{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["I - CC 87+00 to 88+40 (L)","R- CC 87+00 to 88+40 (L)","I - CC 87+50 to 88+40 (R)","R- CC 87+50 to 88+40 (R)","Rainfall Intensity"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":128,"comments":0,"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":"I - CC 87+00 to 88+40 (L)","index":0,"n_rows":37,"n_cols":31,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,22],[15,0,15,4],[15,6,15,8],[15,9,15,11],[15,12,15,15],[15,16,15,19]]}
["Ditch Analysis Input Worksheet"]
["PID:",114496]
["Date",{"$f":"TODAY()","v":"2024-06-27"}]
["Project","Columbia Connector"]
["Location","Sta. 87+00 to 88+40 Left"]
["Designer","ZTM"]
["Checker","SNS"]
["Rainfall Area","C"]
["Depth Design Year",10]
["Shear Stress Design Year",5]
["Time to first section",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MACRO COLUMN (ctrl q)"]
["Pick up Flow:"]
[]
["Paved Gutter? (Y/N)","n"]
[]
[]
["Ref. No.","Begin","End","Side","Length","Shape","Begin","End","Grade","Radius/Width","Inslope (ft./ft.)","Backslope (ft./ft.)","Area (acres)","Coefficient","CA (sum)","Ditch Time","Ditch Time","Total (1)","Total (2)","Intensity (1)","Intensity (2)","Q (1)","Q (2)","Flow Depth (1)","Flow Depth (2)","Hydraulic Radius (1)","Hydraulic Radius (2)","Qi (1)","Qi (2)","Qi/Q (1)","Qi/Q (2)"]
[1,8700,8750,"L",{"$f":"C18-B18","v":50},"Trapazoidal",494.61,494.32,{"$f":"ROUND((G18-H18)/E18,4)","v":5.7999999999999996E-3},6,3,4,3.6999999999999998E-2,0.45,{"$f":"N18*M18","v":1.6649999999999998E-2},0,0,{"$f":"B11","v":10},{"$f":"B11","v":10},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.8202795627711961},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":5.3219361594781596},{"$f":"O18*T18+$B$12","v":8.0257654720140403E-2},{"$f":"O18*U18+$B$12","v":8.8610237055311347E-2},6.8824999999999983E-2,7.2324999999999973E-2,{"$f":"(X18*((J18+(J18+K18*X18+L18*X18))/2))/(J18+SQRT(X18^2+(X18*L18)^2)+SQRT(X18^2+(X18*K18)^2))","v":6.6066999688555547E-2},{"$f":"(Y18*((J18+(J18+K18*Y18+L18*Y18))/2))/(J18+SQRT(Y18^2+(Y18*L18)^2)+SQRT(Y18^2+(Y18*K18)^2))","v":6.9291257156361613E-2},{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q16*Z18*SQRT(I18)*X18*((J18+(J18+X18*K18+X18*L18))/2)","v":8.028787684256769E-2},{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q16*AA18*SQRT(I18)*Y18*((J18+(J18+Y18*K18+Y18*L18))/2)","v":8.8662031195295185E-2},{"$f":"AB18-V18","v":3.0222122427286946E-5},{"$f":"AC18-W18","v":5.1794139983837861E-5}]
[2,8750,8800,"L",{"$f":"C19-B19","v":50},"Trapazoidal",494.32,488.5,0.1164,11,2,4,6.4000000000000001E-2,0.5,{"$f":"O18+M19*N19","v":4.8649999999999999E-2},{"$f":"E18/(60*(V18/(X18*((J18+J18+X18*K18+X18*L18)/2))))","v":4.4598973527330399},{"$f":"E18/(60*(W18/(Y18*((J18+J18+Y18*K18+Y18*L18)/2))))","v":4.2532535810468861},{"$f":"R18+P19","v":14.459897352733041},14.253253581046886,{"$f":"IF($B$8=\"A\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.0774755593565901},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.582206118634363},{"$f":"O19*T19+$B$12","v":0.19836918596269809},0.22292432767156176,3.7762499999999991E-2,4.0024999999999991E-2,3.7336330592399859E-2,3.9546845855767412E-2,{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q17*Z19*SQRT(I19)*X19*((J19+(J19+X19*K19+X19*L19))/2)","v":0.19859587771077217},{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q17*AA19*SQRT(I19)*Y19*((J19+(J19+Y19*K19+Y19*L19))/2)","v":0.22309314009695372},{"$f":"AB19-V19","v":2.2669174807407599E-4},1.6881242539196206E-4]
[3,8800,8840,"L",40,"Trapazoidal",488.5,483.31,0.1298,11,2,4,0.04,0.68,{"$f":"O19+M20*N20","v":7.5850000000000001E-2},1.7629818074738053,1.6637970326966189,16.222879160206848,15.917050613743505,{"$f":"IF($B$8=\"A\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/($R$20+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/($R$20+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/($R$20+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/($R$20+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":3.84700809214424},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(S20+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(S20+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(S20+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(S20+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.3488636177926416},0.29179556378914062,0.32986130540957187,4.4624999999999984E-2,4.7424999999999981E-2,4.4032164271696358E-2,4.6756490138574226E-2,{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q18*Z20*SQRT(I20)*X20*((J20+(J20+X20*K20+X20*L20))/2)","v":0.29281327840106863},{"$f":"1.486/'R- CC 87+00 to 88+40 (L)'!Q18*AA20*SQRT(I20)*Y20*((J20+(J20+Y20*K20+Y20*L20))/2)","v":0.33068864261155617},1.0177146119280112E-3,8.2733720198430172E-4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"R- CC 87+00 to 88+40 (L)","index":1,"n_rows":114,"n_cols":23,"rows_kept":114,"cut":false,"hidden":false,"merged":[[12,0,12,4],[12,5,12,8],[12,9,12,12],[12,14,12,22],[0,0,0,22],[1,0,1,2],[1,8,2,9],[1,10,2,10],[1,11,2,11]]}
["Ditch Analysis"]
["PID:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B2","v":114496},null,null,null,null,"Ditch Lining",null,"Manning's \"n\"","Allowable Shear Stress"]
["Date:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B3","v":"2024-06-27"}]
["Project:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B4","v":"Columbia Connector"},null,null,null,null,"Seed",null,0.04,0.4]
["Location:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B5","v":"Sta. 87+00 to 88+40 Left"},null,null,null,null,"Jute Mat",null,0.04,0.45]
["Designer:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B6","v":"ZTM"},null,null,null,null,"Temporary Mat",null,0.04,1]
["Checker:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B7","v":"SNS"},null,null,null,null,"Permanent Mat, Type 1",null,0.04,2]
["Rainfall Area:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B8","v":"C"},null,null,null,null,"Permanent Mat, Type 2",null,0.04,3]
["Depth Storm Frequency:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B9","v":10},null,null,null,null,"Permanent Mat, Type 3",null,0.04,5,null,"* Grade Steeper than Allowable"]
["Shear Stress Storm Frequency:",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B10","v":5},null,null,null,null,"RCP, Type B",null,0.06,6]
["Pickup Flow (cfs):",null,null,{"$f":"'I - CC 87+00 to 88+40 (L)'!B12","v":0}]
[]
["Station",null,null,null,null,"Dimension",null,null,null,"Rainfall",null,null,null,"Lining Type","Discharge"]
["Ref. No.","Begin","End","Side","Length (ft.)","Radius/Width (ft.)","Inslope (ft./ft.)","Backslope (ft./ft.)","Grade (ft./ft.)","Area (acres)","Total Area (acres)","Runoff Coefficient","CA (sum)","Protection Type","Intensity (in./hr.)","Storm Freq. (Yrs.)","Mann. Coef.","Time Flow (min.)","Velocity Flow (fps)","Shear (lbs./sq.ft)","Design Flow (cfs.)","Depth Flow (ft.)","Width Flow (ft.)"]
[{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", 'I - CC 87+00 to 88+40 (L)'!A18, \"\")","v":1},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!B18<>\"\", 'I - CC 87+00 to 88+40 (L)'!B18, \"\")","v":8700},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!C18<>\"\", 'I - CC 87+00 to 88+40 (L)'!C18, \"\")","v":8750},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!D18<>\"\", 'I - CC 87+00 to 88+40 (L)'!D18, \"\")","v":"L"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!E18<>\"\", 'I - CC 87+00 to 88+40 (L)'!E18, \"\")","v":50},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!J18<>\"\", 'I - CC 87+00 to 88+40 (L)'!J18, \"\")","v":6},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!K18<>\"\", 'I - CC 87+00 to 88+40 (L)'!K18, \"\")","v":3},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!L18<>\"\", 'I - CC 87+00 to 88+40 (L)'!L18, \"\")","v":4},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!I18<>\"\", IF('I - CC 87+00 to 88+40 (L)'!I18>0.2, 'I - CC 87+00 to 88+40 (L)'!I18&\"*\", 'I - CC 87+00 to 88+40 (L)'!I18), \"\")","v":5.7999999999999996E-3},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!M18<>\"\", 'I - CC 87+00 to 88+40 (L)'!M18, \"\")","v":3.6999999999999998E-2},{"$f":"IF(J15<>\"\",J15, \"\")","v":3.6999999999999998E-2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!N18<>\"\", 'I - CC 87+00 to 88+40 (L)'!N18, \"\")","v":0.45},{"$f":"IF(J15<>\"\", J15*L15, \"\")","v":1.6649999999999998E-2},{"$f":"IF(A15<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", \"Paved Gutter\",IF(T15<$L$4, $I$4, IF(T15<$L$5, $I$5, IF(T15<$L$6, $I$6, IF(T15<$L$7, $I$7, IF(T15<$L$8, $I$8, IF(T15<$L$9, $I$9, $I$10))))))), \"\")","v":"Seed"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", IF($D$8=\"A\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.8202795627711961},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", $D$10, \"\")","v":5},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N15, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", 'I - CC 87+00 to 88+40 (L)'!R18, \"\")","v":10},{"$f":"IF(A15<>\"\",U15/(V15*(F15+F15+G15*V15+H15*V15)/2),\"\")","v":0.18685033923990738},{"$f":"IF(A15<>\"\", 62.4*V15*'I - CC 87+00 to 88+40 (L)'!I18, \"\")","v":2.4909143999999991E-2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", 'I - CC 87+00 to 88+40 (L)'!V18, \"\")","v":8.0257654720140403E-2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X18<>\"\",'I - CC 87+00 to 88+40 (L)'!X18, \"\")","v":6.8824999999999983E-2},{"$f":"IF(A15<>\"\",F15+G15*V15+H15*V15, \"\")","v":6.4817749999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", IF($D$8=\"A\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":5.3219361594781596},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", $D$9, \"\")","v":10},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N15, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", 'I - CC 87+00 to 88+40 (L)'!S18, \"\")","v":10},{"$f":"IF(A15<>\"\",U16/(V16*(F15+F15+G15*V16+H15*V16)/2),\"\")","v":0.19592843865383136},{"$f":"IF(A15<>\"\", 62.4*V16*'I - CC 87+00 to 88+40 (L)'!I18, \"\")","v":2.6175863999999986E-2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A18<>\"\", 'I - CC 87+00 to 88+40 (L)'!W18, \"\")","v":8.8610237055311347E-2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X18<>\"\",'I - CC 87+00 to 88+40 (L)'!Y18, \"\")","v":7.2324999999999973E-2},{"$f":"IF(A15<>\"\",F15+G15*V16+H15*V16, \"\")","v":6.5062749999999996}]
[{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", 'I - CC 87+00 to 88+40 (L)'!A19, \"\")","v":2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!B19<>\"\", 'I - CC 87+00 to 88+40 (L)'!B19, \"\")","v":8750},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!C19<>\"\", 'I - CC 87+00 to 88+40 (L)'!C19, \"\")","v":8800},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!E19<>\"\", 'I - CC 87+00 to 88+40 (L)'!D19, \"\")","v":"L"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!F19<>\"\", 'I - CC 87+00 to 88+40 (L)'!E19, \"\")","v":50},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!J19<>\"\", 'I - CC 87+00 to 88+40 (L)'!J19, \"\")","v":11},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!K19<>\"\", 'I - CC 87+00 to 88+40 (L)'!K19, \"\")","v":2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!L19<>\"\", 'I - CC 87+00 to 88+40 (L)'!L19, \"\")","v":4},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!I19<>\"\", IF('I - CC 87+00 to 88+40 (L)'!I19>0.2, 'I - CC 87+00 to 88+40 (L)'!I19&\"*\", 'I - CC 87+00 to 88+40 (L)'!I19), \"\")","v":0.1164},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!M19<>\"\", 'I - CC 87+00 to 88+40 (L)'!M19, \"\")","v":6.4000000000000001E-2},{"$f":"IF(J17<>\"\",K15+J17, \"\")","v":0.10100000000000001},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!N19<>\"\", 'I - CC 87+00 to 88+40 (L)'!N19, \"\")","v":0.5},{"$f":"IF(J17<>\"\", M15+J17*L17, \"\")","v":4.8649999999999999E-2},{"$f":"IF(A17<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", \"Paved Gutter\",IF(T17<$L$4, $I$4, IF(T17<$L$5, $I$5, IF(T17<$L$6, $I$6, IF(T17<$L$7, $I$7, IF(T17<$L$8, $I$8, IF(T17<$L$9, $I$9, $I$10))))))), \"\")","v":"Seed"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", IF($D$8=\"A\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.0774755593565901},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", $D$10, \"\")","v":5},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N17, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", 'I - CC 87+00 to 88+40 (L)'!R19, \"\")","v":14.459897352733041},{"$f":"IF(A17<>\"\",U17/(V17*(F17+F17+G17*V17+H17*V17)/2),\"\")","v":0.47268402305717788},{"$f":"IF(A17<>\"\", 62.4*V17*'I - CC 87+00 to 88+40 (L)'!I19, \"\")","v":0.27428263199999992},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\",'I - CC 87+00 to 88+40 (L)'!V19, \"\")","v":0.19836918596269809},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X19<>\"\",'I - CC 87+00 to 88+40 (L)'!X19, \"\")","v":3.7762499999999991E-2},{"$f":"IF(A17<>\"\",F17+G17*V17+H17*V17, \"\")","v":11.226575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", IF($D$8=\"A\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.582206118634363},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", $D$9, \"\")","v":10},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N17, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", 'I - CC 87+00 to 88+40 (L)'!S19, \"\")","v":14.253253581046886},{"$f":"IF(A17<>\"\",U18/(V18*(F17+F17+G17*V18+H17*V18)/2),\"\")","v":0.50086237501139086},{"$f":"IF(A17<>\"\", 62.4*V18*'I - CC 87+00 to 88+40 (L)'!I19, \"\")","v":0.29071598399999998},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A19<>\"\", 'I - CC 87+00 to 88+40 (L)'!W19, \"\")","v":0.22292432767156176},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X19<>\"\",'I - CC 87+00 to 88+40 (L)'!Y19, \"\")","v":4.0024999999999991E-2},{"$f":"IF(A17<>\"\",F17+G17*V18+H17*V18, \"\")","v":11.24015}]
[{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", 'I - CC 87+00 to 88+40 (L)'!A20, \"\")","v":3},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!B20<>\"\", 'I - CC 87+00 to 88+40 (L)'!B20, \"\")","v":8800},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!C20<>\"\", 'I - CC 87+00 to 88+40 (L)'!C20, \"\")","v":8840},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!E20<>\"\", 'I - CC 87+00 to 88+40 (L)'!D20, \"\")","v":"L"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!F20<>\"\", 'I - CC 87+00 to 88+40 (L)'!E20, \"\")","v":40},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!J20<>\"\", 'I - CC 87+00 to 88+40 (L)'!J20, \"\")","v":11},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!K20<>\"\", 'I - CC 87+00 to 88+40 (L)'!K20, \"\")","v":2},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!L20<>\"\", 'I - CC 87+00 to 88+40 (L)'!L20, \"\")","v":4},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!I20<>\"\", IF('I - CC 87+00 to 88+40 (L)'!I20>0.2, 'I - CC 87+00 to 88+40 (L)'!I20&\"*\", 'I - CC 87+00 to 88+40 (L)'!I20), \"\")","v":0.1298},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!M20<>\"\", 'I - CC 87+00 to 88+40 (L)'!M20, \"\")","v":0.04},{"$f":"IF(J19<>\"\",K17+J19, \"\")","v":0.14100000000000001},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!N20<>\"\", 'I - CC 87+00 to 88+40 (L)'!N20, \"\")","v":0.68},{"$f":"IF(J19<>\"\", M17+J19*L19, \"\")","v":7.5850000000000001E-2},{"$f":"IF(A19<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", \"Paved Gutter\",IF(T19<$L$4, $I$4, IF(T19<$L$5, $I$5, IF(T19<$L$6, $I$6, IF(T19<$L$7, $I$7, IF(T19<$L$8, $I$8, IF(T19<$L$9, $I$9, $I$10))))))), \"\")","v":"Seed"},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", IF($D$8=\"A\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R19+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R19+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R19+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R19+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":3.84700809214424},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", $D$10, \"\")","v":5},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N19, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", 'I - CC 87+00 to 88+40 (L)'!R20, \"\")","v":16.222879160206848},{"$f":"IF(A19<>\"\",U19/(V19*(F19+F19+G19*V19+H19*V19)/2),\"\")","v":0.5872920401335644},{"$f":"IF(A19<>\"\", 62.4*V19*'I - CC 87+00 to 88+40 (L)'!I20, \"\")","v":0.36144107999999986},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", 'I - CC 87+00 to 88+40 (L)'!V20, \"\")","v":0.29179556378914062},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X20<>\"\",'I - CC 87+00 to 88+40 (L)'!X20, \"\")","v":4.4624999999999984E-2},{"$f":"IF(A19<>\"\",F19+G19*V19+H19*V19, \"\")","v":11.267749999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", IF($D$8=\"A\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R20+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R20+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R20+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R20+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.3488636177926416},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", $D$9, \"\")","v":10},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", IF('I - CC 87+00 to 88+40 (L)'!$B$14=\"Y\", 0.015,VLOOKUP(N19, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", 'I - CC 87+00 to 88+40 (L)'!S20, \"\")","v":15.917050613743505},{"$f":"IF(A19<>\"\",U20/(V20*(F19+F19+G19*V20+H19*V20)/2),\"\")","v":0.62423794010531219},{"$f":"IF(A19<>\"\", 62.4*V20*'I - CC 87+00 to 88+40 (L)'!I20, \"\")","v":0.38411973599999982},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A20<>\"\", 'I - CC 87+00 to 88+40 (L)'!W20, \"\")","v":0.32986130540957187},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X20<>\"\",'I - CC 87+00 to 88+40 (L)'!Y20, \"\")","v":4.7424999999999981E-2},{"$f":"IF(A19<>\"\",F19+G19*V20+H19*V20, \"\")","v":11.284549999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!B48<>\"\", 'I - CC 87+00 to 88+40 (L)'!B48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!C48<>\"\", 'I - CC 87+00 to 88+40 (L)'!C48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!E48<>\"\", 'I - CC 87+00 to 88+40 (L)'!D48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!F48<>\"\", 'I - CC 87+00 to 88+40 (L)'!E48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!I48<>\"\", 'I - CC 87+00 to 88+40 (L)'!I48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!K48<>\"\", 'I - CC 87+00 to 88+40 (L)'!K48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!L48<>\"\", 'I - CC 87+00 to 88+40 (L)'!L48, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!I48<>\"\", IF('I - CC 87+00 to 88+40 (L)'!I48>0.2, 'I - CC 87+00 to 88+40 (L)'!I48&\"*\", 'I - CC 87+00 to 88+40 (L)'!I48), \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!M48<>\"\", 'I - CC 87+00 to 88+40 (L)'!M48, \"\")","v":""},null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!N48<>\"\", 'I - CC 87+00 to 88+40 (L)'!N48, \"\")","v":""},{"$f":"IF(J86<>\"\", M85+J86*L86, \"\")","v":""},{"$f":"IF(A86<>\"\", IF(T86<$F$7, $D$7, IF(T86<$F$8, $D$8, IF(T86<$F$9, $D$9, IF(T86<$F$10, $D$10, IF(T86<#REF!,#REF!, IF( T86<#REF!,#REF!,#REF!)))))), \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A48<>\"\", IF($B$3=\"A\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/('I - CC 87+00 to 88+40 (L)'!R48+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$3=\"B\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/('I - CC 87+00 to 88+40 (L)'!R48+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$3=\"C\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/('I - CC 87+00 to 88+40 (L)'!R48+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$3=\"D\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/('I - CC 87+00 to 88+40 (L)'!R48+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A48<>\"\", $J$3, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A48<>\"\", VLOOKUP(N86, $D$6:$E$10, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A42<>\"\", 'I - CC 87+00 to 88+40 (L)'!W42, \"\")","v":""},{"$f":"IF('I - CC 87+00 to 88+40 (L)'!X48<>\"\",'I - CC 87+00 to 88+40 (L)'!X48, \"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A43<>\"\", 'I - CC 87+00 to 88+40 (L)'!V43, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A43<>\"\", 'I - CC 87+00 to 88+40 (L)'!W43, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A44<>\"\",'I - CC 87+00 to 88+40 (L)'!V44, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A44<>\"\", 'I - CC 87+00 to 88+40 (L)'!W44, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A45<>\"\", 'I - CC 87+00 to 88+40 (L)'!V45, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A45<>\"\", 'I - CC 87+00 to 88+40 (L)'!W45, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A46<>\"\",'I - CC 87+00 to 88+40 (L)'!V46, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A46<>\"\", 'I - CC 87+00 to 88+40 (L)'!W46, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A47<>\"\", 'I - CC 87+00 to 88+40 (L)'!V47, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A47<>\"\", 'I - CC 87+00 to 88+40 (L)'!W47, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A48<>\"\",'I - CC 87+00 to 88+40 (L)'!V48, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A48<>\"\", 'I - CC 87+00 to 88+40 (L)'!W48, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A49<>\"\", 'I - CC 87+00 to 88+40 (L)'!V49, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A49<>\"\", 'I - CC 87+00 to 88+40 (L)'!W49, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A50<>\"\",'I - CC 87+00 to 88+40 (L)'!V50, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A50<>\"\", 'I - CC 87+00 to 88+40 (L)'!W50, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A51<>\"\", 'I - CC 87+00 to 88+40 (L)'!V51, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A51<>\"\", 'I - CC 87+00 to 88+40 (L)'!W51, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A52<>\"\",'I - CC 87+00 to 88+40 (L)'!V52, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A52<>\"\", 'I - CC 87+00 to 88+40 (L)'!W52, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A53<>\"\", 'I - CC 87+00 to 88+40 (L)'!V53, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A53<>\"\", 'I - CC 87+00 to 88+40 (L)'!W53, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A54<>\"\", 'I - CC 87+00 to 88+40 (L)'!V54, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A54<>\"\", 'I - CC 87+00 to 88+40 (L)'!W54, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A55<>\"\",'I - CC 87+00 to 88+40 (L)'!V55, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A55<>\"\", 'I - CC 87+00 to 88+40 (L)'!W55, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A56<>\"\", 'I - CC 87+00 to 88+40 (L)'!V56, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+00 to 88+40 (L)'!A56<>\"\", 'I - CC 87+00 to 88+40 (L)'!W56, \"\")","v":""}]

{"sheet":"I - CC 87+50 to 88+40 (R)","index":2,"n_rows":36,"n_cols":31,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,22],[15,0,15,4],[15,6,15,8],[15,9,15,11],[15,12,15,15],[15,16,15,19]]}
["Ditch Analysis Input Worksheet"]
["PID:",114496]
["Date",{"$f":"TODAY()","v":"2024-06-27"}]
["Project","Columbia Connector"]
["Location","Sta. 87+00 to 88+40 Right"]
["Designer","ZTM"]
["Checker","SNS"]
["Rainfall Area","C"]
["Depth Design Year",10]
["Shear Stress Design Year",5]
["Time to first section",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MACRO COLUMN (ctrl q)"]
["Pick up Flow:"]
[]
["Paved Gutter? (Y/N)","n"]
[]
[]
["Ref. No.","Begin","End","Side","Length","Shape","Begin","End","Grade","Radius/Width","Inslope (ft./ft.)","Backslope (ft./ft.)","Area (acres)","Coefficient","CA (sum)","Ditch Time","Ditch Time","Total (1)","Total (2)","Intensity (1)","Intensity (2)","Q (1)","Q (2)","Flow Depth (1)","Flow Depth (2)","Hydraulic Radius (1)","Hydraulic Radius (2)","Qi (1)","Qi (2)","Qi/Q (1)","Qi/Q (2)"]
[1,8750,8800,"R",{"$f":"C18-B18","v":50},"Trapazoidal",493.9,492.42,{"$f":"ROUND((G18-H18)/E18,4)","v":2.9600000000000001E-2},2,2,2,3.3000000000000002E-2,0.7,{"$f":"N18*M18","v":2.3099999999999999E-2},0,0,{"$f":"B11","v":10},{"$f":"B11","v":10},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/($R$18+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.8202795627711961},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(S18+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":5.3219361594781596},{"$f":"O18*T18+$B$12","v":0.11134845790001463},{"$f":"O18*U18+$B$12","v":0.12293672528394547},9.3849999999999975E-2,9.864999999999996E-2,{"$f":"(X18*((J18+(J18+K18*X18+L18*X18))/2))/(J18+SQRT(X18^2+(X18*L18)^2)+SQRT(X18^2+(X18*K18)^2))","v":8.485134518059631E-2},{"$f":"(Y18*((J18+(J18+K18*Y18+L18*Y18))/2))/(J18+SQRT(Y18^2+(Y18*L18)^2)+SQRT(Y18^2+(Y18*K18)^2))","v":8.8794755551832652E-2},{"$f":"1.486/'R- CC 87+50 to 88+40 (R)'!Q16*Z18*SQRT(I18)*X18*((J18+(J18+X18*K18+X18*L18))/2)","v":0.11134877643859187},{"$f":"1.486/'R- CC 87+50 to 88+40 (R)'!Q16*AA18*SQRT(I18)*Y18*((J18+(J18+Y18*K18+Y18*L18))/2)","v":0.12302076827683243},{"$f":"AB18-V18","v":3.1853857723751489E-7},8.40429928869596E-5]
[2,8800,8840,"R",40,"Trapazoidal",492.42,485,0.1855,11,2,4,3.2000000000000001E-2,0.7,{"$f":"O18+M19*N19","v":4.5499999999999999E-2},{"$f":"E18/(60*(V18/(X18*((J18+J18+X18*K18+X18*L18)/2))))","v":1.5365850058468637},{"$f":"E18/(60*(W18/(Y18*((J18+J18+Y18*K18+Y18*L18)/2))))","v":1.4693442534451739},{"$f":"R18+P19","v":11.536585005846863},{"$f":"S18+Q19","v":11.469344253445174},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/($R$19+VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$10,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":4.5333685613432442},{"$f":"IF($B$8=\"A\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$8=\"B\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$8=\"C\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$8=\"D\",(VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(S19+VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($B$9,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE))))","v":5.0390505609028295},{"$f":"O19*T19+$B$12","v":0.2062682695411176},0.22927680052107874,3.4262499999999974E-2,3.6162499999999972E-2,3.3910972172521668E-2,3.5771325088449803E-2,{"$f":"1.486/'R- CC 87+50 to 88+40 (R)'!Q17*Z19*SQRT(I19)*X19*((J19+(J19+X19*K19+X19*L19))/2)","v":0.20640589271710685},{"$f":"1.486/'R- CC 87+50 to 88+40 (R)'!Q17*AA19*SQRT(I19)*Y19*((J19+(J19+Y19*K19+Y19*L19))/2)","v":0.22992128634334338},1.3762317598925433E-4,6.4448582226464546E-4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[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,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"R- CC 87+50 to 88+40 (R)","index":3,"n_rows":114,"n_cols":23,"rows_kept":114,"cut":false,"hidden":false,"merged":[[12,0,12,4],[12,5,12,8],[12,9,12,12],[12,14,12,22],[0,0,0,22],[1,0,1,2],[1,8,2,9],[1,10,2,10],[1,11,2,11]]}
["Ditch Analysis"]
["PID:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B2","v":114496},null,null,null,null,"Ditch Lining",null,"Manning's \"n\"","Allowable Shear Stress"]
["Date:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B3","v":"2024-06-27"}]
["Project:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B4","v":"Columbia Connector"},null,null,null,null,"Seed",null,0.04,0.4]
["Location:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B5","v":"Sta. 87+00 to 88+40 Right"},null,null,null,null,"Jute Mat",null,0.04,0.45]
["Designer:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B6","v":"ZTM"},null,null,null,null,"Temporary Mat",null,0.04,1]
["Checker:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B7","v":"SNS"},null,null,null,null,"Permanent Mat, Type 1",null,0.04,2]
["Rainfall Area:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B8","v":"C"},null,null,null,null,"Permanent Mat, Type 2",null,0.04,3]
["Depth Storm Frequency:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B9","v":10},null,null,null,null,"Permanent Mat, Type 3",null,0.04,5,null,"* Grade Steeper than Allowable"]
["Shear Stress Storm Frequency:",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B10","v":5},null,null,null,null,"RCP, Type B",null,0.06,6]
["Pickup Flow (cfs):",null,null,{"$f":"'I - CC 87+50 to 88+40 (R)'!B12","v":0}]
[]
["Station",null,null,null,null,"Dimension",null,null,null,"Rainfall",null,null,null,"Lining Type","Discharge"]
["Ref. No.","Begin","End","Side","Length (ft.)","Radius/Width (ft.)","Inslope (ft./ft.)","Backslope (ft./ft.)","Grade (ft./ft.)","Area (acres)","Total Area (acres)","Runoff Coefficient","CA (sum)","Protection Type","Intensity (in./hr.)","Storm Freq. (Yrs.)","Mann. Coef.","Time Flow (min.)","Velocity Flow (fps)","Shear (lbs./sq.ft)","Design Flow (cfs.)","Depth Flow (ft.)","Width Flow (ft.)"]
[{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", 'I - CC 87+50 to 88+40 (R)'!A18, \"\")","v":1},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!B18<>\"\", 'I - CC 87+50 to 88+40 (R)'!B18, \"\")","v":8750},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!C18<>\"\", 'I - CC 87+50 to 88+40 (R)'!C18, \"\")","v":8800},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!D18<>\"\", 'I - CC 87+50 to 88+40 (R)'!D18, \"\")","v":"R"},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!E18<>\"\", 'I - CC 87+50 to 88+40 (R)'!E18, \"\")","v":50},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!J18<>\"\", 'I - CC 87+50 to 88+40 (R)'!J18, \"\")","v":2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!K18<>\"\", 'I - CC 87+50 to 88+40 (R)'!K18, \"\")","v":2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!L18<>\"\", 'I - CC 87+50 to 88+40 (R)'!L18, \"\")","v":2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!I18<>\"\", IF('I - CC 87+50 to 88+40 (R)'!I18>0.2, 'I - CC 87+50 to 88+40 (R)'!I18&\"*\", 'I - CC 87+50 to 88+40 (R)'!I18), \"\")","v":2.9600000000000001E-2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!M18<>\"\", 'I - CC 87+50 to 88+40 (R)'!M18, \"\")","v":3.3000000000000002E-2},{"$f":"IF(J15<>\"\",J15, \"\")","v":3.3000000000000002E-2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!N18<>\"\", 'I - CC 87+50 to 88+40 (R)'!N18, \"\")","v":0.7},{"$f":"IF(J15<>\"\", J15*L15, \"\")","v":2.3099999999999999E-2},{"$f":"IF(A15<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", \"Paved Gutter\",IF(T15<$L$4, $I$4, IF(T15<$L$5, $I$5, IF(T15<$L$6, $I$6, IF(T15<$L$7, $I$7, IF(T15<$L$8, $I$8, IF(T15<$L$9, $I$9, $I$10))))))), \"\")","v":"Seed"},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", IF($D$8=\"A\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R15+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.8202795627711961},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", $D$10, \"\")","v":5},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", 0.015,VLOOKUP(N15, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", 'I - CC 87+50 to 88+40 (R)'!R18, \"\")","v":10},{"$f":"IF(A15<>\"\",U15/(V15*(F15+F15+G15*V15+H15*V15)/2),\"\")","v":0.54232816939018302},{"$f":"IF(A15<>\"\", 62.4*V15*'I - CC 87+50 to 88+40 (R)'!I18, \"\")","v":0.17334470399999993},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", 'I - CC 87+50 to 88+40 (R)'!V18, \"\")","v":0.11134845790001463},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!X18<>\"\",'I - CC 87+50 to 88+40 (R)'!X18, \"\")","v":9.3849999999999975E-2},{"$f":"IF(A15<>\"\",F15+G15*V15+H15*V15, \"\")","v":2.3754}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", IF($D$8=\"A\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R16+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":5.3219361594781596},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", $D$9, \"\")","v":10},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", 0.015,VLOOKUP(N15, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", 'I - CC 87+50 to 88+40 (R)'!S18, \"\")","v":10},{"$f":"IF(A15<>\"\",U16/(V16*(F15+F15+G15*V16+H15*V16)/2),\"\")","v":0.56714642016628525},{"$f":"IF(A15<>\"\", 62.4*V16*'I - CC 87+50 to 88+40 (R)'!I18, \"\")","v":0.18221049599999992},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A18<>\"\", 'I - CC 87+50 to 88+40 (R)'!W18, \"\")","v":0.12293672528394547},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!X18<>\"\",'I - CC 87+50 to 88+40 (R)'!Y18, \"\")","v":9.864999999999996E-2},{"$f":"IF(A15<>\"\",F15+G15*V16+H15*V16, \"\")","v":2.3945999999999996}]
[{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", 'I - CC 87+50 to 88+40 (R)'!A19, \"\")","v":2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!B19<>\"\", 'I - CC 87+50 to 88+40 (R)'!B19, \"\")","v":8800},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!C19<>\"\", 'I - CC 87+50 to 88+40 (R)'!C19, \"\")","v":8840},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!E19<>\"\", 'I - CC 87+50 to 88+40 (R)'!D19, \"\")","v":"R"},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!F19<>\"\", 'I - CC 87+50 to 88+40 (R)'!E19, \"\")","v":40},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!J19<>\"\", 'I - CC 87+50 to 88+40 (R)'!J19, \"\")","v":11},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!K19<>\"\", 'I - CC 87+50 to 88+40 (R)'!K19, \"\")","v":2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!L19<>\"\", 'I - CC 87+50 to 88+40 (R)'!L19, \"\")","v":4},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!I19<>\"\", IF('I - CC 87+50 to 88+40 (R)'!I19>0.2, 'I - CC 87+50 to 88+40 (R)'!I19&\"*\", 'I - CC 87+50 to 88+40 (R)'!I19), \"\")","v":0.1855},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!M19<>\"\", 'I - CC 87+50 to 88+40 (R)'!M19, \"\")","v":3.2000000000000001E-2},{"$f":"IF(J17<>\"\",K15+J17, \"\")","v":6.5000000000000002E-2},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!N19<>\"\", 'I - CC 87+50 to 88+40 (R)'!N19, \"\")","v":0.7},{"$f":"IF(J17<>\"\", M15+J17*L17, \"\")","v":4.5499999999999999E-2},{"$f":"IF(A17<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", \"Paved Gutter\",IF(T17<$L$4, $I$4, IF(T17<$L$5, $I$5, IF(T17<$L$6, $I$6, IF(T17<$L$7, $I$7, IF(T17<$L$8, $I$8, IF(T17<$L$9, $I$9, $I$10))))))), \"\")","v":"Seed"},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", IF($D$8=\"A\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R17+VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$15,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":4.5333685613432442},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", $D$10, \"\")","v":5},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", 0.015,VLOOKUP(N17, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", 'I - CC 87+50 to 88+40 (R)'!R19, \"\")","v":11.536585005846863},{"$f":"IF(A17<>\"\",U17/(V17*(F17+F17+G17*V17+H17*V17)/2),\"\")","v":0.54222726155588574},{"$f":"IF(A17<>\"\", 62.4*V17*'I - CC 87+50 to 88+40 (R)'!I19, \"\")","v":0.39659528999999971},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\",'I - CC 87+50 to 88+40 (R)'!V19, \"\")","v":0.2062682695411176},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!X19<>\"\",'I - CC 87+50 to 88+40 (R)'!X19, \"\")","v":3.4262499999999974E-2},{"$f":"IF(A17<>\"\",F17+G17*V17+H17*V17, \"\")","v":11.205575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", IF($D$8=\"A\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($D$8=\"B\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($D$8=\"C\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($D$8=\"D\",(VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/(R18+VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($P$16,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":5.0390505609028295},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", $D$9, \"\")","v":10},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", IF('I - CC 87+50 to 88+40 (R)'!$B$14=\"Y\", 0.015,VLOOKUP(N17, $I$4:$K$10, 3, FALSE)), \"\")","v":0.04},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", 'I - CC 87+50 to 88+40 (R)'!S19, \"\")","v":11.469344253445174},{"$f":"IF(A17<>\"\",U18/(V18*(F17+F17+G17*V18+H17*V18)/2),\"\")","v":0.57075107131077074},{"$f":"IF(A17<>\"\", 62.4*V18*'I - CC 87+50 to 88+40 (R)'!I19, \"\")","v":0.4185881699999997},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A19<>\"\", 'I - CC 87+50 to 88+40 (R)'!W19, \"\")","v":0.22927680052107874},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!X19<>\"\",'I - CC 87+50 to 88+40 (R)'!Y19, \"\")","v":3.6162499999999972E-2},{"$f":"IF(A17<>\"\",F17+G17*V18+H17*V18, \"\")","v":11.216975}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!B47<>\"\", 'I - CC 87+50 to 88+40 (R)'!B47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!C47<>\"\", 'I - CC 87+50 to 88+40 (R)'!C47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!E47<>\"\", 'I - CC 87+50 to 88+40 (R)'!D47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!F47<>\"\", 'I - CC 87+50 to 88+40 (R)'!E47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!I47<>\"\", 'I - CC 87+50 to 88+40 (R)'!I47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!K47<>\"\", 'I - CC 87+50 to 88+40 (R)'!K47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!L47<>\"\", 'I - CC 87+50 to 88+40 (R)'!L47, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!I47<>\"\", IF('I - CC 87+50 to 88+40 (R)'!I47>0.2, 'I - CC 87+50 to 88+40 (R)'!I47&\"*\", 'I - CC 87+50 to 88+40 (R)'!I47), \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!M47<>\"\", 'I - CC 87+50 to 88+40 (R)'!M47, \"\")","v":""},null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!N47<>\"\", 'I - CC 87+50 to 88+40 (R)'!N47, \"\")","v":""},{"$f":"IF(J86<>\"\", M85+J86*L86, \"\")","v":""},{"$f":"IF(A86<>\"\", IF(T86<$F$7, $D$7, IF(T86<$F$8, $D$8, IF(T86<$F$9, $D$9, IF(T86<$F$10, $D$10, IF(T86<#REF!,#REF!, IF( T86<#REF!,#REF!,#REF!)))))), \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A47<>\"\", IF($B$3=\"A\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,2,FALSE))/('I - CC 87+50 to 88+40 (R)'!R47+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$2:$E$7,4,FALSE),IF($B$3=\"B\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,2,FALSE))/('I - CC 87+50 to 88+40 (R)'!R47+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$8:$E$13,4,FALSE),IF($B$3=\"C\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,2,FALSE))/('I - CC 87+50 to 88+40 (R)'!R47+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$14:$E$19,4,FALSE),IF($B$3=\"D\",(VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,2,FALSE))/('I - CC 87+50 to 88+40 (R)'!R47+VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,3,FALSE))^VLOOKUP($J$3,'[1]Rainfall Intensity'!$B$20:$E$25,4,FALSE),FALSE)))), \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A47<>\"\", $J$3, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A47<>\"\", VLOOKUP(N86, $D$6:$E$10, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A41<>\"\", 'I - CC 87+50 to 88+40 (R)'!W41, \"\")","v":""},{"$f":"IF('I - CC 87+50 to 88+40 (R)'!X47<>\"\",'I - CC 87+50 to 88+40 (R)'!X47, \"\")","v":""},{"$f":"IF(A86<>\"\",F86+G86*V86+H86*V86, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A42<>\"\", 'I - CC 87+50 to 88+40 (R)'!V42, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A42<>\"\", 'I - CC 87+50 to 88+40 (R)'!W42, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A43<>\"\",'I - CC 87+50 to 88+40 (R)'!V43, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A43<>\"\", 'I - CC 87+50 to 88+40 (R)'!W43, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A44<>\"\", 'I - CC 87+50 to 88+40 (R)'!V44, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A44<>\"\", 'I - CC 87+50 to 88+40 (R)'!W44, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A45<>\"\",'I - CC 87+50 to 88+40 (R)'!V45, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A45<>\"\", 'I - CC 87+50 to 88+40 (R)'!W45, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A46<>\"\", 'I - CC 87+50 to 88+40 (R)'!V46, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A46<>\"\", 'I - CC 87+50 to 88+40 (R)'!W46, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A47<>\"\",'I - CC 87+50 to 88+40 (R)'!V47, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A47<>\"\", 'I - CC 87+50 to 88+40 (R)'!W47, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A48<>\"\", 'I - CC 87+50 to 88+40 (R)'!V48, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A48<>\"\", 'I - CC 87+50 to 88+40 (R)'!W48, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A49<>\"\",'I - CC 87+50 to 88+40 (R)'!V49, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A49<>\"\", 'I - CC 87+50 to 88+40 (R)'!W49, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A50<>\"\", 'I - CC 87+50 to 88+40 (R)'!V50, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A50<>\"\", 'I - CC 87+50 to 88+40 (R)'!W50, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A51<>\"\",'I - CC 87+50 to 88+40 (R)'!V51, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A51<>\"\", 'I - CC 87+50 to 88+40 (R)'!W51, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A52<>\"\", 'I - CC 87+50 to 88+40 (R)'!V52, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A52<>\"\", 'I - CC 87+50 to 88+40 (R)'!W52, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A53<>\"\", 'I - CC 87+50 to 88+40 (R)'!V53, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A53<>\"\", 'I - CC 87+50 to 88+40 (R)'!W53, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A54<>\"\",'I - CC 87+50 to 88+40 (R)'!V54, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A54<>\"\", 'I - CC 87+50 to 88+40 (R)'!W54, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A55<>\"\", 'I - CC 87+50 to 88+40 (R)'!V55, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('I - CC 87+50 to 88+40 (R)'!A55<>\"\", 'I - CC 87+50 to 88+40 (R)'!W55, \"\")","v":""}]

{"sheet":"Rainfall Intensity","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,6,0],[7,0,12,0],[13,0,18,0],[19,0,24,0]]}
["Intensity Zone","Frequency","Constant \"a\"","Constant \"b\"","Constant \"c\""]
["A",2,46.183999999999997,9,0.85899999999999999]
[null,5,56.984999999999999,10.25,0.85099999999999998]
[null,10,64.167000000000002,11,0.84199999999999997]
[null,25,66.528000000000006,11,0.81100000000000005]
[null,50,65.701999999999998,10.75,0.78200000000000003]
[null,100,64.489000000000004,10.5,0.754]
["B",2,47.987000000000002,9,0.85899999999999999]
[null,5,60.683999999999997,10.5,0.85799999999999998]
[null,10,73.126000000000005,12,0.86299999999999999]
[null,25,75.840999999999994,12,0.83299999999999996]
[null,50,65.620999999999995,10,0.78100000000000003]
[null,100,85.046999999999997,13.25,0.80600000000000005]
["C",2,56.298999999999999,10,0.876]
[null,5,67.933000000000007,11,0.86899999999999999]
[null,10,84.55,13,0.88200000000000001]
[null,25,95.736000000000004,14,0.871]
[null,50,96.783000000000001,14,0.85]
[null,100,80.436000000000007,11.5,0.79400000000000004]
["D",2,57.448,10,0.876]
[null,5,67.933000000000007,11,0.86899999999999999]
[null,10,79.191999999999993,12,0.86399999999999999]
[null,25,87.885999999999996,12.75,0.84899999999999998]
[null,50,95.168999999999997,13.5,0.83899999999999997]
[null,100,91.981999999999999,13,0.81]