Box Culvert Design Excel Sheet ((full)) [TRUSTED]

: Checking if the concrete can resist diagonal tension or if stirrups are needed.

Executes moment distribution calculations for all critical load cases.

The sheet must provide clear "PASS" or "FAIL" visual indicators using Excel's Conditional Formatting feature for critical safety checks: Verifies if the concrete's shear capacity ( Vccap V sub c

For buried culverts, lateral pressure from the surrounding soil against the sidewalls is a significant load case. If the water table is above the culvert's base, hydrostatic pressure must also be considered. box culvert design excel sheet

Span, Rise (height), Wall thickness, Slab thickness. Material Properties: Concrete strength ( fckf sub c k end-sub ), Steel yield strength (

Self-weight of top, bottom, and side slabs.

This backend module automatically computes all dead and live loads acting on the structure. Your Excel formulas must compute: : Checking if the concrete can resist diagonal

Acting as a deck slab, the top slab bears the direct impact of moving traffic loads.

Vehicular Live Load (e.g., HL-93) ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ ======================================== <-- Ground Surface Earth Fill ---------------------------------------- ___________Top Slab (Dead Load)_________ | | Lateral | | Lateral Earth | Water Pressure | Earth Pressure | (Internal) | Pressure ---> | | <--- |________________________________________| Bottom Slab ↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑ Base Soil Upward Reaction Dead Loads (DL)

Cushion depth (soil cover over the top slab), live load types (e.g., AASHTO HL-93, IRC Class AA), and water density. Module 2: Load Calculations If the water table is above the culvert's

: Self-weight of the slabs and walls, plus the weight of soil fill or pavement above the culvert.

These walls resist lateral soil pressure and support the top slab. 2. Key Components of a Box Culvert Design Excel Sheet

Calculates the required area of steel ( Astcap A sub s t end-sub

A robust spreadsheet must evaluate several critical load cases to model real-world conditions accurately.

) and provides spacing for main and distribution reinforcement.