Click for next page ( 5


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 4
4 Airport Passenger Terminal Planning and Design give suggestions, possible input ranges, and explanations to the input or output cells' connec- tions to each other, as well as formula descriptions. They are used throughout each of the indi- vidual models as a quick reference to better understanding each step within the models' process. The models contain some conditional formatting that may prompt the user to enter a differ- ent value, one that is more in line with a typical range of values, or to change the input format to match what a calculation in the model needs to work properly. As previously noted, macros are used in the models to facilitate the navigation through the Spreadsheet Models as a complete set of individual models. In addition, macros used within cer- tain model tabs provide a way to minimize some repetitive work for the user and also to perform some larger tasks much faster. Those users that wish to see what the macros are doing behind the scenes can check the Visual Basic (VBA) code that is stored within the spreadsheet by pressing the Alt key and the F11 key together to launch the Microsoft VBA program. The code should be easily understood by those with a moderate level of proficiency. Each workbook tab has links to sections of the User's Guide and to the workbook's Table of Contents tab. As there are many tabs in this model, and they may not all fit on the bottom of the screen, depending on the size of the user's computer monitor, the "Return to Table of Contents" tab makes it simple to get back to the main page and follow the process through each of the models. The overall modeling approach is for the user to review the data checklist, determine the design hour, and then step through each of the models while referring to the User's Guide for additional help and information related to each of the specific areas of terminal planning. It is recommended that the user proceed in the order (left to right, and top to bottom) illustrated in Figure 3. This order will allow for demand values, determined in the initial steps, to flow into dependent calculations in later steps. Summary of Terminal Planning Spreadsheet Models Design Hour Determination: This model takes the user from data sourcing and collection through determining the peak month, choosing an average day of the peak month, and finally determining the design hour and the associated peak planning factors. Figure 3. Model selection buttons in the workbook Table of Contents.