The web Browser you are currently using is unsupported, and some features of this site may not work as intended. Please update to a modern browser such as Chrome, Firefox or Edge to experience all features Michigan.gov has to offer.
Bridge Analysis Spreadsheets
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 MDOT-related business.
These Bridge Analysis programs are Excel 2002 spreadsheets. They may not be backward compatible to earlier versions of Microsoft Excel.
By downloading any documents and/or programs, users are agreeing to the above disclaimer.
MDOT CMP LFR Spreadsheet & Documentation
MDOT CMP LRFR Spreadsheet & Documentation
Truck Combinations Spreadsheet
Gusset Plate LFR Analysis
Gusset Plate LFR Analysis Documentation
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.
Questions?
MDOT-Load-Rating@Michigan.gov