Spreadsheet: 701921d1603987641-formula-for-specific-cell-to-trigger-from-a-drop-down-leed-if-problem
Sheet: Sheet11

 |  | Project Information |  |  |  |  |  |  |  | Project advancement
 |  | Rating System |  | version |  | Certification |  | Points |  | Documented |  | Progress % |  |  | Project Team |  | [NAME] coordinator |  | Required documentation
 |  | [NAME] DB+C: New Construction |  | v4 |  | Certified |  | 40-49 |  | Yes |  | 0 |  |  | Arquitect |  |  |  | narrative
 |  | [NAME] DB+C: Core & Shell |  | v4.1 |  | Silver |  | 50-59 |  | No |  | 10 |  |  | Mechanical Eng |  | Ana S. |  | floor plans
 |  | [NAME] DB+C: Schools |  |  |  | Gold |  | 60-79 |  |  |  | 20 |  |  | Electrical Eng. |  | Ana Maria |  | calculations
 |  | [NAME] DB+C: Retail |  |  |  | Platinum |  | >80 |  |  |  | 30 |  |  | Plumbing Eng. |  | [NAME] |  | photographs
 |  | [NAME] DB+C: Healthcare |  |  |  |  |  |  |  |  |  | 40 |  |  | Civil Eng. |  | JP
 |  | [NAME] DB+C: Data Centers |  |  |  |  |  |  |  |  |  | 50 |  |  | Client |  | Hugo
 |  | [NAME] DB+C: Hospitality |  |  |  |  |  |  |  |  |  | 60 |  |  | [NAME] |  | Loïc
 |  | [NAME] DB+C: Warehouses and Distribution Centers |  |  |  |  |  |  |  |  |  | 70 |  |  | Commissioner
 |  | LEED ID+C:Commercial Interiors |  |  |  |  |  |  |  |  |  | 80 |  |  | Landscaping
 |  | [NAME] ID+C:Retail |  |  |  |  |  |  |  |  |  | 90 |  |  | LCA
 |  | [NAME] ID+C:Hospitality |  |  |  |  |  |  |  |  |  | 100 |  |  | Contractor
 |  | [NAME] O+M: Existing Buildings |  |  |  |  |  |  |  |  |  |  |  |  | LEED Coordinator
 |  | [NAME] O+M: Schools
 |  | [NAME] O+M: Retail
 |  | [NAME] O+M: Data Centers
 |  | [NAME] O+M: Hospitality
 |  | [NAME] O+M: Warehouses and Distribution Centers
 |  | [NAME] ND: Plan
 |  | [NAME] ND: Built Project
Version | Credit name | Requirements | Required documentation
v4 | Integrative process v4 | C34 comment | 1. Integrative Process worksheet
v4 | [NAME] for Neighborhood Development Location | Locate the project within the boundary of a development certified under [NAME] ND.
v4 | Sensitive Land Protection | Locate the development footprint on land that has been previously developed. | 1. Plan de site, limite de projet, zones de végétation, plans détaillés 2. Narratif du site actuel et passé 3. Narratif sur l'abscence des terres agricoles, risques d'innondation, habitats sensibles
v4 | High Priority Site | Locate the project in (1) a historic district, (2) a site with priority designation, (3) or a brownfield site.
v4 | Surrounding Density and Diverse Uses
v4 | Access to Quality Transit | Locate any functional entry of the project within a 400-meter walking distance of existing or planned bus, streetcar, or rideshare stops, or within a 800-meter walking distance of existing or planned bus rapid transit stops, light or heavy rail stations, commuter rail stations, or commuter ferry terminals.
v4 | Bicycle Facilities
v4 | Reduced Parking Footprint | Achieve a 20% reduction of parking spaces from the baseline (~50 parking stalls or less for this 	    building, exact requirements TBD). The team has suggested this credit will not be achievable 	 based on many parking stall being available, and additional parking being provided.
v4 | Green Vehicles | Provide 5% of preferred parking for green vehicles. Provide 2% of all parking with 208-240 v, networked, demand-response ready EV charging stations.
v4 | Construction Activity Pollution Prevention | Erosion and sedimentation control and verification to be implemented.
v4 | Site Assessment | Conduct a site assessment in pre-design of: (1) topography, (2) hydrology, (3) climate, (4) vegetation, (5) soils, (6) human use, and (7) human health effects. Demonstrate how these topics influences project design.
v4 | Site Development - Protect or Restore Habitat | If a floor-area ratio of 1.5 is achieved, vegetated roof can contribute to the restoration of 30% pre-developed area requirement for 2 points. Else, provide financial support (USD $4/m²) to a conservation organization for 1 point.
v4 | Open Space | Provide 30% of site area as open space, and 25% of this space as vegetated (not turf grass).
v4 | Rainwater Management | Manage on site the runoff from the developed site for the 98th percentile of regional or local rainfall events using low-impact development (LID) and green infrastructures.
v4 | Heat Island Reduction | Provide a combination of green roof, high SRI roof, high SRI hardscape, or shading over hardscape.
v4 | Light Pollution Reduction | Reduce nighttime light pollution by reducing exterior uplighting and site boundary light trespass
v4 | Outdoor Water Use Reduction | Provide no irrigation or reduce landscape water use by 30% from baseline as determined by the EPA WaterSense Water Budget Tool.
v4 | Indoor Water Use Reduction | Reduce indoor non-process water use by 20% over baseline, and ensure fixtures are water sense labeled or local equivalent. Clothes washers, dishwashers, prerinse spray values, and ice machines must meet specific standards.
v4 | Building-Level Water Metering | Install a building water meter and share water use data with the USGBC.
v4 | Outdoor Water Use Reduction | Provide no irrigation or reduce landscape water use by 50% from baseline as determined by the EPA WaterSense Water Budget Tool.
v4 | Indoor Water Use Reduction | Reduce indoor non-process water use by at least 40% over baseline. Consider installing low- flow plumbing fixtures. Consider installing the following: WC ≤ 4.2 LPF, UR ≤ 0.5 LPF, LAV ≤ 1.9 LPM, KS ≤ 5.7 LPM, SH ≤ 5.7 LPM. These flow and flush rates typically produce ±35% water use savings, which equates to 3 WEc1 points. All dishwashers and clothes washers must be ENERGY STAR (or equivalent) rated.  Additional water savings may be achieved by further reducing flow and flush volumes e.g. 1.3 LPM lavatories, 3.8 LPF WCs. Innovative wastewater technologies such as waterless urinals should be considered if more points are desired. 40% reduction - 4 points 45% reduction - 5 points 50% reduction - 6 points 55% reduction - 6 points + 1 Exemplary performance point
v4 | [NAME] | For cooling towers and evaporative condensers, conduct a one-time potable water analysis, measuring at least 5 control parameters, which are Ca (as CaCO3), total alkalinity, [NAME], Cl, Conductivity. Calculate the number of cooling tower cyclers by divideing the maximum allowed concentration level of each parameter by the actual concentration level of each parameter found in the potable makeup water. Limit cooling tower cycles to avoid exeeding maximum values for any parameters.
v4 | Water Metering | Install additional water metering for two or more of the following sub systems: (1) irrigation system, (2) indoor plumbing fixtures, (3) domestic hot water, (4) boiler, (5) reclaimed water, or (6) other process water.
v4 | Fundamental Commissioning and Verification
v4 | Minimum Energy Performance
v4 | Building-Level Energy Metering | Install a building energy meter and share energy use data with the USGBC.
v4 | Fundamental Refrigerant Management | Do not use chlorofluorocarbon (CFC)-based refrigerants in new heating, ventilating, air-conditioning, and refrigeration (HVAC&R) systems.
v4 | Enhanced Commissioning
v4 | Optimize Energy Performance
v4 | Advanced Energy Metering | Provide sub-metering for any energy end-use that represents 10% or more of the total annual consumption of the building.
v4 | Demand Response | Since demand response programs are not currently available in Calgary, complete the following: (1) ensure [NAME] has the ability to accept an external price or control signal, (2) develop a plan for shedding at least 10% of the building estimated peak electricity demand, (3) include demand response process in the commissioning scope, (4) contact local utility representatives to discuss participation in future DR programs.
v4 | Renewable Energy Production
v4 | Enhanced Refrigerant Management
v4 | Green Power and Carbon Offsets | Engage in a contract for qualified resources that have come online since January 1, 2005, for a minimum of five years to be delivered at least annually. The contract must specify the provision of at least 50% or 100% of the project's energy from green power, carbon offsets, or renewable energy certificates (RECs).
v4 | Storage and Collection of Recyclables
v4 | Construction and Demolition Waste Management Planning
v4 | Building Life-Cycle Impact Reduction | Provide dedicated areas accessible to waste haulers and building occupants for the collection and storage of recyclable materials for the entire building.
v4 | Building Product Disclosure and Optimization - Environmental Product Declarations | Develop and implement a construction and demolition waste management plan :  Establish waste diversion goals for the project by identifying at least five materials (both structural and nonstructural) targeted for diversion. Specify whether materials will be separated or comingled and describe the diversion strategies planned for the project. Describe where the material will be taken and how the recycling facility will process the material including expected diversion rates for each material stream..
v4 | Building Product Disclosure and Optimization - Sourcing of Raw Materials
v4 | Building Product Disclosure and Optimization - Material Ingredients
v4 | Construction and Demolition Waste Management
v4 | Minimum Indoor Air Quality Performance
v4 | Environmental Tobacco Smoke Control | Locate the project in a building that prohibits smoking by all occupants and users both inside the building and outside the building except in designated smoking areas located at least 25 feet (7.5 meters) from all entries, outdoor air intakes, and operable windows. Signage must be posted within 10 feet (3 meters) of all building entrances indicating the no-smoking policy.
v4 | Enhanced Indoor Air Quality Strategies
v4 | Low-Emitting Materials
v4 | Construction Indoor Air Quality Management Plan | Develop and implement an indoor air quality (IAQ) management plan for the construction and  preoccupancy phases of the building.  The plan must address all of the creteria.
v4 | Indoor Air Quality Assessment
v4 | Thermal comfort
v4 | Interior lighting
v4 | Daylight
v4 | Quality Views | Achieve a direct line of sight to the outdoors via vision glazing for 75% of all regularly occupied floor area. View glazing in the contributing area must provide a clear image of the exterior, not obstructed by frits, fibers, patterned glazing, or added tints that distort color balance. Additionally, 75% of all regularly occupied floor area must have at least two of the indicated 4 kinds of views
v4 | Acoustic performance
v4 | LEED Accredited Professional
 | [NAME] v4.1  credit requirements
 | Credit name | Requirements | Required documentation
 | Integrative process | C100 comment | 1. Integrative Process worksheet v2
 | [NAME] for Neighborhood Development Location
 | Sensitive Land Protection
 | High Priority Site
 | Surrounding Density and Diverse Uses
 | Access to Quality Transit
 | Bicycle Facilities
 | Reduced Parking Footprint
 | Green Vehicles
 | Construction Activity Pollution Prevention
 | Site Assessment
 | Site Development - Protect or Restore Habitat
 | Open Space
 | Rainwater Management
 | Heat Island Reduction
 | Light Pollution Reduction
 | Outdoor Water Use Reduction
 | Indoor Water Use Reduction
 | Building-Level Water Metering
 | Outdoor Water Use Reduction
 | Indoor Water Use Reduction
 | [NAME]
 | Water Metering
 | Fundamental Commissioning and Verification
 | Minimum Energy Performance
 | Building-Level Energy Metering
 | Fundamental Refrigerant Management
 | Enhanced Commissioning
 | Optimize Energy Performance
 | Advanced Energy Metering
 | Demand Response
 | Renewable Energy Production
 | Enhanced Refrigerant Management
 | Green Power and Carbon Offsets
 | Storage and Collection of Recyclables
 | Construction and Demolition Waste Management Planning
 | Building Life-Cycle Impact Reduction
 | Building Product Disclosure and Optimization - Environmental Product Declarations
 | Building Product Disclosure and Optimization - Sourcing of Raw Materials
 | Building Product Disclosure and Optimization - Material Ingredients
 | Construction and Demolition Waste Management
 | Minimum Indoor Air Quality Performance
 | Environmental Tobacco Smoke Control
 | Enhanced Indoor Air Quality Strategies
 | Low-Emitting Materials
 | Construction Indoor Air Quality Management Plan
 | Indoor Air Quality Assessment
 | Thermal comfort
 | Interior lighting
 | Daylight
 | Quality Views
 | Acoustic performance
 | LEED Accredited Professional