Box Culvert Design Excel Sheet Upd Official

Introduction

The sheet uses either:

Effective depth (d): =SlabThickness - Cover - (BarDia/2)
Moment capacity (φMn): =0.9 * As * fy * (d - (As*fy)/(1.7*f'c*b))
Temperature steel: =0.0018 * b * SlabThickness

Why use an Excel sheet?

Soil Parameters:

Unit weight of soil, angle of repose (usually 30°), and safe bearing capacity (SBC). 2. Load Calculations The spreadsheet must calculate several types of pressure: box culvert design excel sheet

Self-weight = γc × volume
Distributed loads from backfill = γb × depth × tributary width

Use TEXTJOIN and & to create a written summary paragraph: "For Q=15 cumecs, a 3m x 2.5m box culvert with Fe500 steel at 150mm c/c in top slab is REQUIRED. Shear OK. Increase bottom slab depth to 450mm." Introduction The sheet uses either:

Limitations:

Haunch Design

: Some templates include specific calculations for haunch portions to reduce pressure at corners. Effective depth (d): =SlabThickness - Cover - (BarDia/2)