Concrete Box Culvert analysis and Design Spreadsheet A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction. Typically embedded so as to be surrounded by soil, a culvert may be made from a pipe, reinforced concrete or other material. AEC 3D Culvert-Box. AEC 3D Culverts-Box is a solution helping civil engineers to quickly design and plan box type cross drainage structures or minor bridges for highway/canal projects. It offers a wide range of sophisticated features for precise design, planning, analysis and production of 3D/2D drawings.

TUTORIALS

In the reinforcement, there are top slab, bottom slab and outside walls.

Box culvert typical section (6x7), where 6 are inside length and 7 is inside height. Top slab has top main bar and bottom main bar.

Dots signify distribution bars. Bottom slab has top main bar and bottom main bar. Dots signify distribution bars. There’re outside walls with vertical main bars. Dots indicate distribution bars.

There’re bars at 45 degree, known as haunch bars. Wall thickness is 10 inches. Top bar size is #4 @ 6” centre to centre. Bottom bar size is #5 @ 6” centre to centre. Haunch size is #4 @ 12” centre to centre. Cross-section distribution bars are # 4 @ 12” centre to centre. Vertical bars are # 4 @ 6” centre to centre. Top bars are # 4 @ 6” centre to centre. Bottom bars in bottom slab are # 5 @ 6” centre to centre. Bottom slab is slightly bigger than top slab.

Horizontal length = length – concrete cover

Band is according to slab thickness.

Slab thickness = 10”

Concrete cover (from top and bottom) is 2”

3” band cover is considered

Cut length = length – (2 x concrete cover)

Top bar length = 7.67’

Band = 3”

1’ offset

Concrete cover = 2”

Culvert length = 20’ Box culvert typical section (6 x 7)

Box Culvert Design Excel Sheet Free

Express scribe 5.63 registration code. r = square root(x² + y²)

r = square root (1.668 + 1.642)

r = 1.819

Haunch bar total length = 0.5 + 0.5 + 1.819 = 2.819

Numbers = (length – 2 x concrete cover)/spacing + 1

Diameter and length are same in case of distribution bars. [Calculated single time]

Diameter is different in case of top and bottom main bars. [Calculated separately]

Total Length = Bar Length x Numbers x Rows

Weight = d²/52.896

Box culvert design excel sheet printable

Total Weight = Total Length x Weight/ft

Download Link Excel File

To get more clear idea, go through the following video tutorial.

Lecturer: Engr WASEEM RAJA

Where to get a circular pipe culvert design spreadsheet

For pipe culvert design spreadsheets in either U.S. or S.I. units, click here to visit our spreadsheet store. Obtain convenient, easy to use spreadsheets for culvert design calculations at reasonable prices. Read on for information about the use of Excel spreadsheets for circular culvert design.

Inlet Control and Outlet Control for a Pipe Culvert Design Spreadsheet

One of the general conditions for pipe culvert design calculations is inlet control, in which the flow rate through the culvert is controlled at the inlet end of the culvert by the culvert diameter and other inlet conditions. The other general condition is outlet control, in which the flow rate is controlled by the outlet conditions and the entire length of the culvert.

Box Culvert Design Excel Sheet Pdf

Pipe Culvert Inlet Control Design Spreadsheet Calculations

An equation that relates culvert parameters for inlet control conditions in a pipe culvert design spreadsheet is:

where:

HW = headwater depth above inlet invert (ft – U.S. or m – S.I.)
D = inside height of the culvert (ft – U.S. or m – S.I.)
Q = discharge (cfs – U.S. or m³/s – S.I.)
A = cross-sectional area of culvert (ft² – U.S. or m² – S.I.)
S = culvert slope (dimensionless)
K1 = 1.0 for U.S. units or 1.811 for S.I. units
Ks = slope constant = -0.5 for a non-mitered or + 0.7 for a mitered inlet
Y and c are constants dependent on the type of culvert and type of inlet.

Pipe Culvert Outlet Control Design Calculations

Box Culvert Design Excel Sheet

An equation that relates culvert parameters for outlet control conditions in a pipe culvert design spreadsheet is:

Where:

h_L = the head loss in the culvert barrel for full pipe flow (ft – U.S. or m – S.I.)
K_u = 29 for U.S. units or 19.63 for S.I. units
n = Manning roughness coefficient for the culvert material
L = length of the culvert barrel (ft – U.S. or m – S.I.)
R = hydraulic radius of the full culvert barrel = A/P (ft – U.S. or m – S.I.)
A = cross-sectional area of the culvert barrel (ft² – U.S. or m² – S.I.)
P = perimeter of the culvert barrel, ft or m
V = velocity in the culvert barrel, ft/sec or m/s
Ke = loss coefficient for pipe entrance

A spreadsheet screenshot for pipe culvert design calculations

The Excel spreadsheet screenshot below shows part of a spreadsheet for circular culvert design calculations based on inlet control. Based on the indicated input values, the spreadsheet will calculate the minimum required pipe culvert diameter and the headwater depth for the next larger standard culvert diameter.

For low cost, easy to use spreadsheets to make these calculations in S.I. or U.S. units, click here to visit our spreadsheet store.

Box Culvert Design Excel Sheet Design

References

1. Hydraulic Design of Highway Culverts,Third Edition, Publication No. FHWA-HIF-12-026, U.S. DOT/Federal Highway Administration, April, 2012.

Double Box Culvert Design Excel Sheet

2. Bengtson, Harlan H., “Spreadsheets for Circular Culvert Design.”, an online article.