Design a 2-cell box culvert, 10 ft span per cell, 8 ft rise, with 4 ft of fill above top slab. HS-20 live load. f’c=4,000 psi, fy=60,000 psi.
: Unit weight of soil, angle of internal friction, and depth of earth fill above the culvert. 2. Load Calculations A robust spreadsheet must account for: Box Culvert Design Example - MnDOT
Let’s simulate a real-world project.
For those, use dedicated software like STAAD, SAP2000, or MIDAS. But for 90% of typical single- or double-barrel culverts under fill, an XLS is perfectly adequate—and often faster.
Enter span, rise, wall thickness (12 inches), top slab thickness (12 inches), bottom slab thickness (12 inches). Box Culvert Design Calculations Xls
Start by establishing the physical dimensions and material strengths. This input data forms the foundation for all subsequent formulas in the spreadsheet. Dimensions : Span, height, and wall/slab thicknesses. Concrete & Steel : Typical concrete strengths range from ), while steel yield strength ( ) is generally ksi for rebar or ksi for welded wire fabric. Unit Weights : Standard values include kcf for reinforced concrete and kcf for soil fill. 2. Perform Hydraulic Analysis
for concrete) to verify that the chosen dimensions can accommodate the design flow. Box Culvert Design Example - MnDOT Design a 2-cell box culvert, 10 ft span
A professional box culvert design spreadsheet isn't just a single table. It should include these interconnected sheets: