6.2.2 HSM Spreadsheets
As part of the NCHRP research studies used to develop the HSM crash prediction models, several spreadsheet tools were developed to assist in the implementation of the HSM Part C predictive method. The HSM Spreadsheets are Microsoft Excel-based tools maintained by AASHTO that were created for the purpose of simplifying the implementation of the HSM Part C predictive method. The following four HSM Spreadsheets related to the various chapters in the HSM have been developed:
- Rural Two-Lane, Two-Way Roads Spreadsheet – HSM Chapter 10;
- Rural Multilane Highways Spreadsheet – HSM Chapter 11;
- Urban and Suburban Arterials Spreadsheet – HSM Chapter 12; and
- ISATe – HSM Chapter 18 and Chapter 19
The use of the HSM Spreadsheets allows the user to manually enter data and determine the segmentation of the safety study area. The latest version of these tools, along with additional information, is available on AASHTO’s HSM website, which is located in
Appendix G, Section 5 – External References (Reference 3)
. Several agencies have expanded and modified the HSM Spreadsheets to meet their specific needs. These changes include automation, increased flexibility, and additional features. These modified spreadsheets are not designed for general use in Texas but may be a useful resource for very specific application needs. Several of these modified tools are located on the HSM website. The use of modified spreadsheets can be accepted by the TxDOT Project Manager that will be approving the completed analysis prior to use.