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.
In order to use most of the spreadsheets, enable macros. Learn more on Microsoft's website.
The programs are based on Visual Basic®, Mathcad, and Microsoft® Office Excel® 2007.
Please contact Michael Nop with questions on these programs.
Software written under Iowa Highway Research Board Project TR-620, Update of RCB Culvert Standards to LRFD Specifications.
CulvertCalc 3.1 Installation Files (3.9 MB) 03/18/21
Attention Internet Explorer users: In order to download Mathcad files, right click on the link and choose "Save target as." If the file extension is shown as XML, be sure to change it to XMCD.
These Mathcad sheets may be used for various portions of AASHTO LRFD steel I-girder design.
Positive Moment Constructibility
These files consist of RC-Pier example input files and documentation on the use of RC-Pier for a typical LRFD T-Pier design..
RC Pier Column
RC Pier Footing
These files consist of RC-Pier library files, RC-Pier example input
files, and documentation on the use of RC-Pier for a typical LRFD frame pier
HP Pile Sections
RC Pier Column (20 MB)
RC Pier Footing (36 MB)
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.
The PPCB fabricator data spreadsheet is a form to collect prestressed beam camber data from fabricators.
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.
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.
This spreadsheet was developed to provide LRFD Live Load Distribution Factors for Beam-Slab Bridges.
This appication assists with design of traditional concrete decks on prestressed or steel beams (Aashto Lrfd 18.104.22.168, 22.214.171.124.3, 126.96.36.199, 9, A13.4).
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.
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.
The prepare cost estimate spreadsheet may be used to assist
the designer in estimating the cost of a project based on bid items.
This pane is still being developed and is not finalized for use.
Bridge Tools is an Excel Add-in that provides access to various Iowa DOT Design Applications. Once installed, a tab titled Iowa DOT will appear on the Excel ribbon each time Excel is opened. The ribbon tab displays button groups that identify the currently available design applications offered in the add-in.
Iowa DOT Bridge Tools Installation Files (2.0MB) 02/23/22