Evaluation of MDOT's Methodology for Estimating Work Zone User Delay Times

Michigan Department of Transportation (MDOT) currently uses a macro-enabled spreadsheet called Construction Congestion Cost (CO3) created in the late 1990’s to estimate user delay times and costs that the traveling public can expect to experience while traveling through or around construction work zones. MDOT anticipates after 30 plus years Microsoft may stop supporting the old Excel 95 macros altogether: thus, making CO3 unusable. This proposed research project will allow MDOT to make an informed decision on how best to move forward after evaluating whether CO3 can be updated to ensure future viability or other sustainable software solutions should be implemented to best meet MDOT’s business needs.

Language

• English

Project

• Status: Active
• Sponsor Organizations:

  Michigan Department of Transportation

  Van Wagoner Building
  425 W. Ottawa Street
  Lansing, MI  United States  48909
• Performing Organizations:

  Western Michigan University

  1903 W. Michigan Avenue
  Kalamazoo, MI  United States  49008-5241
• Start Date: 20230501
• Expected Completion Date: 20260228
• Actual Completion Date: 0

Subject/Index Terms

• TRT Terms: Costs; Estimating; Methodology; Traffic delays; Work zones
• Identifier Terms: Michigan Department of Transportation
• Subject Areas: Construction; Data and Information Technology; Highways; Operations and Traffic Management;

Filing Info

• Accession Number: 01889385
• Record Type: Research project
• Source Agency: Michigan Department of Transportation
• Files: RIP, STATEDOT
• Created Date: Jul 31 2023 11:40AM