{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DROP Inlet","Flow Data","Pipe Length","CFS chart","Info"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":53,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DROP Inlet","index":0,"n_rows":205,"n_cols":26,"rows_kept":205,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,3],[2,7,4,7],[2,9,4,9],[1,5,1,8],[2,5,4,5],[2,6,4,6],[2,1,2,2],[57,0,58,2],[44,0,46,2],[48,0,49,2],[2,8,4,8],[51,0,52,2],[54,0,55,2],[41,0,43,2],[18,1,18,2],[35,0,36,1]]}
["Project Name: ",null,null,null,null,null,null,null,null,null,null,"IaDropInlet.xls Ver 1.10"]
["Computed by: ",null,null,null,null,"Outflow, CFS",null,null,null,{"$f":"IF(Y17=0,\"\",\"Void - Press Compute\")","v":""}]
["Date: ",null,null,null,null,"Weir","Inlet Orfice","Barrel Orifice","Full Pipe"," Structure Outflow, CFS"]
["Checked by: ",null,null,null,"HW","cfs","cfs",null,"cfs","cfs",null,"Controlling",null,null,"Intersection of Weir & Full Pipe Flow",null,"Barrel Orifice Check","Inlet Orifice Check"]
["Date: ",null,null,"Elev","Ft","Weir","Inlet Orfice",null,"Full Pipe","Struct",null,"Factor",null,null,{"$f":"MAX(O6:O205)","v":106.1163579815415},null,{"$f":"SUM(Q6:Q205)","v":0},{"$f":"SUM(R6:R205)","v":0},"Full Pipe Flow"]
["Input Data",null,null,{"$f":"IF(crest=\"\",\"\",crest)","v":105},{"$f":"IF(D6=\"\",\"\",D6-crest)","v":0},{"$f":"IF(E6=\"\",\"\",3.33*E6^1.5*(WeirLnet))","v":0},{"$f":"IF(E6=\"\",\"\",Rarea*0.61*(64.4*E6)^0.5)","v":0},{"$f":"IF(D6=\"\",\"\",Barea*BOcoeff*(64.4*(D6-(invert+Pipe_Diam/24)))^0.5)","v":43.497834333985921},{"$f":"IF(E6=\"\",\"\",Barea*((64.4*(D6-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5)","v":40.019030025871018},{"$f":"IF(E6=\"\",\"\",MIN(F6:I6))","v":0},null,{"$f":"IF(E6=\"\",\"\",IF(J6=F6,\"Weir Flow\",IF(J6=G6,\"Inlet Orifice\",IF(J6=H6,\"Barrel Orifice\",\"Full Pipe Flow\"))))","v":"Weir Flow"},null,{"$f":"IF(F6>I6,TRUE, FALSE)","v":false},null,null,{"$f":"IF(E6=\"\",\"\",IF(J6=F6,0,IF(J6=G6,0,IF(J6=H6,1,0))))","v":0},{"$f":"IF(E6=\"\",\"\",IF(J6=F6,0,IF(J6=G6,1,0)))","v":0}]
["Riser Type & Diameter (in)",{"$f":"IF(ISNUMBER(Riser_Diam),\"Circular\",\"D x 3D\")","v":"Circular"},42,{"$f":"IF(D6=\"\",\"\",IF(D6>=high_water,\"\",IF(L6=\"Full Pipe Flow\",(INT((D6-crest+0.01)/change_inc)+1)*change_inc+crest,D6+NonFPincr)))","v":105.1},{"$f":"IF(D7=\"\",\"\",D7-crest)","v":9.9999999999994316E-2},1.1052243393366374,14.893567524362149,{"$f":"IF(D7=\"\",\"\",Barea*BOcoeff*(64.4*(D7-(invert+Pipe_Diam/24)))^0.5)","v":43.76885150016755},{"$f":"IF(E7=\"\",\"\",Barea*((64.4*(D7-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5)","v":40.130040031149107},{"$f":"IF(E7=\"\",\"\",MIN(F7:I7))","v":1.1052243393366374},null,{"$f":"IF(E7=\"\",\"\",IF(J7=F7,\"Weir Flow\",IF(J7=G7,\"Inlet Orifice\",IF(J7=H7,\"Barrel Orifice\",\"Full Pipe Flow\"))))","v":"Weir Flow"},null,{"$f":"IF(F7>I7,TRUE, FALSE)","v":false},{"$f":"IF(AND(NOT(N7),N8),(F7-I7)/((I8-I7)/(D8-D7)-(F8-F7)/(D8-D7))+D7,\"\")","v":""},null,{"$f":"IF(E7=\"\",\"\",IF(J7=F7,0,IF(J7=G7,0,IF(J7=H7,1,0))))","v":0},{"$f":"IF(E7=\"\",\"\",IF(J7=F7,0,IF(J7=G7,1,0)))","v":0},{"$f":"IF(D7=\"\",\"\",IF(I7=J7,I7,\"\"))","v":""}]
["Length of Weir Obstruction(ft)",null,0.5,{"$f":"IF(D7=\"\",\"\",IF(D7>=high_water,\"\",IF(L7=\"Full Pipe Flow\",(INT((D7-crest+0.01)/change_inc)+1)*change_inc+crest,D7+NonFPincr)))","v":105.19999999999999},{"$f":"IF(D8=\"\",\"\",D8-crest)","v":0.19999999999998863},3.1260465003094349,21.062685185072436,44.038200820884519,40.240743800179608,3.1260465003094349,null,"Weir Flow",null,false,{"$f":"IF(AND(NOT(N8),N9),(F8-I8)/((I9-I8)/(D9-D8)-(F9-F8)/(D9-D8))+D8,\"\")","v":""},null,0,0,"",null,null,null,null,null,"Max Full Pipe Flow",{"$f":"MAX(I6:I205)","v":46.209995516288693}]
[{"$f":"IF(ISNUMBER(Riser_Diam),\"\",\"Radius of crest rounding, (in)\")","v":""},null,6,105.29999999999998,0.29999999999998295,5.7429141284784082,25.796415658153066,44.30591271418961,40.35114385344928,5.7429141284784082,null,"Weir Flow",null,false,"",null,0,0,"",null,null,null,null,null,"Max Y for Chart",{"$f":"5*INT(1+(1.25*Z8/5))","v":60}]
["Principal Spillway Crest Elev (ft)",null,105,105.39999999999998,0.39999999999997726,8.8417947146931013,29.787135048724299,44.572016684622014,40.461242677058515,8.8417947146931013,null,"Weir Flow",null,false,"",null,0,0,""]
["Invert of Barrel Elevation (ft)",null,96,105.49999999999997,0.49999999999997158,12.356783765720087,33.30302941195702,44.836541361160521,40.571042723374575,12.356783765720087,null,"Weir Flow",null,false,"",null,0,0,""]
["Barrel Orifice Coefficient (C)",null,0.61,105.59999999999997,0.59999999999996589,16.243414096076453,36.481640884373732,45.099514533173114,40.680546411668914,16.243414096076453,null,"Weir Flow",null,false,"",null,0,0,""]
["Pipe Diameter (in)",null,24,105.69999999999996,0.69999999999996021,20.469041213742837,39.404675804010168,45.360963184490778,40.789756128739135,20.469041213742837,null,"Weir Flow",null,false,"",null,0,0,"",null,null,null,"Full Pipe increment1=",{"$f":"IF(change_inc1=\"\",NonFPincr,change_inc1)","v":0.2}]
["Pipe Length (ft)",null,112,105.79999999999995,0.79999999999995453,25.008372002475468,42.125370370144871,45.620913525723729,40.89867422951599,25.008372002475468,null,"Weir Flow",null,false,"",null,0,0,"",null,null,null,"Non Full Pipe Increment=",0.1]
["Entrance Coefficient 'Ke'",null,1,105.89999999999995,0.89999999999994884,29.841057162089218,44.68070257308645,45.879391024929667,41.007303037655859,29.841057162089218,null,"Weir Flow",null,false,"",null,0,0,""]
["Mannings 'n-value'",null,2.5000000000000001E-2,105.99999999999994,0.99999999999994316,34.950262377586064,47.097595862499695,46.13642043673557,41.115644846119139,34.950262377586064,null,"Weir Flow",null,false,"",null,0,0,""]
["Elbow Elev (if None, Leave 'BLANK')",null,null,106.09999999999994,1.0999999999999375,40.321758870228678,49.396375268131614,46.39202583000732,41.223701917734985,40.321758870228678,null,"Weir Flow",null,false,106.1163579815415,null,0,0,""]
["Length of Outlet ('BLANK' if none)",null,null,106.19999999999993,1.1999999999999318,45.943313027827259,51.592831316306132,46.646230614154682,41.331476485752731,41.331476485752731,null,"Full Pipe Flow",null,true,"",null,0,0,41.331476485752731,null,null,null,"Outlet Type"]
["Outlet Type","Cantilever",null,106.4,1.4000000000000057,57.895191386503214,55.726626942947824,47.150528844357524,41.546186899310818,41.546186899310818,null,"Full Pipe Flow",null,true,"",null,0,0,41.546186899310818,null,null,null,1,"Cantilever"]
["Outlet Elevation (ft)",null,86,106.6,1.5999999999999943,70.734357717550481,59.574270097450182,47.649490134693572,41.759793381344615,41.759793381344615,null,"Full Pipe Flow",null,true,"",null,0,0,41.759793381344615,null,null,null,2,"Slotted Flume"]
["Tailwater Elev (if unknown, leave 'Blank')",null,null,106.8,1.7999999999999972,84.40325550836171,63.188055555219044,48.143280423024073,41.972312786320494,41.972312786320494,null,"Full Pipe Flow",null,true,"",null,0,0,41.972312786320494]
["Auxiliary Spillway Elev (ft)",null,109,107,2,98.854270125769091,66.60605882391593,48.632057222408406,42.183761544139841,42.183761544139841,null,"Full Pipe Flow",null,true,"",null,0,0,42.183761544139841]
["Maximum Headwater Elev (ft)",null,111,107.2,2.2000000000000028,114.04715650604005,69.857023836264673,49.115970208042093,42.394155674962789,42.394155674962789,null,"Full Pipe Flow",null,true,"",null,0,0,42.394155674962789]
["Elev Increment After Full Pipe Flow",null,0.2,107.4,2.4000000000000057,129.94731276862319,72.963281768749624,49.595161752644294,42.603510803372863,42.603510803372863,null,"Full Pipe Flow",null,true,"",null,0,0,42.603510803372863]
[null,null,null,107.6,2.5999999999999943,146.52457230256746,75.942591433736453,50.069767415723241,42.811842171918229,42.811842171918229,null,"Full Pipe Flow",null,true,"",null,0,0,42.811842171918229]
["Basic Output",null,null,107.8,2.7999999999999972,163.7523297099564,78.809351608022524,50.539916391484994,43.019164654062784,43.019164654062784,null,"Full Pipe Flow",null,true,"",null,0,0,43.019164654062784]
[null,"Full Pipe Flow - Max. Outflow (cfs):",{"$f":"MAX(S7:S205)","v":46.209995516288693},108,3,181.60689052754176,81.575428948197526,51.005731919579063,43.225492766578078,43.225492766578078,null,"Full Pipe Flow",null,true,"",null,0,0,43.225492766578078,"NOTE: Pipe slope computed to be greater than friction slope - but 5D is being used - OK"]
[null,"Full Pipe Flow - Max. Velocity (fps):",{"$f":"MAX(S7:S205)/Barea","v":14.709098413343332},108.2,3.2000000000000028,200.06697601982108,84.250740740292159,51.467331662382101,43.430840681405449,43.430840681405449,null,"Full Pipe Flow",null,true,"",null,0,0,43.430840681405449,"NOTE: Pipe slope computed to be greater than friction slope - a 2D riser might improve flow characteristics."]
[null,"Useable Weir Length (Ft):",{"$f":"IF(ISNUMBER(Riser_Diam),(PI()*Riser_Diam/12)-WeirObs,Pipe_Diam*6/12+4*radius/12-WeirObs)","v":10.495574287564276},108.4,3.4000000000000057,219.11333849327912,86.843675777188437,51.924828052091918,43.635222237015725,43.635222237015725,null,"Full Pipe Flow",null,true,"",null,0,0,43.635222237015725,"NOTE: Pipe slope computed to be greater than friction slope - a 5D riser can eliminate flow problems"]
[null,"Riser Area (Sq Ft):",{"$f":"IF(ISNUMBER(Riser_Diam),(Riser_Diam/24)^2*PI(),3*Pipe_Diam^2/144)","v":9.6211275016187408},108.6,3.5999999999999943,238.72845729673355,89.361405146175358,52.378328610533018,43.838650949292209,43.838650949292209,null,"Full Pipe Flow",null,true,"",null,0,0,43.838650949292209]
[null,"Barrel Area (Sq Ft):",{"$f":"(Pipe_Diam/24)^2* PI()","v":3.1415926535897931},108.8,3.7999999999999972,258.89629496552027,91.810116201344599,52.827936244251049,44.041140021961368,44.041140021961368,null,"Full Pipe Flow",null,true,"",null,0,0,44.041140021961368,"NOTE: Barrel Orifice control can be eliminated by increasing the riser depth."]
[null,"Kp:",{"$f":"5087*Mannings^2/Pipe_Diam^(4/3)","v":4.592615628413646E-2},109,4,279.60209902071222,94.19519172500209,53.273749517190232,44.242702356593639,44.242702356593639,null,"Full Pipe Flow",null,true,"",null,0,0,44.242702356593639,"NOTE: Inlet Orifice control can be eliminated by increasing the riser diameter."]
[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.14014951244421325},109.2,4.2000000000000028,300.83223898604138,96.521349199622165,53.715862903001003,44.443350562196194,44.443350562196194,null,"Full Pipe Flow",null,true,"",null,0,0,44.443350562196194,"VOID: Principal Spillway inlet may not be lower than the barrel invert elevation."]
[null,"Pipe Slope: ",{"$f":"IF(OR(elbow=\"\",len_outlet=\"\"),TAN(ASIN((invert-outlet)/Pipe_Len)),TAN(ASIN((invert-elbow)/(Pipe_Len-len_outlet))))","v":8.9643746495559881E-2},109.4,4.4000000000000057,322.57407096185756,98.792750536266084,54.154367018807193,44.643096964417616,44.643096964417616,null,"Full Pipe Flow",null,true,"",null,0,0,44.643096964417616,"Warning: Principal Spillway outlet is higher than the barrel invert 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":0},109.6,4.5999999999999943,344.81582403911267,101.01308957618498,54.58934884207121,44.841953614383499,44.841953614383499,null,"Full Pipe Flow",null,true,"",null,0,0,44.841953614383499]
["Maximum Barrel Invert Elevation for avoiding Barrel Orifice Control:",null,null,109.8,4.7999999999999972,367.54650422264893,103.18566263261516,55.020891912027516,45.039932297181018,45.039932297181018,null,"Full Pipe Flow",null,true,"",null,0,0,45.039932297181018,"Warning: Please check the elevation of the elbow."]
[null,null,{"$f":"Weir_FP_cross-((Weir_FP_cross-TailW)/(1+Entrance_Coeff+km+Kp*Pipe_Len))/(BOcoeff^2)-Pipe_Diam/24","v":97.924841452152691},110,5,390.75581253871241,105.31342592536517,55.449076517005111,45.237044540009229,45.237044540009229,null,"Full Pipe Flow",null,true,"",null,0,0,45.237044540009229]
[null,"Km:",{"$f":"IF(ElAngle>30,30*Mannings/3,ABS(ElAngle*Mannings/3))","v":0},110.2,5.2000000000000028,{"$f":"IF(E38=\"\",\"\",3.33*E38^1.5*(WeirLnet))","v":414.43407474241798},{"$f":"IF(E38=\"\",\"\",Rarea*0.61*(64.4*E38)^0.5)","v":107.39904276734907},55.873979868829466,45.43330162001115,45.43330162001115,null,"Full Pipe Flow",null,true,"",null,0,0,45.43330162001115,"Warning: The Principal Spillway elevation is lower than the top of the barrel."]
[null,"Tailwater Elev Used For Full Pipe Flow:",{"$f":"MAX(TWentered,IF(OutType=\"Slotted Flume\", outlet,Pipe_Diam/12*0.5+outlet))","v":87},110.4,5.4000000000000057,438.57218059410235,109.44492265312438,56.29567626537613,45.628714571802661,45.628714571802661,null,"Full Pipe Flow",null,true,"",null,0,0,{"$f":"IF(D39=\"\",\"\",IF(I39=J39,I39,\"\"))","v":45.628714571802661}]
[null,null,null,110.6,5.5999999999999943,463.16153109202219,111.45325388589535,56.714237242245467,45.823294194712403,45.823294194712403,null,"Full Pipe Flow",null,true,"",null,0,0,45.823294194712403,"NOTE: The pipe slope is flatter than the outlet slope. Eliminate or lower the elbow."]
["Notes & Warnings",null,null,110.8,5.7999999999999972,488.19399236907935,113.42603100240856,57.129731714435479,46.017051059746244,46.017051059746244,null,"Full Pipe Flow",null,true,"",null,0,0,46.017051059746244,"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,T41,IF(ElAngle<0,T40,\"\")))","v":""},null,null,111,6,513.66185520891099,115.36507797494374,57.542226108806815,46.209995516288693,46.209995516288693,null,"Full Pipe Flow",null,true,"",null,0,0,46.209995516288693]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","","","Warning: Please enter a Mannings N value (positive number)"]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[{"$f":"IF(Mannings<=0,T43,IF(C34>C33,IF((crest-invert)>=5*Pipe_Diam/12,T27,IF((crest-invert)>=2*Pipe_Diam/12,T29,T28)),\"\"))","v":""},null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[{"$f":"IF(Q5>0,T31,\"\")","v":""},null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[{"$f":"IF(crest<invert,T33,IF(outlet>invert,T34,IF(elbow<>\"\",IF(OR(elbow<outlet,invert<elbow,elbow-outlet>len_outlet),T36,\"\"),\"\")))","v":""},null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[{"$f":"IF(crest<=(invert+Pipe_Diam/12),T38,\"\")","v":""},null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[{"$f":"IF(IOcheck>0,T32,\"\")","v":""},null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","",{"$f":"IF(E70=\"\",\"\",3.33*E70^1.5*(WeirLnet))","v":""},{"$f":"IF(E70=\"\",\"\",Rarea*0.61*(64.4*E70)^0.5)","v":""},"","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","",{"$f":"IF(D71=\"\",\"\",Barea*BOcoeff*(64.4*(D71-(invert+Pipe_Diam/24)))^0.5)","v":""},{"$f":"IF(E71=\"\",\"\",Barea*((64.4*(D71-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5)","v":""},{"$f":"IF(E71=\"\",\"\",MIN(F71:I71))","v":""},null,{"$f":"IF(E71=\"\",\"\",IF(J71=F71,\"Weir Flow\",IF(J71=G71,\"Inlet Orifice\",IF(J71=H71,\"Barrel Orifice\",\"Full Pipe Flow\"))))","v":""},null,{"$f":"IF(F71>I71,TRUE, FALSE)","v":false},"",null,{"$f":"IF(E71=\"\",\"\",IF(J71=F71,0,IF(J71=G71,0,IF(J71=H71,1,0))))","v":""},{"$f":"IF(E71=\"\",\"\",IF(J71=F71,0,IF(J71=G71,1,0)))","v":""},{"$f":"IF(D71=\"\",\"\",IF(I71=J71,I71,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D71=\"\",\"\",IF(D71>=high_water,\"\",IF(L71=\"Full Pipe Flow\",(INT((D71-crest+0.01)/change_inc)+1)*change_inc+crest,D71+NonFPincr)))","v":""},{"$f":"IF(D72=\"\",\"\",D72-crest)","v":""},"","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N72),N73),(F72-I72)/((I73-I72)/(D73-D72)-(F73-F72)/(D73-D72))+D72,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","",{"$f":"IF(E102=\"\",\"\",3.33*E102^1.5*(WeirLnet))","v":""},{"$f":"IF(E102=\"\",\"\",Rarea*0.61*(64.4*E102)^0.5)","v":""},"","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",{"$f":"IF(D103=\"\",\"\",IF(I103=J103,I103,\"\"))","v":""}]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","",{"$f":"IF(E134=\"\",\"\",3.33*E134^1.5*(WeirLnet))","v":""},{"$f":"IF(E134=\"\",\"\",Rarea*0.61*(64.4*E134)^0.5)","v":""},"","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","",{"$f":"IF(D135=\"\",\"\",Barea*BOcoeff*(64.4*(D135-(invert+Pipe_Diam/24)))^0.5)","v":""},{"$f":"IF(E135=\"\",\"\",Barea*((64.4*(D135-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5)","v":""},{"$f":"IF(E135=\"\",\"\",MIN(F135:I135))","v":""},null,{"$f":"IF(E135=\"\",\"\",IF(J135=F135,\"Weir Flow\",IF(J135=G135,\"Inlet Orifice\",IF(J135=H135,\"Barrel Orifice\",\"Full Pipe Flow\"))))","v":""},null,{"$f":"IF(F135>I135,TRUE, FALSE)","v":false},"",null,{"$f":"IF(E135=\"\",\"\",IF(J135=F135,0,IF(J135=G135,0,IF(J135=H135,1,0))))","v":""},{"$f":"IF(E135=\"\",\"\",IF(J135=F135,0,IF(J135=G135,1,0)))","v":""},{"$f":"IF(D135=\"\",\"\",IF(I135=J135,I135,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D135=\"\",\"\",IF(D135>=high_water,\"\",IF(L135=\"Full Pipe Flow\",(INT((D135-crest+0.01)/change_inc)+1)*change_inc+crest,D135+NonFPincr)))","v":""},{"$f":"IF(D136=\"\",\"\",D136-crest)","v":""},"","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N136),N137),(F136-I136)/((I137-I136)/(D137-D136)-(F137-F136)/(D137-D136))+D136,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","",{"$f":"IF(E166=\"\",\"\",3.33*E166^1.5*(WeirLnet))","v":""},{"$f":"IF(E166=\"\",\"\",Rarea*0.61*(64.4*E166)^0.5)","v":""},"","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",{"$f":"IF(D167=\"\",\"\",IF(I167=J167,I167,\"\"))","v":""}]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","",{"$f":"IF(E198=\"\",\"\",3.33*E198^1.5*(WeirLnet))","v":""},{"$f":"IF(E198=\"\",\"\",Rarea*0.61*(64.4*E198)^0.5)","v":""},"","","",null,"",null,false,"",null,"","",""]
[null,null,null,"","","","",{"$f":"IF(D199=\"\",\"\",Barea*BOcoeff*(64.4*(D199-(invert+Pipe_Diam/24)))^0.5)","v":""},{"$f":"IF(E199=\"\",\"\",Barea*((64.4*(D199-TailW))/(1+Entrance_Coeff+km+Kp*Pipe_Len))^0.5)","v":""},{"$f":"IF(E199=\"\",\"\",MIN(F199:I199))","v":""},null,{"$f":"IF(E199=\"\",\"\",IF(J199=F199,\"Weir Flow\",IF(J199=G199,\"Inlet Orifice\",IF(J199=H199,\"Barrel Orifice\",\"Full Pipe Flow\"))))","v":""},null,{"$f":"IF(F199>I199,TRUE, FALSE)","v":false},"",null,{"$f":"IF(E199=\"\",\"\",IF(J199=F199,0,IF(J199=G199,0,IF(J199=H199,1,0))))","v":""},{"$f":"IF(E199=\"\",\"\",IF(J199=F199,0,IF(J199=G199,1,0)))","v":""},{"$f":"IF(D199=\"\",\"\",IF(I199=J199,I199,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D199=\"\",\"\",IF(D199>=high_water,\"\",IF(L199=\"Full Pipe Flow\",(INT((D199-crest+0.01)/change_inc)+1)*change_inc+crest,D199+NonFPincr)))","v":""},{"$f":"IF(D200=\"\",\"\",D200-crest)","v":""},"","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N200),N201),(F200-I200)/((I201-I200)/(D201-D200)-(F201-F200)/(D201-D200))+D200,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N201),N202),(F201-I201)/((I202-I201)/(D202-D201)-(F202-F201)/(D202-D201))+D201,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N202),N203),(F202-I202)/((I203-I202)/(D203-D202)-(F203-F202)/(D203-D202))+D202,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N203),N204),(F203-I203)/((I204-I203)/(D204-D203)-(F204-F203)/(D204-D203))+D203,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,{"$f":"IF(AND(NOT(N204),N205),(F204-I204)/((I205-I204)/(D205-D204)-(F205-F204)/(D205-D204))+D204,\"\")","v":""},null,"","",""]
[null,null,null,"","","","","","","",null,"",null,false,null,null,"","",""]

{"sheet":"Flow Data","index":1,"n_rows":201,"n_cols":6,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["Elev","Weir","Inlet Orfice","Barrel Orifice","Full Pipe"," Structure Outflow"]
[{"$f":"'DROP Inlet'!D6","v":105},{"$f":"'DROP Inlet'!F6","v":0},{"$f":"'DROP Inlet'!G6","v":0},{"$f":"'DROP Inlet'!H6","v":43.497834333985921},{"$f":"'DROP Inlet'!I6","v":40.019030025871018},{"$f":"'DROP Inlet'!J6","v":0}]
[{"$f":"'DROP Inlet'!D7","v":105.1},{"$f":"'DROP Inlet'!F7","v":1.1052243393366374},{"$f":"'DROP Inlet'!G7","v":14.893567524362149},{"$f":"'DROP Inlet'!H7","v":43.76885150016755},{"$f":"'DROP Inlet'!I7","v":40.130040031149107},{"$f":"'DROP Inlet'!J7","v":1.1052243393366374}]
[{"$f":"'DROP Inlet'!D8","v":105.19999999999999},{"$f":"'DROP Inlet'!F8","v":3.1260465003094349},{"$f":"'DROP Inlet'!G8","v":21.062685185072436},{"$f":"'DROP Inlet'!H8","v":44.038200820884519},{"$f":"'DROP Inlet'!I8","v":40.240743800179608},{"$f":"'DROP Inlet'!J8","v":3.1260465003094349}]
[{"$f":"'DROP Inlet'!D9","v":105.29999999999998},{"$f":"'DROP Inlet'!F9","v":5.7429141284784082},{"$f":"'DROP Inlet'!G9","v":25.796415658153066},{"$f":"'DROP Inlet'!H9","v":44.30591271418961},{"$f":"'DROP Inlet'!I9","v":40.35114385344928},{"$f":"'DROP Inlet'!J9","v":5.7429141284784082}]
[{"$f":"'DROP Inlet'!D10","v":105.39999999999998},{"$f":"'DROP Inlet'!F10","v":8.8417947146931013},{"$f":"'DROP Inlet'!G10","v":29.787135048724299},{"$f":"'DROP Inlet'!H10","v":44.572016684622014},{"$f":"'DROP Inlet'!I10","v":40.461242677058515},{"$f":"'DROP Inlet'!J10","v":8.8417947146931013}]
[{"$f":"'DROP Inlet'!D11","v":105.49999999999997},{"$f":"'DROP Inlet'!F11","v":12.356783765720087},{"$f":"'DROP Inlet'!G11","v":33.30302941195702},{"$f":"'DROP Inlet'!H11","v":44.836541361160521},{"$f":"'DROP Inlet'!I11","v":40.571042723374575},{"$f":"'DROP Inlet'!J11","v":12.356783765720087}]
[{"$f":"'DROP Inlet'!D12","v":105.59999999999997},{"$f":"'DROP Inlet'!F12","v":16.243414096076453},{"$f":"'DROP Inlet'!G12","v":36.481640884373732},{"$f":"'DROP Inlet'!H12","v":45.099514533173114},{"$f":"'DROP Inlet'!I12","v":40.680546411668914},{"$f":"'DROP Inlet'!J12","v":16.243414096076453}]
[{"$f":"'DROP Inlet'!D13","v":105.69999999999996},{"$f":"'DROP Inlet'!F13","v":20.469041213742837},{"$f":"'DROP Inlet'!G13","v":39.404675804010168},{"$f":"'DROP Inlet'!H13","v":45.360963184490778},{"$f":"'DROP Inlet'!I13","v":40.789756128739135},{"$f":"'DROP Inlet'!J13","v":20.469041213742837}]
[{"$f":"'DROP Inlet'!D14","v":105.79999999999995},{"$f":"'DROP Inlet'!F14","v":25.008372002475468},{"$f":"'DROP Inlet'!G14","v":42.125370370144871},{"$f":"'DROP Inlet'!H14","v":45.620913525723729},{"$f":"'DROP Inlet'!I14","v":40.89867422951599},{"$f":"'DROP Inlet'!J14","v":25.008372002475468}]
[{"$f":"'DROP Inlet'!D15","v":105.89999999999995},{"$f":"'DROP Inlet'!F15","v":29.841057162089218},{"$f":"'DROP Inlet'!G15","v":44.68070257308645},{"$f":"'DROP Inlet'!H15","v":45.879391024929667},{"$f":"'DROP Inlet'!I15","v":41.007303037655859},{"$f":"'DROP Inlet'!J15","v":29.841057162089218}]
[{"$f":"'DROP Inlet'!D16","v":105.99999999999994},{"$f":"'DROP Inlet'!F16","v":34.950262377586064},{"$f":"'DROP Inlet'!G16","v":47.097595862499695},{"$f":"'DROP Inlet'!H16","v":46.13642043673557},{"$f":"'DROP Inlet'!I16","v":41.115644846119139},{"$f":"'DROP Inlet'!J16","v":34.950262377586064}]
[{"$f":"'DROP Inlet'!D17","v":106.09999999999994},{"$f":"'DROP Inlet'!F17","v":40.321758870228678},{"$f":"'DROP Inlet'!G17","v":49.396375268131614},{"$f":"'DROP Inlet'!H17","v":46.39202583000732},{"$f":"'DROP Inlet'!I17","v":41.223701917734985},{"$f":"'DROP Inlet'!J17","v":40.321758870228678}]
[{"$f":"'DROP Inlet'!D18","v":106.19999999999993},{"$f":"'DROP Inlet'!F18","v":45.943313027827259},{"$f":"'DROP Inlet'!G18","v":51.592831316306132},{"$f":"'DROP Inlet'!H18","v":46.646230614154682},{"$f":"'DROP Inlet'!I18","v":41.331476485752731},{"$f":"'DROP Inlet'!J18","v":41.331476485752731}]
[{"$f":"'DROP Inlet'!D19","v":106.4},{"$f":"'DROP Inlet'!F19","v":57.895191386503214},{"$f":"'DROP Inlet'!G19","v":55.726626942947824},{"$f":"'DROP Inlet'!H19","v":47.150528844357524},{"$f":"'DROP Inlet'!I19","v":41.546186899310818},{"$f":"'DROP Inlet'!J19","v":41.546186899310818}]
[{"$f":"'DROP Inlet'!D20","v":106.6},{"$f":"'DROP Inlet'!F20","v":70.734357717550481},{"$f":"'DROP Inlet'!G20","v":59.574270097450182},{"$f":"'DROP Inlet'!H20","v":47.649490134693572},{"$f":"'DROP Inlet'!I20","v":41.759793381344615},{"$f":"'DROP Inlet'!J20","v":41.759793381344615}]
[{"$f":"'DROP Inlet'!D21","v":106.8},{"$f":"'DROP Inlet'!F21","v":84.40325550836171},{"$f":"'DROP Inlet'!G21","v":63.188055555219044},{"$f":"'DROP Inlet'!H21","v":48.143280423024073},{"$f":"'DROP Inlet'!I21","v":41.972312786320494},{"$f":"'DROP Inlet'!J21","v":41.972312786320494}]
[{"$f":"'DROP Inlet'!D22","v":107},{"$f":"'DROP Inlet'!F22","v":98.854270125769091},{"$f":"'DROP Inlet'!G22","v":66.60605882391593},{"$f":"'DROP Inlet'!H22","v":48.632057222408406},{"$f":"'DROP Inlet'!I22","v":42.183761544139841},{"$f":"'DROP Inlet'!J22","v":42.183761544139841}]
[{"$f":"'DROP Inlet'!D23","v":107.2},{"$f":"'DROP Inlet'!F23","v":114.04715650604005},{"$f":"'DROP Inlet'!G23","v":69.857023836264673},{"$f":"'DROP Inlet'!H23","v":49.115970208042093},{"$f":"'DROP Inlet'!I23","v":42.394155674962789},{"$f":"'DROP Inlet'!J23","v":42.394155674962789}]
[{"$f":"'DROP Inlet'!D24","v":107.4},{"$f":"'DROP Inlet'!F24","v":129.94731276862319},{"$f":"'DROP Inlet'!G24","v":72.963281768749624},{"$f":"'DROP Inlet'!H24","v":49.595161752644294},{"$f":"'DROP Inlet'!I24","v":42.603510803372863},{"$f":"'DROP Inlet'!J24","v":42.603510803372863}]
[{"$f":"'DROP Inlet'!D25","v":107.6},{"$f":"'DROP Inlet'!F25","v":146.52457230256746},{"$f":"'DROP Inlet'!G25","v":75.942591433736453},{"$f":"'DROP Inlet'!H25","v":50.069767415723241},{"$f":"'DROP Inlet'!I25","v":42.811842171918229},{"$f":"'DROP Inlet'!J25","v":42.811842171918229}]
[{"$f":"'DROP Inlet'!D26","v":107.8},{"$f":"'DROP Inlet'!F26","v":163.7523297099564},{"$f":"'DROP Inlet'!G26","v":78.809351608022524},{"$f":"'DROP Inlet'!H26","v":50.539916391484994},{"$f":"'DROP Inlet'!I26","v":43.019164654062784},{"$f":"'DROP Inlet'!J26","v":43.019164654062784}]
[{"$f":"'DROP Inlet'!D27","v":108},{"$f":"'DROP Inlet'!F27","v":181.60689052754176},{"$f":"'DROP Inlet'!G27","v":81.575428948197526},{"$f":"'DROP Inlet'!H27","v":51.005731919579063},{"$f":"'DROP Inlet'!I27","v":43.225492766578078},{"$f":"'DROP Inlet'!J27","v":43.225492766578078}]
[{"$f":"'DROP Inlet'!D28","v":108.2},{"$f":"'DROP Inlet'!F28","v":200.06697601982108},{"$f":"'DROP Inlet'!G28","v":84.250740740292159},{"$f":"'DROP Inlet'!H28","v":51.467331662382101},{"$f":"'DROP Inlet'!I28","v":43.430840681405449},{"$f":"'DROP Inlet'!J28","v":43.430840681405449}]
[{"$f":"'DROP Inlet'!D29","v":108.4},{"$f":"'DROP Inlet'!F29","v":219.11333849327912},{"$f":"'DROP Inlet'!G29","v":86.843675777188437},{"$f":"'DROP Inlet'!H29","v":51.924828052091918},{"$f":"'DROP Inlet'!I29","v":43.635222237015725},{"$f":"'DROP Inlet'!J29","v":43.635222237015725}]
[{"$f":"'DROP Inlet'!D30","v":108.6},{"$f":"'DROP Inlet'!F30","v":238.72845729673355},{"$f":"'DROP Inlet'!G30","v":89.361405146175358},{"$f":"'DROP Inlet'!H30","v":52.378328610533018},{"$f":"'DROP Inlet'!I30","v":43.838650949292209},{"$f":"'DROP Inlet'!J30","v":43.838650949292209}]
[{"$f":"'DROP Inlet'!D31","v":108.8},{"$f":"'DROP Inlet'!F31","v":258.89629496552027},{"$f":"'DROP Inlet'!G31","v":91.810116201344599},{"$f":"'DROP Inlet'!H31","v":52.827936244251049},{"$f":"'DROP Inlet'!I31","v":44.041140021961368},{"$f":"'DROP Inlet'!J31","v":44.041140021961368}]
[{"$f":"'DROP Inlet'!D32","v":109},{"$f":"'DROP Inlet'!F32","v":279.60209902071222},{"$f":"'DROP Inlet'!G32","v":94.19519172500209},{"$f":"'DROP Inlet'!H32","v":53.273749517190232},{"$f":"'DROP Inlet'!I32","v":44.242702356593639},{"$f":"'DROP Inlet'!J32","v":44.242702356593639}]
[{"$f":"'DROP Inlet'!D33","v":109.2},{"$f":"'DROP Inlet'!F33","v":300.83223898604138},{"$f":"'DROP Inlet'!G33","v":96.521349199622165},{"$f":"'DROP Inlet'!H33","v":53.715862903001003},{"$f":"'DROP Inlet'!I33","v":44.443350562196194},{"$f":"'DROP Inlet'!J33","v":44.443350562196194}]
[{"$f":"'DROP Inlet'!D34","v":109.4},{"$f":"'DROP Inlet'!F34","v":322.57407096185756},{"$f":"'DROP Inlet'!G34","v":98.792750536266084},{"$f":"'DROP Inlet'!H34","v":54.154367018807193},{"$f":"'DROP Inlet'!I34","v":44.643096964417616},{"$f":"'DROP Inlet'!J34","v":44.643096964417616}]
[{"$f":"'DROP Inlet'!D35","v":109.6},{"$f":"'DROP Inlet'!F35","v":344.81582403911267},{"$f":"'DROP Inlet'!G35","v":101.01308957618498},{"$f":"'DROP Inlet'!H35","v":54.58934884207121},{"$f":"'DROP Inlet'!I35","v":44.841953614383499},{"$f":"'DROP Inlet'!J35","v":44.841953614383499}]
[{"$f":"'DROP Inlet'!D36","v":109.8},{"$f":"'DROP Inlet'!F36","v":367.54650422264893},{"$f":"'DROP Inlet'!G36","v":103.18566263261516},{"$f":"'DROP Inlet'!H36","v":55.020891912027516},{"$f":"'DROP Inlet'!I36","v":45.039932297181018},{"$f":"'DROP Inlet'!J36","v":45.039932297181018}]
[{"$f":"'DROP Inlet'!D37","v":110},{"$f":"'DROP Inlet'!F37","v":390.75581253871241},{"$f":"'DROP Inlet'!G37","v":105.31342592536517},{"$f":"'DROP Inlet'!H37","v":55.449076517005111},{"$f":"'DROP Inlet'!I37","v":45.237044540009229},{"$f":"'DROP Inlet'!J37","v":45.237044540009229}]
[{"$f":"'DROP Inlet'!D38","v":110.2},{"$f":"'DROP Inlet'!F38","v":414.43407474241798},{"$f":"'DROP Inlet'!G38","v":107.39904276734907},{"$f":"'DROP Inlet'!H38","v":55.873979868829466},{"$f":"'DROP Inlet'!I38","v":45.43330162001115},{"$f":"'DROP Inlet'!J38","v":45.43330162001115}]
[{"$f":"'DROP Inlet'!D39","v":110.4},{"$f":"'DROP Inlet'!F39","v":438.57218059410235},{"$f":"'DROP Inlet'!G39","v":109.44492265312438},{"$f":"'DROP Inlet'!H39","v":56.29567626537613},{"$f":"'DROP Inlet'!I39","v":45.628714571802661},{"$f":"'DROP Inlet'!J39","v":45.628714571802661}]
[{"$f":"'DROP Inlet'!D40","v":110.6},{"$f":"'DROP Inlet'!F40","v":463.16153109202219},{"$f":"'DROP Inlet'!G40","v":111.45325388589535},{"$f":"'DROP Inlet'!H40","v":56.714237242245467},{"$f":"'DROP Inlet'!I40","v":45.823294194712403},{"$f":"'DROP Inlet'!J40","v":45.823294194712403}]
[{"$f":"'DROP Inlet'!D41","v":110.8},{"$f":"'DROP Inlet'!F41","v":488.19399236907935},{"$f":"'DROP Inlet'!G41","v":113.42603100240856},{"$f":"'DROP Inlet'!H41","v":57.129731714435479},{"$f":"'DROP Inlet'!I41","v":46.017051059746244},{"$f":"'DROP Inlet'!J41","v":46.017051059746244}]
[{"$f":"'DROP Inlet'!D42","v":111},{"$f":"'DROP Inlet'!F42","v":513.66185520891099},{"$f":"'DROP Inlet'!G42","v":115.36507797494374},{"$f":"'DROP Inlet'!H42","v":57.542226108806815},{"$f":"'DROP Inlet'!I42","v":46.209995516288693},{"$f":"'DROP Inlet'!J42","v":46.209995516288693}]
[{"$f":"'DROP Inlet'!D43","v":""},{"$f":"'DROP Inlet'!F43","v":""},{"$f":"'DROP Inlet'!G43","v":""},{"$f":"'DROP Inlet'!H43","v":""},{"$f":"'DROP Inlet'!I43","v":""},{"$f":"'DROP Inlet'!J43","v":""}]
[{"$f":"'DROP Inlet'!D44","v":""},{"$f":"'DROP Inlet'!F44","v":""},{"$f":"'DROP Inlet'!G44","v":""},{"$f":"'DROP Inlet'!H44","v":""},{"$f":"'DROP Inlet'!I44","v":""},{"$f":"'DROP Inlet'!J44","v":""}]
[{"$f":"'DROP Inlet'!D45","v":""},{"$f":"'DROP Inlet'!F45","v":""},{"$f":"'DROP Inlet'!G45","v":""},{"$f":"'DROP Inlet'!H45","v":""},{"$f":"'DROP Inlet'!I45","v":""},{"$f":"'DROP Inlet'!J45","v":""}]
[{"$f":"'DROP Inlet'!D46","v":""},{"$f":"'DROP Inlet'!F46","v":""},{"$f":"'DROP Inlet'!G46","v":""},{"$f":"'DROP Inlet'!H46","v":""},{"$f":"'DROP Inlet'!I46","v":""},{"$f":"'DROP Inlet'!J46","v":""}]
[{"$f":"'DROP Inlet'!D47","v":""},{"$f":"'DROP Inlet'!F47","v":""},{"$f":"'DROP Inlet'!G47","v":""},{"$f":"'DROP Inlet'!H47","v":""},{"$f":"'DROP Inlet'!I47","v":""},{"$f":"'DROP Inlet'!J47","v":""}]
[{"$f":"'DROP Inlet'!D48","v":""},{"$f":"'DROP Inlet'!F48","v":""},{"$f":"'DROP Inlet'!G48","v":""},{"$f":"'DROP Inlet'!H48","v":""},{"$f":"'DROP Inlet'!I48","v":""},{"$f":"'DROP Inlet'!J48","v":""}]
[{"$f":"'DROP Inlet'!D49","v":""},{"$f":"'DROP Inlet'!F49","v":""},{"$f":"'DROP Inlet'!G49","v":""},{"$f":"'DROP Inlet'!H49","v":""},{"$f":"'DROP Inlet'!I49","v":""},{"$f":"'DROP Inlet'!J49","v":""}]
[{"$f":"'DROP Inlet'!D50","v":""},{"$f":"'DROP Inlet'!F50","v":""},{"$f":"'DROP Inlet'!G50","v":""},{"$f":"'DROP Inlet'!H50","v":""},{"$f":"'DROP Inlet'!I50","v":""},{"$f":"'DROP Inlet'!J50","v":""}]
[{"$f":"'DROP Inlet'!D51","v":""},{"$f":"'DROP Inlet'!F51","v":""},{"$f":"'DROP Inlet'!G51","v":""},{"$f":"'DROP Inlet'!H51","v":""},{"$f":"'DROP Inlet'!I51","v":""},{"$f":"'DROP Inlet'!J51","v":""}]
[{"$f":"'DROP Inlet'!D52","v":""},{"$f":"'DROP Inlet'!F52","v":""},{"$f":"'DROP Inlet'!G52","v":""},{"$f":"'DROP Inlet'!H52","v":""},{"$f":"'DROP Inlet'!I52","v":""},{"$f":"'DROP Inlet'!J52","v":""}]
[{"$f":"'DROP Inlet'!D53","v":""},{"$f":"'DROP Inlet'!F53","v":""},{"$f":"'DROP Inlet'!G53","v":""},{"$f":"'DROP Inlet'!H53","v":""},{"$f":"'DROP Inlet'!I53","v":""},{"$f":"'DROP Inlet'!J53","v":""}]
[{"$f":"'DROP Inlet'!D54","v":""},{"$f":"'DROP Inlet'!F54","v":""},{"$f":"'DROP Inlet'!G54","v":""},{"$f":"'DROP Inlet'!H54","v":""},{"$f":"'DROP Inlet'!I54","v":""},{"$f":"'DROP Inlet'!J54","v":""}]
[{"$f":"'DROP Inlet'!D55","v":""},{"$f":"'DROP Inlet'!F55","v":""},{"$f":"'DROP Inlet'!G55","v":""},{"$f":"'DROP Inlet'!H55","v":""},{"$f":"'DROP Inlet'!I55","v":""},{"$f":"'DROP Inlet'!J55","v":""}]
[{"$f":"'DROP Inlet'!D56","v":""},{"$f":"'DROP Inlet'!F56","v":""},{"$f":"'DROP Inlet'!G56","v":""},{"$f":"'DROP Inlet'!H56","v":""},{"$f":"'DROP Inlet'!I56","v":""},{"$f":"'DROP Inlet'!J56","v":""}]
[{"$f":"'DROP Inlet'!D57","v":""},{"$f":"'DROP Inlet'!F57","v":""},{"$f":"'DROP Inlet'!G57","v":""},{"$f":"'DROP Inlet'!H57","v":""},{"$f":"'DROP Inlet'!I57","v":""},{"$f":"'DROP Inlet'!J57","v":""}]
[{"$f":"'DROP Inlet'!D58","v":""},{"$f":"'DROP Inlet'!F58","v":""},{"$f":"'DROP Inlet'!G58","v":""},{"$f":"'DROP Inlet'!H58","v":""},{"$f":"'DROP Inlet'!I58","v":""},{"$f":"'DROP Inlet'!J58","v":""}]
[{"$f":"'DROP Inlet'!D59","v":""},{"$f":"'DROP Inlet'!F59","v":""},{"$f":"'DROP Inlet'!G59","v":""},{"$f":"'DROP Inlet'!H59","v":""},{"$f":"'DROP Inlet'!I59","v":""},{"$f":"'DROP Inlet'!J59","v":""}]
[{"$f":"'DROP Inlet'!D60","v":""},{"$f":"'DROP Inlet'!F60","v":""},{"$f":"'DROP Inlet'!G60","v":""},{"$f":"'DROP Inlet'!H60","v":""},{"$f":"'DROP Inlet'!I60","v":""},{"$f":"'DROP Inlet'!J60","v":""}]
[{"$f":"'DROP Inlet'!D61","v":""},{"$f":"'DROP Inlet'!F61","v":""},{"$f":"'DROP Inlet'!G61","v":""},{"$f":"'DROP Inlet'!H61","v":""},{"$f":"'DROP Inlet'!I61","v":""},{"$f":"'DROP Inlet'!J61","v":""}]
[{"$f":"'DROP Inlet'!D62","v":""},{"$f":"'DROP Inlet'!F62","v":""},{"$f":"'DROP Inlet'!G62","v":""},{"$f":"'DROP Inlet'!H62","v":""},{"$f":"'DROP Inlet'!I62","v":""},{"$f":"'DROP Inlet'!J62","v":""}]
[{"$f":"'DROP Inlet'!D63","v":""},{"$f":"'DROP Inlet'!F63","v":""},{"$f":"'DROP Inlet'!G63","v":""},{"$f":"'DROP Inlet'!H63","v":""},{"$f":"'DROP Inlet'!I63","v":""},{"$f":"'DROP Inlet'!J63","v":""}]
[{"$f":"'DROP Inlet'!D64","v":""},{"$f":"'DROP Inlet'!F64","v":""},{"$f":"'DROP Inlet'!G64","v":""},{"$f":"'DROP Inlet'!H64","v":""},{"$f":"'DROP Inlet'!I64","v":""},{"$f":"'DROP Inlet'!J64","v":""}]
[{"$f":"'DROP Inlet'!D65","v":""},{"$f":"'DROP Inlet'!F65","v":""},{"$f":"'DROP Inlet'!G65","v":""},{"$f":"'DROP Inlet'!H65","v":""},{"$f":"'DROP Inlet'!I65","v":""},{"$f":"'DROP Inlet'!J65","v":""}]
[{"$f":"'DROP Inlet'!D66","v":""},{"$f":"'DROP Inlet'!F66","v":""},{"$f":"'DROP Inlet'!G66","v":""},{"$f":"'DROP Inlet'!H66","v":""},{"$f":"'DROP Inlet'!I66","v":""},{"$f":"'DROP Inlet'!J66","v":""}]
[{"$f":"'DROP Inlet'!D67","v":""},{"$f":"'DROP Inlet'!F67","v":""},{"$f":"'DROP Inlet'!G67","v":""},{"$f":"'DROP Inlet'!H67","v":""},{"$f":"'DROP Inlet'!I67","v":""},{"$f":"'DROP Inlet'!J67","v":""}]
[{"$f":"'DROP Inlet'!D68","v":""},{"$f":"'DROP Inlet'!F68","v":""},{"$f":"'DROP Inlet'!G68","v":""},{"$f":"'DROP Inlet'!H68","v":""},{"$f":"'DROP Inlet'!I68","v":""},{"$f":"'DROP Inlet'!J68","v":""}]
[{"$f":"'DROP Inlet'!D69","v":""},{"$f":"'DROP Inlet'!F69","v":""},{"$f":"'DROP Inlet'!G69","v":""},{"$f":"'DROP Inlet'!H69","v":""},{"$f":"'DROP Inlet'!I69","v":""},{"$f":"'DROP Inlet'!J69","v":""}]
[{"$f":"'DROP Inlet'!D70","v":""},{"$f":"'DROP Inlet'!F70","v":""},{"$f":"'DROP Inlet'!G70","v":""},{"$f":"'DROP Inlet'!H70","v":""},{"$f":"'DROP Inlet'!I70","v":""},{"$f":"'DROP Inlet'!J70","v":""}]
[{"$f":"'DROP Inlet'!D71","v":""},{"$f":"'DROP Inlet'!F71","v":""},{"$f":"'DROP Inlet'!G71","v":""},{"$f":"'DROP Inlet'!H71","v":""},{"$f":"'DROP Inlet'!I71","v":""},{"$f":"'DROP Inlet'!J71","v":""}]
[{"$f":"'DROP Inlet'!D72","v":""},{"$f":"'DROP Inlet'!F72","v":""},{"$f":"'DROP Inlet'!G72","v":""},{"$f":"'DROP Inlet'!H72","v":""},{"$f":"'DROP Inlet'!I72","v":""},{"$f":"'DROP Inlet'!J72","v":""}]
[{"$f":"'DROP Inlet'!D73","v":""},{"$f":"'DROP Inlet'!F73","v":""},{"$f":"'DROP Inlet'!G73","v":""},{"$f":"'DROP Inlet'!H73","v":""},{"$f":"'DROP Inlet'!I73","v":""},{"$f":"'DROP Inlet'!J73","v":""}]
[{"$f":"'DROP Inlet'!D74","v":""},{"$f":"'DROP Inlet'!F74","v":""},{"$f":"'DROP Inlet'!G74","v":""},{"$f":"'DROP Inlet'!H74","v":""},{"$f":"'DROP Inlet'!I74","v":""},{"$f":"'DROP Inlet'!J74","v":""}]
[{"$f":"'DROP Inlet'!D75","v":""},{"$f":"'DROP Inlet'!F75","v":""},{"$f":"'DROP Inlet'!G75","v":""},{"$f":"'DROP Inlet'!H75","v":""},{"$f":"'DROP Inlet'!I75","v":""},{"$f":"'DROP Inlet'!J75","v":""}]
[{"$f":"'DROP Inlet'!D76","v":""},{"$f":"'DROP Inlet'!F76","v":""},{"$f":"'DROP Inlet'!G76","v":""},{"$f":"'DROP Inlet'!H76","v":""},{"$f":"'DROP Inlet'!I76","v":""},{"$f":"'DROP Inlet'!J76","v":""}]
[{"$f":"'DROP Inlet'!D77","v":""},{"$f":"'DROP Inlet'!F77","v":""},{"$f":"'DROP Inlet'!G77","v":""},{"$f":"'DROP Inlet'!H77","v":""},{"$f":"'DROP Inlet'!I77","v":""},{"$f":"'DROP Inlet'!J77","v":""}]
[{"$f":"'DROP Inlet'!D78","v":""},{"$f":"'DROP Inlet'!F78","v":""},{"$f":"'DROP Inlet'!G78","v":""},{"$f":"'DROP Inlet'!H78","v":""},{"$f":"'DROP Inlet'!I78","v":""},{"$f":"'DROP Inlet'!J78","v":""}]
[{"$f":"'DROP Inlet'!D79","v":""},{"$f":"'DROP Inlet'!F79","v":""},{"$f":"'DROP Inlet'!G79","v":""},{"$f":"'DROP Inlet'!H79","v":""},{"$f":"'DROP Inlet'!I79","v":""},{"$f":"'DROP Inlet'!J79","v":""}]
[{"$f":"'DROP Inlet'!D80","v":""},{"$f":"'DROP Inlet'!F80","v":""},{"$f":"'DROP Inlet'!G80","v":""},{"$f":"'DROP Inlet'!H80","v":""},{"$f":"'DROP Inlet'!I80","v":""},{"$f":"'DROP Inlet'!J80","v":""}]
[{"$f":"'DROP Inlet'!D81","v":""},{"$f":"'DROP Inlet'!F81","v":""},{"$f":"'DROP Inlet'!G81","v":""},{"$f":"'DROP Inlet'!H81","v":""},{"$f":"'DROP Inlet'!I81","v":""},{"$f":"'DROP Inlet'!J81","v":""}]
[{"$f":"'DROP Inlet'!D82","v":""},{"$f":"'DROP Inlet'!F82","v":""},{"$f":"'DROP Inlet'!G82","v":""},{"$f":"'DROP Inlet'!H82","v":""},{"$f":"'DROP Inlet'!I82","v":""},{"$f":"'DROP Inlet'!J82","v":""}]
[{"$f":"'DROP Inlet'!D83","v":""},{"$f":"'DROP Inlet'!F83","v":""},{"$f":"'DROP Inlet'!G83","v":""},{"$f":"'DROP Inlet'!H83","v":""},{"$f":"'DROP Inlet'!I83","v":""},{"$f":"'DROP Inlet'!J83","v":""}]
[{"$f":"'DROP Inlet'!D84","v":""},{"$f":"'DROP Inlet'!F84","v":""},{"$f":"'DROP Inlet'!G84","v":""},{"$f":"'DROP Inlet'!H84","v":""},{"$f":"'DROP Inlet'!I84","v":""},{"$f":"'DROP Inlet'!J84","v":""}]
[{"$f":"'DROP Inlet'!D85","v":""},{"$f":"'DROP Inlet'!F85","v":""},{"$f":"'DROP Inlet'!G85","v":""},{"$f":"'DROP Inlet'!H85","v":""},{"$f":"'DROP Inlet'!I85","v":""},{"$f":"'DROP Inlet'!J85","v":""}]
[{"$f":"'DROP Inlet'!D86","v":""},{"$f":"'DROP Inlet'!F86","v":""},{"$f":"'DROP Inlet'!G86","v":""},{"$f":"'DROP Inlet'!H86","v":""},{"$f":"'DROP Inlet'!I86","v":""},{"$f":"'DROP Inlet'!J86","v":""}]
[{"$f":"'DROP Inlet'!D87","v":""},{"$f":"'DROP Inlet'!F87","v":""},{"$f":"'DROP Inlet'!G87","v":""},{"$f":"'DROP Inlet'!H87","v":""},{"$f":"'DROP Inlet'!I87","v":""},{"$f":"'DROP Inlet'!J87","v":""}]
[{"$f":"'DROP Inlet'!D88","v":""},{"$f":"'DROP Inlet'!F88","v":""},{"$f":"'DROP Inlet'!G88","v":""},{"$f":"'DROP Inlet'!H88","v":""},{"$f":"'DROP Inlet'!I88","v":""},{"$f":"'DROP Inlet'!J88","v":""}]
[{"$f":"'DROP Inlet'!D89","v":""},{"$f":"'DROP Inlet'!F89","v":""},{"$f":"'DROP Inlet'!G89","v":""},{"$f":"'DROP Inlet'!H89","v":""},{"$f":"'DROP Inlet'!I89","v":""},{"$f":"'DROP Inlet'!J89","v":""}]
[{"$f":"'DROP Inlet'!D90","v":""},{"$f":"'DROP Inlet'!F90","v":""},{"$f":"'DROP Inlet'!G90","v":""},{"$f":"'DROP Inlet'!H90","v":""},{"$f":"'DROP Inlet'!I90","v":""},{"$f":"'DROP Inlet'!J90","v":""}]
[{"$f":"'DROP Inlet'!D91","v":""},{"$f":"'DROP Inlet'!F91","v":""},{"$f":"'DROP Inlet'!G91","v":""},{"$f":"'DROP Inlet'!H91","v":""},{"$f":"'DROP Inlet'!I91","v":""},{"$f":"'DROP Inlet'!J91","v":""}]
[{"$f":"'DROP Inlet'!D92","v":""},{"$f":"'DROP Inlet'!F92","v":""},{"$f":"'DROP Inlet'!G92","v":""},{"$f":"'DROP Inlet'!H92","v":""},{"$f":"'DROP Inlet'!I92","v":""},{"$f":"'DROP Inlet'!J92","v":""}]
[{"$f":"'DROP Inlet'!D93","v":""},{"$f":"'DROP Inlet'!F93","v":""},{"$f":"'DROP Inlet'!G93","v":""},{"$f":"'DROP Inlet'!H93","v":""},{"$f":"'DROP Inlet'!I93","v":""},{"$f":"'DROP Inlet'!J93","v":""}]
[{"$f":"'DROP Inlet'!D94","v":""},{"$f":"'DROP Inlet'!F94","v":""},{"$f":"'DROP Inlet'!G94","v":""},{"$f":"'DROP Inlet'!H94","v":""},{"$f":"'DROP Inlet'!I94","v":""},{"$f":"'DROP Inlet'!J94","v":""}]
[{"$f":"'DROP Inlet'!D95","v":""},{"$f":"'DROP Inlet'!F95","v":""},{"$f":"'DROP Inlet'!G95","v":""},{"$f":"'DROP Inlet'!H95","v":""},{"$f":"'DROP Inlet'!I95","v":""},{"$f":"'DROP Inlet'!J95","v":""}]
[{"$f":"'DROP Inlet'!D96","v":""},{"$f":"'DROP Inlet'!F96","v":""},{"$f":"'DROP Inlet'!G96","v":""},{"$f":"'DROP Inlet'!H96","v":""},{"$f":"'DROP Inlet'!I96","v":""},{"$f":"'DROP Inlet'!J96","v":""}]
[{"$f":"'DROP Inlet'!D97","v":""},{"$f":"'DROP Inlet'!F97","v":""},{"$f":"'DROP Inlet'!G97","v":""},{"$f":"'DROP Inlet'!H97","v":""},{"$f":"'DROP Inlet'!I97","v":""},{"$f":"'DROP Inlet'!J97","v":""}]
[{"$f":"'DROP Inlet'!D98","v":""},{"$f":"'DROP Inlet'!F98","v":""},{"$f":"'DROP Inlet'!G98","v":""},{"$f":"'DROP Inlet'!H98","v":""},{"$f":"'DROP Inlet'!I98","v":""},{"$f":"'DROP Inlet'!J98","v":""}]
[{"$f":"'DROP Inlet'!D99","v":""},{"$f":"'DROP Inlet'!F99","v":""},{"$f":"'DROP Inlet'!G99","v":""},{"$f":"'DROP Inlet'!H99","v":""},{"$f":"'DROP Inlet'!I99","v":""},{"$f":"'DROP Inlet'!J99","v":""}]
[{"$f":"'DROP Inlet'!D100","v":""},{"$f":"'DROP Inlet'!F100","v":""},{"$f":"'DROP Inlet'!G100","v":""},{"$f":"'DROP Inlet'!H100","v":""},{"$f":"'DROP Inlet'!I100","v":""},{"$f":"'DROP Inlet'!J100","v":""}]
[{"$f":"'DROP Inlet'!D101","v":""},{"$f":"'DROP Inlet'!F101","v":""},{"$f":"'DROP Inlet'!G101","v":""},{"$f":"'DROP Inlet'!H101","v":""},{"$f":"'DROP Inlet'!I101","v":""},{"$f":"'DROP Inlet'!J101","v":""}]
[{"$f":"'DROP Inlet'!D102","v":""},{"$f":"'DROP Inlet'!F102","v":""},{"$f":"'DROP Inlet'!G102","v":""},{"$f":"'DROP Inlet'!H102","v":""},{"$f":"'DROP Inlet'!I102","v":""},{"$f":"'DROP Inlet'!J102","v":""}]
[{"$f":"'DROP Inlet'!D103","v":""},{"$f":"'DROP Inlet'!F103","v":""},{"$f":"'DROP Inlet'!G103","v":""},{"$f":"'DROP Inlet'!H103","v":""},{"$f":"'DROP Inlet'!I103","v":""},{"$f":"'DROP Inlet'!J103","v":""}]
[{"$f":"'DROP Inlet'!D104","v":""},{"$f":"'DROP Inlet'!F104","v":""},{"$f":"'DROP Inlet'!G104","v":""},{"$f":"'DROP Inlet'!H104","v":""},{"$f":"'DROP Inlet'!I104","v":""},{"$f":"'DROP Inlet'!J104","v":""}]
[{"$f":"'DROP Inlet'!D105","v":""},{"$f":"'DROP Inlet'!F105","v":""},{"$f":"'DROP Inlet'!G105","v":""},{"$f":"'DROP Inlet'!H105","v":""},{"$f":"'DROP Inlet'!I105","v":""},{"$f":"'DROP Inlet'!J105","v":""}]
[{"$f":"'DROP Inlet'!D106","v":""},{"$f":"'DROP Inlet'!F106","v":""},{"$f":"'DROP Inlet'!G106","v":""},{"$f":"'DROP Inlet'!H106","v":""},{"$f":"'DROP Inlet'!I106","v":""},{"$f":"'DROP Inlet'!J106","v":""}]
[{"$f":"'DROP Inlet'!D107","v":""},{"$f":"'DROP Inlet'!F107","v":""},{"$f":"'DROP Inlet'!G107","v":""},{"$f":"'DROP Inlet'!H107","v":""},{"$f":"'DROP Inlet'!I107","v":""},{"$f":"'DROP Inlet'!J107","v":""}]
[{"$f":"'DROP Inlet'!D108","v":""},{"$f":"'DROP Inlet'!F108","v":""},{"$f":"'DROP Inlet'!G108","v":""},{"$f":"'DROP Inlet'!H108","v":""},{"$f":"'DROP Inlet'!I108","v":""},{"$f":"'DROP Inlet'!J108","v":""}]
[{"$f":"'DROP Inlet'!D109","v":""},{"$f":"'DROP Inlet'!F109","v":""},{"$f":"'DROP Inlet'!G109","v":""},{"$f":"'DROP Inlet'!H109","v":""},{"$f":"'DROP Inlet'!I109","v":""},{"$f":"'DROP Inlet'!J109","v":""}]
[{"$f":"'DROP Inlet'!D110","v":""},{"$f":"'DROP Inlet'!F110","v":""},{"$f":"'DROP Inlet'!G110","v":""},{"$f":"'DROP Inlet'!H110","v":""},{"$f":"'DROP Inlet'!I110","v":""},{"$f":"'DROP Inlet'!J110","v":""}]
[{"$f":"'DROP Inlet'!D111","v":""},{"$f":"'DROP Inlet'!F111","v":""},{"$f":"'DROP Inlet'!G111","v":""},{"$f":"'DROP Inlet'!H111","v":""},{"$f":"'DROP Inlet'!I111","v":""},{"$f":"'DROP Inlet'!J111","v":""}]
[{"$f":"'DROP Inlet'!D112","v":""},{"$f":"'DROP Inlet'!F112","v":""},{"$f":"'DROP Inlet'!G112","v":""},{"$f":"'DROP Inlet'!H112","v":""},{"$f":"'DROP Inlet'!I112","v":""},{"$f":"'DROP Inlet'!J112","v":""}]
[{"$f":"'DROP Inlet'!D113","v":""},{"$f":"'DROP Inlet'!F113","v":""},{"$f":"'DROP Inlet'!G113","v":""},{"$f":"'DROP Inlet'!H113","v":""},{"$f":"'DROP Inlet'!I113","v":""},{"$f":"'DROP Inlet'!J113","v":""}]
[{"$f":"'DROP Inlet'!D114","v":""},{"$f":"'DROP Inlet'!F114","v":""},{"$f":"'DROP Inlet'!G114","v":""},{"$f":"'DROP Inlet'!H114","v":""},{"$f":"'DROP Inlet'!I114","v":""},{"$f":"'DROP Inlet'!J114","v":""}]
[{"$f":"'DROP Inlet'!D115","v":""},{"$f":"'DROP Inlet'!F115","v":""},{"$f":"'DROP Inlet'!G115","v":""},{"$f":"'DROP Inlet'!H115","v":""},{"$f":"'DROP Inlet'!I115","v":""},{"$f":"'DROP Inlet'!J115","v":""}]
[{"$f":"'DROP Inlet'!D116","v":""},{"$f":"'DROP Inlet'!F116","v":""},{"$f":"'DROP Inlet'!G116","v":""},{"$f":"'DROP Inlet'!H116","v":""},{"$f":"'DROP Inlet'!I116","v":""},{"$f":"'DROP Inlet'!J116","v":""}]
[{"$f":"'DROP Inlet'!D117","v":""},{"$f":"'DROP Inlet'!F117","v":""},{"$f":"'DROP Inlet'!G117","v":""},{"$f":"'DROP Inlet'!H117","v":""},{"$f":"'DROP Inlet'!I117","v":""},{"$f":"'DROP Inlet'!J117","v":""}]
[{"$f":"'DROP Inlet'!D118","v":""},{"$f":"'DROP Inlet'!F118","v":""},{"$f":"'DROP Inlet'!G118","v":""},{"$f":"'DROP Inlet'!H118","v":""},{"$f":"'DROP Inlet'!I118","v":""},{"$f":"'DROP Inlet'!J118","v":""}]
[{"$f":"'DROP Inlet'!D119","v":""},{"$f":"'DROP Inlet'!F119","v":""},{"$f":"'DROP Inlet'!G119","v":""},{"$f":"'DROP Inlet'!H119","v":""},{"$f":"'DROP Inlet'!I119","v":""},{"$f":"'DROP Inlet'!J119","v":""}]
[{"$f":"'DROP Inlet'!D120","v":""},{"$f":"'DROP Inlet'!F120","v":""},{"$f":"'DROP Inlet'!G120","v":""},{"$f":"'DROP Inlet'!H120","v":""},{"$f":"'DROP Inlet'!I120","v":""},{"$f":"'DROP Inlet'!J120","v":""}]
[{"$f":"'DROP Inlet'!D121","v":""},{"$f":"'DROP Inlet'!F121","v":""},{"$f":"'DROP Inlet'!G121","v":""},{"$f":"'DROP Inlet'!H121","v":""},{"$f":"'DROP Inlet'!I121","v":""},{"$f":"'DROP Inlet'!J121","v":""}]
[{"$f":"'DROP Inlet'!D122","v":""},{"$f":"'DROP Inlet'!F122","v":""},{"$f":"'DROP Inlet'!G122","v":""},{"$f":"'DROP Inlet'!H122","v":""},{"$f":"'DROP Inlet'!I122","v":""},{"$f":"'DROP Inlet'!J122","v":""}]
[{"$f":"'DROP Inlet'!D123","v":""},{"$f":"'DROP Inlet'!F123","v":""},{"$f":"'DROP Inlet'!G123","v":""},{"$f":"'DROP Inlet'!H123","v":""},{"$f":"'DROP Inlet'!I123","v":""},{"$f":"'DROP Inlet'!J123","v":""}]
[{"$f":"'DROP Inlet'!D124","v":""},{"$f":"'DROP Inlet'!F124","v":""},{"$f":"'DROP Inlet'!G124","v":""},{"$f":"'DROP Inlet'!H124","v":""},{"$f":"'DROP Inlet'!I124","v":""},{"$f":"'DROP Inlet'!J124","v":""}]
[{"$f":"'DROP Inlet'!D125","v":""},{"$f":"'DROP Inlet'!F125","v":""},{"$f":"'DROP Inlet'!G125","v":""},{"$f":"'DROP Inlet'!H125","v":""},{"$f":"'DROP Inlet'!I125","v":""},{"$f":"'DROP Inlet'!J125","v":""}]
[{"$f":"'DROP Inlet'!D126","v":""},{"$f":"'DROP Inlet'!F126","v":""},{"$f":"'DROP Inlet'!G126","v":""},{"$f":"'DROP Inlet'!H126","v":""},{"$f":"'DROP Inlet'!I126","v":""},{"$f":"'DROP Inlet'!J126","v":""}]
[{"$f":"'DROP Inlet'!D127","v":""},{"$f":"'DROP Inlet'!F127","v":""},{"$f":"'DROP Inlet'!G127","v":""},{"$f":"'DROP Inlet'!H127","v":""},{"$f":"'DROP Inlet'!I127","v":""},{"$f":"'DROP Inlet'!J127","v":""}]
[{"$f":"'DROP Inlet'!D128","v":""},{"$f":"'DROP Inlet'!F128","v":""},{"$f":"'DROP Inlet'!G128","v":""},{"$f":"'DROP Inlet'!H128","v":""},{"$f":"'DROP Inlet'!I128","v":""},{"$f":"'DROP Inlet'!J128","v":""}]
[{"$f":"'DROP Inlet'!D129","v":""},{"$f":"'DROP Inlet'!F129","v":""},{"$f":"'DROP Inlet'!G129","v":""},{"$f":"'DROP Inlet'!H129","v":""},{"$f":"'DROP Inlet'!I129","v":""},{"$f":"'DROP Inlet'!J129","v":""}]
[{"$f":"'DROP Inlet'!D130","v":""},{"$f":"'DROP Inlet'!F130","v":""},{"$f":"'DROP Inlet'!G130","v":""},{"$f":"'DROP Inlet'!H130","v":""},{"$f":"'DROP Inlet'!I130","v":""},{"$f":"'DROP Inlet'!J130","v":""}]
[{"$f":"'DROP Inlet'!D131","v":""},{"$f":"'DROP Inlet'!F131","v":""},{"$f":"'DROP Inlet'!G131","v":""},{"$f":"'DROP Inlet'!H131","v":""},{"$f":"'DROP Inlet'!I131","v":""},{"$f":"'DROP Inlet'!J131","v":""}]
[{"$f":"'DROP Inlet'!D132","v":""},{"$f":"'DROP Inlet'!F132","v":""},{"$f":"'DROP Inlet'!G132","v":""},{"$f":"'DROP Inlet'!H132","v":""},{"$f":"'DROP Inlet'!I132","v":""},{"$f":"'DROP Inlet'!J132","v":""}]
[{"$f":"'DROP Inlet'!D133","v":""},{"$f":"'DROP Inlet'!F133","v":""},{"$f":"'DROP Inlet'!G133","v":""},{"$f":"'DROP Inlet'!H133","v":""},{"$f":"'DROP Inlet'!I133","v":""},{"$f":"'DROP Inlet'!J133","v":""}]
[{"$f":"'DROP Inlet'!D134","v":""},{"$f":"'DROP Inlet'!F134","v":""},{"$f":"'DROP Inlet'!G134","v":""},{"$f":"'DROP Inlet'!H134","v":""},{"$f":"'DROP Inlet'!I134","v":""},{"$f":"'DROP Inlet'!J134","v":""}]
[{"$f":"'DROP Inlet'!D135","v":""},{"$f":"'DROP Inlet'!F135","v":""},{"$f":"'DROP Inlet'!G135","v":""},{"$f":"'DROP Inlet'!H135","v":""},{"$f":"'DROP Inlet'!I135","v":""},{"$f":"'DROP Inlet'!J135","v":""}]
[{"$f":"'DROP Inlet'!D136","v":""},{"$f":"'DROP Inlet'!F136","v":""},{"$f":"'DROP Inlet'!G136","v":""},{"$f":"'DROP Inlet'!H136","v":""},{"$f":"'DROP Inlet'!I136","v":""},{"$f":"'DROP Inlet'!J136","v":""}]
[{"$f":"'DROP Inlet'!D137","v":""},{"$f":"'DROP Inlet'!F137","v":""},{"$f":"'DROP Inlet'!G137","v":""},{"$f":"'DROP Inlet'!H137","v":""},{"$f":"'DROP Inlet'!I137","v":""},{"$f":"'DROP Inlet'!J137","v":""}]
[{"$f":"'DROP Inlet'!D138","v":""},{"$f":"'DROP Inlet'!F138","v":""},{"$f":"'DROP Inlet'!G138","v":""},{"$f":"'DROP Inlet'!H138","v":""},{"$f":"'DROP Inlet'!I138","v":""},{"$f":"'DROP Inlet'!J138","v":""}]
[{"$f":"'DROP Inlet'!D139","v":""},{"$f":"'DROP Inlet'!F139","v":""},{"$f":"'DROP Inlet'!G139","v":""},{"$f":"'DROP Inlet'!H139","v":""},{"$f":"'DROP Inlet'!I139","v":""},{"$f":"'DROP Inlet'!J139","v":""}]
[{"$f":"'DROP Inlet'!D140","v":""},{"$f":"'DROP Inlet'!F140","v":""},{"$f":"'DROP Inlet'!G140","v":""},{"$f":"'DROP Inlet'!H140","v":""},{"$f":"'DROP Inlet'!I140","v":""},{"$f":"'DROP Inlet'!J140","v":""}]
[{"$f":"'DROP Inlet'!D141","v":""},{"$f":"'DROP Inlet'!F141","v":""},{"$f":"'DROP Inlet'!G141","v":""},{"$f":"'DROP Inlet'!H141","v":""},{"$f":"'DROP Inlet'!I141","v":""},{"$f":"'DROP Inlet'!J141","v":""}]
[{"$f":"'DROP Inlet'!D142","v":""},{"$f":"'DROP Inlet'!F142","v":""},{"$f":"'DROP Inlet'!G142","v":""},{"$f":"'DROP Inlet'!H142","v":""},{"$f":"'DROP Inlet'!I142","v":""},{"$f":"'DROP Inlet'!J142","v":""}]
[{"$f":"'DROP Inlet'!D143","v":""},{"$f":"'DROP Inlet'!F143","v":""},{"$f":"'DROP Inlet'!G143","v":""},{"$f":"'DROP Inlet'!H143","v":""},{"$f":"'DROP Inlet'!I143","v":""},{"$f":"'DROP Inlet'!J143","v":""}]
[{"$f":"'DROP Inlet'!D144","v":""},{"$f":"'DROP Inlet'!F144","v":""},{"$f":"'DROP Inlet'!G144","v":""},{"$f":"'DROP Inlet'!H144","v":""},{"$f":"'DROP Inlet'!I144","v":""},{"$f":"'DROP Inlet'!J144","v":""}]
[{"$f":"'DROP Inlet'!D145","v":""},{"$f":"'DROP Inlet'!F145","v":""},{"$f":"'DROP Inlet'!G145","v":""},{"$f":"'DROP Inlet'!H145","v":""},{"$f":"'DROP Inlet'!I145","v":""},{"$f":"'DROP Inlet'!J145","v":""}]
[{"$f":"'DROP Inlet'!D146","v":""},{"$f":"'DROP Inlet'!F146","v":""},{"$f":"'DROP Inlet'!G146","v":""},{"$f":"'DROP Inlet'!H146","v":""},{"$f":"'DROP Inlet'!I146","v":""},{"$f":"'DROP Inlet'!J146","v":""}]
[{"$f":"'DROP Inlet'!D147","v":""},{"$f":"'DROP Inlet'!F147","v":""},{"$f":"'DROP Inlet'!G147","v":""},{"$f":"'DROP Inlet'!H147","v":""},{"$f":"'DROP Inlet'!I147","v":""},{"$f":"'DROP Inlet'!J147","v":""}]
[{"$f":"'DROP Inlet'!D148","v":""},{"$f":"'DROP Inlet'!F148","v":""},{"$f":"'DROP Inlet'!G148","v":""},{"$f":"'DROP Inlet'!H148","v":""},{"$f":"'DROP Inlet'!I148","v":""},{"$f":"'DROP Inlet'!J148","v":""}]
[{"$f":"'DROP Inlet'!D149","v":""},{"$f":"'DROP Inlet'!F149","v":""},{"$f":"'DROP Inlet'!G149","v":""},{"$f":"'DROP Inlet'!H149","v":""},{"$f":"'DROP Inlet'!I149","v":""},{"$f":"'DROP Inlet'!J149","v":""}]
[{"$f":"'DROP Inlet'!D150","v":""},{"$f":"'DROP Inlet'!F150","v":""},{"$f":"'DROP Inlet'!G150","v":""},{"$f":"'DROP Inlet'!H150","v":""},{"$f":"'DROP Inlet'!I150","v":""},{"$f":"'DROP Inlet'!J150","v":""}]
[{"$f":"'DROP Inlet'!D151","v":""},{"$f":"'DROP Inlet'!F151","v":""},{"$f":"'DROP Inlet'!G151","v":""},{"$f":"'DROP Inlet'!H151","v":""},{"$f":"'DROP Inlet'!I151","v":""},{"$f":"'DROP Inlet'!J151","v":""}]
[{"$f":"'DROP Inlet'!D152","v":""},{"$f":"'DROP Inlet'!F152","v":""},{"$f":"'DROP Inlet'!G152","v":""},{"$f":"'DROP Inlet'!H152","v":""},{"$f":"'DROP Inlet'!I152","v":""},{"$f":"'DROP Inlet'!J152","v":""}]
[{"$f":"'DROP Inlet'!D153","v":""},{"$f":"'DROP Inlet'!F153","v":""},{"$f":"'DROP Inlet'!G153","v":""},{"$f":"'DROP Inlet'!H153","v":""},{"$f":"'DROP Inlet'!I153","v":""},{"$f":"'DROP Inlet'!J153","v":""}]
[{"$f":"'DROP Inlet'!D154","v":""},{"$f":"'DROP Inlet'!F154","v":""},{"$f":"'DROP Inlet'!G154","v":""},{"$f":"'DROP Inlet'!H154","v":""},{"$f":"'DROP Inlet'!I154","v":""},{"$f":"'DROP Inlet'!J154","v":""}]
[{"$f":"'DROP Inlet'!D155","v":""},{"$f":"'DROP Inlet'!F155","v":""},{"$f":"'DROP Inlet'!G155","v":""},{"$f":"'DROP Inlet'!H155","v":""},{"$f":"'DROP Inlet'!I155","v":""},{"$f":"'DROP Inlet'!J155","v":""}]
[{"$f":"'DROP Inlet'!D156","v":""},{"$f":"'DROP Inlet'!F156","v":""},{"$f":"'DROP Inlet'!G156","v":""},{"$f":"'DROP Inlet'!H156","v":""},{"$f":"'DROP Inlet'!I156","v":""},{"$f":"'DROP Inlet'!J156","v":""}]
[{"$f":"'DROP Inlet'!D157","v":""},{"$f":"'DROP Inlet'!F157","v":""},{"$f":"'DROP Inlet'!G157","v":""},{"$f":"'DROP Inlet'!H157","v":""},{"$f":"'DROP Inlet'!I157","v":""},{"$f":"'DROP Inlet'!J157","v":""}]
[{"$f":"'DROP Inlet'!D158","v":""},{"$f":"'DROP Inlet'!F158","v":""},{"$f":"'DROP Inlet'!G158","v":""},{"$f":"'DROP Inlet'!H158","v":""},{"$f":"'DROP Inlet'!I158","v":""},{"$f":"'DROP Inlet'!J158","v":""}]
[{"$f":"'DROP Inlet'!D159","v":""},{"$f":"'DROP Inlet'!F159","v":""},{"$f":"'DROP Inlet'!G159","v":""},{"$f":"'DROP Inlet'!H159","v":""},{"$f":"'DROP Inlet'!I159","v":""},{"$f":"'DROP Inlet'!J159","v":""}]
[{"$f":"'DROP Inlet'!D160","v":""},{"$f":"'DROP Inlet'!F160","v":""},{"$f":"'DROP Inlet'!G160","v":""},{"$f":"'DROP Inlet'!H160","v":""},{"$f":"'DROP Inlet'!I160","v":""},{"$f":"'DROP Inlet'!J160","v":""}]
[{"$f":"'DROP Inlet'!D161","v":""},{"$f":"'DROP Inlet'!F161","v":""},{"$f":"'DROP Inlet'!G161","v":""},{"$f":"'DROP Inlet'!H161","v":""},{"$f":"'DROP Inlet'!I161","v":""},{"$f":"'DROP Inlet'!J161","v":""}]
[{"$f":"'DROP Inlet'!D162","v":""},{"$f":"'DROP Inlet'!F162","v":""},{"$f":"'DROP Inlet'!G162","v":""},{"$f":"'DROP Inlet'!H162","v":""},{"$f":"'DROP Inlet'!I162","v":""},{"$f":"'DROP Inlet'!J162","v":""}]
[{"$f":"'DROP Inlet'!D163","v":""},{"$f":"'DROP Inlet'!F163","v":""},{"$f":"'DROP Inlet'!G163","v":""},{"$f":"'DROP Inlet'!H163","v":""},{"$f":"'DROP Inlet'!I163","v":""},{"$f":"'DROP Inlet'!J163","v":""}]
[{"$f":"'DROP Inlet'!D164","v":""},{"$f":"'DROP Inlet'!F164","v":""},{"$f":"'DROP Inlet'!G164","v":""},{"$f":"'DROP Inlet'!H164","v":""},{"$f":"'DROP Inlet'!I164","v":""},{"$f":"'DROP Inlet'!J164","v":""}]
[{"$f":"'DROP Inlet'!D165","v":""},{"$f":"'DROP Inlet'!F165","v":""},{"$f":"'DROP Inlet'!G165","v":""},{"$f":"'DROP Inlet'!H165","v":""},{"$f":"'DROP Inlet'!I165","v":""},{"$f":"'DROP Inlet'!J165","v":""}]
[{"$f":"'DROP Inlet'!D166","v":""},{"$f":"'DROP Inlet'!F166","v":""},{"$f":"'DROP Inlet'!G166","v":""},{"$f":"'DROP Inlet'!H166","v":""},{"$f":"'DROP Inlet'!I166","v":""},{"$f":"'DROP Inlet'!J166","v":""}]
[{"$f":"'DROP Inlet'!D167","v":""},{"$f":"'DROP Inlet'!F167","v":""},{"$f":"'DROP Inlet'!G167","v":""},{"$f":"'DROP Inlet'!H167","v":""},{"$f":"'DROP Inlet'!I167","v":""},{"$f":"'DROP Inlet'!J167","v":""}]
[{"$f":"'DROP Inlet'!D168","v":""},{"$f":"'DROP Inlet'!F168","v":""},{"$f":"'DROP Inlet'!G168","v":""},{"$f":"'DROP Inlet'!H168","v":""},{"$f":"'DROP Inlet'!I168","v":""},{"$f":"'DROP Inlet'!J168","v":""}]
[{"$f":"'DROP Inlet'!D169","v":""},{"$f":"'DROP Inlet'!F169","v":""},{"$f":"'DROP Inlet'!G169","v":""},{"$f":"'DROP Inlet'!H169","v":""},{"$f":"'DROP Inlet'!I169","v":""},{"$f":"'DROP Inlet'!J169","v":""}]
[{"$f":"'DROP Inlet'!D170","v":""},{"$f":"'DROP Inlet'!F170","v":""},{"$f":"'DROP Inlet'!G170","v":""},{"$f":"'DROP Inlet'!H170","v":""},{"$f":"'DROP Inlet'!I170","v":""},{"$f":"'DROP Inlet'!J170","v":""}]
[{"$f":"'DROP Inlet'!D171","v":""},{"$f":"'DROP Inlet'!F171","v":""},{"$f":"'DROP Inlet'!G171","v":""},{"$f":"'DROP Inlet'!H171","v":""},{"$f":"'DROP Inlet'!I171","v":""},{"$f":"'DROP Inlet'!J171","v":""}]
[{"$f":"'DROP Inlet'!D172","v":""},{"$f":"'DROP Inlet'!F172","v":""},{"$f":"'DROP Inlet'!G172","v":""},{"$f":"'DROP Inlet'!H172","v":""},{"$f":"'DROP Inlet'!I172","v":""},{"$f":"'DROP Inlet'!J172","v":""}]
[{"$f":"'DROP Inlet'!D173","v":""},{"$f":"'DROP Inlet'!F173","v":""},{"$f":"'DROP Inlet'!G173","v":""},{"$f":"'DROP Inlet'!H173","v":""},{"$f":"'DROP Inlet'!I173","v":""},{"$f":"'DROP Inlet'!J173","v":""}]
[{"$f":"'DROP Inlet'!D174","v":""},{"$f":"'DROP Inlet'!F174","v":""},{"$f":"'DROP Inlet'!G174","v":""},{"$f":"'DROP Inlet'!H174","v":""},{"$f":"'DROP Inlet'!I174","v":""},{"$f":"'DROP Inlet'!J174","v":""}]
[{"$f":"'DROP Inlet'!D175","v":""},{"$f":"'DROP Inlet'!F175","v":""},{"$f":"'DROP Inlet'!G175","v":""},{"$f":"'DROP Inlet'!H175","v":""},{"$f":"'DROP Inlet'!I175","v":""},{"$f":"'DROP Inlet'!J175","v":""}]
[{"$f":"'DROP Inlet'!D176","v":""},{"$f":"'DROP Inlet'!F176","v":""},{"$f":"'DROP Inlet'!G176","v":""},{"$f":"'DROP Inlet'!H176","v":""},{"$f":"'DROP Inlet'!I176","v":""},{"$f":"'DROP Inlet'!J176","v":""}]
[{"$f":"'DROP Inlet'!D177","v":""},{"$f":"'DROP Inlet'!F177","v":""},{"$f":"'DROP Inlet'!G177","v":""},{"$f":"'DROP Inlet'!H177","v":""},{"$f":"'DROP Inlet'!I177","v":""},{"$f":"'DROP Inlet'!J177","v":""}]
[{"$f":"'DROP Inlet'!D178","v":""},{"$f":"'DROP Inlet'!F178","v":""},{"$f":"'DROP Inlet'!G178","v":""},{"$f":"'DROP Inlet'!H178","v":""},{"$f":"'DROP Inlet'!I178","v":""},{"$f":"'DROP Inlet'!J178","v":""}]
[{"$f":"'DROP Inlet'!D179","v":""},{"$f":"'DROP Inlet'!F179","v":""},{"$f":"'DROP Inlet'!G179","v":""},{"$f":"'DROP Inlet'!H179","v":""},{"$f":"'DROP Inlet'!I179","v":""},{"$f":"'DROP Inlet'!J179","v":""}]
[{"$f":"'DROP Inlet'!D180","v":""},{"$f":"'DROP Inlet'!F180","v":""},{"$f":"'DROP Inlet'!G180","v":""},{"$f":"'DROP Inlet'!H180","v":""},{"$f":"'DROP Inlet'!I180","v":""},{"$f":"'DROP Inlet'!J180","v":""}]
[{"$f":"'DROP Inlet'!D181","v":""},{"$f":"'DROP Inlet'!F181","v":""},{"$f":"'DROP Inlet'!G181","v":""},{"$f":"'DROP Inlet'!H181","v":""},{"$f":"'DROP Inlet'!I181","v":""},{"$f":"'DROP Inlet'!J181","v":""}]
[{"$f":"'DROP Inlet'!D182","v":""},{"$f":"'DROP Inlet'!F182","v":""},{"$f":"'DROP Inlet'!G182","v":""},{"$f":"'DROP Inlet'!H182","v":""},{"$f":"'DROP Inlet'!I182","v":""},{"$f":"'DROP Inlet'!J182","v":""}]
[{"$f":"'DROP Inlet'!D183","v":""},{"$f":"'DROP Inlet'!F183","v":""},{"$f":"'DROP Inlet'!G183","v":""},{"$f":"'DROP Inlet'!H183","v":""},{"$f":"'DROP Inlet'!I183","v":""},{"$f":"'DROP Inlet'!J183","v":""}]
[{"$f":"'DROP Inlet'!D184","v":""},{"$f":"'DROP Inlet'!F184","v":""},{"$f":"'DROP Inlet'!G184","v":""},{"$f":"'DROP Inlet'!H184","v":""},{"$f":"'DROP Inlet'!I184","v":""},{"$f":"'DROP Inlet'!J184","v":""}]
[{"$f":"'DROP Inlet'!D185","v":""},{"$f":"'DROP Inlet'!F185","v":""},{"$f":"'DROP Inlet'!G185","v":""},{"$f":"'DROP Inlet'!H185","v":""},{"$f":"'DROP Inlet'!I185","v":""},{"$f":"'DROP Inlet'!J185","v":""}]
[{"$f":"'DROP Inlet'!D186","v":""},{"$f":"'DROP Inlet'!F186","v":""},{"$f":"'DROP Inlet'!G186","v":""},{"$f":"'DROP Inlet'!H186","v":""},{"$f":"'DROP Inlet'!I186","v":""},{"$f":"'DROP Inlet'!J186","v":""}]
[{"$f":"'DROP Inlet'!D187","v":""},{"$f":"'DROP Inlet'!F187","v":""},{"$f":"'DROP Inlet'!G187","v":""},{"$f":"'DROP Inlet'!H187","v":""},{"$f":"'DROP Inlet'!I187","v":""},{"$f":"'DROP Inlet'!J187","v":""}]
[{"$f":"'DROP Inlet'!D188","v":""},{"$f":"'DROP Inlet'!F188","v":""},{"$f":"'DROP Inlet'!G188","v":""},{"$f":"'DROP Inlet'!H188","v":""},{"$f":"'DROP Inlet'!I188","v":""},{"$f":"'DROP Inlet'!J188","v":""}]
[{"$f":"'DROP Inlet'!D189","v":""},{"$f":"'DROP Inlet'!F189","v":""},{"$f":"'DROP Inlet'!G189","v":""},{"$f":"'DROP Inlet'!H189","v":""},{"$f":"'DROP Inlet'!I189","v":""},{"$f":"'DROP Inlet'!J189","v":""}]
[{"$f":"'DROP Inlet'!D190","v":""},{"$f":"'DROP Inlet'!F190","v":""},{"$f":"'DROP Inlet'!G190","v":""},{"$f":"'DROP Inlet'!H190","v":""},{"$f":"'DROP Inlet'!I190","v":""},{"$f":"'DROP Inlet'!J190","v":""}]
[{"$f":"'DROP Inlet'!D191","v":""},{"$f":"'DROP Inlet'!F191","v":""},{"$f":"'DROP Inlet'!G191","v":""},{"$f":"'DROP Inlet'!H191","v":""},{"$f":"'DROP Inlet'!I191","v":""},{"$f":"'DROP Inlet'!J191","v":""}]
[{"$f":"'DROP Inlet'!D192","v":""},{"$f":"'DROP Inlet'!F192","v":""},{"$f":"'DROP Inlet'!G192","v":""},{"$f":"'DROP Inlet'!H192","v":""},{"$f":"'DROP Inlet'!I192","v":""},{"$f":"'DROP Inlet'!J192","v":""}]
[{"$f":"'DROP Inlet'!D193","v":""},{"$f":"'DROP Inlet'!F193","v":""},{"$f":"'DROP Inlet'!G193","v":""},{"$f":"'DROP Inlet'!H193","v":""},{"$f":"'DROP Inlet'!I193","v":""},{"$f":"'DROP Inlet'!J193","v":""}]
[{"$f":"'DROP Inlet'!D194","v":""},{"$f":"'DROP Inlet'!F194","v":""},{"$f":"'DROP Inlet'!G194","v":""},{"$f":"'DROP Inlet'!H194","v":""},{"$f":"'DROP Inlet'!I194","v":""},{"$f":"'DROP Inlet'!J194","v":""}]
[{"$f":"'DROP Inlet'!D195","v":""},{"$f":"'DROP Inlet'!F195","v":""},{"$f":"'DROP Inlet'!G195","v":""},{"$f":"'DROP Inlet'!H195","v":""},{"$f":"'DROP Inlet'!I195","v":""},{"$f":"'DROP Inlet'!J195","v":""}]
[{"$f":"'DROP Inlet'!D196","v":""},{"$f":"'DROP Inlet'!F196","v":""},{"$f":"'DROP Inlet'!G196","v":""},{"$f":"'DROP Inlet'!H196","v":""},{"$f":"'DROP Inlet'!I196","v":""},{"$f":"'DROP Inlet'!J196","v":""}]
[{"$f":"'DROP Inlet'!D197","v":""},{"$f":"'DROP Inlet'!F197","v":""},{"$f":"'DROP Inlet'!G197","v":""},{"$f":"'DROP Inlet'!H197","v":""},{"$f":"'DROP Inlet'!I197","v":""},{"$f":"'DROP Inlet'!J197","v":""}]
[{"$f":"'DROP Inlet'!D198","v":""},{"$f":"'DROP Inlet'!F198","v":""},{"$f":"'DROP Inlet'!G198","v":""},{"$f":"'DROP Inlet'!H198","v":""},{"$f":"'DROP Inlet'!I198","v":""},{"$f":"'DROP Inlet'!J198","v":""}]
[{"$f":"'DROP Inlet'!D199","v":""},{"$f":"'DROP Inlet'!F199","v":""},{"$f":"'DROP Inlet'!G199","v":""},{"$f":"'DROP Inlet'!H199","v":""},{"$f":"'DROP Inlet'!I199","v":""},{"$f":"'DROP Inlet'!J199","v":""}]
[{"$f":"'DROP Inlet'!D200","v":""},{"$f":"'DROP Inlet'!F200","v":""},{"$f":"'DROP Inlet'!G200","v":""},{"$f":"'DROP Inlet'!H200","v":""},{"$f":"'DROP Inlet'!I200","v":""},{"$f":"'DROP Inlet'!J200","v":""}]
[{"$f":"'DROP Inlet'!D201","v":""},{"$f":"'DROP Inlet'!F201","v":""},{"$f":"'DROP Inlet'!G201","v":""},{"$f":"'DROP Inlet'!H201","v":""},{"$f":"'DROP Inlet'!I201","v":""},{"$f":"'DROP Inlet'!J201","v":""}]
[{"$f":"'DROP Inlet'!D202","v":""},{"$f":"'DROP Inlet'!F202","v":""},{"$f":"'DROP Inlet'!G202","v":""},{"$f":"'DROP Inlet'!H202","v":""},{"$f":"'DROP Inlet'!I202","v":""},{"$f":"'DROP Inlet'!J202","v":""}]
[{"$f":"'DROP Inlet'!D203","v":""},{"$f":"'DROP Inlet'!F203","v":""},{"$f":"'DROP Inlet'!G203","v":""},{"$f":"'DROP Inlet'!H203","v":""},{"$f":"'DROP Inlet'!I203","v":""},{"$f":"'DROP Inlet'!J203","v":""}]
[{"$f":"'DROP Inlet'!D204","v":""},{"$f":"'DROP Inlet'!F204","v":""},{"$f":"'DROP Inlet'!G204","v":""},{"$f":"'DROP Inlet'!H204","v":""},{"$f":"'DROP Inlet'!I204","v":""},{"$f":"'DROP Inlet'!J204","v":""}]
[{"$f":"'DROP Inlet'!D205","v":""},{"$f":"'DROP Inlet'!F205","v":""},{"$f":"'DROP Inlet'!G205","v":""},{"$f":"'DROP Inlet'!H205","v":""},{"$f":"'DROP Inlet'!I205","v":""},{"$f":"'DROP Inlet'!J205","v":""}]

{"sheet":"Pipe Length","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"'DROP Inlet'!L1","v":"IaDropInlet.xls Ver 1.10"}]
[null,"Calculate the Pipe Length"]
[]
["Project Name: ",{"$f":"IF('DROP Inlet'!B1=\"\",\"\",'DROP Inlet'!B1)","v":""}]
["Computed by: ",{"$f":"IF('DROP Inlet'!B2:C2=\"\",\"\",'DROP Inlet'!B2:C2)","v":""}]
["Date: ",{"$f":"IF('DROP Inlet'!B3:C3=\"\",\"\",'DROP Inlet'!B3:C3)","v":""}]
["Checked by: "]
["Date: "]
["Basic Pipe Elevations"]
["Principal Spillway Crest Elev (ft)",null,105]
["Invert of Barrel Elevation (ft)",null,96]
["Elbow Elev (if None, Leave 'BLANK')"]
["Length of Outlet ('BLANK' if none)"]
["Outlet Elevation (ft)",null,86]
[]
["Basic Embankment Elevations"]
["Constructed Top of Fill Elev (ft)",null,111]
["Embankment Top Width",null,12]
["Frontslope (H/V)",null,3]
["Backslope (H/V)",null,3]
["Downstream Toe Elev (ft)",null,85]
["Length of Pipe Past Downstream Toe (ft)",null,3]
[null,null,null,null,null,{"$f":"IF(OR(pscrest<binvert,binvert<elb,binvert<outelev,IF(OR(elb=\"\",lenout=\"\"),FALSE,elb<outelev),tof<pscrest,outelev<toe),\"Check your inputs\",\"OK\")","v":"OK"}]
["Calculated Pipe Length"]
["Pipe Length (ft)",null,{"$f":"IF(F23=\"OK\",IF(OR(elb=\"\",lenout=\"\"),ROUND(((binvert-outelev)^2+(overh+tw+(tof-pscrest)*fs+(tof-toe)*bs)^2)^0.5,0),ROUND(((binvert-elb)^2+(overh+tw+(tof-pscrest)*fs+(tof-toe)*bs-lenout)^2)^0.5+lenout,0)),\"\")","v":111}]
[]
[]
[]
["Pipe Profile "]
["Station of CL of Dam",null,1000]
[]
["Pipe Profile for CADD",null,"Sta","Elev"]
["Upstream Top of Riser",null,{"$f":"CL_dam-tw/2-(tof-pscrest)*fs-Riser_Diam/12","v":972.5},{"$f":"pscrest","v":105}]
["Upstream FL of Riser",null,{"$f":"CL_dam-tw/2-(tof-pscrest)*fs-Riser_Diam/12","v":972.5},{"$f":"invert","v":96}]
["Barrel Invert",null,{"$f":"CL_dam-tw/2-(tof-pscrest)*fs","v":976},{"$f":"invert","v":96}]
["Elbow",null,{"$f":"IF(elbow=\"\",\"\",C37-len_outlet)","v":""},{"$f":"IF(elbow=\"\",\"\",elbow)","v":""}]
["Outlet",null,{"$f":"CL_dam+tw/2+(tof-toe)*bs+overh","v":1087},{"$f":"outelev","v":86}]

{"sheet":"CFS chart","index":3,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Project Name:",{"$f":"IF('DROP Inlet'!B1=\"\",\"\",'DROP Inlet'!B1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"'DROP Inlet'!L1","v":"IaDropInlet.xls Ver 1.10"}]
[null,"Computed by:",{"$f":"IF('DROP Inlet'!B2=\"\",\"\",'DROP Inlet'!B2)","v":""}]
[null,"Date:",{"$f":"'Pipe Length'!B6","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"'DROP Inlet'!J2","v":""}]

{"sheet":"Info","index":4,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,4,6],[30,0,30,5],[27,0,27,5],[29,0,29,5],[28,0,28,5]]}
[{"$f":"'DROP Inlet'!L1","v":"IaDropInlet.xls Ver 1.10"}]
["Revised 12/12/2017"]
[]
["Calculates flow capacity of drop inlet pipe structure consisting of a full circular riser and a circular conduit. Limiting flow conditions reviewed are:"]
[]
[null,"Riser weir flow"]
[null,"Inlet orifice flow"]
[null,"Barrel orifice flow"]
[null,"Full pipe flow"]
[]
["Maximum number of elevation intervals displayed is 200."]
[]
["Program support:"]
["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.10"]
["Updates to match computations used in  NRCS Engineering Field Tools software"]
["Weir and Orifice coefficients match EFT values"]
["Tailwater is the outlet elevation + 0.5* the pipe diameter."]
["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."]
[]
[]
["Version 1.02 - December 17, 2002"]
["Added Print button on Drop Inlet tab to automatically determine number of pages to print."]