{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Hood Inlet","Flow Data","Weir Slug Data","Pipe Length","Weir & Slug","CFS chart","Info"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":56,"comments":2,"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":"Hood Inlet","index":0,"n_rows":205,"n_cols":25,"rows_kept":205,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,3],[2,8,4,8],[2,5,4,5],[2,6,4,6],[2,1,2,2],[1,5,1,7],[2,7,4,7],[41,0,43,2],[18,1,18,2],[54,0,55,2],[51,0,53,2],[44,0,46,2],[48,0,49,2]]}
["Project Name: ",null,null,null,null,null,null,null,null,null,"IaHoodInlet.xls Ver 1.30"]
["Computed by: ",null,null,null,null,"Outflow, CFS",null,null,{"$f":"IF(X17=0,\"\",\"Void - Press Compute\")","v":""}]
["Date: ",null,null,null,null,"Weir","Slug Flow","Full Pipe"," Structure Outflow, CFS"]
["Checked by: ",null,null,null,"HW","cfs","cfs","cfs","cfs",null,"Controlling"]
["Date: ",null,null,"Elev","Ft","Weir","Inlet Orfice","Full Pipe","Struct",null,"Factor",null,null,null,null,null,null,"Full Pipe Flow"]
["Input Data",null,null,{"$f":"IF(pcrest=\"\",\"\",ROUND(pcrest,1))","v":1083.5},{"$f":"IF(D6=\"\",\"\",D6-crest)","v":0},{"$f":"IF(E6=\"\",\"\",'Weir & Slug'!E7)","v":0},{"$f":"IF(E6=\"\",\"\",'Weir & Slug'!F7)","v":0},{"$f":"IF(E6=\"\",\"\",IF(D6-TailW<0,0,Barea*((64.4*(D6-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5))","v":38.300702046688954},{"$f":"IF(E6=\"\",\"\",IF(E6>1.8*Pipe_Diam/12,H6,IF(H6=0,MAX(F6,G6),MIN(MAX(F6,G6),H6))))","v":0},null,{"$f":"IF(E6=\"\",\"\",IF(I6=F6,\"Weir Flow\",IF(I6=H6,\"Full Pipe Flow\",\"Slug Flow\")))","v":"Weir Flow"}]
[null,null,null,{"$f":"IF(D6=\"\",\"\",IF(D6>=high_water,\"\",IF(K6=\"Full Pipe Flow\",(INT((D6)/change_inc)+1)*change_inc,D6+NonFPincr)))","v":1083.5999999999999},{"$f":"IF(D7=\"\",\"\",D7-crest)","v":9.9999999999909051E-2},{"$f":"IF(E7=\"\",\"\",'Weir & Slug'!E8)","v":3.9218296572715874E-2},{"$f":"IF(E7=\"\",\"\",'Weir & Slug'!F8)","v":0},{"$f":"IF(E7=\"\",\"\",IF(D7-TailW<0,0,Barea*((64.4*(D7-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5))","v":38.406945529692045},3.9218296572715874E-2,null,{"$f":"IF(E7=\"\",\"\",IF(I7=F7,\"Weir Flow\",IF(I7=H7,\"Full Pipe Flow\",\"Slug Flow\")))","v":"Weir Flow"},null,null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF(H7=I7,H7,\"\"))","v":""}]
[null,null,null,1083.6999999999998,{"$f":"IF(D8=\"\",\"\",D8-crest)","v":0.1999999999998181},{"$f":"IF(E8=\"\",\"\",'Weir & Slug'!E9)","v":0.15720982708192952},{"$f":"IF(E8=\"\",\"\",'Weir & Slug'!F9)","v":0},38.512895925549671,0.15720982708192952,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,null,null,"Max Full Pipe Flow",{"$f":"MAX(H6:H205)","v":45.586953738228971}]
[null,null,null,1083.7999999999997,0.29999999999972715,{"$f":"IF(E9=\"\",\"\",'Weir & Slug'!E10)","v":0.35416716640216822},{"$f":"IF(E9=\"\",\"\",'Weir & Slug'!F10)","v":0},38.618555646524491,0.35416716640216822,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,null,null,"Max Y for Chart",{"$f":"5*INT(1+(1.25*Y8/5))","v":60}]
["Principal Spillway Crest Elev (ft)",null,1083.5,1083.8999999999996,0.3999999999996362,{"$f":"IF(E10=\"\",\"\",'Weir & Slug'!E11)","v":0.62984210049717815},{"$f":"IF(E10=\"\",\"\",'Weir & Slug'!F11)","v":0},38.7239270719693,0.62984210049717815,null,"Weir Flow",null,null,null,null,null,null,""]
[null,null,null,1083.9999999999995,0.49999999999954525,{"$f":"IF(E11=\"\",\"\",'Weir & Slug'!E12)","v":0.98351103185676458},{"$f":"IF(E11=\"\",\"\",'Weir & Slug'!F12)","v":0},38.829012548952171,0.98351103185676458,null,"Weir Flow",null,null,null,null,null,null,""]
[null,null,null,1084.0999999999995,0.5999999999994543,{"$f":"IF(E12=\"\",\"\",'Weir & Slug'!E13)","v":1.413934153631609},{"$f":"IF(E12=\"\",\"\",'Weir & Slug'!F13)","v":0},38.933814392866438,1.413934153631609,null,"Weir Flow",null,null,null,null,null,null,""]
["Pipe Diameter (in)",null,24,1084.1999999999994,0.69999999999936335,{"$f":"IF(E13=\"\",\"\",'Weir & Slug'!E14)","v":1.9193066669147465},{"$f":"IF(E13=\"\",\"\",'Weir & Slug'!F14)","v":0},39.038334888025922,1.9193066669147465,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,"Full Pipe increment1=",{"$f":"IF(change_inc1=\"\",NonFPincr,change_inc1)","v":0.2}]
["Pipe Length (ft)",null,125,1084.2999999999993,0.7999999999992724,{"$f":"IF(E14=\"\",\"\",'Weir & Slug'!E15)","v":2.49719965562783},{"$f":"IF(E14=\"\",\"\",'Weir & Slug'!F15)","v":0},39.142576288245905,2.49719965562783,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,"Non Full Pipe Increment=",0.1]
["Entrance Coefficient 'Ke'",null,1,1084.3999999999992,0.89999999999918145,{"$f":"IF(E15=\"\",\"\",'Weir & Slug'!E16)","v":3.1444872417085783},{"$f":"IF(E15=\"\",\"\",'Weir & Slug'!F16)","v":0},39.246540817410121,3.1444872417085783,null,"Weir Flow",null,null,null,null,null,null,""]
["Mannings 'n-value'",null,2.5000000000000001E-2,1084.4999999999991,0.99999999999909051,{"$f":"IF(E16=\"\",\"\",'Weir & Slug'!E17)","v":3.8572551064028775},{"$f":"IF(E16=\"\",\"\",'Weir & Slug'!F17)","v":0},39.350230670024381,3.8572551064028775,null,"Weir Flow",null,null,null,null,null,null,""]
["Elbow Elev (if None, Leave 'BLANK')",null,1065.5,1084.599999999999,1.0999999999989996,{"$f":"IF(E17=\"\",\"\",'Weir & Slug'!E18)","v":4.6306829951216733},{"$f":"IF(E17=\"\",\"\",'Weir & Slug'!F18)","v":0},39.453648011756982,4.6306829951216733,null,"Weir Flow",null,null,null,null,null,null,""]
["Length of Outlet ('BLANK' if none)",null,20,1084.6999999999989,1.1999999999989086,{"$f":"IF(E18=\"\",\"\",'Weir & Slug'!E19)","v":5.4588896886839242},{"$f":"IF(E18=\"\",\"\",'Weir & Slug'!F19)","v":0},39.556794979966519,5.4588896886839242,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,"Outlet Type"]
["Outlet Type","Cantilever",null,1084.7999999999988,1.2999999999988177,{"$f":"IF(E19=\"\",\"\",'Weir & Slug'!E20)","v":6.3347216407549753},{"$f":"IF(E19=\"\",\"\",'Weir & Slug'!F20)","v":0},39.659673684217225,6.3347216407549753,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,1,"Cantilever"]
["Outlet Elevation (ft)",null,1064.5,1084.8999999999987,1.3999999999987267,{"$f":"IF(E20=\"\",\"\",'Weir & Slug'!E21)","v":7.2494528414019985},{"$f":"IF(E20=\"\",\"\",'Weir & Slug'!F21)","v":0},39.762286206782434,7.2494528414019985,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,2,"Slotted Flume"]
["Tailwater Elev (if unknown, leave 'Blank')",null,null,1084.9999999999986,1.4999999999986358,{"$f":"IF(E21=\"\",\"\",'Weir & Slug'!E22)","v":8.192335886865628},{"$f":"IF(E21=\"\",\"\",'Weir & Slug'!F22)","v":0},39.86463460313626,8.192335886865628,null,"Weir Flow",null,null,null,null,null,null,""]
["Auxiliary Spillway Elev (ft)",null,1089,1085.0999999999985,1.5999999999985448,{"$f":"IF(E22=\"\",\"\",'Weir & Slug'!E23)","v":9.1498826640041298},{"$f":"IF(E22=\"\",\"\",'Weir & Slug'!F23)","v":0},39.966720902434034,9.1498826640041298,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,"Wall Smoothness"]
["Maximum Headwater Elev (ft)",null,1091,1085.1999999999985,1.6999999999984539,{"$f":"IF(E23=\"\",\"\",'Weir & Slug'!E24)","v":10.104595861964423},{"$f":"IF(E23=\"\",\"\",'Weir & Slug'!F24)","v":0},40.068547107981665,10.104595861964423,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,1,"Smooth"]
["Elev Increment After Full Pipe Flow",null,0.2,1085.2999999999984,1.7999999999983629,{"$f":"IF(E24=\"\",\"\",'Weir & Slug'!E25)","v":11.03238441543335},{"$f":"IF(E24=\"\",\"\",'Weir & Slug'!F25)","v":0},40.170115197694344,11.03238441543335,null,"Weir Flow",null,null,null,null,null,null,"",null,null,null,2,"Corrugated"]
[null,null,null,1085.3999999999983,1.899999999998272,{"$f":"IF(E25=\"\",\"\",'Weir & Slug'!E26)","v":11.895791363304415},{"$f":"IF(E25=\"\",\"\",'Weir & Slug'!F26)","v":0},40.2714271245448,11.895791363304415,null,"Weir Flow",null,null,null,null,null,null,""]
["Basic Output",null,null,1085.4999999999982,1.999999999998181,{"$f":"IF(E26=\"\",\"\",'Weir & Slug'!E27)","v":12.607021244873684},{"$f":"IF(E26=\"\",\"\",'Weir & Slug'!F27)","v":0},40.372484817001435,12.607021244873684,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Full Pipe Flow - Max. Outflow (cfs):",{"$f":"MAX(R7:R205)","v":45.586953738228971},1085.5999999999981,2.0999999999980901,{"$f":"IF(E27=\"\",\"\",'Weir & Slug'!E28)","v":13.092249121116769},{"$f":"IF(E27=\"\",\"\",'Weir & Slug'!F28)","v":0},40.473290179456619,13.092249121116769,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Full Pipe Flow - Max. Velocity (fps):",{"$f":"MAX(R7:R205)/Barea","v":14.510778055881396},1085.699999999998,2.1999999999979991,{"$f":"IF(E28=\"\",\"\",'Weir & Slug'!E29)","v":13.578332958072703},{"$f":"IF(E28=\"\",\"\",'Weir & Slug'!F29)","v":0},40.573845092645435,13.578332958072703,null,"Weir Flow",null,null,null,null,null,null,""]
[null,null,null,1085.7999999999979,2.2999999999979082,{"$f":"IF(E29=\"\",\"\",'Weir & Slug'!E30)","v":14.065491149668338},{"$f":"IF(E29=\"\",\"\",'Weir & Slug'!F30)","v":0},40.674151414055046,14.065491149668338,null,"Weir Flow",null,null,null,null,null,null,""]
[null,null,null,1085.8999999999978,2.3999999999978172,{"$f":"IF(E30=\"\",\"\",'Weir & Slug'!E31)","v":14.553912639999163},{"$f":"IF(E30=\"\",\"\",'Weir & Slug'!F31)","v":0},40.774210978325073,14.553912639999163,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Barrel Area (Sq Ft):",{"$f":"(Pipe_Diam/24)^2* PI()","v":3.1415926535897931},1085.9999999999977,2.4999999999977263,{"$f":"IF(E31=\"\",\"\",'Weir & Slug'!E32)","v":15.043761546710007},{"$f":"IF(E31=\"\",\"\",'Weir & Slug'!F32)","v":0},40.874025597639054,15.043761546710007,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Kp:",{"$f":"5087*Mannings^2/Pipe_Diam^(4/3)","v":4.592615628413646E-2},1086.0999999999976,2.5999999999976353,{"$f":"IF(E32=\"\",\"\",'Weir & Slug'!E33)","v":15.535180922861123},{"$f":"IF(E32=\"\",\"\",'Weir & Slug'!F33)","v":0},40.973597062107466,15.535180922861123,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Friction Slope (HW at the A.S. Crest): ",{"$f":"((emerg-(outlet+0.6*Pipe_Diam/12))*Kp)/(Kp*Pipe_Len+Entrance_Coeff+1)","v":0.13823941360229369},1086.1999999999975,2.6999999999975444,{"$f":"IF(E33=\"\",\"\",'Weir & Slug'!E34)","v":16.028295842914797},{"$f":"IF(E33=\"\",\"\",'Weir & Slug'!F34)","v":0},41.072927140142198,16.028295842914797,null,"Weir Flow",null,null,null,null,null,null,"","VOID: Principal Spillway inlet may not be lower than the barrel invert elevation."]
[null,"Pipe Slope: ",{"$f":"IF(OR(elbow=\"\",len_outlet=\"\"),TAN(ASIN((crest-outlet)/Pipe_Len)),TAN(ASIN((crest-elbow)/(Pipe_Len-len_outlet))))","v":0.17400443716972247},1086.2999999999975,2.7999999999974534,{"$f":"IF(E34=\"\",\"\",'Weir & Slug'!E35)","v":16.523215953324144},{"$f":"IF(E34=\"\",\"\",'Weir & Slug'!F35)","v":0},41.172017578823095,16.523215953324144,null,"Weir Flow",null,null,null,null,null,null,"","Warning: Principal Spillway outlet is higher than the pipe inlet elevation."]
[null,"Outlet Elbow Angle (deg):",{"$f":"IF(OR(elbow=\"\",len_outlet=\"\"),0,ROUND((180/PI())*(ATAN(PipeSlope)-ASIN((elbow-outlet)/len_outlet)),0))","v":7},1086.3999999999974,2.8999999999973625,{"$f":"IF(E35=\"\",\"\",'Weir & Slug'!E36)","v":17.020037595216568},{"$f":"IF(E35=\"\",\"\",'Weir & Slug'!F36)","v":0},41.270870104256424,17.020037595216568,null,"Weir Flow",null,null,null,null,null,null,""]
[null,null,null,1086.4999999999973,2.9999999999972715,{"$f":"IF(E36=\"\",\"\",'Weir & Slug'!E37)","v":17.518845582263666},{"$f":"IF(E36=\"\",\"\",'Weir & Slug'!F37)","v":0},41.3694864219257,17.518845582263666,null,"Weir Flow",null,null,null,null,null,null,"","Warning: Please check the elevation of the elbow."]
[null,null,null,1086.5999999999972,3.0999999999971806,{"$f":"IF(E37=\"\",\"\",'Weir & Slug'!E38)","v":18.019714698574649},{"$f":"IF(E37=\"\",\"\",'Weir & Slug'!F38)","v":0},41.467868217035019,18.019714698574649,null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Km:",{"$f":"IF(ElAngle>30,30*Mannings/3,ABS(ElAngle*Mannings/3))","v":5.8333333333333341E-2},1086.6999999999971,3.1999999999970896,{"$f":"IF(E38=\"\",\"\",'Weir & Slug'!E39)","v":18.522710967649122},{"$f":"IF(E38=\"\",\"\",'Weir & Slug'!F39)","v":9.0509667988585232},41.566017154845035,{"$f":"IF(E38=\"\",\"\",IF(E38>1.8*Pipe_Diam/12,H38,IF(H38=0,MAX(F38,G38),MIN(MAX(F38,G38),H38))))","v":18.522710967649122},null,"Weir Flow",null,null,null,null,null,null,""]
[null,"Tailwater Elev Used For Full Pipe Flow:",{"$f":"MAX(TWentered,IF(OutType=\"Slotted Flume\", outlet,Pipe_Diam/12*0.5+outlet))","v":1065.5},{"$f":"IF(D38=\"\",\"\",IF(D38>=high_water,\"\",IF(K38=\"Full Pipe Flow\",(INT((D38)/change_inc)+1)*change_inc,D38+NonFPincr)))","v":1086.799999999997},3.2999999999969987,{"$f":"IF(E39=\"\",\"\",'Weir & Slug'!E40)","v":19.027892732888869},{"$f":"IF(E39=\"\",\"\",'Weir & Slug'!F40)","v":20.364675297832992},41.663934881001822,20.364675297832992,null,"Slug Flow",null,null,null,null,null,null,{"$f":"IF(D39=\"\",\"\",IF(H39=I39,H39,\"\"))","v":""}]
[null,null,null,1086.8999999999969,3.3999999999969077,{"$f":"IF(E40=\"\",\"\",'Weir & Slug'!E41)","v":19.535311582050465},{"$f":"IF(E40=\"\",\"\",'Weir & Slug'!F41)","v":31.678383796807463},41.761623021858817,31.678383796807463,null,"Slug Flow",null,null,null,null,null,null,"","NOTE: The pipe slope is flatter than the outlet slope. Eliminate or lower the elbow."]
["Notes & Warnings",null,null,1086.9999999999968,3.4999999999968168,{"$f":"IF(E41=\"\",\"\",'Weir & Slug'!E42)","v":20.045013141713799},{"$f":"IF(E41=\"\",\"\",'Weir & Slug'!F42)","v":42.992092295781937},41.859083184792006,41.859083184792006,null,"Full Pipe Flow",null,null,null,null,null,null,41.859083184792006,"VOID: The elevation difference between the elbow & outlet cannot be greater than the outlet length"]
[{"$f":"IF(OR(len_outlet=\"\",elbow=\"\"),\"\",IF((elbow-outlet)/len_outlet>1,S41,\"\"))","v":""},null,null,1087,3.5,{"$f":"IF(E42=\"\",\"\",'Weir & Slug'!E43)","v":20.045013141730063},{"$f":"IF(E42=\"\",\"\",'Weir & Slug'!F43)","v":42.992092296142076},41.859083184795104,41.859083184795104,null,"Full Pipe Flow",null,null,null,null,null,null,41.859083184795104]
[null,null,null,1087.2,3.7000000000000455,{"$f":"IF(E43=\"\",\"\",'Weir & Slug'!E44)","v":""},{"$f":"IF(E43=\"\",\"\",'Weir & Slug'!F44)","v":""},42.053325913351863,42.053325913351863,null,"Full Pipe Flow",null,null,null,null,null,null,42.053325913351863,"Warning: Please enter a Mannings N value (positive number)"]
[null,null,null,1087.4000000000001,3.9000000000000909,{"$f":"IF(E44=\"\",\"\",'Weir & Slug'!E45)","v":""},{"$f":"IF(E44=\"\",\"\",'Weir & Slug'!F45)","v":""},42.246675557700243,42.246675557700243,null,"Full Pipe Flow",null,null,null,null,null,null,42.246675557700243]
[{"$f":"IF(Mannings<=0,S43,\"\")","v":""},null,null,1087.6000000000001,4.1000000000001364,{"$f":"IF(E45=\"\",\"\",'Weir & Slug'!E46)","v":""},{"$f":"IF(E45=\"\",\"\",'Weir & Slug'!F46)","v":""},42.439144324321411,42.439144324321411,null,"Full Pipe Flow",null,null,null,null,null,null,42.439144324321411,"Note: Verify that the pipe inside wall type is correct."]
[null,null,null,1087.8,4.2999999999999545,{"$f":"IF(E46=\"\",\"\",'Weir & Slug'!E47)","v":""},{"$f":"IF(E46=\"\",\"\",'Weir & Slug'!F47)","v":""},42.630744144145069,42.630744144145069,null,"Full Pipe Flow",null,null,null,null,null,null,42.630744144145069,"VOID: The tailwater elevation is higher than the inlet elevation."]
[null,null,null,1088,4.5,{"$f":"IF(E47=\"\",\"\",'Weir & Slug'!E48)","v":""},{"$f":"IF(E47=\"\",\"\",'Weir & Slug'!F48)","v":""},42.821486681180915,42.821486681180915,null,"Full Pipe Flow",null,null,null,null,null,null,42.821486681180915]
[null,null,null,1088.2,4.7000000000000455,{"$f":"IF(E48=\"\",\"\",'Weir & Slug'!E49)","v":""},{"$f":"IF(E48=\"\",\"\",'Weir & Slug'!F49)","v":""},43.011383340803512,43.011383340803512,null,"Full Pipe Flow",null,null,null,null,null,null,43.011383340803512]
[{"$f":"IF(outlet>crest,S34,IF(elbow<>\"\",IF(OR(elbow<outlet,elbow-outlet>len_outlet),S36,\"\"),\"\"))","v":""},null,null,1088.4000000000001,4.9000000000000909,{"$f":"IF(E49=\"\",\"\",'Weir & Slug'!E50)","v":""},{"$f":"IF(E49=\"\",\"\",'Weir & Slug'!F50)","v":""},43.200445277711488,43.200445277711488,null,"Full Pipe Flow",null,null,null,null,null,null,43.200445277711488]
[null,null,null,1088.6000000000001,5.1000000000001364,{"$f":"IF(E50=\"\",\"\",'Weir & Slug'!E51)","v":""},{"$f":"IF(E50=\"\",\"\",'Weir & Slug'!F51)","v":""},43.388683403573566,43.388683403573566,null,"Full Pipe Flow",null,null,null,null,null,null,43.388683403573566]
[null,null,null,1088.8,5.2999999999999545,{"$f":"IF(E51=\"\",\"\",'Weir & Slug'!E52)","v":""},{"$f":"IF(E51=\"\",\"\",'Weir & Slug'!F52)","v":""},43.576108394377265,43.576108394377265,null,"Full Pipe Flow",null,null,null,null,null,null,43.576108394377265]
[{"$f":"IF(OR(len_outlet=\"\",elbow=\"\"),\"\",IF(ElAngle<0,S40,\"\"))","v":""},null,null,1089,5.5,{"$f":"IF(E52=\"\",\"\",'Weir & Slug'!E53)","v":""},{"$f":"IF(E52=\"\",\"\",'Weir & Slug'!F53)","v":""},43.762730697495471,43.762730697495471,null,"Full Pipe Flow",null,null,null,null,null,null,43.762730697495471]
[null,null,null,1089.2,5.7000000000000455,{"$f":"IF(E53=\"\",\"\",'Weir & Slug'!E54)","v":""},{"$f":"IF(E53=\"\",\"\",'Weir & Slug'!F54)","v":""},43.948560538480756,43.948560538480756,null,"Full Pipe Flow",null,null,null,null,null,null,43.948560538480756]
[null,null,null,1089.4000000000001,5.9000000000000909,{"$f":"IF(E54=\"\",\"\",'Weir & Slug'!E55)","v":""},{"$f":"IF(E54=\"\",\"\",'Weir & Slug'!F55)","v":""},44.133607927604366,44.133607927604366,null,"Full Pipe Flow",null,null,null,null,null,null,44.133607927604366]
[{"$f":"IF(TWentered=\"\",\"\",IF(TWentered>crest,S46,\"\"))","v":""},null,null,1089.6000000000001,6.1000000000001364,{"$f":"IF(E55=\"\",\"\",'Weir & Slug'!E56)","v":""},{"$f":"IF(E55=\"\",\"\",'Weir & Slug'!F56)","v":""},44.317882666148414,44.317882666148414,null,"Full Pipe Flow",null,null,null,null,null,null,44.317882666148414]
[null,null,null,1089.8,6.2999999999999545,{"$f":"IF(E56=\"\",\"\",'Weir & Slug'!E57)","v":""},{"$f":"IF(E56=\"\",\"\",'Weir & Slug'!F57)","v":""},44.501394352463549,44.501394352463549,null,"Full Pipe Flow",null,null,null,null,null,null,44.501394352463549]
[null,null,null,1090,6.5,{"$f":"IF(E57=\"\",\"\",'Weir & Slug'!E58)","v":""},{"$f":"IF(E57=\"\",\"\",'Weir & Slug'!F58)","v":""},44.684152387803778,44.684152387803778,null,"Full Pipe Flow",null,null,null,null,null,null,44.684152387803778]
[null,null,null,1090.2,6.7000000000000455,{"$f":"IF(E58=\"\",\"\",'Weir & Slug'!E59)","v":""},{"$f":"IF(E58=\"\",\"\",'Weir & Slug'!F59)","v":""},44.866165981945301,44.866165981945301,null,"Full Pipe Flow",null,null,null,null,null,null,44.866165981945301]
[null,null,null,1090.4000000000001,6.9000000000000909,{"$f":"IF(E59=\"\",\"\",'Weir & Slug'!E60)","v":""},{"$f":"IF(E59=\"\",\"\",'Weir & Slug'!F60)","v":""},45.047444158603064,45.047444158603064,null,"Full Pipe Flow",null,null,null,null,null,null,45.047444158603064]
[null,null,null,1090.6000000000001,7.1000000000001364,{"$f":"IF(E60=\"\",\"\",'Weir & Slug'!E61)","v":""},{"$f":"IF(E60=\"\",\"\",'Weir & Slug'!F61)","v":""},45.227995760650906,45.227995760650906,null,"Full Pipe Flow",null,null,null,null,null,null,45.227995760650906]
[null,null,null,1090.8,7.2999999999999545,{"$f":"IF(E61=\"\",\"\",'Weir & Slug'!E62)","v":""},{"$f":"IF(E61=\"\",\"\",'Weir & Slug'!F62)","v":""},45.407829455154904,45.407829455154904,null,"Full Pipe Flow",null,null,null,null,null,null,45.407829455154904]
[null,null,null,1091,7.5,{"$f":"IF(E62=\"\",\"\",'Weir & Slug'!E63)","v":""},{"$f":"IF(E62=\"\",\"\",'Weir & Slug'!F63)","v":""},45.586953738228971,45.586953738228971,null,"Full Pipe Flow",null,null,null,null,null,null,45.586953738228971]
[null,null,null,"","",{"$f":"IF(E63=\"\",\"\",'Weir & Slug'!E64)","v":""},{"$f":"IF(E63=\"\",\"\",'Weir & Slug'!F64)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E64=\"\",\"\",'Weir & Slug'!E65)","v":""},{"$f":"IF(E64=\"\",\"\",'Weir & Slug'!F65)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E65=\"\",\"\",'Weir & Slug'!E66)","v":""},{"$f":"IF(E65=\"\",\"\",'Weir & Slug'!F66)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E66=\"\",\"\",'Weir & Slug'!E67)","v":""},{"$f":"IF(E66=\"\",\"\",'Weir & Slug'!F67)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E67=\"\",\"\",'Weir & Slug'!E68)","v":""},{"$f":"IF(E67=\"\",\"\",'Weir & Slug'!F68)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E68=\"\",\"\",'Weir & Slug'!E69)","v":""},{"$f":"IF(E68=\"\",\"\",'Weir & Slug'!F69)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E69=\"\",\"\",'Weir & Slug'!E70)","v":""},{"$f":"IF(E69=\"\",\"\",'Weir & Slug'!F70)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E70=\"\",\"\",'Weir & Slug'!E71)","v":""},{"$f":"IF(E70=\"\",\"\",'Weir & Slug'!F71)","v":""},"",{"$f":"IF(E70=\"\",\"\",IF(E70>1.8*Pipe_Diam/12,H70,IF(H70=0,MAX(F70,G70),MIN(MAX(F70,G70),H70))))","v":""},null,"",null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(D70=\"\",\"\",IF(D70>=high_water,\"\",IF(K70=\"Full Pipe Flow\",(INT((D70)/change_inc)+1)*change_inc,D70+NonFPincr)))","v":""},"",{"$f":"IF(E71=\"\",\"\",'Weir & Slug'!E72)","v":""},{"$f":"IF(E71=\"\",\"\",'Weir & Slug'!F72)","v":""},{"$f":"IF(E71=\"\",\"\",IF(D71-TailW<0,0,Barea*((64.4*(D71-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5))","v":""},"",null,{"$f":"IF(E71=\"\",\"\",IF(I71=F71,\"Weir Flow\",IF(I71=H71,\"Full Pipe Flow\",\"Slug Flow\")))","v":""},null,null,null,null,null,null,{"$f":"IF(D71=\"\",\"\",IF(H71=I71,H71,\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(D72=\"\",\"\",D72-crest)","v":""},{"$f":"IF(E72=\"\",\"\",'Weir & Slug'!E73)","v":""},{"$f":"IF(E72=\"\",\"\",'Weir & Slug'!F73)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E73=\"\",\"\",'Weir & Slug'!E74)","v":""},{"$f":"IF(E73=\"\",\"\",'Weir & Slug'!F74)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E74=\"\",\"\",'Weir & Slug'!E75)","v":""},{"$f":"IF(E74=\"\",\"\",'Weir & Slug'!F75)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E75=\"\",\"\",'Weir & Slug'!E76)","v":""},{"$f":"IF(E75=\"\",\"\",'Weir & Slug'!F76)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E76=\"\",\"\",'Weir & Slug'!E77)","v":""},{"$f":"IF(E76=\"\",\"\",'Weir & Slug'!F77)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E77=\"\",\"\",'Weir & Slug'!E78)","v":""},{"$f":"IF(E77=\"\",\"\",'Weir & Slug'!F78)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E78=\"\",\"\",'Weir & Slug'!E79)","v":""},{"$f":"IF(E78=\"\",\"\",'Weir & Slug'!F79)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E79=\"\",\"\",'Weir & Slug'!E80)","v":""},{"$f":"IF(E79=\"\",\"\",'Weir & Slug'!F80)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E80=\"\",\"\",'Weir & Slug'!E81)","v":""},{"$f":"IF(E80=\"\",\"\",'Weir & Slug'!F81)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E81=\"\",\"\",'Weir & Slug'!E82)","v":""},{"$f":"IF(E81=\"\",\"\",'Weir & Slug'!F82)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E82=\"\",\"\",'Weir & Slug'!E83)","v":""},{"$f":"IF(E82=\"\",\"\",'Weir & Slug'!F83)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E83=\"\",\"\",'Weir & Slug'!E84)","v":""},{"$f":"IF(E83=\"\",\"\",'Weir & Slug'!F84)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E84=\"\",\"\",'Weir & Slug'!E85)","v":""},{"$f":"IF(E84=\"\",\"\",'Weir & Slug'!F85)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E85=\"\",\"\",'Weir & Slug'!E86)","v":""},{"$f":"IF(E85=\"\",\"\",'Weir & Slug'!F86)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E86=\"\",\"\",'Weir & Slug'!E87)","v":""},{"$f":"IF(E86=\"\",\"\",'Weir & Slug'!F87)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E87=\"\",\"\",'Weir & Slug'!E88)","v":""},{"$f":"IF(E87=\"\",\"\",'Weir & Slug'!F88)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E88=\"\",\"\",'Weir & Slug'!E89)","v":""},{"$f":"IF(E88=\"\",\"\",'Weir & Slug'!F89)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E89=\"\",\"\",'Weir & Slug'!E90)","v":""},{"$f":"IF(E89=\"\",\"\",'Weir & Slug'!F90)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E90=\"\",\"\",'Weir & Slug'!E91)","v":""},{"$f":"IF(E90=\"\",\"\",'Weir & Slug'!F91)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E91=\"\",\"\",'Weir & Slug'!E92)","v":""},{"$f":"IF(E91=\"\",\"\",'Weir & Slug'!F92)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E92=\"\",\"\",'Weir & Slug'!E93)","v":""},{"$f":"IF(E92=\"\",\"\",'Weir & Slug'!F93)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E93=\"\",\"\",'Weir & Slug'!E94)","v":""},{"$f":"IF(E93=\"\",\"\",'Weir & Slug'!F94)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E94=\"\",\"\",'Weir & Slug'!E95)","v":""},{"$f":"IF(E94=\"\",\"\",'Weir & Slug'!F95)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E95=\"\",\"\",'Weir & Slug'!E96)","v":""},{"$f":"IF(E95=\"\",\"\",'Weir & Slug'!F96)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E96=\"\",\"\",'Weir & Slug'!E97)","v":""},{"$f":"IF(E96=\"\",\"\",'Weir & Slug'!F97)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E97=\"\",\"\",'Weir & Slug'!E98)","v":""},{"$f":"IF(E97=\"\",\"\",'Weir & Slug'!F98)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E98=\"\",\"\",'Weir & Slug'!E99)","v":""},{"$f":"IF(E98=\"\",\"\",'Weir & Slug'!F99)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E99=\"\",\"\",'Weir & Slug'!E100)","v":""},{"$f":"IF(E99=\"\",\"\",'Weir & Slug'!F100)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E100=\"\",\"\",'Weir & Slug'!E101)","v":""},{"$f":"IF(E100=\"\",\"\",'Weir & Slug'!F101)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E101=\"\",\"\",'Weir & Slug'!E102)","v":""},{"$f":"IF(E101=\"\",\"\",'Weir & Slug'!F102)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E102=\"\",\"\",'Weir & Slug'!E103)","v":""},{"$f":"IF(E102=\"\",\"\",'Weir & Slug'!F103)","v":""},"",{"$f":"IF(E102=\"\",\"\",IF(E102>1.8*Pipe_Diam/12,H102,IF(H102=0,MAX(F102,G102),MIN(MAX(F102,G102),H102))))","v":""},null,"",null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(D102=\"\",\"\",IF(D102>=high_water,\"\",IF(K102=\"Full Pipe Flow\",(INT((D102)/change_inc)+1)*change_inc,D102+NonFPincr)))","v":""},"",{"$f":"IF(E103=\"\",\"\",'Weir & Slug'!E104)","v":""},{"$f":"IF(E103=\"\",\"\",'Weir & Slug'!F104)","v":""},"","",null,"",null,null,null,null,null,null,{"$f":"IF(D103=\"\",\"\",IF(H103=I103,H103,\"\"))","v":""}]
[null,null,null,"","",{"$f":"IF(E104=\"\",\"\",'Weir & Slug'!E105)","v":""},{"$f":"IF(E104=\"\",\"\",'Weir & Slug'!F105)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E105=\"\",\"\",'Weir & Slug'!E106)","v":""},{"$f":"IF(E105=\"\",\"\",'Weir & Slug'!F106)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E106=\"\",\"\",'Weir & Slug'!E107)","v":""},{"$f":"IF(E106=\"\",\"\",'Weir & Slug'!F107)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E107=\"\",\"\",'Weir & Slug'!E108)","v":""},{"$f":"IF(E107=\"\",\"\",'Weir & Slug'!F108)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E108=\"\",\"\",'Weir & Slug'!E109)","v":""},{"$f":"IF(E108=\"\",\"\",'Weir & Slug'!F109)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E109=\"\",\"\",'Weir & Slug'!E110)","v":""},{"$f":"IF(E109=\"\",\"\",'Weir & Slug'!F110)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E110=\"\",\"\",'Weir & Slug'!E111)","v":""},{"$f":"IF(E110=\"\",\"\",'Weir & Slug'!F111)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E111=\"\",\"\",'Weir & Slug'!E112)","v":""},{"$f":"IF(E111=\"\",\"\",'Weir & Slug'!F112)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E112=\"\",\"\",'Weir & Slug'!E113)","v":""},{"$f":"IF(E112=\"\",\"\",'Weir & Slug'!F113)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E113=\"\",\"\",'Weir & Slug'!E114)","v":""},{"$f":"IF(E113=\"\",\"\",'Weir & Slug'!F114)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E114=\"\",\"\",'Weir & Slug'!E115)","v":""},{"$f":"IF(E114=\"\",\"\",'Weir & Slug'!F115)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E115=\"\",\"\",'Weir & Slug'!E116)","v":""},{"$f":"IF(E115=\"\",\"\",'Weir & Slug'!F116)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E116=\"\",\"\",'Weir & Slug'!E117)","v":""},{"$f":"IF(E116=\"\",\"\",'Weir & Slug'!F117)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E117=\"\",\"\",'Weir & Slug'!E118)","v":""},{"$f":"IF(E117=\"\",\"\",'Weir & Slug'!F118)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E118=\"\",\"\",'Weir & Slug'!E119)","v":""},{"$f":"IF(E118=\"\",\"\",'Weir & Slug'!F119)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E119=\"\",\"\",'Weir & Slug'!E120)","v":""},{"$f":"IF(E119=\"\",\"\",'Weir & Slug'!F120)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E120=\"\",\"\",'Weir & Slug'!E121)","v":""},{"$f":"IF(E120=\"\",\"\",'Weir & Slug'!F121)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E121=\"\",\"\",'Weir & Slug'!E122)","v":""},{"$f":"IF(E121=\"\",\"\",'Weir & Slug'!F122)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E122=\"\",\"\",'Weir & Slug'!E123)","v":""},{"$f":"IF(E122=\"\",\"\",'Weir & Slug'!F123)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E123=\"\",\"\",'Weir & Slug'!E124)","v":""},{"$f":"IF(E123=\"\",\"\",'Weir & Slug'!F124)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E124=\"\",\"\",'Weir & Slug'!E125)","v":""},{"$f":"IF(E124=\"\",\"\",'Weir & Slug'!F125)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E125=\"\",\"\",'Weir & Slug'!E126)","v":""},{"$f":"IF(E125=\"\",\"\",'Weir & Slug'!F126)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E126=\"\",\"\",'Weir & Slug'!E127)","v":""},{"$f":"IF(E126=\"\",\"\",'Weir & Slug'!F127)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E127=\"\",\"\",'Weir & Slug'!E128)","v":""},{"$f":"IF(E127=\"\",\"\",'Weir & Slug'!F128)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E128=\"\",\"\",'Weir & Slug'!E129)","v":""},{"$f":"IF(E128=\"\",\"\",'Weir & Slug'!F129)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E129=\"\",\"\",'Weir & Slug'!E130)","v":""},{"$f":"IF(E129=\"\",\"\",'Weir & Slug'!F130)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E130=\"\",\"\",'Weir & Slug'!E131)","v":""},{"$f":"IF(E130=\"\",\"\",'Weir & Slug'!F131)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E131=\"\",\"\",'Weir & Slug'!E132)","v":""},{"$f":"IF(E131=\"\",\"\",'Weir & Slug'!F132)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E132=\"\",\"\",'Weir & Slug'!E133)","v":""},{"$f":"IF(E132=\"\",\"\",'Weir & Slug'!F133)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E133=\"\",\"\",'Weir & Slug'!E134)","v":""},{"$f":"IF(E133=\"\",\"\",'Weir & Slug'!F134)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E134=\"\",\"\",'Weir & Slug'!E135)","v":""},{"$f":"IF(E134=\"\",\"\",'Weir & Slug'!F135)","v":""},"",{"$f":"IF(E134=\"\",\"\",IF(E134>1.8*Pipe_Diam/12,H134,IF(H134=0,MAX(F134,G134),MIN(MAX(F134,G134),H134))))","v":""},null,"",null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(D134=\"\",\"\",IF(D134>=high_water,\"\",IF(K134=\"Full Pipe Flow\",(INT((D134)/change_inc)+1)*change_inc,D134+NonFPincr)))","v":""},"",{"$f":"IF(E135=\"\",\"\",'Weir & Slug'!E136)","v":""},{"$f":"IF(E135=\"\",\"\",'Weir & Slug'!F136)","v":""},{"$f":"IF(E135=\"\",\"\",IF(D135-TailW<0,0,Barea*((64.4*(D135-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5))","v":""},"",null,{"$f":"IF(E135=\"\",\"\",IF(I135=F135,\"Weir Flow\",IF(I135=H135,\"Full Pipe Flow\",\"Slug Flow\")))","v":""},null,null,null,null,null,null,{"$f":"IF(D135=\"\",\"\",IF(H135=I135,H135,\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(D136=\"\",\"\",D136-crest)","v":""},{"$f":"IF(E136=\"\",\"\",'Weir & Slug'!E137)","v":""},{"$f":"IF(E136=\"\",\"\",'Weir & Slug'!F137)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E137=\"\",\"\",'Weir & Slug'!E138)","v":""},{"$f":"IF(E137=\"\",\"\",'Weir & Slug'!F138)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E138=\"\",\"\",'Weir & Slug'!E139)","v":""},{"$f":"IF(E138=\"\",\"\",'Weir & Slug'!F139)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E139=\"\",\"\",'Weir & Slug'!E140)","v":""},{"$f":"IF(E139=\"\",\"\",'Weir & Slug'!F140)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E140=\"\",\"\",'Weir & Slug'!E141)","v":""},{"$f":"IF(E140=\"\",\"\",'Weir & Slug'!F141)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E141=\"\",\"\",'Weir & Slug'!E142)","v":""},{"$f":"IF(E141=\"\",\"\",'Weir & Slug'!F142)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E142=\"\",\"\",'Weir & Slug'!E143)","v":""},{"$f":"IF(E142=\"\",\"\",'Weir & Slug'!F143)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E143=\"\",\"\",'Weir & Slug'!E144)","v":""},{"$f":"IF(E143=\"\",\"\",'Weir & Slug'!F144)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E144=\"\",\"\",'Weir & Slug'!E145)","v":""},{"$f":"IF(E144=\"\",\"\",'Weir & Slug'!F145)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E145=\"\",\"\",'Weir & Slug'!E146)","v":""},{"$f":"IF(E145=\"\",\"\",'Weir & Slug'!F146)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E146=\"\",\"\",'Weir & Slug'!E147)","v":""},{"$f":"IF(E146=\"\",\"\",'Weir & Slug'!F147)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E147=\"\",\"\",'Weir & Slug'!E148)","v":""},{"$f":"IF(E147=\"\",\"\",'Weir & Slug'!F148)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E148=\"\",\"\",'Weir & Slug'!E149)","v":""},{"$f":"IF(E148=\"\",\"\",'Weir & Slug'!F149)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E149=\"\",\"\",'Weir & Slug'!E150)","v":""},{"$f":"IF(E149=\"\",\"\",'Weir & Slug'!F150)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E150=\"\",\"\",'Weir & Slug'!E151)","v":""},{"$f":"IF(E150=\"\",\"\",'Weir & Slug'!F151)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E151=\"\",\"\",'Weir & Slug'!E152)","v":""},{"$f":"IF(E151=\"\",\"\",'Weir & Slug'!F152)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E152=\"\",\"\",'Weir & Slug'!E153)","v":""},{"$f":"IF(E152=\"\",\"\",'Weir & Slug'!F153)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E153=\"\",\"\",'Weir & Slug'!E154)","v":""},{"$f":"IF(E153=\"\",\"\",'Weir & Slug'!F154)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E154=\"\",\"\",'Weir & Slug'!E155)","v":""},{"$f":"IF(E154=\"\",\"\",'Weir & Slug'!F155)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E155=\"\",\"\",'Weir & Slug'!E156)","v":""},{"$f":"IF(E155=\"\",\"\",'Weir & Slug'!F156)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E156=\"\",\"\",'Weir & Slug'!E157)","v":""},{"$f":"IF(E156=\"\",\"\",'Weir & Slug'!F157)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E157=\"\",\"\",'Weir & Slug'!E158)","v":""},{"$f":"IF(E157=\"\",\"\",'Weir & Slug'!F158)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E158=\"\",\"\",'Weir & Slug'!E159)","v":""},{"$f":"IF(E158=\"\",\"\",'Weir & Slug'!F159)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E159=\"\",\"\",'Weir & Slug'!E160)","v":""},{"$f":"IF(E159=\"\",\"\",'Weir & Slug'!F160)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E160=\"\",\"\",'Weir & Slug'!E161)","v":""},{"$f":"IF(E160=\"\",\"\",'Weir & Slug'!F161)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E161=\"\",\"\",'Weir & Slug'!E162)","v":""},{"$f":"IF(E161=\"\",\"\",'Weir & Slug'!F162)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E162=\"\",\"\",'Weir & Slug'!E163)","v":""},{"$f":"IF(E162=\"\",\"\",'Weir & Slug'!F163)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E163=\"\",\"\",'Weir & Slug'!E164)","v":""},{"$f":"IF(E163=\"\",\"\",'Weir & Slug'!F164)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E164=\"\",\"\",'Weir & Slug'!E165)","v":""},{"$f":"IF(E164=\"\",\"\",'Weir & Slug'!F165)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E165=\"\",\"\",'Weir & Slug'!E166)","v":""},{"$f":"IF(E165=\"\",\"\",'Weir & Slug'!F166)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E166=\"\",\"\",'Weir & Slug'!E167)","v":""},{"$f":"IF(E166=\"\",\"\",'Weir & Slug'!F167)","v":""},"",{"$f":"IF(E166=\"\",\"\",IF(E166>1.8*Pipe_Diam/12,H166,IF(H166=0,MAX(F166,G166),MIN(MAX(F166,G166),H166))))","v":""},null,"",null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(D166=\"\",\"\",IF(D166>=high_water,\"\",IF(K166=\"Full Pipe Flow\",(INT((D166)/change_inc)+1)*change_inc,D166+NonFPincr)))","v":""},"",{"$f":"IF(E167=\"\",\"\",'Weir & Slug'!E168)","v":""},{"$f":"IF(E167=\"\",\"\",'Weir & Slug'!F168)","v":""},"","",null,"",null,null,null,null,null,null,{"$f":"IF(D167=\"\",\"\",IF(H167=I167,H167,\"\"))","v":""}]
[null,null,null,"","",{"$f":"IF(E168=\"\",\"\",'Weir & Slug'!E169)","v":""},{"$f":"IF(E168=\"\",\"\",'Weir & Slug'!F169)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E169=\"\",\"\",'Weir & Slug'!E170)","v":""},{"$f":"IF(E169=\"\",\"\",'Weir & Slug'!F170)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E170=\"\",\"\",'Weir & Slug'!E171)","v":""},{"$f":"IF(E170=\"\",\"\",'Weir & Slug'!F171)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E171=\"\",\"\",'Weir & Slug'!E172)","v":""},{"$f":"IF(E171=\"\",\"\",'Weir & Slug'!F172)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E172=\"\",\"\",'Weir & Slug'!E173)","v":""},{"$f":"IF(E172=\"\",\"\",'Weir & Slug'!F173)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E173=\"\",\"\",'Weir & Slug'!E174)","v":""},{"$f":"IF(E173=\"\",\"\",'Weir & Slug'!F174)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E174=\"\",\"\",'Weir & Slug'!E175)","v":""},{"$f":"IF(E174=\"\",\"\",'Weir & Slug'!F175)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E175=\"\",\"\",'Weir & Slug'!E176)","v":""},{"$f":"IF(E175=\"\",\"\",'Weir & Slug'!F176)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E176=\"\",\"\",'Weir & Slug'!E177)","v":""},{"$f":"IF(E176=\"\",\"\",'Weir & Slug'!F177)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E177=\"\",\"\",'Weir & Slug'!E178)","v":""},{"$f":"IF(E177=\"\",\"\",'Weir & Slug'!F178)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E178=\"\",\"\",'Weir & Slug'!E179)","v":""},{"$f":"IF(E178=\"\",\"\",'Weir & Slug'!F179)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E179=\"\",\"\",'Weir & Slug'!E180)","v":""},{"$f":"IF(E179=\"\",\"\",'Weir & Slug'!F180)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E180=\"\",\"\",'Weir & Slug'!E181)","v":""},{"$f":"IF(E180=\"\",\"\",'Weir & Slug'!F181)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E181=\"\",\"\",'Weir & Slug'!E182)","v":""},{"$f":"IF(E181=\"\",\"\",'Weir & Slug'!F182)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E182=\"\",\"\",'Weir & Slug'!E183)","v":""},{"$f":"IF(E182=\"\",\"\",'Weir & Slug'!F183)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E183=\"\",\"\",'Weir & Slug'!E184)","v":""},{"$f":"IF(E183=\"\",\"\",'Weir & Slug'!F184)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E184=\"\",\"\",'Weir & Slug'!E185)","v":""},{"$f":"IF(E184=\"\",\"\",'Weir & Slug'!F185)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E185=\"\",\"\",'Weir & Slug'!E186)","v":""},{"$f":"IF(E185=\"\",\"\",'Weir & Slug'!F186)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E186=\"\",\"\",'Weir & Slug'!E187)","v":""},{"$f":"IF(E186=\"\",\"\",'Weir & Slug'!F187)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E187=\"\",\"\",'Weir & Slug'!E188)","v":""},{"$f":"IF(E187=\"\",\"\",'Weir & Slug'!F188)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E188=\"\",\"\",'Weir & Slug'!E189)","v":""},{"$f":"IF(E188=\"\",\"\",'Weir & Slug'!F189)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E189=\"\",\"\",'Weir & Slug'!E190)","v":""},{"$f":"IF(E189=\"\",\"\",'Weir & Slug'!F190)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E190=\"\",\"\",'Weir & Slug'!E191)","v":""},{"$f":"IF(E190=\"\",\"\",'Weir & Slug'!F191)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E191=\"\",\"\",'Weir & Slug'!E192)","v":""},{"$f":"IF(E191=\"\",\"\",'Weir & Slug'!F192)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E192=\"\",\"\",'Weir & Slug'!E193)","v":""},{"$f":"IF(E192=\"\",\"\",'Weir & Slug'!F193)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E193=\"\",\"\",'Weir & Slug'!E194)","v":""},{"$f":"IF(E193=\"\",\"\",'Weir & Slug'!F194)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E194=\"\",\"\",'Weir & Slug'!E195)","v":""},{"$f":"IF(E194=\"\",\"\",'Weir & Slug'!F195)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E195=\"\",\"\",'Weir & Slug'!E196)","v":""},{"$f":"IF(E195=\"\",\"\",'Weir & Slug'!F196)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E196=\"\",\"\",'Weir & Slug'!E197)","v":""},{"$f":"IF(E196=\"\",\"\",'Weir & Slug'!F197)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E197=\"\",\"\",'Weir & Slug'!E198)","v":""},{"$f":"IF(E197=\"\",\"\",'Weir & Slug'!F198)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E198=\"\",\"\",'Weir & Slug'!E199)","v":""},{"$f":"IF(E198=\"\",\"\",'Weir & Slug'!F199)","v":""},"",{"$f":"IF(E198=\"\",\"\",IF(E198>1.8*Pipe_Diam/12,H198,IF(H198=0,MAX(F198,G198),MIN(MAX(F198,G198),H198))))","v":""},null,"",null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(D198=\"\",\"\",IF(D198>=high_water,\"\",IF(K198=\"Full Pipe Flow\",(INT((D198)/change_inc)+1)*change_inc,D198+NonFPincr)))","v":""},"",{"$f":"IF(E199=\"\",\"\",'Weir & Slug'!E200)","v":""},{"$f":"IF(E199=\"\",\"\",'Weir & Slug'!F200)","v":""},{"$f":"IF(E199=\"\",\"\",IF(D199-TailW<0,0,Barea*((64.4*(D199-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5))","v":""},"",null,{"$f":"IF(E199=\"\",\"\",IF(I199=F199,\"Weir Flow\",IF(I199=H199,\"Full Pipe Flow\",\"Slug Flow\")))","v":""},null,null,null,null,null,null,{"$f":"IF(D199=\"\",\"\",IF(H199=I199,H199,\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(D200=\"\",\"\",D200-crest)","v":""},{"$f":"IF(E200=\"\",\"\",'Weir & Slug'!E201)","v":""},{"$f":"IF(E200=\"\",\"\",'Weir & Slug'!F201)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E201=\"\",\"\",'Weir & Slug'!E202)","v":""},{"$f":"IF(E201=\"\",\"\",'Weir & Slug'!F202)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E202=\"\",\"\",'Weir & Slug'!E203)","v":""},{"$f":"IF(E202=\"\",\"\",'Weir & Slug'!F203)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E203=\"\",\"\",'Weir & Slug'!E204)","v":""},{"$f":"IF(E203=\"\",\"\",'Weir & Slug'!F204)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E204=\"\",\"\",'Weir & Slug'!E205)","v":""},{"$f":"IF(E204=\"\",\"\",'Weir & Slug'!F205)","v":""},"","",null,"",null,null,null,null,null,null,""]
[null,null,null,"","",{"$f":"IF(E205=\"\",\"\",'Weir & Slug'!E206)","v":""},{"$f":"IF(E205=\"\",\"\",'Weir & Slug'!F206)","v":""},"","",null,"",null,null,null,null,null,null,""]

{"sheet":"Flow Data","index":1,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["Elev","Full Pipe"," Structure Outflow"]
[{"$f":"'Hood Inlet'!D6","v":1083.5},{"$f":"'Hood Inlet'!H6","v":38.300702046688954},{"$f":"'Hood Inlet'!I6","v":0}]
[{"$f":"'Hood Inlet'!D7","v":1083.5999999999999},{"$f":"'Hood Inlet'!H7","v":38.406945529692045},{"$f":"'Hood Inlet'!I7","v":3.9218296572715874E-2}]
[{"$f":"'Hood Inlet'!D8","v":1083.6999999999998},{"$f":"'Hood Inlet'!H8","v":38.512895925549671},{"$f":"'Hood Inlet'!I8","v":0.15720982708192952}]
[{"$f":"'Hood Inlet'!D9","v":1083.7999999999997},{"$f":"'Hood Inlet'!H9","v":38.618555646524491},{"$f":"'Hood Inlet'!I9","v":0.35416716640216822}]
[{"$f":"'Hood Inlet'!D10","v":1083.8999999999996},{"$f":"'Hood Inlet'!H10","v":38.7239270719693},{"$f":"'Hood Inlet'!I10","v":0.62984210049717815}]
[{"$f":"'Hood Inlet'!D11","v":1083.9999999999995},{"$f":"'Hood Inlet'!H11","v":38.829012548952171},{"$f":"'Hood Inlet'!I11","v":0.98351103185676458}]
[{"$f":"'Hood Inlet'!D12","v":1084.0999999999995},{"$f":"'Hood Inlet'!H12","v":38.933814392866438},{"$f":"'Hood Inlet'!I12","v":1.413934153631609}]
[{"$f":"'Hood Inlet'!D13","v":1084.1999999999994},{"$f":"'Hood Inlet'!H13","v":39.038334888025922},{"$f":"'Hood Inlet'!I13","v":1.9193066669147465}]
[{"$f":"'Hood Inlet'!D14","v":1084.2999999999993},{"$f":"'Hood Inlet'!H14","v":39.142576288245905},{"$f":"'Hood Inlet'!I14","v":2.49719965562783}]
[{"$f":"'Hood Inlet'!D15","v":1084.3999999999992},{"$f":"'Hood Inlet'!H15","v":39.246540817410121},{"$f":"'Hood Inlet'!I15","v":3.1444872417085783}]
[{"$f":"'Hood Inlet'!D16","v":1084.4999999999991},{"$f":"'Hood Inlet'!H16","v":39.350230670024381},{"$f":"'Hood Inlet'!I16","v":3.8572551064028775}]
[{"$f":"'Hood Inlet'!D17","v":1084.599999999999},{"$f":"'Hood Inlet'!H17","v":39.453648011756982},{"$f":"'Hood Inlet'!I17","v":4.6306829951216733}]
[{"$f":"'Hood Inlet'!D18","v":1084.6999999999989},{"$f":"'Hood Inlet'!H18","v":39.556794979966519},{"$f":"'Hood Inlet'!I18","v":5.4588896886839242}]
[{"$f":"'Hood Inlet'!D19","v":1084.7999999999988},{"$f":"'Hood Inlet'!H19","v":39.659673684217225},{"$f":"'Hood Inlet'!I19","v":6.3347216407549753}]
[{"$f":"'Hood Inlet'!D20","v":1084.8999999999987},{"$f":"'Hood Inlet'!H20","v":39.762286206782434},{"$f":"'Hood Inlet'!I20","v":7.2494528414019985}]
[{"$f":"'Hood Inlet'!D21","v":1084.9999999999986},{"$f":"'Hood Inlet'!H21","v":39.86463460313626},{"$f":"'Hood Inlet'!I21","v":8.192335886865628}]
[{"$f":"'Hood Inlet'!D22","v":1085.0999999999985},{"$f":"'Hood Inlet'!H22","v":39.966720902434034},{"$f":"'Hood Inlet'!I22","v":9.1498826640041298}]
[{"$f":"'Hood Inlet'!D23","v":1085.1999999999985},{"$f":"'Hood Inlet'!H23","v":40.068547107981665},{"$f":"'Hood Inlet'!I23","v":10.104595861964423}]
[{"$f":"'Hood Inlet'!D24","v":1085.2999999999984},{"$f":"'Hood Inlet'!H24","v":40.170115197694344},{"$f":"'Hood Inlet'!I24","v":11.03238441543335}]
[{"$f":"'Hood Inlet'!D25","v":1085.3999999999983},{"$f":"'Hood Inlet'!H25","v":40.2714271245448},{"$f":"'Hood Inlet'!I25","v":11.895791363304415}]
[{"$f":"'Hood Inlet'!D26","v":1085.4999999999982},{"$f":"'Hood Inlet'!H26","v":40.372484817001435},{"$f":"'Hood Inlet'!I26","v":12.607021244873684}]
[{"$f":"'Hood Inlet'!D27","v":1085.5999999999981},{"$f":"'Hood Inlet'!H27","v":40.473290179456619},{"$f":"'Hood Inlet'!I27","v":13.092249121116769}]
[{"$f":"'Hood Inlet'!D28","v":1085.699999999998},{"$f":"'Hood Inlet'!H28","v":40.573845092645435},{"$f":"'Hood Inlet'!I28","v":13.578332958072703}]
[{"$f":"'Hood Inlet'!D29","v":1085.7999999999979},{"$f":"'Hood Inlet'!H29","v":40.674151414055046},{"$f":"'Hood Inlet'!I29","v":14.065491149668338}]
[{"$f":"'Hood Inlet'!D30","v":1085.8999999999978},{"$f":"'Hood Inlet'!H30","v":40.774210978325073},{"$f":"'Hood Inlet'!I30","v":14.553912639999163}]
[{"$f":"'Hood Inlet'!D31","v":1085.9999999999977},{"$f":"'Hood Inlet'!H31","v":40.874025597639054},{"$f":"'Hood Inlet'!I31","v":15.043761546710007}]
[{"$f":"'Hood Inlet'!D32","v":1086.0999999999976},{"$f":"'Hood Inlet'!H32","v":40.973597062107466},{"$f":"'Hood Inlet'!I32","v":15.535180922861123}]
[{"$f":"'Hood Inlet'!D33","v":1086.1999999999975},{"$f":"'Hood Inlet'!H33","v":41.072927140142198},{"$f":"'Hood Inlet'!I33","v":16.028295842914797}]
[{"$f":"'Hood Inlet'!D34","v":1086.2999999999975},{"$f":"'Hood Inlet'!H34","v":41.172017578823095},{"$f":"'Hood Inlet'!I34","v":16.523215953324144}]
[{"$f":"'Hood Inlet'!D35","v":1086.3999999999974},{"$f":"'Hood Inlet'!H35","v":41.270870104256424},{"$f":"'Hood Inlet'!I35","v":17.020037595216568}]
[{"$f":"'Hood Inlet'!D36","v":1086.4999999999973},{"$f":"'Hood Inlet'!H36","v":41.3694864219257},{"$f":"'Hood Inlet'!I36","v":17.518845582263666}]
[{"$f":"'Hood Inlet'!D37","v":1086.5999999999972},{"$f":"'Hood Inlet'!H37","v":41.467868217035019},{"$f":"'Hood Inlet'!I37","v":18.019714698574649}]
[{"$f":"'Hood Inlet'!D38","v":1086.6999999999971},{"$f":"'Hood Inlet'!H38","v":41.566017154845035},{"$f":"'Hood Inlet'!I38","v":18.522710967649122}]
[{"$f":"'Hood Inlet'!D39","v":1086.799999999997},{"$f":"'Hood Inlet'!H39","v":41.663934881001822},{"$f":"'Hood Inlet'!I39","v":20.364675297832992}]
[{"$f":"'Hood Inlet'!D40","v":1086.8999999999969},{"$f":"'Hood Inlet'!H40","v":41.761623021858817},{"$f":"'Hood Inlet'!I40","v":31.678383796807463}]
[{"$f":"'Hood Inlet'!D41","v":1086.9999999999968},{"$f":"'Hood Inlet'!H41","v":41.859083184792006},{"$f":"'Hood Inlet'!I41","v":41.859083184792006}]
[{"$f":"'Hood Inlet'!D42","v":1087},{"$f":"'Hood Inlet'!H42","v":41.859083184795104},{"$f":"'Hood Inlet'!I42","v":41.859083184795104}]
[{"$f":"'Hood Inlet'!D43","v":1087.2},{"$f":"'Hood Inlet'!H43","v":42.053325913351863},{"$f":"'Hood Inlet'!I43","v":42.053325913351863}]
[{"$f":"'Hood Inlet'!D44","v":1087.4000000000001},{"$f":"'Hood Inlet'!H44","v":42.246675557700243},{"$f":"'Hood Inlet'!I44","v":42.246675557700243}]
[{"$f":"'Hood Inlet'!D45","v":1087.6000000000001},{"$f":"'Hood Inlet'!H45","v":42.439144324321411},{"$f":"'Hood Inlet'!I45","v":42.439144324321411}]
[{"$f":"'Hood Inlet'!D46","v":1087.8},{"$f":"'Hood Inlet'!H46","v":42.630744144145069},{"$f":"'Hood Inlet'!I46","v":42.630744144145069}]
[{"$f":"'Hood Inlet'!D47","v":1088},{"$f":"'Hood Inlet'!H47","v":42.821486681180915},{"$f":"'Hood Inlet'!I47","v":42.821486681180915}]
[{"$f":"'Hood Inlet'!D48","v":1088.2},{"$f":"'Hood Inlet'!H48","v":43.011383340803512},{"$f":"'Hood Inlet'!I48","v":43.011383340803512}]
[{"$f":"'Hood Inlet'!D49","v":1088.4000000000001},{"$f":"'Hood Inlet'!H49","v":43.200445277711488},{"$f":"'Hood Inlet'!I49","v":43.200445277711488}]
[{"$f":"'Hood Inlet'!D50","v":1088.6000000000001},{"$f":"'Hood Inlet'!H50","v":43.388683403573566},{"$f":"'Hood Inlet'!I50","v":43.388683403573566}]
[{"$f":"'Hood Inlet'!D51","v":1088.8},{"$f":"'Hood Inlet'!H51","v":43.576108394377265},{"$f":"'Hood Inlet'!I51","v":43.576108394377265}]
[{"$f":"'Hood Inlet'!D52","v":1089},{"$f":"'Hood Inlet'!H52","v":43.762730697495471},{"$f":"'Hood Inlet'!I52","v":43.762730697495471}]
[{"$f":"'Hood Inlet'!D53","v":1089.2},{"$f":"'Hood Inlet'!H53","v":43.948560538480756},{"$f":"'Hood Inlet'!I53","v":43.948560538480756}]
[{"$f":"'Hood Inlet'!D54","v":1089.4000000000001},{"$f":"'Hood Inlet'!H54","v":44.133607927604366},{"$f":"'Hood Inlet'!I54","v":44.133607927604366}]
[{"$f":"'Hood Inlet'!D55","v":1089.6000000000001},{"$f":"'Hood Inlet'!H55","v":44.317882666148414},{"$f":"'Hood Inlet'!I55","v":44.317882666148414}]
[{"$f":"'Hood Inlet'!D56","v":1089.8},{"$f":"'Hood Inlet'!H56","v":44.501394352463549},{"$f":"'Hood Inlet'!I56","v":44.501394352463549}]
[{"$f":"'Hood Inlet'!D57","v":1090},{"$f":"'Hood Inlet'!H57","v":44.684152387803778},{"$f":"'Hood Inlet'!I57","v":44.684152387803778}]
[{"$f":"'Hood Inlet'!D58","v":1090.2},{"$f":"'Hood Inlet'!H58","v":44.866165981945301},{"$f":"'Hood Inlet'!I58","v":44.866165981945301}]
[{"$f":"'Hood Inlet'!D59","v":1090.4000000000001},{"$f":"'Hood Inlet'!H59","v":45.047444158603064},{"$f":"'Hood Inlet'!I59","v":45.047444158603064}]
[{"$f":"'Hood Inlet'!D60","v":1090.6000000000001},{"$f":"'Hood Inlet'!H60","v":45.227995760650906},{"$f":"'Hood Inlet'!I60","v":45.227995760650906}]
[{"$f":"'Hood Inlet'!D61","v":1090.8},{"$f":"'Hood Inlet'!H61","v":45.407829455154904},{"$f":"'Hood Inlet'!I61","v":45.407829455154904}]
[{"$f":"'Hood Inlet'!D62","v":1091},{"$f":"'Hood Inlet'!H62","v":45.586953738228971},{"$f":"'Hood Inlet'!I62","v":45.586953738228971}]
[{"$f":"'Hood Inlet'!D63","v":""},{"$f":"'Hood Inlet'!H63","v":""},{"$f":"'Hood Inlet'!I63","v":""}]
[{"$f":"'Hood Inlet'!D64","v":""},{"$f":"'Hood Inlet'!H64","v":""},{"$f":"'Hood Inlet'!I64","v":""}]
[{"$f":"'Hood Inlet'!D65","v":""},{"$f":"'Hood Inlet'!H65","v":""},{"$f":"'Hood Inlet'!I65","v":""}]
[{"$f":"'Hood Inlet'!D66","v":""},{"$f":"'Hood Inlet'!H66","v":""},{"$f":"'Hood Inlet'!I66","v":""}]
[{"$f":"'Hood Inlet'!D67","v":""},{"$f":"'Hood Inlet'!H67","v":""},{"$f":"'Hood Inlet'!I67","v":""}]
[{"$f":"'Hood Inlet'!D68","v":""},{"$f":"'Hood Inlet'!H68","v":""},{"$f":"'Hood Inlet'!I68","v":""}]
[{"$f":"'Hood Inlet'!D69","v":""},{"$f":"'Hood Inlet'!H69","v":""},{"$f":"'Hood Inlet'!I69","v":""}]
[{"$f":"'Hood Inlet'!D70","v":""},{"$f":"'Hood Inlet'!H70","v":""},{"$f":"'Hood Inlet'!I70","v":""}]
[{"$f":"'Hood Inlet'!D71","v":""},{"$f":"'Hood Inlet'!H71","v":""},{"$f":"'Hood Inlet'!I71","v":""}]
[{"$f":"'Hood Inlet'!D72","v":""},{"$f":"'Hood Inlet'!H72","v":""},{"$f":"'Hood Inlet'!I72","v":""}]
[{"$f":"'Hood Inlet'!D73","v":""},{"$f":"'Hood Inlet'!H73","v":""},{"$f":"'Hood Inlet'!I73","v":""}]
[{"$f":"'Hood Inlet'!D74","v":""},{"$f":"'Hood Inlet'!H74","v":""},{"$f":"'Hood Inlet'!I74","v":""}]
[{"$f":"'Hood Inlet'!D75","v":""},{"$f":"'Hood Inlet'!H75","v":""},{"$f":"'Hood Inlet'!I75","v":""}]
[{"$f":"'Hood Inlet'!D76","v":""},{"$f":"'Hood Inlet'!H76","v":""},{"$f":"'Hood Inlet'!I76","v":""}]
[{"$f":"'Hood Inlet'!D77","v":""},{"$f":"'Hood Inlet'!H77","v":""},{"$f":"'Hood Inlet'!I77","v":""}]
[{"$f":"'Hood Inlet'!D78","v":""},{"$f":"'Hood Inlet'!H78","v":""},{"$f":"'Hood Inlet'!I78","v":""}]
[{"$f":"'Hood Inlet'!D79","v":""},{"$f":"'Hood Inlet'!H79","v":""},{"$f":"'Hood Inlet'!I79","v":""}]
[{"$f":"'Hood Inlet'!D80","v":""},{"$f":"'Hood Inlet'!H80","v":""},{"$f":"'Hood Inlet'!I80","v":""}]
[{"$f":"'Hood Inlet'!D81","v":""},{"$f":"'Hood Inlet'!H81","v":""},{"$f":"'Hood Inlet'!I81","v":""}]
[{"$f":"'Hood Inlet'!D82","v":""},{"$f":"'Hood Inlet'!H82","v":""},{"$f":"'Hood Inlet'!I82","v":""}]
[{"$f":"'Hood Inlet'!D83","v":""},{"$f":"'Hood Inlet'!H83","v":""},{"$f":"'Hood Inlet'!I83","v":""}]
[{"$f":"'Hood Inlet'!D84","v":""},{"$f":"'Hood Inlet'!H84","v":""},{"$f":"'Hood Inlet'!I84","v":""}]
[{"$f":"'Hood Inlet'!D85","v":""},{"$f":"'Hood Inlet'!H85","v":""},{"$f":"'Hood Inlet'!I85","v":""}]
[{"$f":"'Hood Inlet'!D86","v":""},{"$f":"'Hood Inlet'!H86","v":""},{"$f":"'Hood Inlet'!I86","v":""}]
[{"$f":"'Hood Inlet'!D87","v":""},{"$f":"'Hood Inlet'!H87","v":""},{"$f":"'Hood Inlet'!I87","v":""}]
[{"$f":"'Hood Inlet'!D88","v":""},{"$f":"'Hood Inlet'!H88","v":""},{"$f":"'Hood Inlet'!I88","v":""}]
[{"$f":"'Hood Inlet'!D89","v":""},{"$f":"'Hood Inlet'!H89","v":""},{"$f":"'Hood Inlet'!I89","v":""}]
[{"$f":"'Hood Inlet'!D90","v":""},{"$f":"'Hood Inlet'!H90","v":""},{"$f":"'Hood Inlet'!I90","v":""}]
[{"$f":"'Hood Inlet'!D91","v":""},{"$f":"'Hood Inlet'!H91","v":""},{"$f":"'Hood Inlet'!I91","v":""}]
[{"$f":"'Hood Inlet'!D92","v":""},{"$f":"'Hood Inlet'!H92","v":""},{"$f":"'Hood Inlet'!I92","v":""}]
[{"$f":"'Hood Inlet'!D93","v":""},{"$f":"'Hood Inlet'!H93","v":""},{"$f":"'Hood Inlet'!I93","v":""}]
[{"$f":"'Hood Inlet'!D94","v":""},{"$f":"'Hood Inlet'!H94","v":""},{"$f":"'Hood Inlet'!I94","v":""}]
[{"$f":"'Hood Inlet'!D95","v":""},{"$f":"'Hood Inlet'!H95","v":""},{"$f":"'Hood Inlet'!I95","v":""}]
[{"$f":"'Hood Inlet'!D96","v":""},{"$f":"'Hood Inlet'!H96","v":""},{"$f":"'Hood Inlet'!I96","v":""}]
[{"$f":"'Hood Inlet'!D97","v":""},{"$f":"'Hood Inlet'!H97","v":""},{"$f":"'Hood Inlet'!I97","v":""}]
[{"$f":"'Hood Inlet'!D98","v":""},{"$f":"'Hood Inlet'!H98","v":""},{"$f":"'Hood Inlet'!I98","v":""}]
[{"$f":"'Hood Inlet'!D99","v":""},{"$f":"'Hood Inlet'!H99","v":""},{"$f":"'Hood Inlet'!I99","v":""}]
[{"$f":"'Hood Inlet'!D100","v":""},{"$f":"'Hood Inlet'!H100","v":""},{"$f":"'Hood Inlet'!I100","v":""}]
[{"$f":"'Hood Inlet'!D101","v":""},{"$f":"'Hood Inlet'!H101","v":""},{"$f":"'Hood Inlet'!I101","v":""}]
[{"$f":"'Hood Inlet'!D102","v":""},{"$f":"'Hood Inlet'!H102","v":""},{"$f":"'Hood Inlet'!I102","v":""}]
[{"$f":"'Hood Inlet'!D103","v":""},{"$f":"'Hood Inlet'!H103","v":""},{"$f":"'Hood Inlet'!I103","v":""}]
[{"$f":"'Hood Inlet'!D104","v":""},{"$f":"'Hood Inlet'!H104","v":""},{"$f":"'Hood Inlet'!I104","v":""}]
[{"$f":"'Hood Inlet'!D105","v":""},{"$f":"'Hood Inlet'!H105","v":""},{"$f":"'Hood Inlet'!I105","v":""}]
[{"$f":"'Hood Inlet'!D106","v":""},{"$f":"'Hood Inlet'!H106","v":""},{"$f":"'Hood Inlet'!I106","v":""}]
[{"$f":"'Hood Inlet'!D107","v":""},{"$f":"'Hood Inlet'!H107","v":""},{"$f":"'Hood Inlet'!I107","v":""}]
[{"$f":"'Hood Inlet'!D108","v":""},{"$f":"'Hood Inlet'!H108","v":""},{"$f":"'Hood Inlet'!I108","v":""}]
[{"$f":"'Hood Inlet'!D109","v":""},{"$f":"'Hood Inlet'!H109","v":""},{"$f":"'Hood Inlet'!I109","v":""}]
[{"$f":"'Hood Inlet'!D110","v":""},{"$f":"'Hood Inlet'!H110","v":""},{"$f":"'Hood Inlet'!I110","v":""}]
[{"$f":"'Hood Inlet'!D111","v":""},{"$f":"'Hood Inlet'!H111","v":""},{"$f":"'Hood Inlet'!I111","v":""}]
[{"$f":"'Hood Inlet'!D112","v":""},{"$f":"'Hood Inlet'!H112","v":""},{"$f":"'Hood Inlet'!I112","v":""}]
[{"$f":"'Hood Inlet'!D113","v":""},{"$f":"'Hood Inlet'!H113","v":""},{"$f":"'Hood Inlet'!I113","v":""}]
[{"$f":"'Hood Inlet'!D114","v":""},{"$f":"'Hood Inlet'!H114","v":""},{"$f":"'Hood Inlet'!I114","v":""}]
[{"$f":"'Hood Inlet'!D115","v":""},{"$f":"'Hood Inlet'!H115","v":""},{"$f":"'Hood Inlet'!I115","v":""}]
[{"$f":"'Hood Inlet'!D116","v":""},{"$f":"'Hood Inlet'!H116","v":""},{"$f":"'Hood Inlet'!I116","v":""}]
[{"$f":"'Hood Inlet'!D117","v":""},{"$f":"'Hood Inlet'!H117","v":""},{"$f":"'Hood Inlet'!I117","v":""}]
[{"$f":"'Hood Inlet'!D118","v":""},{"$f":"'Hood Inlet'!H118","v":""},{"$f":"'Hood Inlet'!I118","v":""}]
[{"$f":"'Hood Inlet'!D119","v":""},{"$f":"'Hood Inlet'!H119","v":""},{"$f":"'Hood Inlet'!I119","v":""}]
[{"$f":"'Hood Inlet'!D120","v":""},{"$f":"'Hood Inlet'!H120","v":""},{"$f":"'Hood Inlet'!I120","v":""}]
[{"$f":"'Hood Inlet'!D121","v":""},{"$f":"'Hood Inlet'!H121","v":""},{"$f":"'Hood Inlet'!I121","v":""}]
[{"$f":"'Hood Inlet'!D122","v":""},{"$f":"'Hood Inlet'!H122","v":""},{"$f":"'Hood Inlet'!I122","v":""}]
[{"$f":"'Hood Inlet'!D123","v":""},{"$f":"'Hood Inlet'!H123","v":""},{"$f":"'Hood Inlet'!I123","v":""}]
[{"$f":"'Hood Inlet'!D124","v":""},{"$f":"'Hood Inlet'!H124","v":""},{"$f":"'Hood Inlet'!I124","v":""}]
[{"$f":"'Hood Inlet'!D125","v":""},{"$f":"'Hood Inlet'!H125","v":""},{"$f":"'Hood Inlet'!I125","v":""}]
[{"$f":"'Hood Inlet'!D126","v":""},{"$f":"'Hood Inlet'!H126","v":""},{"$f":"'Hood Inlet'!I126","v":""}]
[{"$f":"'Hood Inlet'!D127","v":""},{"$f":"'Hood Inlet'!H127","v":""},{"$f":"'Hood Inlet'!I127","v":""}]
[{"$f":"'Hood Inlet'!D128","v":""},{"$f":"'Hood Inlet'!H128","v":""},{"$f":"'Hood Inlet'!I128","v":""}]
[{"$f":"'Hood Inlet'!D129","v":""},{"$f":"'Hood Inlet'!H129","v":""},{"$f":"'Hood Inlet'!I129","v":""}]
[{"$f":"'Hood Inlet'!D130","v":""},{"$f":"'Hood Inlet'!H130","v":""},{"$f":"'Hood Inlet'!I130","v":""}]
[{"$f":"'Hood Inlet'!D131","v":""},{"$f":"'Hood Inlet'!H131","v":""},{"$f":"'Hood Inlet'!I131","v":""}]
[{"$f":"'Hood Inlet'!D132","v":""},{"$f":"'Hood Inlet'!H132","v":""},{"$f":"'Hood Inlet'!I132","v":""}]
[{"$f":"'Hood Inlet'!D133","v":""},{"$f":"'Hood Inlet'!H133","v":""},{"$f":"'Hood Inlet'!I133","v":""}]
[{"$f":"'Hood Inlet'!D134","v":""},{"$f":"'Hood Inlet'!H134","v":""},{"$f":"'Hood Inlet'!I134","v":""}]
[{"$f":"'Hood Inlet'!D135","v":""},{"$f":"'Hood Inlet'!H135","v":""},{"$f":"'Hood Inlet'!I135","v":""}]
[{"$f":"'Hood Inlet'!D136","v":""},{"$f":"'Hood Inlet'!H136","v":""},{"$f":"'Hood Inlet'!I136","v":""}]
[{"$f":"'Hood Inlet'!D137","v":""},{"$f":"'Hood Inlet'!H137","v":""},{"$f":"'Hood Inlet'!I137","v":""}]
[{"$f":"'Hood Inlet'!D138","v":""},{"$f":"'Hood Inlet'!H138","v":""},{"$f":"'Hood Inlet'!I138","v":""}]
[{"$f":"'Hood Inlet'!D139","v":""},{"$f":"'Hood Inlet'!H139","v":""},{"$f":"'Hood Inlet'!I139","v":""}]
[{"$f":"'Hood Inlet'!D140","v":""},{"$f":"'Hood Inlet'!H140","v":""},{"$f":"'Hood Inlet'!I140","v":""}]
[{"$f":"'Hood Inlet'!D141","v":""},{"$f":"'Hood Inlet'!H141","v":""},{"$f":"'Hood Inlet'!I141","v":""}]
[{"$f":"'Hood Inlet'!D142","v":""},{"$f":"'Hood Inlet'!H142","v":""},{"$f":"'Hood Inlet'!I142","v":""}]
[{"$f":"'Hood Inlet'!D143","v":""},{"$f":"'Hood Inlet'!H143","v":""},{"$f":"'Hood Inlet'!I143","v":""}]
[{"$f":"'Hood Inlet'!D144","v":""},{"$f":"'Hood Inlet'!H144","v":""},{"$f":"'Hood Inlet'!I144","v":""}]
[{"$f":"'Hood Inlet'!D145","v":""},{"$f":"'Hood Inlet'!H145","v":""},{"$f":"'Hood Inlet'!I145","v":""}]
[{"$f":"'Hood Inlet'!D146","v":""},{"$f":"'Hood Inlet'!H146","v":""},{"$f":"'Hood Inlet'!I146","v":""}]
[{"$f":"'Hood Inlet'!D147","v":""},{"$f":"'Hood Inlet'!H147","v":""},{"$f":"'Hood Inlet'!I147","v":""}]
[{"$f":"'Hood Inlet'!D148","v":""},{"$f":"'Hood Inlet'!H148","v":""},{"$f":"'Hood Inlet'!I148","v":""}]
[{"$f":"'Hood Inlet'!D149","v":""},{"$f":"'Hood Inlet'!H149","v":""},{"$f":"'Hood Inlet'!I149","v":""}]
[{"$f":"'Hood Inlet'!D150","v":""},{"$f":"'Hood Inlet'!H150","v":""},{"$f":"'Hood Inlet'!I150","v":""}]
[{"$f":"'Hood Inlet'!D151","v":""},{"$f":"'Hood Inlet'!H151","v":""},{"$f":"'Hood Inlet'!I151","v":""}]
[{"$f":"'Hood Inlet'!D152","v":""},{"$f":"'Hood Inlet'!H152","v":""},{"$f":"'Hood Inlet'!I152","v":""}]
[{"$f":"'Hood Inlet'!D153","v":""},{"$f":"'Hood Inlet'!H153","v":""},{"$f":"'Hood Inlet'!I153","v":""}]
[{"$f":"'Hood Inlet'!D154","v":""},{"$f":"'Hood Inlet'!H154","v":""},{"$f":"'Hood Inlet'!I154","v":""}]
[{"$f":"'Hood Inlet'!D155","v":""},{"$f":"'Hood Inlet'!H155","v":""},{"$f":"'Hood Inlet'!I155","v":""}]
[{"$f":"'Hood Inlet'!D156","v":""},{"$f":"'Hood Inlet'!H156","v":""},{"$f":"'Hood Inlet'!I156","v":""}]
[{"$f":"'Hood Inlet'!D157","v":""},{"$f":"'Hood Inlet'!H157","v":""},{"$f":"'Hood Inlet'!I157","v":""}]
[{"$f":"'Hood Inlet'!D158","v":""},{"$f":"'Hood Inlet'!H158","v":""},{"$f":"'Hood Inlet'!I158","v":""}]
[{"$f":"'Hood Inlet'!D159","v":""},{"$f":"'Hood Inlet'!H159","v":""},{"$f":"'Hood Inlet'!I159","v":""}]
[{"$f":"'Hood Inlet'!D160","v":""},{"$f":"'Hood Inlet'!H160","v":""},{"$f":"'Hood Inlet'!I160","v":""}]
[{"$f":"'Hood Inlet'!D161","v":""},{"$f":"'Hood Inlet'!H161","v":""},{"$f":"'Hood Inlet'!I161","v":""}]
[{"$f":"'Hood Inlet'!D162","v":""},{"$f":"'Hood Inlet'!H162","v":""},{"$f":"'Hood Inlet'!I162","v":""}]
[{"$f":"'Hood Inlet'!D163","v":""},{"$f":"'Hood Inlet'!H163","v":""},{"$f":"'Hood Inlet'!I163","v":""}]
[{"$f":"'Hood Inlet'!D164","v":""},{"$f":"'Hood Inlet'!H164","v":""},{"$f":"'Hood Inlet'!I164","v":""}]
[{"$f":"'Hood Inlet'!D165","v":""},{"$f":"'Hood Inlet'!H165","v":""},{"$f":"'Hood Inlet'!I165","v":""}]
[{"$f":"'Hood Inlet'!D166","v":""},{"$f":"'Hood Inlet'!H166","v":""},{"$f":"'Hood Inlet'!I166","v":""}]
[{"$f":"'Hood Inlet'!D167","v":""},{"$f":"'Hood Inlet'!H167","v":""},{"$f":"'Hood Inlet'!I167","v":""}]
[{"$f":"'Hood Inlet'!D168","v":""},{"$f":"'Hood Inlet'!H168","v":""},{"$f":"'Hood Inlet'!I168","v":""}]
[{"$f":"'Hood Inlet'!D169","v":""},{"$f":"'Hood Inlet'!H169","v":""},{"$f":"'Hood Inlet'!I169","v":""}]
[{"$f":"'Hood Inlet'!D170","v":""},{"$f":"'Hood Inlet'!H170","v":""},{"$f":"'Hood Inlet'!I170","v":""}]
[{"$f":"'Hood Inlet'!D171","v":""},{"$f":"'Hood Inlet'!H171","v":""},{"$f":"'Hood Inlet'!I171","v":""}]
[{"$f":"'Hood Inlet'!D172","v":""},{"$f":"'Hood Inlet'!H172","v":""},{"$f":"'Hood Inlet'!I172","v":""}]
[{"$f":"'Hood Inlet'!D173","v":""},{"$f":"'Hood Inlet'!H173","v":""},{"$f":"'Hood Inlet'!I173","v":""}]
[{"$f":"'Hood Inlet'!D174","v":""},{"$f":"'Hood Inlet'!H174","v":""},{"$f":"'Hood Inlet'!I174","v":""}]
[{"$f":"'Hood Inlet'!D175","v":""},{"$f":"'Hood Inlet'!H175","v":""},{"$f":"'Hood Inlet'!I175","v":""}]
[{"$f":"'Hood Inlet'!D176","v":""},{"$f":"'Hood Inlet'!H176","v":""},{"$f":"'Hood Inlet'!I176","v":""}]
[{"$f":"'Hood Inlet'!D177","v":""},{"$f":"'Hood Inlet'!H177","v":""},{"$f":"'Hood Inlet'!I177","v":""}]
[{"$f":"'Hood Inlet'!D178","v":""},{"$f":"'Hood Inlet'!H178","v":""},{"$f":"'Hood Inlet'!I178","v":""}]
[{"$f":"'Hood Inlet'!D179","v":""},{"$f":"'Hood Inlet'!H179","v":""},{"$f":"'Hood Inlet'!I179","v":""}]
[{"$f":"'Hood Inlet'!D180","v":""},{"$f":"'Hood Inlet'!H180","v":""},{"$f":"'Hood Inlet'!I180","v":""}]
[{"$f":"'Hood Inlet'!D181","v":""},{"$f":"'Hood Inlet'!H181","v":""},{"$f":"'Hood Inlet'!I181","v":""}]
[{"$f":"'Hood Inlet'!D182","v":""},{"$f":"'Hood Inlet'!H182","v":""},{"$f":"'Hood Inlet'!I182","v":""}]
[{"$f":"'Hood Inlet'!D183","v":""},{"$f":"'Hood Inlet'!H183","v":""},{"$f":"'Hood Inlet'!I183","v":""}]
[{"$f":"'Hood Inlet'!D184","v":""},{"$f":"'Hood Inlet'!H184","v":""},{"$f":"'Hood Inlet'!I184","v":""}]
[{"$f":"'Hood Inlet'!D185","v":""},{"$f":"'Hood Inlet'!H185","v":""},{"$f":"'Hood Inlet'!I185","v":""}]
[{"$f":"'Hood Inlet'!D186","v":""},{"$f":"'Hood Inlet'!H186","v":""},{"$f":"'Hood Inlet'!I186","v":""}]
[{"$f":"'Hood Inlet'!D187","v":""},{"$f":"'Hood Inlet'!H187","v":""},{"$f":"'Hood Inlet'!I187","v":""}]
[{"$f":"'Hood Inlet'!D188","v":""},{"$f":"'Hood Inlet'!H188","v":""},{"$f":"'Hood Inlet'!I188","v":""}]
[{"$f":"'Hood Inlet'!D189","v":""},{"$f":"'Hood Inlet'!H189","v":""},{"$f":"'Hood Inlet'!I189","v":""}]
[{"$f":"'Hood Inlet'!D190","v":""},{"$f":"'Hood Inlet'!H190","v":""},{"$f":"'Hood Inlet'!I190","v":""}]
[{"$f":"'Hood Inlet'!D191","v":""},{"$f":"'Hood Inlet'!H191","v":""},{"$f":"'Hood Inlet'!I191","v":""}]
[{"$f":"'Hood Inlet'!D192","v":""},{"$f":"'Hood Inlet'!H192","v":""},{"$f":"'Hood Inlet'!I192","v":""}]
[{"$f":"'Hood Inlet'!D193","v":""},{"$f":"'Hood Inlet'!H193","v":""},{"$f":"'Hood Inlet'!I193","v":""}]
[{"$f":"'Hood Inlet'!D194","v":""},{"$f":"'Hood Inlet'!H194","v":""},{"$f":"'Hood Inlet'!I194","v":""}]
[{"$f":"'Hood Inlet'!D195","v":""},{"$f":"'Hood Inlet'!H195","v":""},{"$f":"'Hood Inlet'!I195","v":""}]
[{"$f":"'Hood Inlet'!D196","v":""},{"$f":"'Hood Inlet'!H196","v":""},{"$f":"'Hood Inlet'!I196","v":""}]
[{"$f":"'Hood Inlet'!D197","v":""},{"$f":"'Hood Inlet'!H197","v":""},{"$f":"'Hood Inlet'!I197","v":""}]
[{"$f":"'Hood Inlet'!D198","v":""},{"$f":"'Hood Inlet'!H198","v":""},{"$f":"'Hood Inlet'!I198","v":""}]
[{"$f":"'Hood Inlet'!D199","v":""},{"$f":"'Hood Inlet'!H199","v":""},{"$f":"'Hood Inlet'!I199","v":""}]
[{"$f":"'Hood Inlet'!D200","v":""},{"$f":"'Hood Inlet'!H200","v":""},{"$f":"'Hood Inlet'!I200","v":""}]
[{"$f":"'Hood Inlet'!D201","v":""},{"$f":"'Hood Inlet'!H201","v":""},{"$f":"'Hood Inlet'!I201","v":""}]
[{"$f":"'Hood Inlet'!D202","v":""},{"$f":"'Hood Inlet'!H202","v":""},{"$f":"'Hood Inlet'!I202","v":""}]
[{"$f":"'Hood Inlet'!D203","v":""},{"$f":"'Hood Inlet'!H203","v":""},{"$f":"'Hood Inlet'!I203","v":""}]
[{"$f":"'Hood Inlet'!D204","v":""},{"$f":"'Hood Inlet'!H204","v":""},{"$f":"'Hood Inlet'!I204","v":""}]
[{"$f":"'Hood Inlet'!D205","v":""},{"$f":"'Hood Inlet'!H205","v":""},{"$f":"'Hood Inlet'!I205","v":""}]

{"sheet":"Weir Slug Data","index":2,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["Elev","Weir","Slug Flow"]
[{"$f":"'Hood Inlet'!D6","v":1083.5},{"$f":"'Hood Inlet'!F6","v":0},{"$f":"'Hood Inlet'!G6","v":0}]
[{"$f":"'Hood Inlet'!D7","v":1083.5999999999999},{"$f":"'Hood Inlet'!F7","v":3.9218296572715874E-2},{"$f":"'Hood Inlet'!G7","v":0}]
[{"$f":"'Hood Inlet'!D8","v":1083.6999999999998},{"$f":"'Hood Inlet'!F8","v":0.15720982708192952},{"$f":"'Hood Inlet'!G8","v":0}]
[{"$f":"'Hood Inlet'!D9","v":1083.7999999999997},{"$f":"'Hood Inlet'!F9","v":0.35416716640216822},{"$f":"'Hood Inlet'!G9","v":0}]
[{"$f":"'Hood Inlet'!D10","v":1083.8999999999996},{"$f":"'Hood Inlet'!F10","v":0.62984210049717815},{"$f":"'Hood Inlet'!G10","v":0}]
[{"$f":"'Hood Inlet'!D11","v":1083.9999999999995},{"$f":"'Hood Inlet'!F11","v":0.98351103185676458},{"$f":"'Hood Inlet'!G11","v":0}]
[{"$f":"'Hood Inlet'!D12","v":1084.0999999999995},{"$f":"'Hood Inlet'!F12","v":1.413934153631609},{"$f":"'Hood Inlet'!G12","v":0}]
[{"$f":"'Hood Inlet'!D13","v":1084.1999999999994},{"$f":"'Hood Inlet'!F13","v":1.9193066669147465},{"$f":"'Hood Inlet'!G13","v":0}]
[{"$f":"'Hood Inlet'!D14","v":1084.2999999999993},{"$f":"'Hood Inlet'!F14","v":2.49719965562783},{"$f":"'Hood Inlet'!G14","v":0}]
[{"$f":"'Hood Inlet'!D15","v":1084.3999999999992},{"$f":"'Hood Inlet'!F15","v":3.1444872417085783},{"$f":"'Hood Inlet'!G15","v":0}]
[{"$f":"'Hood Inlet'!D16","v":1084.4999999999991},{"$f":"'Hood Inlet'!F16","v":3.8572551064028775},{"$f":"'Hood Inlet'!G16","v":0}]
[{"$f":"'Hood Inlet'!D17","v":1084.599999999999},{"$f":"'Hood Inlet'!F17","v":4.6306829951216733},{"$f":"'Hood Inlet'!G17","v":0}]
[{"$f":"'Hood Inlet'!D18","v":1084.6999999999989},{"$f":"'Hood Inlet'!F18","v":5.4588896886839242},{"$f":"'Hood Inlet'!G18","v":0}]
[{"$f":"'Hood Inlet'!D19","v":1084.7999999999988},{"$f":"'Hood Inlet'!F19","v":6.3347216407549753},{"$f":"'Hood Inlet'!G19","v":0}]
[{"$f":"'Hood Inlet'!D20","v":1084.8999999999987},{"$f":"'Hood Inlet'!F20","v":7.2494528414019985},{"$f":"'Hood Inlet'!G20","v":0}]
[{"$f":"'Hood Inlet'!D21","v":1084.9999999999986},{"$f":"'Hood Inlet'!F21","v":8.192335886865628},{"$f":"'Hood Inlet'!G21","v":0}]
[{"$f":"'Hood Inlet'!D22","v":1085.0999999999985},{"$f":"'Hood Inlet'!F22","v":9.1498826640041298},{"$f":"'Hood Inlet'!G22","v":0}]
[{"$f":"'Hood Inlet'!D23","v":1085.1999999999985},{"$f":"'Hood Inlet'!F23","v":10.104595861964423},{"$f":"'Hood Inlet'!G23","v":0}]
[{"$f":"'Hood Inlet'!D24","v":1085.2999999999984},{"$f":"'Hood Inlet'!F24","v":11.03238441543335},{"$f":"'Hood Inlet'!G24","v":0}]
[{"$f":"'Hood Inlet'!D25","v":1085.3999999999983},{"$f":"'Hood Inlet'!F25","v":11.895791363304415},{"$f":"'Hood Inlet'!G25","v":0}]
[{"$f":"'Hood Inlet'!D26","v":1085.4999999999982},{"$f":"'Hood Inlet'!F26","v":12.607021244873684},{"$f":"'Hood Inlet'!G26","v":0}]
[{"$f":"'Hood Inlet'!D27","v":1085.5999999999981},{"$f":"'Hood Inlet'!F27","v":13.092249121116769},{"$f":"'Hood Inlet'!G27","v":0}]
[{"$f":"'Hood Inlet'!D28","v":1085.699999999998},{"$f":"'Hood Inlet'!F28","v":13.578332958072703},{"$f":"'Hood Inlet'!G28","v":0}]
[{"$f":"'Hood Inlet'!D29","v":1085.7999999999979},{"$f":"'Hood Inlet'!F29","v":14.065491149668338},{"$f":"'Hood Inlet'!G29","v":0}]
[{"$f":"'Hood Inlet'!D30","v":1085.8999999999978},{"$f":"'Hood Inlet'!F30","v":14.553912639999163},{"$f":"'Hood Inlet'!G30","v":0}]
[{"$f":"'Hood Inlet'!D31","v":1085.9999999999977},{"$f":"'Hood Inlet'!F31","v":15.043761546710007},{"$f":"'Hood Inlet'!G31","v":0}]
[{"$f":"'Hood Inlet'!D32","v":1086.0999999999976},{"$f":"'Hood Inlet'!F32","v":15.535180922861123},{"$f":"'Hood Inlet'!G32","v":0}]
[{"$f":"'Hood Inlet'!D33","v":1086.1999999999975},{"$f":"'Hood Inlet'!F33","v":16.028295842914797},{"$f":"'Hood Inlet'!G33","v":0}]
[{"$f":"'Hood Inlet'!D34","v":1086.2999999999975},{"$f":"'Hood Inlet'!F34","v":16.523215953324144},{"$f":"'Hood Inlet'!G34","v":0}]
[{"$f":"'Hood Inlet'!D35","v":1086.3999999999974},{"$f":"'Hood Inlet'!F35","v":17.020037595216568},{"$f":"'Hood Inlet'!G35","v":0}]
[{"$f":"'Hood Inlet'!D36","v":1086.4999999999973},{"$f":"'Hood Inlet'!F36","v":17.518845582263666},{"$f":"'Hood Inlet'!G36","v":0}]
[{"$f":"'Hood Inlet'!D37","v":1086.5999999999972},{"$f":"'Hood Inlet'!F37","v":18.019714698574649},{"$f":"'Hood Inlet'!G37","v":0}]
[{"$f":"'Hood Inlet'!D38","v":1086.6999999999971},{"$f":"'Hood Inlet'!F38","v":18.522710967649122},{"$f":"'Hood Inlet'!G38","v":9.0509667988585232}]
[{"$f":"'Hood Inlet'!D39","v":1086.799999999997},{"$f":"'Hood Inlet'!F39","v":19.027892732888869},{"$f":"'Hood Inlet'!G39","v":20.364675297832992}]
[{"$f":"'Hood Inlet'!D40","v":1086.8999999999969},{"$f":"'Hood Inlet'!F40","v":19.535311582050465},{"$f":"'Hood Inlet'!G40","v":31.678383796807463}]
[{"$f":"'Hood Inlet'!D41","v":1086.9999999999968},{"$f":"'Hood Inlet'!F41","v":20.045013141713799},{"$f":"'Hood Inlet'!G41","v":42.992092295781937}]
[{"$f":"'Hood Inlet'!D42","v":1087},{"$f":"'Hood Inlet'!F42","v":20.045013141730063},{"$f":"'Hood Inlet'!G42","v":42.992092296142076}]
[{"$f":"'Hood Inlet'!D43","v":1087.2},{"$f":"'Hood Inlet'!F43","v":""},{"$f":"'Hood Inlet'!G43","v":""}]
[{"$f":"'Hood Inlet'!D44","v":1087.4000000000001},{"$f":"'Hood Inlet'!F44","v":""},{"$f":"'Hood Inlet'!G44","v":""}]
[{"$f":"'Hood Inlet'!D45","v":1087.6000000000001},{"$f":"'Hood Inlet'!F45","v":""},{"$f":"'Hood Inlet'!G45","v":""}]
[{"$f":"'Hood Inlet'!D46","v":1087.8},{"$f":"'Hood Inlet'!F46","v":""},{"$f":"'Hood Inlet'!G46","v":""}]
[{"$f":"'Hood Inlet'!D47","v":1088},{"$f":"'Hood Inlet'!F47","v":""},{"$f":"'Hood Inlet'!G47","v":""}]
[{"$f":"'Hood Inlet'!D48","v":1088.2},{"$f":"'Hood Inlet'!F48","v":""},{"$f":"'Hood Inlet'!G48","v":""}]
[{"$f":"'Hood Inlet'!D49","v":1088.4000000000001},{"$f":"'Hood Inlet'!F49","v":""},{"$f":"'Hood Inlet'!G49","v":""}]
[{"$f":"'Hood Inlet'!D50","v":1088.6000000000001},{"$f":"'Hood Inlet'!F50","v":""},{"$f":"'Hood Inlet'!G50","v":""}]
[{"$f":"'Hood Inlet'!D51","v":1088.8},{"$f":"'Hood Inlet'!F51","v":""},{"$f":"'Hood Inlet'!G51","v":""}]
[{"$f":"'Hood Inlet'!D52","v":1089},{"$f":"'Hood Inlet'!F52","v":""},{"$f":"'Hood Inlet'!G52","v":""}]
[{"$f":"'Hood Inlet'!D53","v":1089.2},{"$f":"'Hood Inlet'!F53","v":""},{"$f":"'Hood Inlet'!G53","v":""}]
[{"$f":"'Hood Inlet'!D54","v":1089.4000000000001},{"$f":"'Hood Inlet'!F54","v":""},{"$f":"'Hood Inlet'!G54","v":""}]
[{"$f":"'Hood Inlet'!D55","v":1089.6000000000001},{"$f":"'Hood Inlet'!F55","v":""},{"$f":"'Hood Inlet'!G55","v":""}]
[{"$f":"'Hood Inlet'!D56","v":1089.8},{"$f":"'Hood Inlet'!F56","v":""},{"$f":"'Hood Inlet'!G56","v":""}]
[{"$f":"'Hood Inlet'!D57","v":1090},{"$f":"'Hood Inlet'!F57","v":""},{"$f":"'Hood Inlet'!G57","v":""}]
[{"$f":"'Hood Inlet'!D58","v":1090.2},{"$f":"'Hood Inlet'!F58","v":""},{"$f":"'Hood Inlet'!G58","v":""}]
[{"$f":"'Hood Inlet'!D59","v":1090.4000000000001},{"$f":"'Hood Inlet'!F59","v":""},{"$f":"'Hood Inlet'!G59","v":""}]
[{"$f":"'Hood Inlet'!D60","v":1090.6000000000001},{"$f":"'Hood Inlet'!F60","v":""},{"$f":"'Hood Inlet'!G60","v":""}]
[{"$f":"'Hood Inlet'!D61","v":1090.8},{"$f":"'Hood Inlet'!F61","v":""},{"$f":"'Hood Inlet'!G61","v":""}]
[{"$f":"'Hood Inlet'!D62","v":1091},{"$f":"'Hood Inlet'!F62","v":""},{"$f":"'Hood Inlet'!G62","v":""}]
[{"$f":"'Hood Inlet'!D63","v":""},{"$f":"'Hood Inlet'!F63","v":""},{"$f":"'Hood Inlet'!G63","v":""}]
[{"$f":"'Hood Inlet'!D64","v":""},{"$f":"'Hood Inlet'!F64","v":""},{"$f":"'Hood Inlet'!G64","v":""}]
[{"$f":"'Hood Inlet'!D65","v":""},{"$f":"'Hood Inlet'!F65","v":""},{"$f":"'Hood Inlet'!G65","v":""}]
[{"$f":"'Hood Inlet'!D66","v":""},{"$f":"'Hood Inlet'!F66","v":""},{"$f":"'Hood Inlet'!G66","v":""}]
[{"$f":"'Hood Inlet'!D67","v":""},{"$f":"'Hood Inlet'!F67","v":""},{"$f":"'Hood Inlet'!G67","v":""}]
[{"$f":"'Hood Inlet'!D68","v":""},{"$f":"'Hood Inlet'!F68","v":""},{"$f":"'Hood Inlet'!G68","v":""}]
[{"$f":"'Hood Inlet'!D69","v":""},{"$f":"'Hood Inlet'!F69","v":""},{"$f":"'Hood Inlet'!G69","v":""}]
[{"$f":"'Hood Inlet'!D70","v":""},{"$f":"'Hood Inlet'!F70","v":""},{"$f":"'Hood Inlet'!G70","v":""}]
[{"$f":"'Hood Inlet'!D71","v":""},{"$f":"'Hood Inlet'!F71","v":""},{"$f":"'Hood Inlet'!G71","v":""}]
[{"$f":"'Hood Inlet'!D72","v":""},{"$f":"'Hood Inlet'!F72","v":""},{"$f":"'Hood Inlet'!G72","v":""}]
[{"$f":"'Hood Inlet'!D73","v":""},{"$f":"'Hood Inlet'!F73","v":""},{"$f":"'Hood Inlet'!G73","v":""}]
[{"$f":"'Hood Inlet'!D74","v":""},{"$f":"'Hood Inlet'!F74","v":""},{"$f":"'Hood Inlet'!G74","v":""}]
[{"$f":"'Hood Inlet'!D75","v":""},{"$f":"'Hood Inlet'!F75","v":""},{"$f":"'Hood Inlet'!G75","v":""}]
[{"$f":"'Hood Inlet'!D76","v":""},{"$f":"'Hood Inlet'!F76","v":""},{"$f":"'Hood Inlet'!G76","v":""}]
[{"$f":"'Hood Inlet'!D77","v":""},{"$f":"'Hood Inlet'!F77","v":""},{"$f":"'Hood Inlet'!G77","v":""}]
[{"$f":"'Hood Inlet'!D78","v":""},{"$f":"'Hood Inlet'!F78","v":""},{"$f":"'Hood Inlet'!G78","v":""}]
[{"$f":"'Hood Inlet'!D79","v":""},{"$f":"'Hood Inlet'!F79","v":""},{"$f":"'Hood Inlet'!G79","v":""}]
[{"$f":"'Hood Inlet'!D80","v":""},{"$f":"'Hood Inlet'!F80","v":""},{"$f":"'Hood Inlet'!G80","v":""}]
[{"$f":"'Hood Inlet'!D81","v":""},{"$f":"'Hood Inlet'!F81","v":""},{"$f":"'Hood Inlet'!G81","v":""}]
[{"$f":"'Hood Inlet'!D82","v":""},{"$f":"'Hood Inlet'!F82","v":""},{"$f":"'Hood Inlet'!G82","v":""}]
[{"$f":"'Hood Inlet'!D83","v":""},{"$f":"'Hood Inlet'!F83","v":""},{"$f":"'Hood Inlet'!G83","v":""}]
[{"$f":"'Hood Inlet'!D84","v":""},{"$f":"'Hood Inlet'!F84","v":""},{"$f":"'Hood Inlet'!G84","v":""}]
[{"$f":"'Hood Inlet'!D85","v":""},{"$f":"'Hood Inlet'!F85","v":""},{"$f":"'Hood Inlet'!G85","v":""}]
[{"$f":"'Hood Inlet'!D86","v":""},{"$f":"'Hood Inlet'!F86","v":""},{"$f":"'Hood Inlet'!G86","v":""}]
[{"$f":"'Hood Inlet'!D87","v":""},{"$f":"'Hood Inlet'!F87","v":""},{"$f":"'Hood Inlet'!G87","v":""}]
[{"$f":"'Hood Inlet'!D88","v":""},{"$f":"'Hood Inlet'!F88","v":""},{"$f":"'Hood Inlet'!G88","v":""}]
[{"$f":"'Hood Inlet'!D89","v":""},{"$f":"'Hood Inlet'!F89","v":""},{"$f":"'Hood Inlet'!G89","v":""}]
[{"$f":"'Hood Inlet'!D90","v":""},{"$f":"'Hood Inlet'!F90","v":""},{"$f":"'Hood Inlet'!G90","v":""}]
[{"$f":"'Hood Inlet'!D91","v":""},{"$f":"'Hood Inlet'!F91","v":""},{"$f":"'Hood Inlet'!G91","v":""}]
[{"$f":"'Hood Inlet'!D92","v":""},{"$f":"'Hood Inlet'!F92","v":""},{"$f":"'Hood Inlet'!G92","v":""}]
[{"$f":"'Hood Inlet'!D93","v":""},{"$f":"'Hood Inlet'!F93","v":""},{"$f":"'Hood Inlet'!G93","v":""}]
[{"$f":"'Hood Inlet'!D94","v":""},{"$f":"'Hood Inlet'!F94","v":""},{"$f":"'Hood Inlet'!G94","v":""}]
[{"$f":"'Hood Inlet'!D95","v":""},{"$f":"'Hood Inlet'!F95","v":""},{"$f":"'Hood Inlet'!G95","v":""}]
[{"$f":"'Hood Inlet'!D96","v":""},{"$f":"'Hood Inlet'!F96","v":""},{"$f":"'Hood Inlet'!G96","v":""}]
[{"$f":"'Hood Inlet'!D97","v":""},{"$f":"'Hood Inlet'!F97","v":""},{"$f":"'Hood Inlet'!G97","v":""}]
[{"$f":"'Hood Inlet'!D98","v":""},{"$f":"'Hood Inlet'!F98","v":""},{"$f":"'Hood Inlet'!G98","v":""}]
[{"$f":"'Hood Inlet'!D99","v":""},{"$f":"'Hood Inlet'!F99","v":""},{"$f":"'Hood Inlet'!G99","v":""}]
[{"$f":"'Hood Inlet'!D100","v":""},{"$f":"'Hood Inlet'!F100","v":""},{"$f":"'Hood Inlet'!G100","v":""}]
[{"$f":"'Hood Inlet'!D101","v":""},{"$f":"'Hood Inlet'!F101","v":""},{"$f":"'Hood Inlet'!G101","v":""}]
[{"$f":"'Hood Inlet'!D102","v":""},{"$f":"'Hood Inlet'!F102","v":""},{"$f":"'Hood Inlet'!G102","v":""}]
[{"$f":"'Hood Inlet'!D103","v":""},{"$f":"'Hood Inlet'!F103","v":""},{"$f":"'Hood Inlet'!G103","v":""}]
[{"$f":"'Hood Inlet'!D104","v":""},{"$f":"'Hood Inlet'!F104","v":""},{"$f":"'Hood Inlet'!G104","v":""}]
[{"$f":"'Hood Inlet'!D105","v":""},{"$f":"'Hood Inlet'!F105","v":""},{"$f":"'Hood Inlet'!G105","v":""}]
[{"$f":"'Hood Inlet'!D106","v":""},{"$f":"'Hood Inlet'!F106","v":""},{"$f":"'Hood Inlet'!G106","v":""}]
[{"$f":"'Hood Inlet'!D107","v":""},{"$f":"'Hood Inlet'!F107","v":""},{"$f":"'Hood Inlet'!G107","v":""}]
[{"$f":"'Hood Inlet'!D108","v":""},{"$f":"'Hood Inlet'!F108","v":""},{"$f":"'Hood Inlet'!G108","v":""}]
[{"$f":"'Hood Inlet'!D109","v":""},{"$f":"'Hood Inlet'!F109","v":""},{"$f":"'Hood Inlet'!G109","v":""}]
[{"$f":"'Hood Inlet'!D110","v":""},{"$f":"'Hood Inlet'!F110","v":""},{"$f":"'Hood Inlet'!G110","v":""}]
[{"$f":"'Hood Inlet'!D111","v":""},{"$f":"'Hood Inlet'!F111","v":""},{"$f":"'Hood Inlet'!G111","v":""}]
[{"$f":"'Hood Inlet'!D112","v":""},{"$f":"'Hood Inlet'!F112","v":""},{"$f":"'Hood Inlet'!G112","v":""}]
[{"$f":"'Hood Inlet'!D113","v":""},{"$f":"'Hood Inlet'!F113","v":""},{"$f":"'Hood Inlet'!G113","v":""}]
[{"$f":"'Hood Inlet'!D114","v":""},{"$f":"'Hood Inlet'!F114","v":""},{"$f":"'Hood Inlet'!G114","v":""}]
[{"$f":"'Hood Inlet'!D115","v":""},{"$f":"'Hood Inlet'!F115","v":""},{"$f":"'Hood Inlet'!G115","v":""}]
[{"$f":"'Hood Inlet'!D116","v":""},{"$f":"'Hood Inlet'!F116","v":""},{"$f":"'Hood Inlet'!G116","v":""}]
[{"$f":"'Hood Inlet'!D117","v":""},{"$f":"'Hood Inlet'!F117","v":""},{"$f":"'Hood Inlet'!G117","v":""}]
[{"$f":"'Hood Inlet'!D118","v":""},{"$f":"'Hood Inlet'!F118","v":""},{"$f":"'Hood Inlet'!G118","v":""}]
[{"$f":"'Hood Inlet'!D119","v":""},{"$f":"'Hood Inlet'!F119","v":""},{"$f":"'Hood Inlet'!G119","v":""}]
[{"$f":"'Hood Inlet'!D120","v":""},{"$f":"'Hood Inlet'!F120","v":""},{"$f":"'Hood Inlet'!G120","v":""}]
[{"$f":"'Hood Inlet'!D121","v":""},{"$f":"'Hood Inlet'!F121","v":""},{"$f":"'Hood Inlet'!G121","v":""}]
[{"$f":"'Hood Inlet'!D122","v":""},{"$f":"'Hood Inlet'!F122","v":""},{"$f":"'Hood Inlet'!G122","v":""}]
[{"$f":"'Hood Inlet'!D123","v":""},{"$f":"'Hood Inlet'!F123","v":""},{"$f":"'Hood Inlet'!G123","v":""}]
[{"$f":"'Hood Inlet'!D124","v":""},{"$f":"'Hood Inlet'!F124","v":""},{"$f":"'Hood Inlet'!G124","v":""}]
[{"$f":"'Hood Inlet'!D125","v":""},{"$f":"'Hood Inlet'!F125","v":""},{"$f":"'Hood Inlet'!G125","v":""}]
[{"$f":"'Hood Inlet'!D126","v":""},{"$f":"'Hood Inlet'!F126","v":""},{"$f":"'Hood Inlet'!G126","v":""}]
[{"$f":"'Hood Inlet'!D127","v":""},{"$f":"'Hood Inlet'!F127","v":""},{"$f":"'Hood Inlet'!G127","v":""}]
[{"$f":"'Hood Inlet'!D128","v":""},{"$f":"'Hood Inlet'!F128","v":""},{"$f":"'Hood Inlet'!G128","v":""}]
[{"$f":"'Hood Inlet'!D129","v":""},{"$f":"'Hood Inlet'!F129","v":""},{"$f":"'Hood Inlet'!G129","v":""}]
[{"$f":"'Hood Inlet'!D130","v":""},{"$f":"'Hood Inlet'!F130","v":""},{"$f":"'Hood Inlet'!G130","v":""}]
[{"$f":"'Hood Inlet'!D131","v":""},{"$f":"'Hood Inlet'!F131","v":""},{"$f":"'Hood Inlet'!G131","v":""}]
[{"$f":"'Hood Inlet'!D132","v":""},{"$f":"'Hood Inlet'!F132","v":""},{"$f":"'Hood Inlet'!G132","v":""}]
[{"$f":"'Hood Inlet'!D133","v":""},{"$f":"'Hood Inlet'!F133","v":""},{"$f":"'Hood Inlet'!G133","v":""}]
[{"$f":"'Hood Inlet'!D134","v":""},{"$f":"'Hood Inlet'!F134","v":""},{"$f":"'Hood Inlet'!G134","v":""}]
[{"$f":"'Hood Inlet'!D135","v":""},{"$f":"'Hood Inlet'!F135","v":""},{"$f":"'Hood Inlet'!G135","v":""}]
[{"$f":"'Hood Inlet'!D136","v":""},{"$f":"'Hood Inlet'!F136","v":""},{"$f":"'Hood Inlet'!G136","v":""}]
[{"$f":"'Hood Inlet'!D137","v":""},{"$f":"'Hood Inlet'!F137","v":""},{"$f":"'Hood Inlet'!G137","v":""}]
[{"$f":"'Hood Inlet'!D138","v":""},{"$f":"'Hood Inlet'!F138","v":""},{"$f":"'Hood Inlet'!G138","v":""}]
[{"$f":"'Hood Inlet'!D139","v":""},{"$f":"'Hood Inlet'!F139","v":""},{"$f":"'Hood Inlet'!G139","v":""}]
[{"$f":"'Hood Inlet'!D140","v":""},{"$f":"'Hood Inlet'!F140","v":""},{"$f":"'Hood Inlet'!G140","v":""}]
[{"$f":"'Hood Inlet'!D141","v":""},{"$f":"'Hood Inlet'!F141","v":""},{"$f":"'Hood Inlet'!G141","v":""}]
[{"$f":"'Hood Inlet'!D142","v":""},{"$f":"'Hood Inlet'!F142","v":""},{"$f":"'Hood Inlet'!G142","v":""}]
[{"$f":"'Hood Inlet'!D143","v":""},{"$f":"'Hood Inlet'!F143","v":""},{"$f":"'Hood Inlet'!G143","v":""}]
[{"$f":"'Hood Inlet'!D144","v":""},{"$f":"'Hood Inlet'!F144","v":""},{"$f":"'Hood Inlet'!G144","v":""}]
[{"$f":"'Hood Inlet'!D145","v":""},{"$f":"'Hood Inlet'!F145","v":""},{"$f":"'Hood Inlet'!G145","v":""}]
[{"$f":"'Hood Inlet'!D146","v":""},{"$f":"'Hood Inlet'!F146","v":""},{"$f":"'Hood Inlet'!G146","v":""}]
[{"$f":"'Hood Inlet'!D147","v":""},{"$f":"'Hood Inlet'!F147","v":""},{"$f":"'Hood Inlet'!G147","v":""}]
[{"$f":"'Hood Inlet'!D148","v":""},{"$f":"'Hood Inlet'!F148","v":""},{"$f":"'Hood Inlet'!G148","v":""}]
[{"$f":"'Hood Inlet'!D149","v":""},{"$f":"'Hood Inlet'!F149","v":""},{"$f":"'Hood Inlet'!G149","v":""}]
[{"$f":"'Hood Inlet'!D150","v":""},{"$f":"'Hood Inlet'!F150","v":""},{"$f":"'Hood Inlet'!G150","v":""}]
[{"$f":"'Hood Inlet'!D151","v":""},{"$f":"'Hood Inlet'!F151","v":""},{"$f":"'Hood Inlet'!G151","v":""}]
[{"$f":"'Hood Inlet'!D152","v":""},{"$f":"'Hood Inlet'!F152","v":""},{"$f":"'Hood Inlet'!G152","v":""}]
[{"$f":"'Hood Inlet'!D153","v":""},{"$f":"'Hood Inlet'!F153","v":""},{"$f":"'Hood Inlet'!G153","v":""}]
[{"$f":"'Hood Inlet'!D154","v":""},{"$f":"'Hood Inlet'!F154","v":""},{"$f":"'Hood Inlet'!G154","v":""}]
[{"$f":"'Hood Inlet'!D155","v":""},{"$f":"'Hood Inlet'!F155","v":""},{"$f":"'Hood Inlet'!G155","v":""}]
[{"$f":"'Hood Inlet'!D156","v":""},{"$f":"'Hood Inlet'!F156","v":""},{"$f":"'Hood Inlet'!G156","v":""}]
[{"$f":"'Hood Inlet'!D157","v":""},{"$f":"'Hood Inlet'!F157","v":""},{"$f":"'Hood Inlet'!G157","v":""}]
[{"$f":"'Hood Inlet'!D158","v":""},{"$f":"'Hood Inlet'!F158","v":""},{"$f":"'Hood Inlet'!G158","v":""}]
[{"$f":"'Hood Inlet'!D159","v":""},{"$f":"'Hood Inlet'!F159","v":""},{"$f":"'Hood Inlet'!G159","v":""}]
[{"$f":"'Hood Inlet'!D160","v":""},{"$f":"'Hood Inlet'!F160","v":""},{"$f":"'Hood Inlet'!G160","v":""}]
[{"$f":"'Hood Inlet'!D161","v":""},{"$f":"'Hood Inlet'!F161","v":""},{"$f":"'Hood Inlet'!G161","v":""}]
[{"$f":"'Hood Inlet'!D162","v":""},{"$f":"'Hood Inlet'!F162","v":""},{"$f":"'Hood Inlet'!G162","v":""}]
[{"$f":"'Hood Inlet'!D163","v":""},{"$f":"'Hood Inlet'!F163","v":""},{"$f":"'Hood Inlet'!G163","v":""}]
[{"$f":"'Hood Inlet'!D164","v":""},{"$f":"'Hood Inlet'!F164","v":""},{"$f":"'Hood Inlet'!G164","v":""}]
[{"$f":"'Hood Inlet'!D165","v":""},{"$f":"'Hood Inlet'!F165","v":""},{"$f":"'Hood Inlet'!G165","v":""}]
[{"$f":"'Hood Inlet'!D166","v":""},{"$f":"'Hood Inlet'!F166","v":""},{"$f":"'Hood Inlet'!G166","v":""}]
[{"$f":"'Hood Inlet'!D167","v":""},{"$f":"'Hood Inlet'!F167","v":""},{"$f":"'Hood Inlet'!G167","v":""}]
[{"$f":"'Hood Inlet'!D168","v":""},{"$f":"'Hood Inlet'!F168","v":""},{"$f":"'Hood Inlet'!G168","v":""}]
[{"$f":"'Hood Inlet'!D169","v":""},{"$f":"'Hood Inlet'!F169","v":""},{"$f":"'Hood Inlet'!G169","v":""}]
[{"$f":"'Hood Inlet'!D170","v":""},{"$f":"'Hood Inlet'!F170","v":""},{"$f":"'Hood Inlet'!G170","v":""}]
[{"$f":"'Hood Inlet'!D171","v":""},{"$f":"'Hood Inlet'!F171","v":""},{"$f":"'Hood Inlet'!G171","v":""}]
[{"$f":"'Hood Inlet'!D172","v":""},{"$f":"'Hood Inlet'!F172","v":""},{"$f":"'Hood Inlet'!G172","v":""}]
[{"$f":"'Hood Inlet'!D173","v":""},{"$f":"'Hood Inlet'!F173","v":""},{"$f":"'Hood Inlet'!G173","v":""}]
[{"$f":"'Hood Inlet'!D174","v":""},{"$f":"'Hood Inlet'!F174","v":""},{"$f":"'Hood Inlet'!G174","v":""}]
[{"$f":"'Hood Inlet'!D175","v":""},{"$f":"'Hood Inlet'!F175","v":""},{"$f":"'Hood Inlet'!G175","v":""}]
[{"$f":"'Hood Inlet'!D176","v":""},{"$f":"'Hood Inlet'!F176","v":""},{"$f":"'Hood Inlet'!G176","v":""}]
[{"$f":"'Hood Inlet'!D177","v":""},{"$f":"'Hood Inlet'!F177","v":""},{"$f":"'Hood Inlet'!G177","v":""}]
[{"$f":"'Hood Inlet'!D178","v":""},{"$f":"'Hood Inlet'!F178","v":""},{"$f":"'Hood Inlet'!G178","v":""}]
[{"$f":"'Hood Inlet'!D179","v":""},{"$f":"'Hood Inlet'!F179","v":""},{"$f":"'Hood Inlet'!G179","v":""}]
[{"$f":"'Hood Inlet'!D180","v":""},{"$f":"'Hood Inlet'!F180","v":""},{"$f":"'Hood Inlet'!G180","v":""}]
[{"$f":"'Hood Inlet'!D181","v":""},{"$f":"'Hood Inlet'!F181","v":""},{"$f":"'Hood Inlet'!G181","v":""}]
[{"$f":"'Hood Inlet'!D182","v":""},{"$f":"'Hood Inlet'!F182","v":""},{"$f":"'Hood Inlet'!G182","v":""}]
[{"$f":"'Hood Inlet'!D183","v":""},{"$f":"'Hood Inlet'!F183","v":""},{"$f":"'Hood Inlet'!G183","v":""}]
[{"$f":"'Hood Inlet'!D184","v":""},{"$f":"'Hood Inlet'!F184","v":""},{"$f":"'Hood Inlet'!G184","v":""}]
[{"$f":"'Hood Inlet'!D185","v":""},{"$f":"'Hood Inlet'!F185","v":""},{"$f":"'Hood Inlet'!G185","v":""}]
[{"$f":"'Hood Inlet'!D186","v":""},{"$f":"'Hood Inlet'!F186","v":""},{"$f":"'Hood Inlet'!G186","v":""}]
[{"$f":"'Hood Inlet'!D187","v":""},{"$f":"'Hood Inlet'!F187","v":""},{"$f":"'Hood Inlet'!G187","v":""}]
[{"$f":"'Hood Inlet'!D188","v":""},{"$f":"'Hood Inlet'!F188","v":""},{"$f":"'Hood Inlet'!G188","v":""}]
[{"$f":"'Hood Inlet'!D189","v":""},{"$f":"'Hood Inlet'!F189","v":""},{"$f":"'Hood Inlet'!G189","v":""}]
[{"$f":"'Hood Inlet'!D190","v":""},{"$f":"'Hood Inlet'!F190","v":""},{"$f":"'Hood Inlet'!G190","v":""}]
[{"$f":"'Hood Inlet'!D191","v":""},{"$f":"'Hood Inlet'!F191","v":""},{"$f":"'Hood Inlet'!G191","v":""}]
[{"$f":"'Hood Inlet'!D192","v":""},{"$f":"'Hood Inlet'!F192","v":""},{"$f":"'Hood Inlet'!G192","v":""}]
[{"$f":"'Hood Inlet'!D193","v":""},{"$f":"'Hood Inlet'!F193","v":""},{"$f":"'Hood Inlet'!G193","v":""}]
[{"$f":"'Hood Inlet'!D194","v":""},{"$f":"'Hood Inlet'!F194","v":""},{"$f":"'Hood Inlet'!G194","v":""}]
[{"$f":"'Hood Inlet'!D195","v":""},{"$f":"'Hood Inlet'!F195","v":""},{"$f":"'Hood Inlet'!G195","v":""}]
[{"$f":"'Hood Inlet'!D196","v":""},{"$f":"'Hood Inlet'!F196","v":""},{"$f":"'Hood Inlet'!G196","v":""}]
[{"$f":"'Hood Inlet'!D197","v":""},{"$f":"'Hood Inlet'!F197","v":""},{"$f":"'Hood Inlet'!G197","v":""}]
[{"$f":"'Hood Inlet'!D198","v":""},{"$f":"'Hood Inlet'!F198","v":""},{"$f":"'Hood Inlet'!G198","v":""}]
[{"$f":"'Hood Inlet'!D199","v":""},{"$f":"'Hood Inlet'!F199","v":""},{"$f":"'Hood Inlet'!G199","v":""}]
[{"$f":"'Hood Inlet'!D200","v":""},{"$f":"'Hood Inlet'!F200","v":""},{"$f":"'Hood Inlet'!G200","v":""}]
[{"$f":"'Hood Inlet'!D201","v":""},{"$f":"'Hood Inlet'!F201","v":""},{"$f":"'Hood Inlet'!G201","v":""}]
[{"$f":"'Hood Inlet'!D202","v":""},{"$f":"'Hood Inlet'!F202","v":""},{"$f":"'Hood Inlet'!G202","v":""}]
[{"$f":"'Hood Inlet'!D203","v":""},{"$f":"'Hood Inlet'!F203","v":""},{"$f":"'Hood Inlet'!G203","v":""}]
[{"$f":"'Hood Inlet'!D204","v":""},{"$f":"'Hood Inlet'!F204","v":""},{"$f":"'Hood Inlet'!G204","v":""}]
[{"$f":"'Hood Inlet'!D205","v":""},{"$f":"'Hood Inlet'!F205","v":""},{"$f":"'Hood Inlet'!G205","v":""}]

{"sheet":"Pipe Length","index":3,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"'Hood Inlet'!K1","v":"IaHoodInlet.xls Ver 1.30"}]
[null,"Calculate the Pipe Length"]
[]
["Project Name: ",{"$f":"IF('Hood Inlet'!B1=\"\",\"\",'Hood Inlet'!B1)","v":""}]
["Computed by: ",{"$f":"IF('Hood Inlet'!B2:C2=\"\",\"\",'Hood Inlet'!B2:C2)","v":""}]
["Date: ",{"$f":"IF('Hood Inlet'!B3=\"\",\"\",'Hood Inlet'!B3)","v":""}]
["Checked by: "]
["Date: "]
["Basic Pipe Elevations"]
["Principal Spillway Crest Elev (ft)",null,1083.5]
[]
["Elbow Elev (if None, Leave 'BLANK')",null,1065.5]
["Length of Outlet ('BLANK' if none)",null,20]
["Outlet Elevation (ft)",null,1064.5]
[]
["Basic Embankment Elevations"]
["Constructed Top of Fill Elev (ft)",null,1091]
["Embankment Top Width",null,12]
["Frontslope (H/V)",null,3]
["Backslope (H/V)",null,3]
["Downstream Toe Elev (ft)",null,1063.5]
["Length of Pipe Past Downstream Toe (ft)",null,6]
[null,null,null,null,null,{"$f":"IF(OR(IF(OR(elb=\"\",lenout=\"\"),FALSE,elb<outelev),tof<pscrest,outelev<toe),\"Check your inputs\",\"OK\")","v":"OK"}]
["Calculated Pipe Flow Length"]
["Pipe Length (ft)",null,{"$f":"IF(F23=\"OK\",IF(OR(elb=\"\",lenout=\"\"),ROUND(((pscrest-outelev)^2+(overh+tw+(tof-pscrest)*fs+(tof-toe)*bs)^2)^0.5,0),ROUND(((pscrest-elb)^2+(overh+tw+(tof-pscrest)*fs+(tof-toe)*bs-lenout)^2)^0.5+lenout,0)),\"\")","v":125}]
[]
[]
[]
["Pipe Profile "]
["Station of CL of Dam",null,1000]
[]
["Pipe Profile for CADD",null,"Sta","Elev"]
["Inlet",null,{"$f":"CL_dam-tw/2-(tof-pscrest)*fs","v":971.5},{"$f":"pscrest","v":1083.5}]
["Elbow",null,{"$f":"IF(elb=\"\",\"\",C35-lenout)","v":1074.5},{"$f":"IF(elb=\"\",\"\",elb)","v":1065.5}]
["Outlet",null,{"$f":"CL_dam+tw/2+(tof-toe)*bs+overh","v":1094.5},{"$f":"outelev","v":1064.5}]

{"sheet":"Weir & Slug","index":4,"n_rows":207,"n_cols":13,"rows_kept":207,"cut":false,"hidden":false,"merged":[[5,7,5,8],[5,10,5,12]]}
[null,"Project Name:",{"$f":"IF('Hood Inlet'!B1=\"\",\"\",'Hood Inlet'!B1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"'Hood Inlet'!K1","v":"IaHoodInlet.xls Ver 1.30"}]
[null,"Computed by:",{"$f":"IF('Hood Inlet'!B2=\"\",\"\",'Hood Inlet'!B2)","v":""}]
[null,"Date:",{"$f":"IF('Hood Inlet'!B3=\"\",\"\",'Hood Inlet'!B3)","v":""}]
[]
[null,"Computations for Weir Flow",null,null,"Weir Flow","Slug Flow"]
["H","a, wetted area, sq ft",null,null,"Q, cfs","Q, cfs"]
[{"$f":"IF('Hood Inlet'!E6>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E6))","v":0},{"$f":"IF(A7=\"\",\"\",IF(A7<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A7)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A7)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A7)^2),IF(A7<=Pipe_Diam_Ft,0,Barea)))","v":0},null,null,{"$f":"IF(A7=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A7/Pipe_Diam_Ft)*(B7/Barea)*(A7/Pipe_Diam_Ft)^0.5)","v":0},{"$f":"IF(A7=\"\",\"\",IF(A7<slugstart,0,IF(A7/(Pipe_Diam/12)-Cs<0,0,((A7/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":0}]
[{"$f":"IF('Hood Inlet'!E7>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E7))","v":9.9999999999909051E-2},5.8725906877522605E-2,null,null,3.9218296572715874E-2,0]
[{"$f":"IF('Hood Inlet'!E8>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E8))","v":0.1999999999998181},0.16350110879306601,null,null,0.15720982708192952,0,null,null,null,null,null,"Pipe Diameter, Ft =",{"$f":"Pipe_Diam/12","v":2}]
[{"$f":"IF('Hood Inlet'!E9>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E9))","v":0.29999999999972715},0.29549884018575412,null,null,0.35416716640216822,0,null,null,null,null,null,"Cs =",{"$f":"IF(Mannings>0.02,1.56,IF(Mannings<=0.01,1.05,1.05+51*(Mannings-0.01)))","v":1.56}]
[{"$f":"IF('Hood Inlet'!E10>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E10))","v":0.3999999999996362},0.44729521800103011,null,null,0.62984210049717815,0]
[{"$f":"IF('Hood Inlet'!E11>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E11))","v":0.49999999999954525},0.61418484930359063,null,null,0.98351103185676458,0]
[{"$f":"IF('Hood Inlet'!E12>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E12))","v":0.5999999999994543},0.7926734251299411,null,null,1.413934153631609,0]
[{"$f":"IF('Hood Inlet'!E13>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E13))","v":0.69999999999936335},0.97992191235320059,null,null,1.9193066669147465,0]
[{"$f":"IF('Hood Inlet'!E14>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E14))","v":0.7999999999992724},1.1734792265804856,null,null,2.49719965562783,0]
[{"$f":"IF('Hood Inlet'!E15>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E15))","v":0.89999999999918145},1.3711301619210459,null,null,3.1444872417085783,0]
[{"$f":"IF('Hood Inlet'!E16>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E16))","v":0.99999999999909051},1.5707963267930776,null,null,3.8572551064028775,0]
[{"$f":"IF('Hood Inlet'!E17>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E17))","v":1.0999999999989996},1.7704624916651275,null,null,4.6306829951216733,0]
[{"$f":"IF('Hood Inlet'!E18>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E18))","v":1.1999999999989086},1.968113427005743,null,null,5.4588896886839242,0]
[{"$f":"IF('Hood Inlet'!E19>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E19))","v":1.2999999999988177},2.161670741233122,null,null,6.3347216407549753,0]
[{"$f":"IF('Hood Inlet'!E20>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E20))","v":1.3999999999987267},2.3489192284565177,null,null,7.2494528414019985,0]
[{"$f":"IF('Hood Inlet'!E21>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E21))","v":1.4999999999986358},2.5274078042830519,null,null,8.192335886865628,0]
[{"$f":"IF('Hood Inlet'!E22>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E22))","v":1.5999999999985448},2.6942974355858524,null,null,9.1498826640041298,0]
[{"$f":"IF('Hood Inlet'!E23>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E23))","v":1.6999999999984539},2.8460938134014406,null,null,10.104595861964423,0]
[{"$f":"IF('Hood Inlet'!E24>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E24))","v":1.7999999999983629},2.9780915447945442,null,null,11.03238441543335,0]
[{"$f":"IF('Hood Inlet'!E25>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E25))","v":1.899999999998272},3.0828667467106849,null,null,11.895791363304415,0]
[{"$f":"IF('Hood Inlet'!E26>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E26))","v":1.999999999998181},3.1415926535897931,null,null,12.607021244873684,0]
[{"$f":"IF('Hood Inlet'!E27>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E27))","v":2.0999999999980901},3.1415926535897931,null,null,13.092249121116769,0]
[{"$f":"IF('Hood Inlet'!E28>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E28))","v":2.1999999999979991},3.1415926535897931,null,null,13.578332958072703,0]
[{"$f":"IF('Hood Inlet'!E29>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E29))","v":2.2999999999979082},3.1415926535897931,null,null,14.065491149668338,0]
[{"$f":"IF('Hood Inlet'!E30>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E30))","v":2.3999999999978172},3.1415926535897931,null,null,14.553912639999163,0]
[{"$f":"IF('Hood Inlet'!E31>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E31))","v":2.4999999999977263},3.1415926535897931,null,null,15.043761546710007,0]
[{"$f":"IF('Hood Inlet'!E32>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E32))","v":2.5999999999976353},3.1415926535897931,null,null,15.535180922861123,0]
[{"$f":"IF('Hood Inlet'!E33>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E33))","v":2.6999999999975444},3.1415926535897931,null,null,16.028295842914797,0]
[{"$f":"IF('Hood Inlet'!E34>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E34))","v":2.7999999999974534},3.1415926535897931,null,null,16.523215953324144,0]
[{"$f":"IF('Hood Inlet'!E35>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E35))","v":2.8999999999973625},3.1415926535897931,null,null,17.020037595216568,0]
[{"$f":"IF('Hood Inlet'!E36>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E36))","v":2.9999999999972715},3.1415926535897931,null,null,17.518845582263666,0]
[{"$f":"IF('Hood Inlet'!E37>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E37))","v":3.0999999999971806},3.1415926535897931,null,null,18.019714698574649,0]
[{"$f":"IF('Hood Inlet'!E38>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E38))","v":3.1999999999970896},{"$f":"IF(A39=\"\",\"\",IF(A39<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A39)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A39)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A39)^2),IF(A39<=Pipe_Diam_Ft,0,Barea)))","v":3.1415926535897931},null,null,{"$f":"IF(A39=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A39/Pipe_Diam_Ft)*(B39/Barea)*(A39/Pipe_Diam_Ft)^0.5)","v":18.522710967649122},{"$f":"IF(A39=\"\",\"\",IF(A39<slugstart,0,IF(A39/(Pipe_Diam/12)-Cs<0,0,((A39/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":9.0509667988585232}]
[{"$f":"IF('Hood Inlet'!E39>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E39))","v":3.2999999999969987},3.1415926535897931,null,null,19.027892732888869,20.364675297832992]
[{"$f":"IF('Hood Inlet'!E40>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E40))","v":3.3999999999969077},3.1415926535897931,null,null,19.535311582050465,31.678383796807463]
[{"$f":"IF('Hood Inlet'!E41>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E41))","v":3.4999999999968168},3.1415926535897931,null,null,20.045013141713799,42.992092295781937]
[{"$f":"IF('Hood Inlet'!E42>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E42))","v":3.5},3.1415926535897931,null,null,20.045013141730063,42.992092296142076]
[{"$f":"IF('Hood Inlet'!E43>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E43))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E44>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E44))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E45>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E45))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E46>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E46))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E47>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E47))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E48>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E48))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E49>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E49))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E50>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E50))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E51>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E51))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E52>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E52))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E53>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E53))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E54>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E54))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E55>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E55))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E56>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E56))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E57>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E57))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E58>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E58))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E59>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E59))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E60>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E60))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E61>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E61))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E62>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E62))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E63>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E63))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E64>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E64))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E65>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E65))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E66>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E66))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E67>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E67))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E68>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E68))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E69>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E69))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E70>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E70))","v":""},{"$f":"IF(A71=\"\",\"\",IF(A71<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A71)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A71)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A71)^2),IF(A71<=Pipe_Diam_Ft,0,Barea)))","v":""},null,null,{"$f":"IF(A71=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A71/Pipe_Diam_Ft)*(B71/Barea)*(A71/Pipe_Diam_Ft)^0.5)","v":""},{"$f":"IF(A71=\"\",\"\",IF(A71<slugstart,0,IF(A71/(Pipe_Diam/12)-Cs<0,0,((A71/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":""}]
[{"$f":"IF('Hood Inlet'!E71>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E71))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E72>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E72))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E73>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E73))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E74>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E74))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E75>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E75))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E76>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E76))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E77>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E77))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E78>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E78))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E79>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E79))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E80>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E80))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E81>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E81))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E82>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E82))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E83>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E83))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E84>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E84))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E85>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E85))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E86>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E86))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E87>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E87))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E88>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E88))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E89>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E89))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E90>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E90))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E91>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E91))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E92>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E92))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E93>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E93))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E94>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E94))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E95>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E95))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E96>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E96))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E97>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E97))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E98>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E98))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E99>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E99))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E100>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E100))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E101>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E101))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E102>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E102))","v":""},{"$f":"IF(A103=\"\",\"\",IF(A103<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A103)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A103)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A103)^2),IF(A103<=Pipe_Diam_Ft,0,Barea)))","v":""},null,null,{"$f":"IF(A103=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A103/Pipe_Diam_Ft)*(B103/Barea)*(A103/Pipe_Diam_Ft)^0.5)","v":""},{"$f":"IF(A103=\"\",\"\",IF(A103<slugstart,0,IF(A103/(Pipe_Diam/12)-Cs<0,0,((A103/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":""}]
[{"$f":"IF('Hood Inlet'!E103>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E103))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E104>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E104))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E105>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E105))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E106>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E106))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E107>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E107))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E108>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E108))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E109>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E109))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E110>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E110))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E111>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E111))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E112>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E112))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E113>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E113))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E114>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E114))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E115>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E115))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E116>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E116))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E117>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E117))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E118>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E118))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E119>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E119))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E120>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E120))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E121>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E121))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E122>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E122))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E123>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E123))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E124>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E124))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E125>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E125))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E126>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E126))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E127>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E127))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E128>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E128))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E129>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E129))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E130>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E130))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E131>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E131))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E132>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E132))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E133>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E133))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E134>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E134))","v":""},{"$f":"IF(A135=\"\",\"\",IF(A135<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A135)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A135)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A135)^2),IF(A135<=Pipe_Diam_Ft,0,Barea)))","v":""},null,null,{"$f":"IF(A135=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A135/Pipe_Diam_Ft)*(B135/Barea)*(A135/Pipe_Diam_Ft)^0.5)","v":""},{"$f":"IF(A135=\"\",\"\",IF(A135<slugstart,0,IF(A135/(Pipe_Diam/12)-Cs<0,0,((A135/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":""}]
[{"$f":"IF('Hood Inlet'!E135>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E135))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E136>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E136))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E137>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E137))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E138>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E138))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E139>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E139))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E140>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E140))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E141>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E141))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E142>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E142))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E143>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E143))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E144>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E144))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E145>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E145))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E146>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E146))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E147>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E147))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E148>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E148))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E149>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E149))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E150>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E150))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E151>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E151))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E152>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E152))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E153>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E153))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E154>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E154))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E155>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E155))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E156>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E156))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E157>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E157))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E158>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E158))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E159>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E159))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E160>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E160))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E161>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E161))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E162>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E162))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E163>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E163))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E164>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E164))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E165>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E165))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E166>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E166))","v":""},{"$f":"IF(A167=\"\",\"\",IF(A167<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A167)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A167)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A167)^2),IF(A167<=Pipe_Diam_Ft,0,Barea)))","v":""},null,null,{"$f":"IF(A167=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A167/Pipe_Diam_Ft)*(B167/Barea)*(A167/Pipe_Diam_Ft)^0.5)","v":""},{"$f":"IF(A167=\"\",\"\",IF(A167<slugstart,0,IF(A167/(Pipe_Diam/12)-Cs<0,0,((A167/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":""}]
[{"$f":"IF('Hood Inlet'!E167>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E167))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E168>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E168))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E169>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E169))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E170>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E170))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E171>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E171))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E172>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E172))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E173>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E173))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E174>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E174))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E175>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E175))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E176>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E176))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E177>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E177))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E178>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E178))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E179>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E179))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E180>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E180))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E181>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E181))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E182>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E182))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E183>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E183))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E184>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E184))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E185>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E185))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E186>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E186))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E187>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E187))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E188>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E188))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E189>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E189))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E190>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E190))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E191>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E191))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E192>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E192))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E193>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E193))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E194>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E194))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E195>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E195))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E196>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E196))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E197>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E197))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E198>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E198))","v":""},{"$f":"IF(A199=\"\",\"\",IF(A199<=Pipe_Diam_Ft,Pipe_Diam_Ft^2/4*ACOS((Pipe_Diam_Ft-2*A199)/Pipe_Diam_Ft)-(Pipe_Diam_Ft/2-A199)*SQRT((Pipe_Diam_Ft/2)^2-(Pipe_Diam_Ft/2-A199)^2),IF(A199<=Pipe_Diam_Ft,0,Barea)))","v":""},null,null,{"$f":"IF(A199=\"\",\"\",(Pipe_Diam_Ft^2.5)*(1.83*PipeSlope^(1/15)+0.6*A199/Pipe_Diam_Ft)*(B199/Barea)*(A199/Pipe_Diam_Ft)^0.5)","v":""},{"$f":"IF(A199=\"\",\"\",IF(A199<slugstart,0,IF(A199/(Pipe_Diam/12)-Cs<0,0,((A199/(Pipe_Diam/12)-Cs)*(Pipe_Diam/12)^2.5)/0.025)))","v":""}]
[{"$f":"IF('Hood Inlet'!E199>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E199))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E200>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E200))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E201>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E201))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E202>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E202))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E203>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E203))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E204>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E204))","v":""},"",null,null,"",""]
[{"$f":"IF('Hood Inlet'!E205>1.81*Pipe_Diam/12,\"\",VALUE('Hood Inlet'!E205))","v":""},"",null,null,"",""]
[null,null,null,null,null,"End"]

{"sheet":"CFS chart","index":5,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Project Name:",{"$f":"IF('Hood Inlet'!B1=\"\",\"\",'Hood Inlet'!B1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"'Hood Inlet'!K1","v":"IaHoodInlet.xls Ver 1.30"}]
[null,"Computed by:",{"$f":"IF('Hood Inlet'!B2=\"\",\"\",'Hood Inlet'!B2)","v":""}]
[null,"Date:",{"$f":"IF('Hood Inlet'!B3=\"\",\"\",'Hood Inlet'!B3)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"'Hood Inlet'!I2","v":""}]

{"sheet":"Info","index":6,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,0,4,6],[37,0,41,5],[42,0,44,5],[34,0,34,5],[33,0,33,5],[28,0,28,5],[27,0,27,5],[29,0,29,5],[30,0,30,5]]}
[{"$f":"'Hood Inlet'!K1","v":"IaHoodInlet.xls Ver 1.30"}]
["2017-12-20"]
[]
["Calculates flow capacity of a pipe structure consisting of a hood inlet and a circular conduit. Limiting flow conditions reviewed are:"]
[]
[null,"Weir flow"]
[null,"Slug Flow"]
[null,"Full pipe flow"]
[]
[]
["Maximum number of elevation intervals displayed is 200."]
[]
["Program support:"]
["State Conservation Engineer"]
["USDA Natural Resources Conservation Service"]
["693 Federal Bldg"]
["210 Walnut St"]
["Des Moines, Iowa 50309"]
["515.284.4135"]
[]
["Double Click Here"]
["to View the Documentation"]
["Adobe Reader is require to open this."]
[]
[]
["Updates"]
["Version 1.25"]
["Updates to match computations used in the NRCS Engineering Field Tools software"]
["Slug flow equations match EFT software"]
["Weir flow equations match EFT software"]
["Tailwater is the outlet elevation + 0.5* the pipe diameter."]
[]
["Version 1.20"]
["On the Pipe Length tab: Computations of station and elevation of the pipe profile for use in CADD were added. The user needs to input the station value of the CL of dam."]
["On the Hood Inlet tab: Elevations used after full pipe flow occurs are now multiples of the Elevation Increment value rather than increments above the crest elevation. "]
[]
["Version 1.10"]
["For the case when the standard tailwater is higher than the inlet, the limiting valve prior to reaching full pipe flow is now correctly displayed as either Weir flow or Slug flow. Previously a value of 0 was displayed rather than displaying the larger of the Weir or Slug Flow values."]
[]
[]
[]
[]
["If tailwater is entered in that is higher than the inlet elevation, a VOID message will be displayed since Weir flow & Slug flow values are not able to be calculated correctly."]