Culvert Design Excel Sheet — Box

A robust Excel sheet for box culvert design should include the following tabs or sections: 1. Input Data

against code-mandated minimum steel ratios to prevent brittle cracking. box culvert design excel sheet

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 A robust Excel sheet for box culvert design

Calculates required Area of Steel (As) for moment and shear. Live Load ( LLcap L cap L Calculates

Height of backfill, live load intensity. 2. Loading Calculations

Note that this is a basic outline, and you will need to add more details and complexity to create a comprehensive and accurate box culvert design Excel sheet. Additionally, you should verify the calculations and assumptions used in the Excel sheet with hand calculations and/or other software to ensure accuracy and validity.