{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["soakaway","from author","tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"comments":1,"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":"soakaway","index":0,"n_rows":61,"n_cols":74,"rows_kept":61,"cut":false,"hidden":false,"merged":[[11,29,11,34],[12,29,12,34],[13,29,13,34],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,25,48,26],[47,16,47,17],[47,19,47,20],[47,21,47,22],[1,4,3,15],[49,9,49,10],[51,2,51,26],[48,9,48,10],[48,11,48,12],[48,21,48,22],[48,14,48,15],[48,16,48,17],[48,19,48,20],[48,23,48,24],[55,2,56,3],[55,4,55,7],[56,4,56,7],[57,2,58,3],[57,4,57,7],[58,4,58,7],[53,2,54,3],[53,4,53,7],[54,4,54,7],[47,23,47,24],[47,25,47,26],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,9,47,10],[47,11,47,12],[47,14,47,15],[52,2,52,7],[45,23,45,24],[45,25,45,26],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,9,46,10],[46,11,46,12],[46,14,46,15],[46,16,46,17],[46,19,46,20],[46,21,46,22],[46,23,46,24],[46,25,46,26],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,9,45,10],[45,11,45,12],[45,14,45,15],[45,16,45,17],[45,19,45,20],[45,21,45,22],[43,23,43,24],[43,25,43,26],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,9,44,10],[44,11,44,12],[44,14,44,15],[44,16,44,17],[44,19,44,20],[44,21,44,22],[44,23,44,24],[44,25,44,26],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,9,43,10],[43,11,43,12],[43,14,43,15],[43,16,43,17],[43,19,43,20],[43,21,43,22],[41,23,41,24],[41,25,41,26],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,9,42,10],[42,11,42,12],[42,14,42,15],[42,16,42,17],[42,19,42,20],[42,21,42,22],[42,23,42,24],[42,25,42,26],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,9,41,10],[41,11,41,12],[41,14,41,15],[41,16,41,17],[41,19,41,20],[41,21,41,22],[39,23,39,24],[39,25,39,26],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,9,40,10],[40,11,40,12],[40,14,40,15],[40,16,40,17],[40,19,40,20],[40,21,40,22],[40,23,40,24],[40,25,40,26],[39,2,39,3],[39,4,39,5],[39,6,39,7],[39,9,39,10],[39,11,39,12],[39,14,39,15],[39,16,39,17],[39,19,39,20],[39,21,39,22],[35,2,35,26],[36,2,38,3],[36,4,38,5],[36,6,38,7],[36,8,36,12],[36,13,36,17],[36,18,36,22],[36,23,38,24],[36,25,38,26],[37,8,38,8],[37,9,38,10],[37,11,38,12],[37,13,38,13],[37,14,38,15],[37,16,38,17],[37,18,38,18],[37,19,38,20],[37,21,38,22],[30,2,30,11],[30,12,30,13],[30,15,30,23],[30,24,30,25],[31,2,31,11],[31,12,31,13],[31,15,31,23],[31,24,31,25],[32,2,32,11],[32,12,32,13],[32,15,32,25],[27,2,27,10],[27,15,27,23],[27,24,27,25],[28,2,28,9],[28,10,28,11],[28,12,28,13],[28,15,28,23],[28,24,28,25],[29,2,29,11],[29,12,29,13],[29,15,29,23],[29,24,29,25],[23,2,23,11],[23,12,23,13],[23,15,23,23],[23,24,23,25],[25,2,25,13],[25,15,25,25],[26,2,26,11],[26,12,26,13],[26,15,26,23],[26,24,26,25],[20,2,20,11],[20,12,20,13],[20,15,20,23],[20,24,20,25],[21,2,21,11],[21,12,21,13],[21,15,21,23],[21,24,21,25],[22,2,22,11],[22,12,22,13],[22,15,22,23],[22,24,22,25],[14,15,14,25],[16,2,16,13],[16,15,16,25],[18,2,18,7],[18,8,18,13],[17,15,17,23],[17,24,17,25],[19,2,19,7],[19,8,19,13],[18,15,18,23],[18,24,18,25],[17,2,17,7],[17,8,17,13],[19,15,19,23],[19,24,19,25],[12,12,12,13],[12,15,12,21],[12,22,12,23],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,15,13,21],[13,22,13,23],[13,24,13,25],[8,30,8,32],[4,2,4,3],[4,4,4,15],[4,16,4,18],[4,19,4,21],[4,22,4,23],[4,24,4,27],[9,12,9,13],[9,15,9,21],[9,22,9,23],[5,29,5,33],[7,2,7,13],[7,15,7,25],[7,29,7,32],[8,8,8,13],[8,15,8,21],[8,22,8,23],[9,30,9,32],[9,2,9,7],[9,8,9,9],[9,10,9,11],[50,2,50,26],[14,2,14,13],[0,1,0,13],[0,14,0,27],[1,16,2,21],[2,22,2,23],[2,24,2,27],[3,16,3,18],[3,19,3,21],[3,22,3,23],[3,24,3,27],[10,2,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,15,10,21],[10,22,10,23],[11,8,11,13],[11,15,11,21],[11,22,11,23],[11,24,11,25],[12,2,12,7],[12,8,12,9],[12,10,12,11]]}
[null,"version: 1.3. FREE Lite Version",null,null,null,null,null,null,null,null,null,null,null,null,"© 2012-2019 Damian Janicki"]
[null,null,null,null,"YourSpreadsheets™\nYour Office Address Goes Here\nwww.YourSpreadsheets.co.uk\nTel: 010 1234 567890",null,null,null,null,null,null,null,null,null,null,null,"Test project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"type:",null,"geocellular units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"infilled pit or trench",null,null,"alternative sizes:",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,null,22668,null,null,"Page:",null,"C/01",null,null,null,null,null,null,null,null,null,null,null,null,"perforated concrete ring",null,null,null,{"$f":"IF(AP3=TRUE,1,0)","v":1}]
[null,null,"Section: ",null,"Something Somewhere",null,null,null,null,null,null,null,null,null,null,null,"Prepared By:",null,null,"DJ",null,null,"Date:",null,{"$f":"TODAY()","v":"2019-06-22"},null,null,null,null,null,null,null,null,null,null,"selected:",null,{"$f":"MATCH(I19,AL2:AL4)","v":1}]
[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,"Display Alternative Soakaway Sizes  ",null,null,null,null,null,null,null,null,null,null,"base infiltration:",{"$f":"IF(baseinfiltr>1,$M$27,0)","v":0.3}]
[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,"sub-type:",null,"circular pit around ring",null,null,"infiltration rate:",{"$f":"IF(infiltr=1,$M$33,$M$29)","v":4.4297483607016737E-5}]
[null,null,"ALTERNATIVE SOAKAWAY SIZES",null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY OF CALCULATIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY:",null,null,null,null,null,null,null,"square pit around ring"]
[null,null,null,null,null,null,null,null,"trench soakaways",null,null,null,null,null,null,"critical design rainfall duration 'tcrit' =",null,null,null,null,null,null,{"$f":"INDEX(C40:D49,MATCH(W10,AN39:AN48,0),1)","v":120},null,"min",null,null,null,null,{"$f":"W12","v":0.79005293785600539}," storage volume",null,null,null,null,"selected:",null,{"$f":"MATCH(I20,AL7:AL8)","v":2},null,null,null,null,null,null,null,null,null,null,null,"ring alternative (square pit):"]
[null,null,"width of trench [mm]:",null,null,null,null,null,450,null,600,null,900,null,null,"required storage volume 'Vreq' =",null,null,null,null,null,null,{"$f":"MAX(Z40:AA49)","v":10.073174957664069},null,"m3",null,null,null,null,{"$f":"W14","v":0.13487157618252141}," 50% discharge time",null,null,null,null,null,null,null,null,null,null,null,"trench alternative:",null,null,null,null,null,null,null,{"$f":"I13","v":1050},null,null,null,null,null,null,null,{"$f":"K13","v":1350},null,null,null,null,null,null,null,{"$f":"M13","v":1500}]
[null,null,"required trench length [m]:",null,null,null,null,null,{"$f":"AR23","v":16.526359972866761},null,{"$f":"AS23","v":13.311748650762684},null,{"$f":"AT23","v":9.5625370744799696},null,null,"provided storage volume 'Vprov' =",null,null,null,null,null,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(Dint/2000)^2*1.25+(PI()*(L/2)^2*1.25-PI()*((Dint+100)/2000)^2*1.25)*_vol1/100),IF(AND(type=3,subtype=2),W*(PI()*(Dint/2000)^2*1.25+(1.25*L^2-PI()*((Dint+100)/2000)^2*1.25)*_vol1/100),1.25*L*W*_vol1/100))","v":12.75},null,"m3",null,null,null,null,null,null,null,null,null,null,"site:",null,"England and Wales",null,null,null,null,null,{"$f":"I10/1000","v":0.45},{"$f":"K10/1000","v":0.6},{"$f":"M10/1000","v":0.9},null,null,null,null,"A","B","C",null,"X1","X2","final value",null,"A","B","C",null,"X1","X2","final value",null,"A","B","C",null,"X1","X2","final value"]
[null,null,null,null,null,null,null,null,"ring soakaways",null,null,null,null,null,null,"utilisation factor =",null,null,null,null,null,null,{"$f":"W10/W11","v":0.79005293785600539},null,{"$f":"IF(W11>=W10,\".OK\",\".NOT OK\")","v":".OK"},null,null,null,null,{"$f":"IF(OR($AD$13<>\"\",$AD$14<>\"\"),\"REVIEW THESE VALUES:\",\"\")","v":""},null,null,null,null,null,null,null,"Scotland and N Ireland",null,null,null,5,{"$f":"(MAX(L40,Q40,V40))","v":4.1304276000000009},{"$f":"(AQ12-((0.5*$AR$11*1.25*2)*(inf*C40*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C40*60))+(1.25*$AR$11*_vol1/100))","v":8.3035211984605759},{"$f":"(AQ12-((0.5*$AS$11*1.25*2)*(inf*C40*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C40*60))+(1.25*$AS$11*_vol1/100))","v":6.2763715807915608},{"$f":"(AQ12-((0.5*$AT$11*1.25*2)*(inf*C40*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C40*60))+(1.25*$AT$11*_vol1/100))","v":4.2147356892813361},null,null,5,{"$f":"(MAX(L40,Q40,V40))","v":4.1304276000000009},{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C40*60)","v":-3.1994603205738947},{"$f":"-(0.5*1.25*4*W*inf*$C40*60)","v":-9.9669338115787653E-2},{"$f":"$AX12+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":4.1941184823130122},{"$f":"IF(AZ12^2-4*AY12*BA12<0,1,0)","v":0},{"$f":"IF(BB12=1,0,(-AZ12+(AZ12^2-4*AY12*BA12)^0.5)/(2*AY12))","v":-1.1606199411161127},{"$f":"IF(BB12=1,0,(-AZ12-(AZ12^2-4*AY12*BA12)^0.5)/(2*AY12))","v":1.1294680191888831},{"$f":"MAX(BC12:BD21)","v":1.7036125024438808},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C40*60)","v":-3.1994603205738947},{"$f":"-(0.5*1.25*4*W*inf*$C40*60)","v":-9.9669338115787653E-2},{"$f":"$AX12+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":4.0262396248868075},{"$f":"IF(BH12^2-4*BG12*BI12<0,1,0)","v":0},{"$f":"IF(BJ12=1,0,(-BH12+(BH12^2-4*BG12*BI12)^0.5)/(2*BG12))","v":-1.1374737835456741},{"$f":"IF(BJ12=1,0,(-BH12-(BH12^2-4*BG12*BI12)^0.5)/(2*BG12))","v":1.1063218616184445},{"$f":"MAX(BK12:BL21)","v":1.6901831029130121},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C40*60)","v":-3.1994603205738947},{"$f":"-(0.5*1.25*4*W*inf*$C40*60)","v":-9.9669338115787653E-2},{"$f":"$AX12+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":3.9124796096572103},{"$f":"IF(BP12^2-4*BO12*BQ12<0,1,0)","v":0},{"$f":"IF(BR12=1,0,(-BP12+(BP12^2-4*BO12*BQ12)^0.5)/(2*BO12))","v":-1.1215138991147025},{"$f":"IF(BR12=1,0,(-BP12-(BP12^2-4*BO12*BQ12)^0.5)/(2*BO12))","v":1.0903619771874726},{"$f":"MAX(BS12:BT21)","v":1.6810278212048844}]
[null,null,"diameter of ring [mm]:",null,null,null,null,null,{"$f":"IF(ring=1,AL31,IF(OR(ring=10,ring=9,ring=8),AL36,INDEX(AL30:AL39,ring-1)))","v":1050},null,{"$f":"IF(ring=1,AL32,IF(OR(ring=10,ring=9),AL37,INDEX(AL30:AL39,ring+1)))","v":1350},null,{"$f":"IF(ring=1,AL33,IF(ring=10,AL38,IF(ring=9,AL39,INDEX(AL30:AL39,ring+2))))","v":1500},null,null,"required time to discharge 50% 't50' =",null,null,null,null,null,null,{"$f":"W11*0.5*IF(type=3,1/W,1)/(IF(AND(type=3,subtype=1),(PI()*(L/2)^2*binf+0.5*(2*PI()*(L/2)*1.25))*(inf*60*60),IF(AND(type=3,subtype=2),((L^2)*binf+0.5*(4*L*1.25))*(inf*60*60),(L*W*binf+0.5*(L*1.25*2+W*1.25*2))*(inf*60*60))))","v":3.236917828380514},null,"hours",null,null,null,null,{"$f":"IF(OR(AND(type<>1,$Y$24>40),AND(type=1,$Y$24<70)),\"'free volume in infill aggregate' in the 'Soakaway Data'\",\nIF(OR(AND(type<>1,$M$27<>\"No\"),AND(type=1,NOT(AND($M$27>=20%,$M$27<=40%)))),\"'allowance for infiltration through soakaway base'\",\"\"))","v":""},null,null,null,null,null,"selected:",null,{"$f":"MATCH(I18,AL11:AL12)","v":1},null,null,null,10,{"$f":"(MAX(L41,Q41,V41))","v":5.8896396000000024},{"$f":"(AQ13-((0.5*$AR$11*1.25*2)*(inf*C41*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C41*60))+(1.25*$AR$11*_vol1/100))","v":11.408576631442463},{"$f":"(AQ13-((0.5*$AS$11*1.25*2)*(inf*C41*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C41*60))+(1.25*$AS$11*_vol1/100))","v":8.6893305899339914},{"$f":"(AQ13-((0.5*$AT$11*1.25*2)*(inf*C41*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C41*60))+(1.25*$AT$11*_vol1/100))","v":5.8794390051510153},null,null,10,5.8896396000000024,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C41*60)","v":-3.211420641147789},{"$f":"-(0.5*1.25*4*W*inf*$C41*60)","v":-0.19933867623157531},{"$f":"$AX13+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":5.9533304823130138},{"$f":"IF(AZ13^2-4*AY13*BA13<0,1,0)","v":0},{"$f":"IF(BB13=1,0,(-AZ13+(AZ13^2-4*AY13*BA13)^0.5)/(2*AY13))","v":-1.3929326989568986},{"$f":"IF(BB13=1,0,(-AZ13-(AZ13^2-4*AY13*BA13)^0.5)/(2*AY13))","v":1.3308608938257187},{"$f":"(PI()*(AY10/2000)^2*1.25+(1.25*BE12^2-PI()*((AY10+100)/2000)^2*1.25)*_vol1/100)*0.5/(((BE12^2)*binf+0.5*(4*BE12*1.25))*(inf*60*60))","v":1.8718241209155086},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C41*60)","v":-3.211420641147789},{"$f":"-(0.5*1.25*4*W*inf*$C41*60)","v":-0.19933867623157531},{"$f":"$AX13+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":5.7854516248868091},{"$f":"IF(BH13^2-4*BG13*BI13<0,1,0)","v":0},{"$f":"IF(BJ13=1,0,(-BH13+(BH13^2-4*BG13*BI13)^0.5)/(2*BG13))","v":-1.3736033347654997},{"$f":"IF(BJ13=1,0,(-BH13-(BH13^2-4*BG13*BI13)^0.5)/(2*BG13))","v":1.3115315296343197},{"$f":"(PI()*(BG10/2000)^2*1.25+(1.25*BM12^2-PI()*((BG10+100)/2000)^2*1.25)*_vol1/100)*0.5/(((BM12^2)*binf+0.5*(4*BM12*1.25))*(inf*60*60))","v":1.8938725125064102},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C41*60)","v":-3.211420641147789},{"$f":"-(0.5*1.25*4*W*inf*$C41*60)","v":-0.19933867623157531},{"$f":"$AX13+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":5.6716916096572119},{"$f":"IF(BP13^2-4*BO13*BQ13<0,1,0)","v":0},{"$f":"IF(BR13=1,0,(-BP13+(BP13^2-4*BO13*BQ13)^0.5)/(2*BO13))","v":-1.360345396341327},{"$f":"IF(BR13=1,0,(-BP13-(BP13^2-4*BO13*BQ13)^0.5)/(2*BO13))","v":1.2982735912101471},{"$f":"(PI()*(BO10/2000)^2*1.25+(1.25*BU12^2-PI()*((BO10+100)/2000)^2*1.25)*_vol1/100)*0.5/(((PI()*(BU12/2)^2)*binf+0.5*(2*PI()*(BU12/2)*1.25))*(inf*60*60))","v":2.4307550497506161}]
[null,null,null,null,null,null,{"$f":"IF(AND(type=3,subtype=2),\"required pit side length\",\"required pit diameter\")","v":"required pit diameter"},"[m]:",{"$f":"IF(ISERROR(IF(AND(type=3,subtype=2),BE21,BE35)),\"N/A\",IF(AND(type=3,subtype=2),BE21,BE35))","v":1.9528440429670291},null,{"$f":"IF(ISERROR(IF(AND(type=3,subtype=2),BM21,BM35)),\"N/A\",IF(AND(type=3,subtype=2),BM21,BM35))","v":1.9394140772045456},null,{"$f":"IF(ISERROR(IF(AND(type=3,subtype=2),BU21,BU35)),\"N/A\",IF(AND(type=3,subtype=2),BU21,BU35))","v":1.9302684348569872},null,null,"utilisation factor =",null,null,null,null,null,null,{"$f":"W13/24","v":0.13487157618252141},null,{"$f":"IF(W13<=24,\".OK\",\".NOT OK\")","v":".OK"},null,null,null,null,{"$f":"IF(AND(\nOR(AND(type<>1,$Y$24>40),AND(type=1,$Y$24<70)),\nOR(AND(type<>1,$M$27<>\"No\"),AND(type=1,NOT(AND($M$27>=20%,$M$27<=40%))))\n),\"'allowance for infiltration through soakaway base'\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,15,7.23996,{"$f":"(AQ14-((0.5*$AR$11*1.25*2)*(inf*C42*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C42*60))+(1.25*$AR$11*_vol1/100))","v":13.532661829095417},{"$f":"(AQ14-((0.5*$AS$11*1.25*2)*(inf*C42*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C42*60))+(1.25*$AS$11*_vol1/100))","v":10.381492355653041},{"$f":"(AQ14-((0.5*$AT$11*1.25*2)*(inf*C42*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C42*60))+(1.25*$AT$11*_vol1/100))","v":7.0758874700635737},null,null,15,7.23996,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C42*60)","v":-3.2233809617216838},{"$f":"-(0.5*1.25*4*W*inf*$C42*60)","v":-0.29900801434736296},{"$f":"$AX14+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":7.3036508823130113},0,-1.5523647374888585,1.4596025049454062,{"$f":"BE13/24","v":7.799267170481286E-2},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C42*60)","v":-3.2233809617216838},{"$f":"-(0.5*1.25*4*W*inf*$C42*60)","v":-0.29900801434736296},{"$f":"$AX14+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":7.1357720248868066},0,-1.5349727531269619,1.4422105205835098,{"$f":"BM13/24","v":7.8911354687767096E-2},null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C42*60)","v":-3.2233809617216838},{"$f":"-(0.5*1.25*4*W*inf*$C42*60)","v":-0.29900801434736296},{"$f":"$AX14+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":7.0220120096572094},0,-1.5230709687348392,1.4303087361913871,{"$f":"BU13/24","v":0.10128146040627567}]
[null,null," * Based on effective depth and number of pits as in Soakaway Data table",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W12=0,\"SOAKAWAY IS NOT REQUIRED\",IF(AND(W>1,AD10>1),\"* Discharge time is assessed per soakaway rather than a group\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"climate change:",null,"No","infiltration through base:","No",null,30,9.3387995999999998,{"$f":"(AQ15-((0.5*$AR$11*1.25*2)*(inf*C43*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C43*60))+(1.25*$AR$11*_vol1/100))","v":15.791032494124622},{"$f":"(AQ15-((0.5*$AS$11*1.25*2)*(inf*C43*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C43*60))+(1.25*$AS$11*_vol1/100))","v":12.34694582413932},{"$f":"(AQ15-((0.5*$AT$11*1.25*2)*(inf*C43*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C43*60))+(1.25*$AT$11*_vol1/100))","v":8.5842638568923029},null,null,30,9.3387995999999998,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C43*60)","v":-3.2592619234433671},{"$f":"-(0.5*1.25*4*W*inf*$C43*60)","v":-0.59801602869472592},{"$f":"$AX15+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":9.4024904823130111},0,-1.7927022459272612,1.6092202052869282,null,null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C43*60)","v":-3.2592619234433671},{"$f":"-(0.5*1.25*4*W*inf*$C43*60)","v":-0.59801602869472592},{"$f":"$AX15+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":9.2346116248868064},0,-1.7774933293268733,1.5940112886865403,null,null,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C43*60)","v":-3.2592619234433671},{"$f":"-(0.5*1.25*4*W*inf*$C43*60)","v":-0.59801602869472592},{"$f":"$AX15+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":9.1208516096572083},0,-1.767108811229376,1.583626770589043]
[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,0.05,null,0.1,null,60,11.641500000000001,{"$f":"(AQ16-((0.5*$AR$11*1.25*2)*(inf*C44*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C44*60))+(1.25*$AR$11*_vol1/100))","v":16.526359972866761},{"$f":"(AQ16-((0.5*$AS$11*1.25*2)*(inf*C44*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C44*60))+(1.25*$AS$11*_vol1/100))","v":13.311748650762684},{"$f":"(AQ16-((0.5*$AT$11*1.25*2)*(inf*C44*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C44*60))+(1.25*$AT$11*_vol1/100))","v":9.5625370744799696},null,null,60,11.641500000000001,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C44*60)","v":-3.3310238468867341},{"$f":"-(0.5*1.25*4*W*inf*$C44*60)","v":-1.1960320573894518},{"$f":"$AX16+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":11.705190882313012},0,-2.0626708918058472,1.7036125024438808,{"$f":"0.5*1.25*_vol1/100-24*binf*inf*60*60","v":-0.61694077509387379},"A",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C44*60)","v":-3.3310238468867341},{"$f":"-(0.5*1.25*4*W*inf*$C44*60)","v":-1.1960320573894518},{"$f":"$AX16+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":11.537312024886807},0,-2.0492414922749784,1.6901831029130121,{"$f":"0.5*1.25*_vol1/100-24*binf*inf*60*60","v":-0.61694077509387379},"A",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C44*60)","v":-3.3310238468867341},{"$f":"-(0.5*1.25*4*W*inf*$C44*60)","v":-1.1960320573894518},{"$f":"$AX16+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":11.423552009657211},0,-2.0400862105668507,1.6810278212048844,{"$f":"0.5*1.25*_vol1/100-24*binf*inf*60*60","v":-0.61694077509387379},"A"]
[null,null,"GENERAL DATA",null,null,null,null,null,null,null,null,null,null,null,null,"SOAKAWAY DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,0.2,null,120,14.012107199999997,{"$f":"(AQ17-((0.5*$AR$11*1.25*2)*(inf*C45*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C45*60))+(1.25*$AR$11*_vol1/100))","v":15.037842510956224},{"$f":"(AQ17-((0.5*$AS$11*1.25*2)*(inf*C45*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C45*60))+(1.25*$AS$11*_vol1/100))","v":12.594244590097709},{"$f":"(AQ17-((0.5*$AT$11*1.25*2)*(inf*C45*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C45*60))+(1.25*$AT$11*_vol1/100))","v":9.4746029598783164},null,null,120,14.012107199999997,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C45*60)","v":-3.4745476937734683},{"$f":"-(0.5*1.25*4*W*inf*$C45*60)","v":-2.3920641147789037},{"$f":"$AX17+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":14.075798082313009},0,-2.3861886611194221,1.6977352779450938,{"$f":"-24*0.5*4*1.25*inf*60*60","v":-9.5682564591156147},"B",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C45*60)","v":-3.4745476937734683},{"$f":"-(0.5*1.25*4*W*inf*$C45*60)","v":-2.3920641147789037},{"$f":"$AX17+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":13.907919224886804},0,-2.3743232246455905,1.6858698414712627,{"$f":"-24*0.5*4*1.25*inf*60*60","v":-9.5682564591156147},"B",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C45*60)","v":-3.4745476937734683},{"$f":"-(0.5*1.25*4*W*inf*$C45*60)","v":-2.3920641147789037},{"$f":"$AX17+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":13.794159209657206},0,-2.3662432535719318,1.6777898703976035,{"$f":"-24*0.5*4*1.25*inf*60*60","v":-9.5682564591156147},"B"]
[null,null,"site location:",null,null,null,null,null,"England and Wales",null,null,null,null,null,null,{"$f":"IF(type=3,\"number of ring soakaways:\",\"soakaway width 'W' [m] =\")","v":"soakaway width 'W' [m] ="},null,null,null,null,null,null,null,null,3,null,null,null,null,{"$f":"IF(AND(type=3,INT(W)<>W),\"<- change the decimal number to integer\",\"\")","v":""},null,null,null,null,null,null,null,0.15,null,0.3,null,240,16.365585599999996,{"$f":"(AQ18-((0.5*$AR$11*1.25*2)*(inf*C46*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C46*60))+(1.25*$AR$11*_vol1/100))","v":11.75590949230863},{"$f":"(AQ18-((0.5*$AS$11*1.25*2)*(inf*C46*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C46*60))+(1.25*$AS$11*_vol1/100))","v":10.251946543274203},{"$f":"(AQ18-((0.5*$AT$11*1.25*2)*(inf*C46*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C46*60))+(1.25*$AT$11*_vol1/100))","v":8.1252963033655039},null,null,240,16.365585599999996,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C46*60)","v":-3.761595387546937},{"$f":"-(0.5*1.25*4*W*inf*$C46*60)","v":-4.7841282295578074},{"$f":"$AX18+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":16.429276482313007},0,-2.8204142275312547,1.5485793445462193,{"$f":"0.5*PI()*(AY10/2000)^2*1.25-0.5*PI()*((AY10+100)/2000)^2*1.25*_vol1/100","v":-1.0615147052168483E-2},"C",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C46*60)","v":-3.761595387546937},{"$f":"-(0.5*1.25*4*W*inf*$C46*60)","v":-4.7841282295578074},{"$f":"$AX18+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":16.261397624886804},0,-2.8101751337937921,1.5383402508087562,{"$f":"0.5*PI()*(BG10/2000)^2*1.25-0.5*PI()*((BG10+100)/2000)^2*1.25*_vol1/100","v":1.7364662518865481E-2},"C",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C46*60)","v":-3.761595387546937},{"$f":"-(0.5*1.25*4*W*inf*$C46*60)","v":-4.7841282295578074},{"$f":"$AX18+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":16.147637609657206},0,-2.8032093049428739,1.5313744219578382,{"$f":"0.5*PI()*(BO10/2000)^2*1.25-0.5*PI()*((BO10+100)/2000)^2*1.25*_vol1/100","v":3.6324665057131833E-2},"C"]
[null,null,"soakaway type:",null,null,null,null,null,"geocellular units",null,null,null,null,null,null,{"$f":"IF(AND(type=3,subtype=2),\"square pit side length 'L' [m] =\",IF(AND(type=3,subtype=1),\"circular pit diameter 'D' [m] =\",\"soakaway length 'L' [m] =\"))","v":"soakaway length 'L' [m] ="},null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,0.4,null,360,17.838369899999993,{"$f":"(AQ19-((0.5*$AR$11*1.25*2)*(inf*C47*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C47*60))+(1.25*$AR$11*_vol1/100))","v":9.5934574794679772},{"$f":"(AQ19-((0.5*$AS$11*1.25*2)*(inf*C47*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C47*60))+(1.25*$AS$11*_vol1/100))","v":8.5357893842741142},{"$f":"(AQ19-((0.5*$AT$11*1.25*2)*(inf*C47*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C47*60))+(1.25*$AT$11*_vol1/100))","v":6.9533590562617293},null,null,360,17.838369899999993,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C47*60)","v":-4.0486430813204048},{"$f":"-(0.5*1.25*4*W*inf*$C47*60)","v":-7.1761923443367115},{"$f":"$AX19+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":17.902060782313004},0,-3.1681704454226249,1.3956772420957699,{"$f":"(-BE17+(BE17^2-4*BE16*BE18)^0.5)/(2*BE16)","v":-15.508088222316871},"X1",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C47*60)","v":-4.0486430813204048},{"$f":"-(0.5*1.25*4*W*inf*$C47*60)","v":-7.1761923443367115},{"$f":"$AX19+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":17.734181924886798},0,-3.1590666487250014,1.3865734453981466,{"$f":"(-BM17+(BM17^2-4*BM16*BM18)^0.5)/(2*BM16)","v":-15.511012322194942},"X1",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C47*60)","v":-4.0486430813204048},{"$f":"-(0.5*1.25*4*W*inf*$C47*60)","v":-7.1761923443367115},{"$f":"$AX19+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":17.620421909657203},0,-3.1528768449039646,1.3803836415771098,{"$f":"(-BU17+(BU17^2-4*BU16*BU18)^0.5)/(2*BU16)","v":-15.51299315818199},"X1"]
[null,null,"pit shape:",null,null,null,null,null,"square pit around ring",null,null,null,null,null,null,"soakaway ring internal diameter 'Dint' [mm] =",null,null,null,null,null,null,null,null,1200,null,null,null,null,null,null,null,null,null,null,null,null,0.25,null,0.5,null,600,19.738555199999993,{"$f":"(AQ20-((0.5*$AR$11*1.25*2)*(inf*C48*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C48*60))+(1.25*$AR$11*_vol1/100))","v":7.0126352760207782},{"$f":"(AQ20-((0.5*$AS$11*1.25*2)*(inf*C48*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C48*60))+(1.25*$AS$11*_vol1/100))","v":6.3546743155643961},{"$f":"(AQ20-((0.5*$AT$11*1.25*2)*(inf*C48*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C48*60))+(1.25*$AT$11*_vol1/100))","v":5.3086986083423797},null,null,600,19.738555199999993,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C48*60)","v":-4.6227384688673423},{"$f":"-(0.5*1.25*4*W*inf*$C48*60)","v":-11.960320573894519},{"$f":"$AX20+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":19.802246082313005},0,-3.7343708819457215,1.1470904951266463,{"$f":"(-BE17-(BE17^2-4*BE16*BE18)^0.5)/(2*BE16)","v":-1.1094922606857639E-3},"X2",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C48*60)","v":-4.6227384688673423},{"$f":"-(0.5*1.25*4*W*inf*$C48*60)","v":-11.960320573894519},{"$f":"$AX20+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":19.634367224886802},0,-3.7269199563825954,1.1396395695635202,{"$f":"(-BM17-(BM17^2-4*BM16*BM18)^0.5)/(2*BM16)","v":1.8146076173826684E-3},"X2",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C48*60)","v":-4.6227384688673423},{"$f":"-(0.5*1.25*4*W*inf*$C48*60)","v":-11.960320573894519},{"$f":"$AX20+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":19.520607209657204},0,-3.7218579784618031,1.1345775916427274,{"$f":"(-BU17-(BU17^2-4*BU16*BU18)^0.5)/(2*BU16)","v":3.7954436044340682E-3},"X2"]
[null,null,"impermeable area drained to soakaway 'A' [m2] =",null,null,null,null,null,null,null,null,null,300,null,null,"total depth from ground level 'Db' [m] =",null,null,null,null,null,null,null,null,1.75,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,0.6,null,1440,23.351983199999999,{"$f":"(AQ21-((0.5*$AR$11*1.25*2)*(inf*C49*60)))/((($AR$11*binf+0.5*1.25*2)*(inf*C49*60))+(1.25*$AR$11*_vol1/100))","v":3.6683420969288987},{"$f":"(AQ21-((0.5*$AS$11*1.25*2)*(inf*C49*60)))/((($AS$11*binf+0.5*1.25*2)*(inf*C49*60))+(1.25*$AS$11*_vol1/100))","v":3.3518309724466588},{"$f":"(AQ21-((0.5*$AT$11*1.25*2)*(inf*C49*60)))/((($AT$11*binf+0.5*1.25*2)*(inf*C49*60))+(1.25*$AT$11*_vol1/100))","v":2.8117760469839492},null,null,1440,23.351983199999999,{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C49*60)","v":-6.6320723252816212},{"$f":"-(0.5*1.25*4*W*inf*$C49*60)","v":-28.704769377346846},{"$f":"$AX21+(W*PI()*(($AY$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($AY$10/2000)^2*1.25)","v":23.415674082313011},0,-5.0300858977528469,0.70191093682493777,{"$f":"IF(BE14<=1,BE12,IF(BE12>MAX(BE19,BE20),\"N/A\",MAX(BE19,BE20)))","v":1.7036125024438808},"final",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C49*60)","v":-6.6320723252816212},{"$f":"-(0.5*1.25*4*W*inf*$C49*60)","v":-28.704769377346846},{"$f":"$AX21+(W*PI()*(($BG$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BG$10/2000)^2*1.25)","v":23.247795224886808},0,-5.0256663707545437,0.69749140982663549,{"$f":"IF(BM14<=1,BM12,IF(BM12>MAX(BM19,BM20),\"N/A\",MAX(BM19,BM20)))","v":1.6901831029130121},"final",{"$f":"-(W*1.25*_vol1/100+W*binf*inf*$C49*60)","v":-6.6320723252816212},{"$f":"-(0.5*1.25*4*W*inf*$C49*60)","v":-28.704769377346846},{"$f":"$AX21+(W*PI()*(($BO$10+100)/2000)^2*1.25*_vol1/100-W*PI()*($BO$10/2000)^2*1.25)","v":23.13403520965721},0,-5.0226676758581803,0.69449271493027143,{"$f":"IF(BU14<=1,BU12,IF(BU12>MAX(BU19,BU20),\"N/A\",MAX(BU19,BU20)))","v":1.6810278212048844},"final"]
[null,null,"60 min rainfall depth of 5 year return period 'R' [mm] =",null,null,null,null,null,null,null,null,null,15,null,null,"depth to drain invert level 'Dd' [m] =",null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,0.35,null,0.7,null,null,"based on emptying time",{"$f":"AR11*24*0.5*1.25*2*inf*60*60/(AR11*1.25*_vol1/100*0.5-AR11*24*binf*(inf*60*60)-24*0.5*1.25*2*inf*60*60)","v":-0.42531872020530248},{"$f":"AS11*24*0.5*1.25*2*inf*60*60/(AS11*1.25*_vol1/100*0.5-AS11*24*binf*(inf*60*60)-24*0.5*1.25*2*inf*60*60)","v":-0.55690995987366576},{"$f":"AT11*24*0.5*1.25*2*inf*60*60/(AT11*1.25*_vol1/100*0.5-AT11*24*binf*(inf*60*60)-24*0.5*1.25*2*inf*60*60)","v":-0.80640814053237952}]
[null,null,"M5-60 to M5-2d rainfall ratio 'r' =",null,null,null,null,null,null,null,null,null,0.5,null,null,"soakaway effective depth 'Deff' [m] =",null,null,null,null,null,null,null,null,1.25,null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,0.8,null,null,"final length",{"$f":"IF(AR22<=0,MAX(AR12:AR21),IF(AR22<MAX(AR12:AR21),\"N/A\",MAX(AR12:AR21)))","v":16.526359972866761},{"$f":"IF(AS22<=0,MAX(AS12:AS21),IF(AS22<MAX(AS12:AS21),\"N/A\",MAX(AS12:AS21)))","v":13.311748650762684},{"$f":"IF(AT22<=0,MAX(AT12:AT21),IF(AT22<MAX(AT12:AT21),\"N/A\",MAX(AT12:AT21)))","v":9.5625370744799696},null,null,null,"ring alternative (circular pit):"]
[null,null,"allowance for climate change:",null,null,null,null,null,null,null,null,null,0.3,null,null,"free volume in infill aggregate [%] =",null,null,null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,null,null,"selected cliamte change:",null,{"$f":"IF($M$24=\"No\",1,IF($M$24>0%,2,\"N/A\"))","v":2},null,0.9,null,null,null,null,null,null,null,null,null,null,{"$f":"I13","v":1050},null,null,null,null,null,null,null,{"$f":"K13","v":1350},null,null,null,null,null,null,null,{"$f":"M13","v":1500}]
[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,1,null,null,null,null,null,null,null,null,null,null,"A","B","C",null,"X1","X2","final value",null,"A","B","C",null,"X1","X2","final value",null,"A","B","C",null,"X1","X2","final value"]
[null,null,"SOIL INFILTRATION DATA",null,null,null,null,null,null,null,null,null,null,null,null,"SOAKAGE TRIAL PIT DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected base infiltration:",{"$f":"IF($M$27=\"No\",1,IF($M$27>0%,2,\"N/A\"))","v":2},null,null,null,null,null,null,null,null,5,{"$f":"(MAX(L40,Q40,V40))","v":4.1304276000000009},{"$f":"-(PI()*binf*(W*inf*$C40*60)+PI()*1.25*W*_vol1/100)","v":-10.051401038566992},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C40*60)","v":-0.15656023020635781},{"$f":"$AX26-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":4.1941184823130113},{"$f":"IF(AZ26^2-4*AY26*BA26<0,1,0)","v":0},{"$f":"IF(BB26=1,0,(-AZ26+(AZ26^2-4*AY26*BA26)^0.5)/(2*AY26))","v":-0.65379703992815841},{"$f":"IF(BB26=1,0,(-AZ26-(AZ26^2-4*AY26*BA26)^0.5)/(2*AY26))","v":0.6382210789645435},{"$f":"2*MAX(BC26:BD35)","v":1.9528440429670291},null,{"$f":"-(PI()*binf*(W*inf*$C40*60)+PI()*1.25*W*_vol1/100)","v":-10.051401038566992},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C40*60)","v":-0.15656023020635781},{"$f":"$AX26-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":4.0262396248868075},{"$f":"IF(BH26^2-4*BG26*BI26<0,1,0)","v":0},{"$f":"IF(BJ26=1,0,(-BH26+(BH26^2-4*BG26*BI26)^0.5)/(2*BG26))","v":-0.64073795428815794},{"$f":"IF(BJ26=1,0,(-BH26-(BH26^2-4*BG26*BI26)^0.5)/(2*BG26))","v":0.62516199332454303},{"$f":"2*MAX(BK26:BL35)","v":1.9394140772045456},null,{"$f":"-(PI()*binf*(W*inf*$C40*60)+PI()*1.25*W*_vol1/100)","v":-10.051401038566992},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C40*60)","v":-0.15656023020635781},{"$f":"$AX26-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":3.9124796096572094},{"$f":"IF(BP26^2-4*BO26*BQ26<0,1,0)","v":0},{"$f":"IF(BR26=1,0,(-BP26+(BP26^2-4*BO26*BQ26)^0.5)/(2*BO26))","v":-0.63173336480904452},{"$f":"IF(BR26=1,0,(-BP26-(BP26^2-4*BO26*BQ26)^0.5)/(2*BO26))","v":0.61615740384542961},{"$f":"2*MAX(BS26:BT35)","v":1.9302684348569872}]
[null,null,"allowance for infiltration through soakaway base:",null,null,null,null,null,null,null,null,null,0.3,null,null,"soakage trial pit width 'Wt' [m] =",null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"(MAX(L41,Q41,V41))","v":5.8896396000000024},{"$f":"-(PI()*binf*(W*inf*$C41*60)+PI()*1.25*W*_vol1/100)","v":-10.088975493816518},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C41*60)","v":-0.31312046041271563},{"$f":"$AX27-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":5.9533304823130129},{"$f":"IF(AZ27^2-4*AY27*BA27<0,1,0)","v":0},{"$f":"IF(BB27=1,0,(-AZ27+(AZ27^2-4*AY27*BA27)^0.5)/(2*AY27))","v":-0.78384311979345289},{"$f":"IF(BB27=1,0,(-AZ27-(AZ27^2-4*AY27*BA27)^0.5)/(2*AY27))","v":0.75280721722786281},{"$f":"(PI()*(AY24/2000)^2*1.25+(PI()*(BE26/2)^2*1.25-PI()*((AY24+100)/2000)^2*1.25)*_vol1/100)*0.5/((PI()*(BE26/2)^2*binf+0.5*(2*PI()*(BE26/2)*1.25))*(inf*60*60))","v":2.094125589267875},null,{"$f":"-(PI()*binf*(W*inf*$C41*60)+PI()*1.25*W*_vol1/100)","v":-10.088975493816518},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C41*60)","v":-0.31312046041271563},{"$f":"$AX27-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":5.7854516248868091},{"$f":"IF(BH27^2-4*BG27*BI27<0,1,0)","v":0},{"$f":"IF(BJ27=1,0,(-BH27+(BH27^2-4*BG27*BI27)^0.5)/(2*BG27))","v":-0.77293707736251804},{"$f":"IF(BJ27=1,0,(-BH27-(BH27^2-4*BG27*BI27)^0.5)/(2*BG27))","v":0.74190117479692796},{"$f":"(PI()*(BG24/2000)^2*1.25+(PI()*(BM26/2)^2*1.25-PI()*((BG24+100)/2000)^2*1.25)*_vol1/100)*0.5/((PI()*(BM26/2)^2*binf+0.5*(2*PI()*(BM26/2)*1.25))*(inf*60*60))","v":2.1196247313300116},null,{"$f":"-(PI()*binf*(W*inf*$C41*60)+PI()*1.25*W*_vol1/100)","v":-10.088975493816518},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C41*60)","v":-0.31312046041271563},{"$f":"$AX27-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":5.671691609657211},{"$f":"IF(BP27^2-4*BO27*BQ27<0,1,0)","v":0},{"$f":"IF(BR27=1,0,(-BP27+(BP27^2-4*BO27*BQ27)^0.5)/(2*BO27))","v":-0.76545665338400604},{"$f":"IF(BR27=1,0,(-BP27-(BP27^2-4*BO27*BQ27)^0.5)/(2*BO27))","v":0.73442075081841596},{"$f":"(PI()*(BO24/2000)^2*1.25+(PI()*(BU26/2)^2*1.25-PI()*((BO24+100)/2000)^2*1.25)*_vol1/100)*0.5/((PI()*(BU26/2)^2*binf+0.5*(2*PI()*(BU26/2)*1.25))*(inf*60*60))","v":2.1371985540807756}]
[null,null,"available on-site infiltration test results:",null,null,null,null,null,null,null,null,null,null,null,null,"soakage trial pit length 'Lt' [m] =",null,null,null,null,null,null,null,null,2.4,null,null,null,null,null,null,null,null,null,null,"infiltration trial pit:",null,1,{"$f":"IF(infiltr=1,\"(?)\",\"\")","v":"(?)"},{"$f":"IF(infiltr=1,\"\",\"(?)\")","v":""},null,null,null,null,null,null,null,null,15,7.23996,{"$f":"-(PI()*binf*(W*inf*$C42*60)+PI()*1.25*W*_vol1/100)","v":-10.126549949066042},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C42*60)","v":-0.46968069061907353},{"$f":"$AX28-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":7.3036508823130104},0,-0.87276435080384973,0.82638323453212348,{"$f":"BE27/24","v":8.7255232886161452E-2},null,{"$f":"-(PI()*binf*(W*inf*$C42*60)+PI()*1.25*W*_vol1/100)","v":-10.126549949066042},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C42*60)","v":-0.46968069061907353},{"$f":"$AX28-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":7.1357720248868066},0,-0.86295096390133152,0.81656984762960527,{"$f":"BM27/24","v":8.8317697138750484E-2},null,{"$f":"-(PI()*binf*(W*inf*$C42*60)+PI()*1.25*W*_vol1/100)","v":-10.126549949066042},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C42*60)","v":-0.46968069061907353},{"$f":"$AX28-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":7.0220120096572085},0,-0.85623539589857411,0.80985427962684786,{"$f":"BU27/24","v":8.9049939753365656E-2}]
[null,null,{"$f":"IF(AL28=1,\"use soakage trial pit table below\",\"soil infiltration rate 'f'\")","v":"use soakage trial pit table below"},null,null,null,null,null,null,null,"[m/s] =",null,{"$f":"3.5*10^-5","v":3.5000000000000004E-5},null,null,"total depth from ground level 'Dtb' [m] =",null,null,null,null,null,null,null,null,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,9.3387995999999998,{"$f":"-(PI()*binf*(W*inf*$C43*60)+PI()*1.25*W*_vol1/100)","v":-10.239273314814621},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C43*60)","v":-0.93936138123814705},{"$f":"$AX29-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":9.4024904823130093},0,-1.0052355244917326,0.91349450417156619,null,null,{"$f":"-(PI()*binf*(W*inf*$C43*60)+PI()*1.25*W*_vol1/100)","v":-10.239273314814621},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C43*60)","v":-0.93936138123814705},{"$f":"$AX29-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":9.2346116248868064},0,-0.9966521083911053,0.90491108807093878,null,null,{"$f":"-(PI()*binf*(W*inf*$C43*60)+PI()*1.25*W*_vol1/100)","v":-10.239273314814621},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C43*60)","v":-0.93936138123814705},{"$f":"$AX29-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":9.1208516096572083},0,-0.99079139711873609,0.89905037679856958]
[null,null,"internal surface area of trial pit 'ap50' [m2] =",null,null,null,null,null,null,null,null,null,{"$f":"AK56","v":7.5},null,null,"depth to pipe invert level 'Dtp' [m] =",null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,"ring diameters:",null,900,"show error about taking measurements",{"$f":"IF(AND(infiltr=1,ISERROR(M33)),1,0)","v":0},null,null,null,null,null,null,null,null,60,11.641500000000001,{"$f":"-(PI()*binf*(W*inf*$C44*60)+PI()*1.25*W*_vol1/100)","v":-10.464720046311776},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C44*60)","v":-1.8787227624762941},{"$f":"$AX30-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":11.70519088231301},0,-1.1511768880873805,0.97164769340639734,{"$f":"0.5*PI()*1.25*_vol1/100-24*PI()*binf*inf*60*60","v":-1.9381766067349069},"A",{"$f":"-(PI()*binf*(W*inf*$C44*60)+PI()*1.25*W*_vol1/100)","v":-10.464720046311776},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C44*60)","v":-1.8787227624762941},{"$f":"$AX30-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":11.537312024886807},0,-1.1435927076418229,0.96406351296083981,{"$f":"0.5*PI()*1.25*_vol1/100-24*PI()*binf*inf*60*60","v":-1.9381766067349069},"A",{"$f":"-(PI()*binf*(W*inf*$C44*60)+PI()*1.25*W*_vol1/100)","v":-10.464720046311776},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C44*60)","v":-1.8787227624762941},{"$f":"$AX30-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":11.423552009657209},0,-1.1384222502533263,0.95889305557234317,{"$f":"0.5*PI()*1.25*_vol1/100-24*PI()*binf*inf*60*60","v":-1.9381766067349069},"A"]
[null,null,"storage volume between 75-25% 'Vp' [m3] =",null,null,null,null,null,null,null,null,null,{"$f":"AK59","v":1.7999999999999998},null,null,"soakage trial pit effective depth 'Dteff' [m] =",null,null,null,null,null,null,null,null,{"$f":"Y29-Y30","v":1.5},null,null,null,null,null,null,null,null,null,null,null,null,1050,null,null,null,null,null,null,null,null,null,null,120,14.012107199999997,{"$f":"-(PI()*binf*(W*inf*$C45*60)+PI()*1.25*W*_vol1/100)","v":-10.915613509306086},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C45*60)","v":-3.7574455249525882},{"$f":"$AX31-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":14.075798082313009},0,-1.3206487130706785,0.97642202148351454,{"$f":"24*0.5*2*PI()*1.25*inf*60*60","v":15.029782099810351},"B",{"$f":"-(PI()*binf*(W*inf*$C45*60)+PI()*1.25*W*_vol1/100)","v":-10.915613509306086},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C45*60)","v":-3.7574455249525882},{"$f":"$AX31-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":13.907919224886804},0,-1.3139337301894369,0.96970703860227281,{"$f":"24*0.5*2*PI()*1.25*inf*60*60","v":15.029782099810351},"B",{"$f":"-(PI()*binf*(W*inf*$C45*60)+PI()*1.25*W*_vol1/100)","v":-10.915613509306086},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C45*60)","v":-3.7574455249525882},{"$f":"$AX31-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":13.794159209657206},0,-1.3093609090156575,0.96513421742849359,{"$f":"24*0.5*2*PI()*1.25*inf*60*60","v":15.029782099810351},"B"]
[null,null,"time for water to fall from 75-25% 'tp' [min] =",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AP58:AR58,1,MATCH(AS59,AP59:AR59,0))","v":90.298582995951449},null,null,"free volume in infill aggregate [%] =",null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,1200,null,null,null,null,null,null,null,null,null,null,240,16.365585599999996,{"$f":"-(PI()*binf*(W*inf*$C46*60)+PI()*1.25*W*_vol1/100)","v":-11.817400435294708},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C46*60)","v":-7.5148910499051764},{"$f":"$AX32-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":16.429276482313007},0,-1.5391709121930679,0.90325347070054995,{"$f":"0.5*PI()*(AY24/2000)^2*1.25-0.5*PI()*((AY24+100)/2000)^2*1.25*_vol1/100","v":-1.0615147052168483E-2},"C",{"$f":"-(PI()*binf*(W*inf*$C46*60)+PI()*1.25*W*_vol1/100)","v":-11.817400435294708},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C46*60)","v":-7.5148910499051764},{"$f":"$AX32-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":16.261397624886804},0,-1.533340612657301,0.89742317116478321,{"$f":"0.5*PI()*(BG24/2000)^2*1.25-0.5*PI()*((BG24+100)/2000)^2*1.25*_vol1/100","v":1.7364662518865481E-2},"C",{"$f":"-(PI()*binf*(W*inf*$C46*60)+PI()*1.25*W*_vol1/100)","v":-11.817400435294708},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C46*60)","v":-7.5148910499051764},{"$f":"$AX32-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":16.147637609657203},0,-1.5293738681125082,0.89345642661999058,{"$f":"0.5*PI()*(BO24/2000)^2*1.25-0.5*PI()*((BO24+100)/2000)^2*1.25*_vol1/100","v":3.6324665057131833E-2},"C"]
[null,null,"soil infiltration rate 'f' [m/s] =",null,null,null,null,null,null,null,null,null,{"$f":"AS59","v":4.4297483607016737E-5},null,null,"NOTE: faces of excavation assumed to be vertical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1350,null,null,null,null,null,null,null,null,null,null,360,17.838369899999993,{"$f":"-(PI()*binf*(W*inf*$C47*60)+PI()*1.25*W*_vol1/100)","v":-12.719187361283328},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C47*60)","v":-11.272336574857764},{"$f":"$AX33-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":17.902060782313001},0,-1.7095524914568354,0.82330588979340802,{"$f":"-2*(-BE31+(BE31^2-4*BE30*BE32)^0.5)/(2*BE30)","v":-1.4126770388706146E-3},"X1",{"$f":"-(PI()*binf*(W*inf*$C47*60)+PI()*1.25*W*_vol1/100)","v":-12.719187361283328},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C47*60)","v":-11.272336574857764},{"$f":"$AX33-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":17.734181924886798},0,-1.7043306700826697,0.81808406841924264,{"$f":"-2*(-BM31+(BM31^2-4*BM30*BM32)^0.5)/(2*BM30)","v":2.3103563351439967E-3},"X1",{"$f":"-(PI()*binf*(W*inf*$C47*60)+PI()*1.25*W*_vol1/100)","v":-12.719187361283328},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C47*60)","v":-11.272336574857764},{"$f":"$AX33-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":17.6204219096572},0,-1.7007798753498249,0.81453327368639761,{"$f":"-2*(-BU31+(BU31^2-4*BU30*BU32)^0.5)/(2*BU30)","v":4.832185949182978E-3},"X1"]
[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,1500,null,null,null,null,null,null,null,null,null,null,600,19.738555199999993,{"$f":"-(PI()*binf*(W*inf*$C48*60)+PI()*1.25*W*_vol1/100)","v":-14.522761213260571},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C48*60)","v":-18.787227624762938},{"$f":"$AX34-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":19.802246082313005},0,-1.9817013619663011,0.68806116855676358,{"$f":"-2*(-BE31-(BE31^2-4*BE30*BE32)^0.5)/(2*BE30)","v":-15.507785037538687},"X2",{"$f":"-(PI()*binf*(W*inf*$C48*60)+PI()*1.25*W*_vol1/100)","v":-14.522761213260571},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C48*60)","v":-18.787227624762938},{"$f":"$AX34-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":19.634367224886802},0,-1.9773644536618384,0.68372426025230049,{"$f":"-2*(-BM31-(BM31^2-4*BM30*BM32)^0.5)/(2*BM30)","v":-15.511508070912701},"X2",{"$f":"-(PI()*binf*(W*inf*$C48*60)+PI()*1.25*W*_vol1/100)","v":-14.522761213260571},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C48*60)","v":-18.787227624762938},{"$f":"$AX34-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":19.5206072096572},0,-1.9744175747272847,0.6807773813177469,{"$f":"-2*(-BU31-(BU31^2-4*BU30*BU32)^0.5)/(2*BU30)","v":-15.51402990052674},"X2"]
[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,1800,null,null,null,null,null,null,null,null,null,null,1440,23.351983199999999,{"$f":"-(PI()*binf*(W*inf*$C49*60)+PI()*1.25*W*_vol1/100)","v":-20.835269695180919},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C49*60)","v":-45.089346299431057},{"$f":"$AX35-W*PI()*(AY$24/2000)^2*1.25+PI()*((AY$24+100)/2000)^2*1.25*W*_vol1/100","v":23.415674082313011},0,-2.5968594238281257,0.43277194336417157,{"$f":"IF(BE28<=1,BE26,IF(BE26>MAX(BE33,BE34),\"N/A\",MAX(BE33,BE34)))","v":1.9528440429670291},"final",{"$f":"-(PI()*binf*(W*inf*$C49*60)+PI()*1.25*W*_vol1/100)","v":-20.835269695180919},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C49*60)","v":-45.089346299431057},{"$f":"$AX35-W*PI()*(BG$24/2000)^2*1.25+PI()*((BG$24+100)/2000)^2*1.25*W*_vol1/100","v":23.247795224886808},0,-2.5941975416072851,0.43011006114333045,{"$f":"IF(BM28<=1,BM26,IF(BM26>MAX(BM33,BM34),\"N/A\",MAX(BM33,BM34)))","v":1.9394140772045456},"final",{"$f":"-(PI()*binf*(W*inf*$C49*60)+PI()*1.25*W*_vol1/100)","v":-20.835269695180919},{"$f":"-2*PI()*0.5*1.25*(W*inf*$C49*60)","v":-45.089346299431057},{"$f":"$AX35-W*PI()*(BO$24/2000)^2*1.25+PI()*((BO$24+100)/2000)^2*1.25*W*_vol1/100","v":23.134035209657206},0,-2.5923910995377759,0.42830361907382153,{"$f":"IF(BU28<=1,BU26,IF(BU26>MAX(BU33,BU34),\"N/A\",MAX(BU33,BU34)))","v":1.9302684348569872},"final"]
[null,null,"REQUIRED STORAGE CAPACITY PER RAINFALL DURATION",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,2100]
[null,null,"rainfall duration [min]",null,"rainfall factor Z1",null,"M5-D rainfalls [mm]",null,"M10-D",null,null,null,null,"M50-D",null,null,null,null,"M100-D",null,null,null,null,"outflow from soakaway [m3]",null,"required storage [m3]",null,null,null,null,null,null,null,null,null,null,null,2400,null,null,null,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,null,null,null,"Z2","rainfalls [mm]",null,"inflow [m3]",null,"Z2","rainfalls [mm]",null,"inflow [m3]",null,"Z2","rainfalls [mm]",null,"inflow [m3]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2700,"find max","storage reqired",null,"M1","M2","M3","M4","M5","M10","M20","M30","M50","M100"]
[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,3000,{"$f":"IF(Z40=MAX($Z$40:$AA$49),1,0)","v":0},{"$f":"Z40","v":3.9663054232360038},3,{"$f":"IF(location=1,IF($G40<5,tables!D$21,IF($G40>100,tables!D$32,FORECAST($G40,OFFSET(tables!D$21:D$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!D$36,IF($G40>100,tables!D$47,FORECAST($G40,OFFSET(tables!D$36:D$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.61829999999999996},{"$f":"IF(location=1,IF($G40<5,tables!E$21,IF($G40>100,tables!E$32,FORECAST($G40,OFFSET(tables!E$21:E$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!E$36,IF($G40>100,tables!E$47,FORECAST($G40,OFFSET(tables!E$36:E$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.79},{"$f":"IF(location=1,IF($G40<5,tables!F$21,IF($G40>100,tables!F$32,FORECAST($G40,OFFSET(tables!F$21:F$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!F$36,IF($G40>100,tables!F$47,FORECAST($G40,OFFSET(tables!F$36:F$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.89170000000000005},{"$f":"IF(location=1,IF($G40<5,tables!G$21,IF($G40>100,tables!G$32,FORECAST($G40,OFFSET(tables!G$21:G$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!G$36,IF($G40>100,tables!G$47,FORECAST($G40,OFFSET(tables!G$36:G$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G40<5,tables!H$21,IF($G40>100,tables!H$32,FORECAST($G40,OFFSET(tables!H$21:H$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!H$36,IF($G40>100,tables!H$47,FORECAST($G40,OFFSET(tables!H$36:H$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.0216999999999998},{"$f":"IF(location=1,IF($G40<5,tables!I$21,IF($G40>100,tables!I$32,FORECAST($G40,OFFSET(tables!I$21:I$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!I$36,IF($G40>100,tables!I$47,FORECAST($G40,OFFSET(tables!I$36:I$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.1951000000000003},{"$f":"IF(location=1,IF($G40<5,tables!J$21,IF($G40>100,tables!J$32,FORECAST($G40,OFFSET(tables!J$21:J$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!J$36,IF($G40>100,tables!J$47,FORECAST($G40,OFFSET(tables!J$36:J$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.3685},{"$f":"IF(location=1,IF($G40<5,tables!K$21,IF($G40>100,tables!K$32,FORECAST($G40,OFFSET(tables!K$21:K$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!K$36,IF($G40>100,tables!K$47,FORECAST($G40,OFFSET(tables!K$36:K$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4374333333333336},{"$f":"IF(location=1,IF($G40<5,tables!L$21,IF($G40>100,tables!L$32,FORECAST($G40,OFFSET(tables!L$21:L$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!L$36,IF($G40>100,tables!L$47,FORECAST($G40,OFFSET(tables!L$36:L$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5752999999999999},{"$f":"IF(location=1,IF($G40<5,tables!M$21,IF($G40>100,tables!M$32,FORECAST($G40,OFFSET(tables!M$21:M$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G40,tables!$C$21:$C$32,1)-1,0,2)))),IF($G40<5,tables!M$36,IF($G40>100,tables!M$47,FORECAST($G40,OFFSET(tables!M$36:M$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G40,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.8104000000000002}]
[null,null,5,null,{"$f":"IF(rr<0.12,tables!D5,IF(rr>=0.45,tables!D16,FORECAST($M$23,OFFSET(tables!D5:D16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":0.39},null,{"$f":"E40*15","v":5.8500000000000005},null,{"$f":"IF($AL$53=1,0,HLOOKUP($AL$53,$AP$37:$AY$48,$AO39))","v":1.1951000000000003},{"$f":"G40*I40*IF($AL$24>1,1+$M$24,1)","v":9.0887355000000039},null,{"$f":"J40/1000*A","v":2.726620650000001},null,{"$f":"IF($AM$53=1,0,HLOOKUP($AM$53,$AP$37:$AY$48,$AO39))","v":1.5752999999999999},{"$f":"G40*N40*IF($AL$24>1,1+$M$24,1)","v":11.980156500000001},null,{"$f":"O40/1000*A","v":3.5940469500000005},null,{"$f":"IF($AN$53=1,0,HLOOKUP($AN$53,$AP$37:$AY$48,$AO39))","v":1.8104000000000002},{"$f":"G40*S40*IF($AL$24>1,1+$M$24,1)","v":13.768092000000003},null,{"$f":"T40/1000*A","v":4.1304276000000009},null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C40*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C40*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C40*60)))","v":0.16412217676399701},null,{"$f":"IF(MAX(L40,Q40,V40)-X40<0,0,MAX(L40,Q40,V40)-X40)","v":3.9663054232360038},null,null,null,null,null,null,null,null,null,"selected:",null,{"$f":"MATCH(Y20,AL30:AL39)","v":3},0,5.5613952464720082,4,{"$f":"IF(location=1,IF($G41<5,tables!D$21,IF($G41>100,tables!D$32,FORECAST($G41,OFFSET(tables!D$21:D$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!D$36,IF($G41>100,tables!D$47,FORECAST($G41,OFFSET(tables!D$36:D$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.61380000000000001},{"$f":"IF(location=1,IF($G41<5,tables!E$21,IF($G41>100,tables!E$32,FORECAST($G41,OFFSET(tables!E$21:E$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!E$36,IF($G41>100,tables!E$47,FORECAST($G41,OFFSET(tables!E$36:E$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.79},{"$f":"IF(location=1,IF($G41<5,tables!F$21,IF($G41>100,tables!F$32,FORECAST($G41,OFFSET(tables!F$21:F$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!F$36,IF($G41>100,tables!F$47,FORECAST($G41,OFFSET(tables!F$36:F$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.8962},{"$f":"IF(location=1,IF($G41<5,tables!G$21,IF($G41>100,tables!G$32,FORECAST($G41,OFFSET(tables!G$21:G$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!G$36,IF($G41>100,tables!G$47,FORECAST($G41,OFFSET(tables!G$36:G$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G41<5,tables!H$21,IF($G41>100,tables!H$32,FORECAST($G41,OFFSET(tables!H$21:H$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!H$36,IF($G41>100,tables!H$47,FORECAST($G41,OFFSET(tables!H$36:H$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.0261999999999998},{"$f":"IF(location=1,IF($G41<5,tables!I$21,IF($G41>100,tables!I$32,FORECAST($G41,OFFSET(tables!I$21:I$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!I$36,IF($G41>100,tables!I$47,FORECAST($G41,OFFSET(tables!I$36:I$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.2086000000000001},{"$f":"IF(location=1,IF($G41<5,tables!J$21,IF($G41>100,tables!J$32,FORECAST($G41,OFFSET(tables!J$21:J$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!J$36,IF($G41>100,tables!J$47,FORECAST($G41,OFFSET(tables!J$36:J$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.391},{"$f":"IF(location=1,IF($G41<5,tables!K$21,IF($G41>100,tables!K$32,FORECAST($G41,OFFSET(tables!K$21:K$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!K$36,IF($G41>100,tables!K$47,FORECAST($G41,OFFSET(tables!K$36:K$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4659333333333335},{"$f":"IF(location=1,IF($G41<5,tables!L$21,IF($G41>100,tables!L$32,FORECAST($G41,OFFSET(tables!L$21:L$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!L$36,IF($G41>100,tables!L$47,FORECAST($G41,OFFSET(tables!L$36:L$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.6157999999999999},{"$f":"IF(location=1,IF($G41<5,tables!M$21,IF($G41>100,tables!M$32,FORECAST($G41,OFFSET(tables!M$21:M$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G41,tables!$C$21:$C$32,1)-1,0,2)))),IF($G41<5,tables!M$36,IF($G41>100,tables!M$47,FORECAST($G41,OFFSET(tables!M$36:M$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G41,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.8644000000000003}]
[null,null,10,null,{"$f":"IF(rr<0.12,tables!E5,IF(rr>=0.45,tables!E16,FORECAST($M$23,OFFSET(tables!E5:E16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":0.54},null,{"$f":"E41*15","v":8.1000000000000014},null,1.2086000000000001,12.726558000000004,null,3.8179674000000015,null,1.6157999999999999,17.014374000000004,null,5.1043122000000007,null,1.8644000000000003,19.632132000000006,null,5.8896396000000024,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C41*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C41*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C41*60)))","v":0.32824435352799403},null,{"$f":"IF(MAX(L41,Q41,V41)-X41<0,0,MAX(L41,Q41,V41)-X41)","v":5.5613952464720082},null,null,null,null,null,null,null,null,null,null,null,null,0,6.7475934697080087,5,{"$f":"IF(location=1,IF($G42<5,tables!D$21,IF($G42>100,tables!D$32,FORECAST($G42,OFFSET(tables!D$21:D$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!D$36,IF($G42>100,tables!D$47,FORECAST($G42,OFFSET(tables!D$36:D$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.61050000000000004},{"$f":"IF(location=1,IF($G42<5,tables!E$21,IF($G42>100,tables!E$32,FORECAST($G42,OFFSET(tables!E$21:E$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!E$36,IF($G42>100,tables!E$47,FORECAST($G42,OFFSET(tables!E$36:E$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.79},{"$f":"IF(location=1,IF($G42<5,tables!F$21,IF($G42>100,tables!F$32,FORECAST($G42,OFFSET(tables!F$21:F$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!F$36,IF($G42>100,tables!F$47,FORECAST($G42,OFFSET(tables!F$36:F$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.89949999999999997},{"$f":"IF(location=1,IF($G42<5,tables!G$21,IF($G42>100,tables!G$32,FORECAST($G42,OFFSET(tables!G$21:G$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!G$36,IF($G42>100,tables!G$47,FORECAST($G42,OFFSET(tables!G$36:G$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G42<5,tables!H$21,IF($G42>100,tables!H$32,FORECAST($G42,OFFSET(tables!H$21:H$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!H$36,IF($G42>100,tables!H$47,FORECAST($G42,OFFSET(tables!H$36:H$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.0294999999999999},{"$f":"IF(location=1,IF($G42<5,tables!I$21,IF($G42>100,tables!I$32,FORECAST($G42,OFFSET(tables!I$21:I$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!I$36,IF($G42>100,tables!I$47,FORECAST($G42,OFFSET(tables!I$36:I$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.2185000000000001},{"$f":"IF(location=1,IF($G42<5,tables!J$21,IF($G42>100,tables!J$32,FORECAST($G42,OFFSET(tables!J$21:J$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!J$36,IF($G42>100,tables!J$47,FORECAST($G42,OFFSET(tables!J$36:J$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4075},{"$f":"IF(location=1,IF($G42<5,tables!K$21,IF($G42>100,tables!K$32,FORECAST($G42,OFFSET(tables!K$21:K$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!K$36,IF($G42>100,tables!K$47,FORECAST($G42,OFFSET(tables!K$36:K$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4868333333333337},{"$f":"IF(location=1,IF($G42<5,tables!L$21,IF($G42>100,tables!L$32,FORECAST($G42,OFFSET(tables!L$21:L$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!L$36,IF($G42>100,tables!L$47,FORECAST($G42,OFFSET(tables!L$36:L$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.6455},{"$f":"IF(location=1,IF($G42<5,tables!M$21,IF($G42>100,tables!M$32,FORECAST($G42,OFFSET(tables!M$21:M$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G42,tables!$C$21:$C$32,1)-1,0,2)))),IF($G42<5,tables!M$36,IF($G42>100,tables!M$47,FORECAST($G42,OFFSET(tables!M$36:M$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G42,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.9040000000000001}]
[null,null,15,null,{"$f":"IF(rr<0.12,tables!F5,IF(rr>=0.45,tables!F16,FORECAST($M$23,OFFSET(tables!F5:F16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":0.65},null,{"$f":"E42*15","v":9.75},null,1.2185000000000001,15.444487500000001,null,4.6333462500000007,null,1.6455,20.8567125,null,6.2570137499999996,null,1.9040000000000001,24.133200000000002,null,7.23996,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C42*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C42*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C42*60)))","v":0.49236653029199096},null,6.7475934697080087,null,null,null,null,null,null,null,null,null,"return period:",null,"ignore",0,8.3540665394160172,6,{"$f":"IF(location=1,IF($G43<5,tables!D$21,IF($G43>100,tables!D$32,FORECAST($G43,OFFSET(tables!D$21:D$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!D$36,IF($G43>100,tables!D$47,FORECAST($G43,OFFSET(tables!D$36:D$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.61460000000000004},{"$f":"IF(location=1,IF($G43<5,tables!E$21,IF($G43>100,tables!E$32,FORECAST($G43,OFFSET(tables!E$21:E$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!E$36,IF($G43>100,tables!E$47,FORECAST($G43,OFFSET(tables!E$36:E$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.79460000000000008},{"$f":"IF(location=1,IF($G43<5,tables!F$21,IF($G43>100,tables!F$32,FORECAST($G43,OFFSET(tables!F$21:F$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!F$36,IF($G43>100,tables!F$47,FORECAST($G43,OFFSET(tables!F$36:F$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.9},{"$f":"IF(location=1,IF($G43<5,tables!G$21,IF($G43>100,tables!G$32,FORECAST($G43,OFFSET(tables!G$21:G$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!G$36,IF($G43>100,tables!G$47,FORECAST($G43,OFFSET(tables!G$36:G$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G43<5,tables!H$21,IF($G43>100,tables!H$32,FORECAST($G43,OFFSET(tables!H$21:H$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!H$36,IF($G43>100,tables!H$47,FORECAST($G43,OFFSET(tables!H$36:H$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G43<5,tables!I$21,IF($G43>100,tables!I$32,FORECAST($G43,OFFSET(tables!I$21:I$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!I$36,IF($G43>100,tables!I$47,FORECAST($G43,OFFSET(tables!I$36:I$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.2292000000000001},{"$f":"IF(location=1,IF($G43<5,tables!J$21,IF($G43>100,tables!J$32,FORECAST($G43,OFFSET(tables!J$21:J$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!J$36,IF($G43>100,tables!J$47,FORECAST($G43,OFFSET(tables!J$36:J$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4237999999999997},{"$f":"IF(location=1,IF($G43<5,tables!K$21,IF($G43>100,tables!K$32,FORECAST($G43,OFFSET(tables!K$21:K$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!K$36,IF($G43>100,tables!K$47,FORECAST($G43,OFFSET(tables!K$36:K$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5068666666666666},{"$f":"IF(location=1,IF($G43<5,tables!L$21,IF($G43>100,tables!L$32,FORECAST($G43,OFFSET(tables!L$21:L$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!L$36,IF($G43>100,tables!L$47,FORECAST($G43,OFFSET(tables!L$36:L$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.6729999999999998},{"$f":"IF(location=1,IF($G43<5,tables!M$21,IF($G43>100,tables!M$32,FORECAST($G43,OFFSET(tables!M$21:M$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G43,tables!$C$21:$C$32,1)-1,0,2)))),IF($G43<5,tables!M$36,IF($G43>100,tables!M$47,FORECAST($G43,OFFSET(tables!M$36:M$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G43,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.9467999999999999}]
[null,null,30,null,{"$f":"IF(rr<0.12,tables!G5,IF(rr>=0.45,tables!G16,FORECAST($M$23,OFFSET(tables!G5:G16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":0.82},null,{"$f":"E43*15","v":12.299999999999999},null,1.2292000000000001,19.654907999999999,null,5.8964723999999995,null,1.6729999999999998,26.751269999999995,null,8.0253809999999977,null,1.9467999999999999,31.129331999999998,null,9.3387995999999998,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C43*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C43*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C43*60)))","v":0.98473306058398191},null,8.3540665394160172,null,null,null,null,null,null,null,null,null,null,null,"M1-D",0,9.6720338788320372,7,{"$f":"IF(location=1,IF($G44<5,tables!D$21,IF($G44>100,tables!D$32,FORECAST($G44,OFFSET(tables!D$21:D$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!D$36,IF($G44>100,tables!D$47,FORECAST($G44,OFFSET(tables!D$36:D$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.62},{"$f":"IF(location=1,IF($G44<5,tables!E$21,IF($G44>100,tables!E$32,FORECAST($G44,OFFSET(tables!E$21:E$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!E$36,IF($G44>100,tables!E$47,FORECAST($G44,OFFSET(tables!E$36:E$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.8},{"$f":"IF(location=1,IF($G44<5,tables!F$21,IF($G44>100,tables!F$32,FORECAST($G44,OFFSET(tables!F$21:F$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!F$36,IF($G44>100,tables!F$47,FORECAST($G44,OFFSET(tables!F$36:F$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.9},{"$f":"IF(location=1,IF($G44<5,tables!G$21,IF($G44>100,tables!G$32,FORECAST($G44,OFFSET(tables!G$21:G$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!G$36,IF($G44>100,tables!G$47,FORECAST($G44,OFFSET(tables!G$36:G$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G44<5,tables!H$21,IF($G44>100,tables!H$32,FORECAST($G44,OFFSET(tables!H$21:H$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!H$36,IF($G44>100,tables!H$47,FORECAST($G44,OFFSET(tables!H$36:H$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G44<5,tables!I$21,IF($G44>100,tables!I$32,FORECAST($G44,OFFSET(tables!I$21:I$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!I$36,IF($G44>100,tables!I$47,FORECAST($G44,OFFSET(tables!I$36:I$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.24},{"$f":"IF(location=1,IF($G44<5,tables!J$21,IF($G44>100,tables!J$32,FORECAST($G44,OFFSET(tables!J$21:J$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!J$36,IF($G44>100,tables!J$47,FORECAST($G44,OFFSET(tables!J$36:J$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4399999999999997},{"$f":"IF(location=1,IF($G44<5,tables!K$21,IF($G44>100,tables!K$32,FORECAST($G44,OFFSET(tables!K$21:K$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!K$36,IF($G44>100,tables!K$47,FORECAST($G44,OFFSET(tables!K$36:K$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5266666666666666},{"$f":"IF(location=1,IF($G44<5,tables!L$21,IF($G44>100,tables!L$32,FORECAST($G44,OFFSET(tables!L$21:L$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!L$36,IF($G44>100,tables!L$47,FORECAST($G44,OFFSET(tables!L$36:L$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.7},{"$f":"IF(location=1,IF($G44<5,tables!M$21,IF($G44>100,tables!M$32,FORECAST($G44,OFFSET(tables!M$21:M$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G44,tables!$C$21:$C$32,1)-1,0,2)))),IF($G44<5,tables!M$36,IF($G44>100,tables!M$47,FORECAST($G44,OFFSET(tables!M$36:M$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G44,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.99}]
[null,null,60,null,{"$f":"IF(rr<0.12,tables!H5,IF(rr>=0.45,tables!H16,FORECAST($M$23,OFFSET(tables!H5:H16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":1},null,{"$f":"E44*15","v":15},null,1.24,24.180000000000003,null,7.2540000000000013,null,1.7,33.15,null,9.9450000000000003,null,1.99,38.805,null,11.641500000000001,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C44*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C44*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C44*60)))","v":1.9694661211679638},null,9.6720338788320372,null,null,null,null,null,null,null,null,null,null,null,"M2-D",1,10.073174957664069,8,{"$f":"IF(location=1,IF($G45<5,tables!D$21,IF($G45>100,tables!D$32,FORECAST($G45,OFFSET(tables!D$21:D$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!D$36,IF($G45>100,tables!D$47,FORECAST($G45,OFFSET(tables!D$36:D$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.63139999999999996},{"$f":"IF(location=1,IF($G45<5,tables!E$21,IF($G45>100,tables!E$32,FORECAST($G45,OFFSET(tables!E$21:E$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!E$36,IF($G45>100,tables!E$47,FORECAST($G45,OFFSET(tables!E$36:E$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.80570000000000008},{"$f":"IF(location=1,IF($G45<5,tables!F$21,IF($G45>100,tables!F$32,FORECAST($G45,OFFSET(tables!F$21:F$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!F$36,IF($G45>100,tables!F$47,FORECAST($G45,OFFSET(tables!F$36:F$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.9},{"$f":"IF(location=1,IF($G45<5,tables!G$21,IF($G45>100,tables!G$32,FORECAST($G45,OFFSET(tables!G$21:G$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!G$36,IF($G45>100,tables!G$47,FORECAST($G45,OFFSET(tables!G$36:G$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G45<5,tables!H$21,IF($G45>100,tables!H$32,FORECAST($G45,OFFSET(tables!H$21:H$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!H$36,IF($G45>100,tables!H$47,FORECAST($G45,OFFSET(tables!H$36:H$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G45<5,tables!I$21,IF($G45>100,tables!I$32,FORECAST($G45,OFFSET(tables!I$21:I$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!I$36,IF($G45>100,tables!I$47,FORECAST($G45,OFFSET(tables!I$36:I$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.24},{"$f":"IF(location=1,IF($G45<5,tables!J$21,IF($G45>100,tables!J$32,FORECAST($G45,OFFSET(tables!J$21:J$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!J$36,IF($G45>100,tables!J$47,FORECAST($G45,OFFSET(tables!J$36:J$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4456999999999998},{"$f":"IF(location=1,IF($G45<5,tables!K$21,IF($G45>100,tables!K$32,FORECAST($G45,OFFSET(tables!K$21:K$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!K$36,IF($G45>100,tables!K$47,FORECAST($G45,OFFSET(tables!K$36:K$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5361666666666667},{"$f":"IF(location=1,IF($G45<5,tables!L$21,IF($G45>100,tables!L$32,FORECAST($G45,OFFSET(tables!L$21:L$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!L$36,IF($G45>100,tables!L$47,FORECAST($G45,OFFSET(tables!L$36:L$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.7170999999999998},{"$f":"IF(location=1,IF($G45<5,tables!M$21,IF($G45>100,tables!M$32,FORECAST($G45,OFFSET(tables!M$21:M$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G45,tables!$C$21:$C$32,1)-1,0,2)))),IF($G45<5,tables!M$36,IF($G45>100,tables!M$47,FORECAST($G45,OFFSET(tables!M$36:M$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G45,tables!$C$36:$C$47,1)-1,0,2)))))","v":2.0127999999999999}]
[null,null,120,null,{"$f":"IF(rr<0.12,tables!I5,IF(rr>=0.45,tables!I16,FORECAST($M$23,OFFSET(tables!I5:I16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":1.19},null,{"$f":"E45*15","v":17.849999999999998},null,1.24,28.774199999999997,null,8.6322599999999987,null,1.7170999999999998,39.845305499999995,null,11.95359165,null,2.0127999999999999,46.70702399999999,null,14.012107199999997,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C45*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C45*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C45*60)))","v":3.9389322423359276},null,10.073174957664069,null,null,null,null,null,null,null,null,null,null,null,"M3-D",0,8.4877211153281404,9,{"$f":"IF(location=1,IF($G46<5,tables!D$21,IF($G46>100,tables!D$32,FORECAST($G46,OFFSET(tables!D$21:D$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!D$36,IF($G46>100,tables!D$47,FORECAST($G46,OFFSET(tables!D$36:D$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.64280000000000004},{"$f":"IF(location=1,IF($G46<5,tables!E$21,IF($G46>100,tables!E$32,FORECAST($G46,OFFSET(tables!E$21:E$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!E$36,IF($G46>100,tables!E$47,FORECAST($G46,OFFSET(tables!E$36:E$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.81140000000000001},{"$f":"IF(location=1,IF($G46<5,tables!F$21,IF($G46>100,tables!F$32,FORECAST($G46,OFFSET(tables!F$21:F$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!F$36,IF($G46>100,tables!F$47,FORECAST($G46,OFFSET(tables!F$36:F$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.90139999999999998},{"$f":"IF(location=1,IF($G46<5,tables!G$21,IF($G46>100,tables!G$32,FORECAST($G46,OFFSET(tables!G$21:G$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!G$36,IF($G46>100,tables!G$47,FORECAST($G46,OFFSET(tables!G$36:G$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G46<5,tables!H$21,IF($G46>100,tables!H$32,FORECAST($G46,OFFSET(tables!H$21:H$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!H$36,IF($G46>100,tables!H$47,FORECAST($G46,OFFSET(tables!H$36:H$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G46<5,tables!I$21,IF($G46>100,tables!I$32,FORECAST($G46,OFFSET(tables!I$21:I$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!I$36,IF($G46>100,tables!I$47,FORECAST($G46,OFFSET(tables!I$36:I$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.24},{"$f":"IF(location=1,IF($G46<5,tables!J$21,IF($G46>100,tables!J$32,FORECAST($G46,OFFSET(tables!J$21:J$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!J$36,IF($G46>100,tables!J$47,FORECAST($G46,OFFSET(tables!J$36:J$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4485999999999997},{"$f":"IF(location=1,IF($G46<5,tables!K$21,IF($G46>100,tables!K$32,FORECAST($G46,OFFSET(tables!K$21:K$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!K$36,IF($G46>100,tables!K$47,FORECAST($G46,OFFSET(tables!K$36:K$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5419333333333329},{"$f":"IF(location=1,IF($G46<5,tables!L$21,IF($G46>100,tables!L$32,FORECAST($G46,OFFSET(tables!L$21:L$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!L$36,IF($G46>100,tables!L$47,FORECAST($G46,OFFSET(tables!L$36:L$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.7285999999999999},{"$f":"IF(location=1,IF($G46<5,tables!M$21,IF($G46>100,tables!M$32,FORECAST($G46,OFFSET(tables!M$21:M$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G46,tables!$C$21:$C$32,1)-1,0,2)))),IF($G46<5,tables!M$36,IF($G46>100,tables!M$47,FORECAST($G46,OFFSET(tables!M$36:M$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G46,tables!$C$36:$C$47,1)-1,0,2)))))","v":2.0271999999999992}]
[null,null,240,null,{"$f":"IF(rr<0.12,tables!J5,IF(rr>=0.45,tables!J16,FORECAST($M$23,OFFSET(tables!J5:J16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":1.38},null,{"$f":"E46*15","v":20.7},null,1.24,33.368400000000001,null,10.01052,null,1.7285999999999999,46.516625999999995,null,13.9549878,null,2.0271999999999992,54.551951999999986,null,16.365585599999996,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C46*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C46*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C46*60)))","v":7.8778644846718553},null,8.4877211153281404,null,null,null,null,null,null,null,null,null,null,null,"M4-D",0,6.0215731729922073,10,{"$f":"IF(location=1,IF($G47<5,tables!D$21,IF($G47>100,tables!D$32,FORECAST($G47,OFFSET(tables!D$21:D$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!D$36,IF($G47>100,tables!D$47,FORECAST($G47,OFFSET(tables!D$36:D$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.65060000000000007},{"$f":"IF(location=1,IF($G47<5,tables!E$21,IF($G47>100,tables!E$32,FORECAST($G47,OFFSET(tables!E$21:E$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!E$36,IF($G47>100,tables!E$47,FORECAST($G47,OFFSET(tables!E$36:E$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.81530000000000002},{"$f":"IF(location=1,IF($G47<5,tables!F$21,IF($G47>100,tables!F$32,FORECAST($G47,OFFSET(tables!F$21:F$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!F$36,IF($G47>100,tables!F$47,FORECAST($G47,OFFSET(tables!F$36:F$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.90529999999999999},{"$f":"IF(location=1,IF($G47<5,tables!G$21,IF($G47>100,tables!G$32,FORECAST($G47,OFFSET(tables!G$21:G$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!G$36,IF($G47>100,tables!G$47,FORECAST($G47,OFFSET(tables!G$36:G$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G47<5,tables!H$21,IF($G47>100,tables!H$32,FORECAST($G47,OFFSET(tables!H$21:H$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!H$36,IF($G47>100,tables!H$47,FORECAST($G47,OFFSET(tables!H$36:H$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G47<5,tables!I$21,IF($G47>100,tables!I$32,FORECAST($G47,OFFSET(tables!I$21:I$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!I$36,IF($G47>100,tables!I$47,FORECAST($G47,OFFSET(tables!I$36:I$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.24},{"$f":"IF(location=1,IF($G47<5,tables!J$21,IF($G47>100,tables!J$32,FORECAST($G47,OFFSET(tables!J$21:J$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!J$36,IF($G47>100,tables!J$47,FORECAST($G47,OFFSET(tables!J$36:J$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4446999999999997},{"$f":"IF(location=1,IF($G47<5,tables!K$21,IF($G47>100,tables!K$32,FORECAST($G47,OFFSET(tables!K$21:K$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!K$36,IF($G47>100,tables!K$47,FORECAST($G47,OFFSET(tables!K$36:K$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5380333333333329},{"$f":"IF(location=1,IF($G47<5,tables!L$21,IF($G47>100,tables!L$32,FORECAST($G47,OFFSET(tables!L$21:L$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!L$36,IF($G47>100,tables!L$47,FORECAST($G47,OFFSET(tables!L$36:L$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.7246999999999999},{"$f":"IF(location=1,IF($G47<5,tables!M$21,IF($G47>100,tables!M$32,FORECAST($G47,OFFSET(tables!M$21:M$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G47,tables!$C$21:$C$32,1)-1,0,2)))),IF($G47<5,tables!M$36,IF($G47>100,tables!M$47,FORECAST($G47,OFFSET(tables!M$36:M$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G47,tables!$C$36:$C$47,1)-1,0,2)))))","v":2.0193999999999992}]
[null,null,360,null,{"$f":"IF(rr<0.12,tables!K5,IF(rr>=0.45,tables!K16,FORECAST($M$23,OFFSET(tables!K5:K16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":1.51},null,{"$f":"E47*15","v":22.65},null,1.24,36.511800000000001,null,10.953540000000002,null,1.7246999999999999,50.783791499999992,null,15.235137449999998,null,2.0193999999999992,59.461232999999972,null,17.838369899999993,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C47*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C47*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C47*60)))","v":11.816796727007786},null,6.0215731729922073,null,null,null,null,null,null,null,null,null,null,null,"M5-D",0,4.3893988320352406E-2,11,{"$f":"IF(location=1,IF($G48<5,tables!D$21,IF($G48>100,tables!D$32,FORECAST($G48,OFFSET(tables!D$21:D$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!D$36,IF($G48>100,tables!D$47,FORECAST($G48,OFFSET(tables!D$36:D$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.66080000000000005},{"$f":"IF(location=1,IF($G48<5,tables!E$21,IF($G48>100,tables!E$32,FORECAST($G48,OFFSET(tables!E$21:E$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!E$36,IF($G48>100,tables!E$47,FORECAST($G48,OFFSET(tables!E$36:E$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.82039999999999991},{"$f":"IF(location=1,IF($G48<5,tables!F$21,IF($G48>100,tables!F$32,FORECAST($G48,OFFSET(tables!F$21:F$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!F$36,IF($G48>100,tables!F$47,FORECAST($G48,OFFSET(tables!F$36:F$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.91},{"$f":"IF(location=1,IF($G48<5,tables!G$21,IF($G48>100,tables!G$32,FORECAST($G48,OFFSET(tables!G$21:G$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!G$36,IF($G48>100,tables!G$47,FORECAST($G48,OFFSET(tables!G$36:G$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G48<5,tables!H$21,IF($G48>100,tables!H$32,FORECAST($G48,OFFSET(tables!H$21:H$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!H$36,IF($G48>100,tables!H$47,FORECAST($G48,OFFSET(tables!H$36:H$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.03},{"$f":"IF(location=1,IF($G48<5,tables!I$21,IF($G48>100,tables!I$32,FORECAST($G48,OFFSET(tables!I$21:I$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!I$36,IF($G48>100,tables!I$47,FORECAST($G48,OFFSET(tables!I$36:I$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.2392000000000001},{"$f":"IF(location=1,IF($G48<5,tables!J$21,IF($G48>100,tables!J$32,FORECAST($G48,OFFSET(tables!J$21:J$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!J$36,IF($G48>100,tables!J$47,FORECAST($G48,OFFSET(tables!J$36:J$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4392},{"$f":"IF(location=1,IF($G48<5,tables!K$21,IF($G48>100,tables!K$32,FORECAST($G48,OFFSET(tables!K$21:K$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!K$36,IF($G48>100,tables!K$47,FORECAST($G48,OFFSET(tables!K$36:K$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.5325333333333333},{"$f":"IF(location=1,IF($G48<5,tables!L$21,IF($G48>100,tables!L$32,FORECAST($G48,OFFSET(tables!L$21:L$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!L$36,IF($G48>100,tables!L$47,FORECAST($G48,OFFSET(tables!L$36:L$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.7192000000000001},{"$f":"IF(location=1,IF($G48<5,tables!M$21,IF($G48>100,tables!M$32,FORECAST($G48,OFFSET(tables!M$21:M$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G48,tables!$C$21:$C$32,1)-1,0,2)))),IF($G48<5,tables!M$36,IF($G48>100,tables!M$47,FORECAST($G48,OFFSET(tables!M$36:M$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G48,tables!$C$36:$C$47,1)-1,0,2)))))","v":2.0083999999999995}]
[null,null,600,null,{"$f":"IF(rr<0.12,tables!L5,IF(rr>=0.45,tables!L16,FORECAST($M$23,OFFSET(tables!L5:L16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":1.68},null,{"$f":"E48*15","v":25.2},null,1.2392000000000001,40.596192000000002,null,12.178857600000001,null,1.7192000000000001,56.320991999999997,null,16.8962976,null,2.0083999999999995,65.795183999999978,null,19.738555199999993,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C48*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C48*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C48*60)))","v":19.694661211679641},null,4.3893988320352406E-2,null,null,null,null,null,null,null,null,null,null,null,"M10-D",0,0,12,{"$f":"IF(location=1,IF($G49<5,tables!D$21,IF($G49>100,tables!D$32,FORECAST($G49,OFFSET(tables!D$21:D$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!D$36,IF($G49>100,tables!D$47,FORECAST($G49,OFFSET(tables!D$36:D$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.68090000000000006},{"$f":"IF(location=1,IF($G49<5,tables!E$21,IF($G49>100,tables!E$32,FORECAST($G49,OFFSET(tables!E$21:E$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!E$36,IF($G49>100,tables!E$47,FORECAST($G49,OFFSET(tables!E$36:E$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.83044999999999991},{"$f":"IF(location=1,IF($G49<5,tables!F$21,IF($G49>100,tables!F$32,FORECAST($G49,OFFSET(tables!F$21:F$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!F$36,IF($G49>100,tables!F$47,FORECAST($G49,OFFSET(tables!F$36:F$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.91044999999999998},{"$f":"IF(location=1,IF($G49<5,tables!G$21,IF($G49>100,tables!G$32,FORECAST($G49,OFFSET(tables!G$21:G$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!G$36,IF($G49>100,tables!G$47,FORECAST($G49,OFFSET(tables!G$36:G$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":0.97},{"$f":"IF(location=1,IF($G49<5,tables!H$21,IF($G49>100,tables!H$32,FORECAST($G49,OFFSET(tables!H$21:H$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!H$36,IF($G49>100,tables!H$47,FORECAST($G49,OFFSET(tables!H$36:H$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.02955},{"$f":"IF(location=1,IF($G49<5,tables!I$21,IF($G49>100,tables!I$32,FORECAST($G49,OFFSET(tables!I$21:I$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!I$36,IF($G49>100,tables!I$47,FORECAST($G49,OFFSET(tables!I$36:I$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.21865},{"$f":"IF(location=1,IF($G49<5,tables!J$21,IF($G49>100,tables!J$32,FORECAST($G49,OFFSET(tables!J$21:J$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!J$36,IF($G49>100,tables!J$47,FORECAST($G49,OFFSET(tables!J$36:J$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.4181999999999999},{"$f":"IF(location=1,IF($G49<5,tables!K$21,IF($G49>100,tables!K$32,FORECAST($G49,OFFSET(tables!K$21:K$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!K$36,IF($G49>100,tables!K$47,FORECAST($G49,OFFSET(tables!K$36:K$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.511233333333333},{"$f":"IF(location=1,IF($G49<5,tables!L$21,IF($G49>100,tables!L$32,FORECAST($G49,OFFSET(tables!L$21:L$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!L$36,IF($G49>100,tables!L$47,FORECAST($G49,OFFSET(tables!L$36:L$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.6973},{"$f":"IF(location=1,IF($G49<5,tables!M$21,IF($G49>100,tables!M$32,FORECAST($G49,OFFSET(tables!M$21:M$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2),OFFSET(tables!$C$21:$C$32,MATCH($G49,tables!$C$21:$C$32,1)-1,0,2)))),IF($G49<5,tables!M$36,IF($G49>100,tables!M$47,FORECAST($G49,OFFSET(tables!M$36:M$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2),OFFSET(tables!$C$36:$C$47,MATCH($G49,tables!$C$36:$C$47,1)-1,0,2)))))","v":1.9663999999999997}]
[null,null,1440,null,{"$f":"IF(rr<0.12,tables!M5,IF(rr>=0.45,tables!M16,FORECAST($M$23,OFFSET(tables!M5:M16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2),OFFSET(tables!$C$5:$C$16,MATCH($M$23,tables!$C$5:$C$16,1)-1,0,2))))","v":2.0299999999999998},null,{"$f":"E49*15","v":30.449999999999996},null,1.21865,48.240260249999999,null,14.472078075000001,null,1.6973,67.187620499999994,null,20.156286149999996,null,1.9663999999999997,77.839943999999988,null,23.351983199999999,null,{"$f":"IF(AND(type=3,subtype=1),W*(PI()*(L/2)^2*binf+2*PI()*(L/2)*0.5*1.25)*(inf*C49*60),IF(AND(type=3,subtype=2),W*(L^2*binf+0.5*L*1.25*4)*(inf*C49*60),(L*W*binf+0.5*1.25*(2*L+2*W))*(inf*C49*60)))","v":47.267186908031142},null,0,null,null,null,null,null,null,null,null,null,null,null,"M20-D"]
[null,null,"* Z2 is growth factor from M5 rainfalls",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,"M30-D"]
[null,null,{"$f":"IF(AN30=1,\"Invalid measurements. Click the grey question mark below to see what measurements are required. Also refer to BRE 365 for details.\",\"\")","v":""},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,"M50-D"]
[null,null,"SOAKAGE TRIAL PIT INFILTRATION TEST RESULTS",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,"M100-D"]
[null,null,"water level measurement No:",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,null,null,null,null,null,null,null,null,"selected:",null,{"$f":"MATCH(I37,AL42:AL52,0)","v":7},{"$f":"MATCH(N37,AL42:AL52,0)","v":10},{"$f":"MATCH(S37,AL42:AL52,0)","v":11}]
[null,null,"Soakage Trial 1",null,"time [min] =",null,null,null,0,11,25,44,80,102,150,190,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,1,2,3]
[null,null,null,null,"depth to water [m] =",null,null,null,1,1.38,1.7,1.6,2,2.13,2.4,2.5,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,{"$f":"IF($AL$57=MIN(I55:AA55),INDEX(I54:AA54,1,MATCH($AL$57,(I55:AA55),0)),FORECAST($AL$57,OFFSET(I54:AA54,0,MATCH($AL$57,I55:AA55,1)-1,1,2),OFFSET(I55:AA55,0,MATCH($AL$57,I55:AA55,1)-1,1,2)))","v":10.85526315789474},{"$f":"IF($AL$57=MIN(I57:AA57),INDEX(I56:AA56,1,MATCH($AL$57,(I57:AA57),0)),FORECAST($AL$57,OFFSET(I56:AA56,0,MATCH($AL$57,I57:AA57,1)-1,1,2),OFFSET(I57:AA57,0,MATCH($AL$57,I57:AA57,1)-1,1,2)))","v":{"$error":"#N/A"}},{"$f":"IF($AL$57=MIN(I59:AA59),INDEX(I58:AA58,1,MATCH($AL$57,(I59:AA59),0)),FORECAST($AL$57,OFFSET(I58:AA58,0,MATCH($AL$57,I59:AA59,1)-1,1,2),OFFSET(I59:AA59,0,MATCH($AL$57,I59:AA59,1)-1,1,2)))","v":{"$error":"#N/A"}}]
[null,null,"Soakage Trial 2",null,"time [min] =",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,"ap50",{"$f":"Lt*Wt+0.5*(Lt*Dteff*2+Wt*Dteff*2)","v":7.5},null,null,null,null,{"$f":"IF($AL$58=MAX(I55:AA55),INDEX(I54:AA54,1,MATCH($AL$58,(I55:AA55),0)),FORECAST($AL$58,OFFSET(I54:AA54,0,MATCH($AL$58,I55:AA55,1)-1,1,2),OFFSET(I55:AA55,0,MATCH($AL$58,I55:AA55,1)-1,1,2)))","v":101.15384615384619},{"$f":"IF($AL$58=MAX(I57:AA57),INDEX(I56:AA56,1,MATCH($AL$58,(I57:AA57),0)),FORECAST($AL$58,OFFSET(I56:AA56,0,MATCH($AL$58,I57:AA57,1)-1,1,2),OFFSET(I57:AA57,0,MATCH($AL$58,I57:AA57,1)-1,1,2)))","v":{"$error":"#N/A"}},{"$f":"IF($AL$58=MAX(I59:AA59),INDEX(I58:AA58,1,MATCH($AL$58,(I59:AA59),0)),FORECAST($AL$58,OFFSET(I58:AA58,0,MATCH($AL$58,I59:AA59,1)-1,1,2),OFFSET(I59:AA59,0,MATCH($AL$58,I59:AA59,1)-1,1,2)))","v":{"$error":"#N/A"}}]
[null,null,null,null,"depth to water [m] =",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,"h75",{"$f":"25%*Dteff","v":0.375},{"$f":"AK57+Dtp","v":1.375},null,"t@75"]
[null,null,"Soakage Trial 3",null,"time [min] =",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,"h25",{"$f":"75%*Dteff","v":1.125},{"$f":"AK58+Dtp","v":2.125},null,"t@25","tp75-25",{"$f":"IF(AND(SUM(I54:AA54)>0,SUM(I55:AA55)>0),AP56-AP55,1440)","v":90.298582995951449},{"$f":"IF(AND(SUM(I56:AA56)>0,SUM(I57:AA57)>0),AQ56-AQ55,1440)","v":1440},{"$f":"IF(AND(SUM(I58:AA58)>0,SUM(I59:AA59)>0),AR56-AR55,1440)","v":1440}]
[null,null,null,null,"depth to water [m] =",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,"Vp75-25",{"$f":"(AL58-AL57)*Lt*Wt*_vol2/100","v":1.7999999999999998},null,null,null,"f",{"$f":"IF(AND(SUM(I54:AA54)>0,SUM(I55:AA55)>0),$AK$59/($AK$56*AP58*60),1)","v":4.4297483607016737E-5},{"$f":"IF(AND(SUM(I56:AA56)>0,SUM(I57:AA57)>0),$AK$59/($AK$56*AQ58*60),1)","v":1},{"$f":"IF(AND(SUM(I58:AA58)>0,SUM(I59:AA59)>0),$AK$59/($AK$56*AR58*60),1)","v":1},{"$f":"MIN(AP59:AR59)","v":4.4297483607016737E-5}]
[]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"calculations are based on BRE Guidelines (Digest 365)"]

{"sheet":"from author","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,2,48,9],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[6,2,9,9],[12,2,30,9],[34,2,37,9]]}
[null,"Version: 1.3. - FREE LITE VERSION",null,null,null,null,null,null,null,null,"© 2012-2019 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",null,null,null,"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",null,null,null,"info@yourspreadsheets.co.uk"]
[]
[]
[null,null,"General information:\nNOTE: This spreadsheet contains macros."]
[]
[]
[]
[]
[]
[null,null,"The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. \n\nIn no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage.\n\nThis spreadsheet is a freeware and can be distributed freely but only in its original form.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowable.\n\nBy using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet.\n\nDamian Janicki"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This is a Free Lite Version. The full version of the spreadsheet allows to:\n- Input your company information, change logo and change header information;\n- Change rainfall return period 'R';\n- Change soakaway pit depth."]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on BRE Guidelines (Digest 365 2007).\n\nChangelog:\n20.06.2019 - v.1.3. - added pop-up messages and diagrams to explain levels in soakage trial pit and how to make measurements during infiltration test. It is now easier to find the option to design soakaways from modular geocellular units.\n20.10.2012 - v.1.2. - moved all calculations to one worksheet.\n20.10.2011 - v.1.1. - official release of the spreadsheets."]

{"sheet":"tables","index":2,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":true,"merged":[[47,3,47,12],[4,1,15,1],[2,3,2,12],[20,1,29,1],[32,3,32,12],[35,1,44,1]]}
[]
[null,"Values of Factor Z1 for rainfall duration D and ratio r (for 5y return period)"]
[null,null,null,"rainfall duration D (min)"]
[null,null,null,5,10,15,30,60,120,240,360,600,1440]
[null,"rainfall ratio r",0.12,0.22,0.34,0.45,0.67,1,1.48,2.17,2.75,3.7,6]
[null,null,0.15,0.25,0.38,0.48,0.69,1,1.42,2.02,2.46,3.23,4.9000000000000004]
[null,null,0.18,0.27,0.41,0.51,0.71,1,1.36,1.86,2.25,2.86,4.3]
[null,null,0.21,0.28999999999999998,0.43,0.54,0.73,1,1.33,1.77,2.12,2.62,3.6]
[null,null,0.24,0.31,0.46,0.56000000000000005,0.75,1,1.3,1.71,2,2.4,3.35]
[null,null,0.27,0.33,0.48,0.57999999999999996,0.76,1,1.27,1.64,1.88,2.2400000000000002,3.1]
[null,null,0.3,0.34,0.49,0.59,0.77,1,1.25,1.57,1.78,2.12,2.84]
[null,null,0.33,0.35,0.5,0.61,0.78,1,1.23,1.53,1.73,2.04,2.6]
[null,null,0.36,0.36,0.51,0.62,0.79,1,1.22,1.48,1.67,1.9,2.42]
[null,null,0.39,0.37,0.52,0.63,0.8,1,1.21,1.46,1.62,1.82,2.2799999999999998]
[null,null,0.42,0.38,0.53,0.64,0.81,1,1.2,1.42,1.57,1.74,2.16]
[null,null,0.45,0.39,0.54,0.65,0.82,1,1.19,1.38,1.51,1.68,2.0299999999999998]
[]
[]
[null,"Growth factor Z2 for M?? rainfalls from M5 rainfalls",null,null,null,null,null,null,10,20,30,50,100]
[null,null,null,"M1","M2","M3","M4","M5","M10","M20","M30","M50","M100"]
[null,"M5 rainfall (mm)",5,0.62,0.79,0.89,0.97,1.02,1.19,1.36,{"$f":"(L21-J21)/3+J21","v":1.4266666666666667},1.56,1.79]
[null,null,10,0.61,0.79,0.9,0.97,1.03,1.22,1.41,{"$f":"(L22-J22)/3+J22","v":1.49},1.65,1.91]
[null,null,15,0.62,0.8,0.9,0.97,1.03,1.24,1.44,1.5266666666666666,1.7,1.99]
[null,null,20,0.64,0.81,0.9,0.97,1.03,1.24,1.45,1.5433333333333332,1.73,2.0299999999999998]
[null,null,25,0.66,0.82,0.91,0.97,1.03,1.24,1.44,1.5333333333333332,1.72,2.0099999999999998]
[null,null,30,0.68,0.83,0.91,0.97,1.03,1.22,1.42,1.5133333333333332,1.7,1.97]
[null,null,40,0.7,0.84,0.92,0.97,1.02,1.19,1.38,1.4666666666666666,1.64,1.89]
[null,null,50,0.72,0.85,0.93,0.98,1.02,1.17,1.34,1.4200000000000002,1.58,1.81]
[null,null,75,0.76,0.87,0.93,0.98,1.02,1.1399999999999999,1.28,1.3433333333333333,1.47,1.64]
[null,null,100,0.78,0.88,0.94,0.98,1.02,1.1299999999999999,1.25,1.3,1.4,1.54]
[null,null,150,0.78,0.88,0.94,0.98,1.01,1.1200000000000001,1.21,1.25,1.33,1.45]
[null,null,200,0.78,0.88,0.94,0.98,1.01,1.1100000000000001,1.19,1.2266666666666666,1.3,1.4]
[null,null,null,"England & Wales"]
[]
[null,null,null,"M1","M2","M3","M4","M5","M10","M20","M30","M50","M100"]
[null,"M5 rainfall (mm)",5,0.67,0.82,0.91,0.98,1.02,1.17,1.35,{"$f":"(L36-J36)/3+J36","v":1.4400000000000002},1.62,1.86]
[null,null,10,0.68,0.82,0.91,0.98,1.03,1.19,1.39,{"$f":"(L37-J37)/3+J37","v":1.49},1.69,1.97]
[null,null,15,0.69,0.83,0.91,0.97,1.03,1.2,1.39,1.4933333333333332,1.7,1.98]
[null,null,20,0.7,0.84,0.92,0.97,1.02,1.19,1.38,1.4733333333333332,1.66,1.93]
[null,null,25,0.71,0.84,0.92,0.98,1.02,1.18,1.37,1.46,1.64,1.89]
[null,null,30,0.72,0.85,0.92,0.98,1.02,1.18,1.36,1.4433333333333334,1.61,1.85]
[null,null,40,0.74,0.86,0.93,0.98,1.02,1.17,1.34,1.4133333333333333,1.56,1.77]
[null,null,50,0.75,0.87,0.93,0.98,1.02,1.1599999999999999,1.3,1.3733333333333333,1.52,1.72]
[null,null,75,0.77,0.88,0.94,0.98,1.02,1.1399999999999999,1.27,1.33,1.45,1.62]
[null,null,100,0.78,0.88,0.94,0.98,1.02,1.1299999999999999,1.24,1.2933333333333332,1.4,1.54]
[null,null,150,0.79,0.89,0.94,0.98,1.02,1.1100000000000001,1.2,1.2433333333333334,1.33,1.45]
[null,null,200,0.8,0.89,0.95,0.99,1.01,1.1000000000000001,1.18,1.22,1.3,1.4]
[null,null,null,"Scotland and N Ireland"]