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.
As discussed in Chapter 1, the introduction to this Userâs Guide, the Collection was created with the dual objectives of ease of use and applicability to all potential users involved in airport construction projects, regardless of airport size or project scope. The steps set forth below for using the Collection should be followed to ensure effective and efficient use of the Collection. 5.1 General Process to Follow When Using the Collection A user interested in implementing sustainable airport construction practices should first select the appropriate database presentation format from which to conduct their search of the Collection. Hard copies of the Collection sorted by Construction Practice category and Construc- tion Implementation Stage category are provided in Appendix A and Appendix B, respectively. An Excel version of the Collection, found on the accompany CD, can also be used. The search of the Collection can be as broad or as specific as needed. The main methods to search the Collection are (1) with no filter (either using the hard copy provided in Appendix A and Appendix B or using the Excel version of the Collection); or (2) by filterable criteria (using the Excel version of the Collection only). A list of potential sustainable construction practices can be extracted from this search and shared with other selected stakeholders that will participate in, or be affected by, a particular airport construction project. After a search of the Collection has yielded potential sustainable construction practices for imple- mentation, these practices should be further evaluated by the user and by selected stakeholders for their suitability at a given airport. An assessment of suitability implies predetermination of criteria that defines what practices would be considered appropriate and what would not; this may include an economic cost/benefit analysis, environmental impact study, social impact study, or operational change management analysis. Each practice on the list should be considered in light of policies, requirements, conditions, and constraints that are unique to the particular airport. As part of this process, the user should review the information in the Collection pertaining to the applicable economic, operational, natural resource/environmental, and/or social considerations potentially resulting from implementa- tion of a specific practice. Information in the Collection can also be used to identify locations (e.g., airports where a particular practice has been implemented) and sources (e.g., documents that may yield further information about the suitability of a particular practice) for additional research. Once an assessment of the suitability of each practice has been performed, the practices iden- tified for implementation should ideally be incorporated into a comprehensive, top-down effort 12 C H A P T E R 5 How to Use the Collection
to implement and monitor sustainable construction practices at the airport. Los Angeles World Airportsâ Sustainable Airport Planning, Design and Construction Guidelines (Los Angeles World Airports 2009) and the City of Chicagoâs Sustainable Airport Manual (City of Chicago 2009) are examples of this type of comprehensive effort. 5.2 How to Use Hard Copy of the Collection To conduct a search for specific sustainable construction practices by construction practice category, use Appendix A: Sustainable Construct Practices by Construction Practice Category and look for the construction practice category of interest (for example, âPolicies and Regulationsâ). The user would then go to the first column of the reproduced spreadsheet page, labeled âSustainable Practice,â and read down each row in the column to find each subcategory in the âPolicies and Regulationsâ practice category (e.g., âPolicies, Procedures and Plans,â âSustain- ability Meetings, Teams, and Presentationâ) followed by the individual sustainable construction practices contained in each subcategory (e.g., âCreate and follow a sustainable vision/mission statement that incorporates construction practices.â). Within each individual sustainable construction practice row, users can read the columns across the row to find information on LEED® applicability, examples of airports where the sustainable construction practice has been implemented (e.g., San Francisco International Airport), and the applicable economic, operational, natural resource/environmental, and/or social factors to consider when planning the implementation of a specific construction practice (e.g., the economic impact varies widely based upon the âdetail and goalsâ of the vision/mission statement). A ref- erence number identifying the source for each sustainable construction practice is also included (sources are identified by reference number at the end of Appendix A). Similarly, to search for specific sustainable construction practices by construction implemen- tation stage, users would look for the construction implementation stage category of interest (for example, âPre-constructionâ) in Appendix B. The user would then go to the first column of the reproduced spreadsheet page labeled âSustainable Practice,â and then read down each row in the column to find the individual sustainable construction practices contained in each construction phase category. Continuing to read across each sustainable construction practice row, users can read the columns to find the information described in the paragraph above. 5.3 How to Use Excel Spreadsheet Version of the Collection The filter function in Microsoft Excel can be used to quickly locate practices throughout the Collection that are applicable to a userâs area of interest. Filtering allows a user to see only the sustainable construction practices matching his or her search, hiding practices that are not relevant. In each of the presentation formats of the Collection, five column headings are capable of being filtered (Excel columns C through G located on row five). These five headings allow the user to conduct a search based on construction practice categories and subcategories (âConstruction Categoryâ worksheet), or construction implementation stage categories and subcategories (Implementation Phase worksheet), depending on the worksheet of the Collection the user has open. As explained in Chapter 4, section 3, âPotential LEED Applicabilityâ is also included as a filterable criterion so that users can conduct a search for sustainable construction practices related to LEED credits. In the Excel version of the Collection, AutoFilter arrows â â appear to the right of these searchable column headings. If the AutoFilter arrows disappear on your version or are not currently â¼ How to Use the Collection 13
included, the filter function can be obtained by first highlighting the five column headings and then selecting DATA â FILTER â AUTO FILTER from the main toolbar, as shown in Figure 3. Clicking on the AutoFilter arrow in a searchable column displays an alphabetical list of categories, subcategories, phases, or LEED® credits that are in that particular column. As shown in Figure 4, a user clicks on the AutoFilter arrow in the âLEED Creditâ column to locate construction practices related to Materials and Resources (MR) Credit 6: Rapidly Renewable Materials (based on the LEED® 2009 for New Construction and Major Renovations Rating System guidebook). After selecting âMR Credit 6,â a total of 11 sustainable construction practices that are applicable to the rapidly renewable materials credit remain in the filtered view of the Collection; all other 14 Sustainable Airport Construction Practices Source: Ricondo & Associates, Inc., March 2010. Prepared by: Ricondo & Associates, Inc., March 2010. Figure 3. Resetting AutoFilter function in Excel version of the Collection. Source: Ricondo & Associates, Inc., March 2010. Prepared by: Ricondo & Associates, Inc., March 2010. Figure 4. Example of LEED® credit sort criteria.
practices are no longer visible. Filtering does not alter the practices, sources, or Research Team Considerations in any way. As soon as the filter is removed, all data reappears the same as it was before. There are two different options for a user to go back to viewing the list of all sustainable con- struction practices and headings. Clicking again on the AutoFilter arrow will display the â(All)â filter option, located at the top of the alphabetical listing. If a filtered search is performed in only one column, selecting â(All)â shows all construction practices once again, as illustrated in Figure 5. A second option to removing all previous filters and viewing the entire Collection again, is to select DATA â FILTER â SHOW ALL from the main toolbar, as displayed in Figure 6. This will display the original view with all practices and headings. How to Use the Collection 15 Source: Ricondo & Associates, Inc., March 2010. Prepared by: Ricondo & Associates, Inc., March 2010. Figure 5. Example of removing filter from Excel version of the Collection. Source: Ricondo & Associates, Inc., March 2010. Prepared by: Ricondo & Associates, Inc., March 2010. Figure 6. Example of removing all filters from Excel version of the Collection.
The DATA â FILTER â SHOW ALL option is preferred if a user conducts a filtered search on multiple categories. For example, a user could perform a filtered search on practices that may improve health and safety that are implemented during construction. While in the âImplemen- tation Phaseâ worksheet, the user would filter practices by clicking on the AutoFilter box and selecting âDuring Constructionâ from the âImplementation Phaseâ column and âHealth and Safetyâ from the âSubcategoryâ column. After the filtered search, the user can quickly view the full listing of practices by selecting DATA â FILTER â SHOW ALL. 5.4 Standard Browsing Within the Excel Spreadsheet Version Some users may not be interested in narrowing down the list of practices by conducting a filtered search. As described in Chapter 4, the Collection has been organized in alternative formats and includes headings and subheadings to appeal to users who are interested in browsing all sustainable construction practices. To enhance the userâs ability to scroll through the large number of practices, the âGroupâ function in Microsoft Excel has been utilized. To consolidate the entire listing of practices and headings into a list of only headings and subheadings, the user can click on box â1â located in the top left corner of the Excel worksheet, left of column âA.â As illustrated in Figure 7, clicking this box hides the construction practices and displays only the main category (in green) and subheading(s). Alternatively, the original listing displaying all practices and headings can be viewed by clicking box â2â located to the right of box â1.â 16 Sustainable Airport Construction Practices Source: Ricondo & Associates, Inc., May 2010. Prepared by: Ricondo & Associates, Inc., May 2010. Figure 7. Browsing by category and subcategory.
How to Use the Collection 17 From the view of only the main categories and headings (selecting box 1), a user can view practices within a particular category and/or subcategory by selecting the â+â box located to the left of the heading of the category the user wishes to expand. A category can then be collapsed by selecting the box containing a âââ to the left of the category heading, as shown in Figure 8. Source: Ricondo & Associates, Inc., May 2010. Prepared by: Ricondo & Associates, Inc., May 2010. Figure 8. Example of how to collapse or expand categories in Excel version of the Collection.