{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Materials","Environ. Product Declarations","Sourcing of Raw Materials","Material Ingredients","Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":21,"comments":5,"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":"Instructions","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[48,4,48,6],[2,3,4,3],[33,4,33,6],[68,2,69,5],[61,2,62,5],[63,2,64,5],[66,2,67,5],[37,4,37,6],[41,4,41,6],[45,4,45,6],[2,4,2,6],[36,4,36,6],[40,4,40,6],[44,4,44,6],[6,4,6,6],[10,4,10,6]]}
[]
[]
[null,null,null,null,"Building Product Disclosure and Optimization Calculator\nLEED v4 MR Credit Building Product Disclosure and Optimization - Environmental Product Declarations, MR Credit Building Product Disclosure and Optimization - Sourcing of Raw Materials, and MR Credit Building Product Disclosure and Optimization -  Material Ingredients "]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros"]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2."]
[null,null,null,null,"Unit of measurement",null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"The total materials cost is based on",null,"Actual cost"]
[]
[null,null,null,null,"Actual materials cost (required for ID+C projects)"]
[]
[null,null,null,null,"Actual materials cost, excluding labor and equipment"]
[]
[null,null,null,null,"OR"]
[]
[null,null,null,null,"Default materials cost"]
[]
[null,null,null,null,"Total construction costs for the LEED project",null,0]
[]
[null,null,null,null,"Total furniture cost (Optional)",null,0]
[]
[null,null,null,null,"Total mechanical, electrical, and plumbing components (Optional)",null,0]
[]
[]
[null,null,null,null,"Total materials cost",null,{"$f":"IF(G14=\"Actual cost\",G18,((G24*0.45)+G26+G28))","v":0}]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Complete the Materials tab for all products and materials included in the following credits (as applicable):\n\nMR Credit Building Product Disclosure and Optimization - Environmental Product Declarations\nMR Credit Building Product Disclosure and Optimization - Sourcing of Raw Materials\nMR Credit Building Product Disclosure and Optimization - Material Ingredients"]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"For projects attempting MR Credit Building Product Disclosure and Optimization - Environmental Product Declarations"]
[null,null,null,null,"Complete the Environ. Product Declarations tab."]
[]
[]
[null,null,null,null,"For projects attempting MR Credit Building Product Disclosure and Optimization - Sourcing of Raw Materials"]
[null,null,null,null,"Complete the Sourcing of Raw Materials tab."]
[]
[]
[null,null,null,null,"For projects attempting MR Credit Building Product Disclosure and Optimization - Material Ingredients"]
[null,null,null,null,"Complete the Material Ingredients tab."]
[]
[null,null,null,null,"Step 6. "]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[null,null,null,null,null,null,null,null,null,"UOM"]
[null,null,null,null,null,null,null,"V03",null,{"$f":"IF(G10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,null,"Copyright © 2012",null,"1 = IP; 2 = SI"]
[null,null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,null,"All Rights Reserved"]

{"sheet":"Materials","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[20,1,20,5],[19,1,19,5],[4,1,5,6],[6,7,7,7],[6,8,7,8],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,5,7,5],[6,6,7,6],[6,4,7,4]]}
[]
[null,"Material Information"]
[]
[]
[null,"Enter product and material information for those included in MR Credit Building Product Disclosure and Optimization - Environmental Product Declarations, MR Credit Building Product Disclosure and Optimization -Sourcing of Raw Materials, and MR Credit Building Product Disclosure and Optimization - Material Ingredients. \n\nAll permanently installed building products contributing toward credit compliance are required to be included in all building product disclosure and optimization credits.  Optional products and materials, such as MEP, are not required to be included.  However, if they are, they will be included consistently across all cost-based Materials and Resources credits.\n\nProduct and materials cost includes all taxes and expenses to deliver the material to the project site incurred by the contractor but excludes any cost for labor and equipment required for installation after the material is delivered to the site.  Product and materials cost equals the cost per item multiplied by number of items purchased. The cost of salvaged, reused or reclaimed materials is either the actual cost paid or the replacement value, whichever is higher."]
[]
[null,"Material \nDescription","CSI Div \n(optional)","Is the material structure\nor enclosure?","Description \nof Material","Manufacturer \nName","Material Cost\n($)"]
[]
[{"$f":"IF(G9>=0,0,1)","v":0}]
[{"$f":"IF(G10>=0,0,1)","v":0}]
[0]
[0]
[0]
[0]
[{"$f":"IF(G15>=0,0,1)","v":0}]
[{"$f":"IF(G16>=0,0,1)","v":0}]
[{"$f":"IF(G17>=0,0,1)","v":0}]
[]
[]
["A","Total value of sustainable materials (unweighted)",null,null,null,null,{"$f":"SUM(G9:G19)","v":0}]
[null,"Total materials cost",null,null,null,null,{"$f":"Instructions!G31","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,"`"]

{"sheet":"Environ. Product Declarations","index":2,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6],[19,9,19,10],[6,2,7,2],[4,1,4,11],[6,9,7,9],[6,3,7,3],[6,5,7,5],[6,6,7,6],[5,9,5,11],[6,11,7,11],[5,1,5,3],[5,5,5,7],[6,1,7,1],[6,10,7,10],[6,7,7,7]]}
[]
[null,"Environmental Product Declarations"]
[]
[]
[null,"Complete all columns with applicable material data for the attempted options.  If the option is not attempted, leave the column blank.  "]
[null,"General Information\n(from Materials tab)",null,null,null,"Option 1 \nEnvironmental Product Declaration",null,null,null,"Option 2\nMulti-Attribute Optimization"]
[null,"Material \nDescription","Is the material structure\nor enclosure?","Material Cost",null,"EPD \nProgram \nOperator","EPD \nType","Weighted \nEPD \nValue \n(#)",null,"Third Party \nCertification Program","Does the entire product meet local criteria?","Total Sustainable Criteria Value with Location Valuation Factor\n($)"]
[]
[{"$f":"IF(D9>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B9),\"\",Materials!B9)","v":""},{"$f":"IF(ISBLANK(Materials!D9),\"\",Materials!D9)","v":""},{"$f":"IF(ISBLANK(Materials!G9),\"\",Materials!G9)","v":""},null,null,null,{"$f":"IF(G9=\"Product-specific Type III\",1,(IF(G9=\"Product-specific\",0.25,(IF(G9=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,{"$f":"IFERROR(IF(J9<>0,IF(K9=\"Yes\",D9*2,D9),0),0)","v":0}]
[{"$f":"IF(D10>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B10),\"\",Materials!B10)","v":""},{"$f":"IF(ISBLANK(Materials!D10),\"\",Materials!D10)","v":""},{"$f":"IF(ISBLANK(Materials!G10),\"\",Materials!G10)","v":""},null,null,null,{"$f":"IF(G10=\"Product-specific Type III\",1,(IF(G10=\"Product-specific\",0.25,(IF(G10=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,{"$f":"IFERROR(IF(J10<>0,IF(K10=\"Yes\",D10*2,D10),0),0)","v":0}]
[0,{"$f":"IF(ISBLANK(Materials!B11),\"\",Materials!B11)","v":""},{"$f":"IF(ISBLANK(Materials!D11),\"\",Materials!D11)","v":""},{"$f":"IF(ISBLANK(Materials!G11),\"\",Materials!G11)","v":""},null,null,null,"",null,null,null,0]
[0,{"$f":"IF(ISBLANK(Materials!B12),\"\",Materials!B12)","v":""},{"$f":"IF(ISBLANK(Materials!D12),\"\",Materials!D12)","v":""},{"$f":"IF(ISBLANK(Materials!G12),\"\",Materials!G12)","v":""},null,null,null,{"$f":"IF(G12=\"Product-specific Type III\",1,(IF(G12=\"Product-specific\",0.25,(IF(G12=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,0]
[0,{"$f":"IF(ISBLANK(Materials!B13),\"\",Materials!B13)","v":""},{"$f":"IF(ISBLANK(Materials!D13),\"\",Materials!D13)","v":""},{"$f":"IF(ISBLANK(Materials!G13),\"\",Materials!G13)","v":""},null,null,null,"",null,null,null,0]
[0,{"$f":"IF(ISBLANK(Materials!B14),\"\",Materials!B14)","v":""},{"$f":"IF(ISBLANK(Materials!D14),\"\",Materials!D14)","v":""},{"$f":"IF(ISBLANK(Materials!G14),\"\",Materials!G14)","v":""},null,null,null,"",null,null,null,0]
[{"$f":"IF(D15>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B15),\"\",Materials!B15)","v":""},{"$f":"IF(ISBLANK(Materials!D15),\"\",Materials!D15)","v":""},{"$f":"IF(ISBLANK(Materials!G15),\"\",Materials!G15)","v":""},null,null,null,{"$f":"IF(G15=\"Product-specific Type III\",1,(IF(G15=\"Product-specific\",0.25,(IF(G15=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,0]
[{"$f":"IF(D16>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B16),\"\",Materials!B16)","v":""},{"$f":"IF(ISBLANK(Materials!D16),\"\",Materials!D16)","v":""},{"$f":"IF(ISBLANK(Materials!G16),\"\",Materials!G16)","v":""},null,null,null,{"$f":"IF(G16=\"Product-specific Type III\",1,(IF(G16=\"Product-specific\",0.25,(IF(G16=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,{"$f":"IFERROR(IF(J16<>0,IF(K16=\"Yes\",D16*2,D16),0),0)","v":0}]
[{"$f":"IF(D17>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B17),\"\",Materials!B17)","v":""},{"$f":"IF(ISBLANK(Materials!D17),\"\",Materials!D17)","v":""},{"$f":"IF(ISBLANK(Materials!G17),\"\",Materials!G17)","v":""},null,null,null,{"$f":"IF(G17=\"Product-specific Type III\",1,(IF(G17=\"Product-specific\",0.25,(IF(G17=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,{"$f":"IFERROR(IF(J17<>0,IF(K17=\"Yes\",D17*2,D17),0),0)","v":0}]
[null,{"$f":"IF(ISBLANK(Materials!B18),\"\",Materials!B18)","v":""},{"$f":"IF(ISBLANK(Materials!D18),\"\",Materials!D18)","v":""},{"$f":"IF(ISBLANK(Materials!G18),\"\",Materials!G18)","v":""},null,null,null,{"$f":"IF(G18=\"Product-specific Type III\",1,(IF(G18=\"Product-specific\",0.25,(IF(G18=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,0]
[null,{"$f":"IF(ISBLANK(Materials!B19),\"\",Materials!B19)","v":""},{"$f":"IF(ISBLANK(Materials!D19),\"\",Materials!D19)","v":""},{"$f":"IF(ISBLANK(Materials!G19),\"\",Materials!G19)","v":""},null,null,null,{"$f":"IF(G19=\"Product-specific Type III\",1,(IF(G19=\"Product-specific\",0.25,(IF(G19=\"Industry-wide (generic)\",0.5,\"\")))))","v":""},null,null,null,0]
["A",null,null,null,null,"Weighted number of products with EPD",null,{"$f":"ROUNDDOWN(SUM(H9:H19),0)","v":0},null,"Total sustainable criteria value with location valuation factor",null,{"$f":"SUM(L9:L19)","v":0}]

{"sheet":"Sourcing of Raw Materials","index":3,"n_rows":20,"n_cols":24,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,21,19,22],[6,23,7,23],[6,21,7,21],[6,22,7,22],[19,1,19,3],[5,1,5,3],[6,1,7,1],[6,3,7,3],[19,17,19,18],[19,8,19,9],[6,17,6,19],[6,13,6,14],[6,15,6,16],[6,2,7,2],[5,5,5,6],[6,5,7,5],[6,6,7,6],[6,8,6,10],[6,11,6,12],[5,8,5,9]]}
[]
[null,"Sourcing of Raw Materials"]
[]
[]
[null,"Fill in all columns with applicable material data for all attempted options.  If the option is not attempted, leave the column blank. "]
[null,"General Information\n(from Materials tab)",null,null,null,"Option 1\nRaw Material Source and Extraction Reporting",null,null,"Option 2 \nLeadership Extraction Practices"]
[null,"Material \nDescription","Is the material structure\nor enclosure?","Material Cost\n($)",null,"Corporate Sustainability \nReport Type","Weighted\nSustainable \nCriteria Value\n(#)",null,"Extended Producer Responsibility",null,null,"Bio-based Materials",null,"Wood Products",null,"Materials Reuse",null,"Recycled Content",null,null,null,"Does the entire product meet local criteria?","Sustainable \nCriteria Value\nSubtotal\n($)","Total Sustainable Criteria Value with Location Valuation Factor\n($)"]
[null,null,null,null,null,null,null,null,"Extended Producer Responsibility\nClosed Loop or \nTake Back Program Name","Percent Extended Producer Responsibility\n(%)","Sustainable \nCriteria Value\n($)","Percent Meeting Sustainable Agriculture Network Standard (%)","Sustainable \nCriteria Value\n($)","Percent \nFSC\nCertified\n(%)","Sustainable \nCriteria Value\n($)","Percent \nSalvaged \nor Reused\n(%)","Sustainable \nCriteria Value\n($)","Percent \nPost-Consumer\n(%)","Percent\nPre-Consumer\n(%)","Sustainable \nCriteria Value\n($)"]
[{"$f":"IF(D9>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B9),\"\",Materials!B9)","v":""},{"$f":"IF(ISBLANK(Materials!D9),\"\",Materials!D9)","v":""},{"$f":"IF(ISBLANK(Materials!G9),\"\",Materials!G9)","v":""},null,null,{"$f":"IF(F9=\"Manufacturer Declared\",0.5,IF(F9=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I9>0,(D9*J9)*0.5,0)","v":0},null,{"$f":"IFERROR(L9*D9,0)","v":0},null,{"$f":"IFERROR(N9*D9,0)","v":0},null,{"$f":"IFERROR(D9*P9,0)","v":0},null,null,{"$f":"IFERROR((R9*D9)+((S9*D9)/2),0)","v":0},null,null,{"$f":"IF(SUM(K9,M9,O9,Q9,T9)>D9,D9,SUM(K9,M9,O9,Q9,T9))","v":0},{"$f":"IF(V9=\"Yes\",W9*2,W9)","v":0}]
[{"$f":"IF(D10>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B10),\"\",Materials!B10)","v":""},{"$f":"IF(ISBLANK(Materials!D10),\"\",Materials!D10)","v":""},{"$f":"IF(ISBLANK(Materials!G10),\"\",Materials!G10)","v":""},null,null,{"$f":"IF(F10=\"Manufacturer Declared\",0.5,IF(F10=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I10>0,(D10*J10)*0.5,0)","v":0},null,{"$f":"IFERROR(L10*D10,0)","v":0},null,{"$f":"IFERROR(N10*D10,0)","v":0},null,{"$f":"IFERROR(D10*P10,0)","v":0},null,null,{"$f":"IFERROR((R10*D10)+((S10*D10)/2),0)","v":0},null,null,{"$f":"IF(SUM(K10,M10,O10,Q10,T10)>D10,D10,SUM(K10,M10,O10,Q10,T10))","v":0},{"$f":"IF(V10=\"Yes\",W10*2,W10)","v":0}]
[0,{"$f":"IF(ISBLANK(Materials!B11),\"\",Materials!B11)","v":""},{"$f":"IF(ISBLANK(Materials!D11),\"\",Materials!D11)","v":""},{"$f":"IF(ISBLANK(Materials!G11),\"\",Materials!G11)","v":""},null,null,"",null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0,0]
[0,{"$f":"IF(ISBLANK(Materials!B12),\"\",Materials!B12)","v":""},{"$f":"IF(ISBLANK(Materials!D12),\"\",Materials!D12)","v":""},{"$f":"IF(ISBLANK(Materials!G12),\"\",Materials!G12)","v":""},null,null,{"$f":"IF(F12=\"Manufacturer Declared\",0.5,IF(F12=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I12>0,(D12*J12)*0.5,0)","v":0},null,{"$f":"IFERROR(L12*D12,0)","v":0},null,{"$f":"IFERROR(N12*D12,0)","v":0},null,{"$f":"IFERROR(D12*P12,0)","v":0},null,null,{"$f":"IFERROR((R12*D12)+((S12*D12)/2),0)","v":0},null,null,{"$f":"IF(SUM(K12,M12,O12,Q12,T12)>D12,D12,SUM(K12,M12,O12,Q12,T12))","v":0},0]
[0,{"$f":"IF(ISBLANK(Materials!B13),\"\",Materials!B13)","v":""},{"$f":"IF(ISBLANK(Materials!D13),\"\",Materials!D13)","v":""},{"$f":"IF(ISBLANK(Materials!G13),\"\",Materials!G13)","v":""},null,null,"",null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0,0]
[0,{"$f":"IF(ISBLANK(Materials!B14),\"\",Materials!B14)","v":""},{"$f":"IF(ISBLANK(Materials!D14),\"\",Materials!D14)","v":""},{"$f":"IF(ISBLANK(Materials!G14),\"\",Materials!G14)","v":""},null,null,"",null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0,0]
[{"$f":"IF(D15>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B15),\"\",Materials!B15)","v":""},{"$f":"IF(ISBLANK(Materials!D15),\"\",Materials!D15)","v":""},{"$f":"IF(ISBLANK(Materials!G15),\"\",Materials!G15)","v":""},null,null,{"$f":"IF(F15=\"Manufacturer Declared\",0.5,IF(F15=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I15>0,(D15*J15)*0.5,0)","v":0},null,{"$f":"IFERROR(L15*D15,0)","v":0},null,{"$f":"IFERROR(N15*D15,0)","v":0},null,{"$f":"IFERROR(D15*P15,0)","v":0},null,null,{"$f":"IFERROR((R15*D15)+((S15*D15)/2),0)","v":0},null,null,{"$f":"IF(SUM(K15,M15,O15,Q15,T15)>D15,D15,SUM(K15,M15,O15,Q15,T15))","v":0},0]
[{"$f":"IF(D16>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B16),\"\",Materials!B16)","v":""},{"$f":"IF(ISBLANK(Materials!D16),\"\",Materials!D16)","v":""},{"$f":"IF(ISBLANK(Materials!G16),\"\",Materials!G16)","v":""},null,null,{"$f":"IF(F16=\"Manufacturer Declared\",0.5,IF(F16=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I16>0,(D16*J16)*0.5,0)","v":0},null,{"$f":"IFERROR(L16*D16,0)","v":0},null,{"$f":"IFERROR(N16*D16,0)","v":0},null,{"$f":"IFERROR(D16*P16,0)","v":0},null,null,{"$f":"IFERROR((R16*D16)+((S16*D16)/2),0)","v":0},null,null,{"$f":"IF(SUM(K16,M16,O16,Q16,T16)>D16,D16,SUM(K16,M16,O16,Q16,T16))","v":0},{"$f":"IF(V16=\"Yes\",W16*2,W16)","v":0}]
[{"$f":"IF(D17>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B17),\"\",Materials!B17)","v":""},{"$f":"IF(ISBLANK(Materials!D17),\"\",Materials!D17)","v":""},{"$f":"IF(ISBLANK(Materials!G17),\"\",Materials!G17)","v":""},null,null,{"$f":"IF(F17=\"Manufacturer Declared\",0.5,IF(F17=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I17>0,(D17*J17)*0.5,0)","v":0},null,{"$f":"IFERROR(L17*D17,0)","v":0},null,{"$f":"IFERROR(N17*D17,0)","v":0},null,{"$f":"IFERROR(D17*P17,0)","v":0},null,null,{"$f":"IFERROR((R17*D17)+((S17*D17)/2),0)","v":0},null,null,{"$f":"IF(SUM(K17,M17,O17,Q17,T17)>D17,D17,SUM(K17,M17,O17,Q17,T17))","v":0},{"$f":"IF(V17=\"Yes\",W17*2,W17)","v":0}]
[null,{"$f":"IF(ISBLANK(Materials!B18),\"\",Materials!B18)","v":""},{"$f":"IF(ISBLANK(Materials!D18),\"\",Materials!D18)","v":""},{"$f":"IF(ISBLANK(Materials!G18),\"\",Materials!G18)","v":""},null,null,{"$f":"IF(F18=\"Manufacturer Declared\",0.5,IF(F18=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I18>0,(D18*J18)*0.5,0)","v":0},null,{"$f":"IFERROR(L18*D18,0)","v":0},null,{"$f":"IFERROR(N18*D18,0)","v":0},null,{"$f":"IFERROR(D18*P18,0)","v":0},null,null,{"$f":"IFERROR((R18*D18)+((S18*D18)/2),0)","v":0},null,null,{"$f":"IF(SUM(K18,M18,O18,Q18,T18)>D18,D18,SUM(K18,M18,O18,Q18,T18))","v":0},0]
[null,{"$f":"IF(ISBLANK(Materials!B19),\"\",Materials!B19)","v":""},{"$f":"IF(ISBLANK(Materials!D19),\"\",Materials!D19)","v":""},{"$f":"IF(ISBLANK(Materials!G19),\"\",Materials!G19)","v":""},null,null,{"$f":"IF(F19=\"Manufacturer Declared\",0.5,IF(F19=\"Third Party Verified\",1,\"\"))","v":""},null,null,null,{"$f":"IF(I19>0,(D19*J19)*0.5,0)","v":0},null,{"$f":"IFERROR(L19*D19,0)","v":0},null,{"$f":"IFERROR(N19*D19,0)","v":0},null,{"$f":"IFERROR(D19*P19,0)","v":0},null,null,{"$f":"IFERROR((R19*D19)+((S19*D19)/2),0)","v":0},null,null,{"$f":"IF(SUM(K19,M19,O19,Q19,T19)>D19,D19,SUM(K19,M19,O19,Q19,T19))","v":0},0]
["A",null,null,null,null,"Total value",{"$f":"ROUNDDOWN(SUM(G9:G19),0)","v":0},null,"Total value",null,{"$f":"SUM(K9:K19)","v":0},"Total value",{"$f":"SUM(M9:M19)","v":0},"Total value",{"$f":"SUM(O9:O19)","v":0},"Total value",{"$f":"SUM(Q9:Q19)","v":0},"Total value",null,{"$f":"SUM(T9:T19)","v":0},null,"Total sustainable criteria value with location valuation factor",null,{"$f":"SUM(X9:X19)","v":0}]

{"sheet":"Material Ingredients","index":4,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,7,19,9],[6,3,7,3],[20,7,20,10],[6,1,7,1],[5,1,5,3],[6,7,7,7],[6,2,7,2],[6,9,7,9],[6,8,7,8],[5,7,5,10],[6,10,7,10],[6,5,7,5]]}
[]
[null,"Material Ingredients"]
[]
[]
[null,"Fill in all columns with applicable material data for all attempted options.  If the option is not attempted, leave the column blank.  "]
[null,"General Information\n(from Materials tab)",null,null,null,"Option 1\nMaterial Ingredient Reporting",null,"Option 2\nMaterial Ingredient Optimization"]
[null,"Material \nDescription","Is the material structure\nor enclosure?","Material Cost\n($)",null,"Type of Reporting",null,"Certification \nProgram","Does the entire product meet local criteria?","Sustainable \nCriteria Value Subtotal \n($)","Total Sustainable Criteria Value with Location Valuation Factor\n($)"]
[]
[{"$f":"IF(D9>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B9),\"\",Materials!B9)","v":""},{"$f":"IF(ISBLANK(Materials!D9),\"\",Materials!D9)","v":""},{"$f":"IF(ISBLANK(Materials!G9),\"\",Materials!G9)","v":""},null,null,null,null,null,{"$f":"IF(OR(H9=\"GreenScreen v1.2 Assessment\",H9=\"Cradle to Cradle v2 Platinum\",H9=\"Cradle to Cradle v3 Gold\",H9=\"Cradle to Cradle v3 Platinum\"),D9*1.5,IF(OR(H9=\"GreenScreen v1.2 List Translator\",H9=\"REACH\",H9=\"Cradle to Cradle v2 Gold\",H9=\"Cradle to Cradle v3 silver\"),D9,0))","v":0},{"$f":"IF(I9=\"Yes\",J9*2,J9)","v":0}]
[{"$f":"IF(D10>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B10),\"\",Materials!B10)","v":""},{"$f":"IF(ISBLANK(Materials!D10),\"\",Materials!D10)","v":""},{"$f":"IF(ISBLANK(Materials!G10),\"\",Materials!G10)","v":""},null,null,null,null,null,{"$f":"IF(OR(H10=\"GreenScreen v1.2 Assessment\",H10=\"Cradle to Cradle v2 Platinum\",H10=\"Cradle to Cradle v3 Gold\",H10=\"Cradle to Cradle v3 Platinum\"),D10*1.5,IF(OR(H10=\"GreenScreen v1.2 List Translator\",H10=\"REACH\",H10=\"Cradle to Cradle v2 Gold\",H10=\"Cradle to Cradle v3 silver\"),D10,0))","v":0},{"$f":"IF(I10=\"Yes\",J10*2,J10)","v":0}]
[0,{"$f":"IF(ISBLANK(Materials!B11),\"\",Materials!B11)","v":""},{"$f":"IF(ISBLANK(Materials!D11),\"\",Materials!D11)","v":""},{"$f":"IF(ISBLANK(Materials!G11),\"\",Materials!G11)","v":""},null,null,null,null,null,0,0]
[0,{"$f":"IF(ISBLANK(Materials!B12),\"\",Materials!B12)","v":""},{"$f":"IF(ISBLANK(Materials!D12),\"\",Materials!D12)","v":""},{"$f":"IF(ISBLANK(Materials!G12),\"\",Materials!G12)","v":""},null,null,null,null,null,{"$f":"IF(OR(H12=\"GreenScreen v1.2 Assessment\",H12=\"Cradle to Cradle v2 Platinum\",H12=\"Cradle to Cradle v3 Gold\",H12=\"Cradle to Cradle v3 Platinum\"),D12*1.5,IF(OR(H12=\"GreenScreen v1.2 List Translator\",H12=\"REACH\",H12=\"Cradle to Cradle v2 Gold\",H12=\"Cradle to Cradle v3 silver\"),D12,0))","v":0},0]
[0,{"$f":"IF(ISBLANK(Materials!B13),\"\",Materials!B13)","v":""},{"$f":"IF(ISBLANK(Materials!D13),\"\",Materials!D13)","v":""},{"$f":"IF(ISBLANK(Materials!G13),\"\",Materials!G13)","v":""},null,null,null,null,null,0,0]
[0,{"$f":"IF(ISBLANK(Materials!B14),\"\",Materials!B14)","v":""},{"$f":"IF(ISBLANK(Materials!D14),\"\",Materials!D14)","v":""},{"$f":"IF(ISBLANK(Materials!G14),\"\",Materials!G14)","v":""},null,null,null,null,null,0,0]
[{"$f":"IF(D15>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B15),\"\",Materials!B15)","v":""},{"$f":"IF(ISBLANK(Materials!D15),\"\",Materials!D15)","v":""},{"$f":"IF(ISBLANK(Materials!G15),\"\",Materials!G15)","v":""},null,null,null,null,null,{"$f":"IF(OR(H15=\"GreenScreen v1.2 Assessment\",H15=\"Cradle to Cradle v2 Platinum\",H15=\"Cradle to Cradle v3 Gold\",H15=\"Cradle to Cradle v3 Platinum\"),D15*1.5,IF(OR(H15=\"GreenScreen v1.2 List Translator\",H15=\"REACH\",H15=\"Cradle to Cradle v2 Gold\",H15=\"Cradle to Cradle v3 silver\"),D15,0))","v":0},0]
[{"$f":"IF(D16>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B16),\"\",Materials!B16)","v":""},{"$f":"IF(ISBLANK(Materials!D16),\"\",Materials!D16)","v":""},{"$f":"IF(ISBLANK(Materials!G16),\"\",Materials!G16)","v":""},null,null,null,null,null,{"$f":"IF(OR(H16=\"GreenScreen v1.2 Assessment\",H16=\"Cradle to Cradle v2 Platinum\",H16=\"Cradle to Cradle v3 Gold\",H16=\"Cradle to Cradle v3 Platinum\"),D16*1.5,IF(OR(H16=\"GreenScreen v1.2 List Translator\",H16=\"REACH\",H16=\"Cradle to Cradle v2 Gold\",H16=\"Cradle to Cradle v3 silver\"),D16,0))","v":0},{"$f":"IF(I16=\"Yes\",J16*2,J16)","v":0}]
[{"$f":"IF(D17>=0,0,1)","v":0},{"$f":"IF(ISBLANK(Materials!B17),\"\",Materials!B17)","v":""},{"$f":"IF(ISBLANK(Materials!D17),\"\",Materials!D17)","v":""},{"$f":"IF(ISBLANK(Materials!G17),\"\",Materials!G17)","v":""},null,null,null,null,null,{"$f":"IF(OR(H17=\"GreenScreen v1.2 Assessment\",H17=\"Cradle to Cradle v2 Platinum\",H17=\"Cradle to Cradle v3 Gold\",H17=\"Cradle to Cradle v3 Platinum\"),D17*1.5,IF(OR(H17=\"GreenScreen v1.2 List Translator\",H17=\"REACH\",H17=\"Cradle to Cradle v2 Gold\",H17=\"Cradle to Cradle v3 silver\"),D17,0))","v":0},{"$f":"IF(I17=\"Yes\",J17*2,J17)","v":0}]
[null,{"$f":"IF(ISBLANK(Materials!B18),\"\",Materials!B18)","v":""},{"$f":"IF(ISBLANK(Materials!D18),\"\",Materials!D18)","v":""},{"$f":"IF(ISBLANK(Materials!G18),\"\",Materials!G18)","v":""},null,null,null,null,null,{"$f":"IF(OR(H18=\"GreenScreen v1.2 Assessment\",H18=\"Cradle to Cradle v2 Platinum\",H18=\"Cradle to Cradle v3 Gold\",H18=\"Cradle to Cradle v3 Platinum\"),D18*1.5,IF(OR(H18=\"GreenScreen v1.2 List Translator\",H18=\"REACH\",H18=\"Cradle to Cradle v2 Gold\",H18=\"Cradle to Cradle v3 silver\"),D18,0))","v":0},0]
[null,{"$f":"IF(ISBLANK(Materials!B19),\"\",Materials!B19)","v":""},{"$f":"IF(ISBLANK(Materials!D19),\"\",Materials!D19)","v":""},{"$f":"IF(ISBLANK(Materials!G19),\"\",Materials!G19)","v":""},null,null,null,null,null,{"$f":"IF(OR(H19=\"GreenScreen v1.2 Assessment\",H19=\"Cradle to Cradle v2 Platinum\",H19=\"Cradle to Cradle v3 Gold\",H19=\"Cradle to Cradle v3 Platinum\"),D19*1.5,IF(OR(H19=\"GreenScreen v1.2 List Translator\",H19=\"REACH\",H19=\"Cradle to Cradle v2 Gold\",H19=\"Cradle to Cradle v3 silver\"),D19,0))","v":0},0]
["A",null,null,null,null,"Total number of products",null,"Total sustainable criteria value with location valuation factor",null,null,{"$f":"SUM(K9:K19)","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F9:F19,\"<>\")","v":0}]

{"sheet":"Summary","index":5,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[71,3,71,4],[71,10,72,10]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tabs."]
[]
[null,null,"Total materials cost ($)",null,null,null,null,{"$f":"Instructions!G31","v":0}]
[]
[]
[null,null,"MR Credit Building Product Disclosure and Optimization - Environmental Product Declarations"]
[]
[null,null,"Option 1. Environmental Product Declaration"]
[]
[null,null,"Weighted number of products with EPD",null,null,null,null,{"$f":"'Environ. Product Declarations'!H20","v":0}]
[]
[null,null,"Option 2. Multi-Attribute Optimization"]
[]
[null,null,"Total sustainable criteria value of products with multi-attribute optimization",null,null,null,null,{"$f":"SUMIF('Environ. Product Declarations'!C9:C19,\"No\",'Environ. Product Declarations'!L9:L19)+H27","v":0}]
[]
[null,null,"Sustainable criteria value as a percentage of total materials cost",null,null,null,null,{"$f":"IFERROR(H17/H6,0)","v":0}]
[]
[null,null,"For projects with structure and enclosure materials"]
[]
[null,null,"Total structure and enclosure materials sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"SUMIF('Environ. Product Declarations'!C9:C19,\"Yes\",'Environ. Product Declarations'!L9:L19)","v":0}]
[]
[null,null,"Total sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"'Environ. Product Declarations'!L20","v":0}]
[]
[null,null,"Structure and enclosure materials sustainable criteria value claimed (capped at 30%)",null,null,null,null,{"$f":"IFERROR(IF(H23/H25>0.3,(H25*0.3),H23),0)","v":0}]
[]
[]
[null,null,"MR Credit Building Product Disclosure and Optimization - Sourcing of Raw Materials"]
[]
[null,null,"Option 1. Raw Material Source and Extraction Reporting"]
[]
[null,null,"Weighted number of products with raw material source and extraction reports",null,null,null,null,{"$f":"'Sourcing of Raw Materials'!G20","v":0}]
[]
[null,null,"Option 2. Leadership Extraction Practices"]
[]
[null,null,"Total sustainable criteria value of products with leadership extraction practices",null,null,null,null,{"$f":"SUMIF('Sourcing of Raw Materials'!C9:C19,\"No\",'Sourcing of Raw Materials'!X9:X19)+H48","v":0}]
[]
[null,null,"Sustainable criteria value as a percentage of total materials cost",null,null,null,null,{"$f":"IFERROR(H38/H6,0)","v":0}]
[]
[null,null,"For projects with structure and enclosure materials"]
[]
[null,null,"Total structure and enclosure materials sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"SUMIF('Sourcing of Raw Materials'!C9:C19,\"Yes\",'Sourcing of Raw Materials'!X9:X19)","v":0}]
[]
[null,null,"Total sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"'Sourcing of Raw Materials'!X20","v":0}]
[]
[null,null,"Structure and enclosure materials sustainable criteria value claimed (capped at 30%)",null,null,null,null,{"$f":"IFERROR(IF(H44/H46>0.3,(H46*0.3),H44),0)","v":0}]
[]
[]
[null,null,"MR Credit Building Product Disclosure and Optimization - Material Ingredients"]
[]
[null,null,"Option 1. Material Ingredient Reporting"]
[]
[null,null,"Number of products meeting material ingredient reporting requirements",null,null,null,null,{"$f":"'Material Ingredients'!F21","v":0}]
[]
[null,null,"Option 2. Material Ingredient Optimization"]
[]
[null,null,"Total sustainable criteria value of products with material ingredient optimization",null,null,null,null,{"$f":"SUMIF('Material Ingredients'!C9:C19,\"No\",'Material Ingredients'!K9:K19)+H69","v":0}]
[]
[null,null,"Sustainable criteria value as a percentage of total materials cost",null,null,null,null,{"$f":"IFERROR(H59/H6,0)","v":0}]
[]
[null,null,"For projects with structure and enclosure materials"]
[]
[null,null,"Total structure and enclosure materials sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"SUMIF('Material Ingredients'!C9:C19,\"Yes\",'Material Ingredients'!K9:K19)","v":0}]
[]
[null,null,"Total sustainable criteria value with location valuation factor",null,null,null,null,{"$f":"'Material Ingredients'!K20","v":0}]
[]
[null,null,"Structure and enclosure materials sustainable criteria value claimed (capped at 30%)",null,null,null,null,{"$f":"IFERROR(IF(H65/H67>0.3,(H67*0.3),H65),0)","v":0}]