{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":82,"n_cols":11,"rows_kept":82,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["     IN GROUND CALCULATIONS (Spreadsheet)",{"$nulls":8},"Updated","2022-03-02"]
[]
["Name of Applicant: _________________________________________"]
[]
["1. SITE CONDITIONS"]
[]
[null,"Evaluate the site and soils report for the following:"]
[null,"    > Surface water movement"]
[null,"    > Measure Elevations and distances on the site so that slope, contours and "]
[null,"           available areas can be determined."]
[null,"    > Description of several soil profiles where the system will be located."]
[null,"    > Determine the limiting conditions such as bedrock, high groundwater level,"]
[null,"           soil permeability, and setbacks."]
[null,"           (Note: shaded boxes to be filled in by designer)"]
[]
[null,"Slope =","          ","%","Seepage beds must be placed on <6% slopes"]
[]
[null,"Occupancy: One or two family dwelling",null,null,null,"# of bedrooms ="]
[]
[null,"Public facility (I.e. non-residential). Daily wastewater flow",{"$nulls":5},"           ","GPD"]
[null,null,"(provide particulars on separate sheet)"]
[]
[null,"Wastewater: Typical residential BOD5",null,null,null,"Y/N = "]
[null,null,"    Or other: BOD5=",null,"            ",null,"            ","mg/L"]
[]
[null,"Suitable area: Cross slope distance =",{"$nulls":4},"Feet"]
[null,null,"      ","        Width =",null,null,"Feet"]
[]
["Soil limiting factor=",null,"                              ",null,"         Depth to limiting factor =",null,null,null,"Inches"]
[]
[null,"In-situ soil application rate used",null,null,"           ","gal/sf/day"]
[]
[]
[]
["2. DESIGN WASTEWATER FLOW (DWF)"]
[]
[null,"One or two-family dwelling:"]
[]
[null,"    DWF = gal/day/bedroom (generally 150) x # of bedrooms"]
[null,"    DWF =   ","            ","gal/day/bedroom x",null,"            ","# of bedrooms"]
[null,"    DWF =",{"$error":"#VALUE!"},"gal/day"]
[]
[null,"Public Facilities"]
[]
[null,"    DWF = Sum of each wastewater flow per source per day x 1.5"]
[null,"    DWF =",null,"gal/day x 1.5"]
[null,"    DWF =",null,"gal/day "]
[]
[]
[]
[]
["3. WIDTH AND LENGTH OF THE DISTRIBUTION CELL"]
[]
[null,"1. Determine the design loading rate (DLR) for the site"]
[]
[null,"        Select the effluent application rate for the most restrictive soil horizon in contact with the "]
[null,"        distribution cell that matches the soil conditions. The effluent application rate selected is"]
[null,"        the design loading rate (DLR) for the site."]
[]
[null,null,"DLR = ",null,"gpd/sf"]
[]
[null,"2. Determine the distribution cell area."]
[]
[null,"        Calculate the distribution cell area by dividing the daily design wastewater flow (DWF)"]
[null,"        by the design loading rate (DLR)."]
[]
[null,"           Distribution cell area = DWF/DLR"]
[null,"           Distribution cell area =",null,null,null,"gpd  divided by ",null,0,"gpd/sf"]
[null,"           Distribution cell area = ",null,null,{"$error":"#DIV/0!"},"sf"]
[]
[null,"3. Select a width (A) for the distribution cell.",null,null,null,"(Usually 3 feet)"]
[]
[null,null,"A =",null,"ft"]
[]
[null,"4. Determine the distribution cell length."]
[]
[null,"        Calculate the distribution cell length (B) by dividing the required distribution area by the "]
[null,"        distribution cell width (A)."]
[]
[null,null,"       B = Distribution cell area divided by A"]
[null,null,"       B = ",{"$error":"#DIV/0!"},"sf    divided by",null,0,"ft"]
[null,null,"       B = ",{"$error":"#DIV/0!"},"ft"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}