Loadingpharmacy7

TUTORIALS

Home » Excel Sheets » RC Design » Reinforced Concrete » Structural » Excel Sheet Box Culvert Analysis and Design A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction.

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.

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. Download 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 mater. 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.

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)

r = square root(x² + y²)

r = square root (1.668 + 1.642)

r = 1.819

Box Culvert Design Excel Sheet Example

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

Box Culvert Design Excel Sheet As Per Irc

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

Total Weight = Total Length x Weight/ft

Download Link Excel File

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

Lecturer: Civil Gyaan

LRFD Box Culvert Program

LRFD Box Culvert is a Mathcad 15 program that allows you to design concrete box culverts, wingwalls, headwalls, and cutoff walls in accordance with the AASHTO LRFD Bridge Specification. Mathcad enables engineers to easily perform, document and share calculation and design results.

• Publisher: Florida Department of Transportation
• Home page:www.dot.state.fl.us
• Last updated: June 13th, 2017

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.

• Publisher: AEC Logic
• Last updated: February 27th, 2014

TxDOT Concrete Box Culvert Analysis Program (CULV5)

CULV5 is an analysis tool for concrete box culverts. The program determines the forces acting on each of the different members of the culvert using the direct stiffness method. The user provides input data for loading conditions, structure geometry, and member sizes.

• Publisher: Texas Department of Transportation
• Home page:www.txdot.gov
• Last updated: August 10th, 2013

Hydrology Studio

Stand-alone software for detention ponds, storm sewers, culvert design, and open channel modeling. Hydrology Studio software is straight-to-the-point and intuitive. Hydrology Studio uses a customizable, on-screen routing diagram that lets you point and click your way through complex watersheds.

• Publisher: Hydrology Studio
• Home page:www.hydrologystudio.com
• Last updated: March 16th, 2016

CONTECH Bridge Solutions Inc. Hydraulic Tools

CONTECH Bridge Solutions Inc. Hydraulic Tools, also known as the Culvert Calculator, provides users with the ability to perform several analyses including: Culvert Calculator; Hydrologic Analysis; Reservoir Routing.The software is a computer program that can be used by engineers and planners to analyze various hydrologic and hydraulic conditions where CONTECH structures may play a role.

• Publisher: CONTECH Bridge Solutions Inc.
• Home page:www.conteches.com
• Last updated: May 24th, 2012

CSS Wizard

CSS Wizard is a web page developing tools set that helps user to create complex web pages without having deep programming skills.User selects the required page layout out of the propossed by the application, by clicking on one of the standard layouts shown or a template masters set. Web page designers can bring in their own projected layouts in XHTML.

• Publisher: Engineering Adventures Ltd
• Home page:www.csswizard.net
• Last updated: May 26th, 2020

CuteDraw

Perfect business and technical diagramming software with rich templates and examples. It is a vector-based graphic design software, quickly create illustrations, documents, manuals, schemas, plans, flow charts, org charts, network diagrams, UML etc.

• Publisher: CuteDraw
• Home page:www.cutedraw.com
• Last updated: May 27th, 2020

Sampling Design Tool

The Biogeography Branch’s Sampling Design Tool for ArcGIS provides users a means to efficiently sample a population, be it people, animals, objects or processes, in a GIS environment. The tool was created for sampling when the population and component sampling units are defined by known dimensions.

• Publisher: Center for Coastal Monitoring and Assessment
• Last updated: June 11th, 2010

Autodesk Design Review

Autodesk Design Review is a CAD viewer that allows you to view, mark up, print, and track changes to 2D and 3D files for free. It supports a variety of file formats, including DWF, DWFx, DWG, and DXF, Adobe PDF, as well as image file types. You can measure, mark up, and review 2D and 3D designs; share changes with your extended team and stakeholders, and more.

• Publisher: Autodesk, Inc.
• Home page:www.autodesk.com
• Last updated: July 2nd, 2020

SoC Embedded Design Suite

With Altera's Soc Embedded Design Suite (SoC EDS), you get all the tools you need to work more productively, improve software quality, and ultimately get to market faster.Main features:- Expedite SoC embedded systems development with utility programs and run-time software.- Jump start development with bare-metal and Linux application examples.

• Publisher: Altera Corporation
• Home page:www.altera.com
• Last updated: June 29th, 2015

Autodesk Design Review 2012

Autodesk®Design Review is a free program used for creating and reviewing DWF files. An open, published, and secure file format developed by Autodesk, DWF enables you to combine and publish rich 2D- and 3D-design data and share it with others. Design Review enables your entire project or product team to view, print, measure, and markup DWF, DWG, DXF, PDF.

• Publisher: Autodesk, Inc.
• Home page:usa.autodesk.com
• Last updated: February 27th, 2012

UniPDF

UniPDF can convert PDF documents into Word documents, images, plain text and HTML. It supports batch conversion and you can add files to the list by dropping them into the application’s interface. However, the UniPDF tool doesn't offer any advanced settings.

• Publisher: UniPDF.com
• Home page:www.unipdf.com
• Last updated: June 16th, 2021

DreamPlan Home Design Software

DreamPlan Home Design Software allows you to create the floor plan of your house, add wall, roof, ceiling, floor, etc. and arrange furniture inside rooms. You can also set custom colors, textures, decorations, and other items. This tool can create a 3D rendering of your design quickly.

• Publisher: NCH Software
• Home page:www.nchsoftware.com
• Last updated: April 11th, 2021

Aleo Flash Intro Banner Maker

Aleo Flash Intro Banner Maker could not have a more descriptive name. This program is mainly intended to create Flash banners for webpages. Luckily, there is a floating preview window that displays all the changes in real time. It lets you generate the necessary HTML code and save the banner as a Flash movie, an animated GIF and even an AVI video.

• Publisher: Aleo Software, Inc.
• Home page:www.aleosoft.com
• Last updated: September 26th, 2014

Autodesk Design Review Browser Add-on

The Autodesk Design Review Browser Add-in for Autodesk Design Review software lets you view DWF files using Mozilla Firefox and Google Chrome for the Windows operating system. Now, you can view embedded DWF files in Firefox and Chrome much the same way as you do in the Microsoft Internet Explorer browser.

• Publisher: Autodesk
• Home page:usa.autodesk.com
• Last updated: March 24th, 2011

DP Animation Maker

DP Animation Maker can help you design your own animated wallpapers, screensavers, and banners. The program has a straightforward interface so it is unlikely you have any difficulty to use it even if it is your first time. Yet, if you want to exploit all its features, it is a good idea to consult its online help documentation. Moreover, it is great that it comes with various examples.

• Publisher: DesktopPaints
• Home page:www.animationsoftware7.com
• Last updated: April 23rd, 2021

Adobe CS6 Design and Web Premium

Adobe Creative Suite 6 Design & Web Premium is the ultimate toolkit for professional design and web development. Craft compelling graphics and images, lay out high-impact print pages, build HTML5/CSS3 websites, and design for tablets and smartphones — all with greater speed and precision than ever before.

• Publisher: Adobe Systems Incorporated
• Home page:www.adobe.com
• Last updated: June 3rd, 2012

123D Design

123D Design is a free, powerful, yet simple 3D creation and editing tool which supports many new 3D printers. It allows you to create complex objects starting from basic shapes or sketches. These objects can then be 3D printed or manufactured with CNC, laser cutters, water jet cutters, etc.

• Publisher: Autodesk, Inc.
• Last updated: December 6th, 2016