{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","System Calculations","Tables","Pics"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":19,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Calculator","index":0,"n_rows":46,"n_cols":56,"rows_kept":46,"cut":false,"hidden":false,"merged":[[12,15,12,18],[16,5,16,9],[12,25,12,27],[14,23,14,27],[33,5,33,12],[12,6,12,9],[35,5,35,12],[3,5,3,55],[40,23,40,24],[40,15,40,16],[40,8,40,9],[12,10,12,11],[12,19,12,20],[12,44,12,46],[5,34,5,38],[6,34,6,40],[14,6,14,9],[14,15,14,18],[14,10,14,11],[5,46,5,53],[6,46,6,53],[12,37,12,39],[8,5,8,55],[5,27,5,28],[5,10,5,18],[6,10,6,18],[6,23,6,28],[11,35,11,49],[12,28,12,29],[40,30,40,32],[40,48,40,50],[12,41,12,42],[18,5,18,55],[37,5,37,55],[38,7,39,10],[38,15,39,16],[38,22,39,25],[38,29,39,33],[16,10,16,11],[33,25,35,28],[14,28,14,29],[14,19,14,20],[40,38,40,39]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stormwater Pipe Retention/Detention System Design Aid"]
[]
[null,null,null,null,null,"PROJECT DESCRIPTION"]
[]
[null,null,null,null,null,null,null,null,null,"Project Name:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:","MM","/","DD","/","YYYY",null,null,null,null,null,"City / State:",null,null,null,null,null,"/",null,null,null,null,null,"Phone #:"]
[null,null,null,null,null,null,null,null,null,"Engineer:",null,null,null,null,null,null,null,null,null,null,null,null,"Contractor:",null,null,null,null,null,null,null,null,null,null,"Designed By:",null,null,null,null,null,null,null,null,null,null,null,"Prinsco Rep:"]
[]
[null,null,null,null,null,"DESIGN CRITERIA"]
[]
[null,null,null,null,null,null,null,"Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One Value Must Be Zero"]
[null,null,null,null,null,null,"Number of Laterals",null,null,null,8,null,null,null,null,"Min. Depth to Invert of Pipe",null,null,null,9,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(ft)\",\"(m)\")","v":"(ft)"},null,null,null,"Stone Porosity",null,null,40,null,"%",null,null,null,null,null,null,372.3,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(ft)\",\"(m)\")","v":"(ft)"},"OR",null,null,0,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(ft)\",\"(m)\")","v":"(ft)"}]
[]
[null,null,null,null,null,null,"Max. Depth to Invert of Pipe",null,null,null,8,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(ft)\",\"(m)\")","v":"(ft)"},null,null,"Additional Stone Below Pipe*",null,null,null,0,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(in)\",\"(mm)\")","v":"(in)"},null,"Additional Stone Side of Pipe*",null,null,null,null,0,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(in)\",\"(mm)\")","v":"(in)"}]
[]
[null,null,null,null,null,"Additional Stone Above Pipe*",null,null,null,null,0,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(in)\",\"(mm)\")","v":"(in)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Minimum recommended values are already included in calculations"]
[null,null,null,null,null,"SYSTEM LAYOUT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Recommended riser diameter:",null,null,null,null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C48,'System Calculations'!E48)","v":"24 in"},null,null,"Warning - Burial depth too shallow",null,null,null,null,null,null,null,null,"Contact Prinsco Sales Representative"]
[]
[null,null,null,null,null,"Recommended cleanout size:",null,null,null,null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C72,'System Calculations'!E72)","v":"6 or 8 in"}]
[]
[null,null,null,null,null,"SYSTEM STORAGE"]
[null,null,null,null,null,null,null,"System Footprint",null,null,null,null,null,null,null,"Stone Storage",null,null,null,null,null,null,"Product Storage",null,null,null,null,null,null,"Total System Storage"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C39,'System Calculations'!E39)","v":18132.30675},null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(sf)\",\"(sq. m)\")","v":"(sf)"},null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C33,'System Calculations'!E33)","v":0},null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(cf)\",\"(cu. m)\")","v":"(cf)"},null,null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C32,'System Calculations'!E32)","v":27848.04},null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(cf)\",\"(cu. m)\")","v":"(cf)"},null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C34,'System Calculations'!E34)","v":27848.04},null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(cf)\",\"(cu. m)\")","v":"(cf)"},null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C40,'System Calculations'!E40)","v":1750.8952820833333},null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(cy)\",\"(cu. m)\")","v":"(cy)"},null,null,null,null,null,null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,'System Calculations'!C64,'System Calculations'!E63)","v":5339.2885218518522},null,null,{"$f":"IF('System Calculations'!C16='System Calculations'!G4,\"(sy)\",\"(sq. m)\")","v":"(sy)"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V 3.0"]

{"sheet":"System Calculations","index":1,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Table for Drop-Down Options (Comboboxes)"]
[null,"Index #","Pipe Diameters (IN)","Number of Headers","Solid or Perforated","Include Volume of the Headers","Units","Pipe Diameters (mm)","Pipe Options for Drop Down"]
[null,1,12,0,"Solid","Yes","Standard",300,{"$f":"IF($C$16=$G$4,C4&\" in\",IF($C$16=$G$5,H4&\" mm\",\"NO UNIT\"))","v":"12 in"}]
[null,2,15,1,"Perforated","No","Metric",375,{"$f":"IF($C$16=$G$4,C5&\" in\",IF($C$16=$G$5,H5&\" mm\",\"NO UNIT\"))","v":"15 in"}]
[null,3,18,2,null,null,null,450,"18 in"]
[null,4,24,null,null,null,null,600,"24 in"]
[null,5,30,null,null,null,null,750,"30 in"]
[null,6,36,null,null,null,null,900,"36 in"]
[null,7,42,null,null,null,null,1050,"42 in"]
[null,8,48,null,null,null,null,1200,"48 in"]
[null,9,60,null,null,null,null,1500,"60 in"]
[]
[]
["Index # output","Inputs","Standard",null,"Metric Conversions",null,"Pipe System Calculations"]
[1,"Units",{"$f":"INDEX(Profile,A16)","v":"Standard"},null,null,null,"IF Statements",null,null,"Header Volume",null,null,"Header Dim."]
[1,"Solid or Perforated System",{"$f":"INDEX(Perforated,A17)","v":"Solid"},null,null,null,"Header Volume",{"$f":"IF($C$21=$C$22,'System Calculations'!K17,'System Calculations'!K18)","v":525.55386933521061},null,"Fab Vol. (SS)",{"$f":"(2*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,13,FALSE))+(('System Calculations'!$C$24-2)*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,10,FALSE))","v":525.55386933521061},"x","Header Width",{"$f":"(((VLOOKUP('System Calculations'!$C$22,Tables!C6:Q14,4,FALSE))*('System Calculations'!$C$24-1))+(VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,3,FALSE)))/12","v":45.314166666666665},null,"Spacing Between pipe",{"$f":"VLOOKUP(C22,Tables!C6:Q14,4,0)-VLOOKUP(C22,Tables!C6:Q14,3,0)","v":23.35}]
[null,"Stone Porosity ",{"$f":"Calculator!AC13","v":40},"%",null,null,"Header Displacement ",{"$f":"IF($C$21=$C$22,'System Calculations'!K19,'System Calculations'!K20)","v":623.97016666666673},null,"Fab Vol. (DS)",{"$f":"K17+((VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,8,FALSE))*(((VLOOKUP('System Calculations'!$C$22,Tables!C6:Q14,4,FALSE)-(2*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,12,FALSE)))/12)*('System Calculations'!$C$24-1)+(((VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,14,FALSE))/12)*'System Calculations'!$C$24)))","v":630.84266100187722},"?","Header Length (SS)",{"$f":"(VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,12,FALSE)+(0.5*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,3,FALSE)))/12","v":4.9349999999999996}]
[1,"Include Volume of the Headers",{"$f":"INDEX(YesNo,A19)","v":"Yes"},null,null,null,"Header Length (ft)",{"$f":"IF($C$21=$C$22,N18,N19)","v":4.9349999999999996},null,"Fab Disp. (SS)",{"$f":"((4*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,12,FALSE)/12)*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,15,FALSE))+(('System Calculations'!$C$24-2)*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,11,FALSE))","v":623.97016666666673},"x","Header Length (DS)",{"$f":"N18+(VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,14,FALSE)/12)","v":6.3433333333333328}]
[1,"Number of Headers (0,1,2)",{"$f":"INDEX(HeaderConfiguration,A20)","v":0},null,null,null,null,null,null,"Fab Disp. (DS)",{"$f":"K19+((VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,15,FALSE))*(((VLOOKUP('System Calculations'!$C$22,Tables!C6:Q14,4,FALSE)-(2*VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,12,FALSE)))/12)*('System Calculations'!$C$24-1)+(((VLOOKUP('System Calculations'!$C$21,Tables!C6:Q14,14,FALSE))/12)*'System Calculations'!$C$24)))","v":751.10497499999997},"?"]
[7,"Header Diameter",{"$f":"INDEX(PipeSizes,A21)","v":42},"(in)",{"$f":"INDEX(H4:H12,A21)","v":1050},"mm"]
[7,"Lateral Diameter",{"$f":"INDEX(PipeSizes,A22)","v":42},"(in)",{"$f":"INDEX(H4:H12,A22)","v":1050},"mm","Storage Volumes",null,null,"Lateral Volume",null,null,"System Dim.",null,null,"Trench Dim."]
[null,"System Length ",{"$f":"IF(AND(C55>0,C56=0),C55,IF(AND(C56>0,C55=0),C57,\"Error\"))","v":372.3},"(ft)",{"$f":"C23/G31","v":113.47703636873484},"m","Product Storage",{"$f":"K23+IF($C$19=\"Yes\",$C$20*H17,0)","v":27848.04},"x","Lateral Vol.",{"$f":"($C$23-($C$20*H19))*$C$24*VLOOKUP($C$22,Tables!C6:Q14,8,FALSE)","v":27848.04},"x","System Length (ft)",{"$f":"$C$23","v":372.3},"x","Trench Length",{"$f":"N23+(2*VLOOKUP($C$22,Tables!C6:Q14,6,FALSE))+(2*C30/12)","v":375.3}]
[null,"Number of laterals",{"$f":"Calculator!K13","v":8},null,null,null,"System Displacement (cf)",{"$f":"K24+$C$20*H18","v":33626.135999999999},"x","Lateral Disp.",{"$f":"($C$23-($C$20*H19))*$C$24*VLOOKUP($C$22,Tables!C6:Q14,15,FALSE)","v":33626.135999999999},"x","System Width (ft)",{"$f":"((VLOOKUP($C$22,Tables!C6:Q14,4,FALSE)*($C$24-1))+VLOOKUP($C$22,Tables!C6:Q14,3,FALSE))/12","v":45.314166666666665},"x","Trench Width",{"$f":"N24+(2*VLOOKUP($C$22,Tables!C6:Q14,6,FALSE))+(2*C30/12)","v":48.314166666666665}]
[null,"Additional Stone Above",{"$f":"IF(C16=G4,Calculator!K17,Calculator!K17/I32)","v":0},"(in)",{"$f":"C25*$I$32","v":0},"mm","Stone Volume (cf)",{"$f":"(Q28*Q25)-H24","v":47274.172616249998},"x",null,null,null,"Lateral Length (ft)",{"$f":"($C$23-($C$20*H19))","v":372.3},"x","Stone Envelope Height (ft)",{"$f":"(VLOOKUP($C$22,Tables!C6:Q14,7,FALSE)+$C$26+VLOOKUP($C$22,Tables!C6:Q14,3,FALSE)+$C$25)/12","v":4.4616666666666669}]
[null,"Additional Stone Below",{"$f":"IF(C16=G4,Calculator!T15,Calculator!T15/I32)","v":0},"(in)",{"$f":"C26*$I$32","v":0},"mm","Stone Volume (cy)",{"$f":"H25/27","v":1750.8952820833333},"x",null,null,null,null,null,null,"Trench Height (ft)",{"$f":"((VLOOKUP($C$22,Tables!C6:Q14,7,FALSE)+$C$26+((VLOOKUP($C$22,Tables!C6:Q14,3,FALSE)-VLOOKUP($C$22,Tables!C6:Q14,2,FALSE))/2))/12)+$C$27","v":9.2554166666666671}]
[null,"Average Depth to Invert",{"$f":"(C28+C29)/2","v":8.5},"(ft)",{"$f":"C27/$G$31","v":2.5907999170944027},"m","Stone Storage",{"$f":"IF($C$17=\"Perforated\",(($C$18/100)*H25),0)","v":0},"x",null,null,null,null,null,null,"Cover Height (ft)",{"$f":"Q26-((VLOOKUP($C$22,Tables!C6:Q14,7,FALSE)+$C$26)/12)-(VLOOKUP($C$22,Tables!C6:Q14,3,FALSE)/12)","v":4.7937500000000011}]
[null,"Max. Depth to Invert of Pipe",{"$f":"IF(C16=G4,Calculator!K15,Calculator!K15*G31)","v":8},"(ft)",{"$f":"C28/$G$31","v":2.4383999219712025},"m","Total System Storage",{"$f":"H27+H23","v":27848.04},"x",null,null,null,null,null,null,"System Footprint  (sf)",{"$f":"Q23*Q24","v":18132.30675}]
[null,"Min. Depth to Invert of Pipe",{"$f":"IF(C16=G4,Calculator!T13,Calculator!T13*G31)","v":9},"(ft)",{"$f":"C29/$G$31","v":2.743199912217603},"m"]
[null,"Additional Stone Side",{"$f":"IF(C16=G4,Calculator!AC15,Calculator!AC15/I32)","v":0},"(in)",{"$f":"C30*$I$32","v":0},"mm","Conversions",null,null,null,null,null,null,"Picture labels"]
[null,"Outputs",null,null,null,null,3.28084,"ft =",1,"m",null,null,null,"System Width",null,{"$f":"IF($C$16=$G$4,ROUND(C35,1)&\" ft\",ROUND(E35,1)&\" m\")","v":"45.3 ft"}]
[null,"Product Storage",{"$f":"H23","v":27848.04},"(cf)",{"$f":"C32/$G$33","v":788.5679334667999},"cu. m",1,"in =",25.4,"mm",null,null,null,"System Length",null,{"$f":"IF($C$16=$G$4,ROUND(C36,1)&\" ft\",ROUND(E36,1)&\" m\")","v":"372.3 ft"}]
[null,"Stone Storage",{"$f":"H27","v":0},"(cf)",{"$f":"C33/$G$33","v":0},"cu. m",35.314700000000002,"cf =",1,"cu. m",null,null,null,"Excavation Width",null,{"$f":"IF($C$16=$G$4,ROUND(C37,1)&\" ft\",ROUND(E37,1)&\" m\")","v":"48.3 ft"}]
[null,"Total System Storage",{"$f":"H28","v":27848.04},"(cf)",{"$f":"C34/$G$33","v":788.5679334667999},"cu. m",10.7639,"sf =",1,"sq. m",null,null,null,"Excavation Length",null,{"$f":"IF($C$16=$G$4,ROUND(C38,1)&\" ft\",ROUND(E38,1)&\" m\")","v":"375.3 ft"}]
[null,"System Width",{"$f":"N24","v":45.314166666666665},"(ft)",{"$f":"C35/$G$31","v":13.811757558023757},"m",1.3079499999999999,"cy =",1,"cu. m",null,null,null,"Cover Height",null,{"$f":"IF($C$16=$G$4,ROUND(C41,1)&\" ft\",ROUND(E41,1)&\" m\")","v":"4.8 ft"}]
[null,"System Length",{"$f":"N23","v":372.3},"(ft)",{"$f":"C36/$G$31","v":113.47703636873484},"m",9,"sf=",1,"sy",null,null,null,"Lateral Length",null,{"$f":"IF($C$16=$G$4,ROUND(C42,1)&\" ft\",ROUND(E42,1)&\" m\")","v":"372.3 ft"}]
[null,"Excavation Width",{"$f":"Q24","v":48.314166666666665},"(ft)",14.726157528762959,"m",null,null,null,null,null,null,null,"Initial Backfill Above Crown",null,{"$f":"IF($C$16=$G$4,ROUND(C43,1)&\" in\",ROUND(E43,1)&\" mm\")","v":"0 in"}]
[null,"Excavation Length",{"$f":"Q23","v":375.3},"(ft)",114.39143633947404,"m",null,null,null,null,null,null,null,"Bedding",null,{"$f":"IF($C$16=$G$4,ROUND(C44,1)&\" in\",ROUND(E44,1)&\" mm\")","v":"6 in"}]
[null,"System Footprint",{"$f":"Q28","v":18132.30675},"(sf)",{"$f":"C39/G34","v":1684.5480494987876},"sq. m",null,null,null,null,null,null,null,"Side Wall Spacing",null,{"$f":"IF($C$16=$G$4,ROUND(C45,1)&\" in\",ROUND(E45,1)&\" mm\")","v":"18 in"}]
[null,"Required Stone",{"$f":"H26","v":1750.8952820833333},"(cy)",{"$f":"C40/G35","v":1338.6561275915237},"cu. m",null,null,null,null,null,null,null,"C-C Spacing",null,{"$f":"IF($C$16=$G$4,ROUND(C46,1)&\" in\",ROUND(E46,1)&\" mm\")","v":"70.9 in"}]
[null,"Cover Height",{"$f":"Q27","v":4.7937500000000011},"(ft)",{"$f":"C41/$G$31","v":1.4611349532436819},"m",null,null,null,null,null,null,null,"Spacing Between Pipe",null,{"$f":"IF($C$16=$G$4,ROUND(C47,1)&\" in\",ROUND(E47,1)&\" mm\")","v":"23.4 in"}]
[null,"Lateral Length",{"$f":"N25","v":372.3},"(ft)",{"$f":"C42/$G$31","v":113.47703636873484},"m"]
[null,"Initial Backfill Above Crown",{"$f":"C25","v":0},"(in)",{"$f":"C43*$I$32","v":0},"mm"]
[null,"Bedding",{"$f":"VLOOKUP(C22,Tables!C6:Q14,7,FALSE)+C26","v":6},"(in)",{"$f":"C44*$I$32","v":152.39999999999998},"mm"]
[null,"Side Wall Spacing",{"$f":"(VLOOKUP(C22,Tables!C6:Q14,6,FALSE)*12)+C30","v":18},"(in)",457.2,"mm"]
[null,"C-C Spacing",{"$f":"VLOOKUP(C22,Tables!C6:Q14,4,FALSE)","v":70.89},"(in)",1800.606,"mm"]
[null,"Spacing Between Pipe",{"$f":"Q17","v":23.35},"(in)",{"$f":"C47*$I$32","v":593.09},"mm"]
[null,"Recommended riser size",{"$f":"IF(C22>=36,\"24 in\",IF(AND(C22=30,C17=\"Solid\"),\"24 in\",IF(C22>=24,\"12 in\",\"Cleanout\")))","v":"24 in"},"(in)",{"$f":"IF(C22>=36,\"600 mm\",IF(AND(C22=30,C17=\"Solid\"),\"600 mm\",IF(C22>=24,\"300 mm\",\"Cleanout\")))","v":"600 mm"}]
[null,"System too Shallow Formula",{"$f":"IF(C22>=48,1.5,IF(C22=42,1.25,1))","v":1.25}]
[]
[null,"Max. Burial Depth ",{"$f":"C28-((VLOOKUP(C22,Tables!C6:Q14,3,FALSE)-((VLOOKUP(C22,Tables!C6:Q14,3,FALSE)-VLOOKUP(C22,Tables!C6:Q14,2,FALSE))/2))/12)","v":4.2937500000000011},"ft",{"$f":"C51/$G$31","v":1.3087349581204817},"m"]
[null,"Min. Burial Depth",{"$f":"C29-((VLOOKUP(C22,Tables!C6:Q14,3,FALSE)-((VLOOKUP(C22,Tables!C6:Q14,3,FALSE)-VLOOKUP(C22,Tables!C6:Q14,2,FALSE))/2))/12)","v":5.2937500000000011},"ft",{"$f":"C52/$G$31","v":1.6135349483668819},"m"]
[]
[null,"Lateral/System Length Calc"]
[null,"System Length - Input",{"$f":"IF(C16=G4,Calculator!$AL$13,Calculator!$AL$13*G31)","v":372.3},"ft",{"$f":"C55/$G$31","v":113.47703636873484},"m"]
[null,"Lateral Length - Input",{"$f":"IF(C16=G4,Calculator!$AS$13,Calculator!$AS$13*G31)","v":0},"ft",{"$f":"C56/$G$31","v":0},"m"]
[null,"LL convert to SL",{"$f":"C56+(H19*C20)","v":0},"ft",0,"m"]
[]
[null,"Perimeter Calculation"]
[null,"WC",{"$f":"(2*Q23*Q25)+(2*Q23*Q24)+(2*Q24*Q25)","v":40044.663913888893},"sf"]
[]
[]
[null,"Geotextile Calculation",{"$f":"1.2*C60","v":48053.596696666667},"sf",{"$f":"C63/G34","v":4464.3295363824145},"sq. m"]
[null,null,{"$f":"C63/G36","v":5339.2885218518522},"sy"]
[]
[null,"Picture Selector"]
[null,{"$f":"IF(AND(C21=C22,C20=2),\"FDMSS\",IF(AND(C21<>C22,C20=2),\"FDMDS\",IF(AND(C21=C22,C20=1),\"FSMSS\",IF(AND(C21<>C22,C20=1),\"FSMDS\",\"FNM\"))))","v":"FNM"}]
[null,{"$f":"IF('System Calculations'!C17=\"Perforated\",\"RET\",\"DET\")","v":"DET"}]
[]
[]
[]
[null,"Recommended cleanout size","6 or 8 in",null,"150 or 200 mm"]

{"sheet":"Tables","index":2,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"UC (UniCor machine) (WC, which all pipe is now)"]
[null,null,"System Size","ID (IN)","OD (IN)","Manifold C/C Spacing (IN)","Column Width (FT)","Edge Dist. (FT)","Bedding (in)","Storage Capacity Non-Perf. (CF/FT)","Tee Width (IN)","Volume of Tee (CF)","Tee Displacement (CF)","90 Stub (Center to End)","Volume of 90 Elbow","Stub Length - Bulkhead (IN)","Displacement - Pipe (CF/FT)"]
[null,1,12,12.14,14.452999999999999,23.5,0.75391666666666668,0.66666666666666663,4,0.80383102196007339,23.5,2.0145428174909452,2.5377151262303745,11.7,1.567470492822143,5.6,1.038609930933001]
[null,2,15,15.03,17.649999999999999,28.7,0.92083333333333339,0.66666666666666663,4,1.2320982775682681,28.7,3.7626299649895607,4.566631621774583,14.4,2.9570358661638432,7.3,1.528046666328966]
[null,3,18,18.28,21.46,35.4,1.1616666666666664,0.75,4,1.8225513447488189,35.4,6.8910251776408264,8.3517862432332457,17.7,5.3765264670090147,8.4,2.2558683878283778]
[null,4,24,24.23,28.145,47.1,1.5795833333333336,0.83333333333333337,4,3.2020950375255679,47.1,16.114268059042264,19.202555235123981,23.6,12.594907147600567,11.1,3.888762950134323]
[null,5,30,29.86,34.674999999999997,55,1.6937500000000003,1.5,4,4.8630305297858847,55,28.312775447560085,34.010309085315811,27.5,22.288889928185302,11.3,5.9665397948383507]
[null,6,36,35.49,40.590000000000003,61.46,{"$f":"(F11-E11)/12","v":1.7391666666666665},1.5,4,6.87,61.46,44.153773486609239,51.93,30.73,35.19,13.5,8.24]
[null,7,42,41.41,47.54,70.89,{"$f":"(F12-E12)/12","v":1.9458333333333335},1.5,6,9.35,70.89,69.178978222535093,81.760000000000005,35.450000000000003,55.24,16.899999999999999,11.29]
[null,8,48,47.33,54.12,76.83,{"$f":"(F13-E13)/12","v":1.8925000000000001},1.5,6,12.22,76.83,96.886281024612444,113.83,38.42,78.25,16.899999999999999,14.67]
[null,9,60,59.93,66.83,94.2,2.28125,1.5,6,19.589165917425525,94.2,189.16183065279245,215.76357890134793,47.1,153.7749524517904,null,22.752107897194353]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["checks 9/13/22",null,null,"matched system calc","matched system calc",null,null,null,null,"matched system calc"]
[]
[]
[]
[null,null,null,"Manifold CC spacing and tee width same.."]

{"sheet":"Pics","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}