Skip to contentUnited States Department of Transportation - Federal Highway Administration FHWA Home
Research Home
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

 

Safety Effects of Horizontal Curve and Grade Combinations on Rural Two-Lane Highways

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!

 

ResearchFHWA
FHWA
United States Department of Transportation - Federal Highway Administration