Costing Asset Protection Tool (CAPTool)

NCHRP Project SP20-59(17)

This tool provides for a consequence-based assessment across multiple modes of transportation assets. It is an initial tool for high level budgeting decisions, providing a platform where all modes are compared on equal footing. This tool allows for an iterative process where the user can return to the beginning of the model and plot different threshold variables. Opportunities are available at Step 1 and Step 6 in the tool to save your work to your hard drive.

Getting Started with the Tool

STEP 1: Save the Excel spreadsheet tool named “nchrp_rpt_525v15capt.xls” to your computer.

STEP 2: Open the tool.

STEP 3: Enable macros in the tool.

The tool requires that you enable the use of macros in this Excel spreadsheet. When you open the file, if a dialogue box opens up regarding enabling macros, click "Enable Macros." You are now ready to start using the Costing Asset Protection Tool. If you do not see a dialogue box when you open the file, you will need to make sure that your macro security level is set to Medium. To do this, follow these steps:

1. Select the Tools menu option and then select Macro and Security. 
2. A security dialogue will appear. Make sure you are looking at the "Security Level" tab inside the dialogue.
3. Set the security level to Medium by clicking the radio button so that you can choose whether or not you use macros in this tool. 
4. Close the file and any other instances of the application currently running on the computer. 
5. Open the file again and click the Enable button when prompted to allow for the macro to run. 

You are now ready to use the Costing Asset Protection Tool. If you have further questions, please consult the CAPTool User Guide (NCHRP Report 525, Volume 15, Part II).