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.