Bridge Analysis Spreadsheets
Disclaimer of Liability
These electronic engineering data and/or analysis programs are being provided by the Michigan Department of Transportation (hereinafter referred to as MDOT) as a courteous service to contractors, consultants, and local agency bridge owners. In preparation of these electronic engineering data and/or analysis programs MDOT has endeavored to offer current, correct and clearly expressed information. However, error may occur. The information contained in these electronic engineering data and/or analysis programs may not be accurate. MDOT expressly disclaims any liability, of any kind, for any reason, that might otherwise arise out of any use of these electronic engineering data and/or analysis programs. In particular, but without limiting it's disclaimer, MDOT disclaims any responsibility for typographical errors or accuracy of the information provided within, contained within or produced by these electronic engineering data and/or analysis programs. MDOT makes no warranties or representations whatsoever regarding the quality, content, completeness, suitability, adequacy, sequence, accuracy or timeliness of the information and data provided in these electronic engineering data and/or analysis programs.The Bridge Operations Section will only support those persons using this software in connection with Michigan DOT related business.
These Bridge Analysis programs are Excel 2002 spreadsheets. They may not be backward compatible to earlier versions of Microsoft Excel. If there are questions about the structural programs, please contact
By downloading any documents and/or programs, users are agreeing to the above disclaimer.
All documents open in a new window.
MDOT CMP LFR Spreadsheet & Documentation (version 2.0)
MDOT CMP LRFR Spreadsheet & Documentation (version 2.0)
Truck Combinations Spreadsheet
Gusset Plate LFR Analysis (ver. 2.2)
Gusset Plate LFR Analysis Documentation (ver. 2.2)
The LRFR Gusset Plate Analysis spreadsheets have been removed from the website, pending a proposed update to the AASHTO MBE. Once the MBE updates have been approved, the sheets will be updated and re-posted. If you have any questions, contact MDOT-Load-Rating@Michigan.gov.