Final bridge design softwareDisclaimer: This software and other files are intended for use by consultants working for the Office of Bridges and Structures 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 merchantability whether expressed or implied, to the accuracy or functionality of these files. By downloading any files, you are agreeing to this disclaimer.
The Office of Bridges and Structures will only support those persons using these files in connection with Iowa Department of Transportation related business.
LRFD CIP Reinforced Concrete Box Culvert Program
Software written under Iowa Highway Research Board Project TR-620, Update of RCB Culvert Standards to LRFD Specifications.
CulvertCalc Installation Files (47 MB) 05/31/12
CulvertCalc Technical Manual (976 KB)
CulvertCalc User Manual (830 KB)
LRFD Steel Girder Design MathcadŽ SheetsAttention 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.
Bearing Stiffener (252 KB)
Field Splice (2.7 MB) 12/19/14
Intermediate Stiffener Size (211 KB)
Negative Resistance (1.2 MB)
Plastic Moment-Negative (168 KB)
Plastic Moment-Positive (363 KB)
Positive Moment Constructibility (1.3 MB)
Positive Resistance (1.1 MB)
Shear Connectors (392 KB)
Shear Resistance-End Panel (180 KB)
Shear Resistance-Interior Panel (249 KB)
LRFD T-Pier Example using RC-PierŽ
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 (4.8 MB)
RC Pier Footing (8.5 MB)
Jefferson Example Documentation (13.9 MB)
LRFD Frame Pier Example using RC-PierŽ
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 design.
HP Pile Sections (1 KB)
LRFD Loads (14 KB)
RC Pier Column (19.5 MB)
RC Pier Footing (36.0 MB)
Wapello Example Documentation (8.3 MB)
Iowa DOT Elevation ApplicationsThese 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 (473 KB) 09/16/15
PCC Beam Data Spreadsheet (16 KB) 09/16/15
Elevations for PPCB (277 KB) 08/22/13
Elevations for CCS (82 KB) 11/06/14
Elevations for CWPG (122 KB) 11/06/14
Quick Elevations for PG (25 KB)
Iowa DOT Substructure Applications
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 (160 KB) 03/04/13LRFD Pile Length - WEAP Spreadsheet (167 KB) 07/08/13
Pier live load (229 KB) 03/12/14
Pier BR CE (82 KB) 03/12/14
Pier WA IC (51 KB)
Pier WS WL (97 KB) 03/12/14
Pier WS WL All Angles (144 KB) 03/12/14
Pier and Abut DL Super Reactions (225 KB) 04/30/13
Pier Temperature Forces (431 KB) 06/07/13
LRFD Cap Design (133 KB) 06/23/14
LRFD Footing Design (44 KB) 02/17/11
Elastomeric Bearing Design (64 KB) 04/03/13
Iowa DOT Miscellaneous ProgramsThis Visual Basic® application provides rebar development and splice lengths for tension bars per AASHTO LRFD code.
Rebar lengths (65 KB) 06/10/13
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 (242 KB) 10/22/13
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 (692 KB) 11/06/14
In order to use most of the spreadsheets, enable macros according to the following link:
The programs are based on Visual Basic® , Mathcad, and Microsoft® Office Excel® 2007.
Please contact Michael.Nop@dot.iowa.gov with questions on these programs.