Disclaimer:
This software and other files are intended for use by consultants working for the Bridges and Structures Bureau in their development of projects for the Iowa Department of Transportation. Any other use is at the sole discretion of the user. The Iowa Department of Transportation makes the software and other files available "AS IS" and assumes no liability nor makes any warranty of any kind, including warranties of non-infringement, fitness or merchant ability whether expressed or implied, to the accuracy or functionality of these files. By downloading any files, you are agreeing to this disclaimer.
The Bridges and Structures Bureau will only support those persons using these files in connection with Iowa Department of Transportation related business.
Excel Macros
In order to use most of the spreadsheets, enable macros. Learn more on Microsoft's website.
Related Links
The programs are based on Visual Basic®, Mathcad, and Microsoft® Office Excel® 2007.
Please contact Michael Nop with questions on these programs.
List items for Final Bridge Design Software
The configuration files related to the April 2024 released Beam Standards are provided for LEAP Bridge Concrete.
The OpenBridge Designer file and output files are provided by beam series.
Software written under Iowa Highway Research Board Project TR-620, Update of RCB Culvert Standards to LRFD Specifications.
These Mathcad sheets may be used for various portions of AASHTO LRFD steel I-girder design.
These files consist of RC-Pier example input files and documentation on the use of RC-Pier for a typical LRFD T-Pier design.
These files consist of RC-Pier example input files and documentation on the use of RC-Pier for a typical LRFD frame pier design.
These spreadsheets allow the user to determine top of slab elevations (CCS, CWPG, PPCB), beam line haunch elevations (CWPG, PPCB) and haunches (PPCB) for straight, constant width bridges.
- Bridge Deck Grade Adjustment Spreadsheet 06/06/20
- PCC Beam Data Spreadsheet 11/23/15
- Elevations and Haunches for PPCB 01/18/25
- Elevations for CCS 11/06/14
- Elevations for CWPG 11/06/14
- Quick Elevations for PG
The PPCB fabricator data spreadsheet is a form to collect prestressed beam camber data from fabricators.
- PPCB camber 04/23/18
The bridge deck drain spreadsheet may be used to assist the designer in locating deck drains. The Bridge Design Manual shall be consulted for deck drain policy requirements.
- Deck drains 10/27/15
This spreadsheet was developed to aid the design of typical strip seal expansion joints. The Bridge Design Manual shall be consulted for the most up-to-date policies.
- Strip Seal Expansion Joints 07/07/18
This spreadsheet was developed to provide LRFD Live Load Distribution Factors for Beam-Slab Bridges.
- Live Load Distribution Factors 07/06/18
This application assists with design of traditional concrete decks on prestressed or steel beams (Aashto Lrfd 2.5.2.4, 3.6.1.3.3, 4.6.2.1, 9, A13.4).
- Deck on Beam Design 08/27/23
This application determines MASH single slope rail capacity.
- MASH Barrier Single Slope Design 08/04/23
This application assists with design of typical Iowa DOT pretensioned prestressed concrete beams.
- PPCB Analysis Spreadsheet 04/15/25
Some of these spreadsheets allow the user to determine typical pier loads based on the AASHTO LRFD code for use with the RC-Pier software. Some spreadsheets may be used in the LRFD design of typical pier caps, pile footings, and steel laminated elastomeric bearings.
- LRFD Pile Length - IDOT ENR Formula Spreadsheet 09/30/15
- LRFD Pile Length - WEAP Spreadsheet 05/21/18
- Pier live load 10/31/21
- Pier BR CE 03/12/14
- Pier WA IC
- Pier WS WL 06/20/18
- Pier WS WL All Angles 06/20/18
- Pier and Abut DL Super Reactions 04/30/13
- Pier Temperature Forces 06/07/13
- Pile Footing Stiffness Coefficients
- LRFD Cap Design 07/30/18
- LRFD Footing Design 02/17/11
- Elastomeric Bearing Design 07/05/18
- PPCB Beam Slope for Bearing Design 07/15/17
This spreadsheet determines tension rebar development and splice lengths based on the 7th and 8th edition of the AASHTO LRFD code.
Instructions for iPD project cost estimating software.
- iPD Instructions 07/27/18
The prepare cost estimate spreadsheet may be used to assist the designer in estimating the cost of a project based on bid items.
- Prepare Cost Estimate 04/25/17
Download the msi file for installation of the Iowa DOT Bridge Tools Excel Add-in.
The Excel add-in offers two main tools.
The Staking Diagram Coordinates determines the Easting and Northing (EN) coordinates of a State Plane Coordinate System, for points on or off a bridge located on a horizontal alignment. The program guide can be accessed by clicking on the Support Documents icon on the ribbon and select the Program Guide option to open.
The Masterworks tool utilizes an Excel workbook generated by the third party program Masterworks that contains a single Bid Items and Reference Notes Excel spreadsheet. The Masterworks bid items and reference notes are parsed and added to the workbook as two separate worksheets. The added worksheets are the Estimated Quantities and Reference Notes. The tables in the added worksheets are formatted to be imported into a MicroStation .dgn file for use in a plan set. The program overview can be accessed by clicking on the icon on the ribbon.
Further instructions for generating the Bid Item quantities for bridge projects is also provided in Generating Bid Item and Quantity Tabulations for Bridge Plans
For questions on the Bridge Tools, please contact: Jim Denny