With the internal forces known, the final step is to design the steel reinforcement to resist them.
| Spreadsheet Name | Primary Function & Features | Key Code Basis | Download Source | | :--- | :--- | :--- | :--- | | | Comprehensive structural design for concrete box culverts, covering load calculation, analysis, and reinforcement design. | AASHTO 17th Ed., ACI 318-14 | The Engineering Community | | Reinforced Concrete Box Culvert Calculation Spreadsheet | General-purpose calculation and dimensioning tool for box culverts. | General | The Engineering Community | | Structural Design of Single Cell Box Culvert Spreadsheet | Focused specifically on the analysis and design of single-cell box culverts. | General (Refer to sheet) | The Engineering Community | | BOXFRAME - Concrete Box Frame Analysis Spreadsheet | Analyzes internal forces (moments, shears, axial loads) in buried concrete box frames. Has worksheets for equal/unequal slab thicknesses. | General moment distribution methods | ExcelCalcs | | Concrete Box Culvert Analysis and Design Spreadsheet | Performs both analysis (force determination) and design (reinforcement selection) of concrete box culverts. | AASHTO & ACI | The Engineering Community | | Box Culvert Design – Longitudinal Section Spreadsheet | Aids in the preliminary design and dimensioning of the longitudinal section of a box culvert. | N/A (Preliminary design) | The Engineering Community | | Culvert Rate Analysis Spreadsheet | Used for cost estimating and rate analysis of culvert construction. | N/A (Cost estimation) | The Engineering Community | | Estimate of Box Culvert | Bar Bending Schedule (BBS) | Automatically generates a Bar Bending Schedule from given parameters. | N/A (Reinforcement detailing) | Construction Civil Engineering |
To simplify the design process, engineers and designers can use a box culvert design calculations XLS spreadsheet. This spreadsheet provides a comprehensive framework for performing hydraulic, structural, and geotechnical calculations. box culvert design calculations xls link
Geometry Inputs⟶Load Compilation⟶Frame Analysis⟶Section Capacity Check⟶Final ReportGeometry Inputs ⟶ Load Compilation ⟶ Frame Analysis ⟶ Section Capacity Check ⟶ Final Report
A comprehensive worksheet usually contains the following sections: With the internal forces known, the final step
Simple automated diagrams showing bar spacing, concrete cover, and lap splice lengths. 4. Finding Reliable XLS Design Links
Maximum vertical load, minimum lateral load (max bending in top/bottom slabs). | General | The Engineering Community | |
| Calculation | Formula / Method | |-------------|------------------| | Normal depth in culvert | Manning: ( Q = \frac1n A R^2/3 S^1/2 ) solved iteratively | | Inlet control headwater | ( HW/D = c + k \cdot \fracQA\sqrtgD ) (FHWA) | | Earth pressure at depth z | ( p = K_a \cdot \gamma_s \cdot z ) | | Live load from wheel load | ( \textPressure = \fracP(LLDF \times spread)^2 ) | | Moment in top slab (fixed ends) | ( M_neg = \fracw L^212 ), ( M_pos = \fracw L^224 ) (simplified) | | Required steel area | ( A_s = \fracM_u\phi f_y (d - a/2) ) | | Crack width (service) | Gergely‑Lutz or ACI 224R |
Structural and hydraulic designs must comply with regional engineering standards. The most widely accepted codes include: