Box Culvert Design Excel Sheet File

When the water table is above the bottom slab, uplift can exceed the structure's weight. Add a check: Uplift force < Total weight + Soil friction.

Ensure HW/D < 1.2 for inlet control to avoid excessive pressure flow.

  • 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.

    • 1. Flexure (Top Slab): Mu = (w * L_eff^2) / 10 (for fixed ends) Steel area: As = Mu / (0.9 * fy * 0.9d)

    2. Shear: Vu = w * L_eff / 2 Check Vu < φ * 0.17 * sqrt(f'c) * b * d box culvert design excel sheet

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

    4. Corner Reinforcement (Haunches): The corner joints are critical. Excel must check the required development length and corner moment reversal.

    Keep all raw inputs in a single clearly labeled block and use named ranges (e.g., Q_design, span, rise, f_c). When the water table is above the bottom

    Given the design discharge ((Q)), the sheet solves Manning’s equation for full or partially full flow:

    [ Q = \frac1n A R^2/3 S^1/2 ]

    Where:

    The sheet will also check inlet control (using nomograph equations) vs. outlet control (headwater depth). The governing headwater elevation determines the required barrel size.

    To truly rank for "box culvert design excel sheet," you need features that save time: