These spreadsheet tools were created to assist in application of the predictive methods contained in the Highway Safety Manual (HSM), 1st edition. These tools are used to estimate the expected number of crashes for segments and intersections on urban and suburban arterials, rural multilane roads, and two-lane rural highways. The spreadsheet analysis considers multiple segments within a single safety project. The tools report predicted average crash frequency, expected average crash frequency, and potential for safety improvement for existing conditions. The spreadsheets can be customized to fit the needs of individual agencies as in Alabama, Illinois, Ohio, and Washington. Some agencies have incorporated additional countermeasures, or benefit cost tools (e.g., Ohio Economic Crash Analysis Tool).
- National Cooperative Highway Research Program (NCHRP)
The tool is available free of charge at the following link: HSM Part C Spreadsheets.
This information is disseminated under the sponsorship of the U.S. Department of Transportation in the interest of information exchange. The U.S. Government assumes no liability for the use of the information contained herein. This information does not constitute a standard, specification, or regulation. The U.S. Government does not endorse products or manufacturers. Trademarks or manufacturer's names appear in this information only because they are considered essential to the objective of this publication.
Any opinions, findings, and conclusions or recommendations, and translations thereof, expressed in this publication are those of the author(s) and do not necessarily reflect the views of the Federal Highway Administration.