{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me First >>","LEED v4 Scorecard >>"," SITES v2 Scorecard >>","SITES Readiness Assessment","Hidden sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Read Me First >>","index":0,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,40,6],[32,2,32,6],[35,2,35,6],[36,2,36,6],[39,1,39,6],[33,2,33,6],[34,2,34,6],[31,2,31,6],[29,2,29,6],[38,1,38,6],[10,1,12,6],[15,1,16,6],[24,1,24,6],[23,1,23,6],[26,1,27,6],[13,1,13,6],[21,1,21,6],[17,1,17,6],[19,1,19,6],[28,2,28,6],[30,2,30,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LEED to SITES Readiness Tool"]
[]
[]
[null,"for LEED BD+C v4 projects"]
[]
[null,"Purpose"]
[]
[null,"The SITES and LEED rating systems are complementary, and can be used independently or in tandem. If you would like your project to benefit from certifying to both SITES and LEED, you can take advantage of the synergies between them. The Synergies between SITES and LEED document (October 2016) outlines the synergies between the two programs. "]
[]
[null,"This LEED to SITES Readiness Tool is an update to the 2016 synergies document and was created to provide a scorecard view of the available synergies between the two programs. This tool will assist LEED project teams to quickly assess their readiness (and gaps) toward achieving SITES certification, based on the LEED credits achieved/attempted. Note this tool only provides insight into which LEED credits may earn SITES credits, not vice versa. Additionally, in order to benefit from the synergies, the SITES boundary should be similar with the LEED project boundary or LEED campus boundary. LEED projects may achieve up to 65 points toward SITES certification!"]
[]
[null,"In addition to the previously identified synergies from the 2016 document, the tool now also features new credit synergies."]
[]
[null,"The 2016 SITES and LEED synergies is available at the link below. Please refer to that document for further detail as necessary."]
[null,"Synergies Between SITES and LEED"]
[]
[null,"How to Use this Tool"]
[]
[null,1,"Complete the 'LEED v4 Scorecard' sheet with the LEED prerequisites and credits your project has achieved or is planning to attempt. Note only the applicable LEED credits/options are included in the scorecard."]
[null,2,"Next, proceed to the 'SITES v2 Scorecard' sheet which will get auto-populated with information based on your entries in the LEED scorecard sheet."]
[null,3,"Review the SITES v2 scorecard in detail to see which prerequisites/credits and options may be achieved based on selected LEED credits. Note, the \">> Expand by clicking on + sign above to see more details\" button at the top."]
[null,4,"Next, check the 'SITES Readiness Assessment' tab to see a summary view of potential points possible and additional points needed for achieving SITES certification. "]
[null,5,"Review the rest of the SITES scorecard to identify additional credits that might be feasible to achieve. You may be very close to achieving SITES certified status by virtue of your attempted/achieved LEED credits!"]
[null,6,"Review the SITES Rating System to determine requirements for the additional credits/prerequisites. Be sure to also review the “Important Considerations” section in the 2016 Synergies document."]
[null,7,"Register for SITES certification and submit documentation for SITES certification review."]
[null,8,"Remember you will need to document the applicable LEED credits only once in the LEED submittal, so only documentation for new credits will be essential. Feel free to submit this sheet as well as part of your SITES submittal."]
[null,9,"After documentation submission and review, celebrate your SITES certification along with your LEED achievement!"]
[]
[null,"This is only a readiness assessment tool and completion of this does not guarantee achievement of points or SITES certification."]
[null,"Visit sustainablesites.org for more resources on SITES and contact us by emailing sites@gbci.org if you have any questions!"]
[null,"© GBCI June 2021"]

{"sheet":"LEED v4 Scorecard >>","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,1,4,3],[10,2,10,3],[20,2,20,3],[21,2,21,3],[11,2,11,3],[12,2,12,3],[9,2,9,3],[5,2,5,3],[6,2,6,3],[27,2,27,3],[13,1,13,3],[14,2,14,3],[36,2,36,3],[37,2,37,3],[25,2,25,3],[31,2,31,3],[23,1,23,3],[33,1,33,3],[24,2,24,3],[29,2,29,3],[39,1,39,3],[7,2,7,3],[8,2,8,3],[15,2,15,3],[35,1,35,3],[17,2,17,3],[18,2,18,3],[26,2,26,3],[30,2,30,3],[28,2,28,3],[34,2,34,3],[22,2,22,3],[19,1,19,3],[32,2,32,3],[38,1,38,3],[16,2,16,3]]}
[]
["\n\n","LEED v4 BD+C Scorecard"]
[]
[null,"LEED Credits and Prerequisites","Attempted/Achieved?",null,null,"LEED Points",null,null,null,"LEED Points"]
[null,"Location and Transportation"]
[null,"LTc Sensitive Land Protection - Option 1","Select",null,null,0,null,null,null,1]
[null,"LTc Sensitive Land Protection - Option 2","Select"]
[null,"LTc High Priority Site - Option 3","Select",null,null,0,null,null,null,1]
[null,"LTc Surrounding Density and Diverse Uses - Option 2, Diverse Uses (4-7)","Select",null,null,0,null,null,null,1]
[null,"LTc Access to Quality Transit","Select"]
[null,"LTc Bicycle Facilities","Select",null,null,0,null,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"LTc Reduced Parking Footprint","Select",null,null,0,null,null,null,1]
[null,"LTc Green Vehicles - Option 1","Select",null,null,0,null,null,null,1]
[null,"Sustainable Sites"]
[null,"SSp Construction Activity Pollution Prevention","Select",null,null,0,null,null,null,0]
[null,"SSc Site Assessment","Select",null,null,0,null,null,null," 2-3"]
[null,"SSc Rainwater Management - Option 1, Paths 1 or 2","Select",null,null,0,null,null,null,1]
[null,"SSc Heat Island Reduction","Select",null,null,0,null,null,null,2]
[null,"SSc Light Pollution Reduction","Select",null,null,0,null,null,null,5]
[null,"Water Efficiency"]
[null,"WEc Outdoor Water Use Reduction - Option 1, No Irrigation Required","Select",null,null,0]
[null,"WEc Outdoor Water Use Reduction - Option 2, Reduce Irrigation (50%)","Select",null,null,0]
[null,"WEc Outdoor Water Use Reduction - Option 2, Reduce Irrigation (100%)","Select",null,null,0]
[null,"Materials and Resources"]
[null,"MRc Construction and Demolition Waste Management - Option 1, Path 1","Select",null,null,0,null,null,null,1]
[null,"MRc Construction and Demolition Waste Management - Option 1, Path 2","Select",null,null,0,null,null,null,1]
[null,"MRc Building Life-Cycle Impact Reduction - Option 1","Select",null,null,0,null,null,null,1]
[null,"MRc Building Product Disclosure and Optimization - Environmental Product Declarations - Option 1","Select",null,null,0]
[null,"MRc Building Product Disclosure and Optimization - Environmental Product Declarations - Option 2","Select",null,null,0]
[null,"MRc Building Product Disclosure and Optimization - Sourcing of Raw Materials - Option 1","Select",null,null,0,null,null,null," 1-2"]
[null,"MRc Building Product Disclosure and Optimization - Sourcing of Raw Materials - Option 2","Select",null,null,0,null,null,null," 1-2"]
[null,"MRc Building Product Disclosure and Optimization - Material Ingredients - Option 1","Select",null,null,0,null,null,null," 1-2"]
[null,"MRc Building Product Disclosure and Optimization - Material Ingredients - Option 2","Select",null,null,0,null,null,null," 1-2"]
[null,"Indoor Environmental Quality"]
[null,"EQp Environmental Tobacco Smoke Control - Options 1 or 2","Select",null,null,0,null,null,null,0]
[null,"Innovation"]
[null,"IN Community Outreach and Involvement","Select",null,null,0]
[null,"IN Local Food Production","Select",null,null,0]
[]
[null,">>> proceed to next tab to view SITES scorecard"]

{"sheet":" SITES v2 Scorecard >>","index":2,"n_rows":92,"n_cols":17,"rows_kept":92,"cut":false,"hidden":false,"merged":[[3,2,4,7],[3,9,4,13],[1,1,1,2],[70,10,70,15],[33,10,33,15],[47,10,47,15],[68,8,68,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[65,10,65,15],[63,10,63,15],[64,10,64,15],[58,8,58,9],[66,10,66,15],[69,8,69,9],[49,10,49,15],[50,10,50,15],[43,10,43,15],[44,10,44,15],[45,10,45,15],[61,10,61,15],[72,10,72,15],[73,10,73,15],[74,10,74,15],[75,10,75,15],[76,10,76,15],[71,8,71,9],[72,8,72,9],[71,10,71,15],[83,8,83,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[77,10,77,15],[90,10,90,15],[85,10,85,15],[86,10,86,15],[87,10,87,15],[70,8,70,9],[68,10,68,15],[69,10,69,15],[13,8,13,9],[59,8,59,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[59,10,59,15],[67,10,67,15],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[57,8,57,9],[53,10,53,15],[60,10,60,15],[88,10,88,15],[89,10,89,15],[79,10,79,15],[86,8,86,9],[87,8,87,9],[84,10,84,15],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[78,10,78,15],[84,8,84,9],[85,8,85,9],[80,10,80,15],[81,10,81,15],[82,10,82,15],[83,10,83,15],[62,10,62,15],[54,10,54,15],[55,10,55,15],[56,10,56,15],[57,10,57,15],[58,10,58,15],[52,10,52,15],[51,10,51,15],[41,10,41,15],[42,10,42,15],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[46,10,46,15],[48,10,48,15],[48,8,48,9],[40,10,40,15],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[34,10,34,15],[35,10,35,15],[36,10,36,15],[37,10,37,15],[38,10,38,15],[39,10,39,15],[30,8,30,9],[90,1,90,2],[88,1,88,2],[21,1,21,2],[13,1,13,2],[56,1,56,2],[45,1,45,2],[76,1,76,2],[33,1,33,2],[84,1,84,2],[26,1,26,2],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[73,8,73,9],[23,8,23,9],[21,10,21,15],[22,10,22,15],[23,10,23,15],[18,10,18,15],[19,10,19,15],[20,10,20,15],[32,8,32,9],[28,10,28,15],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[25,10,25,15],[26,10,26,15],[27,10,27,15],[29,10,29,15],[30,10,30,15],[31,10,31,15],[32,10,32,15],[24,10,24,15],[31,8,31,9],[12,1,12,2],[28,8,28,9],[29,8,29,9],[12,10,12,15],[13,10,13,15],[14,10,14,15],[15,10,15,15],[16,10,16,15],[17,10,17,15],[21,8,21,9],[22,8,22,9],[12,8,12,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">> Expand by clicking on + sign above to see more details"]
[null,"SITES v2 Scorecard"]
[]
[null,null,"SITES v2 Scorecard Summary",null,null,null,null,null,null,"SITES v2 Certification (max. 200 points)"]
[]
[null,null,"Potential points based on LEED v4 Scorecard Selections",null,"Results",null,null,null,null,"Levels",null,null,null,"Points"]
[null,null,"Total potential Prerequisites ",null,{"$f":"COUNTIF(H15:H71,CHAR(252))","v":0},null,null,null,null,"Certified",null,null,null,70]
[null,null,"Total potential Credits ",null,{"$f":"#REF!-E7","v":{"$error":"#REF!"}},null,null,null,null,"Silver",null,null,null,85]
[null,null,"Total Potential Maximum Points from LEED",null,{"$f":"SUM(H14,H22,H27,H34,H46,H57,H69)","v":0},null,null,null,null,"Gold",null,null,null,100]
[null,null,"Additional Points needed to achieve SITES \"Certified\" status",null,{"$f":"N7-E9","v":70},null,null,null,null,"Platinum",null,null,null,135]
[null,null,"Additional Prerequisites needed to achieve SITES Certification",null,{"$f":"18-E7","v":18}]
[]
[null,"SITES v2 Prerequisites and Credits",null,"Points Available","Max Pts.","Yes","Anticipated based on LEED?","Potential Points Anticipated","Applicable SITES Cases/Options",null,"Related LEED Credit (from LEED v4 Scorecard tab)"]
[null," 1: SITE CONTEXT",null,13,null,null,null,{"$f":"SUM(H19,H20,H21)","v":0}]
[null," CONTEXT P1.1","Limit development on farmland"," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",F15,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",CHAR(252),\"\")","v":""},"ONLY Case 1: Sites without farmland soils",null,"LTc Sensitive Land Protection - Option 2"]
[null," CONTEXT P1.2","Protect floodplain functions "," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",F16,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",CHAR(252),\"\")","v":""},"ONLY Case 1: Sites without floodplain",null,"LTc Sensitive Land Protection - Option 2"]
[null," CONTEXT P1.3","Conserve aquatic ecosystems"," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",F17,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",CHAR(252),\"\")","v":""},"ONLY Case 1: Sites without aquatic ecosystems",null,"LTc Sensitive Land Protection - Option 2"]
[null," CONTEXT P1.4","Conserve habitats for threatened and endangered species"," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",F18,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C7=\"Yes\",CHAR(252),\"\")","v":""},"ONLY Case 1: Brownfields and previously developed sites",null,"LTc Sensitive Land Protection - Option 2"]
[null," CONTEXT C1.5","Redevelop degraded sites","3 to 6",6,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C6=\"Yes\",'LEED v4 Scorecard >>'!C8=\"Yes\"),F19,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C8=\"Yes\",6,IF('LEED v4 Scorecard >>'!C6=\"Yes\",3,\"\"))","v":""},"ONLY Case 1: Previously developed sites (max. 3 points)\nOR\nONLY Case: 2 Brownfield sites (max. 6 points)",null,"LTc Sensitive Land Protection - Option 1\nOR \nLTc High Priority Site - Option 3"]
[null," CONTEXT C1.6","Locate projects within existing developed areas",4,4,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C9=\"Yes\",F20,\"\")","v":""},{"$f":"IF(G20=\"Yes\",E20,\"\")","v":""},null,null,"LTc Surrounding Density and Diverse Uses - Option 2, Diverse Uses (4-7)"]
[null," CONTEXT C1.7","Connect to multi-modal transit networks","2 to 3",3,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C10=\"Yes\",F21,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C10=\"Yes\",E21,\"\")","v":""},"ONLY Option 2",null,"LTc Access to Quality Transit"]
[null," 2: PRE-DESIGN ASSESSMENT + PLANNING",null,{"$f":"D26","v":3},null,null,null,{"$f":"SUM(H26)","v":0}]
[null," PRE-DESIGN P2.1","Use an integrative design process"," -"]
[null," PRE-DESIGN P2.2","Conduct a pre-design site assessment "," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C16=\"Yes\",F24,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C16=\"Yes\",CHAR(252),\"\")","v":""},null,null,"SSc Site Assessment"]
[null," PRE-DESIGN P2.3","Designate and communicate VSPZs"," -"]
[null," PRE-DESIGN C2.4","Engage users and stakeholders",3,3,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C37=\"Yes\",F26,\"\")","v":""},{"$f":"IF(G26=\"Yes\",E26,\"\")","v":""},null,null,"IN Community Outreach and Involvement"]
[null," 3: SITE DESIGN - WATER",null,23,null,null,null,{"$f":"SUM(H30,H31)","v":0}]
[null," WATER P3.1","Manage precipitation on site "," -",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C17=\"Yes\",F28,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C17=\"Yes\",CHAR(252),\"\")","v":""},null,null,"SSc Rainwater Management - Option 1, Path 1\nOR\nSSc Rainwater Management - Option 1, Path 2"]
[null," WATER P3.2","Reduce water use for landscape irrigation "," -",null,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C21=\"Yes\",'LEED v4 Scorecard >>'!C22=\"Yes\", 'LEED v4 Scorecard >>'!C23=\"Yes\"),F29,\"\")","v":""},{"$f":"IF(OR('LEED v4 Scorecard >>'!C21=\"Yes\",'LEED v4 Scorecard >>'!C22=\"Yes\",'LEED v4 Scorecard >>'!C23=\"Yes\"),CHAR(252),\"\")","v":""},"ONLY Option 1: Reduce Outdoor Water Use\n\nNote, while athletic fields can be exempt in SITES P3.2, they are not in the related credit, C3.4. In addition, C3.4 includes water used for created water features.",null,"WEc Outdoor Water Use Reduction - Option 1, No Irrigation Required\nOR\nWEc Outdoor Water Use Reduction - Option 2, Reduce Irrigation (50%)\nOR\nWEc Outdoor Water Use Reduction - Option 2, Reduce Irrigation (100%)"]
[null," WATER C3.3","Manage precipitation beyond baseline","4 to 6",6,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C17=\"Yes\",F30,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C17=\"Yes\",E30,\"\")","v":""},"95th percentile precipitation event",null,"SSc Rainwater Management - Option 1, Path 1\nOR\nSSc Rainwater Management - Option 1, Path 2"]
[null," WATER C3.4","Reduce outdoor water use","4 to 6",6,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C21=\"Yes\",'LEED v4 Scorecard >>'!C23=\"Yes\"),F31,\"\")","v":""},{"$f":"IF(OR('LEED v4 Scorecard >>'!C21=\"Yes\",'LEED v4 Scorecard >>'!C23=\"Yes\"),E31,\"\")","v":""},"ONLY Options 1, 2, or 3",null,"WEc Outdoor Water Use Reduction - Option 1, No Irrigation Required\nOR\nWEc Outdoor Water Use Reduction - Option 2, Reduce Irrigation (100%)"]
[null," WATER C3.5","Design functional stormwater features as amenities","4 to 5",5]
[null," WATER C3.6","Restore aquatic ecosystems","4 to 6",6]
[null," 4: SITE DESIGN - SOIL + VEGETATION",null,40,null,null,null,{"$f":"SUM(H43)","v":0}]
[null," SOIL+VEG P4.1","Create and communicate a soil management plan"," -"]
[null," SOIL+VEG P4.2","Control and manage invasive plants"," -"]
[null," SOIL+VEG P4.3","Use appropriate plants"," -"]
[null," SOIL+VEG C4.4","Conserve healthy soils and appropriate vegetation","4 to 6",6]
[null," SOIL+VEG C4.5","Conserve special status vegetation",4,4]
[null," SOIL+VEG C4.6","Conserve and use native plants","3 to 6",6]
[null," SOIL+VEG C4.7","Conserve and restore native plant communities ","4 to 6",6]
[null," SOIL+VEG C4.8","Optimize biomass","1 to 6",6]
[null," SOIL+VEG C4.9","Reduce urban heat island effects",4,4,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C18=\"Yes\",F43,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C18=\"Yes\",E43,\"\")","v":""},null,null,"SSc Heat Island Reduction"]
[null," SOIL+VEG C4.10","Use vegetation to minimize building energy use","1 to 4",4]
[null," SOIL+VEG C4.11","Reduce the risk of catastrophic wildfire",4,4]
[null," 5: SITE DESIGN - MATERIALS SELECTION",null,41,null,null,null,{"$f":"SUM(H53,H54,H55)","v":0}]
[null," MATERIALS P5.1","Eliminate the use of wood from threatened tree species","-"]
[null," MATERIALS C5.2","Maintain on-site structures and paving","2 to 4",4]
[null," MATERIALS C5.3","Design for adaptability and disassembly","3 to 4",4]
[null," MATERIALS C5.4","Use salvaged materials and plants","3 to 4",4]
[null," MATERIALS C5.5","Use recycled content materials","3 to 4",4]
[null," MATERIALS C5.6","Use regional materials","3 to 5",5]
[null," MATERIALS C5.7","Support responsible extraction of raw materials","1 to 5",5,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C30=\"Yes\",'LEED v4 Scorecard >>'!C31=\"Yes\"),F53,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C30=\"Yes\",3,IF('LEED v4 Scorecard >>'!C31=\"Yes\",5,\"\"))","v":""},"ONLY Option 2 (max. 3 points)\n\nOR\n\nONLY Option 3 (max. 5 points)",null,"MR Building Product Disclosure and Optimization - Sourcing of Raw Materials - Option 1\nOR\nMR Building Product Disclosure and Optimization - Sourcing of Raw Materials - Option 2"]
[null," MATERIALS C5.8","Support transparency and safer chemistry","1 to 5",5,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C32=\"Yes\",'LEED v4 Scorecard >>'!C33=\"Yes\"),F54,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C33=\"Yes\",5,IF('LEED v4 Scorecard >>'!C32=\"Yes\",3,\"\"))","v":""},"ONLY Option 2 (max. 3 points)\n\nOR\n\nONLY Option 3 (max. 5 points)",null,"MR Building Product Disclosure and Optimization - Material Ingredients - Option 1\nOR\nMR Building Product Disclosure and Optimization - Material Ingredients - Option 2"]
[null," MATERIALS C5.9","Support sustainability in materials manufacturing","1 to 5",5,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C28=\"Yes\",'LEED v4 Scorecard >>'!C29=\"Yes\"),F55,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C28=\"Yes\",3,IF('LEED v4 Scorecard >>'!C29=\"Yes\",5,\"\"))","v":""},"ONLY Option 2 (max. 3 points) \n\nOR\n\nONLY Option 3 (max. 5 points)",null,"MR Building Product Disclosure and Optimization - Environmental Product Declarations - Option 1 \nOR\nMR Building Product Disclosure and Optimization - Environmental Product Declarations - Option 2"]
[null," MATERIALS C5.10","Support sustainability in plant production","1 to 5",5]
[null," 6: SITE DESIGN - HUMAN HEALTH + WELL-BEING",null,30,null,null,null,{"$f":"SUM(H58,H64,H65,H66,H67)","v":0}]
[null," HHWB C6.1","Protect and maintain cultural and historic places","2 to 3",2,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C27=\"Yes\",F58,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C27=\"Yes\",E58,\"\")","v":""},"ONLY Option 1: Historic buildings, structures, or objects (max. 2 points)",null,"MRc Building Life-cycle Impact Reduction - Option 1"]
[null," HHWB C6.2","Provide optimum site accessibility, safety, and wayfinding ",2,2]
[null," HHWB C6.3","Promote equitable site use",2,2]
[null," HHWB C6.4","Support mental restoration",2,2]
[null," HHWB C6.5","Support physical activity",2,2]
[null," HHWB C6.6","Support social connection",2,2]
[null," HHWB C6.7","Provide on-site food production","3 to 4",3,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C38=\"Yes\",F64,\"\")","v":""},{"$f":"IF(G64=\"Yes\",3,\"\")","v":""},"ONLY Option 1: Food production only (max. 3 pts.)",null,"IN Local Food Production"]
[null," HHWB C6.8","Reduce light pollution",4,4,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C19=\"Yes\",F65,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C19=\"Yes\",E65,\"\")","v":""},null,null,"SSc Light Pollution Reduction"]
[null," HHWB C6.9","Encourage fuel efficient and multi-modal transportation",4,4,"Yes",{"$f":"IF(E66=H66,F66,\"\")","v":""},{"$f":"IF(AND('LEED v4 Scorecard >>'!C11=\"Yes\",'LEED v4 Scorecard >>'!C12=\"Yes\"),E66,IF(AND('LEED v4 Scorecard >>'!C11=\"Yes\",'LEED v4 Scorecard >>'!C13=\"Yes\"),E66,IF(AND('LEED v4 Scorecard >>'!C12=\"Yes\",'LEED v4 Scorecard >>'!C13=\"Yes\"),E66,\"\")))","v":""},"Achievement of C6.9 requires completion of any combination of at least 2 out of the 3 LEED credits listed under Related LEED Credit. Earning only 1 of these credits will not result in achievement of C6.9. ",null,"LTc Bicycle Facilities\nOR\nLTc Reduced Parking Footprint\nOR \nLTc Green Vehicles"]
[null," HHWB C6.10","Minimize exposure to environmental tobacco smoke ","1 to 2",1,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C35=\"Yes\",F67,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C35=\"Yes\",E67,\"\")","v":""},"ONLY Option 2: Prohibit smoking on site (max. 1 point)\nOR\nONLY Option 1: Designate smoke-free zones (max. 1 point)",null,"EQp Environmental Tobacco Smoke Control - Option 1\nOR\nEQp Environmental Tobacco Smoke Control - Option 2"]
[null," HHWB C6.11","Support local economy",3,3]
[null," 7: CONSTRUCTION",null,17,null,null,null,{"$f":"SUM(H74)","v":0}]
[null," CONSTRUCTION P7.1","Communicate and verify sustainable construction practices","-"]
[null," CONSTRUCTION P7.2","Control and retain construction pollutants","-",null,"Yes",{"$f":"IF('LEED v4 Scorecard >>'!C15=\"Yes\",F71,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C15=\"Yes\",CHAR(252),\"\")","v":""},null,null,"SSp Construction Activity Pollution Prevention"]
[null," CONSTRUCTION P7.3","Restore soils disturbed during construction","-"]
[null," CONSTRUCTION C7.4","Restore soils disturbed by previous development","3 to 5",5]
[null," CONSTRUCTION C7.5","Divert construction and demolition materials from disposal","3 to 4",4,"Yes",{"$f":"IF(OR('LEED v4 Scorecard >>'!C25=\"Yes\",'LEED v4 Scorecard >>'!C26=\"Yes\"),F74,\"\")","v":""},{"$f":"IF('LEED v4 Scorecard >>'!C26=\"Yes\",4,IF('LEED v4 Scorecard >>'!C25=\"Yes\",3,\"\"))","v":""},"Path 1: 50% of structural materials + 95% of roads / infrastructure materials (max. 3 points)\n\nPath 2: 75% of structural materials + 95% of roads / infrastructure materials (max. 4 points)",null,"MRc Construction and Demolition Waste Management - Option 1, Path 1\nOR\nMRc Construction and Demolition Waste Management - Option 1, Path 2"]
[null," CONSTRUCTION C7.6","Divert reusable vegetation, rocks, and soil from disposal","3 to 4",4]
[null," CONSTRUCTION C7.7","Protect air quality during construction","2 to 4",4]
[null," 8. OPERATIONS + MAINTENANCE",null,22,null,null,null,0]
[null," O+M P8.1","Plan for sustainable site maintenance","-"]
[null," O+M P8.2","Provide for storage and collection of recyclables","-"]
[null," O+M C8.3","Recycle organic matter","3 to 5",5]
[null," O+M C8.4","Minimize pesticide and fertilizer use","4 to 5",5]
[null," O+M C8.5","Reduce outdoor energy consumption","2 to 4",4]
[null," O+M C8.6","Use renewable sources for landscape electricity needs","3 to 4",4]
[null," O+M C8.7","Protect air quality during landscape maintenance","2 to 4",4]
[null," 9. EDUCATION + PERFORMANCE MONITORING",null,11,null,null,null,0]
[null," EDUCATION C9.1","Promote sustainability awareness and education","3 to 4",4]
[null," EDUCATION C9.2","Develop and communicate a case study",3,3]
[null," EDUCATION C9.3","Plan to monitor and report site performance",4,4]
[null," 10. INNOVATION OR EXEMPLARY PERFORMANCE",null,9,null,null,null,0]
[null," INNOVATION C10.1","Innovation or exemplary performance","3 to 9",9]
[null," TOTAL  POINTS",null,200,null,null,null,{"$f":"SUM(H14,H22,H27,H57,H69,H34,H77,H46,H85,H89)","v":0}]
[null,null,null,">> Proceed to next tab to view SITES readiness assessment"]

{"sheet":"SITES Readiness Assessment","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,1,21,4],[22,1,22,4],[4,1,4,4],[6,1,7,4]]}
[]
[]
[]
[]
[null,"SITES v2 Readiness Summary"]
[]
[null,"SITES v2 Credit/Prerequisites Based on LEED "]
[]
[null,"Prerequisites/Credits","Required","Anticipated"," Additional Needed"]
[null,"Total Prerequisites ",18,{"$f":"COUNTIF(' SITES v2 Scorecard >>'!H15:H90,CHAR(252))","v":0},{"$f":"C10-D10","v":18}]
[null,"Total Credits","NA",{"$f":"F11-D10","v":0},"NA",{"$f":"(COUNTIF(' SITES v2 Scorecard >>'!G15:G90,\"Yes\"))","v":0}]
[]
[null,"Points for Certification Levels","Required","Anticipated"," Additional Needed"]
[null,"Certified",70,{"$f":"SUM(' SITES v2 Scorecard >>'!H14,' SITES v2 Scorecard >>'!H22,' SITES v2 Scorecard >>'!H27,' SITES v2 Scorecard >>'!H34,' SITES v2 Scorecard >>'!H46,' SITES v2 Scorecard >>'!H57,' SITES v2 Scorecard >>'!H69)","v":0},{"$f":"C14-D14","v":70}]
[null,"Silver",85,{"$f":"SUM(' SITES v2 Scorecard >>'!H14,' SITES v2 Scorecard >>'!H22,' SITES v2 Scorecard >>'!H27,' SITES v2 Scorecard >>'!H34,' SITES v2 Scorecard >>'!H46,' SITES v2 Scorecard >>'!H57,' SITES v2 Scorecard >>'!H69)","v":0},85]
[null,"Gold",100,{"$f":"SUM(' SITES v2 Scorecard >>'!H14,' SITES v2 Scorecard >>'!H22,' SITES v2 Scorecard >>'!H27,' SITES v2 Scorecard >>'!H34,' SITES v2 Scorecard >>'!H46,' SITES v2 Scorecard >>'!H57,' SITES v2 Scorecard >>'!H69)","v":0},100]
[null,"Platinum",135,{"$f":"SUM(' SITES v2 Scorecard >>'!H14,' SITES v2 Scorecard >>'!H22,' SITES v2 Scorecard >>'!H27,' SITES v2 Scorecard >>'!H34,' SITES v2 Scorecard >>'!H46,' SITES v2 Scorecard >>'!H57,' SITES v2 Scorecard >>'!H69)","v":0},135]
[]
[null,"Additional points needed to achieve SITES 'Certified' level",null,null,{"$f":"C14-D14","v":70}]
[null,"Additional prerequisites needed to achieve SITES certification",null,null,{"$f":"18-D10","v":18}]
[]
[]
[null,"Visit sustainablesites.org for more resources on SITES and contact us by emailing sites@gbci.org if you have any questions!"]

{"sheet":"Hidden sheet","index":4,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Credit/Prereq name","Maximum  points","Achieved points","Selected options",null,"Credit/Prereq name"]
[null,null,null,null,null,null,"Prerequisite 1.1: Limit development on farmland ",null,null,null,null,"P1.1 Limit development on farmland "]
[null,null,null,null,null,null,"Prerequisite 1.1:  Case 1: Sites without farmland soils",null,null,null,null,"P1. 2 Limit development on farmland Protect floodplain functions"]
[null,null,null,null,null,null,"Prerequisite 1.1: Case 2:  Sites with famland soils - VSPZs",null,null,null,null,"P1.3 Conserve aquatic ecosystems"]
[null,null,null,null,null,null,"Prerequisite 1.1: Case 3: Sites with farmland soils - Mitigation",null,null,null,null,"P 1.4 Conserve habitats for threatened and endangered species"]
[null,"Select","Select",null,"Select",null,"Protect floodplain functions",null,null,null,null,"Credit  1.5 Redevelop degraded sites",6]
[null,"No","Yes",null,"Yes",null,"Prerequisite 1.2: Case 1: Sites without floodplain",null,null,null,null,"Credit  1.6 Locate Projects Within Existing Developed Areas",4]
[null,null,"No",null,"No",null,"Prerequisite 1.2: Case 2: Previously developed and brownfield sites within floodplain",null,null,null,null,"Credit 1.7 Connect to multimodal transportation networks ",3]
[null,null,null,null,"Yes, with edits",null,"Prerequisite 1.2: Case 3: Greenfield sites within floodplain",null,null,null,null,"P2.1 Use an integrative design process"]
[null,null,"Select",null,null,null,"Conserve aquatic ecosystems",null,null,null,null,"P2.2 Conduct a pre-design site assessment "]
[null,null,"LEED v2009",null,null,null,"Prerequisite 1.3: Case 1: Sites without aquatic ecosystems",null,null,null,null,"C2.4 Engage users and stakeholders",3]
[null,null,"LEED v4",null,null,null,"Prerequisite 1.3: Case 2: Sites with naturally occurring aquatic ecosystems",null,null,null,null,"P3.1 Manage precipitation on site "]
[null,null,"LEED v4.1",null,null,null,"Prerequisite 1.3: Case 3: Sites with naturally occurring poor quality aquatic ecosystems",null,null,null,null,"P3.2 Reduce water use for landscape irrigation "]
[null,null,null,null,null,null,"Conserve habitats for threatened and endangered species",null,null,null,null,"C3.3 Manage precipitation beyond baseline",6]
[null,null,"Select ",null,null,null,"Prerequisite 1.4: Case 1: Brownfields and previously developed sites",null,null,null,null,"C3.4 Reduce outdoor water use",6]
[null,null,"Certified",null,null,null,"Prerequisite 1.4:  Case 2: Greenfield sites",null,null,null,null,"C3.5 Design functional stormwater features as amenities",5]
[null,null,"Registered",null,null,null,"Credit  1.5 Redevelop degraded sites",null,null,null,null,"C3.6 Restore aquatic ecosystems",6]
[null,null,"Split review process initiated/to be initiated",null,null,null,"Credit 1.5: Case 1 - Previously developed sites",null,null,null,null,"P4.2 Control and manage invasive plants"]
[null,null,"Combined review process initiated/to be initiated",null,null,null,"Credit 1.5: Case 2: Brownfield sites",null,null,null,null,"P4.3 Use appropriate plants"]
[null,null,null,null,null,null,"Credit  1.6 Locate Projects Within Existing Developed Areas",null,null,null,null,"Credit 4.4: Conserve healthy soils and appropriate vegetation",6]
[null,null,"Select ",null,null,null,"Credit 1.7 Connect to multimodal transportation networks ",null,null,null,null,"Credit 4.5: Conserve special status vegetation",4]
[null,null,"Certified",null,null,null,"Credit 1.7: Option 1 -Pedestrian and bicycle network",null,null,null,null,"Credit 4.6: Conserve and use native plants",6]
[null,null,"Silver",null,null,null,"Credit 1.7: Transit network:  Brownfield sites",null,null,null,null,"Credit 4.7: Conserve and restore native plant communities",6]
[null,null,"Gold",null,null,null,null,null,null,null,null,"Credit 4.8: Optimize Biomass",6]
[null,null,"Platinum",null,null,null,"Credit 3.3 Manage precipitation beyond baseline",null,null,null,null,"Credit 4.9: Reduce urban heat island effects",4]
[null,null,null,null,null,null,"Credit 3.4 Reduce outdoor water use Option 1: Reduce outdoor water use",null,null,null,null,"Credit 4.10:  Option 1: Reduce energy use",4]
[null,null,null,null,null,null,"Credit 3.4 Option 01:  Reduce outdorr water use",null,null,null,null,"Credit 4.11: Reduce the risk of catastrophic wildfire",4]
[null,null,"SITES Certification",null,null,null,"Credit 3.4 - Option 2: Significantly reduce outdoor water use",null,null,null,null,"P5.1 Eliminate the use of wood from threatened tree species"]
[null,null,"SITES LITE",null,null,null,"Credit 3.4 - Option 3: Elminate outdoor water use",null,null,null,null,"C5.2 Maintain on-site structures and paving",4]
[null,null,null,null,null,null,"Credit 3.5: Design functional stormwater features as amenities",null,null,null,null,"C5.3 Design for adaptability and disassembly",4]
[null,null,null,null,null,null,"Credit 3.6: Restore Aquatic Ecosystems",null,null,null,null,"C5.4 Use salvaged materials and plants",4]
[null,null,null,null,null,null,null,null,null,null,null,"C5.5 Use recycled content materials",4]
[null,null,null,null,null,null,"Credit 4.4: Conserve healthy soils and appropriate vegetation",null,null,null,null,"C5.6 Use regional materials",5]
[null,null,null,null,null,null,"Credit 4.5: Conserve special status vegetation",null,null,null,null,"C5.7 Support responsible extraction of raw materials",5]
[null,null,null,null,null,null,"Credit 4.6: Conserve and use native plants",null,null,null,null,"C5.8 Support transparency and safer chemistry",5]
[null,null,null,null,null,null,"Credit 4.7: Conserve and restore native plant communities",null,null,null,null,"C5.9 Support sustainability in materials manufacturing",5]
[null,null,null,null,null,null,"Credit 4.8: Optimize Biomass",null,null,null,null,"C5.10 Support sustainability in plant production",5]
[null,null,null,null,null,null,"Credit 4.9: Reduce urban heat island effects",null,null,null,null,"C6.1 Protect and maintain cultural and historic places",3]
[null,null,null,null,null,null,"Credit 4.10:  Option 1: Reduce energy use",null,null,null,null,"C6.2 Provide optimum site accessibility, safety, and wayfinding ",2]
[null,null,null,null,null,null,"C4.10 - Option 2: \nProvide shade structures",null,null,null,null,"C6.3 Promote equitable site use",2]
[null,null,null,null,null,null,"C4.10 - Option 3: \nProvide a windbreak",null,null,null,null,"C6.4 Support mental restoration",2]
[null,null,null,null,null,null,"Credit 4.11: Reduce the risk of catastrophic wildfire",null,null,null,null,"C6.5 Support physical activity",2]
[null,null,null,null,null,null,null,null,null,null,null,"C6.6 Support social connection",2]
[null,null,null,null,null,null,"Communicate and verify sustainable construction practices",null,null,null,null,"C6.7 Provide on-site food production",4]
[null,null,null,null,null,null,"Control and retain construction pollutants",null,null,null,null,"C6.8 Reduce light pollution",4]
[null,null,null,null,null,null,"Restore soils disturbed during construction",null,null,null,null,"C6.9 Encourage fuel efficient and multi-modal transportation",4]
[null,null,null,null,null,null,"Credit 7.4 Restore soils disturbed by previous development",null,null,null,null,"C6.10Minimize exposure to environmental tobacco smoke ",2]
[null,null,null,null,null,null,"Credit 7.5 Divert construction and demolition materials from disposal",null,null,null,null,"C6.11 Support local economy",3]
[null,null,null,null,null,null," Credit 7.6 Divert reusable vegetation, rocks, and soil from disposal",null,null,null,null,"P7.1 Communicate and verify sustainable construction practices"]
[null,null,null,null,null,null," Credit 7.7Protect air quality during construction",null,null,null,null,"P7.2 Control and retain construction pollutants"]
[null,null,null,null,null,null,null,null,null,null,null,"C7.5 Divert construction and demolition materials from disposal",4]
[null,null,null,null,null,null,null,null,null,null,null,"P8.1 Plan for sustainable site maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,"P8.2 Provide for storage and collection of recyclables"]
[null,null,null,null,null,null,null,null,null,null,null,"C8.3 Recycle organic matter",5]
[null,null,null,null,null,null,null,null,null,null,null,"C8.4 Minimize pesticide and fertilizer use",5]
[null,null,null,null,null,null,null,null,null,null,null,"C8.5 Reduce outdoor energy consumption",4]
[null,null,null,null,null,null,null,null,null,null,null,"C8.6 Use renewable sources for landscape electricity needs",4]
[null,null,null,null,null,null,null,null,null,null,null,"C8.7 Protect air quality during landscape maintenance",4]
[null,null,null,null,null,null,null,null,null,null,null,"C9.1 Promote sustainability awareness and education",4]
[null,null,null,null,null,null,null,null,null,null,null,"C9.2 Develop and communicate a case study",3]
[null,null,null,null,null,null,null,null,null,null,null,"C9.3 Plan to monitor and report site performance",4]