U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000
Federal Highway Administration Research and Technology
Coordinating, Developing, and Delivering Highway Transportation Innovations
EXCEL CALCULATOR TOOL |
This excel calculator tool is an archived publication and may contain dated technical, contact, and link information |
Publication Number: HRTM 2130 Date: January 2014 |
Publication Number: HRTM 2130 Date: January 2014 |
Download Excel Calculator Tool Here (2.10 MB)
This is an .xlsm file which can only be opened using Microsoft® Excel®.
Report - FHWA-HRT-13-077 | Summary Report - FHWA-HRT-13-078 | Excel Calcuator Tool - HRTM 2130 |
This spreadsheet tool calculates crash modification factors (CMFs) for the combined effect of curves and grades. CMFs are calculated for fatal and injury (FI) crashes (CMFFI ), property damage only (PDO) crashes (CMFPDO ), and total crashes (CMFTOT ). Use the following instructions to analyze a variety of roadway segments.
Step 1: Select the appropriate CMF calculation worksheet from the four available worksheets by clicking on the tabs at the bottom of the screen display. The worksheet selected should be appropriate for the specific combination of horizontal and vertical alignment for which a CMF is to be calculated. The alignment combinations addressed include the following:
Step 2: Enter the applicable input data describing the horizontal and vertical alignment in the orange boxes in the data input table. The text immediately above the data input table on each worksheet gives guidance on typical ranges of input values. Default values based on chapter 10 of the American Association of State Highway and Transportation Officials (AASHTO) Highway Safety Manual (HSM) are provided for the proportions of FI and PDO crashes, PFI and PPDO , which must sum to 1.0. Users may substitute local values for PFI and PPDO defaults.
Step 3: Click “Run.” The computed CMF values, along with a summary of the input data, will appear on a new row added at the bottom of the results table. The final CMFs, CMFFI , CMFPDO , and CMFTOT , are shown in the blue boxes in those rows. You may now enter new values into the orange cells to analyze a different set of conditions. Each time you click the “Run” button, data are saved into the next row of the results report. Clicking “Reset” will refresh the results table by deleting all displayed rows.
Thank you for using the CMF calculator for curves and grades!