Box Culvert Design Excel Sheet

There are many types of construction available in the construction industry; bridge construction is one of them. It is also a part of structural engineering. Bridge mainly builds on the basis of prior imaginary structure.

There are also different kinds of bridges having different kind of structure. Structural engineers or bridge engineers often face difficulties to design structural elements. It is not always possible to design structures with the help of basic bridge structure software. Here the bridge design and analysis spreadsheet comes in handy for the engineers who are associated with bridge engineering.

To achieve quick summary of divergent sections and parts of diversified bridges, the bridge design excel sheet is made. This spreadsheet is particularly aimed for creating the design of different sectors and elements of bridge in accordance with the necessity of engineers.

Here is an important and beneficial list of excel sheets for engineers and construction specialists.

This bridge design excel sheet contains 11 individual excel sheets which are supported with the most recent codes like ACI, AASHTO LRFD, and so on.

Here we shared 11 excel sheets for design of bridge-design. Bridge Concrete Girder. Bridge Concrete Column. Bridge Box Section. Concrete Tunnel. Concrete Box Culvert. Steel Road Plate. Flange Tapered Girder. Prestressed Concrete Pole/Pile. Box Culvert Design Spreadsheet Excel ที่เขียนขึ้นเพื่อวิเคราะห์และออกแบบกล่องคอนกรีต culverts. 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. It’s a structure that carries water above land is known as. Box culvert design excel sheet there are more than 1.2 billion websites worldwide, according to netcraft January 2020 web server survey. Consequently, there is digital abundance — consumers looking for a specific product or service typically have hundreds (or thousands) of websites to choose from. With this saying, it is more.

The detailed specifications of these spreadsheets are as follows:

  • Bridge Concrete Girder: Prestressed Concrete Girder Design for Bridge Structure supported with AASHTO 17th Edition & ACI 318-11. (Download)
  • Bridge Concrete Column: Bridge Column Design supported with AASHTO 17th & ACI 318-11. (Download)
  • Bridge Box Section: Bridge Design for Prestressed Concrete Box Section supported with AASHTO 17th Edition & ACI 318-11. (Download)
  • Concrete Tunnel: Concrete Tunnel Design supported with AASHTO-17th & ACI 318-11. (Download)
  • Double Tee: Prestressed Double Tee Design supported with AASHTO 17th Edition & ACI 318-11. (Download)
  • Concrete Box Culvert: Concrete Box Culvert Design supported with AASHTO 17th Edition & ACI 318-11. (Download)
  • Steel Road Plate Steel Road Plate Design supported with AASHTO 17th Edition & AISC 360-10 through Finite Element Method. (Download)
  • Flange Tapered Girder: Flange Tapered Plate Girder Design supported with AISC Manual 14th Edition (AISC 360-10). (Download)
  • Prestressed Concrete Pole/Pile: Prestressed Concrete Circular Hollow Pole/Pile Design supported with ACI 318-11 & AASHTO 17th. (Download)
  • Falsework: Falsework Design for Steel Girder Bridge supported with NDS 2012 & AASHTO 17th. (Download)
  • Polygon Capacity: Polygon Section Member (Tubular Steel Pole) Design supported with ASCE 48-11. (Download)

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.

Box

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.

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 m3/s – S.I.)
  • A = cross-sectional area of culvert (ft2 – U.S. or m2 – 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.

Box Culvert Design Excel Sheet Template

Pipe Culvert Outlet Control Design Calculations

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

Box Culvert Design Excel Sheet Is 456

Where:

  • hL = the head loss in the culvert barrel for full pipe flow (ft – U.S. or m – S.I.)
  • Ku = 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 (ft2 – U.S. or m2 – 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

Spreadsheet

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.