{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["fig 7-4","Instructions","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"fig 7-4","index":0,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,4,7,4],[6,17,7,17],[6,19,7,19],[7,10,7,11],[6,20,6,21],[2,0,4,0],[2,4,3,4],[2,9,2,12],[2,14,2,22],[3,9,3,12],[3,14,3,22],[4,9,4,12],[6,6,6,8],[4,14,4,22],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,0,5,22],[6,12,6,14],[6,1,7,1],[0,0,0,21],[1,1,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,14],[1,15,1,16],[1,17,1,22]]}
["ON-GRADE INLET CALCULATIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v12a-13"]
["County","Todd",null,null,null,"Item No.",null,"3-8401",null,"Road No.",null,"KY 181",null,null,null,"Road Name"]
[null,"Speed","Lane","W","n","I","Gu.Dp.","Paved Shld.",null," State Project No.",null,null,null,null,"FD04 110 0181 011-013"]
[null,"Limit","Width","(ft)",null,"(iph)","(in)","Width",null,"Federal Project No."]
[null,35,12,2,1.2999999999999999E-2,4,0,0,null,"Emars No.",null,null,null,null,"8486701D"]
[]
["Sag","Station","Inlet","L","C","Area","Slope (ft/ft)",null,null,"LTI","Qt","Qt2","Spread (ft)",null,null,"Qs","di","Eo","Se","E","Flow (cfs)",null,"Allow"]
["Location",null,"Type","(ft)",null,"(ac)","Sl","Sx","Sw","(ft)","(cfs)",null,"T","Tn","Ts","(cfs)","(ft)",null,"(ft/ft)",null,"Qi","Qby","T (ft)"]
[null,"10+25","AB",10,0.7,4.2900000000000001E-2,2.4899999999999998E-4,0.02,{"$f":"H9+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K9^0.42*G9^0.3*(1/($E$5*S9))^0.6","v":1.3094414242775956},0.12011999999999999,{"$f":"IF(M9>$D$5,P9/(1-R9),P9)","v":0.11974571023009509},6.0127702371294243,{"$f":"M9*SQRT(K9/L9)","v":6.0221599785788467},{"$f":"IF(M9>$D$5,M9-$D$5,M9)","v":4.0127702371294243},{"$f":"IF(M9>$D$5,0.56*H9^(5/3)*G9^0.5*O9^(8/3)/$E$5,0.56*I9^(5/3)*G9^0.5*O9^(8/3)/$E$5)","v":4.0729816870500569E-2},{"$f":"M9*H9+$G$5/12","v":0.12025540474258849},{"$f":"IF(M9>$D$5,1/(1+I9/H9/((1+I9/H9/(M9/$D$5-1))^(8/3)-1)),1)","v":0.65986408371342098},{"$f":"H9+(($G$5+VLOOKUP(C9,Data!$A$2:$B$21,2))/12/$D$5)*R9","v":7.4988673642785081E-2},{"$f":"IF(J9>D9,1-(1-(D9/J9))^1.8,1)","v":1},{"$f":"T9*K9","v":0.12011999999999999},{"$f":"K9-U9","v":0},8]
[null,"10+70","BB",10,0.9,0.48032999999999998,5.3255999999999998E-2,0.02,{"$f":"H10+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K10^0.42*G10^0.3*(1/($E$5*S10))^0.6","v":20.036162861598413},1.7291879999999999,{"$f":"IF(M10>$D$5,P10/(1-R10),P10)","v":1.7236878987973934},5.9771256413308986,{"$f":"M10*SQRT(K10/L10)","v":5.9866542261549931},{"$f":"IF(M10>$D$5,M10-$D$5,M10)","v":3.9771256413308986},{"$f":"IF(M10>$D$5,0.56*H10^(5/3)*G10^0.5*O10^(8/3)/$E$5,0.56*I10^(5/3)*G10^0.5*O10^(8/3)/$E$5)","v":0.58165272726634265},{"$f":"M10*H10+$G$5/12","v":0.11954251282661797},0.66255333829740393,{"$f":"H10+(($G$5+VLOOKUP(C10,Data!$A$2:$B$21,2))/12/$D$5)*R10","v":7.5212778191450322E-2},{"$f":"IF(J10>D10,1-(1-(D10/J10))^1.8,1)","v":0.71189176977173774},{"$f":"T10*K10","v":1.2309947055880517},{"$f":"K10-U10","v":0.49819329441194826},8]
[null,"13+00","AB",10,0.9,0.28039999999999998,1.8074E-2,0.02,{"$f":"H11+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K11^0.42*G11^0.3*(1/($E$5*S11))^0.6","v":14.331307223902414},1.5076332944119482,{"$f":"IF(M11>$D$5,P11/(1-R11),P11)","v":1.5053336135016906},6.9571138002918369,{"$f":"M11*SQRT(K11/L11)","v":6.9624259237607298},{"$f":"IF(M11>$D$5,M11-$D$5,M11)","v":4.9571138002918369},{"$f":"IF(M11>$D$5,0.56*H11^(5/3)*G11^0.5*O11^(8/3)/$E$5,0.56*I11^(5/3)*G11^0.5*O11^(8/3)/$E$5)","v":0.60967564170250865},{"$f":"M11*H11+$G$5/12","v":0.13914227600583673},0.59498968452296241,{"$f":"H11+(($G$5+VLOOKUP(C11,Data!$A$2:$B$21,2))/12/$D$5)*R11","v":6.9582473710246867E-2},{"$f":"IF(J11>D11,1-(1-(D11/J11))^1.8,1)","v":0.88396213476317842},{"$f":"T11*K11","v":1.3326907453684291},{"$f":"K11-U11","v":0.17494254904351902},8]
["sag","19+00","AB",10,0.9,0.1333,0,0.02,0.10333333333333333,null,0.65482254904351911,null,3.7978801783766905,null,null,null,0.24262427023420047,0.96901363598815027,0.10333333333333333,null,0.65482254904351911,0,8,"Wd"]
[null,"21+00","AS",10,0.9,0.20269999999999999,9.606E-3,0.02,{"$f":"H13+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K13^0.42*G13^0.3*(1/($E$5*S13))^0.6","v":8.3544481874121139},0.7326662590274694,{"$f":"IF(M13>$D$5,P13/(1-R13),P13)","v":0.73032875672776554},5.9718262852015842,{"$f":"M13*SQRT(K13/L13)","v":5.9813754135275561},{"$f":"IF(M13>$D$5,M13-$D$5,M13)","v":3.9718262852015842},{"$f":"IF(M13>$D$5,0.56*H13^(5/3)*G13^0.5*O13^(8/3)/$E$5,0.56*I13^(5/3)*G13^0.5*O13^(8/3)/$E$5)","v":0.24615383910438787},{"$f":"M13*H13+$G$5/12","v":0.11943652570403168},0.66295474902661788,{"$f":"H13+(($G$5+VLOOKUP(C13,Data!$A$2:$B$21,2))/12/$D$5)*R13","v":7.5246229085551494E-2},{"$f":"IF(J13>D13,1-(1-(D13/J13))^1.8,1)","v":1},{"$f":"T13*K13","v":0.7326662590274694},{"$f":"K13-U13","v":0},8]
[null,"22+30","AS",10,0.9,0.25269999999999998,1.4888E-2,0.02,{"$f":"H14+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K14^0.42*G14^0.3*(1/($E$5*S14))^0.6","v":10.43174300981666},0.90971999999999997,{"$f":"IF(M14>$D$5,P14/(1-R14),P14)","v":0.90680778302495124},5.965899001526088,{"$f":"M14*SQRT(K14/L14)","v":5.9754710772517665},{"$f":"IF(M14>$D$5,M14-$D$5,M14)","v":3.965899001526088},{"$f":"IF(M14>$D$5,0.56*H14^(5/3)*G14^0.5*O14^(8/3)/$E$5,0.56*I14^(5/3)*G14^0.5*O14^(8/3)/$E$5)","v":0.30522767887248914},{"$f":"M14*H14+$G$5/12","v":0.11931798003052176},0.66340421356519097,{"$f":"H14+(($G$5+VLOOKUP(C14,Data!$A$2:$B$21,2))/12/$D$5)*R14","v":7.5283684463765918E-2},{"$f":"IF(J14>D14,1-(1-(D14/J14))^1.8,1)","v":0.99676135621128548},{"$f":"T14*K14","v":0.90677374097253061},{"$f":"K14-U14","v":2.9462590274693667E-3},8]
[null,"24+00","AS",10,0.9,0.1694,6.6530000000000001E-3,0.02,{"$f":"H15+$G$5/12/$D$5","v":0.02},{"$f":"0.6*K15^0.42*G15^0.3*(1/($E$5*S15))^0.6","v":6.9278506017724677},0.60984000000000005,{"$f":"IF(M15>$D$5,P15/(1-R15),P15)","v":0.60789477938797476},5.9722003577100526,{"$f":"M15*SQRT(K15/L15)","v":5.9817480367446816},{"$f":"IF(M15>$D$5,M15-$D$5,M15)","v":3.9722003577100526},{"$f":"IF(M15>$D$5,0.56*H15^(5/3)*G15^0.5*O15^(8/3)/$E$5,0.56*I15^(5/3)*G15^0.5*O15^(8/3)/$E$5)","v":0.20490528136747485},{"$f":"M15*H15+$G$5/12","v":0.11944400715420106},0.66292640056265595,{"$f":"H15+(($G$5+VLOOKUP(C15,Data!$A$2:$B$21,2))/12/$D$5)*R15","v":7.5243866713554666E-2},{"$f":"IF(J15>D15,1-(1-(D15/J15))^1.8,1)","v":1},{"$f":"T15*K15","v":0.60984000000000005},{"$f":"K15-U15","v":0},8]

{"sheet":"Instructions","index":1,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["This spreadsheet calculates the spread of multiple series of on-grade grated or curb box inlets.  Inlets are entered by increasing in station."]
["  A \"sag\" point may be located in order to collect flow from either direction."]
["Grated inlets do not currently provide a blocking factor, as is the case in the previous \"Gratin\" program in KTDID."]
[]
["Blue shaded cells are entered as user supplied values on sheet \"fig-4\".  All other cells are calculated values from formulas or from the macro."]
["Enter all user input values and press “CTRL+r” to execute the macro.  Spreads that exceed the allowable will be shaded red."]
["Change inlet spacing, recalculate the flow area to an inlet and/or change the opening length for curb box inlets and rerun as needed to achieve an allowable spread."]
["A blank line terminates the calculations for an inlet series .  Multiple inlet series may be entered after each blank line between the series. "]
["Heading information may not be reentered for additional series."]
["Two consequtive blank lines will terminate all calculations."]
["One sag inlet per series may be entered but is not required."]
[]
["Inlet spacing is based on a design storm having an intensity of 4 iph."]
["Curb opening lengths and types are checked by the macro.  Valid CBI lengths are 5, 10, 15 and 20 feet.  The CMBBI is only available in a 10 foot length."]
["Precast curb inlets may be available only with a 10 foot opening."]
["CBI, type A has a 2\" depression while type B curb inlets have a 4\" depression.  KYTC policy has been to consider only 2\" as being effective."]
[]
["The macro regenerates the cell formulas and cell formats each time the macro is executed."]
[]
["CURB BOX INLET TYPES:",null,null,null,null,null,null,"DROP BOX INLET TYPES:"]
["  AB = Curb Box Inlet type A with Barrier curb",null,null,null,null,null,null,"  4.12 = 4\" x 12\" bridge deck drain"]
["  AI = Curb Box Inlet type A with Island curb",null,null,null,null,null,null,"  12 = Drop Box Inlet, type 12"]
["  AS = Curb Box Inlet type A with Standard curb",null,null,null,null,null,null,"  13.1 = Drop Box Inlet, type 13 with curved cast vanes"]
["  BB = Curb Box Inlet type B with Barrier curb",null,null,null,null,null,null,"  13.2 = Drop Box Inlet, type 13 with 45° tilted structural steel vanes"]
["  BI = Curb Box Inlet type B with Island curb",null,null,null,null,null,null,"  16.1 = Drop Box Inlet, type 16 with curved cast vanes and slotted pipe"]
["  BS = Curb Box Inlet type B with Standard curb",null,null,null,null,null,null,"  16.2 = Drop Box Inlet, type 16 with 45° tilted structural steel vanes and slotted pipe"]
["  M = Concrete Median Barrier Box Inlet"]
["  U = USer Inlet",null,null,null,null,null,null,"Drop Box Inlets are not recommended in sags."]
["  F1 = Flume Inlet Type 1 (assumed L = 14' with 2:1 emb. slope)",null,null,null,null,null,null,"Slotted pipe is not analyzed as part of DBI type 16."]
["  F2 = Flume Inlet Type 2 (assumed L = 11' with 2:1 emb. slope)",null,null,null,null,null,null,"Slotted pipe shall be analyzed as a curb box inlet of equal length."]
["  One user curb inlet may be added or edited in the appropriate table.",null,null,null,null,null,null,"Up to 4 user grate inlets may be added or edited in the appropriate tables."]
[]
["Column W indicates the type of flow analysis at a sag"]
["  Wd = flow based on weir equation for a depressed inlet"]
["  Wn = flow based on weir equation for a non-depressed inlet"]
["  Or = flow based on orfice equation"]
["  Tr = flow based on calculation of Transition flow between the weir and orifice equations"]
[]
["The spreadsheet results seem to check reasonably with the Visual Urban program for on-grade situations."]
["The results seem to check reasonably with the Visual Urban program for sag situations as long as the flows do not exced the weir flow limits."]
["If the weir flow limits are exceeded the Visual Urban continues to use the weir flow equation while the spreadsheet calculates a transition flow or orifice flow."]

{"sheet":"Data","index":2,"n_rows":55,"n_cols":27,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,22,0,26],[1,22,1,23],[1,24,1,25],[2,24,2,25],[0,9,0,11],[0,12,0,16],[0,17,0,21],[1,12,1,13],[1,14,1,15],[1,17,1,18],[1,19,1,20],[2,19,2,20],[2,14,2,15],[8,7,8,13],[49,0,55,0],[49,15,55,15],[37,0,37,10],[37,11,37,12],[40,4,40,9],[40,10,40,13],[37,13,37,23],[9,7,10,7],[9,12,9,13],[55,1,55,14],[41,3,42,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[8,22,8,26],[9,22,9,23],[9,24,9,25],[10,24,10,25],[37,24,49,24],[38,14,38,20],[39,14,39,15],[39,16,39,18],[39,19,39,20],[40,14,40,15],[40,16,40,18],[40,19,40,20],[40,21,40,23],[45,16,45,19],[46,17,46,18],[49,16,49,23]]}
["Inlet","a (in)","ho (in)","theta(°)","ht (in)","hv (in)",null,null,null,"Splash-over Velocity",null,null,"Curved Vane",null,null,null,null,"45° Tilt Vane",null,null,null,null,"P-1-7/8-4"]
["AB",2,5,53.384,9,{"$f":"C2*SIN(D2*PI()/180)","v":4.0132547324809584},null,null,null,"L = ",{"$f":"I18","v":2},null,"Table Vo ",null,"Curve Fit",null,"Calc.","Table Vo ",null,"Curve Fit",null,"Calc.","Table Vo ",null,"Curve Fit",null,"Calc."]
["AI",2,5.5,34,4,3.0755609690891079,null,null,null,"Vo =",{"$f":"($Z$4*K2^3)+($Z$5*K2^2)+($Z$6*K2)+$Z$7","v":4.6899999999999995},null,"L","Vane","Excel coeff.",null,"Vo","L","Vane","Excel coeff.",null,"Vo","L","Vane","Excel coeff.",null,"Vo"]
["AS",2,4.875,41.841000000000001,6,3.2519455360725877,null,null,null,null,null,null,1,3.84,"c3 =",{"$f":"INDEX(LINEST($N$4:$N$7,$M$4:$M$7^{1,2,3}),1)","v":3.9999999999999564E-2},{"$f":"($P$4*M4^3)+($P$5*M4^2)+($P$6*M4)+$P$7","v":3.84},1,3.32,"c3 =",{"$f":"INDEX(LINEST($S$4:$S$7,$R$4:$R$7^{1,2,3}),1)","v":2.9999999999999371E-2},{"$f":"($U$4*R4^3)+($U$5*R4^2)+($U$6*R4)+$U$7","v":3.3199999999999994},1,2.96,"c3 =",{"$f":"INDEX(LINEST($X$4:$X$7,$W$4:$W$7^{1,2,3}),1)","v":4.999999999999824E-3},{"$f":"($Z$4*W4^3)+($Z$5*W4^2)+($Z$6*W4)+$Z$7","v":2.96}]
["BB",2,5.25,56.661999999999999,9,4.3860760222160762,null,"(formatted cells for macro use)",null,null,null,null,2,5.92,"c2 =",{"$f":"INDEX(LINEST($N$4:$N$7,$M$4:$M$7^{1,2,3}),2)","v":-0.45999999999999647},{"$f":"($P$4*M5^3)+($P$5*M5^2)+($P$6*M5)+$P$7","v":5.919999999999999},2,5.0599999999999996,"c2 =",{"$f":"INDEX(LINEST($S$4:$S$7,$R$4:$R$7^{1,2,3}),2)","v":-0.36499999999999477},{"$f":"($U$4*R5^3)+($U$5*R5^2)+($U$6*R5)+$U$7","v":5.0599999999999987},2,4.6900000000000004,"c2 =",{"$f":"INDEX(LINEST($X$4:$X$7,$W$4:$W$7^{1,2,3}),2)","v":-0.15999999999999862},{"$f":"($Z$4*W5^3)+($Z$5*W5^2)+($Z$6*W5)+$Z$7","v":4.6899999999999995}]
["BI",2,5.25,52.8917,4,4.1868568263035071,null,null,"(do not move)",null,null,null,3,7.56,"c1 =",{"$f":"INDEX(LINEST($N$4:$N$7,$M$4:$M$7^{1,2,3}),3)","v":3.1799999999999917},{"$f":"($P$4*M6^3)+($P$5*M6^2)+($P$6*M6)+$P$7","v":7.5599999999999987},3,6.43,"c1 =",{"$f":"INDEX(LINEST($S$4:$S$7,$R$4:$R$7^{1,2,3}),3)","v":2.6249999999999871},6.43,3,6.16,"c1 =",{"$f":"INDEX(LINEST($X$4:$X$7,$W$4:$W$7^{1,2,3}),3)","v":2.1749999999999967},6.1599999999999993]
["BS",2,5.25,62.667999999999999,6,4.6638949131654179,null,null,null,9,9,null,4,9,"b =",{"$f":"INDEX(LINEST($N$4:$N$7,$M$4:$M$7^{1,2,3}),4)","v":1.0800000000000047},{"$f":"($P$4*M7^3)+($P$5*M7^2)+($P$6*M7)+$P$7","v":9},4,7.61,"b =",{"$f":"INDEX(LINEST($S$4:$S$7,$R$4:$R$7^{1,2,3}),4)","v":1.030000000000008},7.61,4,7.4,"b =",{"$f":"INDEX(LINEST($X$4:$X$7,$W$4:$W$7^{1,2,3}),4)","v":0.94000000000000217},7.3999999999999995]
["F1",2,7.5,63.43,6,7.5]
["F2",2,7.5,63.43,6,7.5,null,"Grate",null,null,null,null,null,null,null,null,null,"Other Grates (not used)",null,null,null,null,"P-1-1/8"]
["M",2.88,4,90,32,4,null,"Type","L","Vo","W","Ag","P (ft); T>=W",null,null,null,null,"Type","L","Vo","W",null,"Table Vo ",null,"Curve Fit",null,"Calc."]
["US",0,4,90,6,4,null,null,"(ft)","(fps)","(ft)","(sq.in)",0,0.5,null,null,null,1,3.2916666666666665,8,2.2708333333333335,null,"L","Vane","Excel coeff.",null,"Vo"]
[4.12,0.5,0,0,6,0,null,4.12,0.95833333333333337,1.43009489836516,{"$f":"(3.75-3/4-0.25)/12","v":0.22916666666666666},{"$f":"(12-2*0.25)*(3.75-0.25)","v":40.25},{"$f":"I12+2*K12","v":1.4166666666666667},{"$f":"I12+K12","v":1.1875}," 4x12 deck drain",null,null,2,4.291666666666667,8,2.2708333333333335,null,1,4.5179999999999998,"c3 =",{"$f":"INDEX(LINEST($X$12:$X$15,$W$12:$W$15^{1,2,3}),1)","v":4.4999999999999242E-2},{"$f":"($Z$12*W12^3)+($Z$13*W12^2)+($Z$14*W12)+$Z$15","v":4.5179999999999989}]
[12,0.5,0,0,6,0,null,12,{"$f":"3*(12+11+7/8)/12","v":5.96875},9.2850877380371308,{"$f":"14/12","v":1.1666666666666667},{"$f":"121*3","v":363},{"$f":"I13+2*K13","v":8.3020833333333339},{"$f":"I13+K13","v":7.135416666666667},"     3 grates",null,null,3,3.0104166666666665,8,2.3125,null,2,6.4619999999999997,"c2 =",{"$f":"INDEX(LINEST($X$12:$X$15,$W$12:$W$15^{1,2,3}),2)","v":-0.50699999999999412},{"$f":"($Z$12*W13^3)+($Z$13*W13^2)+($Z$14*W13)+$Z$15","v":6.461999999999998}]
[13.1,0.5,0,0,6,0,null,13.1,{"$f":"2+5.75/12","v":2.4791666666666665},6.75,{"$f":"(12+5.75)/12","v":1.4791666666666667},413.5,{"$f":"I14+2*K14","v":5.4375},{"$f":"I14+K14","v":3.958333333333333}," curved vane",null,null,4,3.90625,7.8,2.3125,null,3,7.9320000000000004,"c1 =",{"$f":"INDEX(LINEST($X$12:$X$15,$W$12:$W$15^{1,2,3}),3)","v":3.149999999999987},7.9319999999999986]
[13.2,0.5,0,0,6,0,null,13.2,{"$f":"2+4.25/12","v":2.3541666666666665},5.58,1.5,426.6,{"$f":"I15+2*K15","v":5.3541666666666661},{"$f":"I15+K15","v":3.8541666666666665}," 45° tilted vane",null,null,5,3.2916666666666665,10.58,2.958333333333333,null,4,9.1980000000000004,"b =",{"$f":"INDEX(LINEST($X$12:$X$15,$W$12:$W$15^{1,2,3}),4)","v":1.8300000000000065},9.1980000000000004]
[16.100000000000001,0.5,0,0,6,0,null,16.100000000000001,{"$f":"2+5.75/12","v":2.4791666666666665},6.75,{"$f":"(12+5.75)/12","v":1.4791666666666667},413.5,5.4375,3.958333333333333," curved vane",null,null,6,3.0104166666666665,6.6,3.145833333333333]
[16.2,0.5,0,0,6,0,null,16.2,{"$f":"2+4.25/12","v":2.3541666666666665},5.58,1.5,426.6,5.3541666666666661,3.8541666666666665," 45° tilted vane",null,null,7,3.0104166666666665,6.6,2.3125]
[20,0.5,0,0,6,0,"user",20,2,4.6900000000000013,2,576,6,4,"  Visual Urban Vane"]
[20.18,0.5,0,0,6,0,"grate",20.18,2,6.4619999999999997,2,576,{"$f":"I19+2*K19","v":6},{"$f":"I19+K19","v":4},"  P-1-1/8, Vo",null,null,null,null,null,null,"Sample Blocking Calc for Grated Inlets"]
[20.190000000000001,0.5,0,0,6,0,"entry",20.190000000000001,0.628,2.75,1.4690000000000001,0.92200000000000004,4.1929999999999996,3.5649999999999999,"  R-3921-V1",null,"(curved vane)",null,null,null,null,"type 3",null,null,0.5,"WP"]
[20.2,0.5,0,0,6,0,"lines",20.2,1.0209999999999999,3,1.8120000000000001,1.85,5.67,3.8540000000000001,"     R-3922",null,"(tilt vane)",null,null,null,null,"gross","bar","net","blk",0,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",{"$f":"(1+5/12+5/8/12)*2","v":2.9375},{"$f":"20*3/8/12","v":0.625},{"$f":"V22-W22","v":2.3125},{"$f":"V22/2+10*((3/8)/12)","v":1.78125},{"$f":"2*V22+2*V23","v":12.583333333333334},{"$f":"2*V22+V23","v":9.2291666666666679}]
["NOTES:",null,null,null,null,null,null,"3 grates assumed for type 12 unit; Vo assumed",null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"3+4/12+1/4/12","v":3.354166666666667},{"$f":"10*3/8/12","v":0.3125},{"$f":"V23-W23","v":3.041666666666667},{"$f":"V23/2+5*((3/8)/12)","v":1.8333333333333335}]
[20,"User defined inlet",null,null,null,null,null,"Grated lengths and widths do not include frame.",null,null,null,null,null,null,null,null,null,null,null,null,"Area",{"$f":"V23*V22","v":9.8528645833333339},null,{"$f":"X23*X22","v":7.033854166666667},{"$f":"Y23*Y22","v":3.2656250000000004}]
["   CBI = Curb Box Inlet type",null,null,null,null,null,null,"Grated inlet types other than 13 or 16 use splash-over velocities based on P-1-7/8-4 curve.",null,null,null,null,null,null,null,null,null,null,null,null,"% open = ",null,null,{"$f":"X24/$V$24*100","v":71.388925597991289},{"$f":"(1-Y24/V24)*100","v":66.856085634994059}]
["   a = inlet depression (in)"]
["   ho = minimum throat opening (in)"]
["   theta = throat inclination angle as determined from the Standard Drawings (°)"]
["   ht = curb height from gutter flow line to top of curb (no depression) (in)"]
["   hv =  \"Minimum vertical\" is the corresponding vertical depth at the minimum throat opening, ho. (includes depression) (in)"]
[]
["User inlet data may be entered above from cell A18 to cell A21."]
[]
["CMBBI inlet type has a 2.88\" depression as measured from a 4% shoulder cross slope and a 4\" drop from the bottom of the CMBBI over a 28\" gutter width."]
["Cell B8 containing depression, \"a\" would need to be changed for CMBBI to reflect the cross slope if modeled as a user defined inlet.  Calculate a = 28*((4/28) - Sx)"]
["Island curbs are always in weir flow.  (Max. weir flow depth overtops the curb.)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TEST AREA"]
["Sx","Sw","Sl","n",null,"ht",null,null,null,null,null,null,null,null,"TRANSITION"]
[0.02,{"$f":"A40+F44/C44","v":0.10333333333333333},1E-3,1.4999999999999999E-2,null,{"$f":"VLOOKUP(D44,A2:F11,5)/12","v":0.5},null,null,null,null,null,null,null,null,"weir",null,"orifice",null,null,"Interpolated"]
[null,null,null,null,"Inlet Geometry",null,null,null,null,null,"WEIR",null,null,null,"(max)",null,"(min)",null,null,"Values",null,"ORIFICE"]
["Q","L","W","Inlet","a",null,"ho",null,"theta",null,"d1","d2","d","di","hv","Ql","1.4 hv","Qu","dom","d","di","do","d","di"]
["(cfs)","(ft)","(ft)",null,"(in)","(ft)","(in)","(ft)","deg","sine","(ft)","(ft)","(ft)","(ft)","(ft)","(cfs)","(ft)","(cfs)","(ft)","(ft)","(ft)","(ft)","(ft)","(ft)"]
[5.47,5,2,"as",{"$f":"VLOOKUP(D44,A2:B11,2)","v":2},{"$f":"E44/12","v":0.16666666666666666},{"$f":"VLOOKUP(D44,A2:C11,3)","v":4.875},{"$f":"G44/12","v":0.40625},{"$f":"VLOOKUP(D44,A2:D11,4)","v":41.841000000000001},{"$f":"SIN(I44*PI()/180)","v":0.66706575098924881},{"$f":"(A44/(2.3*(B44+1.8*C44)))^(2/3)","v":0.42446383416486111},{"$f":"(A44/(3*B44))^(2/3)","v":0.51042355916464233},{"$f":"IF(B44>12,L44,IF(F44=0,L44,K44))","v":0.42446383416486111},{"$f":"M44+F44","v":0.59113050083152774},{"$f":"H44*J44","v":0.27099546133938235},{"$f":"IF(B44>12,3*B44*O44^1.5,IF(F44=0,3*B44*O44^1.5,2.3*(B44+1.8*C44)*O44^1.5))","v":2.7904183116702166},{"$f":"O44*1.4","v":0.37939364587513524},{"$f":"0.667*H44*B44*(64.4*S44)^0.5","v":5.3695069556847894},{"$f":"0.9*O44","v":0.24389591520544412},{"$f":"U44-F44","v":0.21695066635761737},{"$f":"(A44-P44)/(R44-P44)*0.4*O44+O44","v":0.38361733302428402},{"$f":"(A44/(0.667*H44*B44))^2/64.4","v":0.25311061602876933},{"$f":"X44-F44","v":0.22194168003179385},{"$f":"V44+O44/2","v":0.38860834669846051}]
[]
[5.7,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"di","d",null,"T"]
[null,"Calculation Steps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ft)","type","(ft)","(ft)"]
[null,"1. The appropriate computed \"d\" value based on the two weir flow equation options is selected.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A44<=P44,N44,IF(A44>R44,X44,U44))","v":0.38860834669846051},{"$f":"IF(A44<=P44,IF(F44=0,\"Wn\",\"Wd\"),IF(A44>R44,\"Orif.\",\"Tran\"))","v":"Orif."},{"$f":"IF(A44<=P44,IF(F44=0,L44,K44),IF(A44>R44,W44,T44))","v":0.22194168003179385},{"$f":"IF(S49<F44,S49/B40,S49/A40)","v":11.097084001589693}]
[null,"2.  Maximum weir and minimum orifice flow limits are computed and compared to the design flow."]
[null,"     a.  If the design flow < maximum weir flow, then the weir flow results are selected."]
[null,"     b.  If the design flow > minimum orifice flow, then the orifice flow results are selected."]
[null,"     c.  Otherwise transition depth is computed from hv, between the maximum weir and minimum orifice flows."]
[null,"3.  Depth of flow at inlet is calculated (di = d + a)."]
[null,"4.  Spread is calculated (T = d / Sx).  If d < a, T = d / Sw."]