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 6
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 7
Introduction 7
Figure 5. Resetting Excel macro security levels.
OCR for page 8
8 Airport Passenger Terminal Planning and Design
Figure 6. Unprotect sheets to access formulae.
