Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.
B-1 Running ACCE â ACCE requires 32-bit Microsoft® Excel (version 2007 or later) and a display resolution of 1024x768 pixels or greater. â To start ACCE, click on the button ACCE on the accompanying CD or right click on the file ACCE.xlsm and select âOpenâ (or double click on the file name to begin the program). â ACCE requires an Excel function known as âmacrosâ in order to function properly. If a pop-up message with an âEnable Macrosâ or âEnable Contentâ button appears, that content should be enabled: If no warning appears, macros have already been enabled and ACCE is ready to be used. Before Starting Before starting, have the following information ready: ⢠Description of proposed construction project. ⢠Planned year of construction. ⢠Values for key cost drivers: â Pavement projects: Pavement area (square ft.), design aircraft MTOW (lbs.), and, for run- way construction projects, design aircraft landing gear configuration (SW/DW/DTW/ DDTW) â Security fence projects: Length (ft.) â SRE building and ARFF facility projects: Combined floor area (square ft.) Input Window â The ACCE input window is displayed automatically when opening the tool. It consists of four sections: 1. Contact information: To be used for entering the name and contact information of the preparer of the cost estimate. This information is optional. 2. Airport data: Includes the three-letter FAA identifier, state abbreviation, and name. For NPIAS airports, only the identifier has to be entered: The remaining information is retrieved automatically. This information is required. A P P E N D I X B ACCE Quick Reference Guide
B-2 Airport Capital Improvements: A Business Planning and Decision-Making Approach 3. Project input: This includes a drop-down menu for selecting the project type, a text field for free-form entry of a project description, and a field for the construction year. Once the project type has been selected, additional input fields are shown for entering the input values for the key cost drivers. This information is required. Example:
ACCE Quick Reference Guide B-3 4. Cost estimate: Once the project input data has been entered, the âProcessâ button can be used. This causes a cost estimate to be instantaneously calculated and shown to the right of the project input section. This estimate can be updated by changing the project input values and pressing âProcessâ again. Selecting âGenerate Reportâ will produce the final outputâthe cost estimate report. Example: Other features: â The âClearâ button can be used to clear the input values, in order to generate a brand new cost estimate. â The âCloseâ button closes the ACCE tool and returns the user to Microsoft Excel. Project Types â The project type is selected using a drop-down menu in the project input section. â The following project types are supported: ⢠Aircraft Rescue and Fire Fighting (ARFF) Facility ⢠Apron ⢠Automated Weather Observing System ⢠Perimeter Fencing ⢠Precision Approach Path Indicator (PAPI) ⢠Runway ⢠Snow Removal Equipment (SRE) Building ⢠Taxiway Cost Estimate Report â Provide a name and an optional description to identify the cost estimate. Note: The report name can be a maximum of 31 characters and must conform to Excel naming conventions. â Press OK to generate the cost estimate report. â The cost estimate report displays the contact and airport information, the date and time the report was generated, the project input data, and the cost estimate.
B-4 Airport Capital Improvements: A Business Planning and Decision-Making Approach â The cost estimate includes a low estimate and high estimate that create a range of possible costs. The low and high estimates are based on the level of statistical uncertainty in the cost model for the project type in question. â Cost estimates are provided both in fiscal year (FY) 2014 dollars and in inflation-adjusted dollars for the proposed year of construction. The inflation adjustment is based on predicted increases in general price levels (i.e., not increases in construction-specific costs). â A disclaimer is shown explaining that ACCE is a proof-of-concept tool and that actual costs may differ significantly from the cost estimates produced by the tool. â A toolbar is available below the report: This toolbar supports the following functions: ⢠Print: Sends the report to a printer attached to the computer or on the network. ⢠Save as PDF: Saves the report as a PDF file. ⢠Export: Prompts the user to select a folder and then saves a copy of the report as a Microsoft Excel file with the specified name. Note that only the output is saved (i.e., the cost estimate report). The macros that make up the ACCE tool are not exported. ⢠Return: Returns to the input windowâthis allows the user to enter new inputs and generate a different cost estimate (i.e., to create a what-if analysis).
ACCE Quick Reference Guide B-5 Notes â If the planned year of construction is FY 2014, then inflation-adjusted results are not shown, since these would be identical to the cost estimate expressed in FY 2014 dollars. â If an input value for a key cost driver falls outside the range of values used to develop the cost model for the project type in question, a warning message is displayed indicating that this may result in higher than usual levels of uncertainty: This warning does not, however, preclude use of the entered valueâit is only a cautionary note explaining that the value may result in a greater than usual level of uncertainty. If the user proceeds with the entered value, a similar warning is also displayed in the cost estimate report: â When exiting Microsoft Excel, the following message may appear: Generally, âDonât Saveâ should be selected, to avoid overwriting the ACCE tool with entered data. To save results from a cost estimate, use the âExportâ button in the cost estimate report.
Abbreviations and acronyms used without definitions in TRB publications: A4A Airlines for America AAAE American Association of Airport Executives AASHO American Association of State Highway Officials AASHTO American Association of State Highway and Transportation Officials ACIâNA Airports Council InternationalâNorth America ACRP Airport Cooperative Research Program ADA Americans with Disabilities Act APTA American Public Transportation Association ASCE American Society of Civil Engineers ASME American Society of Mechanical Engineers ASTM American Society for Testing and Materials ATA American Trucking Associations CTAA Community Transportation Association of America CTBSSP Commercial Truck and Bus Safety Synthesis Program DHS Department of Homeland Security DOE Department of Energy EPA Environmental Protection Agency FAA Federal Aviation Administration FHWA Federal Highway Administration FMCSA Federal Motor Carrier Safety Administration FRA Federal Railroad Administration FTA Federal Transit Administration HMCRP Hazardous Materials Cooperative Research Program IEEE Institute of Electrical and Electronics Engineers ISTEA Intermodal Surface Transportation Efficiency Act of 1991 ITE Institute of Transportation Engineers MAP-21 Moving Ahead for Progress in the 21st Century Act (2012) NASA National Aeronautics and Space Administration NASAO National Association of State Aviation Officials NCFRP National Cooperative Freight Research Program NCHRP National Cooperative Highway Research Program NHTSA National Highway Traffic Safety Administration NTSB National Transportation Safety Board PHMSA Pipeline and Hazardous Materials Safety Administration RITA Research and Innovative Technology Administration SAE Society of Automotive Engineers SAFETEA-LU Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users (2005) TCRP Transit Cooperative Research Program TEA-21 Transportation Equity Act for the 21st Century (1998) TRB Transportation Research Board TSA Transportation Security Administration U.S.DOT United States Department of Transportation