Click for next page ( 6


The National Academies | 500 Fifth St. N.W. | Washington, D.C. 20001
Copyright © National Academy of Sciences. All rights reserved.
Terms of Use and Privacy Statement



Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.

OCR for page 5
Introduction 5 Gate Demand: This model lets the user estimate future gate demand through two common approaches. The user can determine the Narrowbody Equivalent Gate and Equivalent Aircraft through the use of gate equivalency tables for the current or future gate mix. Curb Requirements: This model estimates the length of terminal curb frontage required for arrival and departure curbs for private cars and various types of public vehicles. Check-in/Ticketing: This model allows the user to select the number of check-in positions among the Counter, Kiosk, and Curbside areas and adjust the processing conditions to see the effect on the processing time and required space. Mini-queue models are used to show estimated delays. Security Screening: This model determines the necessary number of TSA passenger screening lanes and space required for TSA screening operations. The model includes a mini-queue model to see the effect of processing and queuing variances on the passenger delay and unit requirements. Baggage Screening: This model helps to determine the Transportation Security Administra- tion (TSA) Surge hourly rate of outbound baggage and estimates the required number of Elec- tronic Detection System (EDS) and Explosive Trace Detection (ETD) units, as well as the basic spatial requirements for operation and handling. Baggage Make-up: This model estimates the make-up space and number of containers/carts required to adequately stage and prepare outbound baggage for delivery to the aircraft. Holdrooms: This model looks at a single holdroom and allows the user to adjust usage param- eters to determine the current LOS or estimate the necessary holdroom conditions to achieve a desired LOS. Baggage Claim: This model determines the overall claim frontage that is necessary, based on the user-defined peak period demand. The user can then size an individual claim unit and determine how many units are required for his/her unique aircraft fleet mix. Concourse Circulation: This model allows the user to describe a single concourse design and determine the necessary circulation width (including space for moving walkways), the sug- gested concourse length, and the total circulation area within the concourse. Federal Inspection Services (FIS)/U.S. Customs and Border Protection (CBP): This model provides the user with CBP standards in the main functional areas of passenger processing. A mini-queue model helps the user to determine the required number of primary processing stations and size the baggage claim frontage based on the design hour international demand. Excel Help Enabling Macros in Excel Macros are functions and actions that are running behind the scenes of a spreadsheet. They are commonly triggered by keyboard inputs, buttons, or tabs that link the keyboard action to instructions that perform many routine operations that are sometimes very complex. Macros are useful in data preparation and analysis when the same set of instructions needs to be repeated over and over again; they can help to simplify the process. Macros can also be useful in provid- ing navigation assistance in the use of spreadsheets when there is a pattern to how operations should proceed and in what order. The Terminal Planning Spreadsheet Models use simple macros that should not pose any threats to the user's computer. With a trusted source and the absence of complex code, lower security settings can be safely used to allow the Spreadsheet Models' macros to function properly and safely. During the initial launch of the Spreadsheet Models, there should be either a Security Warn- ing window requesting the user to disable or enable macros, or a window stating that macros are

OCR for page 5
6 Airport Passenger Terminal Planning and Design already disabled because of the current security-level setting. Figure 4 shows examples of Excel macro security warnings. If the Enable Macros option was not selected during startup, or the Security Level window appeared, the command buttons will not function and the operational macros will not work. Fortunately, there are a couple of easy steps to get the spreadsheet running properly with macros. If the Enable Macros option was available and not selected, close Excel, restart Excel, select the Enable Macros option, and finally reopen the Terminal_Planning_Spreadsheet_Model.xls file. The macros should be operational. If the Security Level setting window appeared, close the file, restart Excel, change the macro security level to Medium, and finally reopen the Terminal_Planning_Spreadsheet_Model.xls file. Figure 5 shows the process of changing the Excel macro security level. From the Tools menu, select Macro and then Security. These selections will launch the Secu- rity window where the Medium setting should be chosen. Click OK. When the file is reopened, the Enable Macros option will be available to choose. Protecting and Unprotecting Excel Spreadsheets Microsoft provides authors of Excel files the option of protecting spreadsheets at various levels of security. The author can lock cells to keep them from being selected or allow the user to select the cell to see the formula or lock some cells with formulas and unlock input cells for changing user data. A knowledgeable user of Excel is able to make custom changes to a spreadsheet; the password can be provided so that the sheet can be unlocked and the ability to make changes is granted. Figure 6 explains the process of unlocking the sheet to gain access to changing the function- ality or look of the spreadsheet. From the Tools menu, select Protection and then Unprotect Sheet. These actions will launch the Unprotect Sheet window that requires a password. Enter the password and click OK. The spreadsheet will be unprotected and open to changes. Be cautious when making changes to another author's work. In most cases it is recommended to back up the work before making changes, to retain a record of the original formulas and formatting that were used. Figure 4. Examples of Excel macro security warning messages.

OCR for page 5
Introduction 7 Figure 5. Resetting Excel macro security levels.

OCR for page 5
8 Airport Passenger Terminal Planning and Design Figure 6. Unprotect sheets to access formulae.