Ohio.gov State Agencies  |  Online Services
Skip Ribbon Commands
Skip to main content
Sign In

​​​Highway Safety
Economic Crash Analysis Tool (ECAT)...

The Ohio Department of Transportation (ODOT) reviewed the previous spreadsheets for their operation and calculation methodology.  Based on the needs of ODOT, a single spreadsheet was created to complete the HSM calculations.  The Economic Crash Analysis Tool (ECAT) has the ability to calculate predicted crash frequencies, complete empirical bayes calculations, predict crash frequencies for proposed conditions, conduct alternatives analyses, and complete a benefit-cost analysis.


 ECAT Files

expand Category : 1. Excel Tool ‎(1)
expand Category : 2. Release Notes ‎(1)
expand Category : 3. Examples ‎(13)
expand Category : 4. Misc Information ‎(1)
expand Category : 5. Help Files ‎(6)

 HSM Proportional Tables

Ohio HSM Crash Proportion Tables.pdf
Rural 2-Lane Intersection Proportions.xlsx
Rural 2-Lane Segment Proportions.xlsx
Rural Multilane Intersection Proportions.xlsx
Rural Multilane Segment Proportions.xlsx
Urban and Suburban Intersection Proportions.xlsx
Urban and Suburban Segment Proportions.xlsx

During 2009 and 2010, Dr. Karen Dixon, Principal Investigator of NCHRP 17-38, developed three spreadsheets in a volunteer effort to support training efforts on the first edition of the HSM. Updated versions of these spreadsheets were funded through a partnership between the Alabama Department of Transportation and Virginia Department of Transportation. These agencies released these tools for use by other individuals and agencies to support the implementation of the HSM across the nation.


 HSM Materials

HSM Rural 2-Lane Roads_V3_12132011.xlsm
HSM Rural Multilane Roads_V3_12132011.xlsm
HSM Urban_Suburban Arterials_V3_12132011.xlsm

 Related Links


Click the logos below for detailed information about the Highway Safety Manual (HSM) and Safety Analyst.

Safety Analyst Logo
Safety Analyst Logo

 Safety Reference Material

ECAT Example Exercises_MAR2017.pdf
FHWA Table 70.pdf
Index of Countermeasures Strategies.pdf
Index of Strategies.pdf
TRB-HSM Part C Quick Reference Guide.pdf

 Freeway Training Course