{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Culvert Analysis","Culvert Data","Culvert Entrance Conditions","Help Information","help for macros","Help for Macros Excel 2010"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":52,"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":"Culvert Analysis","index":0,"n_rows":145,"n_cols":497,"rows_kept":145,"cut":false,"hidden":false,"merged":[[4,1,4,4]]}
["Culvert Analysis Spreadsheet",null,null,null,null,null,"IaCulvertDesign.xlsm V1.0"]
[]
["Client:",null,null,"County:",null,"Date:  "]
["Design By:",null,null,"Checked By:",null,"Date:  "]
["Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Inputs:"]
[null,"Headwater (Upstream Water Surface) Elevation:  ",null," Feet"]
[null,"Culvert Inlet Invert Elevation:  ",null," Feet"]
[null,"Culvert Diameter:   ",null," Inches","Select Culvert Material:  ","CMP_2.67x0.5"]
[null,"Length of Culvert:  ",null," Feet","Select Culvert Inlet Type:  ","Projecting - Thin Edge"]
[null,"Culvert Outlet Invert Elevation:  ",null," Feet",null,{"$f":"IF(ISNUMBER(IFERROR(B42,\"Select an Inlet Type\")),\"\",IFERROR(B42,\"Select an Inlet Type\"))","v":""}]
[null,"Tailwater (Downstream) Elevation:  ",null," Feet"]
[]
[]
[]
[]
["Outputs:"]
[null,"CAPACITY = ",{"$f":"IF(C140=\"FALSE\",\"\",B124)","v":""},"cfs",{"$f":"IF(C140=\"FALSE\",\"MUST Select Compute Button to Re-Calculate\",A123)","v":"MUST Select Compute Button to Re-Calculate"}]
[]
[null,null,"Manning's n value:  ",{"$f":"VLOOKUP(F17,'Culvert Data'!A3:B9,2,FALSE)","v":2.4E-2},{"$f":"F17","v":"CMP_2.67x0.5"}]
[null,null,"Entrance Coefficient, Ke:  ",{"$f":"VLOOKUP(F18,'Culvert Data'!A15:B20,2,FALSE)","v":0.9},{"$f":"F18","v":"Projecting - Thin Edge"}]
[]
[]
[{"$f":"IF(C140=\"FALSE\",\"\",\"Scroll Down to View Computations\")","v":""}]
[]
[]
["Calculations:"]
[]
["Headwater (HW)"]
["HW Depth = ",{"$f":"C15-C16","v":0},"feet",{"$f":"B38*12","v":0},"inches","Tailwater (TW) Depth = ",{"$f":"IF((C20-C19)<0,0,C20-C19)","v":0},"feet"]
["Diameter, D",{"$f":"C17/12","v":0},"feet",{"$f":"B39*12","v":0},"inches"]
["Culvert Slope, S",{"$f":"(C16-C19)/C18","v":{"$error":"#DIV/0!"}},"ft/ft"]
["Area = ",{"$f":"PI()*(B39/2)^2","v":0},"ft2",null,"Wetted Perimeter = ",{"$f":"PI()*B39","v":0},null,null,"Hydraulic Radius = ",{"$f":"B41/F41","v":{"$error":"#DIV/0!"}}]
["K =",{"$f":"IF(F$17=\"Concrete\", VLOOKUP(F$18,'Culvert Data'!C28:H31,3,FALSE), IF(F$17=\"CMP_2.67x0.5\",VLOOKUP(F$18,'Culvert Data'!C$32:H$34,3,FALSE),IF(F$17=\"PVC_Plastic\",VLOOKUP(F$18,'Culvert Data'!C$35:H36,3,FALSE),IF(F$17=\"Smooth_HDPE\",VLOOKUP(F$18,'Culvert Data'!C$37:H$39,3,FALSE),IF(F$17=\"Corrugated_PE\",VLOOKUP(F$18,'Culvert Data'!C$40:H$42,3,FALSE),IF(F$17=\"CMP_3x1\",VLOOKUP(F$18,'Culvert Data'!C$43:H$45,3,FALSE),IF(F$17=\"Welded_Steel\",VLOOKUP(F$18,'Culvert Data'!C$46:H$48,3,FALSE),\"Data Not Available\")))))))","v":3.4000000000000002E-2}]
["M = ",{"$f":"IF(F$17=\"Concrete\", VLOOKUP(F$18,'Culvert Data'!C28:H31,4,FALSE), IF(F$17=\"CMP_2.67x0.5\",VLOOKUP(F$18,'Culvert Data'!C$32:H$34,4,FALSE),IF(F$17=\"PVC_Plastic\",VLOOKUP(F$18,'Culvert Data'!C$35:H36,4,FALSE),IF(F$17=\"Smooth_HDPE\",VLOOKUP(F$18,'Culvert Data'!C$37:H$39,4,FALSE),IF(F$17=\"Corrugated_PE\",VLOOKUP(F$18,'Culvert Data'!C$40:H$42,4,FALSE),IF(F$17=\"CMP_3x1\",VLOOKUP(F$18,'Culvert Data'!C$43:H$45,4,FALSE),IF(F$17=\"Welded_Steel\",VLOOKUP(F$18,'Culvert Data'!C$46:H$48,4,FALSE),\"Data Not Available\")))))))","v":1.5}]
["c = ",{"$f":"IF(F$17=\"Concrete\", VLOOKUP(F$18,'Culvert Data'!C28:H31,5,FALSE), IF(F$17=\"CMP_2.67x0.5\",VLOOKUP(F$18,'Culvert Data'!C$32:H$34,5,FALSE),IF(F$17=\"PVC_Plastic\",VLOOKUP(F$18,'Culvert Data'!C$35:H36,5,FALSE),IF(F$17=\"Smooth_HDPE\",VLOOKUP(F$18,'Culvert Data'!C$37:H$39,5,FALSE),IF(F$17=\"Corrugated_PE\",VLOOKUP(F$18,'Culvert Data'!C$40:H$42,5,FALSE),IF(F$17=\"CMP_3x1\",VLOOKUP(F$18,'Culvert Data'!C$43:H$45,5,FALSE),IF(F$17=\"Welded_Steel\",VLOOKUP(F$18,'Culvert Data'!C$46:H$48,5,FALSE),\"Data Not Available\")))))))","v":5.5300000000000002E-2}]
["Y",{"$f":"IF(F$17=\"Concrete\", VLOOKUP(F$18,'Culvert Data'!C28:H31,6,FALSE), IF(F$17=\"CMP_2.67x0.5\",VLOOKUP(F$18,'Culvert Data'!C$32:H$34,6,FALSE),IF(F$17=\"PVC_Plastic\",VLOOKUP(F$18,'Culvert Data'!C$35:H36,6,FALSE),IF(F$17=\"Smooth_HDPE\",VLOOKUP(F$18,'Culvert Data'!C$37:H$39,6,FALSE),IF(F$17=\"Corrugated_PE\",VLOOKUP(F$18,'Culvert Data'!C$40:H$42,6,FALSE),IF(F$17=\"CMP_3x1\",VLOOKUP(F$18,'Culvert Data'!C$43:H$45,6,FALSE),IF(F$17=\"Welded_Steel\",VLOOKUP(F$18,'Culvert Data'!C$46:H$48,6,FALSE),\"Data Not Available\")))))))","v":0.54}]
["Friction Loss Kf = ",{"$f":"29*D28^2/(J41)^(4/3)","v":{"$error":"#DIV/0!"}}]
["0.5S = ",{"$f":"0.5*B40","v":{"$error":"#DIV/0!"}},"For non mitered inlets",null,null,"USE:",{"$f":"IF(F18='Culvert Data'!C33,-'Culvert Analysis'!B48,'Culvert Analysis'!B47)","v":{"$error":"#DIV/0!"}}]
["0.7S =",{"$f":"0.7*B40","v":{"$error":"#DIV/0!"}},"For mitered inlets ( use -ve value)"]
[]
["Unsubmerged Equation Form (1):  Reference:  FHWA  \"Hydraulic Design of Highway Culverts\", Table 8, p. 192, Revised 2005.",null,null,null,null,null,"Note:  This equation applies for Q/(AD^0.5)<= ~3.5"]
[]
["Q = AD0.5 * [ 1/K * (HW/D - Hc/D + 0.5S)]1/m"]
[]
["AD0.5 =   ",{"$f":"B41*B39^0.5","v":0}]
["1/K =",{"$f":"1/B42","v":29.411764705882351}]
["HW/D =",{"$f":"B38/B39","v":{"$error":"#DIV/0!"}}]
["0.5S (from above)",{"$f":"G47","v":{"$error":"#DIV/0!"}}]
[]
["Hc depends on Q"]
["Assumed Q =",0.5,"cfs","Initial Q =",{"$f":"IF(MIN(B41,B60,B67)=0,0.1,MIN(B41,B60,B67))","v":0.1},null,null,"Q2/g =",{"$f":"B60^2/32.2","v":7.7639751552795021E-3},null,null,null,null,null,"A = D2/8 [2 cos-1 (1 - (2d/D)) - sin (2 cos-1 (1-(2d/D)))] =",{"$f":"B39^2/8*(2*ACOS(1-(2*B61/B39))-SIN(2*ACOS(1-(2*B61/B39))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.587271742897158]
["dc =",{"$error":"#DIV/0!"},null,"Initial dc =",{"$f":"IF((0.325*((E60/B39)^0.6666)+0.083*B39)<B39,0.325*((E60/B39)^0.6666)+0.083*B39,0.99*B39)","v":{"$error":"#DIV/0!"}},"From Chow Approx dc eqn",null,null,null,null,null,null,null,null,"T = D sin( cos-1( (2d - D)/D)) =",{"$f":" B39*SIN(ACOS((2*B61-B39)/B39))","v":{"$error":"#DIV/0!"}}]
["q=",{"$f":"IF(B61>B39,0,IF(B61>(B39/2),4*(ACOS((B61/B39)^0.5))*360/(2*PI()),4*(ASIN((B61/B39)^0.5))*360/(2*PI())))","v":{"$error":"#DIV/0!"}},"degrees",null,"0.99 * Diameter =",{"$f":"0.99*B39","v":0},null,null,null,null,null,null,null,null,"A3 / T =",{"$f":"P60^3/P61","v":{"$error":"#DIV/0!"}},null,null,null,"Need Q2/g = A3/T",null,"Error =",{"$f":"ABS(P62-I60)","v":{"$error":"#DIV/0!"}}]
["Area at dc =",{"$f":"IF(B61>(B39/2),((B39^2)/8)*((PI()*2-(PI()*B62/180)+(SIN(B62*2*PI()/360)))),((B39^2)/8*((PI()*B62/180-SIN(B62*2*PI()/360)))))","v":{"$error":"#DIV/0!"}},"ft2",null,"0.1 * Diameter =",{"$f":"0.1*B39","v":0}]
["Vc = Q/Ac =",{"$f":"B60/B63","v":{"$error":"#DIV/0!"}},"ft/sec"]
["Hc= dc+V2/2g =",{"$f":"B61+(B64^2)/64.4","v":{"$error":"#DIV/0!"}},"ft"]
["Hc/D = ",{"$f":"B65/B39","v":{"$error":"#DIV/0!"}},"ft/ft"]
["Calculated Qunsub =",{"$f":"IF(ISERROR(IF((B56-B66+B57)<0,0,B54*(B55*(B56-B66+B57))^(1/B43))),\"\",IF((B56-B66+B57)<0,0,B54*(B55*(B56-B66+B57))^(1/B43)))","v":""},"cfs","Note:  Solution by Trial and Error Using \"Data, Analysis, Solver\" in Macro",null,null,null,"Error =",{"$f":"ABS(B60-B67)","v":{"$error":"#VALUE!"}},null,null,"Check for Convergence:  ",{"$f":"ABS((B60-B67)/B67*100)","v":{"$error":"#VALUE!"}},"Percent",null,{"$f":"IF(M67<0.1,\"Converged within 0.1%\",IF(M67<0.5,\"Converged within 0.5%\",IF(M67<1,\"Converged within 1.0%\",IF(M67<5,\"Converged within 5.0%\",IF(M67<10,\"Converged within 10%\",\"Calculations Did not converge within 10%\")))))","v":{"$error":"#VALUE!"}}]
[]
["Check of Q/(AD0.5)",{"$f":"B67/B54","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B69>3.5,\"!! Q/(AD^0.5) too high, Equation not Valid!!\", \"Value of Q/(AD^0.5) within acceptable range\")","v":{"$error":"#VALUE!"}}]
[]
[]
["Submerged Inlet control Equation:  Reference:  FHWA  \"Hydraulic Design of Highway Culverts\", Table 8, p. 192, Revised 2005.",null,null,null,null,null,null,"Note:  This equation only applies for Q/(AD^0.5)>~4.0"]
[]
["Qinlet control = ",{"$f":"IF((E74+G47-B45)<0,0,(E77*((E74+G47-B45)/B44)^0.5))","v":{"$error":"#DIV/0!"}},null,"Hwi/D = ",{"$f":"B38/B39","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"IF(E78<4,\"Q/AD^0.5 is less than 4, Equation Does not Apply!\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"AD0.5 =",{"$f":"B41*B39^0.5","v":0}]
[null,null,null,"Q/(AD0.5) =",{"$f":"B74/E77","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"IF(E78<4,\"Submerged Inlet Control Equation does not Apply\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
["Ave Q =",{"$f":"(B67+B74)/2","v":{"$error":"#VALUE!"}},"Ave of Submerged and Unsubmerged Qs for Q/(AD^0.5) between 3.5 and 4"]
[]
["Check For Orifice Control:   ",null,{"$f":"IF(B38<B39,\"Orifice Equation Does not Apply … Headwater is Below Top of Culvert at the Inlet\",\"\")","v":""}]
["Qorifice = ",{"$f":"IF(G84<0,0,(0.6*B41*(2*32.2*(G84))^0.5))","v":0},"    Orifice Equation:  0.6A(2gH)^0.5",null,null,"Head on Orifice:",{"$f":"IF(B38<B39,0,C15-(C16+(C17/24)))","v":0}]
[]
[]
["Check for Outlet Control:  Note that this applies only for full culvert barrel flow conditions"]
["Qoutlet control = ",{"$f":"IF(K88<0,0,(B41*((2*32.2*K88)/(1+D29+(B46*C18)))^0.5))","v":{"$error":"#DIV/0!"}},"For Outlet control with tailwater above ((0.6 x Diameter) + (culvert outlet invert elevation))",null,null,null,null,null,null,"Head =",{"$f":"C15-C20","v":0}]
["Qoutlet control = ",{"$f":"IF(K89<0,0,(B41*((2*32.2*K89)/(1+D29+(B46*C18)))^0.5))","v":{"$error":"#DIV/0!"}},"For Outlet control with tailwater assumed to be at ((0.6 x Diameter) + (culvert outlet invert elevation))",null,null,null,null,null,null,"Head =",{"$f":"C15-(C19+0.6*(C17/12))","v":0}]
[]
["Final \"Full Flow\" Outlet Control Value:"]
[null,"Qfull flow outlet control=  ",{"$f":"IF(B38>=B39,IF(C20>=(C19+C17*0.6/12),B88,B89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C92=0, \"'Full Flow' Outlet Control DOES NOT APPLY\",\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Minimum (Non Zero) of Inlet and Outlet Control Q's:",null,null,null,{"$f":"IF(MAX(B67,B74,C92)=0,1,IF(C92=0,IF(B74=0,B67,IF(B67=0,B74,MIN(B67,B74))),IF(MIN(B67,B74,C92)=0,1,MIN(B67,B74,C92))))","v":{"$error":"#DIV/0!"}},null,{"$f":"N92*0.5","v":{"$error":"#DIV/0!"}}]
[]
[]
["Check for Part Full Outlet Control (May Apply if the TW depth is < culvert diameter AND the HW depth is >= 0.75*culvert diameter - p 38 of Reference)",null,null,null,null,null,"Reference:  FHWA \"Hydraulic Design of Highway Culverts\", pages 36 - 38, procedure for partly full outlet control conditions (as show in Figures III-7-D and E), Revised 2005."]
[{"$f":"IF(G38>B39,\"Part Full Outlet Control Does NOT Apply\",IF(B38>=(0.75*B39),\"Part Full Outlet Control Equations DO Apply\",\"Part Full Outlet Control Does NOT Apply\"))","v":"Part Full Outlet Control Equations DO Apply"}]
["Assumed Q1 =",{"$error":"#DIV/0!"}]
[null,"For Assumed Q,         Sn =  ",{"$f":"29*D$28^2/J41^1.3333*(B97/B41)^2/64.4","v":{"$error":"#DIV/0!"}},"ft/ft","P. 36 of Reference",null,null,"Q2/g =",{"$f":"B97^2/32.2","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"A = D2/8 [2 cos-1 (1 - (2d/D)) - sin (2 cos-1 (1-(2d/D)))] =",{"$f":"B39^2/8*(2*ACOS(1-(2*C99/B39))-SIN(2*ACOS(1-(2*C99/B39))))","v":{"$error":"#DIV/0!"}},null,null,null,null,"Wetted Perimeter =",{"$f":"B39*ACOS(1-(2*C99)/B39)","v":{"$error":"#DIV/0!"}},null,null,"Reference for Part Full Circular Section Equations:  Texas DOT Online Manual Section 2 Flow in Conduits http://onlinemanuals.txdot.gov/txdotmanuals/hyd/flow_in_conduits.htm"]
[null,"dc =  ",{"$error":"#DIV/0!"},"feet","Initial dc",{"$f":"IF((0.325*((B97/B39)^0.6666)+0.083*B39)>=B39,0.95*B39,0.325*((B97/B39)^0.6666)+0.083*B39)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"T = D sin( cos-1( (2d - D)/D)) =",{"$f":" B39*SIN(ACOS((2*C99-B39)/B39))","v":{"$error":"#DIV/0!"}},null,null,null,null,"Hydraulic Radius = ",{"$f":"P98/V98","v":{"$error":"#DIV/0!"}}]
[null,"(dc + D)/2",{"$f":"(C99+B$39)/2","v":{"$error":"#DIV/0!"}},"feet","0.99 * Diameter =",{"$f":"0.99*B39","v":0},null,null,null,null,null,null,null,null,"A3 / T =",{"$f":"P98^3/P99","v":{"$error":"#DIV/0!"}},null,null,null,"Need Q2/g = A3/T",null,"Error =",{"$f":"ABS(P100-I98)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"HGL Elev @ outlet =  ",{"$f":"MAX(C$20,(C$19+C100))","v":{"$error":"#DIV/0!"}},"feet","0.1 * Diameter =",{"$f":"0.1*B39","v":0}]
[null,"HW Elev =  ",{"$f":"C101+(C98*C$18)+(1+D29)*((B97/B41)^2)/64.4","v":{"$error":"#DIV/0!"}},"feet","HW Error =",{"$f":"ABS(C102-C15)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Final \"Part Full\" Outlet Control Q (If Applicable):",null,{"$f":"IF(AND(G38<=B39,B38>=(0.35*B39)),IF(F102<0.09,B97,\"Did Not Converge\"),\"Does NOT Apply\")","v":{"$error":"#DIV/0!"}},"cfs","Note:  Solution by Trial and Error Using \"Data, Analysis, Solver\" in Macro"]
[]
[]
["Open Channel Flow Approximation:"]
["Initial Q =",{"$f":"IF((C15-C20)<=0,0,IF((C16-C19)<=0,B117*B113,IF(B116<B117,B116*B113,B117*B113)))","v":0},null,"Q calculated for minimum V (either slope = culvert slope, or slope = W.S. Slope)",null,null,null,null,null,null,null,"Velocity Head for Assumed Velocity:",{"$f":"F111^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"For New V1:","V2/2g = ",{"$f":"Q116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V3:  V2/2g = ",{"$f":"Z116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V5:  V2/2g = ",{"$f":"AJ116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V7:  V2/2g = ",{"$f":"AT116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V9:  V2/2g = ",{"$f":"BD116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V11:  V2/2g = ",{"$f":"BN116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V13:  V2/2g = ",{"$f":"BX116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V15:  V2/2g = ",{"$f":"CH116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V17:  V2/2g = ",{"$f":"CR116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V19:  V2/2g = ",{"$f":"DB116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V21:  V2/2g = ",{"$f":"DL116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V23:  V2/2g = ",{"$f":"DV116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V25:  V2/2g = ",{"$f":"EF116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"CHECK For Maximum Slope:  V2/2g = ",{"$f":"EP116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"CHECK For Minimum Slope:  V2/2g = ",{"$f":"EP117^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V26:  V2/2g = ",{"$f":"FH116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V28:  V2/2g = ",{"$f":"FR116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V30:  V2/2g = ",{"$f":"GB116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V32:  V2/2g = ",{"$f":"GL116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V34:  V2/2g = ",{"$f":"GV116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V36:  V2/2g = ",{"$f":"HF116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V38:  V2/2g = ",{"$f":"HP116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V40:  V2/2g = ",{"$f":"HZ116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V42:  V2/2g = ",{"$f":"IJ116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V43:  V2/2g = ",{"$f":"IT116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"For New V43:  V2/2g = ",{"$f":"JD116^2/64.4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Average of Last Two HW Elevs:",null,null,{"$f":"(IZ120+JJ120)/2","v":{"$error":"#DIV/0!"}},"Error:",{"$f":"ABS(JV109-C15)","v":{"$error":"#DIV/0!"}}]
["TW Critical Depth:",{"$f":"0.325*((B109/B39)^0.6666)+0.083*B39","v":{"$error":"#DIV/0!"}},"ft",null,"Slope Used =",{"$f":"IF(E115<=0,0,IF(E114<=0,E115,IF(E114<E115,E114,E115)))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+D29)*M109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-M110-$C$16)<0,0,$C$15-M110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+D29)*V109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-V110-$C$16)<0,0,$C$15-V110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*AF109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-AF110-$C$16)<0,0,$C$15-AF110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*AP109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-AP110-$C$16)<0,0,$C$15-AP110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*AZ109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-AZ110-$C$16)<0,0,$C$15-AZ110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*BJ109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-BJ110-$C$16)<0,0,$C$15-BJ110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*BT109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-BT110-$C$16)<0,0,$C$15-BT110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*CD109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-CD110-$C$16)<0,0,$C$15-CD110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*CN109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-CN110-$C$16)<0,0,$C$15-CN110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*CX109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-CX110-$C$16)<0,0,$C$15-CX110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*DH109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-DH110-$C$16)<0,0,$C$15-DH110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*DR109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-DR110-$C$16)<0,0,$C$15-DR110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*EB109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-EB110-$C$16)<0,0,$C$15-EB110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*EL109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-EL110-$C$16)<0,0,$C$15-EL110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*EV109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-EV110-$C$16)<0,0,$C$15-EV110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*FD109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-FD110-$C$16)<0,0,$C$15-FD110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*FN109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-FN110-$C$16)<0,0,$C$15-FN110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*FX109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-FX110-$C$16)<0,0,$C$15-FX110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*GH109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-GH110-$C$16)<0,0,$C$15-GH110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*GR109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-GR110-$C$16)<0,0,$C$15-GR110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*HB109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-HB110-$C$16)<0,0,$C$15-HB110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*HL109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-HL110-$C$16)<0,0,$C$15-HL110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*HV109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-HV110-$C$16)<0,0,$C$15-HV110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*IF109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-IF110-$C$16)<0,0,$C$15-IF110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*IP109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-IP110-$C$16)<0,0,$C$15-IP110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*IZ109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-IZ110-$C$16)<0,0,$C$15-IZ110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Entrance Losses = ",{"$f":"(1+$D$29)*JJ109","v":{"$error":"#DIV/0!"}},"U/S Depth 1:",{"$f":"IF(($C$15-JJ110-$C$16)<0,0,$C$15-JJ110-$C$16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Elevation with Minimum Error:",null,null,{"$f":"IF(JD118<(MIN(JN118,JX109)),IZ120,IF(JN118<(MIN(JD118,JX109)),JJ120,JV109))","v":{"$error":"#DIV/0!"}},"Error:",{"$f":"JV110-C15","v":{"$error":"#DIV/0!"}}]
["TW Depth =",{"$f":"MAX(B110,G38)","v":{"$error":"#DIV/0!"}},"ft (Max of Actual & Crit Depth TW)",null,"Velocity Used =",{"$f":"IF(B117<=0,0,IF(B116<=0,B117,IF(B116<B117,B116,B117)))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = (TW Elev + (Slope * Length)) =",{"$f":"B111+C19+(F110*C18)","v":{"$error":"#DIV/0!"}},"ft       Ave US Depth =",{"$f":"((M111-$C$16)+O110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"M119+$C$19+(Q115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((V111-$C$16)+X110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"V119+$C$19+(Z115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((AF111-$C$16)+AH110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"AF119+$C$19+(AJ115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((AP111-$C$16)+AR110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"AP119+$C$19+(AT115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((AZ111-$C$16)+BB110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"AZ119+$C$19+(BD115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((BJ111-$C$16)+BL110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"BJ119+$C$19+(BN115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((BT111-$C$16)+BV110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"BT119+$C$19+(BX115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((CD111-$C$16)+CF110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"CD119+$C$19+(CH115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((CN111-$C$16)+CP110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"CN119+$C$19+(CR115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((CX111-$C$16)+CZ110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"CX119+$C$19+(DB115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((DH111-$C$16)+DJ110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"DH119+$C$19+(DL115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((DR111-$C$16)+DT110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"DR119+$C$19+(DV115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((EB111-$C$16)+ED110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"EB119+$C$19+(EF115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((EL111-$C$16)+EN110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"EL119+$C$19+(EP113*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((EV111-$C$16)+EX110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"Approx. US WS Elev ( just DS of Inlet) = ",{"$f":"EL119+$C$19+(EP114*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((FD111-$C$16)+FF110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"EL119+$C$19+(FH115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((FN111-$C$16)+FP110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"FN119+$C$19+(FR115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((FX111-$C$16)+FZ110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"FX119+$C$19+(GB115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((GH111-$C$16)+GJ110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"GH119+$C$19+(GL115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((GR111-$C$16)+GT110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"GR119+$C$19+(GV115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((HB111-$C$16)+HD110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"HB119+$C$19+(HF115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((HL111-$C$16)+HN110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"HL119+$C$19+(HP115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((HV111-$C$16)+HX110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"HV119+$C$19+(HZ115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((IF111-$C$16)+IH110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"IF119+$C$19+(IJ115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((IP111-$C$16)+IR110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"IP119+$C$19+(IT115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((IZ111-$C$16)+JB110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,"Approx. US WS Elev (in culvert just DS of Inlet) = ",{"$f":"IZ119+$C$19+(JD115*$C$18)","v":{"$error":"#DIV/0!"}},"ft      US Depth = ",{"$f":"((JJ111-$C$16)+JL110)/2","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,null,null,"Final Q:",{"$f":"IF(JD118<(MIN(JN118,JX109)),IZ117,IF(JN118<(MIN(JD118,JX109)),JJ117,(IZ117+JJ117)/2))","v":{"$error":"#DIV/0!"}},"cfs"]
["Ave Depth = ",{"$f":"IF((B38+G38)/2>=B39,B39*0.98,(B38+G38)/2)","v":0},"ft (Ave TW and HW Depth)",null,"Check HW =",{"$f":"C19+B111+(F110*C18)+(1+D29)*(F111^2/64.4)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"New Average Depth = (HWdepth +TW depth)/2 = ",{"$f":"IF((B111+O111)/2>=B39,0.95*B39,(B111+O111)/2)","v":{"$error":"#DIV/0!"}},"ft",null,"Ave of Approx HW Elevs:",{"$f":"(M111+M120)/2","v":{"$error":"#DIV/0!"}},null,null,null,"New Ave Depth 2 = ",{"$f":"IF((M119+X111)/2>=$B$39,0.98*$B$39,(M119+X111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(V111+V120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 3 = ",{"$f":"IF((V119+AH111)/2>=$B$39,0.98*$B$39,(V119+AH111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(AF111+AF120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 5 = ",{"$f":"IF((AF119+AR111)/2>=$B$39,0.98*$B$39,(AF119+AR111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(AP111+AP120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 7 = ",{"$f":"IF((AP119+BB111)/2>=$B$39,0.98*$B$39,(AP119+BB111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(AZ111+AZ120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 9 = ",{"$f":"IF((AZ119+BL111)/2>=$B$39,0.98*$B$39,(AZ119+BL111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(BJ111+BJ120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 11 = ",{"$f":"IF((BJ119+BV111)/2>=$B$39,0.98*$B$39,(BJ119+BV111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(BT111+BT120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 13 = ",{"$f":"IF((BT119+CF111)/2>=$B$39,0.98*$B$39,(BT119+CF111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(CD111+CD120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 15 = ",{"$f":"IF((CD119+CP111)/2>=$B$39,0.98*$B$39,(CD119+CP111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(CN111+CN120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 17 = ",{"$f":"IF((CN119+CZ111)/2>=$B$39,0.98*$B$39,(CN119+CZ111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(CX111+CX120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 19 = ",{"$f":"IF((CX119+DJ111)/2>=$B$39,0.98*$B$39,(CX119+DJ111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(DH111+DH120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 21 = ",{"$f":"IF((DH119+DT111)/2>=$B$39,0.98*$B$39,(DH119+DT111)/2)","v":{"$error":"#DIV/0!"}},null,null,"Ave of Approx HW Elevations:",{"$f":"(DR111+DR120)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Ave Depth 23 = ",{"$f":"IF((DR119+ED111)/2>=$B$39,0.98*$B$39,(DR119+ED111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 25 = ",{"$f":"IF((EB119+EN111)/2>=$B$39,0.98*$B$39,(EB119+EN111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth = ",{"$f":"IF((EL119+EX111)/2>=$B$39,0.98*$B$39,(EL119+EX111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New Ave Depth  = ",{"$f":"IF((EL119+FF111)/2>=$B$39,0.98*$B$39,(EL119+FF111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 26 = ",{"$f":"IF((EL119+FP111)/2>=$B$39,0.98*$B$39,(EL119+FP111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 28 = ",{"$f":"IF((FN119+FZ111)/2>=$B$39,0.98*$B$39,(FN119+FZ111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 30 = ",{"$f":"IF((FX119+GJ111)/2>=$B$39,0.98*$B$39,(FX119+GJ111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 32 = ",{"$f":"IF((GH119+GT111)/2>=$B$39,0.98*$B$39,(GH119+GT111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 34 = ",{"$f":"IF((GR119+HD111)/2>=$B$39,0.98*$B$39,(GR119+HD111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 36 = ",{"$f":"IF((HB119+HN111)/2>=$B$39,0.98*$B$39,(HB119+HN111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 38 = ",{"$f":"IF((HL119+HX111)/2>=$B$39,0.98*$B$39,(HL119+HX111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 40 = ",{"$f":"IF((HV119+IH111)/2>=$B$39,0.98*$B$39,(HV119+IH111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 42 = ",{"$f":"IF((IF119+IR111)/2>=$B$39,0.98*$B$39,(IF119+IR111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 43 = ",{"$f":"IF((IP119+JB111)/2>=$B$39,0.98*$B$39,(IP119+JB111)/2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Ave Depth 43 = ",{"$f":"IF((IZ119+JL111)/2>=$B$39,0.98*$B$39,(IZ119+JL111)/2)","v":{"$error":"#DIV/0!"}}]
["A=",{"$f":"B39^2/8*(2*ACOS(1-(2*B112/B39))-SIN(2*ACOS(1-(2*B112/B39))))","v":{"$error":"#DIV/0!"}},null,null,"Initial HW Error (ft) =",{"$f":"ABS(C15-F112)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"New A =",{"$f":"B39^2/8*(2*ACOS(1-(2*M112/B39))-SIN(2*ACOS(1-(2*M112/B39))))","v":{"$error":"#DIV/0!"}},"sq ft",null,"New Range:  Max Slope:",{"$f":"IF(Q112>$C$15,F110,F116)","v":{"$error":"#DIV/0!"}}," ft/ft",null,null,"New A2 = ",{"$f":"B39^2/8*(2*ACOS(1-(2*V112/B39))-SIN(2*ACOS(1-(2*V112/B39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(Z112>$C$15,Q115,Q113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A3 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*AF112/$B$39))-SIN(2*ACOS(1-(2*AF112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(AJ112>$C$15,Z115,Z113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A5 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*AP112/$B$39))-SIN(2*ACOS(1-(2*AP112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(AT112>$C$15,AJ115,AJ113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A7 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*AZ112/$B$39))-SIN(2*ACOS(1-(2*AZ112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(BD112>$C$15,AT115,AT113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A9 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*BJ112/$B$39))-SIN(2*ACOS(1-(2*BJ112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(BN112>$C$15,BD115,BD113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A11 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*BT112/$B$39))-SIN(2*ACOS(1-(2*BT112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(BX112>$C$15,BN115,BN113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A13 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*CD112/$B$39))-SIN(2*ACOS(1-(2*CD112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(CD120>$C$15,BX115,IF((BX113-BX114)<0.0005,BX113*1.1,BX113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A15 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*CN112/$B$39))-SIN(2*ACOS(1-(2*CN112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(CN120>$C$15,CH115,IF((CH113-CH114)<0.0005,CH113*1.1,CH113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A17 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*CX112/$B$39))-SIN(2*ACOS(1-(2*CX112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(CX120>$C$15,CR115,IF((CR113-CR114)<0.0005,CR113*1.1,CR113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A19 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*DH112/$B$39))-SIN(2*ACOS(1-(2*DH112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(DH120>$C$15,DB115,IF((DB113-DB114)<0.0005,DB113*1.1,DB113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A21 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*DR112/$B$39))-SIN(2*ACOS(1-(2*DR112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(DR120>$C$15,DL115,IF((DL113-DL114)<0.0005,DL113*1.1,DL113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A23 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*EB112/$B$39))-SIN(2*ACOS(1-(2*EB112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(EB120>$C$15,DV115,IF((DV113-DV114)<0.0005,DV113*1.1,DV113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A25 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*EL112/$B$39))-SIN(2*ACOS(1-(2*EL112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(EL120>$C$15,EF115,IF((EF113-EF114)<0.0005,EF113*1.1,EF113))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*EV112/$B$39))-SIN(2*ACOS(1-(2*EV112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New A = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*FD112/$B$39))-SIN(2*ACOS(1-(2*FD112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(EV120>=$C$15,EP113,EP113*1.05)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A26 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*FN112/$B$39))-SIN(2*ACOS(1-(2*FN112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(FN120>$C$15,(FH115+FH113)/2,FH113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A28 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*FX112/$B$39))-SIN(2*ACOS(1-(2*FX112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(FX120>$C$15,(FR115+FR113)/2,FR113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A30 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*GH112/$B$39))-SIN(2*ACOS(1-(2*GH112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(GH120>$C$15,(GB115+GB113)/2,GB113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A32 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*GR112/$B$39))-SIN(2*ACOS(1-(2*GR112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(GR120>$C$15,GL115,GL113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A34 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*HB112/$B$39))-SIN(2*ACOS(1-(2*HB112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(HB120>$C$15,GV115,GV113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A36 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*HL112/$B$39))-SIN(2*ACOS(1-(2*HL112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(HL120>$C$15,HF115,HF113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A38 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*HV112/$B$39))-SIN(2*ACOS(1-(2*HV112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(HV120>$C$15,HP115,HP113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A40 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*IF112/$B$39))-SIN(2*ACOS(1-(2*IF112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(IF120>$C$15,HZ115,HZ113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A42 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*IP112/$B$39))-SIN(2*ACOS(1-(2*IP112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(IP120>$C$15,IJ115,IJ113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A43 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*IZ112/$B$39))-SIN(2*ACOS(1-(2*IZ112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(IZ120>$C$15,IF((IT113-IT114)<0.00011,IT113*0.99,IT113),1.01*IT113)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New A43 = ",{"$f":"$B$39^2/8*(2*ACOS(1-(2*JJ112/$B$39))-SIN(2*ACOS(1-(2*JJ112/$B$39))))","v":{"$error":"#DIV/0!"}},null,null,"New Range:  Max Slope:",{"$f":"IF(JJ120>$C$15,JD115,JD113)","v":{"$error":"#DIV/0!"}}]
["P =",{"$f":"B39*ACOS(1-(2*B112)/B39)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"B40","v":{"$error":"#DIV/0!"}},"culvert slope (ft/ft)",null,null,null,null,null,"New P =",{"$f":"B39*ACOS(1-(2*M112)/B39)","v":{"$error":"#DIV/0!"}},"ft",null,"Min Slope:",{"$f":"IF(Q112<=$C$15,F110,F117)","v":{"$error":"#DIV/0!"}},"ft/ft",null,null,"New P2 = ",{"$f":"B39*ACOS(1-(2*V112)/B39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(Z112<=$C$15,Q115,Q114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P3 = ",{"$f":"$B$39*ACOS(1-(2*AF112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(AJ112<=$C$15,Z115,Z114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P5 = ",{"$f":"$B$39*ACOS(1-(2*AP112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(AT112<=$C$15,AJ115,AJ114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P7 = ",{"$f":"$B$39*ACOS(1-(2*AZ112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(BD112<=$C$15,AT115,AT114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P9 = ",{"$f":"$B$39*ACOS(1-(2*BJ112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(BN112<=$C$15,BD115,BD114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P11 = ",{"$f":"$B$39*ACOS(1-(2*BT112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(BX112<=$C$15,BN115,BN114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P13 = ",{"$f":"$B$39*ACOS(1-(2*CD112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(CD120<=$C$15,BX114,IF((BX113-BX114)<0.0005,BX114*0.9,BX114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P15 = ",{"$f":"$B$39*ACOS(1-(2*CN112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(CN120<=$C$15,CH114,IF((CH113-CH114)<0.0005,CH114*0.9,CH114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P17 = ",{"$f":"$B$39*ACOS(1-(2*CX112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(CX120<=$C$15,CR114,IF((CR113-CR114)<0.0005,CR114*0.9,CR114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P19 = ",{"$f":"$B$39*ACOS(1-(2*DH112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(DH120<=$C$15,DB114,IF((DB113-DB114)<0.0005,DB114*0.9,DB114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P21= ",{"$f":"$B$39*ACOS(1-(2*DR112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(DR120<=$C$15,DL114,IF((DL113-DL114)<0.0005,DL114*0.9,DL114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P23= ",{"$f":"$B$39*ACOS(1-(2*EB112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(EB120<=$C$15,DV114,IF((DV113-DV114)<0.0005,DV114*0.9,DV114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P25= ",{"$f":"$B$39*ACOS(1-(2*EL112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(EL120<=$C$15,EF114,IF((EF113-EF114)<0.0005,EF114*0.9,EF114))","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P = ",{"$f":"$B$39*ACOS(1-(2*EV112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New P= ",{"$f":"$B$39*ACOS(1-(2*FD112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(FD120<=$C$15,EP114,EP114*0.95)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P26= ",{"$f":"$B$39*ACOS(1-(2*FN112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(FN120<=$C$15,(FH115+FH114)/2,FH114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P28= ",{"$f":"$B$39*ACOS(1-(2*FX112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(FX120<=$C$15,(FR115+FR114)/2,FR114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P30= ",{"$f":"$B$39*ACOS(1-(2*GH112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(GH120<=$C$15,(GB115+GB114)/2,GB114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P32= ",{"$f":"$B$39*ACOS(1-(2*GR112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(GR120<=$C$15,GL115,GL114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P34= ",{"$f":"$B$39*ACOS(1-(2*HB112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(HB120<=$C$15,GV115,GV114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P36= ",{"$f":"$B$39*ACOS(1-(2*HL112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(HL120<=$C$15,HF115,HF114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P38= ",{"$f":"$B$39*ACOS(1-(2*HV112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(HV120<=$C$15,HP115,HP114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P40= ",{"$f":"$B$39*ACOS(1-(2*IF112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(IF120<=$C$15,HZ115,HZ114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P42= ",{"$f":"$B$39*ACOS(1-(2*IP112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(IP120<=$C$15,IJ115,IJ114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P43= ",{"$f":"$B$39*ACOS(1-(2*IZ112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(IZ120<$C$15,IF((IT113-IT114)<0.0001,IT114*1.01,IT114),0.99*IT114)","v":{"$error":"#DIV/0!"}},null,null,null,null,"New P43= ",{"$f":"$B$39*ACOS(1-(2*JJ112)/$B$39)","v":{"$error":"#DIV/0!"}},null,null,"Min Slope:",{"$f":"IF(JJ120<=$C$15,JD115,JD114)","v":{"$error":"#DIV/0!"}}]
["R =",{"$f":"B113/B114","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(C15-C20)/C18","v":{"$error":"#DIV/0!"}},"HW to TW slope (ft/ft)",null,null,null,null,null,"New R =",{"$f":"M113/M114","v":{"$error":"#DIV/0!"}},"ft",null,"Use Ave for New Slope:",{"$f":"(Q113+Q114)/2","v":{"$error":"#DIV/0!"}},"ft/ft",null,null,"New R2 = ",{"$f":"V113/V114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(Z113+Z114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R3 = ",{"$f":"AF113/AF114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(AJ113+AJ114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R5 = ",{"$f":"AP113/AP114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(AT113+AT114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R7 = ",{"$f":"AZ113/AZ114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(BD113+BD114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R9 = ",{"$f":"BJ113/BJ114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(BN113+BN114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R11 = ",{"$f":"BT113/BT114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(BX113+BX114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R13 = ",{"$f":"CD113/CD114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(CH113+CH114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R15 = ",{"$f":"CN113/CN114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(CR113+CR114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R17 = ",{"$f":"CX113/CX114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(DB113+DB114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R19 = ",{"$f":"DH113/DH114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(DL113+DL114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R21 = ",{"$f":"DR113/DR114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(DV113+DV114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R23 = ",{"$f":"EB113/EB114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(EF113+EF114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R25 = ",{"$f":"EL113/EL114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(EP113+EP114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R = ",{"$f":"EV113/EV114","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New R = ",{"$f":"FD113/FD114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(FH113+FH114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R26 = ",{"$f":"FN113/FN114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(FR113+FR114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R28 = ",{"$f":"FX113/FX114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(GB113+GB114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R30 = ",{"$f":"GH113/GH114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(GL113+GL114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R32 = ",{"$f":"GR113/GR114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(GV113+GV114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R34 = ",{"$f":"HB113/HB114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(HF113+HF114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R36 = ",{"$f":"HL113/HL114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(HP113+HP114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R38 = ",{"$f":"HV113/HV114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(HZ113+HZ114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R40 = ",{"$f":"IF113/IF114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(IJ113+IJ114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R42 = ",{"$f":"IP113/IP114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(IT113+IT114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R43 = ",{"$f":"IZ113/IZ114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(JD113+JD114)/2","v":{"$error":"#DIV/0!"}},null,null,null,null,"New R43 = ",{"$f":"JJ113/JJ114","v":{"$error":"#DIV/0!"}},null,null,"Use Ave for New Slope:",{"$f":"(JN113+JN114)/2","v":{"$error":"#DIV/0!"}}]
["V =",{"$f":"IF(E114<=0,0,1.486/D28*(B115^(2/3))*E114^0.5)","v":{"$error":"#DIV/0!"}},"  for slope = culvert slope ",null,"Starting Slope Range:  Max Slope:",{"$f":"2*(MAX(E114,E115))","v":{"$error":"#DIV/0!"}},"ft/ft",null,null,null,null,"New V =",{"$f":"1.486/D28*M115^0.6666*F110^0.5","v":{"$error":"#DIV/0!"}},"ft/s",null,"New V1 = ",{"$f":"1.486/$D$28*M115^0.6666*Q115^0.5","v":{"$error":"#DIV/0!"}},"ft/sec",null,null,"New V2 = ",{"$f":"1.486/$D$28*V115^0.6666*Q115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V3 = ",{"$f":"1.486/$D$28*V115^0.6666*Z115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V4 = ",{"$f":"1.486/$D$28*AF115^0.6666*Z115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V5 = ",{"$f":"1.486/$D$28*AF115^0.6666*AJ115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V6 = ",{"$f":"1.486/$D$28*AP115^0.6666*AJ115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V7 = ",{"$f":"1.486/$D$28*AP115^0.6666*AT115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V8 = ",{"$f":"1.486/$D$28*AZ115^0.6666*AT115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V9 = ",{"$f":"1.486/$D$28*AZ115^0.6666*BD115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V10 = ",{"$f":"1.486/$D$28*BJ115^0.6666*BD115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V11 = ",{"$f":"1.486/$D$28*BJ115^0.6666*BN115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V12 = ",{"$f":"1.486/$D$28*BT115^0.6666*BN115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V13 = ",{"$f":"1.486/$D$28*BT115^0.6666*BX115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V14 = ",{"$f":"1.486/$D$28*CD115^0.6666*BX115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V15 = ",{"$f":"1.486/$D$28*CD115^0.6666*CH115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V16 = ",{"$f":"1.486/$D$28*CN115^0.6666*CH115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V17 = ",{"$f":"1.486/$D$28*CN115^0.6666*CR115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V18 = ",{"$f":"1.486/$D$28*CX115^0.6666*CR115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V19 = ",{"$f":"1.486/$D$28*CX115^0.6666*DB115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V20 = ",{"$f":"1.486/$D$28*DH115^0.6666*DB115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V21 = ",{"$f":"1.486/$D$28*DH115^0.6666*DL115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V22 = ",{"$f":"1.486/$D$28*DR115^0.6666*DL115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V23 = ",{"$f":"1.486/$D$28*DR115^0.6666*DV115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V24 = ",{"$f":"1.486/$D$28*EB115^0.6666*DV115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V25 = ",{"$f":"1.486/$D$28*EB115^0.6666*EF115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V26 = ",{"$f":"1.486/$D$28*EL115^0.6666*EF115^0.5","v":{"$error":"#DIV/0!"}},null,null,"Velocity for Max Slope = ",{"$f":"1.486/$D$28*EL115^0.6666*EP113^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V = ",{"$f":"1.486/$D$28*EV115^0.6666*EP113^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New V = ",{"$f":"1.486/$D$28*FD115^0.6666*EP114^0.5","v":{"$error":"#DIV/0!"}},null,null,"Velocity for Ave Slope = ",{"$f":"1.486/$D$28*FD115^0.6666*FH115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V27 = ",{"$f":"1.486/$D$28*FN115^0.6666*FH115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V28 = ",{"$f":"1.486/$D$28*FN115^0.6666*FR115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V29 = ",{"$f":"1.486/$D$28*FX115^0.6666*FR115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V30 = ",{"$f":"1.486/$D$28*FX115^0.6666*GB115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V31 = ",{"$f":"1.486/$D$28*GH115^0.6666*GB115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V32 = ",{"$f":"1.486/$D$28*GH115^0.6666*GL115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V33 = ",{"$f":"1.486/$D$28*GR115^0.6666*GL115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V34 = ",{"$f":"1.486/$D$28*GR115^0.6666*GV115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V35 = ",{"$f":"1.486/$D$28*HB115^0.6666*GV115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V36 = ",{"$f":"1.486/$D$28*HB115^0.6666*HF115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V37 = ",{"$f":"1.486/$D$28*HL115^0.6666*HF115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V38 = ",{"$f":"1.486/$D$28*HL115^0.6666*HP115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V39 = ",{"$f":"1.486/$D$28*HV115^0.6666*HP115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V40= ",{"$f":"1.486/$D$28*HV115^0.6666*HZ115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V41 = ",{"$f":"1.486/$D$28*IF115^0.6666*HZ115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V42 = ",{"$f":"1.486/$D$28*IF115^0.6666*IJ115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V43 = ",{"$f":"1.486/$D$28*IP115^0.6666*IJ115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V44 = ",{"$f":"1.486/$D$28*IP115^0.6666*IT115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V44 = ",{"$f":"1.486/$D$28*IZ115^0.6666*IT115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V45 = ",{"$f":"1.486/$D$28*IZ115^0.6666*JD115^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New V44 = ",{"$f":"1.486/$D$28*JJ115^0.6666*JD115^0.5","v":{"$error":"#DIV/0!"}},null,null,"New V45 = ",{"$f":"1.486/$D$28*JJ115^0.6666*JN115^0.5","v":{"$error":"#DIV/0!"}}]
["V =",{"$f":"1.486/D28*B115^(2/3)*(E115)^0.5","v":{"$error":"#DIV/0!"}},"  for HW to TW slope",null,"Min Slope:",{"$f":"IF(F112<=C15,F110,0.0000001)","v":{"$error":"#DIV/0!"}},"ft/ft",null,null,null,null,"New Q =",{"$f":"M113*M116","v":{"$error":"#DIV/0!"}},"cfs",null,null,null,null,null,null,"New Q2 = ",{"$f":"V113*V116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q3 = ",{"$f":"AF113*AF116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q5 = ",{"$f":"AP113*AP116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q7 = ",{"$f":"AZ113*AZ116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q9 = ",{"$f":"BJ113*BJ116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q11 = ",{"$f":"BT113*BT116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q13 = ",{"$f":"CD113*CD116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q15 = ",{"$f":"CN113*CN116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q17 = ",{"$f":"CX113*CX116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q19 = ",{"$f":"DH113*DH116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q21= ",{"$f":"DR113*DR116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q23= ",{"$f":"EB113*EB116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q25= ",{"$f":"EL113*EL116","v":{"$error":"#DIV/0!"}},null,null,"Velocity for Min Slope = ",{"$f":"1.486/$D$28*EL115^0.6666*EP114^0.5","v":{"$error":"#DIV/0!"}},null,null,null,null,"New Q= ",{"$f":"EV113*EV116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New Q= ",{"$f":"FD113*FD116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q26= ",{"$f":"FN113*FN116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q28= ",{"$f":"FX113*FX116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q30= ",{"$f":"GH113*GH116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q32= ",{"$f":"GR113*GR116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q34= ",{"$f":"HB113*HB116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q36= ",{"$f":"HL113*HL116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q38= ",{"$f":"HV113*HV116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q40= ",{"$f":"IF113*IF116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q42= ",{"$f":"IP113*IP116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q43= ",{"$f":"IZ113*IZ116","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New Q43= ",{"$f":"JJ113*JJ116","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Average Slope:",{"$f":"(F116+F117)/2","v":{"$error":"#DIV/0!"}},"ft/ft",null,null,null,null,"TW Critical Depth:",{"$f":"0.325*((M117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"TW Critical Depth2:",{"$f":"0.325*((V117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth3:",{"$f":"0.325*((AF117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth5:",{"$f":"0.325*((AP117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth7:",{"$f":"0.325*((AZ117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth9:",{"$f":"0.325*((BJ117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth11:",{"$f":"0.325*((BT117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth13:",{"$f":"0.325*((CD117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth15:",{"$f":"0.325*((CN117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth17:",{"$f":"0.325*((CX117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth19:",{"$f":"0.325*((DH117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth21:",{"$f":"0.325*((DR117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth23:",{"$f":"0.325*((EB117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth25:",{"$f":"0.325*((EL117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth:",{"$f":"0.325*((EV117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"TW Critical Depth:",{"$f":"0.325*((FD117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth26:",{"$f":"0.325*((FN117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth28:",{"$f":"0.325*((FX117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth30:",{"$f":"0.325*((GH117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth32:",{"$f":"0.325*((GR117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"TW Critical Depth34:",{"$f":"0.325*((HB117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,"Error =",{"$f":"ABS(HB120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,"TW Critical Depth36:",{"$f":"0.325*((HL117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(HL120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"TW Critical Depth38:",{"$f":"0.325*((HV117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(HV120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"TW Critical Depth40:",{"$f":"0.325*((IF117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(IF120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"TW Critical Depth42:",{"$f":"0.325*((IP117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(IP120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"TW Critical Depth43:",{"$f":"0.325*((IZ117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(IZ120-$C$15)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,"TW Critical Depth43:",{"$f":"0.325*((JJ117/$B$39)^0.6666)+0.083*$B$39","v":{"$error":"#DIV/0!"}},null,null,"Error =",{"$f":"ABS(JJ120-$C$15)","v":{"$error":"#DIV/0!"}},"ft"]
[null,null,null,null,null,null,null,null,null,null,null,"New TW Depth:",{"$f":"IF(MAX(M118,$G$38)>=$B$39,0.98*$B$39,MAX(M118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"New TW Depth2:",{"$f":"IF(MAX(V118,$G$38)>=$B$39,0.98*$B$39,IF(MAX(V118,$G$38)<=0,0,MAX(V118,$G$38)))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth3:",{"$f":"IF(MAX(AF118,$G$38)>=$B$39,0.98*$B$39,MAX(AF118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth5:",{"$f":"IF(MAX(AP118,$G$38)>=$B$39,0.98*$B$39,MAX(AP118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth7:",{"$f":"IF(MAX(AZ118,$G$38)>=$B$39,0.98*$B$39,MAX(AZ118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth9:",{"$f":"IF(MAX(BJ118,$G$38)>=$B$39,0.98*$B$39,MAX(BJ118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth11:",{"$f":"IF(MAX(BT118,$G$38)>=$B$39,0.98*$B$39,MAX(BT118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth13:",{"$f":"IF(MAX(CD118,$G$38)>=$B$39,0.98*$B$39,MAX(CD118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth15:",{"$f":"IF(MAX(CN118,$G$38)>=$B$39,0.98*$B$39,MAX(CN118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth17:",{"$f":"IF(MAX(CX118,$G$38)>=$B$39,0.98*$B$39,MAX(CX118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth19:",{"$f":"IF(MAX(DH118,$G$38)>=$B$39,0.98*$B$39,MAX(DH118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth21:",{"$f":"IF(MAX(DR118,$G$38)>=$B$39,0.98*$B$39,MAX(DR118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth23:",{"$f":"IF(MAX(EB118,$G$38)>=$B$39,0.98*$B$39,MAX(EB118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth25:",{"$f":"IF(MAX(EL118,$G$38)>=$B$39,0.98*$B$39,MAX(EL118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth:",{"$f":"IF(MAX(EV118,$G$38)>=$B$39,0.98*$B$39,MAX(EV118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"New TW Depth:",{"$f":"IF(MAX(FD118,$G$38)>=$B$39,0.98*$B$39,MAX(FD118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth26:",{"$f":"IF(MAX(FN118,$G$38)>=$B$39,0.98*$B$39,MAX(FN118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth28:",{"$f":"IF(MAX(FX118,$G$38)>=$B$39,0.98*$B$39,MAX(FX118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth30:",{"$f":"IF(MAX(GH118,$G$38)>=$B$39,0.98*$B$39,MAX(GH118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth32:",{"$f":"IF(MAX(GR118,$G$38)>=$B$39,0.98*$B$39,MAX(GR118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth34:",{"$f":"IF(MAX(HB118,$G$38)>=$B$39,0.98*$B$39,MAX(HB118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth36:",{"$f":"IF(MAX(HL118,$G$38)>=$B$39,0.98*$B$39,MAX(HL118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth38:",{"$f":"IF(MAX(HV118,$G$38)>=$B$39,0.98*$B$39,MAX(HV118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth40:",{"$f":"IF(MAX(IF118,$G$38)>=$B$39,0.98*$B$39,MAX(IF118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth42:",{"$f":"IF(MAX(IP118,$G$38)>=$B$39,0.98*$B$39,MAX(IP118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth43:",{"$f":"IF(MAX(IZ118,$G$38)>=$B$39,0.98*$B$39,MAX(IZ118,$G$38))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"New TW Depth43:",{"$f":"IF(MAX(JJ118,$G$38)>=$B$39,0.98*$B$39,MAX(JJ118,$G$38))","v":{"$error":"#DIV/0!"}}]
["Final Open Channel Flow Approximation (After Iterations):",null,{"$f":"IF(B38>1.1*B39,\"NOT APPLICABLE!\",JV111)","v":{"$error":"#DIV/0!"}},"cfs","Error in HW Elev After Iterations:",{"$f":"IF(B38>1.1*B39,\"NOT APPLICABLE!\",JX110)","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,"Check HW =",{"$f":"M119+$C$19+(F110*$C$18)+M110","v":{"$error":"#DIV/0!"}},"ft",null,null,null,null,null,null,"Check HW = ",{"$f":"V119+$C$19+(Q115*$C$18)+V110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"AF119+$C$19+(Z115*$C$18)+AF110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"AP119+$C$19+(AJ115*$C$18)+AP110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"AZ119+$C$19+(AT115*$C$18)+AZ110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"BJ119+$C$19+(BD115*$C$18)+BJ110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"BT119+$C$19+(BN115*$C$18)+BT110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"CD119+$C$19+(BX115*$C$18)+CD110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"CN119+$C$19+(CH115*$C$18)+CN110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"CX119+$C$19+(CR115*$C$18)+CX110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"DH119+$C$19+(DB115*$C$18)+DH110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"DR119+$C$19+(DL115*$C$18)+DR110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"EB119+$C$19+(DV115*$C$18)+EB110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"EL119+$C$19+(EF115*$C$18)+EL110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"EV119+$C$19+(EP113*$C$18)+EV110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Check HW = ",{"$f":"FD119+$C$19+(EP114*$C$18)+FD110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"FN119+$C$19+(FH115*$C$18)+FN110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"FX119+$C$19+(FR115*$C$18)+FX110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"GH119+$C$19+(GB115*$C$18)+GH110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"GR119+$C$19+(GL115*$C$18)+GR110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"HB119+$C$19+(GV115*$C$18)+HB110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"HL119+$C$19+(HF115*$C$18)+HL110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"HV119+$C$19+(HP115*$C$18)+HV110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"IF119+$C$19+(HZ115*$C$18)+IF110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"IP119+$C$19+(IJ115*$C$18)+IP110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"IZ119+$C$19+(IT115*$C$18)+IZ110","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Check HW = ",{"$f":"JJ119+$C$19+(JD115*$C$18)+JJ110","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"IF(A123=F126,IF(M67>5,\"Approximate Value ...\",\"\"),\"\")","v":""},{"$f":"IF(A123=F126,IF(M67>5,P67,\"\"),\"\")","v":""}]
[{"$f":"IF(C$15<C$20,F123,IF(C16<C19,F131,IF(C$15=C$20,F124,IF(G38>=B39,IF(E78>4,IF(B38>=B39,IF(B$74<C$92,F127,F128),F127),IF(B38>=B39,IF(AND(B69>3.5,E78<=4),IF(B81<C92,F129,F128),IF(B67<C92,F126,F128)),IF(AND(B69>3.5,E78<=4),F129,F126))),IF(B38>=(0.75*B39),N124,IF(B69<=3.5,F126,IF(B67<C120,F126,F125)))))))","v":"Headwater Elevation EQUALS Tailwater Elevation - NO FLOW!"},null,null,null,null,"ERROR!  Headwater Elevation is LESS THAN Tailwater Elevation!",null,null,null,null,null,null,null,{"$f":"IF(E78>4,IF(B74<C105,IF(AND(B38>B39,C92<B74),C92,B74),IF(AND(B38>B39,C92<C105),C92,C105)),IF(AND(E78<=4,B69>3.5),IF(B81<C105,B81,C105),IF(B67<C105,B67,C105)))","v":{"$error":"#DIV/0!"}}]
["Capacity = ",{"$f":"IF(C$15<C$20,\"ERROR\",IF(C16<C19,\"ERROR\",IF(C$15=C$20,0,IF(G38>=B39,IF(E78>4,IF(B38>=B39,IF(B$74<C$92,B74,C92),B74),IF(B38>=B39,IF(AND(B69>3.5,E78<=4),IF(B81<C92,B81,C92),IF(B67<C92,B67,C92)),IF(AND(B69>3.5,E78<=4),B81,B67))),IF(B38>=(0.75*B39),N123,IF(B69<=3.5,B67,IF(B67<C120,B67,C120)))))))","v":0},null,null,null,"Headwater Elevation EQUALS Tailwater Elevation - NO FLOW!",null,null,null,null,null,null,null,{"$f":"IF(E78>4,IF(B74<C105,IF(AND(B38>B39,C92<B74),F128,F127),IF(AND(B38>B39,C92<C105),F128,F130)),IF(AND(E78<=4,B69>3.5),IF(B81<C105,F129,F130),IF(B67<C105,F126,F130)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Open Channel Flow Approximation (Q is APPROXIMATE)"]
[null,null,null,null,null,"INLET CONTROLS (Unsubmerged Equation)"]
[null,null,null,null,null,"INLET CONTROLS (Submerged Equation)"]
[null,null,null,null,null,"OUTLET CONTROLS - Full Flow"]
[null,null,null,null,null,"INLET CONTROLS (Between Submerged and Unsubmerged Average Q Used)"]
["Calculations Completed For the Following Conditions:",null,null,null,null,"OUTLET CONTROLS - \"Part Full\" Equations Used"]
[null,null,null,null,null,"Culvert Outlet Invert Elev MUST Be Less than or Equal to the Invert Elev"]
[null,"Headwater (Upstream Water Surface) Elevation:  ",100," Feet"]
[null,"Culvert Inlet Invert Elevation:  ",null," Feet"]
[null,"Culvert Diameter:   ",null," Inches","Select Culvert Material:  ","CMP_2.67x0.5"]
[null,"Length of Culvert:  ",null," Feet","Select Culvert Inlet Type:  ","Projecting - Thin Edge"]
[null,"Culvert Outlet Invert Elevation:  ",null," Feet"]
[null,"Tailwater (Downstream) Elevation:  ",null," Feet"]
[]
[]
[null,"Conditions Unchanged from Those used for Calculations? ",{"$f":"IF(AND(C132=C15,C133=C16,C134=C17,C135=C18,C136=C19,C137=C20,F134=F17,F135=F18),\"TRUE\",\"FALSE\")","v":"FALSE"}]
[]
["Developed by:   ","Annette A. Humpal, P.E."]
[null,"Hydraulic Engineer"]
[null,"NRCS - Appleton Area Office"]
[null,"2012-04-30"]

{"sheet":"Culvert Data","index":1,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Manning's \"n\" Values:"]
["Culvert Material","\"n\" Value"]
["Concrete",1.2E-2,"Reference:  FHWA \"Hydraulic Design of Highway Culverts\""]
["CMP_2.67x0.5",2.4E-2,"Reference:  FHWA \"Hydraulic Design of Highway Culverts\""]
["CMP_3x1",2.8000000000000001E-2,"Reference:  FHWA \"Hydraulic Design of Highway Culverts\""]
["Welded_Steel",0.01,"EFH 6 IA-46(2)"]
["PVC_Plastic",1.0999999999999999E-2,"Reference:  HY8 User Guide"]
["Corrugated_PE",2.4E-2,"Reference:  HY8 User Guide"]
["Smooth_HDPE",1.2E-2,"Reference:  HY8 User Guide"]
[]
[]
[]
["Culvert Entrance Type:","Source:  FHWA \"Hydraulic Design of Highway Culverts\", Table 12, 1985."]
["Entrance Type","Ke"]
["Projecting - Groove Edge",0.2]
["Projecting - Square Edge",0.5]
["Projecting - Thin Edge",0.9]
["Headwall - Groove Edge",0.2]
["Headwall - Square Edge",0.5]
["Miter/Square/2:1 Slope",0.7]
[]
[]
["Constants for Inlet Control Design Equations",null,"Source:  FHWA \"Hydraulic Design of Highway Culverts\", Table 9, 1985."]
[]
[null,null,null,"Equation","  Unsubmerged Constants",null,"   Submerged Constants"]
["Culvert Shape","Culvert Material","Entrance Type Description","Form","K","M","c","Y"]
[]
["Circular","Concrete","Headwall - Square Edge",1,9.7999999999999997E-3,2,3.9800000000000002E-2,0.67]
["Circular","Concrete","Headwall - Groove Edge",1,7.7999999999999996E-3,2,2.92E-2,0.74]
["Circular","Concrete","Projecting - Groove Edge",1,4.4999999999999997E-3,2,3.1699999999999999E-2,0.69]
["Circular","Concrete","Projecting - Square Edge",null,1.4500000000000001E-2,1.75,4.1200000000000001E-2,0.64,null,"Reference?  Or use the same as headwall - square edge.  See Hydraulic Design of Highway Culverts 3rd sentence of last paragraph on p. 25"]
["Circular","CMP_2.67x0.5","Headwall - Square Edge",1,7.7999999999999996E-3,2,3.7900000000000003E-2,0.69]
["Circular","CMP_2.67x0.5","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75]
["Circular","CMP_2.67x0.5","Projecting - Thin Edge",1,3.4000000000000002E-2,1.5,5.5300000000000002E-2,0.54]
["Circular","PVC_Plastic","Headwall - Square Edge",1,9.7999999999999997E-3,2,3.9800000000000002E-2,0.67,null,"From HY8 User Guide - same as for Concrete Pipe Square Edge with Headwall"]
["Circular","PVC_Plastic","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75,null,"From HY8 User Guide - same as for Corrugated Metal Pipe culvert, Mitered to conform to slope"]
["Circular","Smooth_HDPE","Headwall - Square Edge",1,9.7999999999999997E-3,2,3.9800000000000002E-2,0.67,null,"From HY8 User Guide - same as for Concrete Pipe Square Edge with Headwall"]
["Circular","Smooth_HDPE","Projecting - Thin Edge",1,3.4000000000000002E-2,1.5,5.5300000000000002E-2,0.54,null,"From HY8 User Guide - same as for CMP Projecting - Thin Edge"]
["Circular","Smooth_HDPE","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75,null,"From HY8 User Guide - same as for Corrugated Metal Pipe culvert, Mitered to conform to slope"]
["Circular","Corrugated_PE","Headwall - Square Edge",1,7.7999999999999996E-3,2,3.7900000000000003E-2,0.69,null,"From HY8 User Guide - same as for Corrugated Metal Pipe culvert with Headwall"]
["Circular","Corrugated_PE","Projecting - Thin Edge",1,3.4000000000000002E-2,1.5,5.5300000000000002E-2,0.54,null,"From HY8 User Guide - same as for CMP Projecting - Thin Edge"]
["Circular","Corrugated_PE","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75,null,"From HY8 User Guide - same as for Corrugated Metal Pipe culvert, Mitered to conform to slope"]
["Circular","CMP_3x1","Headwall - Square Edge",1,7.7999999999999996E-3,2,3.7900000000000003E-2,0.69]
["Circular","CMP_3x1","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75]
["Circular","CMP_3x1","Projecting - Thin Edge",1,3.4000000000000002E-2,1.5,5.5300000000000002E-2,0.54]
["Circular","Welded_Steel","Headwall - Square Edge",1,7.7999999999999996E-3,2,3.7900000000000003E-2,0.69]
["Circular","Welded_Steel","Miter/Square/2:1 Slope",1,2.1000000000000001E-2,1.33,4.6300000000000001E-2,0.75]
["Circular","Welded_Steel","Projecting - Thin Edge",1,3.4000000000000002E-2,1.5,5.5300000000000002E-2,0.54]

{"sheet":"Culvert Entrance Conditions","index":2,"n_rows":42,"n_cols":26,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Culvert Entrance Conditions:   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Projecting Groove Edge (Applies only to Concrete Culverts ",null,null,null,null,null,null,null,null,null,null,null,"Projecting Square Edge (Applies to Concrete Culverts for ",null,null,null,null,null,null,null,null,null,null,null,"Projecting Thin Edge (Applies to Corrugated Metal Pipe (CMP), "]
[null,"with the socket end projecting from the fill)",null,null,null,null,null,null,null,null,null,null,null,"non-socket end of the pipe projecting from the fill)",null,null,null,null,null,null,null,null,null,null,null,"Smooth HDPE or Corrugated PE culverts projecting from the fill)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Headwall – Groove Edge (applies to Concrete pipe with the ",null,null,null,null,null,null,null,null,null,null,null,"Headwall – Square Edge (applies to Concrete, CMP, PVC plastic,",null,null,null,null,null,null,null,null,null,null,null,"Miter/Square/2:1 Slope (applies to CMP, PVC plastic, Smooth HDPE or "]
[null,"socket end in combination with a concrete headwall)",null,null,null,null,null,null,null,null,null,null,null,"Smooth HDPE, or Corrugated PE culverts with a concrete ",null,null,null,null,null,null,null,null,null,null,null,"Corrugated PE culverts that are mitered to conform to the slope)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"headwall and a square edge entrance)"]

{"sheet":"Help Information","index":3,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Culvert Analysis'!G1","v":"IaCulvertDesign.xlsm V1.0"},null,null,null,null,null,null,null,null,"2017-12-05"]
["This is the Wisconsin CulvertDesign_1_20_2015.xlsm spreadsheet. "]
["CMP with 3x1 corrugations and Welded Steel Pipe have been added to the list of materials"]
[]
["New User Information:"]
["Note that this spreadsheet was designed using Excel 2007.  If you are using Excel 2003 or earlier, the spreadsheet probably will not work!"]
["If you are using this spreadsheet for the first time, it is important that you install several key Excel Options.  Select the \"Help for Macros\" button below and follow the instructions to install these options."]
[]
["NOTE for Excel 2010:  Be sure that the calculations are set to automatic.  Check this by selecting the following:"]
["     File, Options, Formulas, Calculation options, and then under \"Workbook Calculation\" be sure that \"automatic\" is selected."]
[]
["Limitations of the Culvert Analysis Spreadsheet:"]
["This spreadsheet applies to single Circular Culverts only (not rectangular, elliptical or other shapes)."]
["This spreadsheet should not be used to analyze culverts with bends or slope changes."]
["This spreadsheet applies to concrete (RCP), corrugated metal pipe (CMP), PVC plastic, Smooth HDPE, or Corrugated PE culvert materials."]
["It does not analyze partially filled (with rock or sediment) culverts."]
["The outlet control calculations use the assumption of a 1.0 for the exit coefficient (i.e. the downstream channel velocity is not considered in the exit loss calculations)."]
["Free surface (channel flow) calculations are approximate.  They do not involve a detailed water surface profile analysis…"]
["This spreadsheet does not analyze road overtopping.  "]
["For very high headwater depths (e.g. greater than 15') another method (e.g. HEC-RAS or HY-8) is recommended for analysis."]
[]
["This spreadsheet provides an approximate culvert hydraulic analysis a variety of conditions.  However, it does not include a detailed water surface profile analysis.  "]
["A downstream tailwater elevation must be entered as input data, and the tailwater elevation that is entered may significantly impact the resulting computed culvert capacity. "]
["If a restriction (e.g. another culvert or bridge) is located a short distance downstream of this site, or if detailed water surface profiles are required, another method, such as "]
["HEC-RAS (more complex, but detailed), or HY-8. should be used."]
[]
[]
["Description:"]
["The spreadsheet checks for inlet control (submerged and unsubmerged), outlet control (full flow and part full), and approximate free surface (channel flow) conditions.  "]
["The equations that were used for inlet control (submerged and unsubmerged) and for outlet control (full flow and part full) were taken from Reference 1 below."]
["Calculations are made for each potentially applicable condition;  however, the discharge for the controlling condition is selected and indicated directly below the "]
["input section near the top of the Culvert Analysis sheet.  The controlling condition is also indicated."]
[]
[]
["References: "]
["Hydraulic Design of Highway Culverts, Hydraulic Design Series No. 5, US Department of Transportation, Federal Highway Administration, Revised May 2005"]
["HY8 Federal Highway Administration's Culvert Analysis Program User Guide"]
["US Army Corps of Engineers, Hydrologic Engineering Center (HEC), HEC-RAS, River Analysis System Hydraulic Reference Manual, March 2008"]
[]
[]
[]
[]
[]
[]
[]
["If you are having problems with getting the Macro's to Work in this Spreadsheet, please Select \"Help for Macros\" and Follow the instructions"]

{"sheet":"help for macros","index":4,"n_rows":103,"n_cols":1,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["NEW User Instructions:  for Excel 2007.  If using Excel 2010 see next Tab (Help for Macros Excel 2010)!"]
["Note that this spreadsheet was designed using Excel 2007.  If you are using Excel 2003 or earlier, the spreadsheet probably will not work!"]
["If you are using this spreadsheet for the first time, it is important that you install several key Excel Options!"]
["Note that you do not need \"Administrative Privileges\" to install these options, just follow these instructions:"]
["It would help to print these instructions to use while you are installing these options"]
[]
["Select the Office Button in the upper left corner of the Excel Screen:"]
[]
[]
[]
["When the new window opens, select the “Excel Options” button at the bottom of this window."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select the “Popular” option on the left side of the Excel Options screen and be sure that the option"]
["“Show Developer tab in the Ribbon” is selected:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Then, select “Add‐Ins” option from the Excel Options window:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["At the bottom of the Add‐Ins Window, select “Manage: Excel Add‐ins” and then select “Go” and the"]
["following window will appear:"]
[]
["In this window, select the “Analysis ToolPak”,"]
["“Lookup Wizard” and “Solver Add‐in” and then select"]
["“OK”."]
["Administrative privileges are not needed to “install”"]
["these Excel Add‐ins; however, it may take a minute or"]
["so for these Add‐ins to be loaded."]

{"sheet":"Help for Macros Excel 2010","index":5,"n_rows":103,"n_cols":1,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["NEW User Instructions:  for Excel 2010"]
[]
["If you are using this spreadsheet for the first time, it is important that you install several key Excel Options!"]
["Note that you do not need \"Administrative Privileges\" to install these options, just follow these instructions:"]
["It would help to print these instructions to use while you are installing these options"]
[]
["Select the File Tab Above (on Upper Left) of Excel Screen"]
[]
[]
[]
["When the new window opens, select the “Options” at the lower left of the window"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select “Customize Ribbon” on the left side of the Excel Options window.  When the new window opens,"]
["Look under \"Main Tabs\" on the Right side of the window, and be sure that the box next to \"Developer\" is checked."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Then, select “Add‐Ins” on the left side of the Excel Options window.  Near the bottom of the Add-Ins window, next to the \"Excel Add-ins\""]
["dropdown, select the \"Go…\" button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Be sure that there are checks next to \"Analysis ToolPak\","]
["and “Solver Add‐in” and then select OK."]
[]
["Administrative privileges are not needed to “install”"]
["these Excel Add‐ins; however, it may take a minute or"]
["so for these Add‐ins to be loaded."]