top of page
Search
tersbravisge1984

Box Culvert Design Spreadsheet Download







































For some time, we have been hearing about the need to update the design of box culverts. The Box Culvert Design Spreadsheet is a one-page document that can help engineers and designers understand what makes a good box culvert design. This spreadsheet contains pressures at section through walls, roof thicknesses, and depths of spans. It also has formulas for calculating spans and lengths for smaller entries and exits (9ft-9ft). It does not contain all of the formulas for the design of box culverts. If you want to include any of the formulas, install a copy of Excel and run the spreadsheet in that program. The spreadsheet is setup with and works best in Microsoft Excel 2010 (and later). You can download a copy of Excel from Microsoft free here: http://office.microsoft.com/en-us/excel-homepage/. I do not own any rights to this spreadsheet or any part of it. This document is provided solely for reference and educational purposes . I have done my best to check all errors but accept no responsibility if you use it inappropriately. I have modeled the spreadsheet around the way that I design box culverts, but your design practices may differ. Please use your best judgment before using this spreadsheet. One of the big problems with box culvert design is that it relies on a lot of tables and hand calculations. This works fine when you are designing a few box culverts, but it can be difficult to manage if you are working on a large project or if you have staff trying to design too many at once. In this case, I created a spreadsheet that will allow engineers and designers to input data quickly and easily into a single worksheet. This spreadsheet will enable you to set up your box culvert design quickly and easily. A lot of thought went into the design of this spreadsheet. It has six primary worksheets to help you design the following: An example of how to use the spreadsheet can be found here. This is not a complete example for every scenario, just an example that gets you started using the spreadsheet. You can see what those calculations would look like on each worksheet tab as well as on the Summary tab (see images below). The images below illustrate some of the general steps necessary to create a detailed box culvert design using this spreadsheet. First, open up the summary tab and create an initial column chart on basis of your culvert type. Each culvert type has its own charts. Each chart is divided into various elements of the design process. For example, if you are designing a box culvert with an inverted T cross section, go to the "Design Element" tab and choose "box culvert with inverted T cross section." You can see that chart below the Summary tab. The summary tab contains all of the basic information about your culvert design. It provides a visual overview of your design including basic geometrical parameters, Yf value, friction factors for each side of the wall and roof, diameter of pipe or box culverts, top width and length of box culverts. eccc085e13

0 views0 comments

Recent Posts

See All

Comments


bottom of page