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
 
 

 Contact

 

Derek Troyer
(614) 387-5164
Derek.Troyer@dot.state.oh.us

Michael McNeill
(614) 387-1265
Michael.McNeill@dot.state.oh.us

 
 

 Safety Reference Material

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