Box Culvert Design Excel Sheet

17-09-2021 admin

Box Culvert Design Excel Sheet Software
Culvert Design Example

Sheet Pile Wall, with Tieback Anchors, Design Based on AASHTO (HB-17), 2018 IBC & ACI 318-19: 43: Screw Piles: Screw Pile Design Based on 2018 IBC & AISC 360-16: 44: PT-Slab on Ground: Design of PT Slabs on Expansive Soil Ground Based on PTI DC10.5-12 & PTI 3rd Edition: 45: Under Footing Sewer: Underground Utilities Way Design Based on AASHTO. Jun 25, 2021 The files accessible by the links below are identical to those accessed through Word, Excel or other software application by MoDOT employees. Many of these file links are also contained in Engineering Policy Guide articles that refer to the forms.

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

Concrete Box Culvert Design Spreadsheet Based on AASHTO 17th & ACI 318-14. Concrete box culverts are available with spans varying from 6 to 16 feet and rises varying from 4 to 14 feet. Standard precast concrete box culverts are typically fabricated in 6 foot sections; however larger boxes are fabricated in 4 foot sections to reduce section weight.
For more widths this design spreadsheet can not be used since it is possible that two axle loads come on the culvert. GN OF SINGLE CELL BOX CULVERT SHTO LRFD Bridge Design 2007 SI Ali Akbar Shaikhzadeh Date: 1-Jul-12 Revision: Version 1.0 Design Summary O.K. Design Based on → (AASHTO 3.6.1.2.6) Traffic travelling parallel to span.
Structural Design Program for designing RCC beams and slabs; Download estimating sheet for road construction; How to estimate construction quantities of materials for concrete; Download a bar bending schedule of Box Culvert; How to earth calculation through excel sheet; How to design a column in Excel; How to design two-way slab through Finite.

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.

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

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.

References

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

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

A lot of structural Engineers are available in this forum who can have good sound knowledge in the structural field. We normally do the analysis using software like Staad Pro or ETABS. Some Engineers use comonent design of RCC using SAFE or some commercial software. Most of the engineers prefer Excell spread sheet for component design of RCC. In this forum many of them contribute many rcc excell sheets. They are scattered and not effectively used by many of the SAFIANS. It is suggested to post in sticy Excell sheet for RCC Design. Many of the Engineers can contribute more on Excell sheet they validated or they followed in their day to day use. As a start, I attached herewith simple design of Box culvert, which is modelled by simple model in Staad Pro using manual calculation.
V.M.RAJAN.