{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","Pipe","Box","Culvert Rating","HW & Outlet Protection","Profile","Design Info"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":2,"defined_names":203,"comments":4,"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":"Intro","index":0,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,1,6,10],[7,1,7,10],[2,1,3,10],[4,1,4,10],[5,1,5,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workbook Protected"]
[null,"CULVERT HYDRAULICS WORKBOOK"]
[]
[null,"MHFD-Culvert, Version 4.01 (April 2025)"]
[null,"Mile High Flood District"]
[null,"Denver, Colorado"]
[null,"www.mhfd.org"]
[]
[null,"Purpose:","This workbook aids in analyzing the flow conditions in circular and box"]
[null,null,"culverts, and calculates the vertical profile along the culvert."]
[]
[null,"Function:","1.  To calculate normal and critical flow conditions in a circular pipe."]
[]
[null,null,"2.  To calculate normal and critical flow conditions in a box culvert."]
[]
[null,null,"3.  To determine headwater depth for a culvert by comparing inlet vs. outlet control."]
[]
[null,null,"4.  To determine the required outlet protection and riprap sizes for a culvert."]
[]
[null,null,"5.  To Determine the vertical profile along the culvert."]
[]
[]
[null,"Content:","The workbook consists of the following sheets:"]
[]
[null,"Pipe","Calculates normal and critical flow conditions in a circular pipe."]
[]
[null,"Box","Calculates normal and critical flow condtions in a box culvert."]
[]
[null,"Culvert Rating","Determines the headwater for a circular or rectangular culvert."]
[]
[null,"HW & Outlet Protection","Determines the headwater and required outlet protection sizes."]
[]
[null,"Profile","Determines the vertical profile of the culvert and soil cover."]
[]
[null,"Design Info","Provides backup data, including values of Manning's n for culvert design."]
[]
[null,"Acknowledgements:","Spreadsheet Development Team:"]
[null,null,"Ken MacKenzie, P.E., Jason Stawski, P.E."]
[null,null,"Mile High Flood District"]
[]
[null,null,"Derek N. Rapp, P.E."]
[null,null,"Peak Stormwater Engineering, LLC"]
[]
[null,null,"Dr. James C.Y. Guo, Ph.D., P.E."]
[null,null,"Professor, Department of Civil Engineering, University of Colorado at Denver"]
[]
[null,null," "]
[null,"Comments?","Direct all comments regarding this spreadsheet workbook to:",null,null,null,null,"MHFD E-Mail"]
[null,"Revisions?","Check for revised versions of this or any other workbook at:",null,null,null,null,"Downloads"]

{"sheet":"Pipe","index":1,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,1,3,5],[4,1,4,5],[2,0,2,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["CIRCULAR CONDUIT FLOW (Normal & Critical Depth Computation)"]
[{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
["Project:"]
["Pipe ID:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Design Information (Input)"]
[null,"Pipe Invert Slope","So =",null,"ft/ft"]
[null,"Pipe Manning's n-value","n =",1.5,{"$f":"IF(Pipe_n=\"\",\"\",IF(AND(Pipe_n>=0.012,Pipe_n<=0.02),\"\",\"*\"))","v":"*"}]
[null,"Pipe Diameter","D =",null,"inches"]
[null,"Design discharge ","Q =",null,"cfs"]
[null,null,null,{"$f":"IF(OR(Pipe_So=\"\",Pipe_n=\"\",Pipe_D=\"\",Pipe_Q=\"\"),0,1)","v":0}]
[null,"Full-Flow Capacity (Calculated)"," "]
[null,"Full-flow area","Af =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",PI()*((Pipe_D/12)^2)/4)","v":""},"sq ft"]
[null,"Full-flow wetted perimeter","Pf =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",PI()*Pipe_D/12)","v":""},"ft"]
[null,"Half Central Angle","Theta =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",PI())","v":""},"radians"]
[null,"Full-flow capacity","Qf =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",1.49/Pipe_n*Pipe_Pf^(-2/3)*Pipe_Af^(5/3)*Pipe_So^0.5)","v":""},"cfs"]
[]
[null,"Calculation of Normal Flow Condition",null,null," "]
[null,"Half Central Angle (0<Theta<3.14)","Theta =",null,"radians"]
[null,"Flow area","An =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",0.25*(Pipe_D/12)^2*(Pipe_ThetaNorm- SIN(Pipe_ThetaNorm)*COS(Pipe_ThetaNorm)))","v":""},"sq ft"]
[null,"Top width","Tn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",(Pipe_D/12)*SIN(Pipe_ThetaNorm))","v":""},"ft"]
[null,"Wetted perimeter","Pn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",(Pipe_D/12)*Pipe_ThetaNorm)","v":""},"ft"]
[null,"Flow depth","Yn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",0.5*(Pipe_D/12)*(1 - COS(Pipe_ThetaNorm)))","v":""},"ft"]
[null,"Flow velocity","Vn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",Pipe_Qn/Pipe_An)","v":""},"fps"]
[null,"Discharge","Qn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",1.49/Pipe_n*Pipe_Pn^(-2 / 3)*Pipe_An^(5/3)*Pipe_So^0.5)","v":""},"cfs"]
[null,"Percent of Full Flow","Flow =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",Pipe_Qn/Pipe_Qf)","v":""},"of full flow"]
[null,"Normal Depth Froude Number ","Frn =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",Pipe_Vn/(32.2*Pipe_An/Pipe_Tn)^0.5)","v":""},{"$f":"IF(Pipe_Input_Boolean=0,\"\",IF(Pipe_FRn>1,\"supercritical\",IF(Pipe_FRn<1,\"subcritical\",\"critical\")))","v":""}]
[]
[null,"Calculation of Critical Flow Condition"]
[null,"Half Central Angle (0<Theta-c<3.14)","Theta-c =",null,"radians"]
[null,"Critical flow area","Ac =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",0.25*(Pipe_D/12)^2*(Pipe_ThetaCrit-SIN(Pipe_ThetaCrit)*COS(Pipe_ThetaCrit)))","v":""},"sq ft"]
[null,"Critical top width","Tc =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",(Pipe_D/12)*SIN(Pipe_ThetaCrit))","v":""},"ft"]
[null,"Critical flow depth","Yc =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",0.5*(Pipe_D/12)*(1 - COS(Pipe_ThetaCrit)))","v":""},"ft"]
[null,"Critical flow velocity","Vc =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",Pipe_Q/Pipe_Ac)","v":""},"fps"]
[null,"Critical Depth Froude Number ","Frc =",{"$f":"IF(Pipe_Input_Boolean=0,\"\",Pipe_Vc/(32.2*Pipe_Ac/Pipe_Tc)^0.5)","v":""}]
[]
[]
[null,{"$f":"IF(Pipe_n_Flag_Boolean=\"*\",\"* Unexpected value for Manning's n\",\"\")","v":"* Unexpected value for Manning's n"}]

{"sheet":"Box","index":2,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,1,3,5],[4,1,4,5],[2,0,2,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["BOX CONDUIT FLOW (Normal & Critical Depth Computation)"]
[{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
["Project:"]
["Box ID:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Design Information (Input)"]
[null,"Box conduit invert slope","So =",null,"ft/ft"]
[null,"Box Manning's n-value ","n =",null,{"$f":"IF(Box_n=\"\",\"\",IF(AND(Box_n>=0.012,Box_n<=0.02),\"\",\"*\"))","v":""}]
[null,"Box Width","W =",null,"ft "]
[null,"Box Height","H =",null,"ft"]
[null,"Design discharge ","Q =",null,"cfs"]
[null,null,null,{"$f":"IF(OR(Box_So=\"\",Box_n=\"\",Box_W=\"\",Box_H=\"\",Box_Q=\"\"),0,1)","v":0}]
[null,"Full-flow capacity (Calculated)"," "]
[null,"Full-flow area","Af =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_W*Box_H)","v":""},"sq ft"]
[null,"Full-flow wetted perimeter","Pf =",{"$f":"IF(Box_Input_Boolean=0,\"\",2*(Box_W+Box_H))","v":""},"ft"]
[null,"Full-flow capacity","Qf =",{"$f":"IF(Box_Input_Boolean=0,\"\",1.49/Box_n*Box_Pf^(-2/3)*Box_Af^(5/3)*Box_So^0.5)","v":""},"cfs"]
[]
[null,"Calculations of Normal Flow Condition",null,null," "]
[null,"Normal flow depth (<H )","Yn =",null,"ft"]
[null,"Flow area","An =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_W*Box_Yn)","v":""},"sq ft"]
[null,"Wetted perimeter","Pn =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_W+2*Box_Yn)","v":""},"ft"]
[null,"Flow velocity","Vn =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_Qn/Box_An)","v":""},"fps"]
[null,"Discharge","Qn =",{"$f":"IF(Box_Input_Boolean=0,\"\",1.49/Box_n*Box_Pn^(-2/3)*Box_An^(5/3)*Box_So^0.5)","v":""},"cfs"]
[null,"Percent of Full Flow","Flow  =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_Qn/Box_Qf)","v":""},"of full flow"]
[null,"Normal Depth Froude Number ","Frn =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_Vn/(32.2 *Box_An/Box_W)^0.5)","v":""},{"$f":"IF(D37=\"\",\"\",IF(D37>1,\"supercritical\",IF(D37<1,\"subcritical\",\"critical\")))","v":""}]
[]
[null,"Calculation of Critical Flow Condition"]
[null,"Critical flow depth","Yc =",null,"ft"]
[null,"Critical flow area","Ac =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_W*Box_Yc)","v":""},"sq ft"]
[null,"Critical flow velocity","Vc =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_Q/Box_Ac)","v":""},"fps"]
[null,"Critical Depth Froude Number ","Frc =",{"$f":"IF(Box_Input_Boolean=0,\"\",Box_Vc/(32.2 *Box_Ac/Box_W)^0.5)","v":""}]
[]
[]
[]
[null,{"$f":"IF(Box_n_Flag_Boolean=\"*\",\"* Unexpected value for Manning's n\",\"\")","v":""}]

{"sheet":"Culvert Rating","index":3,"n_rows":77,"n_cols":63,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,8,0,15],[2,9,2,15],[3,9,3,15],[0,0,0,7],[2,1,2,7],[3,1,3,7],[1,0,1,7],[1,8,1,15]]}
["CULVERT SIZING (INLET vs. OUTLET CONTROL WITH TAILWATER EFFECTS)",null,null,null,null,null,null,null,"CULVERT SIZING (INLET vs. OUTLET CONTROL WITH TAILWATER EFFECTS)",null,null,null,null,null,null,null,null,"Worksheet Protected"]
[{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"},null,null,null,null,null,null,null,{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
["Project: ",null,null,null,null,null,null,null,"Project: ",{"$f":"IF(Culvert_Project=\"\",\"\",Culvert_Project)","v":""}]
["ID:",null,null,null,null,null,null,null,"ID:",{"$f":"IF(Culvert_ID=\"\",\"\",Culvert_ID)","v":""}]
[]
[]
[]
[null,null,null,47187.82]
[null,null,null,null,"X"]
[]
[]
[]
[]
[]
[]
[]
["Design Information (Input):"]
["Circular Culvert:","Barrel Diameter in Inches",null,null,"D =",null,"inches",{"$f":"IF(Culvert_D=\"\",\"\",\nIF(Culvert_D<15,\"Very Small Culvert\",\"\"))","v":""}]
[null,"Inlet Edge Type (Choose from pull-down list)",null,null,null,{"$f":"IF(Culvert_CircularInletEdge_Selection=\"\",\"\",INDEX(Culvert_CircularInletEdge_LIst,Culvert_CircularInletEdge_Selection,1))","v":""},null,{"$f":"IF(Culvert_D=\"\",\"\",\nIF(Culvert_D<15,\"D >= 15 inches expected\",\"\"))","v":""}]
["OR:",null,null,null,null,null,null,{"$f":"IF(Culvert_H=\"\",\"\",\nIF(Culvert_H<1,\"Very Small Culvert\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIRCULAR CULVERT INLET EDGE TYPE"]
["Box Culvert:","Barrel Height (Rise) in Feet",null,null,"H (Rise) =",null,"ft",{"$f":"IF(Culvert_H=\"\",\"\",\nIF(Culvert_H<1,\"Rise >= 1 foot expected\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[null,"Barrel Width (Span) in Feet",null,null,"W (Span) =",null,"ft",{"$f":"IF(Culvert_W=\"\",\"\",\nIF(Culvert_W<1,\"Span >= 1 foot expected\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grooved Edge Projecting",4,"Grv. Proj.",0.2,0.5,0.10878599999999999,0.662381,-0.23380100000000001,5.7958500000000003E-2,-5.5789000000000004E-3,2.05052E-4]
[null,"Inlet Edge Type (Choose from pull-down list)",null,null,null,{"$f":"IF(Culvert_BoxInletEdge_Selection=\"\",\"\",INDEX(Culvert_BoxInletEdge_List,Culvert_BoxInletEdge_Selection,1))","v":""},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grooved Edge in Headwall",5,"Grv. Head.",0.2,0.5,0.11409900000000001,0.65356199999999998,-0.23361499999999999,5.97723E-2,-6.1633800000000004E-3,2.4283200000000001E-4]
[null,null,null,null,null,{"$f":"IF(Culvert_D<>\"\",Culvert_D/12,\nIF(Culvert_H<>\"\",Culvert_H,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beveled Edge (1:1)",6,"1:1 bevel",0.2,0.5,6.3342999999999997E-2,0.76651199999999997,-0.31609700000000002,8.7670100000000001E-2,-9.836951E-3,4.1676000000000001E-4]
[null,"Number of Barrels",null,null,"# Barrels =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beveled Edge (1.5:1)",7,"1.5:1 bevel",0.2,0.5,8.1729999999999997E-2,0.698353,-0.25368299999999999,6.5125000000000002E-2,-7.1974999999999999E-3,3.1245099999999999E-4]
[null,"Inlet Elevation at Culvert Invert",null,{"$f":"IF(Culvert_OE_So<0.5001,ROUND(Culvert_IE-Culvert_OE_So*Culvert_L,2),ROUND(Culvert_OE_So,2))","v":0},"Elev IN =",null,"ft"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge Projecting",8,"Sq. Proj.",0.2,0.5,0.16728699999999999,0.55876599999999998,-0.15981300000000001,4.20069E-2,-3.6925199999999999E-3,1.2516900000000001E-4]
[null,"Outlet Elevation OR Slope",null,{"$f":"IF(Culvert_OE_So<0.5001,ROUND(Culvert_OE_So,4),ROUND((Culvert_IE-Culvert_OE_So)/Culvert_L,4))","v":0},{"$f":"IF(Culvert_OE_So=\"\",\"\", IF(Culvert_OE_So<0.5001,\"So =\",\"Elev OUT =\"))","v":""},null,{"$f":"IF(Culvert_OE_So=\"\",\"\", IF(Culvert_OE_So<0.5001, \"ft/ft\",\"ft\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge with Headwall",9,"Sq. Head.",0.5,0.5,8.7483000000000005E-2,0.70657800000000004,-0.25329499999999999,6.6700099999999998E-2,-6.6165099999999999E-3,2.5061899999999999E-4]
[null,"Culvert Length",null,null,"L =",null,"ft"]
[null,"Manning's Roughness",null,null,"n =",null,{"$f":"IF(Culvert_n=\"\",\"\",\nIF(Culvert_n<0.011,\"For concrete, typically >= 0.011\",\nIF(Culvert_n>0.016,\"For concrete, typically <= 0.016\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOX CULVERT INLET EDGE TYPE"]
[null,"Bend Loss Coefficient",null,null,"Kb  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[null,"Exit Loss Coefficient",null,null,"Kx  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 90 deg. Headwall",1,"square",0.5,0.5,0.122117,0.50543499999999997,-0.10856,2.0780900000000001E-2,-1.36757E-3,3.4560000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 90 deg. Headwall & 15 deg. Flared Wingwall",1,"square",0.5,0.5,0.122117,0.50543499999999997,-0.10856,2.0780900000000001E-2,-1.36757E-3,3.4560000000000001E-5]
[null,{"$f":"IF(OR(Culvert_Barrels=\"\",Culvert_IE=\"\",Culvert_OE_So=\"\",Culvert_L=\"\",Culvert_n=\"\",Culvert_kb=\"\",Culvert_kx=\"\",Culvert_Starting_HWSEL=\"\"),0,\nIF(AND(OR(Culvert_D=\"\",Culvert_CircularInletEdge_Selection=\"\"),OR(Culvert_H=\"\",Culvert_W=\"\",Culvert_BoxInletEdge_Selection=\"\")),0,1))","v":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,"Square Edge w/ 30-75 deg. Flared Wingwall",4,"square",0.4,0.5,7.2492699999999993E-2,0.50708699999999995,-0.117474,2.2170200000000001E-2,-1.4895799999999999E-3,3.8000000000000002E-5]
["Design Information (calculated):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 0 deg. Flared Wingwall",5,"square",0.7,0.5,0.14413300000000001,0.46136300000000002,-9.2150700000000002E-2,2.0002800000000001E-2,-1.3644900000000001E-3,3.5800000000000003E-5]
[null,"Entrance Loss Coefficient",null,null,"Ke =",{"$f":"IF(Culvert_Inputs_Boolean=0,\"\",\nIF(Culvert_D<>\"\",INDEX(Culvert_CircularInletEdge_Table,Culvert_CircularInletEdge_Selection,4),\nINDEX(Culvert_CircularInletEdge_Table,Culvert_BoxInletEdge_Selection,4)))","v":""}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:1 Bevel w/ 90 deg. Headwall",3,"1:1 bevel",0.2,0.5,0.1666086,0.39893529999999999,-6.4039209999999999E-2,1.1201350000000001E-2,-6.4490000000000001E-4,1.4566000000000001E-5]
[null,"Friction Loss Coefficient",null,null,"Kf =",{"$f":"IF(Culvert_Inputs_Boolean=0,\"\",\nIF(Culvert_D<>\"\",(29*(Culvert_n^2)*Culvert_L)/(((PI()*(Culvert_D/12)^2)/4)/(PI()*(Culvert_D/12)))^(4/3),\n(29*(Culvert_n^2)*Culvert_L)/((Culvert_H*Culvert_W)/(2*Culvert_H+2*Culvert_W))^(4/3)))","v":""}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:1 Bevel w/ 45 deg. Flared Wingwall",6,"1:1 bevel",0.2,0.5,9.9563299999999993E-2,0.44124649999999999,-7.4349810000000002E-2,1.273183E-2,-7.5880000000000001E-4,1.774E-5]
[null,"Sum of All Loss Coefficients",null,null,"Ks =",{"$f":"IF(Culvert_Inputs_Boolean=0,\"\",\nCulvert_kb+Culvert_kx+Culvert_ke+Culvert_kf)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5:1 Bevel w/ 90 deg. Headwall",2,"1.5:1 bevel",0.2,0.5,0.1067588,0.45515749999999999,-8.1289509999999995E-2,1.215577E-2,-6.7794009999999996E-4,1.4800000000000001E-5]
[null,"Minimum Energy Condition Coefficient",null,null,"KElow =",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5:1 Bevel w/ 19-34 deg. Flared Wingwall",2,"1.5:1 bevel",0.2,0.5,9.9563299999999993E-2,0.44124649999999999,-7.4349810000000002E-2,1.273183E-2,-7.5880000000000001E-4,1.774E-5]
[null,"Orifice Inlet Condition Coefficient",null,null,"Cd =",null," "]
[]
["Calculations of Culvert Capacity (output):",null,null,{"$f":"IF(OR(ISERROR(F47),ISERROR(F48)),\"Backwater calculations required to obtain Outlet Control Flowrate when HWo < 0.75 * Culvert Rise\",\"\")","v":""}]
[]
[null,"Headwater","Tailwater","Inlet","Inlet","Outlet","Controlling","Flow"]
[null,"Surface","Surface","Control","Control","Control","Culvert","Control"]
[null,"Elevation","Elevation","Equation","Flowrate","Flowrate","Flowrate","Used"]
[null,"(ft)","(ft)","Used","(cfs)","(cfs)","(cfs)"]
[null,null,null,null,null,null,{"$f":"IF(E47=\"\",\"\",\nIF(ISERROR(F47),\nIF(B47>Culvert_IE+0.75*Culvert_Rise,E47,#N/A),\nMIN(E47,F47)))","v":""},{"$f":"IF(ISERROR(G47),#N/A,IF(G47=\"\",\"\",IF(G47=0,\"N/A\",IF(ISERROR(F47),\"INLET\",IF(E47<F47,\"INLET\",\"OUTLET\")))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(ISERROR(G48),#N/A,IF(G48=\"\",\"\",IF(G48=0,\"N/A\",IF(ISERROR(F48),\"INLET\",IF(E48<F48,\"INLET\",\"OUTLET\")))))","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,"Processing Time:"]

{"sheet":"HW & Outlet Protection","index":4,"n_rows":150,"n_cols":64,"rows_kept":150,"cut":false,"hidden":false,"merged":[[1,0,1,10],[130,52,131,52],[130,53,130,61],[3,2,3,10],[4,2,4,10],[107,53,107,61],[107,52,108,52],[2,1,2,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["DETERMINATION OF CULVERT HEADWATER AND OUTLET PROTECTION"]
[null,{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
[null,"Project: "]
[null,"ID: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Soil Type:"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OR(OP_Fr=\"-\",OP_Fr<=1),\"\",\nIF(OP_D<>\"\",\"Supercritical Flow!  Using Adjusted Diameter to calculate protection type.\",\"Supercritical Flow!  Using Adjusted Rise to calculate protection type.\")))","v":""}]
[null,"Design Information:"]
[null,null,"Design Discharge",null,null,"Q =",null,"cfs"]
[]
[null,"Circular Culvert:"]
[null,null,"Barrel Diameter in Inches",null,null,"D =",null,"inches"]
[null,null,"Inlet Edge Type (Choose from pull-down list)",null,null,null,{"$f":"IF(OP_CircularInletEdge_Selection=\"\",\"\",INDEX(OP_CircularInletEdge_List,OP_CircularInletEdge_Selection,1))","v":""}]
[null,"OR:"]
[null,"Box Culvert:",null,null,null,null,"OR",null," "]
[null,null,"Barrel Height (Rise) in Feet",null,null,"H (Rise) =",null,"ft"]
[null,null,"Barrel Width (Span) in Feet",null,null,"W (Span) =",null,"ft"]
[null,null,"Inlet Edge Type (Choose from pull-down list)",null,null,null,{"$f":"IF(OP_BoxInletEdge_Selection=\"\",\"\",INDEX(OP_BoxInletEdge_List,OP_BoxInletEdge_Selection,1))","v":""}]
[]
[null,null,"Number of Barrels",null,null,"# Barrels =",null,null," "]
[null,null,"Inlet Elevation",null,{"$f":"IF(OP_OE_So<0.5001,OP_IE-OP_OE_So*OP_L,OP_OE_So)","v":0},"Elev IN =",null,"ft"]
[null,null,"Outlet Elevation OR Slope",null,{"$f":"IF(OP_OE_So<0.5001,OP_OE_So,(OP_IE-OP_OE_So)/OP_L)","v":0},{"$f":"IF(OP_OE_So=\"\",\"\",IF(OP_OE_So<0.5001,\"So =\",\"Elev OUT =\"))","v":""},null,{"$f":"IF(OP_OE_So=\"\",\"\", IF(OP_OE_So<0.5001, \"ft/ft\",\"ft\"))","v":""}]
[null,null,"Culvert Length"," ",null,"L =",null,"ft"]
[null,null,"Manning's Roughness",null,null,"n =",null,{"$f":"IF(OP_n=\"\",\"\",IF(OP_n<0.011,\"For concrete, this value is typically no less than 0.011\",\"\"))","v":""}]
[null,null,"Bend Loss Coefficient",null,null,"kb ="]
[null,null,"Exit Loss Coefficient",null,null,"kx ="]
[null,null,"Tailwater Surface Elevation",null,null,"Yt, Elevation =",null,"ft"]
[null,null,"Max Allowable Channel Velocity",null,null,"V =",null,"ft/s"]
[null,null,null,null,{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_Yt_Elev=\"\",OP_Yt_Elev-OP_OE>0),\"\",\"Tailwater ELEVATION is less than outlet elevation, using 0.4 x Rise as Yt.\")","v":""}]
[null,"Calculated Results:",null,null,null,null,{"$f":"IF(OR(OP_Q=\"\",OP_Barrels=\"\",OP_IE=\"\",OP_OE_So=\"\",OP_L=\"\",OP_n=\"\",OP_kb=\"\",OP_kx=\"\",OP_V=\"\"),0,\nIF(AND(OR(OP_D=\"\",OP_CircularInletEdge_Selection=\"\"),OR(OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\")),0,1))","v":0}]
[null,null,"Culvert Cross Sectional Area Available",null,null,"A =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",PI()*((OP_D/12)^2)/4,\nOP_H*OP_W))","v":""},"ft2"]
[null,null,"Culvert Normal Depth",null,null,"Yn =",null,"ft"]
[null,null,"Culvert Critical Depth",null,null,"Yc =",null,"ft"]
[null,null,"Froude Number",null,null,"Fr =",null,{"$f":"IF(OP_Fr=\"\",\"\",\nIF(OP_Fr=\"-\",\"Pressure flow!\",\nIF(OP_Fr>1,\"Supercritical!\",\"\")))","v":""}]
[null,null,"Entrance Loss Coefficient",null,null,"ke =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",INDEX(OP_CircularInletEdge_Table,OP_CircularInletEdge_Selection,4),\nINDEX(OP_BoxInletEdge_Table,OP_BoxInletEdge_Selection,4)))","v":""}]
[null,null,"Friction Loss Coefficient",null,null,"kf =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",(29*(OP_n^2)*OP_L)/(OP_Ao/(PI()*(OP_D/12)))^(4/3),\n(29*(OP_n^2)*OP_L)/(OP_Ao/(2*OP_H+2*OP_W))^(4/3)))","v":""}]
[null,null,"Sum of All Loss Coefficients",null,null,"ks =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nOP_kb+OP_kx+OP_ke+OP_kf)","v":""},"ft"]
[]
[null,"Headwater:"]
[null,null,"Inlet Control Headwater",null,null,"HWI =",null,"ft"]
[null,null,"Outlet Control Headwater",null,null,"HWO =",null,"ft"]
[null,null,"Design Headwater Elevation",null,null,"HW =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_HWo=\"N/A\",\nIF(OP_D<>\"\",\nIF(OP_HWi>0.75*(OP_D/12),OP_HWi+OP_IE,\"N/A\"),\nIF(OP_HWi>0.75*OP_H,OP_HWi+OP_IE,\"N/A\")),\nIF(OP_HWi>OP_HWo,OP_HWi+OP_IE,OP_HWo+OP_IE)))","v":""},"ft"]
[null,null,"Headwater/Diameter OR Headwater/Rise Ratio",null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"HW/D =\",\"HW/H=\"))","v":""},{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_HW=\"N/A\",\"N/A\",\nIF(OP_D<>\"\",(OP_HW-OP_IE)/(OP_D/12),\n(OP_HW-OP_IE)/OP_H)))","v":""},{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_HWo=\"N/A\"),\"\",\nIF(OP_HWRatio>1.5,IF(OP_D<>\"\",\"HW/D > 1.5!\",\"HW/H > 1.5!\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OP_HWo=\"N/A\",\"Outlet Control Headwater Approximation Method Inaccurate for Low Flow - Backwater Calculations Required\",\"\")","v":""}]
[null,"Outlet Protection:"]
[null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"Flow/(Diameter^2.5) OR Flow/(Span * Rise^1.5)\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Flow/(Diameter^2.5)\",\"Flow/(Span * Rise^1.5)\"))","v":"Flow/(Diameter^2.5) OR Flow/(Span * Rise^1.5)"},null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Q/D^2.5 =\",\"Q/WH^1.5 =\"))","v":""},{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",(OP_Q/OP_Barrels)/((OP_D/12)^2.5),\n(OP_Q/OP_Barrels)/(OP_W*OP_H^1.5)))","v":""},"ft0.5/s"]
[null,null,"Tailwater Surface Height",null,null,"Yt =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OR(OP_Yt_Elev=\"\",OP_Yt_Elev-OP_OE<=0),\nIF(OP_D<>\"\",0.4*(OP_D/12),0.4*OP_H),\nOP_Yt_Elev-OP_OE))","v":""},"ft"]
[null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"Tailwater/Diameter OR Tailwater/Rise\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Tailwater/Diameter\",\"Tailwater/Rise\"))","v":"Tailwater/Diameter OR Tailwater/Rise"},null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Yt/D =\",\"Yt/H = \"))","v":""},{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",OP_Yt_Height/(OP_D/12),OP_Yt_Height/OP_H))","v":""}]
[null,null,"Expansion Factor",null,null,"1/(2*tan(Θ)) =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_D<>\"\",OP_Circular_EF,OP_Rectangular_EF))","v":""}]
[null,null,"Flow Area at Max Channel Velocity",null,null,"At =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nOP_Q/OP_V)","v":""},"ft2"]
[null,null,"Width of Equivalent Conduit for Multiple Barrels",null,null,"Weq =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_Barrels=1,\"-\",\nIF(OP_D<>\"\",OP_Q/(OP_FlowRatio*(OP_D/12)^1.5),\nOP_Q/(OP_FlowRatio*OP_H^1.5))))","v":""},"ft"]
[null,null,"Length of Riprap Protection",null,null,"Lp =",null,"ft"]
[null,null,"Width of Riprap Protection at Downstream End",null,null,"T =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_Weq=\"-\",\nIF(OP_D<>\"\",ROUNDUP((OP_Lprotection/OP_EF)+(OP_D/12),0),ROUNDUP((OP_Lprotection/OP_EF)+OP_W,0)),\nROUNDUP((OP_Lprotection/OP_EF)+OP_Weq,0)))","v":""},"ft"]
[]
[null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"Adjusted Diameter OR Adjusted Rise (Supercritical Only)\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Adjusted Diameter for Supercritical Flow\", \"Adjusted Rise for Supercritical Flow\"))","v":"Adjusted Diameter OR Adjusted Rise (Supercritical Only)"},null,null,{"$f":"IF(AND(OP_D=\"\",OP_CircularInletEdge_Selection=\"\",OP_H=\"\",OP_W=\"\",OP_BoxInletEdge_Selection=\"\"),\"\",\nIF(OR(OP_D<>\"\",OP_CircularInletEdge_Selection<>\"\"),\"Da =\",\"Ha =\"))","v":""},{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OR(OP_Fr=\"-\",OP_Fr<=1),\"-\",\nIF(OP_D<>\"\",IF(((OP_D)/12+OP_Yn)/2>OP_D,OP_D,((OP_D)/12+OP_Yn)/2),\nIF((OP_H+OP_Yn)/2>OP_H,OP_H,(OP_H+OP_Yn)/2))))","v":""},"ft"]
[null,null,"Minimum Theoretical Riprap Size",null,null,"d50 min=",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OR(OP_Fr=\"-\",OP_Fr<=1),IF(OP_D<>\"\",\n12*0.023*(OP_Q/OP_Barrels)/(OP_Yt_Height^1.2)/((OP_D/12)^0.3),\n12*0.014*(OP_H^0.5)*(OP_Q/OP_Barrels)/(OP_W*OP_Yt_Height)),\nIF(OP_D<>\"\",\n12*0.023*(OP_Q/OP_Barrels)/(OP_Yt_Height^1.2)/OP_Adj_DorH^0.3,\n12*0.014*(OP_Adj_DorH^0.5)*(OP_Q/OP_Barrels)/(OP_W*OP_Yt_Height))))","v":""},"in"]
[null,null,"Nominal Riprap Size",null,null,"d50 nominal=",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_d50_min<6.1,6,\nIF(OP_d50_min<9.1,9,\nIF(OP_d50_min<12.1,12,\nIF(OP_d50_min<18.1,18,\nIF(OP_d50_min<24.1,24,\"-\"))))))","v":""},"in"]
[null,null,"MHFD Riprap Type",null,null,"Type =",{"$f":"IF(OP_Inputs_Boolean=0,\"\",\nIF(OP_d50_min>24, \"Very Big\",INDEX(OP_RiprapType_Table,MATCH(OP_d50_min,OP_RiprapType_d50List,-1),2)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TakeControlFromExcel Boolean"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandy or non-Sandy Soils"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Sandy"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIRCULAR CULVERT INLET EDGE TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grooved Edge Projecting",4,"Grv. Proj.",0.2,0.5,0.10878599999999999,0.662381,-0.23380100000000001,5.7958500000000003E-2,-5.5789000000000004E-3,2.05052E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grooved Edge in Headwall",5,"Grv. Head.",0.2,0.5,0.11409900000000001,0.65356199999999998,-0.23361499999999999,5.97723E-2,-6.1633800000000004E-3,2.4283200000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beveled Edge (1:1)",6,"1:1 bevel",0.2,0.5,6.3342999999999997E-2,0.76651199999999997,-0.31609700000000002,8.7670100000000001E-2,-9.836951E-3,4.1676000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beveled Edge (1.5:1)",7,"1.5:1 bevel",0.2,0.5,8.1729999999999997E-2,0.698353,-0.25368299999999999,6.5125000000000002E-2,-7.1974999999999999E-3,3.1245099999999999E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge Projecting",8,"Sq. Proj.",0.2,0.5,0.16728699999999999,0.55876599999999998,-0.15981300000000001,4.20069E-2,-3.6925199999999999E-3,1.2516900000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge with Headwall",9,"Sq. Head.",0.5,0.5,8.7483000000000005E-2,0.70657800000000004,-0.25329499999999999,6.6700099999999998E-2,-6.6165099999999999E-3,2.5061899999999999E-4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIRCULAR CULVERT EXPANSION FACTOR EQUATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q/D^2.5","Expansion Factor = Ax5+Bx4+Cx3+Dx2+Ex+F  where x = Yt/D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","Yt/D, when EF Levels Off","EF Level Off value","Calc. EF for Yt/D","Min EF",0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5,18666.666666667406,-13454.54545454602,2639.3939393940932,-30.606060606078497,4.8757575757584242,0.3544372294372149,0.3,6.7,{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nIF(OP_TWRatio>BH110,BI110,\nIF(BB110*OP_TWRatio^5+BC110*OP_TWRatio^4+BD110*OP_TWRatio^3+BE110*OP_TWRatio^2+BF110*OP_TWRatio+BG110<$BL$109,$BL$109,\nIF(BB110*OP_TWRatio^5+BC110*OP_TWRatio^4+BD110*OP_TWRatio^3+BE110*OP_TWRatio^2+BF110*OP_TWRatio+BG110>BI110,BI110,\nBB110*OP_TWRatio^5+BC110*OP_TWRatio^4+BD110*OP_TWRatio^3+BE110*OP_TWRatio^2+BF110*OP_TWRatio+BG110))))","v":""},"Yt/D",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",OP_TWRatio)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1948.7179487178926,-2030.3030303029741,528.78787878785749,15.332167832171759,5.1949883449880083,0.35081585081585676,0.4,6.7,"","Q/D^2.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",OP_FlowRatio)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1024.804647417134,-1441.7176910308203,616.69188836293404,-64.356889149901264,6.6014866658019988,0.34431221195984207,0.54,6.7,"","Lower Q/D^2.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nIF(OP_FlowRatio<=1,0.5,\nIF(OP_FlowRatio<=2,1,\nIF(OP_FlowRatio<=3,2,\nIF(OP_FlowRatio<=4,3,\nIF(OP_FlowRatio<=5,4,\nIF(OP_FlowRatio<=6,5,6)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,112.53999384557528,-243.56827467674975,129.29764104681769,-0.7502215294098612,2.3969690368776919,0.3502661938037086,0.64,6.7,"","Upper Q/D^2.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nIF(OP_FlowRatio>5,6,\nIF(OP_FlowRatio>4,5,\nIF(OP_FlowRatio>3,4,\nIF(OP_FlowRatio>2,3,\nIF(OP_FlowRatio>1,2,\nIF(OP_FlowRatio>0.5,1,0.5)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,86.144218613843265,-194.08914561967478,121.67731000420746,-11.447674484620006,3.2456106928734463,0.33677165276370458,0.74,6.7,"","Lower EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nINDEX(OP_CircularEF_Table,MATCH(BL112,BA110:BA116,0),10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,-23.540896376022417,1.0068666203288812,18.211255767633713,1.1043621750540042,2.3526543752174871,0.33951277094264176,0.74,5.15,"","Upper EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nINDEX(OP_CircularEF_Table,MATCH(BL113,BA110:BA116,0),10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,-14.716015859905445,-2.3372485843339095,14.880888310107283,1.8871364704740667,1.0913131776669691,0.3392892562518246,0.74,4.25,"","Interpolated EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_D=\"\"),\"\",\nIF(OR(BL115-BL114=0,BL113-BL112=0),BL114,\nBL114+(BL115-BL114)*((BL111-BL112)/(BL113-BL112))))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOX CULVERT INLET EDGE TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 90 deg. Headwall",1,"square",0.5,0.5,0.122117,0.50543499999999997,-0.10856,2.0780900000000001E-2,-1.36757E-3,3.4560000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 90 deg. Headwall & 15 deg. Flared Wingwall",1,"square",0.5,0.5,0.122117,0.50543499999999997,-0.10856,2.0780900000000001E-2,-1.36757E-3,3.4560000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 30-75 deg. Flared Wingwall",4,"square",0.4,0.5,7.2492699999999993E-2,0.50708699999999995,-0.117474,2.2170200000000001E-2,-1.4895799999999999E-3,3.8000000000000002E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Edge w/ 0 deg. Flared Wingwall",5,"square",0.7,0.5,0.14413300000000001,0.46136300000000002,-9.2150700000000002E-2,2.0002800000000001E-2,-1.3644900000000001E-3,3.5800000000000003E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:1 Bevel w/ 90 deg. Headwall",3,"1:1 bevel",0.2,0.5,0.1666086,0.39893529999999999,-6.4039209999999999E-2,1.1201350000000001E-2,-6.4490000000000001E-4,1.4566000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:1 Bevel w/ 45 deg. Flared Wingwall",6,"1:1 bevel",0.2,0.5,9.9563299999999993E-2,0.44124649999999999,-7.4349810000000002E-2,1.273183E-2,-7.5880000000000001E-4,1.774E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5:1 Bevel w/ 90 deg. Headwall",2,"1.5:1 bevel",0.2,0.5,0.1067588,0.45515749999999999,-8.1289509999999995E-2,1.215577E-2,-6.7794009999999996E-4,1.4800000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5:1 Bevel w/ 19-34 deg. Flared Wingwall",2,"1.5:1 bevel",0.2,0.5,9.9563299999999993E-2,0.44124649999999999,-7.4349810000000002E-2,1.273183E-2,-7.5880000000000001E-4,1.774E-5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOX CULVERT EXPANSION FACTOR EQUATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q/HW^1.5","Expansion Factor = Ax5+Bx4+Cx3+Dx2+Ex+F  where x = Yt/H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","Yt/H, when EF Levels Off","constant EF value","Calc. EF for Yt/H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5,-115918.80341880422,56834.634791970624,-10959.655198839444,1105.291707530454,-20.379126418191415,0.36608578750744414,0.2,6.65,{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nIF(OP_TWRatio>BH133,BI133,\nIF(BB133*OP_TWRatio^5+BC133*OP_TWRatio^4+BD133*OP_TWRatio^3+BE133*OP_TWRatio^2+BF133*OP_TWRatio+BG133<$BL$109,$BL$109,\nIF(BB133*OP_TWRatio^5+BC133*OP_TWRatio^4+BD133*OP_TWRatio^3+BE133*OP_TWRatio^2+BF133*OP_TWRatio+BG133>BI133,BI133,\nBB133*OP_TWRatio^5+BC133*OP_TWRatio^4+BD133*OP_TWRatio^3+BE133*OP_TWRatio^2+BF133*OP_TWRatio+BG133))))","v":""},"Min EF",0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,-9973.614091227606,4723.5220805379504,-592.38749025370885,97.415038489799173,-1.6633699906270187,0.35747499237444647,0.3,6.65,"","Yt/H",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",OP_TWRatio)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,169.27476539392069,-737.70946835831091,477.32669493207538,-59.589590638321489,4.6699815848494035,0.31594093195114836,0.48,6.65,"","Q/WH^1.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",OP_FlowRatio)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,-806.93815987936955,849.65034965039979,-256.16858631567084,40.688502673801757,-0.75874125874145504,0.3470588235293981,0.57999999999999996,6.65,"","Lower Q/WH^1.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nIF(OP_FlowRatio<=1,0.5,\nIF(OP_FlowRatio<=2,1,\nIF(OP_FlowRatio<=3,2,\nIF(OP_FlowRatio<=4,3,\nIF(OP_FlowRatio<=5,4,\nIF(OP_FlowRatio<=6,5,\nIF(OP_FlowRatio<=7,6,\nIF(OP_FlowRatio<=8,7,8)))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,-397.25331428118091,507.85071481666165,-190.04970519676357,34.916001825830762,-1.2283461610627455,0.36207043343653389,0.68,6.65,"","Upper Q/WH^1.5",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nIF(OP_FlowRatio>7,8,\nIF(OP_FlowRatio>6,7,\nIF(OP_FlowRatio>5,6,\nIF(OP_FlowRatio>4,5,\nIF(OP_FlowRatio>3,4,\nIF(OP_FlowRatio>2,3,\nIF(OP_FlowRatio>1,2,\nIF(OP_FlowRatio>0.5,1,0.5)))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,-35.281002032919687,16.92259371623911,23.982504461035472,-4.0716820084840597,0.98994049652958849,0.3533943554538479,0.84,6.2,"","Lower EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nINDEX(OP_BoxEF_Table,MATCH(BL136,BA133:BA141,0),10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,-49.894557365280733,76.816081123526274,-32.478371003072702,9.8374103125756527,-5.6189707004143684E-2,0.36344913667568601,0.9,5.55,"","Upper EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nINDEX(OP_BoxEF_Table,MATCH(BL137,BA133:BA141,0),10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,-39.305424687038553,73.592636555353366,-41.288133726553532,11.460566596100717,-0.1176214119932875,0.3647233201581086,0.95,4.7,"","Interpolated EF",{"$f":"IF(OR(OP_Inputs_Boolean=0,OP_H=\"\"),\"\",\nIF(OR(BL139-BL138=0,BL137-BL136=0),BL138,\nBL138+(BL139-BL138)*((BL135-BL136)/(BL137-BL136))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,-39.305424687038553,73.592636555353366,-41.288133726553532,11.460566596100717,-0.1176214119932875,0.3647233201581086,0.95,4.7,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Riprap Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Very Big"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"VH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"VL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Fabric"]

{"sheet":"Profile","index":5,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,1,3,5],[4,1,4,5],[2,0,2,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["VERTICAL PROFILE FOR THE CULVERT"]
[{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
["Project ="]
["ID ="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Culvert Information (Input)"]
[null,"Barrel Diameter or Height","D or H =",null,"inches"]
[null,"Barrel Length","L =",null,"ft"]
[null,"Barrel Invert Slope","So =",null,"ft/ft"]
[null,"Downstream Invert Elevation","EDI =",null,"ft"]
[null,"Downstream Top Embankment Elevation","EDT =",null,"ft"]
[null,"Upstream Top Embankment Elevation","EUT =",null,"ft"]
[null,"Design Headwater Depth (not elev.)","Hw =",null,"ft"]
[null,"Tailwater Depth (not elev.)","Yt  =",null,"ft"]
[]
[null,"Culvert Hydraulics (Calculated)"]
[null,"Available Headwater Depth","HW-a =",{"$f":"IF(OR(Profile_EUT=\"\",Profile_EUI=\"\"),\"\",Profile_EUT-Profile_EUI)","v":""},"ft"]
[null,"Design Hw/D ratio","Hw/D =",{"$f":"IF(OR(Profile_Hw=\"\",Profile_D_or_H=\"\"),\"\",Profile_Hw/(Profile_D_or_H/12))","v":""}]
[]
[null,"Culvert Vertical Profile"]
[null,"Upstream Invert Elevation","EUI =",{"$f":"IF(OR(Profile_EDI=\"\",Profile_So=\"\",Profile_L=\"\"),\"\",Profile_EDI+Profile_So*Profile_L)","v":""},"ft"]
[null,"Upstream Crown Elevation","EUC =",{"$f":"IF(OR(Profile_EUI=\"\",Profile_D_or_H=\"\"),\"\",Profile_EUI+(Profile_D_or_H/12))","v":""},"ft"]
[null,"Upstream Soil Cover Depth","Upsoil =",{"$f":"IF(OR(Profile_EUT=\"\",Profile_EUC=\"\"),\"\",Profile_EUT-Profile_EUC)","v":""},"ft"]
[null,"Downstream Crown Elevation","EDC =",{"$f":"IF(OR(Profile_EDI=\"\",Profile_D_or_H=\"\"),\"\",Profile_EDI+(Profile_D_or_H/12))","v":""},"ft"]
[null,"Downstream Soil Cover Depth","Dnsoil =",{"$f":"IF(OR(Profile_EDT=\"\",Profile_EDC=\"\"),\"\",Profile_EDT-Profile_EDC)","v":""},"ft"]

{"sheet":"Design Info","index":6,"n_rows":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,0,1,13],[2,0,2,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["DESIGN INFO"]
[{"$f":"Version_Release","v":"MHFD-Culvert, Version 4.01 (April 2025)"}]
[]
["        CIRCULAR (SHAPE = 1) SUMMARY OF SHAPES, MATERIALS, SIZES, & \"n\""]
[]
["Matl   SPANS  NO. OF   DEFAULT  DEF. ENTRANCE   INLET     EQUATION    HDS 5"]
["CODE   (in.)  CULVERTS CORRUG.  \"n\"  (ITYPE)   EDGE (CI)  NUMBER-IC CHT#-SCALE"]
[]
["1-RCP  8-144  29,p96ac         .012  1-Conv   1-sq. proj.     8 (not used)"]
["                                              3-headwall      9        1-1"]
["                                              4-groove        4        1-3"]
["                                              5-groove,hd     5        1-2"]
["                                              6-1:1 bevel     6        3-A"]
["                                              7-1.5 bev.      7        3-B"]
[]
["2-CSP  12-96   17,p49ai 2.7x.5 .024  1-Conv   1-thin          1        2-3"]
["       54-144  16,p50ai 3x1    .028           2-mitered       2        2-2"]
["       54-144  16,p50ai 5x1    .026           3-headwall      3        2-1"]
["       60-312  43,p58ai 6x2    .035           6-1.1 bevel     6        3-A"]
["                                              7-1.5 bevel     7        3-B"]
[]
["3-CAP  12-84   16,p39ka 2.7x.5 .024  1-Conv   (Same as CSP)"]
["       30-120  16,p39ka 3x1    .028"]
["       48-120  13,p39ka 6x1    .025"]
["       60-252  33,p39ka 9x2.5  .035"]
[]
[" ALL   See Inlet Control Procedures  2-Side   1-thin      face, side   56-3"]
["           For Equations               (Cir)  2-square                 56-2"]
["                                              3-bevel                  56-1"]
["                                     3-Side   see box     face, side   58-1/2"]
["                                     4-slope  see box     face, slope  59-1/2"]
[]
["ai = AISI, Handbook of Steel Drainage & Highway Construction Products, 1983"]
["ka = Kaiser Aluminum, Hydraulic Design Detail, DP-131, Edition 2, 1984"]
[]
["EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[1,"thin",0.9,0.5,0.18732099999999999,0.56771000000000005,-0.15654399999999999,4.47052E-2,-3.4360200000000001E-3,8.9660999999999994E-5]
[2,"mitered",0.7,-0.7,0.107137,0.75778900000000005,-0.36146200000000001,0.12339319999999999,-1.6064220000000001E-2,7.6738999999999996E-4]
[3,"headwall",0.5,0.5,0.167433,0.53859500000000005,-0.14937400000000001,3.9154300000000003E-2,-3.4397400000000002E-3,1.15882E-4]
[4,"groove",0.2,0.5,0.10878599999999999,0.662381,-0.23380100000000001,5.7958500000000003E-2,-5.5789000000000004E-3,2.05052E-4]
[5,"grv.hdw.",0.2,0.5,0.11409900000000001,0.65356199999999998,-0.23361499999999999,5.97723E-2,-6.1633800000000004E-3,2.4283200000000001E-4]
[6,"1.1-bev.",0.2,0.5,6.3342999999999997E-2,0.76651199999999997,-0.31609700000000002,8.7670100000000001E-2,-9.836951E-3,4.1676000000000001E-4]
[7,"1.5-bev.",0.2,0.5,8.1729999999999997E-2,0.698353,-0.25368299999999999,6.5125000000000002E-2,-7.1974999999999999E-3,3.1245099999999999E-4]
[8,"sq.-proj.",0.2,0.5,0.16728699999999999,0.55876599999999998,-0.15981300000000001,4.20069E-2,-3.6925199999999999E-3,1.2516900000000001E-4]
[9,"headwall",0.5,0.5,8.7483000000000005E-2,0.70657800000000004,-0.25329499999999999,6.6700099999999998E-2,-6.6165099999999999E-3,2.5061899999999999E-4]
[10,"end-sect.",0.4,0.5,0.120659,0.630768,-0.21842300000000001,5.9181499999999998E-2,-5.99169E-3,2.29287E-4]
[]
["EQ #'s: REFERENCE"]
["  1-10: HY-8 User Manual, FHWA, July 2016, page 46"]
[]
["       BOX (SHAPE = 2) SUMMARY OF SHAPES, MATERIALS, SIZES, & \"n\""]
[]
["Matl   SPAN   RISE    DEF.  ENTRANCE   INLET     EQUATION     HDS 5"]
["CODE   RANGE  RANGE   \"n\"   (ITYPE)   EDGE (CI)  NUMBER-IC  CHT#-SCALE"]
[]
["1-RCB  4'-15' 4'-20' .012   1-Conv    1-square       1        10-1"]
["                                      2-1.5 bev      2        10-3"]
["                                      3-1.1 bev      3        10-2"]
["                                      4-30-75sq      4         8-1"]
["                                      5-90-15sq      1         8-2"]
["                                      6-0 sq         5         8-3"]
["                                      7-1.5 bev      6         9-2"]
["                                      8-bevel        6         9-1"]
[]
["  All  See Inlet Control    2-Side    1&2-square  face, side  58-1"]
["       Procedures For                 3&4-bevel               58-2"]
["       Equations            4-Slope   1&2-square  face, slope 59-1"]
["                                      3&4-bevel               59-2"]
[]
["ac = ACPA, Concrete Pipe Design Manual, February 1985"]
["EQ","EDGE","KE","SR","A","BS","C","DIP","EE","F"]
[1,"square",0.5,0.5,0.122117,0.50543499999999997,-0.10856,2.0780900000000001E-2,-1.36757E-3,3.4560000000000001E-5]
[2,"1.5-bev.",0.2,0.5,0.1067588,0.45515749999999999,-8.1289509999999995E-2,1.215577E-2,-6.7794009999999996E-4,1.4800000000000001E-5]
[3,"1.1-bev.",0.2,0.5,0.1666086,0.39893529999999999,-6.4039209999999999E-2,1.1201350000000001E-2,-6.4490000000000001E-4,1.4566000000000001E-5]
[4,"sq-30/75",0.4,0.5,7.2492699999999993E-2,0.50708699999999995,-0.117474,2.2170200000000001E-2,-1.4895799999999999E-3,3.8000000000000002E-5]
[5,"square",0.7,0.5,0.14413300000000001,0.46136300000000002,-9.2150700000000002E-2,2.0002800000000001E-2,-1.3644900000000001E-3,3.5800000000000003E-5]
[6,"bevel",0.2,0.5,9.9563299999999993E-2,0.44124649999999999,-7.4349810000000002E-2,1.273183E-2,-7.5880000000000001E-4,1.774E-5]
[]
[" EQ #'s: REFERENCE"]
["  1-6: HY-8 User Manual, FHWA, July 2016, page 46"]