This spreadsheet tool assists in the application of the predictive methods contained in the Highway Safety Manual (HSM), 1st edition. The tool is used to estimate the expected number of crashes for urban and suburban arterials, rural multilane roads, and two-lane rural highways. The spreadsheet analysis considers multiple segments within a single safety project. The tool calculates the predicted crash frequency for existing conditions, expected crash frequency for existing conditions, and the potential for safety improvement. Crash modification factors (CMFs) from the HSM and CMF Clearinghouse are used to analyze the effects of proposed countermeasures. A benefit-cost analysis spreadsheet is included within the tool to compute the rate of return for contemplated strategies. The rate of return can only be calculated for one site at a time, but multiple countermeasures can be considered at one site.
- Ohio Department of Transportation
The tool is available free of charge at the following link: Ohio Economic Crash Analysis Tool.
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.