Box Culvert Design Excel Sheet <RECENT>

Compute total weight of culvert (concrete + steel) and soil over haunches. Compute uplift = water pressure × base area. Safety factor = weight / uplift. Use IF( <1.2, "FLOTATION RISK", "OK").

Use beam or slab approximations: simple span or continuous as required.

Key formulas (examples):

For walls, compute overturning moments, axial loads, and check combined bending + axial using interaction formulas.

Compute flow area and hydraulic radius for partial/full depth in the rectangular section.

Check allowable flow depth vs available rise and freeboard.

Include debris considerations and minimum slope checks.

Earth and live loads are computed per standard specifications: box culvert design excel sheet

| Load Type | Excel Calculation Method | |-----------|--------------------------| | Earth fill | ( \textVertical pressure = \gamma_s \times H ) (γₛ = soil unit weight, H = fill height) | | Live load (HS‑20 / IRC Class A) | Equivalent uniform load or wheel load distributed through fill (Boussinesq or 2V:1H method) | | Water pressure (inside) | ( \gamma_w \times h_w ) (h_w = depth of water above invert) | | Self‑weight | Auto‑computed from concrete density and member thicknesses | Compute total weight of culvert (concrete + steel)