Double Box Culvert Design Excel Sheet -

Box Culvert Design and Components Guide | PDF | Bridge - Scribd

: The internal width and height of a single cell (e.g.,

However, the structural design of a double box culvert is notoriously complex. It involves analyzing a statically indeterminate frame subjected to varying loads—earth pressure, live loads, surcharge, and hydraulic pressure. This complexity often leads to time-consuming calculations. This is where the becomes an indispensable tool. double box culvert design excel sheet

Most double box culvert Excel sheets follow one of these codes:

To design a double box culvert using an Excel sheet, you must input key geometric and material data to automate the calculation of loads, structural analysis (often via the ), and reinforcement requirements . 1. Geometric Inputs Box Culvert Design and Components Guide | PDF

| Category | Parameter | |----------|------------| | Geometry | Clear span of each box (L), total rise (H), thickness of top slab (t_t), bottom slab (t_b), outer wall (t_w), interior wall (t_iw) | | Earth cover | Height of fill above top slab (h_fill) | | Material | Concrete compressive strength (f'c), steel yield strength (fy) | | Loads | Live load (e.g., HL-93 or IRC Class A/R), soil unit weight (γ), saturated weight (γ_sat), surcharge | | Safety factors | Load factors per code (e.g., 1.25 DL, 1.75 LL) |

| Check | Excel Implementation | |-------|----------------------| | Flexural reinforcement | As = Mu / (φ × fy × 0.9d) (iterative for tension-controlled section) | | Minimum steel | 0.0018 × b × h (temperature & shrinkage) | | Shear reinforcement | φVc > Vu → none; else stirrups spaced via s = (φ Av fy d) / (Vu - φVc) | | Crack control | z = fs × (dc × A)^(1/3) ≤ 170 kN/mm (for exposure) | This is where the becomes an indispensable tool

Best for advanced users. Solve [K]D = F using MINVERSE and MMULT in Excel (requires array formulas).

A double box culvert is statically indeterminate to 6th degree. In Excel, avoid finite element – use: