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

The current file is being released for users to test and provide feedback to the department on any improvements that may be necessary.  Currently, the tool will be used as one scoring method during the April 2014 funding round.  A PDF of the future enhancements and updates will be maintained below.  With any new tool, errors will occur and these will be corrected and uploaded as time permits.  When starting a new project please return to this website to obtain the latest version.  Please contact Derek Troyer (derek.troyer@dot.state.oh.us) with comments or questions.  Official training dates will be posted in the future and be conducted through webinar style.

 ECAT Files

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

 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.

 NCHRP 17-38 Spreadsheets

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



Derek Troyer
(614) 387-5164

Michael McNeill
(614) 387-1265


 Safety Reference Material

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