The National Academies Press

Currently Skimming:

Pages 179-223

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.

From page 179... ... 179 User's Guide for Spreadsheet Tool 2 Spreadsheet Tool 2 is a spreadsheet-based benefit–cost analysis tool that can be used to assess the cost-effectiveness of specific improvement alternatives for implementation in conjunction with a resurfacing, restoration, and rehabilitation (3R) project. Read the entire page →
From page 180... ... 180 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects shoulders) Read the entire page →
From page 181... ... User's Guide for Spreadsheet Tool 2 181 • Shoulder rumble strips (outside shoulder only on undivided roads; both outside and inside shoulders on divided nonfreeways and freeways) , • Enhanced striping/delineation (nonfreeways only) Read the entire page →
From page 182... ... 182 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects B1 Setup Defaults Before performing any benefit–cost analyses, first visit the Setup worksheet. Read the entire page →
From page 183... ... User's Guide for Spreadsheet Tool 2 183 Figure B-2. Rural Two-lane Highway Setup window. Read the entire page →
From page 184... ... 184 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects • Existing Base Depth: Depth in inches of base material underneath the traveled way and shoulder. Read the entire page →
From page 185... ... User's Guide for Spreadsheet Tool 2 185 • MARR/discount rate: Minimum attractive rate of return (MARR) for analysis of 3R project investments. Read the entire page →
From page 186... ... 186 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Click the Close button to return to the Rural Two-Lane Highway Setup window without saving any changes to the rural two-lane highway cost data element defaults. Read the entire page →
From page 187... ... User's Guide for Spreadsheet Tool 2 187 all percentages is not equal to 100% an error message will be displayed. While no figure is shown, the entry of crash severity proportions functions similarly to the crash type proportions illustrated in Figure B-7. Read the entire page →
From page 188... ... 188 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects B1.2.1 Road Elements Click the View/Edit Road Element Defaults button in the Rural Multilane Highway Setup window. Read the entire page →
From page 189... ... User's Guide for Spreadsheet Tool 2 189 Figure B-9. Rural Multilane Highway Road Elements window. Read the entire page →
From page 190... ... 190 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects • MARR/discount rate: Minimum attractive rate of return (MARR) Read the entire page →
From page 191... ... User's Guide for Spreadsheet Tool 2 191 Click the Close button to return to the Rural Multilane Highway Setup window without saving any changes to the rural multilane highway cost data element defaults. B1.2.3 Safety Elements Click the View/Edit Safety Element Defaults button in the Rural Multilane Highway Setup window. Read the entire page →
From page 192... ... 192 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects • Crash Type Proportion: These are the percentage of all crashes for each crash type shown. Read the entire page →
From page 193... ... User's Guide for Spreadsheet Tool 2 193 centerline rumble strips and enhanced striping and delineation. For rural multilane divided nonfreeways, these treatments include only enhanced striping and delineation. Read the entire page →
From page 194... ... 194 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Click the Close button to return to the Freeway Setup window without saving any changes to the freeway road element defaults. Read the entire page →
From page 195... ... User's Guide for Spreadsheet Tool 2 195 • Right-of-way Unit Cost: Cost of acquiring right-of-way per acre for each freeway type. • Shoulder Rumble Strip Unit Cost: Cost per linear foot for installing a shoulder rumble strip. Read the entire page →
From page 196... ... 196 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects – Possible Injury: Cost of a possible injury crash. Read the entire page →
From page 197... ... User's Guide for Spreadsheet Tool 2 197 Click the Close button to return to the Freeway Setup window without saving any changes to the freeway safety data element defaults. B2 Existing Roadway Attributes After the setup defaults have been either retained or modified, as the user wishes, the tool is ready to perform benefit–cost analyses. Read the entire page →
From page 198... ... 198 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects B2.1 Start New Analysis To start entering roadway data for a new analysis, click the Start New button. Read the entire page →
From page 199... ... User's Guide for Spreadsheet Tool 2 199 First, navigate to the Existing Cross Section tab shown in Figure B-21. • Lane Width: Select the existing average lane width of the traveled way in feet. Read the entire page →
From page 200... ... 200 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects drop-down menus will appear in the window. Read the entire page →
From page 201... ... User's Guide for Spreadsheet Tool 2 201 The window shown in Figure B-24 will appear when the Specific Curve Data Input button is clicked. At the top of the Horizontal Curve Data window is a label that indicates the horizontal curve for which data are being entered. Read the entire page →
From page 202... ... 202 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Figure B-24. Read the entire page →
From page 203... ... User's Guide for Spreadsheet Tool 2 203 All data entry for the last curve on the roadway section is the same as previously defined; however, there is a button (the Add Curve button) that allows the user to add more curves to the roadway section in case more are needed. Read the entire page →
From page 204... ... 204 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects • % of Section with Solid–Dash Centerline: Enter the percentage of the roadway section for which the centerline striping is a solid–dash combination. Read the entire page →
From page 205... ... User's Guide for Spreadsheet Tool 2 205 appropriate value between 0 and 1 for a composite shoulder (i.e., a shoulder whose width is partly paved and partly unpaved) Read the entire page →
From page 206... ... 206 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Next, if a value greater than 0 was entered for Number of Curves on Section, click the Specific Curve Data Input button to enter details about each horizontal curve on the roadway segment. Read the entire page →
From page 207... ... User's Guide for Spreadsheet Tool 2 207 • Curve Length: Enter the length in miles of horizontal curve, not including spiral transitions. • Transition Length: Enter the length in miles of any spiral transition that may be present for one side of the horizontal curve. Read the entire page →
From page 208... ... 208 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects choose to retain the estimate given by the HSM crash prediction method. Read the entire page →
From page 209... ... User's Guide for Spreadsheet Tool 2 209 Figure B-33. Rural Multilane Highway Project Data window: Pavement Marking/ Delineator tab. Read the entire page →
From page 210... ... 210 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects • Inside Shoulder Width: Select the existing inside shoulder width in feet from the drop-down menu. Read the entire page →
From page 211... ... User's Guide for Spreadsheet Tool 2 211 The window in Figure B-35 shows all data entry required for using the average curve data entry option. • % of Section Length on Curves: Enter the percentage of the roadway section that is located on horizontal curves. Read the entire page →
From page 212... ... 212 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Click the Next Curve button to save the data entered for the curve and proceed to data entry for the next curve on the roadway segment. Read the entire page →
From page 213... ... User's Guide for Spreadsheet Tool 2 213 these options is made in the window shown in Figure B-39. The advantage of using site-specific crash history is that the benefit estimate may better reflect local conditions. Read the entire page →
From page 214... ... 214 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects If Yes was selected for median barrier presence in the Existing Cross Section tab, then proceed to the Median Barrier tab, shown in Figure B-40. Read the entire page →
From page 215... ... User's Guide for Spreadsheet Tool 2 215 • Cont. Median Barrier Type: Select the continuous median barrier type from the embedded drop-down menu. Read the entire page →
From page 216... ... 216 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects All other buttons are the same as previously defined for the Median Barrier Data Input window. Read the entire page →
From page 217... ... User's Guide for Spreadsheet Tool 2 217 Figure B-43. Freeway Project Data window: Outside Barrier tab. Read the entire page →
From page 218... ... 218 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects Click the Previous Barrier button to save data entered for the outside barrier and return to data entry for the previous outside barrier on the roadway section. Read the entire page →
From page 219... ... User's Guide for Spreadsheet Tool 2 219 Check the box next to each alternative to be considered for potential improvement. • Widen Lane Width: This option will appear only if the existing lane width is less than 12 ft. Read the entire page →
From page 220... ... 220 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects considered for curves on which HSM procedures indicate that a crash reduction would be likely to result from the superelevation improvement. Read the entire page →
From page 221... ... User's Guide for Spreadsheet Tool 2 221 • Add Centerline Rumble Strip: This option will appear only if no centerline rumble strip is currently present. This option only applies to undivided roadways. Read the entire page →
From page 222... ... 222 Guidelines for Integrating Safety and Cost-Effectiveness into Resurfacing, Restoration, and Rehabilitation (3R) Projects existing lane width to 12 ft, in 1-ft intervals. Read the entire page →
From page 223... ... User's Guide for Spreadsheet Tool 2 223 The results of the analysis are presented in a summary table, with each design alternative sorted by net benefits in descending order. For each alternative considered, the results summary includes the improvement benefits, improvement costs, benefit–cost ratio, net benefits, and the "after project" condition for each roadway attribute that was considered for improvement. Read the entire page →

From page 179...

... 179 User's Guide for Spreadsheet Tool 2 Spreadsheet Tool 2 is a spreadsheet-based benefit–cost analysis tool that can be used to assess the cost-effectiveness of specific improvement alternatives for implementation in conjunction with a resurfacing, restoration, and rehabilitation (3R) project.