{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Eligibility List","Materials List","P5.1","C5.3","C5.4, C5.5, C5.6","C5.7","C5.8","C5.9","C5.10","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Introduction","index":0,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[4,2,4,5],[20,2,20,5],[2,2,2,5],[7,4,7,5]]}
[]
[]
[null,null,"SITES® v2 Materials Worksheet"]
[]
[null,null,"MATERIALS INTRODUCTION"]
[]
[null,null,"PROJECT NAME",null,"PROJECT ID#"]
[]
[]
[null,null,"Step 1."]
[null,null,"Enable macros"]
[null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,"Step 2."]
[null,null,"Enter the total materials cost for all products and materials used on the project (excluding labor)."]
[null,null,"Note: The total materials cost may be higher value than the total materials cost listed within the Materials List"]
[]
[null,null,"Total materials cost"]
[]
[null,null,"Step 3."]
[null,null,"Complete the Materials List tab for all products and materials included in the following prerequisite and credits (as applicable):\n\nP5.1: Eliminate the use of wood from threatened tree species\nC5.3: Design for adaptability and disassembly\nC5.4: Reuse salvaged materials and plants\nC5.5: Use recycled content materials\nC5.6: Use regional materials\nC5.7: Support responsible extraction of raw materials\nC5.8: Support transparency and safer chemistry\nC5.9: Support sustainability in materials manufacturing\nC5.10: Support sustainability in plant production"]
[]
[null,null,null,null,null,null,"V1"]
[null,null,null,null,null,null,"Copyright ©2015"]
[null,null,null,null,null,null,"Green Business Certification Inc."]
[null,null,null,null,null,null,"All Rights Reserved"]
[]
[null,null,null,null,null,null,null,null,null,"Product list"]
[null,null,null,null,null,null,null,null,null,"Plant"]
[null,null,null,null,null,null,null,null,null,"Seed"]
[null,null,null,null,null,null,null,null,null,"Sod"]
[null,null,null,null,null,null,null,null,null,"Soil"]
[null,null,null,null,null,null,null,null,null,"Mulch - wood"]
[null,null,null,null,null,null,null,null,null,"Mulch - other"]
[null,null,null,null,null,null,null,null,null,"Sand (if used as a soil amendment)"]
[null,null,null,null,null,null,null,null,null,"Other soil amendment"]
[null,null,null,null,null,null,null,null,null,"Compost"]
[null,null,null,null,null,null,null,null,null,"Stone"]
[null,null,null,null,null,null,null,null,null,"Natural rock or boulder (uncut)"]
[null,null,null,null,null,null,null,null,null,"Cut or processed stone"]
[null,null,null,null,null,null,null,null,null,"Aggregate/gravel"]
[null,null,null,null,null,null,null,null,null,"Sand (if used as a base course material)"]
[null,null,null,null,null,null,null,null,null,"Other materials or base course layers"]
[null,null,null,null,null,null,null,null,null,"Wood - Natural Lumber"]
[null,null,null,null,null,null,null,null,null,"Wood - Manufactured/compressed wood product"]
[null,null,null,null,null,null,null,null,null,"Non-wood decking, railing, fencing, trellises, or lattice"]
[null,null,null,null,null,null,null,null,null,"Pipe, hose, or irrigation equipment"]
[null,null,null,null,null,null,null,null,null,"Conduit, wiring, and electrical equipment"]
[null,null,null,null,null,null,null,null,null,"Lighting"]
[null,null,null,null,null,null,null,null,null,"Membrane, liner or geotextile"]
[null,null,null,null,null,null,null,null,null,"Fabric or canvas"]
[null,null,null,null,null,null,null,null,null,"Extruded, spray or board foams"]
[null,null,null,null,null,null,null,null,null,"Concrete"]
[null,null,null,null,null,null,null,null,null,"Brick or masonry unit"]
[null,null,null,null,null,null,null,null,null,"Sand (for purposes other than soil amendment or base course material)"]
[null,null,null,null,null,null,null,null,null,"Paint or coating"]
[null,null,null,null,null,null,null,null,null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing"]
[null,null,null,null,null,null,null,null,null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)"]
[]
[null,null,null,null,null,null,null,null,null,"P5.1"]
[null,null,null,null,null,null,null,null,null,"Cites status"]
[null,null,null,null,null,null,null,null,null,"Appendix I"]
[null,null,null,null,null,null,null,null,null,"Appendix II"]
[null,null,null,null,null,null,null,null,null,"Other or not listed"]
[]
[null,null,null,null,null,null,null,null,null,"IUCN status"]
[null,null,null,null,null,null,null,null,null,"EW"]
[null,null,null,null,null,null,null,null,null,"CR"]
[null,null,null,null,null,null,null,null,null,"EN"]
[null,null,null,null,null,null,null,null,null,"Other or not listed"]

{"sheet":"Eligibility List","index":1,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,1,12],[3,1,3,12],[12,1,12,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[4,1,6,3],[4,4,5,12],[29,1,29,3],[30,1,30,3],[31,1,31,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[28,1,28,3],[21,1,21,3],[7,1,7,3],[8,1,8,3],[26,1,26,3],[27,1,27,3],[20,1,20,3],[19,1,19,3],[13,1,13,3],[18,1,18,3],[17,1,17,3],[16,1,16,3],[15,1,15,3],[14,1,14,3],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[42,1,42,12],[43,1,43,12],[35,1,35,3],[36,1,36,3],[32,1,32,3],[33,1,33,3],[34,1,34,3]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"PRODUCT AND MATERIAL ELIGIBILITY"]
[null,"PRODUCT OR MATERIAL",null,null,"ELIGIBILITY - REQUIRED TO BE INCLUDED"]
[]
[null,null,null,null,"P5.1","C5.3","C5.4","C5.5","C5.6","C5.7","C5.8","C5.9","C5.10"]
[null,"Plant",null,null,null,null,"●",null,"250 mi",null,null,null,"●"]
[null,"Seed",null,null,null,null,null,null,"500 mi",null,null,null,"●"]
[null,"Sod",null,null,null,null,"●",null,"250 mi",null,null,null,"●"]
[null,"Soil",null,null,null,null,null,null,"50 mi","●"]
[null,"Mulch - wood",null,null,"●",null,"●","●","50 mi","●"]
[null,"Mulch - other",null,null,null,"●","●","●","50 mi","●"]
[null,"Sand (if used as a soil amendment)",null,null,null,null,null,null,"50 mi","●"]
[null,"Other soil amendment",null,null,null,null,null,null,"50 mi","●"]
[null,"Compost",null,null,null,null,null,null,"50 mi","●"]
[null,"Stone",null,null,null,"●","●","●","50 mi","●",null,"●"]
[null,"Natural rock or boulder (uncut)",null,null,null,null,"●","●","50 mi","●"]
[null,"Cut or processed stone",null,null,null,"●","●","●","50 mi","●",null,"●"]
[null,"Aggregate/gravel",null,null,null,"●","●","●","50 mi","●",null,"●"]
[null,"Sand (if used as a base course material)",null,null,null,"●","●","●","500 mi","●",null,"●"]
[null,"Other materials or base course layers",null,null,null,"●","●","●","500 mi","●",null,"●"]
[null,"Wood - Natural Lumber",null,null,"●","●","●",null,"500 mi","●","●","●"]
[null,"Wood - Manufactured/compressed wood product",null,null,"●","●","●","●","500 mi","●","●","●"]
[null,"Non-wood decking, railing, fencing, trellises, or lattice",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Pipe, hose, or irrigation equipment",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Conduit, wiring, and electrical equipment",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Lighting",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Membrane, liner or geotextile",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Fabric or canvas",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Extruded, spray or board foams",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Concrete",null,null,null,"●","●","●","500 mi","●",null,"●"]
[null,"Brick or masonry unit",null,null,null,"●","●","●","500 mi","●",null,"●"]
[null,"Sand (for purposes other than soil amendment or base course material)",null,null,null,"●","●","●","500 mi","●",null,"●"]
[null,"Paint or coating",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing",null,null,null,"●","●","●","500 mi","●","●","●"]
[null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)",null,null,null,"●","●","●","500 mi","●","●","●"]
[]
[null,"Notes:"]
[null,"P5.1: only wood products are included, including temporary wood used during construction"]
[null,"C5.3: plants, sod, seed, soil (including amendments), and natural rocks or boulders are excluded  "]
[null,"C5.4: seed, soil (including amendments), and recycled content products are excluded "]
[null,"C5.5: plants, sod, seed, soil (including amendments), natural rocks, boulders, and salvaged materials are excluded "]
[null,"C5.6: all materials and products are included; seed should meet the same distance as \"All other materials\" (500 miles)"]
[null,"C5.7: plants, sod, seed, salvaged materials, and recycled content products are excluded"]
[null,"C5.8: only the product types listed in the Reference Guide are included; ensure any wood-based material is correctly classified as either natural lumber or manufactured or compressed wood products"]
[null,"C5.9: natural rocks or boulders, plants, sod, seed, soil (including amendments) and salvaged materials are excluded"]
[null,"C5.10: only plants, sod, and seed are included  "]

{"sheet":"Materials List","index":2,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[7,1,7,2],[6,1,6,6],[1,1,1,7],[3,1,3,7]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"PRODUCT AND MATERIAL IDENTIFICATION"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Complete the following form for all products and materials purchased for the project that are included in the prerequisite and credits (applicable) excluding labor."]
[]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Salvaged or Reused","Cost per Unit","Quantity","Total Materials Cost"]
[{"$f":"IF(F10>=0,0,0)","v":0},null,null,null,null,null,1,{"$f":"F10*G10","v":0}]
[{"$f":"IF(F11>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"F11*G11","v":0}]
[0,null,null,null,null,null,null,{"$f":"F12*G12","v":0}]
[0,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,0]
[{"$f":"IF(F15>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"F15*G15","v":0}]
[0,null,null,null,null,null,null,0]
[{"$f":"IF(F17>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"F17*G17","v":0}]
[0,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,0]
[{"$f":"IF(F20>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"F20*G20","v":0}]
[0,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,0]
["A","Total value for applicable products and materials ($)",null,null,null,null,null,{"$f":"SUM(H10:H22)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Material Product Dropdown"]
[null,"Plant"]
[null,"Seed"]
[null,"Sod"]
[null,"Soil"]
[null,"Mulch - wood"]
[null,"Mulch - other"]
[null,"Sand (if used as a soil amendment)"]
[null,"Other soil amendment"]
[null,"Compost"]
[null,"Stone"]
[null,"Natural rock or boulder (uncut)"]
[null,"Cut or processed stone"]
[null,"Aggregate/gravel"]
[null,"Sand (if used as a base course material)"]
[null,"Other materials or base course layers"]
[null,"Wood - Natural Lumber"]
[null,"Wood - Manufactured/compressed wood product"]
[null,"Non-wood decking, railing, fencing, trellises, or lattice"]
[null,"Pipe, hose, or irrigation equipment"]
[null,"Conduit, wiring, and electrical equipment"]
[null,"Lighting"]
[null,"Membrane, liner or geotextile"]
[null,"Fabric or canvas"]
[null,"Extruded, spray or board foams"]
[null,"Concrete"]
[null,"Brick or masonry unit"]
[null,"Sand (for purposes other than soil amendment or base course material)"]
[null,"Paint or coating"]
[null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing"]
[null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)"]

{"sheet":"P5.1","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,9,8,9],[7,1,7,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[3,1,3,9]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"P5.1: ELIMINATE THE USE OF WOOD FROM THREATENED TREE SPECIES"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. This prerequisite does not apply to non-wood materials. All wood, manufactured wood, wood mulch or other wood products must meet this prerequisite."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,"Product type is eligible for prerequisite","Wood Species","CITES Status","IUCN Status","Third-Party\nCertification?","Meets P5.1?"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(D10=\"\",\"N\",IF(COUNTIF($B$29:$B$31,D10),\"Y\",\"N\"))","v":"N"},null,null,null,null,{"$f":"IF(E10=\"Y\",IF(OR(AND(OR(G10<>\"Other or not listed\",H10<>\"Other or not listed\"),I10=\"Y\"),AND(G10=\"Other or not listed\",H10=\"Other or not listed\")),\"Y\",\"N\"),\"N/A\")","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},"N",null,null,null,null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},"N",null,null,null,null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},"N",null,null,null,null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},"N",null,null,null,null,"N/A"]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},"N",null,null,null,null,{"$f":"IF(E15=\"Y\",IF(OR(AND(OR(G15<>\"Other or not listed\",H15<>\"Other or not listed\"),I15=\"Y\"),AND(G15=\"Other or not listed\",H15=\"Other or not listed\")),\"Y\",\"N\"),\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},"N",null,null,null,null,"N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},"N",null,null,null,null,{"$f":"IF(E17=\"Y\",IF(OR(AND(OR(G17<>\"Other or not listed\",H17<>\"Other or not listed\"),I17=\"Y\"),AND(G17=\"Other or not listed\",H17=\"Other or not listed\")),\"Y\",\"N\"),\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},"N",null,null,null,null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},"N",null,null,null,null,"N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},"N",null,null,null,null,{"$f":"IF(E20=\"Y\",IF(OR(AND(OR(G20<>\"Other or not listed\",H20<>\"Other or not listed\"),I20=\"Y\"),AND(G20=\"Other or not listed\",H20=\"Other or not listed\")),\"Y\",\"N\"),\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},"N",null,null,null,null,"N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},"N",null,null,null,null,{"$f":"IF(E22=\"Y\",IF(OR(AND(OR(G22<>\"Other or not listed\",H22<>\"Other or not listed\"),I22=\"Y\"),AND(G22=\"Other or not listed\",H22=\"Other or not listed\")),\"Y\",\"N\"),\"N/A\")","v":"N/A"}]
["A","All products meet prerequisite?",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J10:J22,\"N\"),\"No\",IF(COUNTIF(J10:J22,\"Y\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[]
[]
[]
[null,"Eligibility List- INCLUDED"]
[null,"Mulch - wood"]
[null,"Wood - Manufactured/compressed wood product"]
[null,"Wood - Natural Lumber"]

{"sheet":"C5.3","index":4,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7],[7,5,8,5],[7,1,7,4],[7,6,8,6],[7,7,8,7],[6,1,6,7]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.3: DESIGN FOR ADAPTABILITY AND DISASSEMBLY"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Enter the percentage of reusable weight. Percentages are based on cost or replacement value. In the case of mixed material assemblies, determine the portion of the total weight that is reusable."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,null,"Product type is eligible for credit","Reusable Weight \n(%)","Total Cost of Reusable Components"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Total Cost of Material"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},{"$f":"IF(D10=\"\",\"N\",IF(COUNTIF($B$29:$B$49,D10),\"Y\",\"N\"))","v":"N"},null,{"$f":"IF(F10=\"Y\",G10*E10,\"N/A\")","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},"N",null,{"$f":"IF(F11=\"Y\",G11*E11,\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},"N",null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},"N",null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},"N",null,"N/A"]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},"N",null,{"$f":"IF(F15=\"Y\",G15*E15,\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},"N",null,"N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},"N",null,{"$f":"IF(F17=\"Y\",G17*E17,\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},"N",null,"N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},"N",null,"N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},"N",null,{"$f":"IF(F20=\"Y\",G20*E20,\"N/A\")","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},"N",null,"N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},"N",null,"N/A"]
["A","Total reusable materials cost",null,null,null,null,null,{"$f":"SUM(H10:H22)","v":0}]
[null,"Total materials cost (less ineligible product cost)",null,null,null,null,null,{"$f":"Introduction!F18 - SUMIF($F$10:$F$22,\"N\",$E$10:$E$22)","v":0}]
[null,"Percent of reusable components (%)",null,null,null,null,null,{"$f":"IFERROR(H23/H24,0)","v":0}]
[]
[]
[null,"Eligibility List"]
[null,"Mulch - other"]
[null,"Stone"]
[null,"Cut or processed stone"]
[null,"Aggregate/gravel"]
[null,"Sand (if used as a base course material)"]
[null,"Other materials or base course layers"]
[null,"Wood - Natural Lumber"]
[null,"Wood - Manufactured/compressed wood product"]
[null,"Non-wood decking, railing, fencing, trellises, or lattice"]
[null,"Pipe, hose, or irrigation equipment"]
[null,"Conduit, wiring, and electrical equipment"]
[null,"Lighting"]
[null,"Membrane, liner or geotextile"]
[null,"Fabric or canvas"]
[null,"Extruded, spray or board foams"]
[null,"Concrete"]
[null,"Brick or masonry unit"]
[null,"Sand (for purposes other than soil amendment or base course material)"]
[null,"Paint or coating"]
[null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing"]
[null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)"]

{"sheet":"C5.4, C5.5, C5.6","index":5,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[27,15,27,19],[27,6,27,13],[23,6,23,7],[1,1,1,4],[24,6,24,7],[3,1,3,4],[7,15,7,19],[22,15,22,18],[23,15,23,18],[24,15,24,18],[6,1,6,4],[22,1,22,3],[24,10,24,12],[23,10,23,12],[7,6,7,8],[7,10,7,13],[7,1,7,4],[22,10,22,12],[22,6,22,7]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.4: REUSE SALVAGED MATERIALS AND PLANTS\nC5.5: USE RECYCLED CONTENT MATERIALS\nC5.6: USE REGIONAL MATERIALS\n"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Enter applicable information for each material under each credit. Percentages are based on cost or replacement value. "]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,null,null,"C5.4: SALVAGED MATERIALS",null,null,null,"C5.5: RECYCLED CONTENT",null,null,null,null,"C5.6: REGIONAL"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Total Cost of Material",null,"Product type is eligible for credit","Salvaged or\nReused\n(from Materials List tab)","Total Cost of Salvaged Material",null,"Product type is eligible for credit","Post-\nConsumer\n(%)","Pre-Consumer\n(%)","Total Cost of Recycled Materials",null,"Maximum \nAllowable\nDistance\n(miles)","Manufacturer Supplier Distance\n(miles)","Extraction Distance\n(miles)","Percent Weight Regional\n(%)","Total Cost of Regional\nMaterials"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},null,{"$f":"IF($D10=\"\",\"N\",IF(COUNTIF($G$30:$G$34,$D10),\"N\",\"Y\"))","v":"N"},{"$f":"IF(ISBLANK('Materials List'!E10),\"\",'Materials List'!E10)","v":""},{"$f":"IF(G10=\"N\",\"N/A\",IF(H10=\"Y\",E10,0))","v":"N/A"},null,{"$f":"IF($D10=\"\",\"N\",IF(COUNTIF($K$30:$K$38,$D10),\"N\",\"Y\"))","v":"N"},null,null,{"$f":"IF(K10=\"N\",\"N/A\",IF(OR(L10>0,M10>0),$E10*(L10+(0.5*M10)),0))","v":"N/A"},null,{"$f":"IF(D10=\"\",\"\",IF(COUNTIF($P$30:$P$39,$D10),50,IF(OR(D10=\"Plant\",D10=\"Sod\"),250,500)))","v":""},null,null,null,{"$f":"IF(AND(Q10<P10,R10<P10,S10>0),E10*S10,0)","v":0}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E11),\"\",'Materials List'!E11)","v":""},{"$f":"IF(G11=\"N\",\"N/A\",IF(H11=\"Y\",E11,0))","v":"N/A"},null,{"$f":"IF($D11=\"\",\"N\",IF(COUNTIF($K$30:$K$38,$D11),\"N\",\"Y\"))","v":"N"},null,null,{"$f":"IF(K11=\"N\",\"N/A\",IF(OR(L11>0,M11>0),$E11*(L11+(0.5*M11)),0))","v":"N/A"},null,{"$f":"IF(D11=\"\",\"\",IF(COUNTIF($P$30:$P$39,$D11),50,IF(OR(D11=\"Plant\",D11=\"Sod\"),250,500)))","v":""},null,null,null,{"$f":"IF(AND(Q11<P11,R11<P11,S11>0),E11*S11,0)","v":0}]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E12),\"\",'Materials List'!E12)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E13),\"\",'Materials List'!E13)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E14),\"\",'Materials List'!E14)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E15),\"\",'Materials List'!E15)","v":""},{"$f":"IF(G15=\"N\",\"N/A\",IF(H15=\"Y\",E15,0))","v":"N/A"},null,"N",null,null,{"$f":"IF(K15=\"N\",\"N/A\",IF(OR(L15>0,M15>0),$E15*(L15+(0.5*M15)),0))","v":"N/A"},null,"",null,null,null,{"$f":"IF(AND(Q15<P15,R15<P15,S15>0),E15*S15,0)","v":0}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E16),\"\",'Materials List'!E16)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E17),\"\",'Materials List'!E17)","v":""},{"$f":"IF(G17=\"N\",\"N/A\",IF(H17=\"Y\",E17,0))","v":"N/A"},null,"N",null,null,{"$f":"IF(K17=\"N\",\"N/A\",IF(OR(L17>0,M17>0),$E17*(L17+(0.5*M17)),0))","v":"N/A"},null,"",null,null,null,{"$f":"IF(AND(Q17<P17,R17<P17,S17>0),E17*S17,0)","v":0}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E18),\"\",'Materials List'!E18)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E19),\"\",'Materials List'!E19)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E20),\"\",'Materials List'!E20)","v":""},{"$f":"IF(G20=\"N\",\"N/A\",IF(H20=\"Y\",E20,0))","v":"N/A"},null,"N",null,null,{"$f":"IF(K20=\"N\",\"N/A\",IF(OR(L20>0,M20>0),$E20*(L20+(0.5*M20)),0))","v":"N/A"},null,"",null,null,null,{"$f":"IF(AND(Q20<P20,R20<P20,S20>0),E20*S20,0)","v":0}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E21),\"\",'Materials List'!E21)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},null,"N",{"$f":"IF(ISBLANK('Materials List'!E22),\"\",'Materials List'!E22)","v":""},"N/A",null,"N",null,null,"N/A",null,"",null,null,null,0]
["A","Total materials cost (from Introduction tab)",null,null,{"$f":"Introduction!F18","v":0},null,"Total salvaged materials cost",null,{"$f":"SUM(I10:I22)","v":0},null,"Total recycled materials cost",null,null,{"$f":"SUM(N10:N22)","v":0},null,"Total regional materials cost",null,null,null,{"$f":"SUM(T10:T22)","v":0}]
[null,null,null,null,null,null,"Total materials cost (less ineligible product and recycled materials cost)",null,{"$f":"$E$23 - SUMIF($G$10:$G$22,\"N\",$E$10:$E$22) - N23","v":0},null,"Total materials cost (less ineligible product and salvaged materials cost)",null,null,{"$f":"$E$23 - SUMIF($K$10:$K$22,\"N\",$E$10:$E$22) - I23","v":0},null,"Total materials cost",null,null,null,{"$f":"$E$23","v":0}]
[null,null,null,null,null,null,"Percent salvaged materials (%)",null,{"$f":"IFERROR(I23/I24,0)","v":0},null,"Percent recycled materials (%)",null,null,{"$f":"IFERROR(N23/N24,0)","v":0},null,"Percent regional materials (%)",null,null,null,{"$f":"IFERROR(T23/T24,0)","v":0}]
[]
[]
[null,null,null,null,null,null,"NOTE: Materials can only count for either c5.4 or c5.5, but not both.",null,null,null,null,null,null,null,null,"NOTE: Soil, Mulch, Soil amendments, Aggregate, Natural rocks and boulders must be extracted and manufactured within 50 miles. Plants and sod must be grown within 250 miles. All other materials must be extracted and manufactured within 500 miles.\n"]
[null,null,null,null,null,null,"Eligibility List - NOT eligible",null,null,null,"Eligibility List - NOT eligible",null,null,null,null,"50 mile distance list"]
[null,null,null,null,null,null,"Seed",null,null,null,"Plant",null,null,null,null,"Soil"]
[null,null,null,null,null,null,"Soil",null,null,null,"Seed",null,null,null,null,"Sand (if used as a soil amendment)"]
[null,null,null,null,null,null,"Sand (if used as a soil amendment)",null,null,null,"Soil",null,null,null,null,"Other soil amendment"]
[null,null,null,null,null,null,"Other soil amendment",null,null,null,"Sand (if used as a soil amendment)",null,null,null,null,"Compost"]
[null,null,null,null,null,null,"Compost",null,null,null,"Other soil amendment",null,null,null,null,"Mulch - wood"]
[null,null,null,null,null,null,null,null,null,null,"Compost",null,null,null,null,"Mulch - other"]
[null,null,null,null,null,null,null,null,null,null,"Wood - Natural Lumber",null,null,null,null,"Stone"]
[null,null,null,null,null,null,null,null,null,null,"Wood - Manufactured/compressed wood product",null,null,null,null,"Natural rock or boulder (uncut)"]
[null,null,null,null,null,null,null,null,null,null,"Sod",null,null,null,null,"Cut or processed stone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aggregate/gravel"]

{"sheet":"C5.7","index":6,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,5,27,11],[6,1,6,11],[7,12,8,12],[22,1,22,4],[7,1,7,3],[7,4,7,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[25,8,25,13],[26,8,26,13],[22,13,22,14],[23,8,23,12],[24,8,24,13],[1,1,1,14],[3,1,3,14],[7,13,8,13],[7,14,8,14],[22,8,22,11]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.7: SUPPORT RESPONSIBLE EXTRACTION OF RAW MATERIALS"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Only the product types listed in the Reference Guide are eligible for this credit. If any materials supplier provides publically available information meeting the requirements of this credit no letter needs to be submitted, but the project should still choose \"Y\" in the \"Supporting Documentation\" and \"Option 1 Letter Sent\" Columns under this credit."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,"Product Eligibility",null,null,null,"Total Cost of Material","Option","Supporting Documentation","Option 2 and Option 3 only:\nPercent Weight Responsibly Extracted\n(%)","Option 1 Letter Sent (Y or N)","Total Cost of Option 2\nMaterials","Total Cost of Option 3\nMaterials"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Salvaged or Reused","Recycled","Product and Material Eligibility for C5.7","Final Eligibility"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!E10),\"\",'Materials List'!E10)","v":""},{"$f":"IF(VLOOKUP(D10,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D10,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},{"$f":"IF($D10=\"\",\"N\",IF(COUNTIF($F$30:$F$36,$D10),\"N\",\"Y\"))","v":"N"},{"$f":"IF(AND(E10=\"N\",F10=\"N\",G10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},null,null,null,null,{"$f":"IF(H10=\"N\",\"N/A\",IF(AND(J10=\"Opt 2\",H10=\"Y\",L10>0,K10=\"Y\"),$I10*L10,0))","v":"N/A"},{"$f":"IF(H10=\"N\",\"N/A\",IF(AND(J10=\"Opt 3\",H10=\"Y\",L10>0,K10=\"Y\"),$I10*L10,0))","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!E11),\"\",'Materials List'!E11)","v":""},{"$f":"IF(VLOOKUP(D11,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D11,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N",{"$f":"IF(AND(E11=\"N\",F11=\"N\",G11=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},null,null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!E12),\"\",'Materials List'!E12)","v":""},{"$f":"IF(VLOOKUP(D12,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D12,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},null,null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!E13),\"\",'Materials List'!E13)","v":""},{"$f":"IF(VLOOKUP(D13,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D13,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},null,null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!E14),\"\",'Materials List'!E14)","v":""},{"$f":"IF(VLOOKUP(D14,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D14,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},null,null,null,null,"N/A","N/A"]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!E15),\"\",'Materials List'!E15)","v":""},{"$f":"IF(VLOOKUP(D15,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D15,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N",{"$f":"IF(AND(E15=\"N\",F15=\"N\",G15=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},null,null,null,null,{"$f":"IF(H15=\"N\",\"N/A\",IF(AND(J15=\"Opt 2\",H15=\"Y\",L15>0,K15=\"Y\"),$I15*L15,0))","v":"N/A"},{"$f":"IF(H15=\"N\",\"N/A\",IF(AND(J15=\"Opt 3\",H15=\"Y\",L15>0,K15=\"Y\"),$I15*L15,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!E16),\"\",'Materials List'!E16)","v":""},{"$f":"IF(VLOOKUP(D16,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D16,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},null,null,null,null,"N/A","N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!E17),\"\",'Materials List'!E17)","v":""},{"$f":"IF(VLOOKUP(D17,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D17,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N",{"$f":"IF(AND(E17=\"N\",F17=\"N\",G17=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},null,null,null,null,{"$f":"IF(H17=\"N\",\"N/A\",IF(AND(J17=\"Opt 2\",H17=\"Y\",L17>0,K17=\"Y\"),$I17*L17,0))","v":"N/A"},{"$f":"IF(H17=\"N\",\"N/A\",IF(AND(J17=\"Opt 3\",H17=\"Y\",L17>0,K17=\"Y\"),$I17*L17,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!E18),\"\",'Materials List'!E18)","v":""},{"$f":"IF(VLOOKUP(D18,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D18,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},null,null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!E19),\"\",'Materials List'!E19)","v":""},{"$f":"IF(VLOOKUP(D19,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D19,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},null,null,null,null,"N/A","N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!E20),\"\",'Materials List'!E20)","v":""},{"$f":"IF(VLOOKUP(D20,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D20,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N",{"$f":"IF(AND(E20=\"N\",F20=\"N\",G20=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},null,null,null,null,{"$f":"IF(H20=\"N\",\"N/A\",IF(AND(J20=\"Opt 2\",H20=\"Y\",L20>0,K20=\"Y\"),$I20*L20,0))","v":"N/A"},{"$f":"IF(H20=\"N\",\"N/A\",IF(AND(J20=\"Opt 3\",H20=\"Y\",L20>0,K20=\"Y\"),$I20*L20,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!E21),\"\",'Materials List'!E21)","v":""},{"$f":"IF(VLOOKUP(D21,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D21,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},null,null,null,null,"N/A","N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!E22),\"\",'Materials List'!E22)","v":""},{"$f":"IF(VLOOKUP(D22,'C5.4, C5.5, C5.6'!D:M,9,FALSE)+VLOOKUP(D22,'C5.4, C5.5, C5.6'!D:M,10,FALSE)<>0,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},null,null,null,null,"N/A","N/A"]
["A",null,null,null,null,null,null,null,"Option 1 compliance has been met for all products",null,null,null,{"$f":"IF(COUNTIFS(M10:M22,\"<>Y\",H10:H22,\"Y\")>0,\"No\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,null,null,null,"Total eligible materials cost (Option 2 and Option 3 only)",null,null,null,null,{"$f":"SUM(N10:N22)","v":0},{"$f":"SUM(O10:O22)","v":0}]
[null,null,null,null,null,null,null,null,"Total materials cost (less ineligible product, salvaged, and recycled materials cost)",null,null,null,null,null,{"$f":"Introduction!F18 - SUMIF(H10:H22,\"N\",I10:I22)","v":0}]
[null,null,null,null,null,null,null,null,"Percent materials meeting Option 2 (%)",null,null,null,null,null,{"$f":"IFERROR(N24/O25,0)","v":0}]
[null,null,null,null,null,null,null,null,"Percent materials meeting Option 3 (%)",null,null,null,null,null,{"$f":"IFERROR(O24/O25,0)","v":0}]
[null,null,null,null,null,"NOTE: If any materials supplier provides publically available information meeting the requirements of this credit no letter needs to be submitted, but the project should still choose \"Y\" in the \"Supporting Documentation\" Column under this credit."]
[null,null,null,null,null,"Eligibility List - NOT eligible"]
[null,null,null,null,null,"Plant"]
[null,null,null,null,null,"Sod"]
[null,null,null,null,null,"Seed"]

{"sheet":"C5.8","index":7,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,1,3,11],[25,1,25,10],[26,1,26,10],[6,1,6,11],[7,11,8,11],[22,1,22,8],[23,1,23,6],[24,1,24,10],[7,1,7,5],[7,6,8,6],[7,9,8,9],[7,10,8,10],[7,7,8,7],[7,8,8,8]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.8: SUPPORT TRANSPARENCY AND SAFER CHEMISTRY"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Only the product types listed in the Reference Guide are eligible for this credit. If any materials supplier provides publically available information meeting the requirements of this credit no letter needs to be submitted, but the project should still choose \"Y\" in the \"Supporting Documentation\" and \"Option 1 Letter Sent\" Columns under this credit."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,null,null,"Product type is eligible for credit","Option","Supporting Documentation","Option 1 Letter Sent (Y or N)","Total Cost of Option 2\nMaterials","Total Cost of Option 3\nMaterials"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Salvaged or Reused","Total Cost of Material"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!E10),\"\",'Materials List'!E10)","v":""},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},{"$f":"IF(D10=\"\",\"N\",IF(COUNTIF($B$31:$B$41,D10),\"Y\",\"N\"))","v":"N"},null,null,null,{"$f":"IF(G10=\"N\",\"N/A\",IF(AND(H10=\"Opt 2\",I10=\"Y\",E10=\"N\"),$F10,0))","v":"N/A"},{"$f":"IF(OR(G10=\"N\",H10<>\"Opt 3\"),\"N/A\",IF(AND(H10=\"Opt 3\",I10=\"Y\",E10=\"N\"),$F10,0))","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!E11),\"\",'Materials List'!E11)","v":""},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!E12),\"\",'Materials List'!E12)","v":""},{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!E13),\"\",'Materials List'!E13)","v":""},{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!E14),\"\",'Materials List'!E14)","v":""},{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},"N",null,null,null,{"$f":"IF(G14=\"N\",\"N/A\",IF(AND(H14=\"Opt 2\",I14=\"Y\",E14=\"N\"),$F14,0))","v":"N/A"},{"$f":"IF(OR(G14=\"N\",H14<>\"Opt 3\"),\"N/A\",IF(AND(H14=\"Opt 3\",I14=\"Y\",E14=\"N\"),$F14,0))","v":"N/A"}]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!E15),\"\",'Materials List'!E15)","v":""},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},"N",null,null,null,{"$f":"IF(G15=\"N\",\"N/A\",IF(AND(H15=\"Opt 2\",I15=\"Y\",E15=\"N\"),$F15,0))","v":"N/A"},{"$f":"IF(OR(G15=\"N\",H15<>\"Opt 3\"),\"N/A\",IF(AND(H15=\"Opt 3\",I15=\"Y\",E15=\"N\"),$F15,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!E16),\"\",'Materials List'!E16)","v":""},{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!E17),\"\",'Materials List'!E17)","v":""},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},"N",null,null,null,{"$f":"IF(G17=\"N\",\"N/A\",IF(AND(H17=\"Opt 2\",I17=\"Y\",E17=\"N\"),$F17,0))","v":"N/A"},{"$f":"IF(OR(G17=\"N\",H17<>\"Opt 3\"),\"N/A\",IF(AND(H17=\"Opt 3\",I17=\"Y\",E17=\"N\"),$F17,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!E18),\"\",'Materials List'!E18)","v":""},{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!E19),\"\",'Materials List'!E19)","v":""},{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!E20),\"\",'Materials List'!E20)","v":""},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},"N",null,null,null,{"$f":"IF(G20=\"N\",\"N/A\",IF(AND(H20=\"Opt 2\",I20=\"Y\",E20=\"N\"),$F20,0))","v":"N/A"},{"$f":"IF(OR(G20=\"N\",H20<>\"Opt 3\"),\"N/A\",IF(AND(H20=\"Opt 3\",I20=\"Y\",E20=\"N\"),$F20,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!E21),\"\",'Materials List'!E21)","v":""},{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},"N",null,null,null,"N/A","N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!E22),\"\",'Materials List'!E22)","v":""},{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},"N",null,null,null,{"$f":"IF(G22=\"N\",\"N/A\",IF(AND(H22=\"Opt 2\",I22=\"Y\",E22=\"N\"),$F22,0))","v":"N/A"},{"$f":"IF(OR(G22=\"N\",H22<>\"Opt 3\"),\"N/A\",IF(AND(H22=\"Opt 3\",I22=\"Y\",E22=\"N\"),$F22,0))","v":"N/A"}]
["A","Option 1 compliance has been met for all products",null,null,null,null,null,null,null,{"$f":"IF(COUNTIFS(J10:J22,\"<>Y\",G10:G22,\"Y\")>0,\"No\",\"Yes\")","v":"Yes"}]
[null,"Total eligible materials cost (Option 2 and Option 3 only)",null,null,null,null,null,null,null,null,{"$f":"SUM(K10:K22)","v":0},{"$f":"SUM(L10:L22)","v":0}]
[null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,null,null,null,null,null,{"$f":"Introduction!F18 - SUMIF(G10:G22,\"N\",F10:F22) - SUMIFS(F10:F22,G10:G22,\"Y\",E10:E22,\"Y\")","v":0}]
[null,"Percent materials meeting Option 2 (%)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K24/L25,0)","v":0}]
[null,"Percent materials meeting Option 3 (%)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(L24/L25,0)","v":0}]
[]
[]
[null,"Eligibility List"]
[null,"Wood - Natural Lumber"]
[null,"Wood - Manufactured/compressed wood product"]
[null,"Non-wood decking, railing, fencing, trellises, or lattice"]
[null,"Pipe, hose, or irrigation equipment"]
[null,"Conduit, wiring, and electrical equipment"]
[null,"Lighting"]
[null,"Membrane, liner or geotextile"]
[null,"Fabric or canvas"]
[null,"Extruded, spray or board foams"]
[null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing"]
[null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)"]

{"sheet":"C5.9","index":8,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,1,3,11],[24,1,24,10],[25,1,25,10],[26,1,26,10],[7,9,8,9],[7,10,8,10],[6,1,6,11],[7,11,8,11],[23,1,23,6],[7,1,7,5],[7,7,8,7],[7,8,8,8],[7,6,8,6],[22,1,22,8]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.9: SUPPORT SUSTAINABILITY IN MATERIALS MANUFACTURING"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Natural rocks or boulders; plants, sod, and seed; soils; and salvaged materials are excluded from this credit. If any manufacturer provides publically available information meeting the requirements of this credit no letter needs to be submitted, but the project should still choose \"Y\" in the \"Supporting Documentation\" and \"Option 1 Letter Sent\" Columns under this credit."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,null,null,"Product type is eligible for credit","Option","Supporting Documentation","Option 1 Letter Sent (Y or N)","Total Cost of Option 2\nMaterials","Total Cost of Option 3\nMaterials"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Salvaged or Reused","Total Cost of Material"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!E10),\"\",'Materials List'!E10)","v":""},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},{"$f":"IF(D10=\"\",\"N\",IF(COUNTIF($B$31:$B$50,D10),\"Y\",\"N\"))","v":"N"},null,null,null,{"$f":"IF(G10=\"N\",\"N/A\",IF(AND(H10=\"Opt 2\",I10=\"Y\",E10=\"N\"),$F10,0))","v":"N/A"},{"$f":"IF(G10=\"N\",\"N/A\",IF(AND(H10=\"Opt 3\",I10=\"Y\",E10=\"N\"),$F10,0))","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!E11),\"\",'Materials List'!E11)","v":""},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},"N",null,null,null,{"$f":"IF(G11=\"N\",\"N/A\",IF(AND(H11=\"Opt 2\",I11=\"Y\",E11=\"N\"),$F11,0))","v":"N/A"},{"$f":"IF(G11=\"N\",\"N/A\",IF(AND(H11=\"Opt 3\",I11=\"Y\",E11=\"N\"),$F11,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!E12),\"\",'Materials List'!E12)","v":""},{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!E13),\"\",'Materials List'!E13)","v":""},{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!E14),\"\",'Materials List'!E14)","v":""},{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!E15),\"\",'Materials List'!E15)","v":""},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},"N",null,null,null,{"$f":"IF(G15=\"N\",\"N/A\",IF(AND(H15=\"Opt 2\",I15=\"Y\",E15=\"N\"),$F15,0))","v":"N/A"},{"$f":"IF(G15=\"N\",\"N/A\",IF(AND(H15=\"Opt 3\",I15=\"Y\",E15=\"N\"),$F15,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!E16),\"\",'Materials List'!E16)","v":""},{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!E17),\"\",'Materials List'!E17)","v":""},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},"N",null,null,null,{"$f":"IF(G17=\"N\",\"N/A\",IF(AND(H17=\"Opt 2\",I17=\"Y\",E17=\"N\"),$F17,0))","v":"N/A"},{"$f":"IF(G17=\"N\",\"N/A\",IF(AND(H17=\"Opt 3\",I17=\"Y\",E17=\"N\"),$F17,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!E18),\"\",'Materials List'!E18)","v":""},{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!E19),\"\",'Materials List'!E19)","v":""},{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!E20),\"\",'Materials List'!E20)","v":""},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},"N",null,null,null,{"$f":"IF(G20=\"N\",\"N/A\",IF(AND(H20=\"Opt 2\",I20=\"Y\",E20=\"N\"),$F20,0))","v":"N/A"},{"$f":"IF(G20=\"N\",\"N/A\",IF(AND(H20=\"Opt 3\",I20=\"Y\",E20=\"N\"),$F20,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!E21),\"\",'Materials List'!E21)","v":""},{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},"N",null,null,null,"N/A","N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!E22),\"\",'Materials List'!E22)","v":""},{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},"N",null,null,null,"N/A","N/A"]
["A","Option 1 compliance has been met for all eligible products",null,null,null,null,null,null,null,{"$f":"IF(COUNTIFS(J10:J22,\"<>Y\",G10:G22,\"Y\")>0,\"No\",\"Yes\")","v":"Yes"}]
[null,"Total eligible materials cost (Option 2 and Option 3 only)",null,null,null,null,null,null,null,null,{"$f":"SUM(K10:K22)","v":0},{"$f":"SUM(L10:L22)","v":0}]
[null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,null,null,null,null,null,{"$f":"Introduction!F18 - SUMIF(G10:G22,\"N\",F10:F22) - SUMIFS(F10:F22,G10:G22,\"Y\",E10:E22,\"Y\")","v":0}]
[null,"Percent materials meeting Option 2 (%)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K24/L25,0)","v":0}]
[null,"Percent materials meeting Option 3 (%)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(L24/L25,0)","v":0}]
[]
[]
[null,"Eligibility List- INLCUDED"]
[null,"Stone"]
[null,"Cut or processed stone"]
[null,"Aggregate/gravel"]
[null,"Sand (if used as a base course material)"]
[null,"Other materials or base course layers"]
[null,"Wood - Natural Lumber"]
[null,"Wood - Manufactured/compressed wood product"]
[null,"Non-wood decking, railing, fencing, trellises, or lattice"]
[null,"Pipe, hose, or irrigation equipment"]
[null,"Conduit, wiring, and electrical equipment"]
[null,"Lighting"]
[null,"Membrane, liner or geotextile"]
[null,"Fabric or canvas"]
[null,"Extruded, spray or board foams"]
[null,"Concrete"]
[null,"Brick or masonry unit"]
[null,"Sand (for purposes other than soil amendment or base course material)"]
[null,"Paint or coating"]
[null,"Adhesive, sealant, elastomer, water proofing, weather stripping, expansion joint filling or flashing"]
[null,"Synthetic surfacing materials and associated products (e.g. crumb rubber, artificial turf, etc.)"]

{"sheet":"C5.10","index":9,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,1,3,10],[26,1,26,9],[22,1,22,7],[23,1,23,8],[7,10,8,10],[7,7,8,7],[7,6,8,6],[7,8,8,8],[7,9,8,9],[6,1,6,10],[7,5,8,5],[7,1,7,4],[24,1,24,9],[25,1,25,9]]}
[]
[null,"SITES® v2 Materials Worksheet"]
[]
[null,"C5.10: SUPPORT SUSTAINABILITY IN PLANT PRODUCTION"]
[]
[null,"INSTRUCTIONS:"]
[null,"1. Only plants, sod, and seed are included in this credit. If any materials supplier provides publically available information meeting the requirements of this credit no letter needs to be submitted, but the project should still choose \"Y\" in the \"Supporting Documentation\" and \"Option 1 Letter Sent\" Columns under this credit."]
[null,"MATERIALS IDENTIFICATION\n(from Materials List tab)",null,null,null,"Product type is eligible for credit","Option","Supporting Documentation","Option 1 Letter Sent (Y or N)","Total Cost of \nOption 2\nMaterials","Total Cost of \nOption 3\nMaterials"]
[null,"Description of Material","Manufacturer or \nSupplier Name","Material/Product\nType","Total Cost of Material"]
[{"$f":"IF(B10>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B10),\"\",'Materials List'!B10)","v":""},{"$f":"IF(ISBLANK('Materials List'!C10),\"\",'Materials List'!C10)","v":""},{"$f":"IF(ISBLANK('Materials List'!D10),\"\",'Materials List'!D10)","v":""},{"$f":"IF(ISBLANK('Materials List'!H10),\"\",'Materials List'!H10)","v":0},{"$f":"IF(D10=\"\",\"N\",IF(COUNTIF($B$31:$B$33,D10),\"Y\",\"N\"))","v":"N"},null,null,null,{"$f":"IF(F10=\"N\",\"N/A\",IF(AND(G10=\"Opt 2\",H10=\"Y\"),$E10,0))","v":"N/A"},{"$f":"IF(F10=\"N\",\"N/A\",IF(AND(G10=\"Opt 3\",H10=\"Y\"),$E10,0))","v":"N/A"}]
[{"$f":"IF(B11>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B11),\"\",'Materials List'!B11)","v":""},{"$f":"IF(ISBLANK('Materials List'!C11),\"\",'Materials List'!C11)","v":""},{"$f":"IF(ISBLANK('Materials List'!D11),\"\",'Materials List'!D11)","v":""},{"$f":"IF(ISBLANK('Materials List'!H11),\"\",'Materials List'!H11)","v":0},"N",null,null,null,{"$f":"IF(F11=\"N\",\"N/A\",IF(AND(G11=\"Opt 2\",H11=\"Y\"),$E11,0))","v":"N/A"},{"$f":"IF(F11=\"N\",\"N/A\",IF(AND(G11=\"Opt 3\",H11=\"Y\"),$E11,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B12),\"\",'Materials List'!B12)","v":""},{"$f":"IF(ISBLANK('Materials List'!C12),\"\",'Materials List'!C12)","v":""},{"$f":"IF(ISBLANK('Materials List'!D12),\"\",'Materials List'!D12)","v":""},{"$f":"IF(ISBLANK('Materials List'!H12),\"\",'Materials List'!H12)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B13),\"\",'Materials List'!B13)","v":""},{"$f":"IF(ISBLANK('Materials List'!C13),\"\",'Materials List'!C13)","v":""},{"$f":"IF(ISBLANK('Materials List'!D13),\"\",'Materials List'!D13)","v":""},{"$f":"IF(ISBLANK('Materials List'!H13),\"\",'Materials List'!H13)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B14),\"\",'Materials List'!B14)","v":""},{"$f":"IF(ISBLANK('Materials List'!C14),\"\",'Materials List'!C14)","v":""},{"$f":"IF(ISBLANK('Materials List'!D14),\"\",'Materials List'!D14)","v":""},{"$f":"IF(ISBLANK('Materials List'!H14),\"\",'Materials List'!H14)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B15>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B15),\"\",'Materials List'!B15)","v":""},{"$f":"IF(ISBLANK('Materials List'!C15),\"\",'Materials List'!C15)","v":""},{"$f":"IF(ISBLANK('Materials List'!D15),\"\",'Materials List'!D15)","v":""},{"$f":"IF(ISBLANK('Materials List'!H15),\"\",'Materials List'!H15)","v":0},"N",null,null,null,{"$f":"IF(F15=\"N\",\"N/A\",IF(AND(G15=\"Opt 2\",H15=\"Y\"),$E15,0))","v":"N/A"},{"$f":"IF(F15=\"N\",\"N/A\",IF(AND(G15=\"Opt 3\",H15=\"Y\"),$E15,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B16),\"\",'Materials List'!B16)","v":""},{"$f":"IF(ISBLANK('Materials List'!C16),\"\",'Materials List'!C16)","v":""},{"$f":"IF(ISBLANK('Materials List'!D16),\"\",'Materials List'!D16)","v":""},{"$f":"IF(ISBLANK('Materials List'!H16),\"\",'Materials List'!H16)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B17>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B17),\"\",'Materials List'!B17)","v":""},{"$f":"IF(ISBLANK('Materials List'!C17),\"\",'Materials List'!C17)","v":""},{"$f":"IF(ISBLANK('Materials List'!D17),\"\",'Materials List'!D17)","v":""},{"$f":"IF(ISBLANK('Materials List'!H17),\"\",'Materials List'!H17)","v":0},"N",null,null,null,{"$f":"IF(F17=\"N\",\"N/A\",IF(AND(G17=\"Opt 2\",H17=\"Y\"),$E17,0))","v":"N/A"},{"$f":"IF(F17=\"N\",\"N/A\",IF(AND(G17=\"Opt 3\",H17=\"Y\"),$E17,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B18),\"\",'Materials List'!B18)","v":""},{"$f":"IF(ISBLANK('Materials List'!C18),\"\",'Materials List'!C18)","v":""},{"$f":"IF(ISBLANK('Materials List'!D18),\"\",'Materials List'!D18)","v":""},{"$f":"IF(ISBLANK('Materials List'!H18),\"\",'Materials List'!H18)","v":0},"N",null,null,null,"N/A","N/A"]
[0,{"$f":"IF(ISBLANK('Materials List'!B19),\"\",'Materials List'!B19)","v":""},{"$f":"IF(ISBLANK('Materials List'!C19),\"\",'Materials List'!C19)","v":""},{"$f":"IF(ISBLANK('Materials List'!D19),\"\",'Materials List'!D19)","v":""},{"$f":"IF(ISBLANK('Materials List'!H19),\"\",'Materials List'!H19)","v":0},"N",null,null,null,"N/A","N/A"]
[{"$f":"IF(B20>=0,0,0)","v":0},{"$f":"IF(ISBLANK('Materials List'!B20),\"\",'Materials List'!B20)","v":""},{"$f":"IF(ISBLANK('Materials List'!C20),\"\",'Materials List'!C20)","v":""},{"$f":"IF(ISBLANK('Materials List'!D20),\"\",'Materials List'!D20)","v":""},{"$f":"IF(ISBLANK('Materials List'!H20),\"\",'Materials List'!H20)","v":0},"N",null,null,null,{"$f":"IF(F20=\"N\",\"N/A\",IF(AND(G20=\"Opt 2\",H20=\"Y\"),$E20,0))","v":"N/A"},{"$f":"IF(F20=\"N\",\"N/A\",IF(AND(G20=\"Opt 3\",H20=\"Y\"),$E20,0))","v":"N/A"}]
[0,{"$f":"IF(ISBLANK('Materials List'!B21),\"\",'Materials List'!B21)","v":""},{"$f":"IF(ISBLANK('Materials List'!C21),\"\",'Materials List'!C21)","v":""},{"$f":"IF(ISBLANK('Materials List'!D21),\"\",'Materials List'!D21)","v":""},{"$f":"IF(ISBLANK('Materials List'!H21),\"\",'Materials List'!H21)","v":0},"N",null,null,null,"N/A","N/A"]
[null,{"$f":"IF(ISBLANK('Materials List'!B22),\"\",'Materials List'!B22)","v":""},{"$f":"IF(ISBLANK('Materials List'!C22),\"\",'Materials List'!C22)","v":""},{"$f":"IF(ISBLANK('Materials List'!D22),\"\",'Materials List'!D22)","v":""},{"$f":"IF(ISBLANK('Materials List'!H22),\"\",'Materials List'!H22)","v":0},"N",null,null,null,"N/A","N/A"]
["A","Option 1 compliance has been met for all eligible products",null,null,null,null,null,null,{"$f":"IF(COUNTIFS(I10:I22,\"<>Y\",F10:F22,\"Y\")>0,\"No\",\"Yes\")","v":"Yes"}]
[null,"Total eligible materials cost (Option 2 and Option 3 only)",null,null,null,null,null,null,null,{"$f":"SUM(J10:J22)","v":0},{"$f":"SUM(K10:K22)","v":0}]
[null,"Total eligible materials cost",null,null,null,null,null,null,null,null,{"$f":"SUMIF(F10:F22,\"Y\",E10:E22)","v":0}]
[null,"Percent materials meeting Option 2 (%)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J24/K25,0)","v":0}]
[null,"Percent materials meeting Option 3 (%)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(K24/K25,0)","v":0}]
[]
[]
[null,"Eligibility List"]
[null,"Plant"]
[null,"Seed"]
[null,"Sod"]

{"sheet":"Summary","index":10,"n_rows":146,"n_cols":8,"rows_kept":146,"cut":false,"hidden":false,"merged":[[121,2,121,7],[145,2,145,7],[19,2,19,7],[29,2,29,7],[39,2,39,7],[49,2,49,7],[73,2,73,7],[97,2,97,7]]}
[]
[]
[null,null,"SUMMARY"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tabs."]
[]
[]
[null,null,"P5.1:ELIMINATE THE USE OF WOOD FROM THREATENED TREE SPECIES"]
[]
[null,null,"All products meet prerequisite?",null,null,null,null,{"$f":"P5.1!J23","v":"N/A"}]
[]
[]
[null,null,"C5.3: DESIGN FOR ADAPTABILITY AND REASSEMBLY"]
[]
[null,null,"Total reusable materials cost",null,null,null,null,{"$f":"C5.3!H23","v":0}]
[]
[null,null,"Total materials cost (less ineligible product cost)",null,null,null,null,{"$f":"C5.3!H24","v":0}]
[]
[null,null,"Percent of reusable components (%)",null,null,null,null,{"$f":"C5.3!H25","v":0}]
[]
[null,null,"Must be at least 30% for 3 points, and 60% for 4 points (excluding plants, rocks, and soils)"]
[]
[null,null,"C5.4: SALVAGED MATERIALS"]
[]
[null,null,"Total salvaged materials cost",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!I23","v":0}]
[]
[null,null,"Total materials cost (less ineligible product and recycled materials cost)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!I24","v":0}]
[]
[null,null,"Percent salvaged materials (%)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!I25","v":0}]
[]
[null,null,"Must be at least 10% for 3 points, and 20% for 4 points (excluding soils)"]
[]
[null,null,"C5.5: RECYCLED CONTENT"]
[]
[null,null,"Total recycled materials cost",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!N23","v":0}]
[]
[null,null,"Total materials cost (less ineligible product and salvaged materials cost)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!N24","v":0}]
[]
[null,null,"Percent recycled materials (%)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!N25","v":0}]
[]
[null,null,"Must be at least 20% for 3 points, and 40% for 4 points (excluding plants and soils)"]
[]
[null,null,"C5.6: REGIONAL"]
[]
[null,null,"Total regional materials cost",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!T23","v":0}]
[]
[null,null,"Total materials cost (from Introduction tab)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!T24","v":0}]
[]
[null,null,"Percent regional materials (%)",null,null,null,null,{"$f":"'C5.4, C5.5, C5.6'!T25","v":0}]
[]
[null,null,"Must be at least 30% for 3 points, and 60% for 4 points, and 90% for 5 points (total materials cost)"]
[]
[null,null,"C5.7: RESPONSIBLE EXTRACTION"]
[]
[null,null,"Option 1"]
[]
[null,null,"Option 1 compliance has been met for all products",null,null,null,null,{"$f":"C5.7!M23","v":"Yes"}]
[]
[null,null,"Option 2"]
[]
[null,null,"Total Option 2 materials cost",null,null,null,null,{"$f":"C5.7!N24","v":0}]
[]
[null,null,"Total materials cost (less ineligible product, salvaged, and recycled materials cost)",null,null,null,null,{"$f":"C5.7!O25","v":0}]
[]
[null,null,"Percent materials meeting Option 2 (%)",null,null,null,null,{"$f":"C5.7!O26","v":0}]
[]
[null,null,"Option 3"]
[]
[null,null,"Total Option 3 materials cost",null,null,null,null,{"$f":"C5.7!O24","v":0}]
[]
[null,null,"Total materials cost (less ineligible product, salvaged, and recycled materials cost)",null,null,null,null,{"$f":"C5.7!O25","v":0}]
[]
[null,null,"Percent materials meeting Option 3 (%)",null,null,null,null,{"$f":"C5.7!O27","v":0}]
[]
[null,null,"Option 1: 100% for 1 point, Option 2: 5% for 3 points, Option 3: 5% for 5 points (excluding recycled and salvaged materials cost) "]
[]
[null,null,"C5.8: SUPPORT TRANSPARENCY AND SAFER CHEMISTRY"]
[]
[null,null,"Option 1"]
[]
[null,null,"Option 1 compliance has been met for all products",null,null,null,null,{"$f":"C5.8!J23","v":"Yes"}]
[]
[null,null,"Option 2"]
[]
[null,null,"Total Option 2 materials cost",null,null,null,null,{"$f":"C5.8!K24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,{"$f":"C5.8!L25","v":0}]
[]
[null,null,"Percent materials meeting Option 2 (%)",null,null,null,null,{"$f":"C5.8!L26","v":0}]
[]
[null,null,"Option 3"]
[]
[null,null,"Total Option 3 materials cost",null,null,null,null,{"$f":"C5.8!L24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,{"$f":"C5.8!L25","v":0}]
[]
[null,null,"Percent materials meeting Option 3 (%)",null,null,null,null,{"$f":"C5.8!L27","v":0}]
[]
[null,null,"Option 1: 100% for 1 point, Option 2: 5% for 3 points, Option 3: 5% for 5 points (excluding salvaged materials cost)"]
[]
[null,null,"C5.9: SUPPORT SUSTAINABILTY IN MATERIALS MANUFACTURING"]
[]
[null,null,"Option 1"]
[]
[null,null,"Option 1 compliance has been met for all products",null,null,null,null,{"$f":"C5.9!J23","v":"Yes"}]
[]
[null,null,"Option 2"]
[]
[null,null,"Total Option 2 materials cost",null,null,null,null,{"$f":"C5.9!K24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,{"$f":"C5.9!L25","v":0}]
[]
[null,null,"Percent materials meeting Option 2 (%)",null,null,null,null,{"$f":"C5.9!L26","v":0}]
[]
[null,null,"Option 3"]
[]
[null,null,"Total Option 3 materials cost",null,null,null,null,{"$f":"C5.9!L24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products and salvaged/reused materials cost)",null,null,null,null,{"$f":"C5.9!L25","v":0}]
[]
[null,null,"Percent materials meeting Option 3 (%)",null,null,null,null,{"$f":"C5.9!L27","v":0}]
[]
[null,null,"Option 1: 100% for 1 point, Option 2: 25% for 3 points, Option 3: 25% for 5 points (excluding rocks, plants, soils and salvaged materials cost)"]
[]
[null,null,"C5.10: SUPPORT SUSTAINABILITY IN PLANT PRODUCTION"]
[]
[null,null,"Option 1"]
[]
[null,null,"Option 1 compliance has been met for all products",null,null,null,null,{"$f":"C5.10!I23","v":"Yes"}]
[]
[null,null,"Option 2"]
[]
[null,null,"Total Option 2 materials cost",null,null,null,null,{"$f":"C5.10!J24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products cost)",null,null,null,null,{"$f":"C5.10!K25","v":0}]
[]
[null,null,"Percent materials meeting Option 2 (%)",null,null,null,null,{"$f":"C5.10!K26","v":0}]
[]
[null,null,"Option 3"]
[]
[null,null,"Total Option 3 materials cost",null,null,null,null,{"$f":"C5.10!K24","v":0}]
[]
[null,null,"Total materials cost (less ineligible products cost)",null,null,null,null,{"$f":"C5.10!K25","v":0}]
[]
[null,null,"Percent materials meeting Option 3 (%)",null,null,null,null,{"$f":"C5.10!K27","v":0}]
[]
[null,null,"Option 1: 100% for 1 point, Option 2: 80% for 3 points, Option 3: 80% for 5 points (only including plants, sod, and seed materials cost)"]