{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet2","Sheet1","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":"Sheet2","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet1","index":1,"n_rows":144,"n_cols":10,"rows_kept":144,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"AT-GRADE CALCULATIONS (Spreadsheet)"]
[]
["Name of Applicant:___________________________________"]
["Site Address: ______________________________________"]
[]
["A. SITE CONDITIONS"]
[null,"Evaluate the site and soils report for the following:"]
[null,"    Type and occupancy of facility."]
[null,"    Quality of wastewater to be distributed."]
[null,"    Dimensions and configuration of suitable area."]
[null,"    Treatment and hydraulic limitations of the soil."]
[null,"    Surface water movement."]
[null,"    (Note: shaded boxes to be filled in by designer)"]
[]
[null,"Slope:",null,"%  (25% Maximum per Ordinance 55)"]
[]
[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,"            ","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,"Infiltrative surface (sand) application rate =",{"$nulls":4},"gal/sf/day"]
[]
[null,"Surface soil application rate =",null,null,null,"gal/sf/day"]
[]
[null,"Linear loading rate =",null,null,"gpd/linear foot"]
[]
["B. SITE DISPOSAL CAPABILITY (SDC)"]
[null,"SDC = cross slope distance x linear loading rate"]
[null,"SDC =",0,"ft     x",0,"gpd/lf"]
[null,"SDC = ",0,"gpd"]
[]
["C. DESIGN WASTEWATER FLOW (DWF)"]
[null,"One or two family dwelling"]
[null,"DWF = ",null,"gal/day/bedroom (generally 150) x",null,null,null,"# of bedrooms"]
[null,"DWF = ",0,"gal/day"]
[]
[null,"Public facilities"]
[null,"DWF = Results of attached flow analysis or average flows x 1.5"]
[null,"DWF = ",null,"gal/day"]
[]
["For the site to be suitable, site dispersal capability must be greater that or equal to design wastewater flow."]
[null,"SDC = ",null," gpd  > or < DWF = ",null,null,"gpd"]
[null,"Site is:",null,"suitable","     or",null,"unsuitable"]
[]
["D. EFFECTIVE LENGTH AND WIDTH OF THE DISTRIBUTION CELL"]
[null,"1. Determine the design loading rate (DLR) for the site."]
[null,"    For the quality of wastewater to be distributed, select the infiltrative surface application rate for the "]
[null,"    most restrictive soil horizon within 12 inches of the distribution cell infiltrative surface. The infiltrative"]
[null,"    surface application rate selected is the design loading rate (DLR) for the site."]
[null,null,"      DLR = ",null,"gal/sf/day"]
[]
[null,"2. Determine the distribution cell area."]
[null,"      Calculate the distribution cell area by dividing the daily design wastewater flow (DWF) by the "]
[null,"      design loading rate (DLR)."]
[null,null,"Distribution cell area = DWF + DLR"]
[null,null,"Distribution cell area = ",null,null,"  gpd divided by ",null,0,"gal/day/sf"]
[null,null,"Distribution cell area =",null,{"$error":"#DIV/0!"},"sf"]
[]
[null,"3. Determine the distribution cell length."]
[null,"       Calculate the distribution cell length (A) by dividing the design wastewater flow (DWF) by the "]
[null,"       linear loading rate."]
[null,null,"A = DWF divided by linear loading rate"]
[null,null,"A = ",0,"gpd divided by",null,0,"gpd/lf"]
[null,null,"A = ",{"$error":"#DIV/0!"},"ft"]
[]
[null,"4. Determine the distribution cell width."]
[null,"        Calculate the distribution cell width (B) by dividing the required distribution area by the required"]
[null,"        distribution cell length (A)."]
[null,null,"B = Distribution cell area divided by A"]
[null,null,"B = ",{"$error":"#DIV/0!"}," sf divided by ",null,{"$error":"#DIV/0!"},"ft"]
[null,null,"B = ",{"$error":"#DIV/0!"},"feet"]
[]
["E. DESIGN OF ENTIRE AT - GRADE COMPONENT"]
[null,"1. Determine the total width of distribution cell."]
[null,"         For a level site,  total width of the distribution cell (TW) is equal to or greater than the "]
[null,"         distribution cell width (B)."]
[null,null,"TW > B"]
[null,null,"TW = ",{"$error":"#DIV/0!"},"ft"]
[]
["    OR","         For a sloping site, total width of the distribution cell (TW) is equal to or greater than the  "]
[null,"         distribution cell width (B) + 2 feet."]
[null,null,"TW > B + 2 feet"]
[null,null,"TW >  ",{"$error":"#DIV/0!"},"ft + 2 feet"]
[null,null,"TW = ",{"$error":"#DIV/0!"}]
[]
[null,"2. Determine the overall width (W) of the component."]
[null,"        W > TW +  [2 x slope width (minimum of 5)]",{"$nulls":4},"*Maximum slope per Ordinance is 4:1"]
[null,"        W > ",{"$error":"#DIV/0!"},"ft    + ",2,"       x",5,"(minimum)"]
[null,"        W > ",{"$error":"#DIV/0!"}]
[]
[null,"3. Determine the overall length (L) of the component"]
[null,"        L > A + [2 x end slope width (minimum of 5)]",{"$nulls":4},"*Maximum slope per Ordinance is 4:1"]
[null,"        L > ",{"$error":"#DIV/0!"},"ft     + ",2,"       x",5,"(minimum)"]
[null,"        L > ",{"$error":"#DIV/0!"},"ft "]
[]
[null,"4. Horizontal location of distribution lateral in the distribution cell."]
[null,"   (Check appropriate box)"]
[null,"              ","Level site with one effluent distribution lateral: the lateral is located in the center of the "]
[null,null,"       Distribution cell."]
[null,"              ","Level site with more than one effluent distribution lateral: laterals are equally spaced apart"]
[null,null,"       with the center two laterals the same distance from center of the cell and the "]
[null,null,"       the distance from the outside laterals to the edge of the cell being one half the "]
[null,null,"       distance between laterals."]
[null,"              ","Sloping site with one effluent distribution lateral: the lateral is located 1 foot in from up slope"]
[null,null,"       edge of the distribution cell."]
[null,"              ","Sloping site with more than one effluent distribution lateral: one lateral is located one foot"]
[null,null,"        down slope from the up slope edge of the distribution cell and the others equally "]
[null,null,"        spaced between the upper lateral and midpoint of the distribution cell width."]
[]
[null,"5. Vertical location of distribution lateral in the distribution cell."]
[null,"              Elevation of distribution lateral > elevation of original contour directly under distribution lateral "]
[null,"              + > 6 inches."]
[null,"              Elevation of distribution lateral > ",{"$nulls":4},"ft    +",null,"ft"]
[null,"              Elevation of distribution lateral > ",{"$nulls":4},"ft"]
[]
[null,"6. Determine the height of the component."]
[null,"         Height over the distribution lateral > 14 inches + nominal diameter of lateral"]
[null,"         Height over the distribution lateral > 14 inches +",{"$nulls":5},"inches."]
[null,"         Height over the distribution lateral = ",{"$nulls":4},"inches"]
[]
[null,"         Height over the rest of the distribution cell > 12 inches"]
[null,"         Height over the rest of the distribution cell =",{"$nulls":5},"Inches"]
[]
[null,"7. Determine the location of observation pipes along the length of distribution cell."]
[null,"        Distance from end of distribution cell to end observation pipes = A divided by 6"]
[null,"        Distance from end of distribution cell to end observation pipes = ",{"$nulls":5},{"$error":"#DIV/0!"},"ft divided by",6]
[null,"        Distance from end of distribution cell to end observation pipes = ",{"$nulls":5},{"$error":"#DIV/0!"},"ft "]
[]
["F. PRESSURE DISTRIBUTION NETWORK"]
[null,"Complete the pressure distribution network worksheet or equivalent pressure distribution software "]
[null,"worksheet."]
[]
[]
[]
[2006]

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