The purpose of this project was to develop a tool, which is available at
https://edocs-public.dot.state.mn.us/edocs_public/DMResultSet/download?docId=29248604
The tool is an Excel macro file that estimates bridge construction contract time based on various controlling activities of bridge construction. As part of this project, various transportation departments throughout the United States were interviewed on how contract time is established in their states. Many states had some sort of estimating tool that aided in establishing contract time; while others followed the process and protocols established by the Federal Highway Administration (FHWA). Chapter 5 of this report contains a user manual for the spreadsheet tool. The MnDOT Bridge Office also developed four instructional videos.