Box Culvert Design Excel Sheet Fix Jun 2026

Vertical Live Load (Traffic) ▼ ▼ ▼ ▼ ▼ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ◄--- Soil Overburden ======================================= |┌───────────────────────────────────┐| Lateral ──►|│ Top Slab │|◄─── Lateral Earth Earth |│ │| Pressure + Surcharge Pressure |│ │| |│ Wall Wall│| |│ │| |│ │| |│ Bottom Slab │| |└───────────────────────────────────┘| ======================================= ▲ ▲ ▲ ▲ ▲ Soil Base Reaction Vertical Loads Self-weight of concrete components based on a density of Earth Fill/Overburden ( DLecap D cap L sub e ): Weight of the soil column above the top slab. Live Load ( LLcap L cap L

Create a dedicated, color-coded area for user input (e.g., blue cells for input, black for calculated). box culvert design excel sheet

Use a (What-If Analysis) to vary B and D until computed Q ≥ required Q. Vertical Live Load (Traffic) ▼ ▼ ▼ ▼

Include comments in formula cells explaining units and assumptions. Include comments in formula cells explaining units and

Use z = fs * (dc * A)^(1/3) . Must be < 30 kN/mm for moderate exposure.

Linking Excel to FEA software for advanced analysis. D. Design and Reinforcement Module