Skip to main content

P3 Toolkit

Analytical Tools

P3-VALUE: Troubleshooting Guide

April 2013

 

« Previous | Table of Contents | Next »

3 Public Sector Comparator Tool

General Mechanics

Q: After I have navigated to the Model Assumptions page, I'm trying to name my project using the "Project Name" field. Using the drop-down menu, I select "New Project" and enter the name. I receive a "Run-time error '1004':" message referencing a Microsoft Visual Basic issue. What do I do now?

Screenshot

View larger image

A: P3-VALUE does not allow multiple scenarios to be stored within the tool template. If a user would like to run different scenarios, the example project should be modified with project-specific values and saved in a folder. The user can then have multiple iterations of the tool open to model different potential delivery scenarios.

Worksheet Technical Challenges

Model Assumptions

Q: I'm trying to enter my project-specific data into the Operating Costs assumption fields. I wanted to enter % of Construction instead of a $ Amount, but the box is blacked out. How do I enter a new value?

Screenshot

View larger image

A: In the PSC Tool, the operations and routine maintenance costs are provided as annual values and can be entered as either a percentage of construction (Column E), or as a dollar value (Column F). If users choose to input O&M costs as percentages, the adjacent cells in column F black out so that the inputs are only either dollar values or percentages. The PSC Tool will prompt users to first "zero out" the dollars if switching to percent values, or vice versa.

Q: I've entered my Design & Construction Costs in Years 1, 2, 3, 4 & 5 and they appear to equal 100%. The Check Status monitor on the far right of the "Assumptions" sheet indicates that I have greater than 100% of my cost profile allocated. Why is this?

Screenshot

View larger image

A: Inputs in this field are determined by the length of the Construction Period as defined in the Timing assumptions field. In the example above, the Construction Period is defined as 5 years, but Year 6 has an extraneous additional 20% hidden under the gray. Navigate to the box and enter "0" and verify that other grayed out years contain zero values. Alternatively, you may adjust the construction length to expose all the input fields, verify they contain the values desired and then re-adjust the construction length period to the original length.

 

« Previous | Table of Contents | Next »

Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000
To view PDF files download the Adobe Acrobat Reader®