{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Scoresheet","References","Guidance","LocationList","Color Legend","Dropdowns","NA_Justification"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":124,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scoresheet","index":0,"n_rows":334,"n_cols":13,"rows_kept":334,"cut":false,"hidden":false,"merged":[[11,0,11,1],[42,0,42,2],[221,3,221,4],[220,3,220,4],[214,3,214,4],[207,3,207,4],[197,3,197,4],[198,3,198,4],[199,3,199,4],[145,3,145,4],[108,3,108,4],[143,3,143,4],[144,3,144,4],[130,0,130,5],[165,3,165,4],[139,3,139,4],[141,3,141,4],[154,3,154,4],[146,3,146,4],[147,3,147,4],[142,3,142,4],[240,3,240,4],[236,3,236,4],[237,3,237,4],[234,3,234,4],[235,3,235,4],[238,3,238,4],[239,3,239,4],[12,0,18,1],[226,3,226,4],[232,3,232,4],[233,3,233,4],[228,3,228,4],[229,3,229,4],[230,3,230,4],[231,3,231,4],[227,3,227,4],[43,0,43,1],[44,0,44,1],[196,3,196,4],[137,3,137,4],[138,3,138,4],[140,3,140,4],[158,3,158,4]]}
["Air Force MILCON Sustainability Requirements Scoresheet"]
["version LEED® 2009 (Updated September 2013)",null,null,null,null,"* required entry"]
["General Information",null,null,null,{"$f":"IF(OR(COUNTBLANK(D4:D13)>0,COUNTBLANK(D15:D19)>0,COUNTBLANK(D39)>0,F20=\"*\"),\"INCOMPLETE\",\"\")","v":"INCOMPLETE"}]
[null,null,null,null,"Project ID (e.g. ABCD12345)",{"$f":"IF(ISBLANK(D4),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[null,null,null,null,"Real Property Unique ID (RPUID)",{"$f":"IF(ISBLANK(D5),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[null,null,null,null,"Building Name",{"$f":"IF(ISBLANK(D6),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[null,null,null,null,"Project Type",{"$f":"IF(ISBLANK(D7),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[null,null,null,null,"Installation",{"$f":"IF(ISBLANK(D8),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(D8,LocationList!B4:E90,2,FALSE)),\"\",VLOOKUP(D8,LocationList!B4:E90,2,FALSE))","v":""},"City","*",null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(D8,LocationList!B4:E90,3,FALSE)),\"\",VLOOKUP(D8,LocationList!B4:E90,3,FALSE))","v":""},"State","*",null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(D8,LocationList!B4:E90,4,FALSE)),\"\",VLOOKUP(D8,LocationList!B4:E90,4,FALSE))","v":""},"CONUS","*",null,null,null,null,"SurveyData"]
[{"$f":"IF(COUNTIF(NA_Justification!E5:E38,\"No\")>0,\"Please complete NA justifications\",\"\")","v":""},null,null,null,"MAJCOM",{"$f":"IF(ISBLANK(D12),\"*\",\"\")","v":"*"},null,null,null,null,"SurveyData"]
[{"$f":"IF(COUNTBLANK(Dropdowns!B37:B43)=7,\"Federal Requirements Complete\",\"SURVEY INCOMPLETE\")","v":"SURVEY INCOMPLETE"},null,null,null,"PM Name","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"PA ($k)","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"Building Size (SF)","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"Program Year (FY####)","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"Project Phase","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"Design Started (FY####)","*",null,null,null,null,"SurveyData"]
[null,null,null,null,"BOD (MM/DD/YY)","*",null,null,null,null,"SurveyData"]
["revision",null,null,null,"Pursuing formal LEED® Certification",{"$f":"IF(AND(D20=\"Complete\",D37=\"Complete\"),\"\",IF(OR(D20=\"Not in pursuit of LEED\",D20=\"In Progress\"),\"\",\"*\"))","v":"*"},null,null,null,null,"SurveyData"]
[]
[null,null,null,"","Date Project Registered with USGBC (MM/DD/YY)",null,null,null,null,null,"SurveyData"]
[null,null,null,"LEED® 2009","LEED® Rating System",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"A266","v":0},"LEED® Points Status",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(OR(D7=\"Horizontal\",D7=\"Utilities\",D7=\"Industrial\"),VLOOKUP(D7,E276:F278,2,FALSE),A275)","v":"Prerequisites Not Achieved"},"LEED® Certification Level Status",null,null,null,null,null,"SurveyData"]
[null,null,null,"","LEED® Points Awarded by GBCI (e.g. 42)",null,null,null,null,null,"SurveyData"]
[null,null,null,1,"LEED® Certification Level Awarded by GBCI_Code"]
[null,null,null,{"$f":"VLOOKUP(D27,LocationList!B207:C211,2,FALSE)","v":"[Select]"},"LEED® Certification Level Awarded by GBCI",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(OR(D20=\"Complete\",D20=\"In Progress\"),A271,\"\")","v":""},"LEED® Energy and Water Points Status",null,null,null,null,null,"SurveyData"]
[null,null,null,"","Date Project Certified by GBCI (MM/DD/YY)",null,null,null,null,null,"SurveyData"]
[null,null,null,"","Registration Fees ($)",null,null,null,null,null,"SurveyData"]
[null,null,null,"","Certification Fees ($)",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"A128","v":0},"HPSB Compliant",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(ISBLANK(D101),IF(A100=\"Yes\",\"Met requirement\",IF(A100=\"No\",\"Did not meet requirement\",IF(A100=\"N/A\",A100,IF(A100=\"Maybe\",A100,D101)))),D101)","v":0},"Water Conservation Achieved (% below EPAct 1992)",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(ISNUMBER(D63),D63,D62)","v":0},{"$f":"\"Energy Efficiency Achieved (% below ANSI/ASHRAE/IESNA Standard \"&Dropdowns!A33&\")\"","v":"Energy Efficiency Achieved (% below ANSI/ASHRAE/IESNA Standard 90.1-2010)"},null,null,null,null,null,"SurveyData"]
[null,null,null,"","LEED® Energy and Water Points Awarded by GBCI",null,null,null,null,null,"SurveyData"]
[null,null,null,{"$f":"IF(OR(D26=\"\",D28=\"[Select]\",D30=\"\",D36=\"\"),\"Not Complete\",\"Complete\")","v":"Not Complete"},"All LEED General Information complete"]
[null,null,null,"2014-03-10","Automatic Date",null,null,null,null,null,"SurveyData"]
[null,null,null,null,"Date Scoresheet Completed or Revised","*",null,null,null,null,"SurveyData"]
[null,null,null,"2013_V0","Scoresheet version",null,null,null,null,null,"SurveyData"]
[]
["Color Coding: See Instructions Tab for more detail"]
["Drop-Down Box",null,null,"Recommended (not required)"]
["No Entry Required",null,null,"Yes or N/A "]
["Custom Entry",null,null,"Maybe"]
["LEED Prerequisite",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"* required entry"]
["Federal Requirements for High Performance and Sustainable Buildings (HPSB) & UFC 1-200-02"]
["HPSB I: Employ Integrated Design Principles (UFC 1-200-02 para 2-2)"]
["Total Points",{"$f":"SUM(COUNTIF(A51:A52,\"Yes\"),COUNTIF(A51:A52,\"N/A\"))","v":0},null,{"$f":"IF(COUNTBLANK(A51:A52)>0,\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points",{"$f":"SUM(F51:F52)","v":2}]
[null,"HPSB I.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBI.1_Ref\",\"Integrated Design\")","v":"Integrated Design"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB I.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBI.2_Ref\",\"Commissioning\")","v":"Commissioning"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
["UFC 1-200-02 para 2-3. Promote Sustainable Location and Site Development"]
["Total Points",{"$f":"SUM(COUNTIF(A58:A58,\"Yes\"),COUNTIF(A58:A58,\"N/A\"))","v":0},null,{"$f":"IF(COUNTBLANK(A55:A58)>0,\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points (HPSB only)",{"$f":"SUM(F58:F58)","v":1}]
[null,"UFC para 2-3.1",null,{"$f":"HYPERLINK(\"#\"&\"UFC_231_Ref\",\"Site selection\")","v":"Site selection"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"UFC para 2-3.2",null,{"$f":"HYPERLINK(\"#\"&\"UFC_232_Ref\",\"Mitigation of Heat Island Effect\")","v":"Mitigation of Heat Island Effect"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"UFC para 2-3.3",null,{"$f":"HYPERLINK(\"#\"&\"UFC_233_Ref\",\"Reduction of Light Pollution\")","v":"Reduction of Light Pollution"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB III.3-4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3_Ref\",\"Stormwater Management\")","v":"Stormwater Management"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
["HPSB II: Optimize Energy Performance (UFC 1-200-02 para 2-4)"]
["Total Points",{"$f":"SUM(COUNTIF(A61,\"Yes\"),COUNTIF(A71:A71,\"Yes\"),COUNTIF(A75,\"Yes\"),COUNTIF(A90,\"Yes\"),COUNTIF(A61,\"N/A\"),COUNTIF(A71:A71,\"N/A\"),COUNTIF(A75,\"N/A\"),COUNTIF(A90,\"N/A\"))","v":0},null,{"$f":"IF(OR(COUNTBLANK(A61)>0,COUNTBLANK(A71)>0,COUNTBLANK(A75)>0,COUNTBLANK(D91:D93)>0,COUNTIF(M63:M64,\"* \")>0,COUNTIF(M73:M74,\"* \")>0,COUNTIF(M88:M89,\"* \")>0,AND(D76=\"Yes\",COUNTIF(D79:D87,TRUE)=0)),\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points",{"$f":"SUM(F61:F97)","v":4}]
[{"$f":"IF(ISBLANK(D62),\"\",D62)","v":""},"HPSB II.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.1_Ref\",\"Energy Efficiency\")","v":"Energy Efficiency"},null,1,"Federal Requirements"]
[null,null,null,null,{"$f":"\"Reduce energy use 30% below ANSI/ASHRAE/IESNA Standard \"&Dropdowns!A33&\" or if not - achieve maximum energy efficiency that is lifecycle cost effective\"","v":"Reduce energy use 30% below ANSI/ASHRAE/IESNA Standard 90.1-2010 or if not - achieve maximum energy efficiency that is lifecycle cost effective"},null,"Federal Requirements",{"$f":"D61","v":"Energy Efficiency"},{"$f":"HPSBII.1","v":"HPSB II.1"},null,null,null,"*"]
[null,null,null,null,{"$f":"\"Insert percentage below ANSI/ASHRAE/IESNA Standard \"&Dropdowns!A33&\" in terms of energy use (e.g. 32)\"","v":"Insert percentage below ANSI/ASHRAE/IESNA Standard 90.1-2010 in terms of energy use (e.g. 32)"},null,"Federal Requirements",{"$f":"D61","v":"Energy Efficiency"},{"$f":"HPSBII.1","v":"HPSB II.1"},null,null,null,{"$f":"IF(ISBLANK(D63),\"* \",\"\")","v":"* "}]
[null,null,null,null,"Insert building energy intensity (kBtu/yr-sqft) calculated IAW 10 CFR 433",null,"Federal Requirements",{"$f":"D61","v":"Energy Efficiency"},{"$f":"HPSBII.1","v":"HPSB II.1"},null,null,null,{"$f":"IF(ISBLANK(D64),\"* \",\"\")","v":"* "}]
[null,null,null,{"$f":"CONCATENATE(D66,\" \",D67,\" \",D68,\" \",D69,\" \",D70)","v":"    "},"Roof Attributes (Recommended)",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[null,null,null,null,"Cool roof (LEED SS cr 7.2 or Energy Star)",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[null,null,null,null,"Green roof",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[null,null,null,null,"Solar electric",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[null,null,null,null,"Solar thermal",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[null,null,null,null,"Solar passive",null,"Federal Requirements","Energy Efficiency","HPSB II.1"]
[{"$f":"IF(ISBLANK(D72),\"\",D72)","v":""},"HPSB II.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.3_Ref\",\"On-site Renewable Energy - Solar Hot Water Heater System\")","v":"On-site Renewable Energy - Solar Hot Water Heater System"},null,1,"Federal Requirements"]
[null,null,null,null,"Installed solar hot water heater system or found installation not lifecycle cost effective",null,"Federal Requirements",{"$f":"D71","v":"On-site Renewable Energy - Solar Hot Water Heater System"},{"$f":"HPSBII.3","v":"HPSB II.2"},null,null,null,"*"]
[null,null,null,null,"Insert generation capacity (MMBtu/yr)",null,"Federal Requirements",{"$f":"D71","v":"On-site Renewable Energy - Solar Hot Water Heater System"},{"$f":"HPSBII.3","v":"HPSB II.2"},null,null,null,{"$f":"IF(AND(D72=\"Yes\",ISBLANK(D73)),\"* \",\"\")","v":""}]
[null,null,null,null,"Insert percentage of demand",null,"Federal Requirements",{"$f":"D71","v":"On-site Renewable Energy - Solar Hot Water Heater System"},{"$f":"HPSBII.3","v":"HPSB II.2"},null,null,null,{"$f":"IF(AND(D72=\"Yes\",ISBLANK(D74)),\"* \",\"\")","v":""}]
[{"$f":"IF(ISBLANK(D76),\"\",D76)","v":""},"HPSB II.3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.4_Ref\",\"On-site Renewable Energy\")","v":"On-site Renewable Energy"},null,1,"Federal Requirements"]
[null,null,null,null,"Installed renewable energy elements or projects were not lifecycle cost effective",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},{"$f":"HPSBII.4","v":"HPSB II.3"},null,null,null,"*"]
[null,null,null,{"$f":"IF(D76=\"Yes\",COUNTIF(D80:D87,\"TRUE\"),\"\")","v":""},"Renewable energy types (check below)",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},{"$f":"HPSBII.4","v":"HPSB II.3"},null,null,null,{"$f":"IF(D76=\"Yes\",\"*\",\"\")","v":""}]
[]
[null,null,null,false,"No Renewables",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},{"$f":"HPSBII.4","v":"HPSB II.3"}]
[null,null,null,false,"Solar PV",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"Solar CP",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"Solar Thermal Electric",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"Geothermal",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"GSHP",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"Wind",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"Hydro",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,false,"WTE",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3"]
[null,null,null,null,"Insert generation capacity (kW)",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3",null,null,null,{"$f":"IF(AND(COUNTIF(D80:D87,TRUE)>0,ISBLANK(D88)),\"* \",\"\")","v":""}]
[null,null,null,null,"Insert percentage of total building",null,"Federal Requirements",{"$f":"D75","v":"On-site Renewable Energy"},"HPSB II.3",null,null,null,{"$f":"IF(AND(COUNTIF(D80:D87,TRUE)>0,ISBLANK(D89)),\"* \",\"\")","v":""}]
[{"$f":"IF((COUNTIF(D91:D93,\"Yes\"))+(COUNTIF(D91:D93,\"N/A\"))>2,\"Yes\",IF(COUNTIF(D91:D93,\"No\")>0,\"No\",\"\"))","v":""},"HPSB II.4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.5_Ref\",\"Measurement and Verification\")","v":"Measurement and Verification"},null,1,"Federal Requirements"]
[null,null,null,null,"Water Metering: Select N/A if no service",null,"Federal Requirements",{"$f":"D90","v":"Measurement and Verification"},{"$f":"HPSBII.5","v":"HPSB II.4"},null,null,null,"*"]
[null,null,null,null,"Electric Metering: Select N/A if no service",null,"Federal Requirements",{"$f":"D90","v":"Measurement and Verification"},{"$f":"HPSBII.5","v":"HPSB II.4"},null,null,null,"*"]
[null,null,null,null,"Natural Gas Metering: Select N/A if no service",null,"Federal Requirements",{"$f":"D90","v":"Measurement and Verification"},{"$f":"HPSBII.5","v":"HPSB II.4"},null,null,null,"*"]
[null,null,null,null,"Steam Metering: Select N/A if no service",null,"Federal Requirements",{"$f":"D90","v":"Measurement and Verification"},{"$f":"HPSBII.5","v":"HPSB II.4"}]
[null,"UFC 2 para 4.3",null,{"$f":"HYPERLINK(\"#\"&\"UFC_243_Ref\",\"Provide an Energy Compliance Analysis (Recommended)\")","v":"Provide an Energy Compliance Analysis (Recommended)"},null,null,"Federal Requirements"]
[null,"EISA 2007 II.7",null,{"$f":"HYPERLINK(\"#\"&\"EISA2007II.7_Ref\",\"Reduction in fossil fuel-generated energy consumption (Undefined requirement)\")","v":"Reduction in fossil fuel-generated energy consumption (Undefined requirement)"},null,null,"Federal Requirements"]
[null,"UFC 2 para 4.5",null,{"$f":"HYPERLINK(\"#\"&\"EISA2007II.8_Ref\",\"Benchmarking (Post occupancy task)\")","v":"Benchmarking (Post occupancy task)"},null,null,"Federal Requirements"]
["HPSB III: Protect and Conserve Water (UFC 1-200-02 para 2-5)   "]
["Total Points",{"$f":"SUM(COUNTIF(A100,\"Yes\"),COUNTIF(A102:A102,\"Yes\"),COUNTIF(A103,\"Yes\"),COUNTIF(A100,\"N/A\"),COUNTIF(A102:A102,\"N/A\"),COUNTIF(A103,\"N/A\"))","v":0},null,{"$f":"IF(OR(COUNTBLANK(A100)>0,COUNTBLANK(A102:A103)>0),\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points",{"$f":"SUM(F100:F104)","v":3}]
[null,"HPSB III.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.1_Ref\",\"Indoor Water\")","v":"Indoor Water"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,null,null,null,"Insert percentage achieved",null,"Federal Requirements","Indoor Water Consumption","HPSB III.1",null,null,null,"*"]
[null,"HPSB III.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.2_Ref\",\"Outdoor Water\")","v":"Outdoor Water"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[{"$f":"IF(ISBLANK(D104),\"\",D104)","v":""},"HPSB III.4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.4_Ref\",\"Water used for heating and cooling\")","v":"Water used for heating and cooling"},null,1,"Federal Requirements"]
[null,null,null,null,"Water efficient measures were implemented with heating and cooling equipment when life cycle effective",null,"Federal Requirements",{"$f":"D103","v":"Water used for heating and cooling"},{"$f":"HPSBIII.4","v":"HPSB III.4"},null,null,null,"*"]
["HPSB IV: Enhance Indoor Environmental Quality (UFC 1-200-02 para 2-6)"]
["Total Points",{"$f":"SUM(COUNTIF(A107:A112,\"Yes\"),COUNTIF(A107:A113,\"N/A\"))","v":0},null,{"$f":"IF(COUNTBLANK(A107:A113)>0,\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points",{"$f":"SUM(F107:F113)","v":6}]
[null,"HPSB IV.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.1_Ref\",\"Thermal Comfort\")","v":"Thermal Comfort"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB IV.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.2_Ref\",\"Ventilation\")","v":"Ventilation"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB IV.3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.3_Ref\",\"Moisture Control\")","v":"Moisture Control"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB IV.4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.4_Ref\",\"Daylighting\")","v":"Daylighting"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB IV.5",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.5_Ref\",\"Low Emitting Materials\")","v":"Low Emitting Materials"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB IV.6",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Protect Indoor Air Quality during Construction\")","v":"Protect Indoor Air Quality during Construction"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
["Yes","HPSB IV.7",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.7_Ref\",\"Environmental Tobacco Smoke Control\")","v":"Environmental Tobacco Smoke Control"},null,null,"Federal Requirements",null,null,null,null,null,"*"]
["HPSB V: Reduce Environmental Impact of Materials (UFC 1-200-02 para 2-6)"]
["Total Points",{"$f":"SUM(COUNTIF(A116:A123,\"Yes\"),COUNTIF(A116:A123,\"N/A\"))","v":0},null,{"$f":"IF(OR(COUNTBLANK(A116:A120)>0,COUNTBLANK(A123)>0,A120=0),\"INCOMPLETE\",\"\")","v":"INCOMPLETE"},"Possible Points",{"$f":"SUM(F116:F123)","v":6}]
[null,"HPSB V.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.1_Ref\",\"Recycled Content\")","v":"Recycled Content"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB V.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.2_Ref\",\"Biologically-based Products\")","v":"Biologically-based Products"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB V.3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.3_Ref\",\"Environmentally Preferable Products\")","v":"Environmentally Preferable Products"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[null,"HPSB V.4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.4_Ref\",\"Waste and Materials Management - Recycling\")","v":"Waste and Materials Management - Recycling"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
[{"$f":"IF(D121>0.499,\"Yes\",IF(ISBLANK(D121),D122,IF(D121<0.499,\"No\",\"\")))","v":0},"HPSB V.5",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.5_Ref\",\"Waste and Materials Management - Divert 50% from Disposal\")","v":"Waste and Materials Management - Divert 50% from Disposal"},null,1,"Federal Requirements"]
[null,null,null,null,"Insert percentage diverted from landfill",null,"Federal Requirements",{"$f":"D120","v":"Waste and Materials Management - Divert 50% from Disposal"},{"$f":"HPSBV.5","v":"HPSB V.5"},null,null,null,"*"]
[null,null,null,null,"Data element is not applicable",null,"Federal Requirements",{"$f":"D120","v":"Waste and Materials Management - Divert 50% from Disposal"},{"$f":"HPSBV.5","v":"HPSB V.5"},null,null,null,"*"]
[null,"HPSB V.6",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.6_Ref\",\"Ozone Depleting Substances\")","v":"Ozone Depleting Substances"},null,1,"Federal Requirements",null,null,null,null,null,"*"]
["HPSB Totals",null,null,null,"Possible Points",{"$f":"SUM(F115,F106,F99,F60,F50,F54)","v":22}]
[{"$f":"SUM(B115,B106,B99,B60,B50,B54)","v":0},"Federal Requirements - Yes or N/A",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIF(A51:A52,\"Maybe\"),COUNTIF(A61,\"Maybe\"),COUNTIF(A71:A71,\"Maybe\"),COUNTIF(A75,\"Maybe\"),COUNTIF(A90,\"Maybe\"),COUNTIF(A100,\"Maybe\"),COUNTIF(A102:A102,\"Maybe\"),COUNTIF(A103:A104,\"Maybe\"),COUNTIF(A107:A113,\"Maybe\"),COUNTIF(A58:A58,\"Maybe\"),COUNTIF(A116:A123,\"Maybe\"))","v":0},"Federal Requirements - Maybe",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIF(A51:A52,\"No\"),COUNTIF(A61,\"No\"),COUNTIF(A71:A71,\"No\"),COUNTIF(A75,\"No\"),COUNTIF(A90,\"No\"),COUNTIF(A100,\"No\"),COUNTIF(A102:A102,\"No\"),COUNTIF(A103:A104,\"No\"),COUNTIF(A107:A113,\"No\"),COUNTIF(A116:A123,\"No\"),COUNTIF(A116:A123,\"No\"))","v":0},"Federal Requirements - No",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"(A125/F124)","v":0},"Percentage of Federal Requirements Met",null,null,null,null,null,null,null,"SurveyResult"]
[]
[]
["LEED® 2009 Checklist"]
[null,{"$f":"HYPERLINK(\"#\"&\"Meet\",\"LEED® Credits and/or Prerequisites that meet HPSB/UFC Requirements\")","v":"LEED® Credits and/or Prerequisites that meet HPSB/UFC Requirements"}]
[null,{"$f":"HYPERLINK(\"#\"&\"Align\",\"LEED® Credits and/or Prerequisites that align closely with HPSB/UFC Requirements\")","v":"LEED® Credits and/or Prerequisites that align closely with HPSB/UFC Requirements"}]
[null,{"$f":"HYPERLINK(\"#\"&\"Energy_Water\",\"LEED® Credits that meet USAF Energy & Water Criteria (may depend on technologies & strategies)\")","v":"LEED® Credits that meet USAF Energy & Water Criteria (may depend on technologies & strategies)"}]
["Sustainable Sites "]
["Achievable Points",{"$f":"SUM((IF(A138=\"Yes\",F138,0)+IF(A139=\"Yes\",F139,0)+IF(A140=\"Yes\",F140,0)+IF(A141=\"Yes\",F141,0)+IF(A142=\"Yes\",F142,0)+IF(A143=\"Yes\",F143,0)+IF(A144=\"Yes\",F144,0)+IF(A145=\"Yes\",F145,0)+IF(A146=\"Yes\",F146,0)+IF(A147=\"Yes\",F147,0)+IF(A148=\"Yes\",F148,0)+IF(A149=\"Yes\",F149,0)+IF(A150=\"Yes\",F150,0)+IF(A151=\"Yes\",F151,0)))","v":0},"Sustainable Sites ",null,"Possible Points",{"$f":"SUM(F138:F151)","v":26}]
[null,"Prereq 1 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3_Ref\",\"Construction Activity Pollution Prevention (HPSB GP3)\")","v":"Construction Activity Pollution Prevention (HPSB GP3)"},null,"Required","Sustainable Sites "]
[null,"Credit 1",null,"Site Selection",null,1,"Sustainable Sites "]
[null,"Credit 2 ",null,"Development Density & Community Connectivity",null,5,"Sustainable Sites "]
[null,"Credit 3",null,"Brownfield Redevelopment",null,1,"Sustainable Sites "]
[null,"Credit 4.1",null,"Alternative Transportation - Public Transportation Access",null,6,"Sustainable Sites "]
[null,"Credit 4.2",null,"Alternative Transportation - Bicycle Storage & Changing Rooms",null,1,"Sustainable Sites "]
[null,"Credit 4.3",null,"Alternative Transportation - Low-Emitting & Fuel Efficient Vehicles",null,3,"Sustainable Sites "]
[null,"Credit 4.4",null,"Alternative Transportation - Parking Capacity",null,2,"Sustainable Sites "]
[null,"Credit 5.1",null,"Site Development - Protect or Restore Habitat",null,1,"Sustainable Sites "]
[null,"Credit 5.2",null,"Site Development - Maximize Open Space",null,1,"Sustainable Sites "]
[null,"Credit 6.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3_Ref\",\"Stormwater Design - Quantity Control (HPSB GP3)\")","v":"Stormwater Design - Quantity Control (HPSB GP3)"},null,1,"Sustainable Sites "]
[null,"Credit 6.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3_Ref\",\"Stormwater Design - Quality Control (HPSB GP3)\")","v":"Stormwater Design - Quality Control (HPSB GP3)"},null,1,"Sustainable Sites "]
[null,"Credit 7.1",null,{"$f":"HYPERLINK(\"#\"&\"UFC_232_Ref\",\"Heat Island Effect - Non-Roof (UFC)\")","v":"Heat Island Effect - Non-Roof (UFC)"},null,1,"Sustainable Sites "]
[null,"Credit 7.2",null,{"$f":"HYPERLINK(\"#\"&\"UFC_232_Ref\",\"Heat Island Effect - Roof (UFC)\")","v":"Heat Island Effect - Roof (UFC)"},null,1,"Sustainable Sites "]
[null,"Credit 8",null,"Light Pollution Reduction",null,1,"Sustainable Sites "]
[null,null,null,null,"Select which LEED® Interior Lighting Option was used",null,"Sustainable Sites ","Light Pollution Reduction","Credit 8"]
["Water Efficiency"]
["Achievable Points",{"$f":"SUM(A156,IF(A159=\"Yes\",F159,0),A160)","v":0},null,null,"Possible Points",{"$f":"SUM(F156:F159,F161:F163)","v":10}]
[null,"Prereq 1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.1_Ref\",\"Water Use Reduction - 20% Reduction (HPSB GP3)\")","v":"Water Use Reduction - 20% Reduction (HPSB GP3)"},null,"Required","Water Efficiency"]
[null,"Credit 1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.2_Ref\",\"Water Efficient Landscaping (HPSB GP3)\")","v":"Water Efficient Landscaping (HPSB GP3)"},null,"2 to 4","Water Efficiency"]
[null,null,null,2,"Reduce Potable Water Use by 50% (HPSB GP3)",2,"Water Efficiency","Water Efficient Landscaping (HPSB GP3)","Credit 1"]
[null,null,null,4,"No Potable Use or Irrigation (HPSB GP3)",2,"Water Efficiency","Water Efficient Landscaping (HPSB GP3)","Credit 1"]
[null,"Credit 2 ",null,"Innovative Wastewater Technologies",null,2,"Water Efficiency"]
[null,"Credit 3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIII.1_Ref\",\"Water Use Reduction (HPSB GP3)\")","v":"Water Use Reduction (HPSB GP3)"},null,"2 to 4","Water Efficiency"]
[null,null,null,2,"30% Reduction (HPSB GP3)",2,"Water Efficiency","Water Use Reduction (HPSB GP3)","Credit 3"]
[null,null,null,3,"35% Reduction (HPSB GP3)",1,"Water Efficiency","Water Use Reduction (HPSB GP3)","Credit 3"]
[null,null,null,4,"40% Reduction (HPSB GP3)",1,"Water Efficiency","Water Use Reduction (HPSB GP3)","Credit 3"]
["Energy & Atmosphere"]
["Achievable Points",{"$f":"SUM((A169)+(A189)+IF(A197=\"Yes\",F197,0)+IF(A198=\"Yes\",F198,0)+IF(A199=\"Yes\",F199,0))+IF(A200=\"Yes\",F200,0)","v":0},null,null,"Possible Points",{"$f":"SUM(F170:F188,F190:F200)","v":35}]
[null,"Prereq 1 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBI.2_Ref\",\"Fundamental Commissioning of the Building Energy Systems (HPSB GP1)\")","v":"Fundamental Commissioning of the Building Energy Systems (HPSB GP1)"},null,"Required","Energy & Atmosphere"]
[null,"Prereq 2 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.1_Ref\",\"Minimum Energy Performance (HPSB GP2)\")","v":"Minimum Energy Performance (HPSB GP2)"},null,"Required","Energy & Atmosphere"]
[null,"Prereq 3 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.6_Ref\",\"Fundamental Refrigerant Management (HPSB GP5)\")","v":"Fundamental Refrigerant Management (HPSB GP5)"},null,"Required","Energy & Atmosphere"]
[null,"Credit 1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.1_Ref\",\"Optimize Energy Performance (HPSB GP2)\")","v":"Optimize Energy Performance (HPSB GP2)"},null,"1 to 19","Energy & Atmosphere"]
[null,null,null,1,"12% for New Buildings/8% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,2,"14% for New Buildings/10% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,3,"16% for New Buildings/12% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,4,"18% for New Buildings/14% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,5,"20% for New Buildings/16% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,6,"22% for New Buildings/18% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,7,"24% for New Buildings/20% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,8,"26% for New Buildings/22% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,9,"28% for New Buildings/24% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,10,"30% for New Buildings/26% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,11,"32% for New Buildings/28% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,12,"34% for New Buildings/30% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,13,"36% for New Buildings/32% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,14,"38% for New Buildings/34% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,15,"40% for New Buildings/36% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,16,"42% for New Buildings/38% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,17,"44% for New Buildings/40% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,18,"46% for New Buildings/42% for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,null,null,19,"48%+ for New Buildings/44%+ for Existing Building Renovations",1,"Energy & Atmosphere","Optimize Energy Performance (HPSB GP2)","Credit 1"]
[null,"Credit 2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.4_Ref\",\"On-Site Renewable Energy (HPSB GP2)\")","v":"On-Site Renewable Energy (HPSB GP2)"},null,"1 to 7","Energy & Atmosphere"]
[null,null,null,1,"On-site 1%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,2,"On-site 3%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,3,"On-site 5%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,4,"On-site 7%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,5,"On-site 9%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,6,"On-site 11%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,null,null,7,"On-site 13%",1,"Energy & Atmosphere","On-Site Renewable Energy (HPSB GP2)","Credit 2"]
[null,"Credit 3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBI.2_Ref\",\"Enhanced Commissioning (HPSB GP1)\")","v":"Enhanced Commissioning (HPSB GP1)"},null,2,"Energy & Atmosphere"]
[null,"Credit 4 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.6_Ref\",\"Enhanced Refrigerant Management (HPSB GP5)\")","v":"Enhanced Refrigerant Management (HPSB GP5)"},null,2,"Energy & Atmosphere"]
[null,"Credit 5",null,{"$f":"HYPERLINK(\"#\"&\"HPSBII.5_Ref\",\"Measurement & Verification (HPSB GP2)\")","v":"Measurement & Verification (HPSB GP2)"},null,3,"Energy & Atmosphere"]
[null,"Credit 6 ",null,"Green Power",null,2,"Energy & Atmosphere"]
["Materials & Resources"]
["Achievable Points",{"$f":"SUM(A204, IF(A208=\"Yes\",F208,0),A209,A212,A215,A218,IF(A221=\"Yes\",F221,0),IF(A222=\"Yes\",F222,0))","v":0},null,null,"Possible Points",{"$f":"SUM(F205:F211,F213:F217,F219:F222)","v":14}]
[null,"Prereq 1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.4_Ref\",\"Storage & Collection of Recyclables (HPSB GP5)\")","v":"Storage & Collection of Recyclables (HPSB GP5)"},null,"Required","Materials & Resources"]
[null,"Credit 1.1",null,"Building Reuse - Maintain Existing Walls Floors & Roof",null,"1 to 3","Materials & Resources"]
[null,null,null,1,"Maintain 55% of Existing Walls Floors & Roof",1,"Materials & Resources","Building Reuse - Maintain Existing Walls Floors & Roof","Credit 1.1"]
[null,null,null,2,"Maintain 75% of Existing Walls Floors & Roof",1,"Materials & Resources","Building Reuse - Maintain Existing Walls Floors & Roof","Credit 1.1"]
[null,null,null,3,"Maintain 95% of Existing Walls Floors & Roof",1,"Materials & Resources","Building Reuse - Maintain Existing Walls Floors & Roof","Credit 1.1"]
[null,"Credit 1.2",null,"Building Reuse - Maintain 50% of Interior Non-Structural Elements",null,1,"Materials & Resources"]
[null,"Credit 2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.5_Ref\",\"Construction Waste Management (HPSB GP5)\")","v":"Construction Waste Management (HPSB GP5)"},null,"1 to 2","Materials & Resources"]
[null,null,null,1,"50% Recycled or Salvaged",1,"Materials & Resources","Construction Waste Management (HPSB GP5)","Credit 2"]
[null,null,null,2,"75% Recycled or Salvaged",1,"Materials & Resources","Construction Waste Management (HPSB GP5)","Credit 2"]
[null,"Credit 3",null,"Materials Reuse",null,"1 to 2","Materials & Resources"]
[null,null,null,1,"5% of value of material reused content",1,"Materials & Resources","Materials Reuse","Credit 3"]
[null,null,null,2,"10%  of value of material reused content",1,"Materials & Resources","Materials Reuse","Credit 3"]
[null,"Credit 4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.1_Ref\",\"Recycled Content (HPSB GP5)\")","v":"Recycled Content (HPSB GP5)"},null,"1 to 2","Materials & Resources"]
[null,null,null,1,"10%  of value of material recycled content",1,"Materials & Resources","Recycled Content (HPSB GP5)","Credit 4"]
[null,null,null,2,"20% of value of material reused content",1,"Materials & Resources","Recycled Content (HPSB GP5)","Credit 4"]
[null,"Credit 5",null,"Regional Materials",null,"1 to 2","Materials & Resources"]
[null,null,null,1,"10% Extracted, Processed & Manufactured",1,"Materials & Resources","Regional Materials","Credit 5"]
[null,null,null,2,"20% Extracted, Processed & Manufactured",1,"Materials & Resources","Regional Materials","Credit 5"]
[null,"Credit 6",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.2_Ref\",\"Rapidly Renewable Materials (HPSB GP5)\")","v":"Rapidly Renewable Materials (HPSB GP5)"},null,1,"Materials & Resources"]
[null,"Credit 7",null,{"$f":"HYPERLINK(\"#\"&\"HPSBV.2_Ref\",\"Certified Wood (HPSB GP5)\")","v":"Certified Wood (HPSB GP5)"},null,1,"Materials & Resources"]
["Indoor Environmental Quality"]
["Achievable Points",{"$f":"COUNTIF(A227:A241,\"Yes\")","v":0},null,null,"Possible Points",{"$f":"SUM(F227:F241)","v":15}]
[null,"Prereq 1 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.1_Ref\",\"Minimum IAQ Performance (HPSB GP4)\")","v":"Minimum IAQ Performance (HPSB GP4)"},null,"Required","Indoor Environmental Quality"]
[null,"Prereq 2 ",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.9_Ref\",\"Environmental Tobacco Smoke (ETS) Control (HPSB GP4)\")","v":"Environmental Tobacco Smoke (ETS) Control (HPSB GP4)"},null,"Required","Indoor Environmental Quality"]
[null,"Credit 1 ",null,"Outside Air Delivery Monitoring",null,1,"Indoor Environmental Quality"]
[null,"Credit 2 ",null,"Increased Ventilation",null,1,"Indoor Environmental Quality"]
[null,"Credit 3.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.7_Ref\",\"Construction IAQ Management Plan, During Construction (HPSB GP4)\")","v":"Construction IAQ Management Plan, During Construction (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 3.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.8_Ref\",\"Construction IAQ Management Plan, Before Occupancy (HPSB GP4)\")","v":"Construction IAQ Management Plan, Before Occupancy (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 4.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Low Emitting Materials, Adhesives & Sealants (HPSB GP4)\")","v":"Low Emitting Materials, Adhesives & Sealants (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 4.2",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Low Emitting Materials, Paints & Coatings (HPSB GP4)\")","v":"Low Emitting Materials, Paints & Coatings (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 4.3",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Low Emitting Materials, Flooring Systems (HPSB GP4)\")","v":"Low Emitting Materials, Flooring Systems (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 4.4",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Low Emitting Materials, Composite Wood & Agrifiber Products (HPSB GP4)\")","v":"Low Emitting Materials, Composite Wood & Agrifiber Products (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 5",null,"Indoor Chemical & Pollutant Source Control",null,1,"Indoor Environmental Quality"]
[null,"Credit 6.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.5_Ref\",\"Controllability of Systems, Lighting (HPSB GP4)\")","v":"Controllability of Systems, Lighting (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 6.2",null,"Controllability of Systems, Thermal Comfort",null,1,"Indoor Environmental Quality"]
[null,"Credit 7.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.2_Ref\",\"Thermal Comfort, Design (HPSB GP4)\")","v":"Thermal Comfort, Design (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 7.2",null,"Thermal Comfort, Verification",null,1,"Indoor Environmental Quality"]
[null,"Credit 8.1",null,{"$f":"HYPERLINK(\"#\"&\"HPSBIV.4_Ref\",\"Daylight & Views - Daylight 75% of Spaces (HPSB GP4)\")","v":"Daylight & Views - Daylight 75% of Spaces (HPSB GP4)"},null,1,"Indoor Environmental Quality"]
[null,"Credit 8.2",null,"Daylight & Views - Views for 90% of Spaces",null,1,"Indoor Environmental Quality"]
["Innovation & Design Process"]
["Achievable Points",{"$f":"COUNTIF(A244:A254,\"Yes\")","v":0},null,null,"Possible Points",{"$f":"SUM(F244:F254)","v":6}]
[null,"Credit 1.1",null,"Innovation in Design 1.1",null,1,"Innovation & Design Process"]
[null,null,null,null,"Select if ID 1.1 was for energy and/or water",null,"Innovation & Design Process","Innovation in Design 1.1","Credit 1.1"]
[null,"Credit 1.2",null,"Innovation in Design 1.2",null,1,"Innovation & Design Process"]
[null,null,null,null,"Select if ID 1.2 was for energy and/or water",null,"Innovation & Design Process","Innovation in Design 1.2","Credit 1.2"]
[null,"Credit 1.3",null,"Innovation in Design 1.3",null,1,"Innovation & Design Process"]
[null,null,null,null,"Select if ID 1.3 was for energy and/or water",null,"Innovation & Design Process","Innovation in Design 1.3","Credit 1.3"]
[null,"Credit 1.4",null,"Innovation in Design 1.4",null,1,"Innovation & Design Process"]
[null,null,null,null,"Select if ID 1.4 was for energy and/or water",null,"Innovation & Design Process","Innovation in Design 1.4","Credit 1.4"]
[null,"Credit 1.5",null,"Innovation in Design 1.5",null,1,"Innovation & Design Process"]
[null,null,null,null,"Select if ID 1.5 was for energy and/or water",null,"Innovation & Design Process","Innovation in Design 1.5","Credit 1.5"]
[null,"Credit 2 ",null,"LEED® Accredited Professional",null,1,"Innovation & Design Process"]
["Regional Priority Credits"]
["Achievable Points",{"$f":"COUNTIF(A257:A263,\"Yes\")","v":0},null,null,"Possible Points",{"$f":"SUM(F257:F263)","v":4}]
[null,"Credit 1.1",null,"Regional Priority 1.1",null,1,"Regional Priority Credits"]
[null,null,null,null,"Select if RP 1.1 was for energy and/or water",null,"Regional Priority Credits","Regional Priority 1.1","Credit 1.1"]
[null,"Credit 1.2",null,"Regional Priority 1.2",null,1,"Regional Priority Credits"]
[null,null,null,null,"Select if RP 1.2 was for energy and/or water",null,"Regional Priority Credits","Regional Priority 1.2","Credit 1.2"]
[null,"Credit 1.3",null,"Regional Priority 1.3",null,1,"Regional Priority Credits"]
[null,null,null,null,"Select if RP 1.3 was for energy and/or water",null,"Regional Priority Credits","Regional Priority 1.3","Credit 1.3"]
[null,"Credit 1.4",null,"Regional Priority 1.4",null,1,"Regional Priority Credits"]
[null,null,null,null,"Select if RP 1.4 was for energy and/or water",null,"Regional Priority Credits","Regional Priority 1.4","Credit 1.4"]
["LEED Project Totals  (pre-certification estimates)",null,null,null,"Possible Points",{"$f":"SUM(F256,F243,F224,F202,F165,F154,F136)","v":110}]
[{"$f":"SUM(B256,B243,B224,B202,B165,B154,B136)","v":0},"Total LEED® Yes Points",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIF(A138:A151,\"Maybe\"),COUNTIF(A156:A159,\"Maybe\"),COUNTIF(A197:A200,\"Maybe\"),COUNTIF(A208:A211,\"Maybe\"),COUNTIF(A215:A217,\"Maybe\"),COUNTIF(A221:A222,\"Maybe\"),COUNTIF(A227:A241,\"Maybe\"),COUNTIF(A244:A254,\"Maybe\"),COUNTIF(A257:A263,\"Maybe\"))","v":0},"Total LEED® Maybe Points",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIF(A138:A151,\"No\"),COUNTIF(A156:A159,\"No\"),COUNTIF(A197:A200,\"No\"),COUNTIF(A208:A211,\"No\"),COUNTIF(A215:A217,\"No\"),COUNTIF(A221:A222,\"No\"),COUNTIF(A227:A241,\"No\"),COUNTIF(A244:A254,\"No\"),COUNTIF(A257:A263,\"No\"))","v":0},"Total LEED® No Points",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"COUNTIF(A137,\"Yes\")+COUNTIF(A155,\"Yes\")+COUNTIF(A166:A168,\"Yes\")+COUNTIF(A203,\"Yes\")+COUNTIF(A225:A226,\"Yes\")","v":0},"LEED® Prerequisites Status (out of 8)",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"COUNTIF(A137,\"Yes\")+COUNTIF(A155,\"Yes\")+COUNTIF(A166:A168,\"Yes\")+COUNTIF(A203,\"Yes\")+COUNTIF(A225:A226,\"Yes\")","v":0},"LEED® Prerequisites Status - Industrial (out of 8)",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"IF(A266>0,SUM(COUNTIF(A149:A150,\"Yes\"),COUNTIF(D152,\"Option 1\"),A156,IF(A159=\"Yes\",F159,0),A160,A169,A189,IF(A197=\"Yes\",F197,0),IF(A199=\"Yes\",F199,0),IF(A200=\"Yes\",F200,0),COUNTIF(A227,\"Yes\"),COUNTIF(A240,\"Yes\"),A273,A274),\"\")","v":""},"Total LEED® Energy and Water Related Points",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIF(A149:A150,\"Yes\"),COUNTIF(D152,\"Option 1\"),A156,IF(A159=\"Yes\",F159,0),A160,A169,A189,IF(A197=\"Yes\",F197,0),IF(A199=\"Yes\",F199,0),IF(A200=\"Yes\",F200,0),COUNTIF(A227,\"Yes\"),COUNTIF(A240,\"Yes\"),A273,A274)","v":0},"LEED® Energy and Water Points Status_Code"]
[{"$f":"SUM(COUNTIFS(A244,\"Yes\",D245,\"Energy\"),COUNTIFS(A244,\"Yes\",D245,\"Water\"),COUNTIFS(A244,\"Yes\",D245,\"Energy & Water\"))+SUM(COUNTIFS(A246,\"Yes\",D247,\"Energy\"),COUNTIFS(A246,\"Yes\",D247,\"Water\"),COUNTIFS(A246,\"Yes\",D247,\"Energy & Water\"))+SUM(COUNTIFS(A248,\"Yes\",D249,\"Energy\"),COUNTIFS(A248,\"Yes\",D249,\"Water\"),COUNTIFS(A248,\"Yes\",D249,\"Energy & Water\"))+SUM(COUNTIFS(A250,\"Yes\",D251,\"Energy\"),COUNTIFS(A250,\"Yes\",D251,\"Water\"),COUNTIFS(A250,\"Yes\",D251,\"Energy & Water\"))+SUM(COUNTIFS(A252,\"Yes\",D253,\"Energy\"),COUNTIFS(A252,\"Yes\",D253,\"Water\"),COUNTIFS(A252,\"Yes\",D253,\"Energy & Water\"))","v":0},"Innovation and Design Energy and Water Credits Achievable",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"SUM(COUNTIFS(A257,\"Yes\",D258,\"Energy\"),COUNTIFS(A257,\"Yes\",D258,\"Water\"),COUNTIFS(A257,\"Yes\",D258,\"Energy & Water\"))+SUM(COUNTIFS(A259,\"Yes\",D260,\"Energy\"),COUNTIFS(A259,\"Yes\",D260,\"Water\"),COUNTIFS(A259,\"Yes\",D260,\"Energy & Water\"))+SUM(COUNTIFS(A261,\"Yes\",D262,\"Energy\"),COUNTIFS(A261,\"Yes\",D262,\"Water\"),COUNTIFS(A261,\"Yes\",D262,\"Energy & Water\"))+SUM(COUNTIFS(A263,\"Yes\",D264,\"Energy\"),COUNTIFS(A263,\"Yes\",D264,\"Water\"),COUNTIFS(A263,\"Yes\",D264,\"Energy & Water\"))","v":0},"Regional Priority Energy and Water Credits Achievable",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"IF(A269=8,VLOOKUP(A266,LocationList!B94:C204,2,FALSE),\"Prerequisites Not Achieved\")","v":"Prerequisites Not Achieved"},"LEED® Certification Status",null,null,null,null,null,null,null,"SurveyResult"]
[{"$f":"IF(D7=\"Horizontal\",(IF(A137=\"Yes\",VLOOKUP(A266,LocationList!B94:F204,3,FALSE),\"Prerequisites Not Achieved\")),\"N/A\")","v":"N/A"},"LEED® Horizontal Benchmark Level",null,null,"Horizontal",{"$f":"A276","v":"N/A"},null,null,null,"SurveyResult"]
[{"$f":"IF(D7=\"Utilities\",(IF(A137=\"Yes\",VLOOKUP(A266,LocationList!B94:F204,4,FALSE),\"Prerequisites Not Achieved\")),\"N/A\")","v":"N/A"},"LEED® Utility Benchmark Level",null,null,"Utilities",{"$f":"A277","v":"N/A"},null,null,null,"SurveyResult"]
[{"$f":"IF(D7=\"Industrial\",(IF(A270=8,VLOOKUP(A266,LocationList!B94:F204,5,FALSE),\"Prerequisites Not Achieved\")),\"N/A\")","v":"N/A"},"LEED® Industrial Benchmark Level",null,null,"Industrial",{"$f":"A278","v":"N/A"},null,null,null,"SurveyResult"]
["LEED®: Certified: 40-49 points, Silver: 50-59 points, Gold: 60-79 points, Platinum: 80-110"]
[]
[]
[]
["Potential Error Check"]
["LEED or HPSB Mismatch: Answers do not align between the HPSB/UFC and LEED credits"]
[null,"LEED Credit",null,"HPSB or UFC Element"]
[{"$f":"IF(A137=A58,\"Match\",\"No Match\")","v":"Match"},"SS PR 1",null,"HPSB III.3 - Stormwater Management",null,null,"Quality Check"]
[{"$f":"IF(AND(A150=A56,A149=A56),\"Match\",\"No Match\")","v":"Match"},"SS 7.1-7.2",null,"UFC 1-200-02 para 2-3.2 Mitigation of Heat Island Effect",null,null,"Quality Check"]
[{"$f":"IF(AND(A155=A100),\"Match\",\"No Match\")","v":"Match"},"WE PR 1",null,"HPSB III.2 - Indoor Water",null,null,"Quality Check"]
[{"$f":"IF(AND(D63<0.198,A167=\"Yes\"),\"No Match\",\"Match\")","v":"Match"},"EA PR 2",null,"HPSB II.2 - Energy Efficiency",null,null,"Quality Check"]
[{"$f":"IF(A123=A168,\"Match\",\"No Match\")","v":"Match"},"EA PR 3",null,"HPSB V.6 - Ozone Depleting Substances",null,null,"Quality Check"]
[{"$f":"IF(AND(A169<10,D62=\"Yes\"),\"No Match\",\"Match\")","v":"Match"},"EA 1",null,"HPSB II.2 - Energy Efficiency",null,null,"Quality Check"]
[{"$f":"IF(A203=A119,\"Match\",\"No Match\")","v":"Match"},"MR PR 1",null,"HPSB V.4 - Waste and Materials Management - Recycling",null,null,"Quality Check"]
[{"$f":"IF(AND(A209<1,A120=\"Yes\"),\"No Match\",\"Match\")","v":"Match"},"MR 2",null,"HPSB V.5 - Waste and Materials Management - Diversion",null,null,"Quality Check"]
[{"$f":"IF(A226=A113,\"Match\",\"No Match\")","v":"No Match"},"IEQ PR 2",null,"HPSB IV.7 - Environmental Tobacco Smoke",null,null,"Quality Check"]
[{"$f":"IF(A225=A112,\"Match\",\"No Match\")","v":"Match"},"IEQ 3.1",null,"HPSB IV.6 - Protect Indoor Air Quality During Construction",null,null,"Quality Check"]
[{"$f":"IF(A238=A107,\"Match\",\"No Match\")","v":"Match"},"IEQ 7.1",null,"HPSB IV.4 - Thermal Comfort",null,null,"Quality Check"]
[]
[]
[]
[]
["Justification for Non-Applicable Answers"]
[{"$f":"IF(NA_Justification!E5=\"Yes\",IF(NA_Justification!C5=\"\",NA_Justification!D5,IF(NA_Justification!D5=\"\",NA_Justification!C5,NA_Justification!C5&\" - \"&NA_Justification!D5)))","v":false},{"$f":"NA_Justification!A5&\"_NA\"","v":"HPSB I.1_NA"},null,{"$f":"NA_Justification!B5&\"_NA\"","v":"Integrated Design_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E6=\"Yes\",IF(NA_Justification!C6=\"\",NA_Justification!D6,IF(NA_Justification!D6=\"\",NA_Justification!C6,NA_Justification!C6&\" - \"&NA_Justification!D6)))","v":false},{"$f":"NA_Justification!A6&\"_NA\"","v":"HPSB I.2_NA"},null,{"$f":"NA_Justification!B6&\"_NA\"","v":"Commissioning_NA"},null,null,"NA Justifications"]
[]
[{"$f":"IF(NA_Justification!E8=\"Yes\",IF(NA_Justification!C8=\"\",NA_Justification!D8,IF(NA_Justification!D8=\"\",NA_Justification!C8,NA_Justification!C8&\" - \"&NA_Justification!D8)))","v":false},{"$f":"NA_Justification!A8&\"_NA\"","v":"UFC 2-3.1_NA"},null,{"$f":"NA_Justification!B8&\"_NA\"","v":"Site selection_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E9=\"Yes\",IF(NA_Justification!C9=\"\",NA_Justification!D9,IF(NA_Justification!D9=\"\",NA_Justification!C9,NA_Justification!C9&\" - \"&NA_Justification!D9)))","v":false},{"$f":"NA_Justification!A9&\"_NA\"","v":"UFC 2-3.2_NA"},null,{"$f":"NA_Justification!B9&\"_NA\"","v":"Mitigation of Heat Island Effect_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E10=\"Yes\",IF(NA_Justification!C10=\"\",NA_Justification!D10,IF(NA_Justification!D10=\"\",NA_Justification!C10,NA_Justification!C10&\" - \"&NA_Justification!D10)))","v":false},{"$f":"NA_Justification!A10&\"_NA\"","v":"UFC 2-3.3_NA"},null,{"$f":"NA_Justification!B10&\"_NA\"","v":"Reduction of Light Pollution_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E11=\"Yes\",IF(NA_Justification!C11=\"\",NA_Justification!D11,IF(NA_Justification!D11=\"\",NA_Justification!C11,NA_Justification!C11&\" - \"&NA_Justification!D11)))","v":false},{"$f":"NA_Justification!A11&\"_NA\"","v":"HPSB III.3-4_NA"},null,{"$f":"NA_Justification!B11&\"_NA\"","v":"Stormwater Management_NA"},null,null,"NA Justifications"]
[]
[{"$f":"IF(NA_Justification!E14=\"Yes\",IF(NA_Justification!C14=\"\",NA_Justification!D14,IF(NA_Justification!D14=\"\",NA_Justification!C14,NA_Justification!C14&\" - \"&NA_Justification!D14)))","v":false},{"$f":"NA_Justification!A14&\"_NA\"","v":"HPSB II.2_NA"},null,{"$f":"NA_Justification!B14&\"_NA\"","v":"On-site Renewable Energy - Solar Hot Water Heater System_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E15=\"Yes\",IF(NA_Justification!C15=\"\",NA_Justification!D15,IF(NA_Justification!D15=\"\",NA_Justification!C15,NA_Justification!C15&\" - \"&NA_Justification!D15)))","v":false},{"$f":"NA_Justification!A15&\"_NA\"","v":"HPSB II.3_NA"},null,{"$f":"NA_Justification!B15&\"_NA\"","v":"On-site Renewable Energy_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E16=\"Yes\",IF(NA_Justification!C16=\"\",NA_Justification!D16,IF(NA_Justification!D16=\"\",NA_Justification!C16,NA_Justification!C16&\" - \"&NA_Justification!D16)))","v":false},{"$f":"NA_Justification!A16&\"_NA\"","v":"HPSB II.4_NA"},null,{"$f":"NA_Justification!B16&\"_NA\"","v":"Measurement and Verification_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E17=\"Yes\",IF(NA_Justification!C17=\"\",NA_Justification!D17,IF(NA_Justification!D17=\"\",NA_Justification!C17,NA_Justification!C17&\" - \"&NA_Justification!D17)))","v":false},{"$f":"B312&\"_Water\"","v":"HPSB II.4_NA_Water"},null,{"$f":"NA_Justification!B17&\"_NA\"","v":"Water Metering: Select N/A if no service_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E18=\"Yes\",IF(NA_Justification!C18=\"\",NA_Justification!D18,IF(NA_Justification!D18=\"\",NA_Justification!C18,NA_Justification!C18&\" - \"&NA_Justification!D18)))","v":false},{"$f":"B312&\"_Electric\"","v":"HPSB II.4_NA_Electric"},null,{"$f":"NA_Justification!B18&\"_NA\"","v":"Electric Metering: Select N/A if no service_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E19=\"Yes\",IF(NA_Justification!C19=\"\",NA_Justification!D19,IF(NA_Justification!D19=\"\",NA_Justification!C19,NA_Justification!C19&\" - \"&NA_Justification!D19)))","v":false},{"$f":"B312&\"_NaturalGas\"","v":"HPSB II.4_NA_NaturalGas"},null,{"$f":"NA_Justification!B19&\"_NA\"","v":"Natural Gas Metering: Select N/A if no service_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E20=\"Yes\",IF(NA_Justification!C20=\"\",NA_Justification!D20,IF(NA_Justification!D20=\"\",NA_Justification!C20,NA_Justification!C20&\" - \"&NA_Justification!D20)))","v":false},{"$f":"B312&\"_Steam\"","v":"HPSB II.4_NA_Steam"},null,{"$f":"NA_Justification!B20&\"_NA\"","v":"Steam Metering: Select N/A if no service_NA"},null,null,"NA Justifications"]
[]
[{"$f":"IF(NA_Justification!E22=\"Yes\",IF(NA_Justification!C22=\"\",NA_Justification!D22,IF(NA_Justification!D22=\"\",NA_Justification!C22,NA_Justification!C22&\" - \"&NA_Justification!D22)))","v":false},{"$f":"NA_Justification!A22&\"_NA\"","v":"HPSB III.1_NA"},null,{"$f":"NA_Justification!B22&\"_NA\"","v":"Indoor Water_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E23=\"Yes\",IF(NA_Justification!C23=\"\",NA_Justification!D23,IF(NA_Justification!D23=\"\",NA_Justification!C23,NA_Justification!C23&\" - \"&NA_Justification!D23)))","v":false},{"$f":"NA_Justification!A23&\"_NA\"","v":"HPSB III.2_NA"},null,{"$f":"NA_Justification!B23&\"_NA\"","v":"Outdoor Water_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E24=\"Yes\",IF(NA_Justification!C24=\"\",NA_Justification!D24,IF(NA_Justification!D24=\"\",NA_Justification!C24,NA_Justification!C24&\" - \"&NA_Justification!D24)))","v":false},{"$f":"NA_Justification!A24&\"_NA\"","v":"HPSB III.4_NA"},null,{"$f":"NA_Justification!B24&\"_NA\"","v":"Water used for heating and cooling_NA"},null,null,"NA Justifications"]
[]
[{"$f":"IF(NA_Justification!E26=\"Yes\",IF(NA_Justification!C26=\"\",NA_Justification!D26,IF(NA_Justification!D26=\"\",NA_Justification!C26,NA_Justification!C26&\" - \"&NA_Justification!D26)))","v":false},{"$f":"NA_Justification!A26&\"_NA\"","v":"HPSB IV.1_NA"},null,{"$f":"NA_Justification!B26&\"_NA\"","v":"Thermal Comfort_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E27=\"Yes\",IF(NA_Justification!C27=\"\",NA_Justification!D27,IF(NA_Justification!D27=\"\",NA_Justification!C27,NA_Justification!C27&\" - \"&NA_Justification!D27)))","v":false},{"$f":"NA_Justification!A27&\"_NA\"","v":"HPSB IV.2_NA"},null,{"$f":"NA_Justification!B27&\"_NA\"","v":"Ventilation_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E28=\"Yes\",IF(NA_Justification!C28=\"\",NA_Justification!D28,IF(NA_Justification!D28=\"\",NA_Justification!C28,NA_Justification!C28&\" - \"&NA_Justification!D28)))","v":false},{"$f":"NA_Justification!A28&\"_NA\"","v":"HPSB IV.3_NA"},null,{"$f":"NA_Justification!B28&\"_NA\"","v":"Moisture Control_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E29=\"Yes\",IF(NA_Justification!C29=\"\",NA_Justification!D29,IF(NA_Justification!D29=\"\",NA_Justification!C29,NA_Justification!C29&\" - \"&NA_Justification!D29)))","v":false},{"$f":"NA_Justification!A29&\"_NA\"","v":"HPSB IV.4_NA"},null,{"$f":"NA_Justification!B29&\"_NA\"","v":"Daylighting_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E30=\"Yes\",IF(NA_Justification!C30=\"\",NA_Justification!D30,IF(NA_Justification!D30=\"\",NA_Justification!C30,NA_Justification!C30&\" - \"&NA_Justification!D30)))","v":false},{"$f":"NA_Justification!A30&\"_NA\"","v":"HPSB IV.5_NA"},null,{"$f":"NA_Justification!B30&\"_NA\"","v":"Low Emitting Materials_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E31=\"Yes\",IF(NA_Justification!C31=\"\",NA_Justification!D31,IF(NA_Justification!D31=\"\",NA_Justification!C31,NA_Justification!C31&\" - \"&NA_Justification!D31)))","v":false},{"$f":"NA_Justification!A31&\"_NA\"","v":"HPSB IV.6_NA"},null,{"$f":"NA_Justification!B31&\"_NA\"","v":"Protect Indoor Air Quality during Construction_NA"},null,null,"NA Justifications"]
[]
[{"$f":"IF(NA_Justification!E33=\"Yes\",IF(NA_Justification!C33=\"\",NA_Justification!D33,IF(NA_Justification!D33=\"\",NA_Justification!C33,NA_Justification!C33&\" - \"&NA_Justification!D33)))","v":false},{"$f":"NA_Justification!A33&\"_NA\"","v":"HPSB V.1_NA"},null,{"$f":"NA_Justification!B33&\"_NA\"","v":"Recycled Content_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E34=\"Yes\",IF(NA_Justification!C34=\"\",NA_Justification!D34,IF(NA_Justification!D34=\"\",NA_Justification!C34,NA_Justification!C34&\" - \"&NA_Justification!D34)))","v":false},{"$f":"NA_Justification!A34&\"_NA\"","v":"HPSB V.2_NA"},null,{"$f":"NA_Justification!B34&\"_NA\"","v":"Biologically based products_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E35=\"Yes\",IF(NA_Justification!C35=\"\",NA_Justification!D35,IF(NA_Justification!D35=\"\",NA_Justification!C35,NA_Justification!C35&\" - \"&NA_Justification!D35)))","v":false},{"$f":"NA_Justification!A35&\"_NA\"","v":"HPSB V.3_NA"},null,{"$f":"NA_Justification!B35&\"_NA\"","v":"Environmentally Preferable Products_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E36=\"Yes\",IF(NA_Justification!C36=\"\",NA_Justification!D36,IF(NA_Justification!D36=\"\",NA_Justification!C36,NA_Justification!C36&\" - \"&NA_Justification!D36)))","v":false},{"$f":"NA_Justification!A36&\"_NA\"","v":"HPSB V.4_NA"},null,{"$f":"NA_Justification!B36&\"_NA\"","v":"Waste and Materials Management - Recycling_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E37=\"Yes\",IF(NA_Justification!C37=\"\",NA_Justification!D37,IF(NA_Justification!D37=\"\",NA_Justification!C37,NA_Justification!C37&\" - \"&NA_Justification!D37)))","v":false},{"$f":"NA_Justification!A37&\"_NA\"","v":"HPSB V.5_NA"},null,{"$f":"NA_Justification!B37&\"_NA\"","v":"Waste and Materials Management - Divert 50% from Disposal_NA"},null,null,"NA Justifications"]
[{"$f":"IF(NA_Justification!E38=\"Yes\",IF(NA_Justification!C38=\"\",NA_Justification!D38,IF(NA_Justification!D38=\"\",NA_Justification!C38,NA_Justification!C38&\" - \"&NA_Justification!D38)))","v":false},{"$f":"NA_Justification!A38&\"_NA\"","v":"HPSB V.6_NA"},null,{"$f":"NA_Justification!B38&\"_NA\"","v":"Ozone Depleting Substances_NA"},null,null,"NA Justifications"]

{"sheet":"References","index":1,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":true,"merged":[[1,0,1,1],[0,0,0,1]]}
["Additional References to ASHRAE 189.1 and UFC Requirements"]
["This summary includes additional detail on ASHRAE 189.1 and the UFC but is not a replacement or substitute to using ASHRAE 189.1."]
["UFC Reference","UFC and ASHRAE Summary"]
["HPSB I: Employ Integrated Design Principles"]
["1-200-02, 2-2.1 - Integrated Design","Evaluate the site and building components to determine whether passive and natural design strategies and features are cost effectively incorporated before the active and mechanical systems are designed. Follow steps of design optimization, as applicable, including the following sequential approach:\n• Analyze potential sites and associated climate including local and regional context.\n• Select a sustainable site.\n• Design building to site analysis focusing on orientation, configuration and massing.\n• Select and integrate into the design, high performance and sustainable building envelope strategies and components (e.g. roofs, walls, fenestrations).\n• Select, design and integrate into the overall design, high performance and sustainable systems (e.g. HVAC, plumbing, water heating systems, lighting systems, control systems, elevators, and fire protection systems).  \n\nFor more detail on integrated design, see ASHRAE 189.1 Informative Appendix H (Integrated Design) and Section H1.1.1 (Charrette Process)"]
["ASHRAE Reference","ASHRAE 189.1, Informative Appendix H (Integrated Design) and Section H1.1.1"]
["1-200-02, 2-2.2 - Commissioning","For Air Force projects, the Project Delivery Team must determine the level of commissioning activities required. Commissioning should be conducted during pre-design and continue through post-occupancy.  Relevant systems include heating, ventilation, air conditioning, IAQ and refrigeration systems, building envelope systems, pressurization systems, lighting controls, irrigation, plumbing, domestic and process water pumping, domestic hot water systems, renewable energy systems, and energy and water measurement devices. Commissioning is to ensure that the designed systems function and operate according to the owner’s project requirements (OPR) and the basis of design (BOD) document (10.3.1.2). \n\nThe specific requirements include that procedures, documentation, tools, and training are provided to building operating staff to sustain systems, both during the commissioning an assembled into a systems manual\n\nPrior to building permit and completion of schematic design:\n(Schematic design can be the design charrette or similar conceptual design activity per the UFC)\n• The owner develops an OPR specifying goals, the design team updates the OPR with all parties.\n• The design team develops the BOD, including descriptions of building systems, IAQ criteria and design parameters, which is NOT required to include documentation of adherence to ANSI/ASHRAE Standard 55 according to the UFC.\n• The project designates a commissioning authority that reviews the OPR and BOD to avoid conflicts\n• Commissioning requirements are incorporated into project specifications and construction documents\n\n"]
[null,"Prior to building occupancy:\n• Commissioning authority verifies installation and performance of systems.\n• The preliminary commissioning report is completed and a system manual prepared with O&M documentation .\n• The commissioning authority should provide pre-functional checklists for the entity responsible for the installed equipment. These checklists ensure that equipment is installed correctly and operating according to design.\n\nPost-occupancy:\n• All planned commissioning activities completed for systems whose commissioning was not possible before\n• Final commission report completed and Systems manual delivered."]
["ASHRAE Reference","ASHRAE 189.1 Section 10.3.1.2"]
["UFC 1-200-02, 2-3. Promote Sustainable Location and Site Development"]
["1-200-02, 2-3.1 - Site Selection","During the site selection process, give preference to sites which possess the following characteristics when appropriate:\n\n• Adaptive reuse or renovation of buildings or sites (including historic buildings), or use of previously disturbed/developed areas\n• Building orientation to maximize energy efficiency, passive solar and daylighting potential of the building\n• Locations in central business districts (cantonment areas) and rural town centers (remote locations)\n• Sites well served by public or other transit if available or projected to be available\n• Site design elements that ensure safe and convenient pedestrian access\n• Proximity to housing\n• Avoiding development of sensitive land resources (including greenfields and USDA Prime Farmland as defined in 7 USC 4201)\n• Consult with local Cultural Resource Manager to identify potential impacts to existing historic buildings, districts, or view sheds\n• Parking management strategies to encourage co-use of shared parking\n"]
["ASHRAE Reference","Not provided"]
["1-200-02, 2-3.2 - Mitigation of Heat Island Effect","Hardscapes - ASHRAE 189.1 Section 5.3.2.1:\nAt least 50% of site hardscape consists of one or a combination of:\na. Existing vegetation or native/adapted plants that provide shade within 5 years \nb. Paving with minimum initial SRI of 29 or SRI of 35 for new concrete without added pigment.\nc. Shading through structures\nd. Parking under a building\ne. Not applicable under the UFC\n\nWalls – ASHRAE 189.1 Section 5.3.2.2:\nAt least 30% of the east and west above-grade walls are shaded to 20 ft, with plants, man-made structures/projections, existing buildings, hillsides, and/or renewable energy systems. Use native/adapted plants. OR if 75% of the opaque wall surfaces have a minimum SRI of 29. East wall shading is not required in climate zone 5, 6,7 and 8. West wall shading is not required in climate zone 7 and 8.\n\nAll shade coverage is estimated based on the arithmetic mean effective at 10 a.m., noon, and 3 p.m. at the summer solstice."]
["ASHRAE Reference","ASHRAE 189.1, Section 5.3.2.1; Section 5.3.2.2"]
["1-200-02, 2-3.3 - Reduction of Light Pollution","Meet the requirements of UFC 3-530-01. This document includes guidance on the design of interior, exterior lighting and controls. Sections 3-7 and 3-8 discuss light pollution and light trespass."]
["ASHRAE Reference","ASHRAE 189.1, Section 5.3.2.1; Section 5.3.2.2"]
["1-200-02, 2-3.4 - Stormwater Management","Meet the requirements of UFC 3-210-10. This document includes guidance for low impact development techniques and stormwater requirements under Section 438 of the Energy Indepedence and Security Act (EISA) 2007. The overall design objective for each applicable project is to maintain predevelopment hydrology and prevent any net increase in stormwater runoff."]
["ASHRAE Reference","ASHRAE 189.1, Section 5.3.2.1; Section 5.3.2.2"]
["HPSB II: Optimize Energy Performance (UFC 1-200-02, 2.4)"]
["1-200-02, 2-4.1 - Energy Efficiency","Design the building to achieve at least 30% energy consumption reduction from ASHRAE 90.1 baseline as required in 10 CFR Part 433. For Navy and Air Force projects, use ASHRAE 90.1 (2007) baseline, except for the performance rating formula in G1.2, which should be used as follows (from 10 CFR 433.5): \n\nPercentage improvement = 100 x (Baseline building consumption—Proposed building consumption) ÷(Baseline building consumption—Receptacle and process loads).\n\nThis differs from the LEED calculation.\nDesign Federal low-rise residential buildings to achieve at least 30% energy consumption reduction from International Energy Conservation Code (IECC) baseline as required in 10 CFR Part 435.\n\nIf a 30% reduction is not life-cycle cost-effective, the design of the proposed building shall be modified so as to achieve an energy consumption level at or better than the maximum level of energy efficiency that is life-cycle cost-effective."]
["ASHRAE Reference","ASHRAE 90.1 (2007)"]
["1-200-02, 2-4.2 - Renewable Energy","Provide on-site renewable energy systems in accordance with ASHRAE 189.1 Section 7.4.1.1 (On-Site Renewable Energy Systems) where life-cycle cost effective considering climate, infrastructure condition, mission compatibility, and effects on base wide electrical system (grid) power quality. When cost-effective, on-site projects should produce at least 6.0 kBTU/SF/year based on conditioned space, unless there are low levels of solar radiation (<4.0 kW/square meter day). Exceptions to the kBTU/SF/year level are provided in ASHRAE 189.1, Section 7.4.1.1.\n\nWhen renewable systems are provided, comply with IEEE 1547 for renewable systems interface to the electrical system grid.  Note: The IEEE 1547 Series of Interconnection Standards are available from IEEE (http://grouper.ieee.org/groups/scc21/dr_shared/) as design guides for IEEE 1547 implementation.\n\nException: Purchase of renewable energy certificates (RECs) must not be used as a substitute for the Section 7.4.1.1 new building requirement."]
["ASHRAE Reference","ASHRAE 189.1, Section 7.4.1.1"]
["1-200-02, 2-4.3: Provide an Energy Compliance Analysis (Recommended)","Recommended: Provide an Energy Compliance Analysis (ECA), which will demonstrate compliance with all energy related requirements in the UFC.  Identify the specific energy conservation criteria that applies to the project, the software used to prepare the necessary calculations, a summary of all input to and output from the calculations, and the calculated baseline and as-designed building energy consumption of the proposed design.  The ECA shall include a completed “Energy Cost Budget (ECB) Compliance Report” as shown in Appendix G of the “User’s Manual for ANSI/ASHRAE/IESNA Standard 90.1-2007.”"]
["ASHRAE Reference","ANSI/ASHRAE/IESNA Standard 90.1-2007"]
["1-200-02, 2-4.4 Measurement and Verification","Meters must be connected to a base wide energy and utility monitoring and control system using the installation’s advanced metering protocols.  The installation of meters is required per DODI 4170.11, Installation Energy Management.\n\nImplement submetering when authorized in writing by the Installation.  Utilize ASHRAE 189.1 Section 7.3.3 (Energy Consumption Management) as guide for subsystem implementation. Section 7.3.3 stipulates that meters should feed automatically to a data acquisition system and that they can provide daily data and hourly energy profiles. The data system should keep data for a minimum of 36 months.\n\nInstall water meters to monitor use in buildings consuming indoor and outdoor water as required by DODI 4170.11. The installation of separate water meters for locations with outdoor water use is encouraged. The use of harvested rainwater, treated wastewater, and air conditioner condensate should also be considered and used where feasible for nonpotable use and potable use where allowed. "]
["ASHRAE Reference","ASHRAE 189.1, Section 7.3.3"]
["1-200-02, 2-4.4 Benchmarking","Compare annual performance data with previous years’ performance data, by entering annual performance data in a measurement and tracking tool such as EPA’s ENERGY STAR®, Portfolio Manager.  The Labs21® Energy Benchmarking Tool may be used to benchmark laboratory buildings.  Results of benchmarking should be used to inform capital investment decisions for new facilities.  "]
["ASHRAE Reference","Not provided"]
[null,"HPSB III: Protect and Conserve Water"]
["1-200-02, 2-5.1 - Indoor Water","Meet the requirements of ASHRAE 189.1 Section 6.3.2.1 (Plumbing Fixtures and Fittings), the main restrictions are listed below but are incomplete:\n• Water closets: flush rate of 1.28 gal per flush max, or in major renovations up to 1.6 gpf\n• Urinal fixtures: 0.5 gpf max\n• Toilet fixtures: MaP (Maximum Performance) test to exceed 18 oz waste removal or EPA WaterSense product\n• Residential bathroom faucets: 1.5 gal per minute max, 0.8 gpm min.\n• Residential kitchen faucets: 2.2 gpm max\n• Public bathroom faucets: 0.5 gpm max (excludes kitchens and janitor sinks)\n• Showerheads: 2.0 gpm max\n\nMeet the requirements of ASHRAE 189.1 Section 6.3.2.2 (Appliances)\n• Clothes washers: public units, water factor of 7.5 gal/cubic foot of drum capacity-normal cycle max, residential 6.0 gal/ft3 max"]
["ASHRAE Reference","ASHRAE 189.1 Section 6.3.2.1, 6.3.2.2"]
["1-200-02, 2-5.2 - Outdoor Water","Meet the requirements of UFC 3-201-02 and the following requirements of ASHRAE 189.1 when life cycle cost effective:  Section 6.3.1 (Mandatory Provisions: Site Water Use Reduction) and either Section 6.4.1 (Prescriptive Option: Site Water Use Reduction) or Section 6.5.1 (Performance Option: Site Water Use Reduction).\n\nSection 6.3.1: A minimum of 60% of the area has native and adapted plants other than turf (excludes athletic fields and golf courses), automatic irrigations systems are hydrozoned for different plants, sprinklers are not within 3 ft of any building, and smart controllers are used where the irrigation adequacy is 80% of minimum evapotranspiration and excess is not greater than 10%.\n\nSection 6.4.1:. A maximum of one-third of improved landscape should be irrigated with potable water (excludes athletic fields), golf courses use only reclaimed water, and potable water should be only used during landscape establishment period for up to 70% of evapotranspiration rate for turf and 55% evapotranspiration rate for other.\n\nSection 6.5.1: Irrigation should be 35% of total water demand. Calculate the baseline water demand based on evapotranspiration rates for the applicable climatic area. Water demand is the product of the area of the landscape, the evapotranspiration rate of the vegetation and any necessary corrections based on site-specific variables. "]
["ASHRAE Reference","ASHRAE 189.1 Section 6.3.1, 6.4.1, 6.5.1"]
["1-200-02, 2-5.3 - Water used for Heating and Cooling","Meet the requirements of the following sections of ASHRAE 189.1 when life cycle cost effective:\n\nSection 6.3.2.3(a) and (b) (HVAC Systems and Equipment): Potable water is not used for once-through cooling and cooling towers have makeup and blowdown meters, conductivity controllers, overflow alarms, and efficient drift eliminators.  Drift reductions are max of 0.002% of recirculated water volume for counterflow towers and 0.005% for cross-flow.\n\nSection 6.3.2.3(c) (HVAC Systems and Equipment).  Condensate from AC units >65,000 Btu/h or steam systems is recovered. Recovery is not required if there is no practical use for the collected condensate.\n\nSection 6.4.2.1 (Cooling Towers).If makeup water is <200 ppm of total hardness (calcium carbonate), at least 5 cycles of concentration have been achieved. If >200 ppm, at least 3.5 cycles have been achieved."]
["ASHRAE Reference","ASHRAE 189.1 Section 6.3.2.3, 6.4.2.1"]
[null,"HPSB IV: Enhance Indoor Environmental Quality (UFC 1-200-02, 2-6)"]
["1-200-02, 2-6.1 - Ventilation and Thermal Comfort","Meet the requirements of ASHRAE 189.1 Section 8.3.1 (Indoor Air Quality) and Section 8.3.2 (Thermal Environmental Conditions for Human Occupancy).  Documentation as described in ASHRAE 55 Section 6.2 is not required. Compliance with standards by providing passive (non-mechanical) thermal comfort methods are allowed and encouraged as described in paragraph 2-2.1 in the UFC.\n\nSection 8.3.1: Requires compliance with ANSI/ASHRAE Standard 62.1, including NAAQS-area specific particulate matter filter, entry mats and surface, and no smoking requirements.\n\nSection 8.3.2: Requires compliance with ANSI/ASHRAE Standard 55 Sections 6.1-6.2 (UFC does not require this documentation for 6.2)"]
["ASHRAE Reference","ASHRAE 189.1 Sections 8.3.1, 8.3.2,  ANSI/ASHRAE 55 Section 6.1-6.2, ANSI/ASHRAE 62.1"]
["1-200-02, 2-6.2 - Moisture Control","Meet the requirements of ASHRAE 189.1 Section 10.3.1.5 (Moisture Control) \n• Absorbent materials stored on site or installed were protected from moisture and building materials with visual evidence of biological growth were not installed\n\nMeet and UFC 3-101-01 Chapter 3, Building Envelope Requirements."]
["ASHRAE Reference","ASHRAE 189.1, Section 10.3.1.5"]
["1-200-02, 2-6.3 - Daylighting and Lighting Control","Meet the requirements of ASHRAE 189.1 Section 8.4.1 (Daylighting by Sidelighting) or Section 8.5.1 (Daylighting Simulation).  The brief details that follow are not a replacement for referring to the guidance in ASHRAE 189.1.\n\nSection 8.4.1 - for offices:\n• N, S, and E facades minimum sidelighting effective aperture = (Sum of window area x window visible light transmittance) / area of primary sidelighted area\n• Combined width of primary sidelighted areas is at least 75% of length of façade wall\n• Opaque interior surfaces have visible light reflectance greater than or equal to 80% for ceilings and 70% for partitions (>60in) in daylight areas\n• W, S, and E facades designed with shading projects with PF not less tan 0.5\n\nSection 8.5.1 – for offices:\n• Illuminance is at least 30 fc on a plane 3 ft above the floor in 75% of daylight areas\n• Direct sun is not on a work surface for more than 20% of occupied hours on the equinox\n\nProvide automated lighting controls in accordance with UFC 3-530-01."]
["ASHRAE Reference","ASHRAE 189.1 Section 8.4.1, 8.5.1"]
["1-200-02, 2-6.4 - Low Emitting Materials","Meeting the requirements of ASHRAE 189.1 Sections 8.4.2 (Prescriptive Option: Materials) or Section 8.5.2 (Performance Option: Materials) demonstrates compliance.\n\nSection 8.4.2: Adhere to the following VOC content rules or CA/DHS/EHLB/R-174:\n• Adhesives and Sealants: SCAQMD Rule 1168, Green Seal Standard GS-36\n• Paints and Coatings: Green Seal Standard GS-11, SCAQMD Rule 1113\n• Composite wood, wood panels, and agrifiber: No added urea-formaldehyde resins for interior spaces, or CARB Airborne Toxic Control Measure to Reduce Formaldehyde Emissions from Composite Wood Products\n• Office Furniture and Seating: ANSI/BIFMA Standard M7.1-2007, with concentration limits in Table E1.1 of the aforementioned standard.\n• Ceilings and Wall Systems\n\nSection 8.5.2: Total concentration of each VOC emitted from all materials is less than the limit in Section 4.3 of the CA/DHS/EHLB/R-174 (California Section 01350)"]
["ASHRAE Reference","ASHRAE 189.1 Section 8.4.2, 8.4.2"]
["1-200-02, 2-6.5 - Protect Indoor Air Quality during and after Construction","Meet the requirements of ASHRAE 189.1 Section 10.3.1.4 (Indoor Air Quality (IAQ) Construction Management).\n\n• IAQ construction management plan implemented\n• Air conveyance materials stored and covered\n• Air filters and controls were functioning during flush-out or baseline monitoring\n• Permanent HVAC systems only used for system startup, testing, balancing and commissioning during construction\n• After construction, prior to occupancy with all finishes installed, the building was flushed-out or there was baseline IAQ monitoring.\n"]
["ASHRAE Reference","ASHRAE 189.1, Section 10.3.1.4"]
["1-200-02, 4-6.6 - Environmental Tobacco Smoke","Implement a policy and post signage indicating that smoking is prohibited within the building and within 25 feet of all building entrances, operable windows, and building ventilation intakes during building occupancy. "]
["ASHRAE Reference","Not provided"]
[null,"HPSB V: Reduce Environmental Impact of Materials (UFC 1-200-02, 2-7)"]
["1-200-02, 2-7.1 - Environmentally Preferable Products","Use products that have a lesser or reduced effect on human health and the environment. Consider product lifecycle when compared with competing products or services serving the same purpose.  A number of standard and eco-labels are available in the marketplace to assist specifiers in making environmentally preferable decisions.  Electronic devices, products and appliances purchased should be EPEAT certified.  For a list of products and recommendations designated for Federal procurement, consult the Green Products Compilation at http://www.gsa.gov/greenproductscompilation and the Federal Green Construction Guide for Specifiers."]
["ASHRAE Reference","Not provided"]
["1-200-02, 2-7.2 - Recycled Content","Meet the requirements of ASHRAE 189.1 Section 9.4.1.1 (Recycled Content) when products are available.\nPer RCRA Section 6002, for EPA-designated products, specify products meeting or exceeding EPA's recycled content recommendations.  EPA’s recycled content product designations and recycled content recommendations are available on EPA’s Comprehensive Procurement Guideline web site at http://www.epa.gov/epawaste/conserve/tools/cpg/index.htm.  Requirements will be met when products are available.\n\nASHRAE 189.1 Section 9.4.1.1 (Recycled Content):\n• The sum of post-consumer recycled content plus one-half of the pre-consumer recycled content is a minimum of 10%, based on cost, of total materials."]
["ASHRAE Reference","ASHRAE 189.1 Section 9.4.1.1"]
["1-200-02, 2-7.3 - Biologically-based products","Per Section 9002 of the Farm Security and Rural Investment Act, specify products composed of the highest percentage of biobased content consistent with the USDA BioPreferred Program, if products meet performance requirements and are available at a reasonable cost.  USDA’s biobased product designations and biobased content recommendations are available on USDA’s BioPreferred web site at http://www.biopreferred.gov/. "]
["ASHRAE Reference","Not provided"]
["1-200-02, 2-7.4 - Waste and Materials Management ","Meet the requirements of ASHRAE 189.1 Section 9.3.1.1 (Construction Waste Management-Diversion) and Section 9.3.4.1 (Storage and Collection of Recyclables – Recyclables), where markets or onsite recycling opportunities exist or are anticipated.\n\nSection 9.3.1.1: A minimum of 50% of nonhazardous construction and demolition waste is diverted from landfills and incinerators\n\nSection 9.3.4.1: There is an area that is dedicated to collecting materials for recycling (paper, cardboard, glass, plastics and metals), suggested minimum area increase with the size of the building."]
["ASHRAE Reference","ASHRAE 189.1 Section 9.3.1.1"]
["1-200-02, 2-7.4 - Ozone Depleting Substances","Meet the requirements of ASHRAE 189.1 Section 9.3.3 (Refrigerants).  Exceptions: Refer to UFC 3-600-01 for fire system requirements\n\nSection 9.3.3: CFC-based refrigerants have not been used in HVAC&R systems; Fire suppression does not contain CFCs, HCFCs or halons."]
["ASHRAE Reference","ASHRAE 189.1 Section 9.3.3"]

{"sheet":"Guidance","index":2,"n_rows":134,"n_cols":2,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,5,1],[4,0,4,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["High Performance Sustainable Building Requirements, UFC 1-200-02, and LEED® 2009 References"]
["For more information on LEED® Credits that meet or align closely with federal requirements as well as other credits a building can pursue towards the Silver certification level, review the LEED® New Construction and Major Renovations 2009 Rating System"]
["Color Code"]
["LEED® Credits and/or Prerequisites that align closely with Federal High Performance Sustainable Buildings (HPSB) Requirements\nThese credits and/or prerequisites align closely with the associated HPSB Guiding Principle.  They could be either more or less stringent or have different measurement metrics.  In the case where one is more stringent than the other, achieving the more stringent one does not imply the less stringent is achieved."]
["LEED® Credits and/or Prerequisites that meet Federal High Performance Sustainable Buildings (HPSB) Requirements\nThese credits and/or prerequisites have the same requirements as the associated HPSB Guiding Principle. This does not guarantee achieving the LEED Credit, as some documentation methods may vary."]
["References"]
["EO 13423 High Performance Sustainable Building Guidance (Dec 08)"]
["LEED(R) for New Construction & Major Renovations 2009 - Nov 2008"]
[]
[null,"HPSB I: Employ Integrated Design Principles"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBI.1\",\"Integrated Design\nHPSB I.1\nUFC 1-200-02 para 2-2.1\")","v":"Integrated Design\nHPSB I.1\nUFC 1-200-02 para 2-2.1"},"Use a collaborative, integrated planning and design team, composed of user, government support staff, and appropriate professionals, to identify requirements and to establish performance goals for siting, energy, water, materials, indoor environmental quality, and other comprehensive design goals.  Ensure incorporation of these goals throughout the design and lifecycle of the building, including deconstruction.\nSite attributes, including climate and local and regional context, impact the design of the building.  Evaluate the site and building components to determine whether passive and natural design strategies and features are cost effectively incorporated before the active and mechanical systems are designed.\n\nUse the following sequential approach:\n• Analyze potential sites and associated climate including local and regional context.\n• Select a sustainable site.\n• Design building to site analysis focusing on orientation, configuration and massing.\n• Select and integrate into the design, high performance and sustainable building envelope strategies and components (e.g. roofs, walls, fenestrations).\n• Select, design and integrate into the overall design, high performance and sustainable systems (e.g. HVAC, plumbing, water heating systems, lighting systems, control systems, elevators, and fire protection systems).  \n\nIncorporate integrated design as described in ASHRAE 189.1 Informative Appendix H (Integrated Design).  Follow the steps of design optimization, as applicable, in ASHRAE 189.1 Section H1.1.1 (Charrette Process)."]
["Requirement Source Document(s)","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBI.2\",\"Commissioning\nHPSB I.2\nUFC 1-200-02 para 2-2.2\")","v":"Commissioning\nHPSB I.2\nUFC 1-200-02 para 2-2.2"},"Employ commissioning practices appropriate to the size and complexity of the building and its system components in order to verify performance and ensure that design requirements are met.  This must include an experienced commissioning provider.  The use of contracted services or Government personnel as the commissioning provider will be determined at project level.\n\nMeet the requirements of ASHRAE 189.1 Section 10.3.1.2 (Building Project Commissioning), with the following modifications:\n• For buildings and systems that are less complex, commissioning can be tailored as determined by the DoD Component AHJ . For Air Force projects, the Project Delivery Team must determine the level of commissioning activities required.\n• “Schematic design” is the design charrette or similar conceptual design activity.\n• Delete the requirement to meet ASHRAE 55 Section 6.2 (Documentation)."]
["Requirement Source Document(s)","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EAPR1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Prerequisite 1: Fundamental Commissioning of Building Energy Systems\nLEED EA Credit 3: Enhanced Commissioning"]
["LEED Credit(s) meet HPSB:","None"]
[null,"UFC 1-200-02, 2-3. Promote Sustainable Location and Site Development"]
[{"$f":"HYPERLINK(\"#\"&\"UFC_231\",\"Site selection\nUFC 1-200-02 para 2-3.1\")","v":"Site selection\nUFC 1-200-02 para 2-3.1"},"Meet the requirements in UFC 2-100-01 and UFC 3-101-01.\n\nDuring the site selection process, give preference to sites which posses the following characteristics when appropriate:\n• Adaptive reuse or renovation of buildings or sites (including historic buildings), or use of previously disturbed/developed areas\n• Building orientation to maximize energy efficiency, passive solar and daylighting potential of the building\n• Locations in central business districts (cantonment areas) and rural town centers (remote locations)\n• Sites well served by public or other transit if available or projected to be available\n• Site design elements that ensure safe and convenient pedestrian access\n• Proximity to housing\n• Avoiding development of sensitive land resources (including greenfields and USDA Prime Farmland as defined in 7 USC 4201)\n• Consult with local Cultural Resource Manager to identify potential impacts to existing historic buildings, districts, or view sheds\n• Parking management strategies to encourage co-use of shared parking"]
["Requirement Source Document(s)","UFC 1-200-02 para 2-3.1"]
["LEED Credit(s) aligns closely with HPSB:","LEED SS Credits 1 -5 (Site Selection, Development Density and Community Connectivity, Brownfield Redevelopment, Alternative Transportation, Site Development)"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"UFC_232\",\"Mitigation of Heat Island Effect\nUFC 1-200-02 para 2-3.2\")","v":"Mitigation of Heat Island Effect\nUFC 1-200-02 para 2-3.2"},"• For Site Hardscapes – Meet the requirements in ASHRAE 189.1 Section 5.3.2.1 (Site Hardscape) for sidewalks, courtyards and POV parking areas.  For all other site hardscapes, implement to the maximum extent practical.  The use of Section 5.3.2.1(e) is not allowed.\n• For Walls – Meet the requirements in ASHRAE 189.1 Section 5.3.2.2 (Walls).\n• For Roofs – Meet the requirements in UFC 3-110-03.\n"]
["Requirement Source Document(s)","UFC 1-200-02 para 2-3.2"]
[{"$f":"HYPERLINK(\"#\"&\"SS_7\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED SS – Credits 7.1 and 7.2: Heat Island Effect Roof and Non-Roof"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"UFC_233\",\"Reduction of Light Pollution\nUFC 1-200-02 para 2-3.3\")","v":"Reduction of Light Pollution\nUFC 1-200-02 para 2-3.3"},"Meet the requirements of UFC 3-530-01."]
["Requirement Source Document(s)","UFC 3-530-01"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"SS_8\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED SS - Credit 8: Light Pollution Reduction"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3\",\"Stormwater Management\nHPSB III.3-4\nUFC 1-200-02 para 2-3.4\")","v":"Stormwater Management\nHPSB III.3-4\nUFC 1-200-02 para 2-3.4"},"Meet the requirements of UFC 3-210-10.\n\nEmploy design and construction strategies that reduce storm water runoff and discharges of polluted water offsite. Per EISA Section 438, to the maximum extent technically feasible, maintain or restore the predevelopment hydrology of the site with regard to temperature, rate, volume, and duration of flow using site planning, design, construction, and maintenance strategies. This question includes both construction storm water discharge controls and stormwater design."]
["Requirement Source Document(s):","EISA 2007 Sec 438"]
["LEED Credit(s) aligns closely with HPSB:","LEED SS Credit 6.1: Stormwater Design - Quantity Control\nLEED SS Credit 6.2: Stormwater Design - Quality Control"]
[{"$f":"HYPERLINK(\"#\"&\"SSPR1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED SS Prerequisite 1: Construction Activity Pollution Prevention"]
[null,"HPSB II: Optimize Energy Performance (UFC 1-200-02, 2.4)"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBII.1\",\"Energy Efficiency\nHPSB II.1\nUFC 1-200-02 para 2-4.1\")","v":"Energy Efficiency\nHPSB II.1\nUFC 1-200-02 para 2-4.1"},"Design the building to achieve at least 30% energy consumption reduction from ASHRAE 90.1 (2007) baseline or 12% energy consumption reduction from ASHRAE 90.1 (2010) baseline.  For Navy and Air Force projects, use ASHRAE 90.1 (2007) baseline, except for the performance rating formula in G1.2, which should be used as follows (from 10 CFR 433.5): \n\nPercentage improvement = 100 x (Baseline building consumption—Proposed building consumption) ÷(Baseline building consumption—Receptacle and process loads).\n\nThis differs from the LEED calculation. Note: The Scoresheet assumes that any project with a design date after 2013 will be based on ASHRAE 90.1 (2010).\n\nDesign Federal low-rise residential buildings to achieve at least 30% energy consumption reduction from International Energy Conservation Code (IECC) baseline.\n\nIf a 30% reduction is not life-cycle cost-effective, the design of the proposed building must be modified so as to achieve an energy consumption level at or better than the maximum level of energy efficiency that is life-cycle cost-effective."]
["Requirement Source Document(s)","10 CFR 433, EPAct 05"]
[{"$f":"HYPERLINK(\"#\"&\"EAPR2\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Prerequisite 2: Minimum Energy Performance \nLEED EA Credit 1: Optimize Energy Performance"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBII.3\",\"On-site Renewable Energy - Solar Hot Water Heater System\nHPSB II.3\nUFC 1-200-02 para 2-4.2\")","v":"On-site Renewable Energy - Solar Hot Water Heater System\nHPSB II.3\nUFC 1-200-02 para 2-4.2"},"Per the Energy Independence and Security Act (EISA) Section 523, meet at least 30% of the hot water demand through the installation of solar hot water heaters, when lifecycle cost effective."]
["Requirement Source Document(s):","EISA Sec. 523"]
[{"$f":"HYPERLINK(\"#\"&\"EA2.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Credit 2: On-Site Renewable Energy"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBII.4\",\"On-site Renewable Energy\nHPSB II.4\nUFC 1-200-02 para 2-4.2\")","v":"On-site Renewable Energy\nHPSB II.4\nUFC 1-200-02 para 2-4.2"},"Provide on-site renewable energy systems in accordance with ASHRAE 189.1 Section 7.4.1.1 (On-Site Renewable Energy Systems) where life-cycle cost effective considering climate, infrastructure condition, mission compatibility, and effects on base wide electrical system (grid) power quality.  Exception: Purchase of renewable energy certificates (RECs) must not be used as a substitute for the Section 7.4.1.1 new building requirement.\n\nWhen renewable systems are provided, comply with IEEE 1547 for renewable systems interface to the electrical system grid.  Note: The IEEE 1547 Series of Interconnection Standards are available from IEEE (http://grouper.ieee.org/groups/scc21/dr_shared/) as design guides for IEEE 1547 implementation.\n\nDesigns must include the following requirements in order to limit the risk to energy security:\na. Direct interconnection of system to installation-wide electrical system (grid):\n• For renewable systems that include a tie-in by a direct connection to the primary distribution system, provide a cumulative renewable load analysis of both the direct connection and building renewable power systems.\n• Evaluate the proposed systems and verify there are no adverse effects on the installation-wide electrical system frequency control, voltage regulation and power quality.  See Appendix B for issues that should be considered.\nb. Direct interconnection of system to buildings that utilize engine generators that may operate in parallel with the renewable energy generation:\n• Evaluate the proposed systems and verify there are no adverse effects on the generator’s ability to maintain frequency control, voltage regulation and power quality.  See Appendix B for issues that should be considered.\n• If the stability of the combined systems cannot be confirmed, then design system to automatically disconnect renewable power generation when the backup generator is in operation.\nc. Direct interconnection of system to buildings that either do not utilize engine generators or have backup power systems that would never operate in parallel with the renewable energy generation, such as a backup generator supplying power via an automatic transfer switch:\n• Provide analysis validating that electrical system design address the electrical characteristics (real and reactive power output) of the renewable system.\n"]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EA2.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Credit 2: On-Site Renewable Energy"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBII.5\",\"Measurement and Verification\nHPSB II.5\nUFC 1-200-02 para 2-4.4 and 2-5.4\")","v":"Measurement and Verification\nHPSB II.5\nUFC 1-200-02 para 2-4.4 and 2-5.4"},"A utility meter must be installed at each building, for each utility serving the building (e.g. district steam, district hot and chilled water, electricity, natural gas, fuel oil, etc.) in the normal units of the measure (i.e. kWh, kW, cf, gallons, etc.).  Meters must be connected to a base wide energy and utility monitoring and control system using the installation’s advanced metering protocols.  The installation of meters is required per DODI 4170.11, Installation Energy Management.\n\nImplement submetering when authorized in writing by the Installation.  Utilize ASHRAE 189.1 Section 7.3.3 (Energy Consumption Management) as guide for subsystem implementation.\n\nInstall water meters to monitor use in buildings consuming indoor and outdoor water as required by DODI 4170.11.\nThe installation of separate water meters for locations with outdoor water use is encouraged."]
["Requirement Source Document(s):","EPAct 2005 Section 103, EISA 2007 Section 434"]
["Links","Energy Policy Act of 2005"]
[{"$f":"HYPERLINK(\"#\"&\"EA5.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Credit 5: Measurement and Verification"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"UFC_243_2\",\"UFC 2-4.3: Provide an Energy Compliance Analysis (Recommended)\")","v":"UFC 2-4.3: Provide an Energy Compliance Analysis (Recommended)"},"Provide an Energy Compliance Analysis (ECA) which will demonstrate compliance with all energy related requirements in this UFC.  "]
["UFC Reference","UFC 1-200-02, 2-4.3"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"EISA2007II.7\",\"EISA 2007 II.7: Reduction in fossil fuel-generated energy consumption\")","v":"EISA 2007 II.7: Reduction in fossil fuel-generated energy consumption"},"For new Federal buildings and Federal buildings undergoing major renovations…(I) The buildings shall be designed so that the fossil fuel generated energy consumption of the buildings is reduced, as compared with such energy consumption by a similar building in fiscal year 2003 (CBECS or RECS data from EIA), by the percentage specified...FY2010 (55%), 2015 (65%), 2020 (80%), 2025 (90%), and 2030 (100%). The DOE Rulemaking is not yet complete"]
["Requirement Source Document(s):","EISA 2007, Sec. 433, (a)(D)(i)"]
["Links","Energy Independence and Security Act of 2007"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"UFC_245\",\"HPSB 2.6: Benchmarking\")","v":"HPSB 2.6: Benchmarking"},"Compare annual performance data with previous years’ performance data, by entering annual performance data in a measurement and tracking tool such as EPA’s ENERGY STAR®, Portfolio Manager.  The Labs21® Energy Benchmarking Tool may be used to benchmark laboratory buildings.  Results of benchmarking should be used to inform capital investment decisions for future projects.  "]
["UFC Reference","UFC 1-200-02, 2-4.5"]
["Requirement Source Document(s):","Federal Leadership in High Performance and Sustainable Buildings MOU"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[null,"HPSB III: Protect and Conserve Water"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIII.1\",\"Indoor Water\nHPSB III.1\nUFC 1-200-02 para 2-5.1\")","v":"Indoor Water\nHPSB III.1\nUFC 1-200-02 para 2-5.1"},"Meet the requirements of ASHRAE 189.1 Section 6.3.2.1 (Plumbing Fixtures and Fittings).  Water closet replacements in major renovations may have a flush value of up to 1.6 GPF (6.1 LPF) to accommodate existing plumbing capacity.\n\nSpecify EPA WaterSense-labeled products, where appropriate and available.\n\nMeet the requirements of ASHRAE 189.1 Section 6.3.2.2 (Appliances).\n"]
["Requirement Source Document(s):","EPAct 1992"]
[{"$f":"HYPERLINK(\"#\"&\"WE3.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED WE Credit 3: Water Use Reduction - Reduce by 30% (3.1), 35% (3.2), 40% (3.3)"]
[{"$f":"HYPERLINK(\"#\"&\"WEPR1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED WE Prerequisite 1: Water Use Reduction - 20% Reduction"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIII.2\",\"Outdoor Water\nHPSB III.2\nUFC 1-200-02 para 2-5.2\")","v":"Outdoor Water\nHPSB III.2\nUFC 1-200-02 para 2-5.2"},"Use water efficient landscape and irrigation strategies, such as water reuse, xeriscaping and the use of harvested rainwater, to reduce outdoor potable water consumption by a minimum of 50%.  This requirement must be demonstrated by comparison to a baseline building using the EPA WaterSense landscape water budget tool version 1.01 or later, or a Component approved tool.\n\nMeet the requirements of UFC 3-201-02 and the following requirements of ASHRAE 189.1 when life cycle cost effective:  Section 6.3.1 (Mandatory Provisions: Site Water Use Reduction) and either Section 6.4.1 (Prescriptive Option: Site Water Use Reduction) or Section 6.5.1 (Performance Option: Site Water Use Reduction).\n\nShow preference for irrigation contractors who are certified through a WaterSense labeled program."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"WE1.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED WE Credit 1.2: Water Efficient Landscaping - No Potable Water Use or Irrigation"]
[{"$f":"HYPERLINK(\"#\"&\"WE1.1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED WE Credit 1.1: Water Efficient Landscaping - Reduce by 50%"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIII.4\",\"Water Used for Heating and Cooling\nHPSB III.4\nUFC 1-200-02 para 2-5.3\")","v":"Water Used for Heating and Cooling\nHPSB III.4\nUFC 1-200-02 para 2-5.3"},"Meet the requirements of the following sections of ASHRAE 189.1 when life cycle cost effective.\n• Meet the requirements of Sections 6.3.2.3(a) and (b) (HVAC Systems and Equipment). \n• Section 6.3.2.3(c) (HVAC Systems and Equipment).  Condensate collection is not required if there is no practical use for the collected condensate.\n• Section 6.4.2.1 (Cooling Towers).\n\nPer EPAct 2005 Section 109, when potable water is used to improve a building’s energy efficiency, implement lifecycle cost effective water conservation measures."]
["Requirement Source Document(s):","EPAct 2005, Sec. 109"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[null,"HPSB IV: Enhance Indoor Environmental Quality (UFC 1-200-02, 2-6)"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.1\",\"Thermal Comfort\nHPSB IV.1\nUFC 1-200-02 para 2-6.1\")","v":"Thermal Comfort\nHPSB IV.1\nUFC 1-200-02 para 2-6.1"},"Meet the requirements of ASHRAE 189.1 Section 8.3.2 (Thermal Environmental Conditions for Human Occupancy).  Documentation as described in ASHRAE 55 Section 6.2 is not required.  Compliance with standards by providing passive (non-mechanical) thermal comfort methods are allowed and encouraged as described in paragraph 2-2.1 in the UFC."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"EQ7.1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED EQ Credit 7: Thermal Comfort - Design"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.2\",\"Ventilation\nHPSB IV.2\nUFC 1-200-02 para 2-6.1\")","v":"Ventilation\nHPSB IV.2\nUFC 1-200-02 para 2-6.1"},"Meet the requirements of ASHRAE 189.1 Section 8.3.1 (Indoor Air Quality)."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"EQPR1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED EQ Prerequisite 1: Minimum Indoor Air Quality Performance"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.3\",\"Moisture Control\nHPSB IV.3\nUFC 1-200-02 para 2-6.2\")","v":"Moisture Control\nHPSB IV.3\nUFC 1-200-02 para 2-6.2"},"Establish and implement a moisture control strategy for controlling moisture flows and condensation to prevent building damage, minimize mold contamination, and reduce health risks related to moisture.  Meet the requirements of ASHRAE 189.1 Section 10.3.1.5 (Moisture Control) and UFC 3-101-01 Chapter 3, Building Envelope Requirements."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.4\",\"Daylighting\nHPSB IV.4\nUFC 1-200-02 para 2-6.3\")","v":"Daylighting\nHPSB IV.4\nUFC 1-200-02 para 2-6.3"},"Meet the requirements of ASHRAE 189.1 Section 8.4.1 (Daylighting by Sidelighting) or Section 8.5.1 (Daylighting Simulation).  Provide automated lighting controls in accordance with UFC 3-530-01."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EQ8.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EQ Credit 8.1: Daylight and Views - Daylight\nLEED EQ Credit 6.1: Controllability of Systems - Lighting"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.5\",\"Low Emitting Materials\nHPSB IV.5\nUFC 1-200-02 para 2-6.4\")","v":"Low Emitting Materials\nHPSB IV.5\nUFC 1-200-02 para 2-6.4"},"Specify materials and products with low pollutant emissions, including composite wood products, adhesives, sealants, interior paints and finishes, carpet systems, and furnishings.  Meeting the requirements of ASHRAE 189.1 Sections 8.4.2 (Prescriptive Option: Materials) or Section 8.5.2 (Performance Option: Materials) demonstrates compliance."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EQ4.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EQ Credits 4.1-4.4: Low-Emitting Materials - Adhesives and Sealants (4.1), Paints and Coatings (4.2), Flooring Systems (4.3), and Composite Wood and Agrifiber Products (4.4)"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6\",\"Protect Indoor Air Quality during Construction\nHPSB IV.6\nUFC 1-200-02 para 2-6.5\")","v":"Protect Indoor Air Quality during Construction\nHPSB IV.6\nUFC 1-200-02 para 2-6.5"},"Follow the recommended approach of SMACNA 008.  After construction and prior to occupancy, conduct a minimum 72-hour flush-out with maximum outdoor air consistent with achieving relative humidity no greater than 60%. After occupancy, continue flush-out as necessary to minimize exposure to contaminants from new building materials.  Meet the requirements of ASHRAE 189.1 Section 10.3.1.4 (Indoor Air Quality (IAQ) Construction Management)."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EQ3.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EQ Credit 3.1: Construction Indoor Air Quality Management Plan - During Occupancy\nLEED EQ Credit 3.2: Construction Indoor Air Quality Management Plan - Before Occupancy"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBIV.7\",\"Environmental Tobacco Smoke Control\nHPSB IV.7\nUFC 1-200-02 para 4-6.6\")","v":"Environmental Tobacco Smoke Control\nHPSB IV.7\nUFC 1-200-02 para 4-6.6"},"Prohibit smoking within the building and within 25 feet (7.62 meters) of all building entrances, operable windows, and building ventilation intakes. "]
["Requirement Source Document(s):","Federal Register: December 22, 2008 (Volume 73, Number 246) - EO 13058"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"EQPR2\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED EQ Prerequisite 2: Environmental Tobacco Smoke (ETS) Control"]
[null,"HPSB V: Reduce Environmental Impact of Materials (UFC 1-200-02, 2-7)"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.1\",\"Recycled Content\nHPSB V.1\nUFC 1-200-02 para 2-7.2\")","v":"Recycled Content\nHPSB V.1\nUFC 1-200-02 para 2-7.2"},"Meet the requirements of ASHRAE 189.1 Section 9.4.1.1 (Recycled Content) when products are available.\n\nPer RCRA Section 6002, for EPA-designated products, specify products meeting or exceeding EPA's recycled content recommendations. For other products, specify materials with recycled content when practicable. EPA’s recycled content product designations and recycled content recommendations are available on EPA’s Comprehensive Procurement Guideline web site at http://www.epa.gov/epawaste/conserve/tools/cpg/index.htm.  Requirements will be met when products are available."]
["Requirement Source Document(s):","RCRA 2002, Sec 6002"]
[{"$f":"HYPERLINK(\"#\"&\"MR4.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED MR Credit 4.1-4.2: Recycled Content - 10% of Content (4.1), 20% of Content (4.2)"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.2\",\"Biologically-based Products\nHPSB V.2\nUFC 1-200-02 para 2-7.3\")","v":"Biologically-based Products\nHPSB V.2\nUFC 1-200-02 para 2-7.3"},"Per Section 9002 of the Farm Security and Rural Investment Act, specify products composed of the highest percentage of biobased content consistent with the USDA BioPreferred Program, if products meet performance requirements and are available at a reasonable cost.  USDA’s biobased product designations and biobased content recommendations are available on USDA’s BioPreferred web site at http://www.biopreferred.gov/. "]
["Requirement Source Document(s):","FSRIA 2002 Section 9002"]
[{"$f":"HYPERLINK(\"#\"&\"MR6.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED MR Credit 6: Rapidly Renewable Materials\nLEED MR Credit 7: Certified Wood"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.3\",\"Environmentally Preferable Products\nHPSB V.3\nUFC 1-200-02 para 2-7.1\")","v":"Environmentally Preferable Products\nHPSB V.3\nUFC 1-200-02 para 2-7.1"},"Use products that have a lesser or reduced effect on human health and the environment.  Consider product life-cycle when compared with competing products or services serving the same purpose.  A number of standard and eco-labels are available in the marketplace to assist specifiers in making environmentally preferable decisions.  Electronic devices, products and appliances purchased should be EPEAT certified.  For a list of products and recommendations designated for Federal procurement, consult the Green Products Compilation at http://www.gsa.gov/greenproductscompilation and the Federal Green Construction Guide for Specifiers."]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
["LEED Credit(s) meet HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.4\",\"Waste and Materials Management - Recycling\nHPSB V.4\nUFC 1-200-02 para 2-7.4\")","v":"Waste and Materials Management - Recycling\nHPSB V.4\nUFC 1-200-02 para 2-7.4"},"Meet the requirements of ASHRAE 189.1  Section 9.3.4.1 (Storage and Collection of Recyclables – Recyclables), where markets or onsite recycling opportunities exist or are anticipated.\nIncorporate adequate space, equipment, and transport accommodations for recycling in the building design. During a project's planning stage, identify local recycling and salvage operations that could process site-related construction and demolition materials. Provide salvage, reuse and recycling services for waste generated from major renovations, where markets or onsite recycling opportunities exist. "]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"MRPR1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED MR Prerequisite 1: Storage and Collection of Recyclables"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.5\",\"Waste and Materials Management, Divert 50% from Disposal\nHPSB V.5\nUFC 1-200-02 para 2-7.4\")","v":"Waste and Materials Management, Divert 50% from Disposal\nHPSB V.5\nUFC 1-200-02 para 2-7.4"},"Meet the requirements of ASHRAE 189.1 Section 9.3.1.1 (Construction Waste Management-Diversion) , where markets or onsite recycling opportunities exist or are anticipated.\n\nDuring a project's planning stage, identify local recycling and salvage operations that could process site-related construction and demolition materials. Provide salvage, reuse and recycling services for waste generated from major renovations, where markets or onsite recycling opportunities exist. During construction, recycle or salvage at least 50 percent of the non-hazardous construction, demolition and land clearing materials, excluding soil, where markets or onsite recycling opportunities exist.   "]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
["LEED Credit(s) aligns closely with HPSB:","None"]
[{"$f":"HYPERLINK(\"#\"&\"MR2.1\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED MR Credit 2.1: Construction Waste Management"]
[{"$f":"HYPERLINK(\"#\"&\"HPSBV.6\",\"Ozone Depleting Substances\nHPSB V.6\nUFC 1-200-02 para 2-7.5\")","v":"Ozone Depleting Substances\nHPSB V.6\nUFC 1-200-02 para 2-7.5"},"Meet the requirements of ASHRAE 189.1 Section 9.3.3 (Refrigerants).  Exceptions: Refer to UFC 3-600-01 for fire system requirements. "]
["Requirement Source Document(s):","Executive Order 13423 and 13514"]
[{"$f":"HYPERLINK(\"#\"&\"EA4.1\",\"LEED Credit(s) aligns closely with HPSB:\")","v":"LEED Credit(s) aligns closely with HPSB:"},"LEED EA Credit 4: Enhanced Refrigerant Management"]
[{"$f":"HYPERLINK(\"#\"&\"EAPR3\",\"LEED Credit(s) meet HPSB:\")","v":"LEED Credit(s) meet HPSB:"},"LEED EA Prerequisite 3: Fundamental Refrigerant Management"]

{"sheet":"LocationList","index":3,"n_rows":211,"n_cols":6,"rows_kept":211,"cut":false,"hidden":true,"merged":[]}
[null,"****FOUO******"]
[null,"BASE Selections:"]
[null,"BASE NAME","CITY","STATE","CONUS"]
[87,"Other","Other","Other","Other"]
[69,"Altus AFB","Altus","OK","Yes"]
[4,"Andersen AFB","Agana","Guam","No"]
[52,"Andrews AFB","Camp Springs","MD","Yes"]
[75,"Arnold AFB","Manchester","TN","Yes"]
[5,"Aviano AB","Pordenone","Italy","No"]
[50,"Barksdale AFB","Bossier City","LA","Yes"]
[28,"Beale AFB","Yuba City","CA","Yes"]
[21,"Bellows AFB","Honolulu","HI","Yes"]
[37,"Bolling AFB","Washington DC","DC","Yes"]
[33,"Buckley AFB","Denver","CO","Yes"]
[64,"Cannon AFB","Clovis","NM","Yes"]
[43,"Cape Canaveral AFS","Cape Canaveral","FL","Yes"]
[72,"Charleston AFB","Charleston","SC","Yes"]
[34,"Cheyenne Mountain AFS","Colorado Springs","CO","Yes"]
[54,"Columbus AFB","Columbus","MS","Yes"]
[65,"Creech AFB","Indian Springs","NV","Yes"]
[25,"Davis-Monthan AFB","Tucson","AZ","Yes"]
[38,"Dover AFB","Dover","DE","Yes"]
[76,"Dyess AFB","Abilene","TX","Yes"]
[29,"Edwards AFB","Edwards AFB","CA","Yes"]
[41,"Eglin AFB","Valpariso","FL","Yes"]
[19,"Eielson AFB","Fairbanks","AK","Yes"]
[74,"Ellsworth AFB","Rapid City","SD","Yes"]
[20,"Elmendorf AFB","Anchorage","AK","Yes"]
[86,"F. E. Warren AFB ","Cheyenne","WY","Yes"]
[84,"Fairchild AFB","Spokane","WA","Yes"]
[77,"Goodfellow AFB","San Angelo","TX","Yes"]
[59,"Grand Forks AFB","Grand Forks","ND","Yes"]
[51,"Hanscom AFB","Bedford","MA","Yes"]
[22,"Hickam AFB","Honolulu","HI","Yes"]
[82,"Hill AFB","Ogden","UT","Yes"]
[62,"Holloman AFB","Alamogordo","NM","Yes"]
[42,"Hurlburt Field","Ft Walton Beach","FL","Yes"]
[12,"Incirlik AB","Incirlik","Turkey","No"]
[18,"Izmir","Izmir ","Turkey","No"]
[6,"Kadena AB","Okinawa","Japan","No"]
[55,"Keesler AFB","Biloxi","MS","Yes"]
[63,"Kirtland AFB","Albuquerque","NM","Yes"]
[10,"Kunsan AB","Kunsan City","S. Korea","No"]
[78,"Lackland AFB","San Antonio","TX","Yes"]
[9,"Lajes Field","Terceira Island","Puerto Rico","No"]
[83,"Langley AFB","Hampton","VA","Yes"]
[79,"Laughlin AFB","Del Rio","TX","Yes"]
[24,"Little Rock AFB","Little Rock","AR","Yes"]
[30,"Los Angeles AFB","El Segundo","CA","Yes"]
[26,"Luke AFB","Phoenix","AZ","Yes"]
[39,"MacDill AFB","Tampa","FL","Yes"]
[56,"Malmstrom AFB","Great Falls","MT","Yes"]
[23,"Maxwell-Gunter AFB","Montgomery","AL","Yes"]
[85,"McChord AFB","Tacoma","WA","Yes"]
[49,"McConnell AFB","Wichita","KS","Yes"]
[60,"Minot AFB","Minot","ND","Yes"]
[7,"Misawa AB","Misawa","Japan","No"]
[45,"Moody AFB","Valdosta","GA","Yes"]
[47,"Mountain Home AFB","Mountain Home","ID","Yes"]
[66,"Nellis AFB","Las Vegas","NV","Yes"]
[61,"Offutt AFB","Bellevue","NE","Yes"]
[11,"Osan AB","Osan","S. Korea","No"]
[44,"Patrick AFB","Cocoa Beach","FL","Yes"]
[35,"Peterson AFB","Colorado Springs","CO","Yes"]
[57,"Pope AFB","Fayetteville","NC","Yes"]
[13,"RAF Alconbury","Alconbury","United Kingdom","No"]
[14,"RAF Croughton","Croughton","United Kingdom","No"]
[15,"RAF Fairford","Fairford","United Kingdom","No"]
[16,"RAF Lakenheath","Lakenheath","United Kingdom","No"]
[17,"RAF Mildenhall","Mildenhall","United Kingdom","No"]
[1,"Ramstein AB","Kaiserslautern","Germany","No"]
[80,"Randolph AFB","San Antonio","TX","Yes"]
[46,"Robins AFB","Warner Robins","GA","Yes"]
[67,"Rome Laboratory","Rome","NY","Yes"]
[36,"Schriever AFB","Colorado Springs","CO","Yes"]
[48,"Scott AFB","Bellville","IL","Yes"]
[58,"Seymour Johnson AFB","Goldsboro","NC","Yes"]
[73,"Shaw AFB","Sumter","SC","Yes"]
[81,"Sheppard AFB","Witchita Falls","TX","Yes"]
[2,"Spangdahlem AB","Trier","Germany","No"]
[3,"Thule AB","Thule","Greenland","No"]
[71,"Tinker AFB","Oklahoma City","OK","Yes"]
[27,"Travis AFB","Fairfield","CA","Yes"]
[40,"Tyndall AFB","Panama City","FL","Yes"]
[32,"USAF Academy","Colorado Springs","CO","Yes"]
[70,"Vance AFB","Enid","OK","Yes"]
[31,"Vandenberg AFB","Lompoc","CA","Yes"]
[53,"Whiteman AFB","Knob Noster","MO","Yes"]
[68,"Wright-Patterson AFB","Dayton","OH","Yes"]
[8,"Yokota AB","Tokyo","Japan","No"]
[]
[null,null,"Vertical","Horizontal","Utility","Industrial"]
[]
[null,0,"Not Achieved","Not Achieved","Not Achieved","Not Achieved"]
[null,1,"Not Achieved","Not Achieved","Not Achieved","Not Achieved"]
[null,2,"Not Achieved","Not Achieved","Not Achieved","Not Achieved"]
[null,3,"Not Achieved","Not Achieved","Not Achieved","Not Achieved"]
[null,4,"Not Achieved","Not Achieved","Not Achieved","Not Achieved"]
[null,5,"Not Achieved","Not Achieved","Certified","Not Achieved"]
[null,6,"Not Achieved","Not Achieved","Certified","Not Achieved"]
[null,7,"Not Achieved","Certified","Silver","Not Achieved"]
[null,8,"Not Achieved","Certified","Silver","Not Achieved"]
[null,9,"Not Achieved","Silver","Gold","Not Achieved"]
[null,10,"Not Achieved","Silver","Gold","Not Achieved"]
[null,11,"Not Achieved","Gold","Platinum","Not Achieved"]
[null,12,"Not Achieved","Gold","Platinum","Not Achieved"]
[null,13,"Not Achieved","Gold","Platinum","Not Achieved"]
[null,14,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,15,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,16,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,17,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,18,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,19,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,20,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,21,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,22,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,23,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,24,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,25,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,26,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,27,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,28,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,29,"Not Achieved","Platinum","Platinum","Not Achieved"]
[null,30,"Not Achieved","Platinum","Platinum","Certified"]
[null,31,"Not Achieved","Platinum","Platinum","Certified"]
[null,32,"Not Achieved","Platinum","Platinum","Certified"]
[null,33,"Not Achieved","Platinum","Platinum","Certified"]
[null,34,"Not Achieved","Platinum","Platinum","Certified"]
[null,35,"Not Achieved","Platinum","Platinum","Certified"]
[null,36,"Not Achieved","Platinum","Platinum","Certified"]
[null,37,"Not Achieved","Platinum","Platinum","Certified"]
[null,38,"Not Achieved","Platinum","Platinum","Silver"]
[null,39,"Not Achieved","Platinum","Platinum","Silver"]
[null,40,"Certified","Platinum","Platinum","Silver"]
[null,41,"Certified","Platinum","Platinum","Silver"]
[null,42,"Certified","Platinum","Platinum","Silver"]
[null,43,"Certified","Platinum","Platinum","Silver"]
[null,44,"Certified","Platinum","Platinum","Silver"]
[null,45,"Certified","Platinum","Platinum","Gold"]
[null,46,"Certified","Platinum","Platinum","Gold"]
[null,47,"Certified","Platinum","Platinum","Gold"]
[null,48,"Certified","Platinum","Platinum","Gold"]
[null,49,"Certified","Platinum","Platinum","Gold"]
[null,50,"Silver","Platinum","Platinum","Gold"]
[null,51,"Silver","Platinum","Platinum","Gold"]
[null,52,"Silver","Platinum","Platinum","Gold"]
[null,53,"Silver","Platinum","Platinum","Gold"]
[null,54,"Silver","Platinum","Platinum","Gold"]
[null,55,"Silver","Platinum","Platinum","Gold"]
[null,56,"Silver","Platinum","Platinum","Gold"]
[null,57,"Silver","Platinum","Platinum","Gold"]
[null,58,"Silver","Platinum","Platinum","Gold"]
[null,59,"Silver","Platinum","Platinum","Gold"]
[null,60,"Gold","Platinum","Platinum","Platinum"]
[null,61,"Gold","Platinum","Platinum","Platinum"]
[null,62,"Gold","Platinum","Platinum","Platinum"]
[null,63,"Gold","Platinum","Platinum","Platinum"]
[null,64,"Gold","Platinum","Platinum","Platinum"]
[null,65,"Gold","Platinum","Platinum","Platinum"]
[null,66,"Gold","Platinum","Platinum","Platinum"]
[null,67,"Gold","Platinum","Platinum","Platinum"]
[null,68,"Gold","Platinum","Platinum","Platinum"]
[null,69,"Gold","Platinum","Platinum","Platinum"]
[null,70,"Gold","Platinum","Platinum","Platinum"]
[null,71,"Gold","Platinum","Platinum","Platinum"]
[null,72,"Gold","Platinum","Platinum","Platinum"]
[null,73,"Gold","Platinum","Platinum","Platinum"]
[null,74,"Gold","Platinum","Platinum","Platinum"]
[null,75,"Gold","Platinum","Platinum","Platinum"]
[null,76,"Gold","Platinum","Platinum","Platinum"]
[null,77,"Gold","Platinum","Platinum","Platinum"]
[null,78,"Gold","Platinum","Platinum","Platinum"]
[null,79,"Gold","Platinum","Platinum","Platinum"]
[null,80,"Platinum","Platinum","Platinum","Platinum"]
[null,81,"Platinum","Platinum","Platinum","Platinum"]
[null,82,"Platinum","Platinum","Platinum","Platinum"]
[null,83,"Platinum","Platinum","Platinum","Platinum"]
[null,84,"Platinum","Platinum","Platinum","Platinum"]
[null,85,"Platinum","Platinum","Platinum","Platinum"]
[null,86,"Platinum","Platinum","Platinum","Platinum"]
[null,87,"Platinum","Platinum","Platinum","Platinum"]
[null,88,"Platinum","Platinum","Platinum","Platinum"]
[null,89,"Platinum","Platinum","Platinum","Platinum"]
[null,90,"Platinum","Platinum","Platinum","Platinum"]
[null,91,"Platinum","Platinum","Platinum","Platinum"]
[null,92,"Platinum","Platinum","Platinum","Platinum"]
[null,93,"Platinum","Platinum","Platinum","Platinum"]
[null,94,"Platinum","Platinum","Platinum","Platinum"]
[null,95,"Platinum","Platinum","Platinum","Platinum"]
[null,96,"Platinum","Platinum","Platinum","Platinum"]
[null,97,"Platinum","Platinum","Platinum","Platinum"]
[null,98,"Platinum","Platinum","Platinum","Platinum"]
[null,99,"Platinum","Platinum","Platinum","Platinum"]
[null,100,"Platinum","Platinum","Platinum","Platinum"]
[null,101,"Platinum","Platinum","Platinum","Platinum"]
[null,102,"Platinum","Platinum","Platinum","Platinum"]
[null,103,"Platinum","Platinum","Platinum","Platinum"]
[null,104,"Platinum","Platinum","Platinum","Platinum"]
[null,105,"Platinum","Platinum","Platinum","Platinum"]
[null,106,"Platinum","Platinum","Platinum","Platinum"]
[null,107,"Platinum","Platinum","Platinum","Platinum"]
[null,108,"Platinum","Platinum","Platinum","Platinum"]
[null,109,"Platinum","Platinum","Platinum","Platinum"]
[null,110,"Platinum","Platinum","Platinum","Platinum"]
[]
[]
[null,1,"[Select]"]
[null,2,"Certified"]
[null,3,"Silver"]
[null,4,"Gold"]
[null,5,"Platinum"]

{"sheet":"Color Legend","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,8,0]]}
["AF MILCON Sustainable Building Requirements Legend"]
["Green text","LEED® Credits and/or Prerequisites that align closely with Federal High Performance Sustainable Buildings (HPSB) Requirements\nThese credits and/or prerequisites align closely with the associated HPSB Guiding Principle.  They could be either more or less stringent or have different measurement metrics.  In the case where one is more stringent than the other, achieving the more stringent one does not imply the less stringent is achieved."]
["Blue Text","LEED® Credits and/or Prerequisites that meet Federal High Performance Sustainable Buildings (HPSB) Requirements\nThese credits and/or prerequisites have the same requirements as the associated HPSB Guiding Principle. This does not guarantee achieving the LEED Credit, as some documentation methods may vary."]
["Gray Text","Recommended (Federal Requirement not fully defined at this time)"]
["Light Gray Cell","Cell is populated by other cells. User is not required to enter values."]
["Light Green Cell (When used, conditional formatting changes  cell to Green, Yellow, or Red depending on entry)","Cell provides a drop-down box for the user to select which LEED Credits and HPSB Requirements that the project is attempting.  When a \"Yes\", \"Maybe\", or \"No\" is selected the cell follows the stoplight convention to visually represent progress. The stoplight convention is also used for \"Yes\", \"Maybe\" or \"No\" totals.  Some light green boxes also have an option for \"N/A\" when used for subquestions"]
[null,"Cell uses a drop down box and user is designating \"Yes\" or \"N/A\" when applicable"]
[null,"Cell uses a drop down box and user is designating \"Maybe\" "]
[null,"Cell uses a drop down box and user is designating \"No\" "]
["Dark Blue Cell, White Text","LEED® Credits that meet USAF Energy & Water Criteria (may depend on technologies & strategies). The DoD Sustainable Buildings Policy and AF Sustainable Design and Development Memorandum require a minimum of 20 energy and water credits for all projects seeking LEED certification. SS Credits 7.1-7.2, WE Credits 1.1 - 3, EA Credits 1-3 and Credits 5-6, IEQ Credit 1 and Credit 8.1 are always energy and water projects according to AF policy. SS Credit 8 is an energy and water credit if the project uses Option 1 for Indoor Lighting.  Innovation and Design and Regional Priority Credits must be specified as energy and water projects for inclusion."]
["Light Yellow Cell","Cell is for custom entry on how the project is pursuing LEED Credits and HPSB requirements. These are subquestions and also general information questions. Boxes that appear when cell is selected give further instruction on entering data.  Some cells restrict values that can be entered - which is explained if incorrectly entered"]

{"sheet":"Dropdowns","index":5,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Date Test","On or After"]
[{"$f":"IF(ISBLANK(Scoresheet!D18),\"90.1-2010\",IF(Scoresheet!D18<B33,\"90.1-2007\",IF(Scoresheet!D18>2012,\"90.1-2010\",IF(Scoresheet!D18=B33,\"90.1-2010\",\"\"))))","v":"90.1-2010"},2013]
[]
["Key for Saving VBA code",{"$f":"IF(AND(Scoresheet!A20=\"\",B45=\"Incomplete\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
["Completeness Check",{"$f":"COUNTBLANK(B37:B43)","v":0}]
["General Information",{"$f":"Scoresheet!E3","v":"INCOMPLETE"}]
["HPSB 1 - Integrated Design",{"$f":"Scoresheet!D50","v":"INCOMPLETE"}]
["UFC - Site Location",{"$f":"Scoresheet!D54","v":"INCOMPLETE"}]
["HPSB 2 - Energy",{"$f":"Scoresheet!D60","v":"INCOMPLETE"}]
["HPSB 3 - Water",{"$f":"Scoresheet!D99","v":"INCOMPLETE"}]
["HPSB 4 - IAQ",{"$f":"Scoresheet!D106","v":"INCOMPLETE"}]
["HPSB 5 - Materials",{"$f":"Scoresheet!D115","v":"INCOMPLETE"}]
["NA Check",{"$f":"COUNTIF(NA_Justification!E5:E38,\"No\")","v":0}]
[null,{"$f":"IF(OR(B44>0,B36<7),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["NA Defaults"]
["NA Facility does not support this service or feature","Yes"]
["NA Not available in region","Yes"]
["NA Facility function is not compatible","Yes"]

{"sheet":"NA_Justification","index":6,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Federal Requirements for High Performance and Sustainable Buildings (HPSB) & UFC 1-200-02"]
["Instructions: Provide a common or project specific justification for an element to be non-applicable, when completed, the Scoresheet tab will allow an N/A response."]
["Justification for Non-Applicable Answers",null,"Common Justification","Project Specific Justification","Complete?"]
["HPSB I: Employ Integrated Design Principles (UFC 1-200-02, 2-2)"]
["HPSB I.1",{"$f":"HYPERLINK(\"#\"&\"HPSBI.1_Ref\",\"Integrated Design\")","v":"Integrated Design"},null,null,{"$f":"IF(Scoresheet!A51=\"N/A\",IF(COUNTBLANK(C5:D5)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB I.2",{"$f":"HYPERLINK(\"#\"&\"HPSBI.2_Ref\",\"Commissioning\")","v":"Commissioning"},null,null,{"$f":"IF(Scoresheet!A52=\"N/A\",IF(COUNTBLANK(C6:D6)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["UFC 1-200-02, 2-3. Promote Sustainable Location and Site Development"]
["UFC 2-3.1",{"$f":"HYPERLINK(\"#\"&\"UFC_231_Ref\",\"Site selection\")","v":"Site selection"},null,null,{"$f":"IF(Scoresheet!A55=\"N/A\",IF(COUNTBLANK(C8:D8)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["UFC 2-3.2",{"$f":"HYPERLINK(\"#\"&\"UFC_232_Ref\",\"Mitigation of Heat Island Effect\")","v":"Mitigation of Heat Island Effect"},null,null,{"$f":"IF(Scoresheet!A56=\"N/A\",IF(COUNTBLANK(C9:D9)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["UFC 2-3.3",{"$f":"HYPERLINK(\"#\"&\"UFC_233_Ref\",\"Reduction of Light Pollution\")","v":"Reduction of Light Pollution"},null,null,{"$f":"IF(Scoresheet!A57=\"N/A\",IF(COUNTBLANK(C10:D10)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB III.3-4",{"$f":"HYPERLINK(\"#\"&\"HPSBIII.3_Ref\",\"Stormwater Management\")","v":"Stormwater Management"},null,null,{"$f":"IF(Scoresheet!A58=\"N/A\",IF(COUNTBLANK(C11:D11)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB II: Optimize Energy Performance (UFC 1-200-02, 2-4)"]
["HPSB II.1","Energy Efficiency",null,null,{"$f":"IF(Scoresheet!A61=\"N/A\",IF(COUNTBLANK(C13:D13)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB II.2",{"$f":"HYPERLINK(\"#\"&\"HPSBII.3_Ref\",\"On-site Renewable Energy - Solar Hot Water Heater System\")","v":"On-site Renewable Energy - Solar Hot Water Heater System"},null,null,{"$f":"IF(Scoresheet!A71=\"N/A\",IF(COUNTBLANK(C14:D14)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB II.3",{"$f":"HYPERLINK(\"#\"&\"HPSBII.4_Ref\",\"On-site Renewable Energy\")","v":"On-site Renewable Energy"},null,null,{"$f":"IF(Scoresheet!A75=\"N/A\",IF(COUNTBLANK(C15:D15)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB II.4",{"$f":"HYPERLINK(\"#\"&\"HPSBII.5_Ref\",\"Measurement and Verification\")","v":"Measurement and Verification"}]
[null,"Water Metering: Select N/A if no service",null,null,{"$f":"IF(Scoresheet!D91=\"N/A\",IF(COUNTBLANK(C17:D17)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
[null,"Electric Metering: Select N/A if no service",null,null,{"$f":"IF(Scoresheet!D92=\"N/A\",IF(COUNTBLANK(C18:D18)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
[null,"Natural Gas Metering: Select N/A if no service",null,null,{"$f":"IF(Scoresheet!D93=\"N/A\",IF(COUNTBLANK(C19:D19)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
[null,"Steam Metering: Select N/A if no service",null,null,{"$f":"IF(Scoresheet!D94=\"N/A\",IF(COUNTBLANK(C20:D20)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB III: Protect and Conserve Water (UFC 1-200-02, 2-5)   "]
["HPSB III.1",{"$f":"HYPERLINK(\"#\"&\"HPSBIII.1_Ref\",\"Indoor Water\")","v":"Indoor Water"},null,null,{"$f":"IF(Scoresheet!A100=\"N/A\",IF(COUNTBLANK(C22:D22)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB III.2",{"$f":"HYPERLINK(\"#\"&\"HPSBIII.2_Ref\",\"Outdoor Water\")","v":"Outdoor Water"},null,null,{"$f":"IF(Scoresheet!A102=\"N/A\",IF(COUNTBLANK(C23:D23)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB III.4",{"$f":"HYPERLINK(\"#\"&\"HPSBIII.4_Ref\",\"Water used for heating and cooling\")","v":"Water used for heating and cooling"},null,null,{"$f":"IF(Scoresheet!A103=\"N/A\",IF(COUNTBLANK(C24:D24)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV: Enhance Indoor Environmental Quality  (UFC 1-200-02, 2-6)"]
["HPSB IV.1",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.1_Ref\",\"Thermal Comfort\")","v":"Thermal Comfort"},null,null,{"$f":"IF(Scoresheet!A107=\"N/A\",IF(COUNTBLANK(C26:D26)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV.2",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.2_Ref\",\"Ventilation\")","v":"Ventilation"},null,null,{"$f":"IF(Scoresheet!A108=\"N/A\",IF(COUNTBLANK(C27:D27)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV.3",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.3_Ref\",\"Moisture Control\")","v":"Moisture Control"},null,null,{"$f":"IF(Scoresheet!A109=\"N/A\",IF(COUNTBLANK(C28:D28)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV.4",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.4_Ref\",\"Daylighting\")","v":"Daylighting"},null,null,{"$f":"IF(Scoresheet!A110=\"N/A\",IF(COUNTBLANK(C29:D29)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV.5",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.5_Ref\",\"Low Emitting Materials\")","v":"Low Emitting Materials"},null,null,{"$f":"IF(Scoresheet!A111=\"N/A\",IF(COUNTBLANK(C30:D30)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB IV.6",{"$f":"HYPERLINK(\"#\"&\"HPSBIV.6_Ref\",\"Protect Indoor Air Quality during Construction\")","v":"Protect Indoor Air Quality during Construction"},null,null,{"$f":"IF(Scoresheet!A112=\"N/A\",IF(COUNTBLANK(C31:D31)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V: Reduce Environmental Impact of Materials (UFC 1-200-02, 2-7)"]
["HPSB V.1",{"$f":"HYPERLINK(\"#\"&\"HPSBV.1_Ref\",\"Recycled Content\")","v":"Recycled Content"},null,null,{"$f":"IF(Scoresheet!A116=\"N/A\",IF(COUNTBLANK(C33:D33)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V.2",{"$f":"HYPERLINK(\"#\"&\"HPSBV.2_Ref\",\"Biologically based products\")","v":"Biologically based products"},null,null,{"$f":"IF(Scoresheet!A117=\"N/A\",IF(COUNTBLANK(C34:D34)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V.3",{"$f":"HYPERLINK(\"#\"&\"HPSBV.3_Ref\",\"Environmentally Preferable Products\")","v":"Environmentally Preferable Products"},null,null,{"$f":"IF(Scoresheet!A118=\"N/A\",IF(COUNTBLANK(C35:D35)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V.4",{"$f":"HYPERLINK(\"#\"&\"HPSBV.4_Ref\",\"Waste and Materials Management - Recycling\")","v":"Waste and Materials Management - Recycling"},null,null,{"$f":"IF(Scoresheet!A119=\"N/A\",IF(COUNTBLANK(C36:D36)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V.5",{"$f":"HYPERLINK(\"#\"&\"HPSBV.5_Ref\",\"Waste and Materials Management - Divert 50% from Disposal\")","v":"Waste and Materials Management - Divert 50% from Disposal"},null,null,{"$f":"IF(Scoresheet!D122=\"Yes\",IF(COUNTBLANK(C37:D37)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]
["HPSB V.6",{"$f":"HYPERLINK(\"#\"&\"HPSBV.6_Ref\",\"Ozone Depleting Substances\")","v":"Ozone Depleting Substances"},null,null,{"$f":"IF(Scoresheet!A123=\"N/A\",IF(COUNTBLANK(C38:D38)<2,\"Yes\",\"No\"),\"Applicable\")","v":"Applicable"}]