{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INFO (VERSION)","BASIN SELECTION","BASIN SIZING - TYPE A","BASIN SIZING - TYPE B","BASIN SIZING - TYPE D","BASIN TABLES"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":3,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INFO (VERSION)","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,0,20,10],[21,0,21,10],[23,0,28,10],[0,0,0,9],[2,0,6,10],[7,0,8,10],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9]]}
["SPREADSHEET INFORMATION"]
[]
["This spreadsheet has been produced as a sediment basin sizing tool. Although all care has been taken to ensure formulas and code are correct in the spreadsheet, Topo does not take any responsibility for any errors in this spreadsheet or works that have been designed using this tool."]
[]
[]
[]
[]
["Topo will aim to release revisions to this spreadsheet as necessary to ensure continual improvement and we welcome feedback to make this design tool better and more user friendly. Please ensure you are on the Topo mailing list to receive these updates"]
[]
[]
[null,"Version","Comments"]
[null,"V1","First Version for Public Release"]
[null,"V2","Updated based on new design procedure in 2018 Appendix B release"]
[null,"V3","Type A empty scour check calculation revised"]
[]
["Topo is a specialist consulting group that is recognised as leaders in the field of erosion and sediment control. We focus on educating our clients and industry and hence we offer this design tool to the public. We hope this assists you in designing sediment basins and encourages industry to achieve better outcomes.\n\nKyle Robson, our Managing Director, was heavily involved in the revision to Appendix B and has been leading the charge in adoption of High Efficiency Sediment basins in Australia (or as they call them, sediment ponds in New Zealand)."]
[]
[]
[]
[]
[]
["If you would like to know more about us, please visit http://www.topo.com.au or feel free to get in contact."]
[]
["The Topo Team"]

{"sheet":"BASIN SELECTION","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,15]]}
["SEDIMENT BASIN SELECTION"]

{"sheet":"BASIN SIZING - TYPE A","index":2,"n_rows":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,29,2,33],[2,24,2,28],[0,0,0,33]]}
["  TYPE A SEDIMENT BASIN SIZING"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEDIMENT STORAGE",null,null,null,null,"APPROX. DIMENSIONS"]
[null,"BASIN ID","CATCH AREA \n(HA)","BATTERS \n(1 IN X)","L:W RATIO","SETTLING DEPTH\nDS\n(m)","DESIGN EVENT (ARI)","IX yr, 24 hr\n(mm/hr)","JAR TEST SETTLE AFTER 15 MINUTES (mm)","QA\nOPTIMUM\n(L/s/ha)","QA SELECTED\n(L/s/ha)","MINIMUM Vs\n(m3)","MINIMUM\nAs\n(m2)","GOVERN FACTOR","ACTUAL VS\n(m3)","DFW\n(m)","MANUAL DFW (m)","DECANT NUMBER OF HOLES","DECANT HOLE DIAMETER (mm)","NUMBER OF DECANTS REQUIRED FOR QA SELECTED","NUMBER OF DECANTS ENGAGED AT EMPTY","NUMBER OF DECANTS ENGAGED AT FULL","EMPTY SCOUR CHECK","FULL SCOUR CHECK","SED STORAGE OPTION?","RUSLE SOIL LOSS (t/ha/yr)","CLEAN OUT FREQUENCY (MONTHS)","MIN SED. STORAGE VOLUME (m3)","APPROX. REQ SED STORAGE DEPTH (m)","APPROX. LENGTH AT SPILLWAY (m)","APPROX. WIDTH AT SPILLWAY (m)","APPROX. DEPTH AT SPILLWAY (m)","SETTLING VOLUME  (m3)","APPROX. TOTAL VOLUME AT SPILLWAY (m3)",null,"K","KS","QL\n(m3/s/ha)","DECANT ARM FLOW\n(L/s)","EMPTY VELOCITY (cm/s)","FULL VELOCITY (cm/s)"]
[null,null,null,null,null,null,null,null,100,{"$f":"IF(G5=1,0.8*H5^1.08/(AK5*MAX(F5,0.1))^0.6*1000,1.1*H5^1.12/(AK5*MAX(F5,0.1))^0.62*1000)","v":0},9,{"$f":"AJ5*C5*H5^1.8","v":0},{"$f":"VLOOKUP(I5,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL5","v":0},{"$f":"IF(M5*F5<L5,\"VOLUME\",\"AREA\")","v":"AREA"},{"$f":"IF(N5=\"volume\",L5,M5*F5)","v":0},{"$f":"MAX(0.2,0.1*L5/(MAX(0.1,(AD5-D5*F5)*(AE5-D5*F5))))","v":0.2},null,200,10,{"$f":"K5/AM5*C5","v":0},1,{"$f":"T5","v":0},{"$f":"IF(AN5>1.5, \"NOT OK\",\"OK\")","v":"OK"},{"$f":"IF(AO5>1.5,\"NOT OK\",\"OK\")","v":"OK"},null,null,null,{"$f":"IF(Y5=\"30% VSET\",O5*0.3,Z5*AA5/12*C5*0.8)","v":0},{"$f":"IF(AD5=0,0,MAX(ROUND(AB5/((AD5-(D5+MAX(P5,Q5))*2*F5)*(AE5-(D5+MAX(P5,Q5))*2*F5)),1),0.2))","v":0},{"$f":"AE5*E5","v":0},{"$f":"SQRT((MAX(M5,L5/MAX(F5,0.1)))/MAX(E5,0.1))+F5*D5","v":0},{"$f":"AC5+F5+MAX(P5,Q5)","v":0.2},{"$f":"O5","v":0},{"$f":"AB5+O5+(AD5-2*D5*F5-MAX(P5,Q5)/2)*(AE5-2*D5*F5-MAX(P5,Q5)/2)*MAX(P5,Q5)","v":2.0000000000000005E-3},null,{"$f":"IF('BASIN SIZING - TYPE A'!G5=1,VLOOKUP(K5,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K5,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I5,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},{"$f":"K5*C5/1000","v":0},{"$f":"VLOOKUP(S5,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R5","v":4.5},{"$f":"AM5/MAX(P5,Q5)/2/1000*100","v":1.125},{"$f":"AM5/0.6/2/1000*100","v":0.375}]
[null,null,null,null,null,null,null,null,100,{"$f":"IF(G6=1,0.8*H6^1.08/(AK6*MAX(F6,0.1))^0.6*1000,1.1*H6^1.12/(AK6*MAX(F6,0.1))^0.62*1000)","v":0},9,{"$f":"AJ6*C6*H6^1.8","v":0},{"$f":"VLOOKUP(I6,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL6","v":0},{"$f":"IF(M6*F6<L6,\"VOLUME\",\"AREA\")","v":"AREA"},{"$f":"IF(N6=\"volume\",L6,M6*F6)","v":0},{"$f":"MAX(0.2,0.1*L6/(MAX(0.1,(AD6-D6*F6)*(AE6-D6*F6))))","v":0.2},null,200,10,{"$f":"K6/AM6*C6","v":0},1,{"$f":"T6","v":0},{"$f":"IF(AN6>1.5, \"NOT OK\",\"OK\")","v":"OK"},{"$f":"IF(AO6>1.5,\"NOT OK\",\"OK\")","v":"OK"},null,null,null,{"$f":"IF(Y6=\"30% VSET\",O6*0.3,Z6*AA6/12*C6*0.8)","v":0},{"$f":"IF(AD6=0,0,MAX(ROUND(AB6/((AD6-(D6+MAX(P6,Q6))*2*F6)*(AE6-(D6+MAX(P6,Q6))*2*F6)),1),0.2))","v":0},{"$f":"AE6*E6","v":0},{"$f":"SQRT((MAX(M6,L6/MAX(F6,0.1)))/MAX(E6,0.1))+F6*D6","v":0},{"$f":"AC6+F6+MAX(P6,Q6)","v":0.2},{"$f":"O6","v":0},{"$f":"AB6+O6+(AD6-2*D6*F6-MAX(P6,Q6)/2)*(AE6-2*D6*F6-MAX(P6,Q6)/2)*MAX(P6,Q6)","v":2.0000000000000005E-3},null,{"$f":"IF('BASIN SIZING - TYPE A'!G6=1,VLOOKUP(K6,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K6,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I6,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S6,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R6","v":4.5},{"$f":"AM6/MAX(P6,Q6)/2/1000*100","v":1.125},{"$f":"AM6/0.6/2/1000*100","v":0.375}]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I7,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL7","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G7=1,VLOOKUP(K7,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K7,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I7,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S7,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R7","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I8,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL8","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G8=1,VLOOKUP(K8,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K8,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I8,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S8,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R8","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I9,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL9","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G9=1,VLOOKUP(K9,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K9,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I9,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S9,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R9","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I10,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL10","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G10=1,VLOOKUP(K10,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K10,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I10,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S10,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R10","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I11,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL11","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G11=1,VLOOKUP(K11,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K11,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I11,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S11,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R11","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I12,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL12","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G12=1,VLOOKUP(K12,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K12,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I12,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S12,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R12","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I13,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL13","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G13=1,VLOOKUP(K13,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K13,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I13,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S13,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R13","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I14,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL14","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G14=1,VLOOKUP(K14,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K14,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I14,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S14,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R14","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I15,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL15","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G15=1,VLOOKUP(K15,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K15,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I15,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S15,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R15","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I16,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL16","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G16=1,VLOOKUP(K16,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K16,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I16,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S16,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R16","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I17,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL17","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G17=1,VLOOKUP(K17,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K17,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I17,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S17,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R17","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I18,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL18","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G18=1,VLOOKUP(K18,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K18,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I18,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S18,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R18","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I19,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL19","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G19=1,VLOOKUP(K19,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K19,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I19,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S19,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R19","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I20,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL20","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G20=1,VLOOKUP(K20,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K20,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I20,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S20,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R20","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I21,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL21","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G21=1,VLOOKUP(K21,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K21,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I21,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S21,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R21","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I22,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL22","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G22=1,VLOOKUP(K22,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K22,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I22,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S22,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R22","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I23,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL23","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G23=1,VLOOKUP(K23,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K23,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I23,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S23,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R23","v":4.5},1.125,0.375]
[null,null,null,null,null,null,null,null,100,0,9,0,{"$f":"VLOOKUP(I24,'BASIN TABLES'!$K$3:$L$8,2,FALSE)*AL24","v":0},"AREA",0,0.2,null,200,10,0,1,0,"OK","OK",null,null,null,0,0,0,0,0.2,0,2.0000000000000005E-3,null,{"$f":"IF('BASIN SIZING - TYPE A'!G24=1,VLOOKUP(K24,'BASIN TABLES'!$D$4:$E$33,2,FALSE), VLOOKUP(K24,'BASIN TABLES'!$D$4:$F$33,3,FALSE))","v":19.3},{"$f":"VLOOKUP(I24,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0,{"$f":"VLOOKUP(S24,'BASIN TABLES'!$R$3:$S$18,2,FALSE)*R24","v":4.5},1.125,0.375]

{"sheet":"BASIN SIZING - TYPE B","index":3,"n_rows":24,"n_cols":28,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,21],[2,20,2,24],[2,15,2,19]]}
["   TYPE B SEDIMENT BASIN SIZING - OPTION 2B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEDIMENT STORAGE",null,null,null,null,"APPROX. DIMENSIONS"]
[null,"BASIN ID","CATCH AREA \n(HA)","BATTERS \n(1 IN X)","L:W RATIO"," SETTLING DEPTH \nDS\n(m)","C1","TIME OF CONC (MINS)","I1\n(mm/hr)","0.5Q1 (m3/s)","JAR TEST SETTLE AFTER 15 MINUTES (mm)","FLOC SETTLE DEPTH \nDF (m)","MINIMUM\nAs\n(m2)","ACTUAL VS\n(m3)","SCOUR CHECK","SED STORAGE OPTION?","RUSLE SOIL LOSS (t/ha/yr)","CLEAN OUT FREQUENCY (MONTHS)","MIN SED. STORAGE VOLUME (m3)","APPROX. REQ SED STORAGE DEPTH (m)","APPROX. LENGTH AT SPILLWAY (m)","APPROX. WIDTH AT SPILLWAY (m)","APPROX. DEPTH AT SPILLWAY (m)","SETTLING VOLUME  (m3)","TOTAL VOLUME AT SPILLWAY (m3)",null,"KS","SCOUR VELOCITY - TYPE B"]
[null,null,null,null,null,null,null,null,null,{"$f":"G5*I5*C5/360*0.5","v":0},100,0.6,{"$f":"(L5/MAX(F5,0.1))*AA5*J5","v":0},{"$f":"M5*F5","v":0},{"$f":"IF(AB5>0.015,\"NOT OK\",\"OK\")","v":"OK"},null,null,null,{"$f":"IF(P5=\"30% VSET\",0.3*N5,Q5*R5/12*C5*0.8)","v":0},{"$f":"IF(U5=0,0,MAX(ROUND(S5/((U5-D5*2*F5)*(V5-D5*2*F5)),1),0.2))","v":0},{"$f":"V5*E5","v":0},{"$f":"SQRT(M5/MAX(E5,0.1))+F5*D5","v":0},{"$f":"T5+F5","v":0},{"$f":"N5","v":0},{"$f":"S5+N5","v":0},null,{"$f":"VLOOKUP(K5,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},{"$f":"J5/MAX(((V5-L5*D5)*L5),0.01)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G6*I6*C6/360*0.5","v":0},100,0.6,{"$f":"(L6/MAX(F6,0.1))*AA6*J6","v":0},{"$f":"M6*F6","v":0},{"$f":"IF(AB6>0.015,\"NOT OK\",\"OK\")","v":"OK"},null,null,null,{"$f":"IF(P6=\"30% VSET\",0.3*N6,Q6*R6/12*C6*0.8)","v":0},{"$f":"IF(U6=0,0,MAX(ROUND(S6/((U6-D6*2*F6)*(V6-D6*2*F6)),1),0.2))","v":0},{"$f":"V6*E6","v":0},{"$f":"SQRT(M6/MAX(E6,0.1))+F6*D6","v":0},{"$f":"T6+F6","v":0},{"$f":"N6","v":0},{"$f":"S6+N6","v":0},null,{"$f":"VLOOKUP(K6,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},{"$f":"J6/MAX(((V6-L6*D6)*L6),0.01)","v":0}]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K7,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K8,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K9,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K10,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K11,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K12,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K13,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K14,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K15,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K16,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K17,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K18,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K19,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K20,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K21,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K22,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K23,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]
[null,null,null,null,null,null,null,null,null,0,100,0.6,0,0,"OK",null,null,null,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(K24,'BASIN TABLES'!$K$3:$L$8,2,FALSE)","v":12000},0]

{"sheet":"BASIN SIZING - TYPE D","index":4,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,15],[2,15,2,19],[2,10,2,14]]}
["   TYPE D SEDIMENT BASIN SIZING"]
[null,"NOTE - TYPE D BASINS ARE UNLIKELY TO COMPLY WITH QLD STATE PLANNING POLICY"]
[null,null,null,null,null,null,null,null,null,null,"SEDIMENT STORAGE",null,null,null,null,"APPROX. DIMENSIONS"]
[null,"BASIN ID","CATCH AREA \n(HA)","BATTERS \n(1 IN X)","L:W RATIO","SETTLING DEPTH\nDS\n(m)","%ILE","R (5 DAY, X%ILE)","CV","VSET","SED STORAGE OPTION?","RUSLE SOIL LOSS (t/ha/yr)","CLEAN OUT FREQUENCY (MONTHS)","VSS","APPROX. REQ SED STORAGE DEPTH (m)","APPROX. LENGTH AT SPILLWAY (m)","APPROX. WIDTH AT SPILLWAY (m)","APPROX. DEPTH AT SPILLWAY (m)","SETTLING VOLUME  (m3)","TOTAL VOLUME AT SPILLWAY (m3)"]
[null,null,null,null,null,null,null,null,null,{"$f":"10*I5*C5*H5","v":0},null,null,null,{"$f":"IF(K5=\"50% VSET\",0.5*J5,L5*0.8*C5*M5/12)","v":0},{"$f":"IF(P5=0,0,ROUND(N5/((P5-D5*2*F5)*(Q5-D5*2*F5)),1))","v":0},{"$f":"Q5*E5","v":0},{"$f":"IF(E5=0,0,IF(F5=0,0,SQRT(J5/F5/E5)+F5*D5))","v":0},{"$f":"F5+O5","v":0},{"$f":"J5","v":0},{"$f":"N5+J5","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(K6=\"50% VSET\",0.5*J6,L6*0.8*C6*M6/12)","v":0},{"$f":"IF(P6=0,0,ROUND(N6/((P6-D6*2*F6)*(Q6-D6*2*F6)),1))","v":0},{"$f":"Q6*E6","v":0},{"$f":"IF(E6=0,0,IF(F6=0,0,SQRT(J6/F6/E6)+F6*D6))","v":0},{"$f":"F6+O6","v":0},{"$f":"J6","v":0},{"$f":"N6+J6","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(K7=\"50% VSET\",0.5*J7,L7*0.8*C7*M7/12)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(K8=\"50% VSET\",0.5*J8,L8*0.8*C8*M8/12)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,0,0,0,0]

{"sheet":"BASIN TABLES","index":5,"n_rows":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,4,1,5],[1,3,2,3]]}
["TABLE B10 - DESIGN EVENT",null,null,"TABLE B11 - K",null,null,null,"TABLE B12 - KS",null,null,"TABLE B14",null,null,null,null,null,null,"DECANT SIZING"]
["DESIGN EVENT",null,null,"LOW FLOW DECANT RATE","K",null,null,"POND WATER TEMP","KS",null,"JAR TEST SETTLEMENT","KS",null,"%ILE",null,"TYPE D SED STORAGE",null,"DECANT DIAMETER","FLOW RATE",null,"TYPE A/B SED STORAGE"]
[1,"SHORT-TERM",null,null,1,5,null,5,16890,null,50,24000,null,75,null,"50% VSET",null,10,{"$f":"4.5/200","v":2.2499999999999999E-2},null,"30% VSET"]
[5,"LONG-TERM",null,1,{"$f":"0.684*(D4/1000)^-0.675","v":72.45295480212657},{"$f":"1.159*(D4/1000)^-0.604","v":75.176730848240837},null,10,14520,null,75,16000,null,80,null,"RUSLE",null,11,{"$f":"$S$3*(R4^2/$R$3^2)","v":2.7224999999999999E-2},null,"RUSLE"]
[null,null,null,2,45,46.9,null,15,12670,null,100,12000,null,85,null,null,null,12,{"$f":"$S$3*(R5^2/$R$3^2)","v":3.2399999999999998E-2}]
[null,null,null,3,34.5,39.5,null,20,11150,null,150,8000,null,90,null,null,null,13,3.8024999999999996E-2]
[null,null,null,4,28.4,33.9,null,25,9930,null,200,6000,null,95,null,null,null,14,4.41E-2]
[null,null,null,5,{"$f":"0.684*(D8/1000)^-0.675","v":24.448451022727863},{"$f":"1.159*(D8/1000)^-0.604","v":28.438425855937986},null,30,8900,null,300,4000,null,null,null,null,null,15,5.0624999999999996E-2]
[null,null,null,6,22.7,26,null,null,null,null,null,null,null,null,null,null,null,16,5.7599999999999998E-2]
[null,null,null,7,19.481164999741729,23.208347565942741,null,null,null,null,null,null,null,null,null,null,null,17,6.5024999999999999E-2]
[null,null,null,8,17.600000000000001,20.9,null,null,null,null,null,null,null,null,null,null,null,18,7.2900000000000006E-2]
[null,null,null,9,16.2,19.3,null,null,null,null,null,null,null,null,null,null,null,19,8.1224999999999992E-2]
[null,null,null,10,15.312852587807445,18.710415673618964,null,null,null,null,null,null,null,null,null,null,null,20,0.09]
[null,null,null,11,14.358730333364567,17.663723348561803,null,null,null,null,null,null,null,null,null,null,null,21,9.9224999999999994E-2]
[null,null,null,12,13.53969123549648,16.759380584253513,null,null,null,null,null,null,null,null,null,null,null,22,0.1089]
[null,null,null,13,12.827568394268038,15.968409127547991,null,null,null,null,null,null,null,null,null,null,null,23,0.11902499999999999]
[null,null,null,14,12.201681309072749,15.269404581545871,null,null,null,null,null,null,null,null,null,null,null,24,0.12959999999999999]
[null,null,null,15,11.646475082573913,14.646178254009525,null,null,null,null,null,null,null,null,null,null,null,25,0.140625]
[null,null,null,16,11.150006316871234,14.086236200349623]
[null,null,null,17,10.702939728506779,13.57976603114065]
[null,null,null,18,10.297864208887596,13.118942932403918]
[null,null,null,19,9.9288150538875364,12.697442680478506]
[null,null,null,20,9.5909329453199206,12.310092564652605]
[null,null,null,21,9.2802158524514891,11.952616405483321]
[null,null,null,22,8.9933354361996827,11.621445148532798]
[null,null,null,23,8.7274990941215602,11.313574030495721]
[null,null,null,24,8.4803448603286071,11.026453389236641]
[null,null,null,25,8.249860327203379,10.757904155160633]
[null,null,null,26,8.0343193807591895,10.506051703999271]
[null,null,null,27,7.8322323175783701,10.269273544952835]
[null,null,null,28,7.6423061336500577,10.046157556562898]
[null,null,null,29,7.4634126299541821,9.8354683509988625]
[null,null,null,30,7.294562585631172,9.6361199649599456]