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.
77 A p p e n d i x e To run the Linear Optimization Procedure in the Excel model developed to implement the Resource Allocation Logic Framework, the user needs to activate the Solver add-in available in Excel, if the Solver add-in in Excel has not been activated before. Instructions for adding/activating the Solver add-in are provided as follows. Instructions to Activate Solver in Excel Program
78 Resource Allocation Logic Framework for Highway Asset preservation Instructions for Adding and Activating the Solver Add-In for Excel 2010: 1. Click the File tab, click Options, and then click the Add-Ins category. 2. To add Solver Add-in, select Solver Add-in in the Inactive Application Add-ins options. 3. In the Manage box, click Excel Add-ins, and then click Go.
instructions to Activate Solver in excel program 79 5. Close Excel and reopen the Excel Program. Instructions for Adding and Activating Solver Add-In for Excel 2007: 1. Click the File tab, click Excel Options. 2. Click the Add-Ins category. 3. To add the Solver Add-in, select Solver Add-in in the Inactive Application Add-ins options. 4. In the Manage box, click Excel Add-ins, and then click Go. 4. The Add-Ins dialog box appears. In the Add-Ins Available box, select the check box next to Solver Add-in that you want to activate, and then click OK.
80 Resource Allocation Logic Framework for Highway Asset preservation 5. The Add-Ins dialog box appears. In the Add-Ins Available box, select the check box next to Solver Add-in that you want to activate, and then click OK. 6. Close Excel and reopen the Excel Program.
instructions to Activate Solver in excel program 81 Instructions for Installing Excel Solver Add-in for Mac: Starting with Excel 2011 Service Pack 1 (Version 14.1.0), Solver is bundled with Microsoft Excel for Mac. To enable Solver, click Tools then Add-ins. Within the Add-in box, check Solver. xlam then hit OK. If you are running Excel 2008 in Mac, download Solver for free from Frontline Systems and then use Solver with Excel 2008. ⢠Visit the Frontline Systems website, and then follow the instructions on the download page. ⢠After you have downloaded and installed Solver, open the workbook that contains your Solver model. ⢠Enable macros.
Abbreviations and acronyms used without definitions in TRB publications: 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 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