Step 1 of 2
Please select a membership then provide your email and desired password for your account.
This article serves as a comprehensive guide to understanding, creating, and utilizing an Excel-based design tool for box culverts. We will cover the theoretical foundations, step-by-step spreadsheet architecture, key formulas, and best practices to ensure your designs are both safe and economical.
Instantly recalculates moments, shears, and steel areas when you change dimensions.
However, Excel is not a panacea. For large, multi-cell, or geometrically complex culverts, or for projects that require full adherence to the latest AASHTO LRFD specifications, dedicated software such as PENNDOT BOX5, BRASS-CULVERT, STAAD.Pro, or MIDAS Civil is likely a better investment in both time and safety. Many engineers find the optimal workflow in a hybrid model: using STAAD.Pro for structural analysis while relying on an Excel spreadsheet for loading computations, code checks, and detailing.
Using Excel’s built-in functions like GOAL SEEK or iterative circular references, the engineer can quickly determine the required height and width of the culvert barrel. The sheet can automatically compute flow velocities, Froude numbers, and headwater elevations. Drop-down menus can select between different inlet edge conditions (e.g., square-edge, rounded) with corresponding coefficients stored in a lookup table. This allows the designer to test multiple scenarios—changing barrel sizes or slopes—in seconds, ensuring the hydraulic performance meets regulatory requirements before any structural calculation begins.
A professional-grade Excel sheet typically includes the following sections: : Geometric Data : Clear span ( ), clear height (
Uniform or trapezoidal pressure distribution acting on the bottom slab. 3. The Design Methodology Workflow
) without requiring shear stirrups, which are difficult to install in thin culvert slabs. Step 5: Crack Width and Deflection Checks (SLS)
: Generates construction drawings for cast-in-place box culverts; a free download is available.
Checking if the thickness is adequate to avoid shear reinforcement. Reinforcement Calculation: Determining area of steel ( Ascap A sub s