{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Ongoing","Facility Maintenance","Lamps","Summary","Summary - Sch or Hos"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":4,"comments":4,"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":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[44,3,44,6],[62,2,63,5],[55,2,56,5],[57,2,58,5],[60,2,61,5],[34,4,34,7],[40,4,40,7],[42,4,42,7],[2,3,4,3],[2,4,2,5],[31,4,31,7],[37,4,37,7]]}
[]
[]
[null,null,null,null,"LEED v4\nPurchasing Calculator"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros"]
[]
[null,null,null,null,"Step 2."]
[null,null,null,null,"Select units",null,null,"miles"]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"Provide the actual cost for the following product and material types, as applicable:"]
[]
[null,null,null,null,"For projects attempting MR Credit Purchasing - Ongoing"]
[]
[null,null,null,null,"Total ongoing consumables cost",null,null,4238.47]
[]
[null,null,null,null,"Total electric-powered equipment cost",null,null,12236]
[]
[null,null,null,null,"Total food and beverage cost (O+M: Schools and O+M: Hospitality Only)",null,null,2495.91]
[]
[null,null,null,null,"For projects attempting MR Credit Purchasing - Facility Maintenance and Renovation"]
[]
[null,null,null,null,"Total products and materials cost",null,null,0]
[]
[null,null,null,null,"Total furniture cost",null,null,0]
[]
[null,null,null,null,"Total materials cost for the LEED project: ",null,null,{"$f":"SUM(H16:H26)","v":18970.38}]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"For projects attempting MR Credit Purchasing - Ongoing"]
[null,null,null,null,"Complete the Ongoing Consumables and Electric-Powered Equipment sections on the Ongoing tab."]
[]
[null,null,null,null,"For projects attempting MR Credit Purchasing - Facility Maintenance and Renovation"]
[null,null,null,null,"Complete the Facility Maintenance tab."]
[]
[null,null,null,null,"For projects attempting MR Credit Purchasing - Lamps"]
[null,null,null,null,"Complete the Lamps tab."]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"Use the information on the Summary tab complete the LEED Credit Form."]
[]
[null,null,null,null,"For Existing Buildings: Schools or Hospitality projects, use the information on Summary - Sch or Hos tab to complete the LEED Credit Form."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"MaterialTyp"]
[null,null,null,null,null,null,null,null,null,null,"Paints and coatings wet-applied on site"]
[null,null,null,null,null,null,null,null,null,null,"Adhesives and sealants wet-applied on site"]
[null,null,null,null,null,null,null,null,null,null,"Flooring"]
[null,null,null,null,null,null,null,null,null,null,"Composite wood"]
[null,null,null,null,null,null,null,null,null,null,"Ceilings, walls, thermal, and acoustic insulation"]
[null,null,null,null,null,null,null,null,null,null,"Salvaged and reused architectural millwork"]
[null,null,null,null,null,null,null,null,null,null,"Other"]

{"sheet":"Ongoing","index":1,"n_rows":81,"n_cols":28,"rows_kept":81,"cut":false,"hidden":false,"merged":[[5,26,6,26],[5,27,6,27],[4,26,4,27],[79,5,79,6],[4,1,4,3],[5,24,6,24],[5,18,5,19],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,5,5,7],[5,9,5,10],[5,21,5,22],[4,5,4,24]]}
[]
[null,"Ongoing"]
[]
[]
[null,"Material Information",null,null,null,"Ongoing Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric-Powered Equipment"]
[null,"Description of \nMaterial","Manufacturer or \nVendor Name","Material Cost\n($)",null,"Postconsumer Recycled Content",null,null,null,"Extended Use",null,null,"Sustainable Agriculture",null,null,"Local Sourcing",null,null,"Bio-Based Materials",null,null,"Paper and Wood Products",null,null,"Total Sustainable \nCriteria Value of Ongoing Consumables\n($)",null,"Sustainable \nLabel Name","Sustainable\nCriteria Value \n($)"]
[null,null,null,null,null,"Percent\nPost-Consumer\n(%)","Meets levels in EPA CPG","Sustainable \nCriteria Value \n($)",null,"Rechargeable or Remanufactured","Sustainable \nCriteria Value\n($)",null,"Sustainable \nLabel Name","Sustainable \nCriteria Value \n($)",null,{"$f":"IF(Instructions!H9=\"miles\",\"Percent of Product Sourced Within 100 mi of site (%)\", \"Percent of Product Sourced Within 160 km of site (%)\")","v":"Percent of Product Sourced Within 100 mi of site (%)"},"Sustainable \nCriteria Value \n($)",null,"Percent of Product SAN Certified\n(%)","Sustainable \nCriteria Value \n($)",null,"Percent of Product FSC Certified\n(%)","Sustainable \nCriteria Value \n($)"]
[{"$f":"IF(D8>0,0,0)","v":0},"B24BWL LED Monitor","Acer",2750,null,null,null,{"$f":"IF(AND(F8>0,OR(G8=\"Yes\",G8=\"N/A\")),F8*D8,0)","v":0},null,null,{"$f":"IF(J8=\"Yes\", D8, 0)","v":0},null,null,{"$f":"IF(AND(M8>0, M8<>\"none\"),D8,0)","v":0},null,null,{"$f":"IF(P8>0,D8*P8,0)","v":0},null,null,{"$f":"IF(S8>0,S8*D8,0)","v":0},null,null,{"$f":"IF(V8>0,V8*D8,0)","v":0},null,{"$f":"SUM(H8,K8,N8,Q8,T8,W8)","v":0},null,"ENERGY STAR",{"$f":"IF(OR(AA8=\"EPEAT silver or better\",AA8=\"ENERGY STAR\"),D8,0)","v":2750}]
[{"$f":"IF(D9>0,0,0)","v":0},"3010 Optiplex Standard PSU","Dell",4890,null,null,null,{"$f":"IF(AND(F9>0,OR(G9=\"Yes\",G9=\"N/A\")),F9*D9,0)","v":0},null,null,{"$f":"IF(J9=\"Yes\", D9, 0)","v":0},null,null,{"$f":"IF(AND(M9>0, M9<>\"none\"),D9,0)","v":0},null,null,{"$f":"IF(P9>0,D9*P9,0)","v":0},null,null,0,null,null,0,null,0,null,"ENERGY STAR",{"$f":"IF(OR(AA9=\"EPEAT silver or better\",AA9=\"ENERGY STAR\"),D9,0)","v":4890}]
[0,"EliteBook 840 G1-14\"-Core i5 4200U-Windows 7 Pro 64-Bit","HP",4596,null,null,null,0,null,null,{"$f":"IF(J10=\"Yes\", D10, 0)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,"ENERGY STAR",4596]
[0,"Choice Organic Lemon Lavender Mint (1 box (16 tea bags))","Choice Organics",24.95,null,null,null,0,null,null,0,null,"USDA Organic",24.95,null,null,0,null,null,0,null,null,0,null,24.95,null,null,0]
[0,"Choice Organic Irish Breakfast (1 box (16 tea bags))","Choice Organics",9.98,null,null,null,0,null,null,0,null,"USDA Organic",9.98,null,null,0,null,null,0,null,null,0,null,9.98,null,null,0]
[{"$f":"IF(D13>0,0,0)","v":0},"Choice Organic Ginger (1 box (16 tea bags))","Choice Organics",24.95,null,null,null,{"$f":"IF(AND(F13>0,OR(G13=\"Yes\",G13=\"N/A\")),F13*D13,0)","v":0},null,null,{"$f":"IF(J13=\"Yes\", D13, 0)","v":0},null,"USDA Organic",{"$f":"IF(AND(M13>0, M13<>\"none\"),D13,0)","v":24.95},null,null,{"$f":"IF(P13>0,D13*P13,0)","v":0},null,null,{"$f":"IF(S13>0,S13*D13,0)","v":0},null,null,{"$f":"IF(V13>0,V13*D13,0)","v":0},null,{"$f":"SUM(H13,K13,N13,Q13,T13,W13)","v":24.95},null,null,{"$f":"IF(OR(AA13=\"EPEAT silver or better\",AA13=\"ENERGY STAR\"),D13,0)","v":0}]
[0,"Choice Organic White Peony (1 box (16 tea bags))","Choice Organics",19.96,null,null,null,0,null,null,0,null,"USDA Organic",19.96,null,null,0,null,null,0,null,null,0,null,19.96,null,null,0]
[0,"Choice Organic Peppermint (1 box (16 tea bags))","Choice Organics",9.98,null,null,null,0,null,null,0,null,"USDA Organic",9.98,null,null,0,null,null,0,null,null,0,null,9.98,null,null,0]
[0,"Choice Organic Masala Chai (1 box (16 tea bags))","Choice Organics",19.96,null,null,null,0,null,null,0,null,"USDA Organic",19.96,null,null,0,null,null,0,null,null,0,null,19.96,null,null,0]
[0,"Choice Organic Green Moroccan Mint (1 box (16 tea bags))","Choice Organics",19.96,null,null,null,0,null,null,0,null,"USDA Organic",19.96,null,null,0,null,null,0,null,null,0,null,19.96,null,null,0]
[0,"Choice Organic Genmaicha (6-pack (6 x 16 tea bags))","Choice Organics",27.34,null,null,null,0,null,null,0,null,"USDA Organic",27.34,null,null,0,null,null,0,null,null,0,null,27.34,null,null,0]
[0,"Choice Organic Earl Grey (1 box (16 tea bags))","Choice Organics",9.98,null,null,null,0,null,null,0,null,"USDA Organic",9.98,null,null,0,null,null,0,null,null,0,null,9.98,null,null,0]
[0,"Choice Organic Decaf English Breakfast 6pk","Choice Organics",27.54,null,null,null,0,null,null,0,null,"USDA Organic",27.54,null,null,0,null,null,0,null,null,0,null,27.54,null,null,0]
[0,"Choice Organic Rooibos 6pk","Choice Organics",27.54,null,null,null,0,null,null,0,null,"USDA Organic",27.54,null,null,0,null,null,0,null,null,0,null,27.54,null,null,0]
[0,"Choice Organic Classic Green 6pk","Choice Organics",27.54,null,null,null,0,null,null,0,null,"USDA Organic",27.54,null,null,0,null,null,0,null,null,0,null,27.54,null,null,0]
[0,"Choice Organic Decaf Green 6pk","Choice Organics",27.54,null,null,null,0,null,null,0,null,"USDA Organic",27.54,null,null,0,null,null,0,null,null,0,null,27.54,null,null,0]
[0,"Kraft Roll Paper","Blaisdells",5.29,null,1,"Yes",5.29,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,5.29,null,null,0]
[0,"Recycled Monthly Planner","Blaisdells",19.489999999999998,null,1,"Yes",19.489999999999998,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,19.489999999999998,null,null,0]
[0,"Sugarcane notebook","Blaisdells",32.9,null,1,"Yes",32.9,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,32.9,null,null,0]
[0,"Paper Towels 15/box","Blaisdells",37.979999999999997,null,1,"Yes",37.979999999999997,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,37.979999999999997,null,null,0]
[0,"Twin Pocket Folders 25/bx","Blaisdells",91.74,null,1,"Yes",91.74,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,91.74,null,null,0]
[0,"Copy Paper 10 reems/box","Blaisdells",911.2,null,1,"Yes",911.2,null,null,0,null,null,0,null,null,0,null,null,0,null,1,911.2,null,1822.4,null,null,0]
[0,"Clipboard","Blaisdells",9.98,null,0.9,"Yes",8.9820000000000011,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,8.9820000000000011,null,null,0]
[0,"Bottle gel pen 2/pk black","Blaisdells",13.96,null,0.89,"Yes",12.4244,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,12.4244,null,null,0]
[0,"Bottle gel pen 3/pk blue","Blaisdells",16.47,null,0.89,"Yes",14.658299999999999,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,14.658299999999999,null,null,0]
[0,"Bottle gel pen ","Blaisdells",16.899999999999999,null,0.89,"Yes",15.040999999999999,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,15.040999999999999,null,null,0]
[0,"Bottle ballpoint pen 12/pk","Blaisdells",13.49,null,0.83,"Yes",11.1967,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,11.1967,null,null,0]
[0,"Post its 3x3 12/pk","Blaisdells",59.94,null,0.8,"Yes",47.951999999999998,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,47.951999999999998,null,null,0]
[0,"Toner 53A Remanufactured","Blaisdells",147.97999999999999,null,0.8,"Yes",118.384,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,118.384,null,null,0]
[0,"Add Rolls 12/pk","Blaisdells",17.579999999999998,null,0.6,"Yes",10.547999999999998,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,10.547999999999998,null,null,0]
[{"$f":"IF(D38>0,0,0)","v":0},"Napkins 250/pk","Blaisdells",51.900000000000006,null,0.5,"Yes",{"$f":"IF(AND(F38>0,OR(G38=\"Yes\",G38=\"N/A\")),F38*D38,0)","v":25.950000000000003},null,null,{"$f":"IF(J38=\"Yes\", D38, 0)","v":0},null,null,{"$f":"IF(AND(M38>0, M38<>\"none\"),D38,0)","v":0},null,null,{"$f":"IF(P38>0,D38*P38,0)","v":0},null,null,{"$f":"IF(S38>0,S38*D38,0)","v":0},null,null,{"$f":"IF(V38>0,V38*D38,0)","v":0},null,{"$f":"SUM(H38,K38,N38,Q38,T38,W38)","v":25.950000000000003},null,null,{"$f":"IF(OR(AA38=\"EPEAT silver or better\",AA38=\"ENERGY STAR\"),D38,0)","v":0}]
[0,"Toner 96A","Blaisdells",257.98,null,0.41,"Yes",105.7718,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,105.7718,null,null,0]
[0,"Note book spiral 11x8-1/2","Blaisdells",61.900000000000006,null,0.4,"Yes",24.760000000000005,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,24.760000000000005,null,null,0]
[0,"Wired Notebook 5x8","Blaisdells",91.8,null,0.4,"Yes",36.72,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,36.72,null,null,0]
[0,"Note book pad lgl 12/pk","Blaisdells",199.95000000000002,null,0.4,"Yes",79.980000000000018,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,79.980000000000018,null,null,0]
[0,"1\" Binder","Blaisdells",68.77000000000001,null,0.39,"Yes",26.820300000000003,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,26.820300000000003,null,null,0]
[0,"Perf Top Pad 5x8 12/pk","Blaisdells",13.99,null,0.35,"Yes",4.8964999999999996,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,4.8964999999999996,null,null,0]
[0,"Montly Planner","Blaisdells",16.489999999999998,null,0.3,"Yes",4.9469999999999992,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,4.9469999999999992,null,null,0]
[0,"Tab Dividers","Blaisdells",29.950000000000003,null,0.3,"Yes",8.9850000000000012,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,8.9850000000000012,null,null,0]
[0,"Card Stock","Blaisdells",57.45,null,0.3,"Yes",17.234999999999999,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,17.234999999999999,null,null,0]
[0,"Copy Paper 8 1/2x14 10/pk","Blaisdells",57.95,null,0.3,"Yes",17.385000000000002,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,17.385000000000002,null,null,0]
[0,"Pressboard folders 6 section 10/bx","Blaisdells",91.98,null,0.3,"Yes",27.594000000000001,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,27.594000000000001,null,null,0]
[0,"Self stick easel pad 2/pk","Blaisdells",115.98,null,0.3,"Yes",34.793999999999997,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,34.793999999999997,null,null,0]
[0,"Post its lined 4x6 5/pk","Blaisdells",131.91999999999999,null,0.3,"Yes",39.575999999999993,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,39.575999999999993,null,null,0]
[0,"Drink cups/50","Blaisdells",10.49,null,0.24,"Yes",2.5175999999999998,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,2.5175999999999998,null,null,0]
[0,"Classification folders 10/bx","Blaisdells",77.989999999999995,null,0.2,"Yes",15.597999999999999,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,15.597999999999999,null,null,0]
[0,"Paper Towel 12/ct","Blaisdells",119.97,null,1,"Yes",119.97,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,119.97,null,null,0]
[0,"Note Pro Notebook","Blaisdells",25.98,null,0.5,"Yes",12.99,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,12.99,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[0,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(AND(F78>0,OR(G78=\"Yes\",G78=\"N/A\")),F78*D78,0)","v":0},null,null,{"$f":"IF(J78=\"Yes\", D78, 0)","v":0},null,null,{"$f":"IF(AND(M78>0, M78<>\"none\"),D78,0)","v":0},null,null,{"$f":"IF(P78>0,D78*P78,0)","v":0},null,null,{"$f":"IF(S78>0,S78*D78,0)","v":0},null,null,{"$f":"IF(V78>0,V78*D78,0)","v":0},null,{"$f":"SUM(H78,K78,N78,Q78,T78,W78)","v":0},null,null,{"$f":"IF(OR(AA78=\"EPEAT silver or better\",AA78=\"ENERGY STAR\"),D78,0)","v":0}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,0,null,null,0]
[null,"Total ongoing consumables cost ($)",null,{"$f":"SUM(D8:D79)","v":15390.559999999998},null,"Recycled content value",null,{"$f":"SUM(H8:H79)","v":1944.2765999999999},null,"Extended use value",{"$f":"SUM(K8:K79)","v":0},null,"Sustainable agriculture value",{"$f":"SUM(N8:N79)","v":277.21999999999997},null,"Local sourcing value",{"$f":"SUM(Q8:Q79)","v":0},null,"Bio-based value",{"$f":"SUM(T8:T79)","v":0},null,"Paper and wood products value",{"$f":"SUM(W8:W79)","v":911.2},null,"Total",null,"Sustainable criteria value of electric-powered equipment",{"$f":"SUM(AB8:AB79)","v":12236}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y8:Y79)","v":3132.6965999999998}]

{"sheet":"Facility Maintenance","index":2,"n_rows":19,"n_cols":36,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,35,6,35],[17,6,17,7],[18,6,18,7],[17,19,17,20],[18,19,18,20],[4,26,4,27],[4,34,6,34],[4,33,6,33],[17,29,17,30],[18,29,18,30],[4,23,4,24],[4,29,4,31],[5,11,6,11],[5,13,6,13],[5,14,6,14],[5,16,6,16],[17,2,17,3],[18,2,18,3],[4,1,4,4],[4,19,4,21],[4,6,4,8],[4,10,4,11],[4,13,4,14],[4,16,4,17],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,10,6,10],[5,17,6,17],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,23,6,23],[5,31,6,31],[5,24,6,24],[5,26,6,26],[5,27,6,27],[5,29,6,29],[5,30,6,30]]}
[]
[null,"Facility Maintenance and Renovation"]
[]
[]
[null,"Material Information",null,null,null,null,"Recycled Content",null,null,null,"Wood Products",null,null,"Bio-Based Materials",null,null,"Materials Reuse",null,null,"Extended Producer Responsibility",null,null,null,"Ingredient Reporting",null,null,"Supply Chain Optimization",null,null,"Low emissions of volatile organic compounds and formaldehyde",null,null,null,{"$f":"IF(Instructions!H9=\"miles\",\"Regional Multiplier: Percent Within 100 mi (%)\",\"Regional Multiplier: Percent Within 160 km (%)\")","v":"Regional Multiplier: Percent Within 100 mi (%)"},"Sustainable \nCriteria Value Subtotal","Total Weighted Sustainable \nCriteria Value"]
[null,"Material Type","Description of \nMaterial","Manufacturer or\nVendor Name","Material Cost\n($)",null,"Percent \nPost-Consumer\n(%)","Percent\nPre-Consumer\n(%)","Sustainable \nCriteria Value\n($)",null,"Percent of \nWood \nFSC Certified\n(%)","Sustainable \nCriteria Value \n($)",null,"Percent of \nProduct SAN Certified\n(%)","Sustainable \nCriteria Value \n($)",null,"Percent Salvaged, Refurbished, \nor Reused\n(%)","Sustainable \nCriteria Value\n($)",null,"Closed Loop \nor \nTake Back \nProgram","Program Name or Manufacturer","Sustainable \nCriteria Value\n($)",null,"Certification \nProgram","Sustainable \nCriteria Value \n($)",null,"Third Party Supply Chain Optimization","Sustainable \nCriteria Value \n($)",null,"Material Type","Meets \nStandard","Sustainable \nCriteria Value \n($)"]
[]
[{"$f":"IF(E8>0,0,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(G8+H8<=1,(E8*G8)+(E8*H8/2),\"Exceeds 100%\")","v":0},null,null,{"$f":"K8*E8","v":0},null,null,{"$f":"IF(N8>0,N8*E8,0)","v":0},null,null,{"$f":"Q8*E8","v":0},null,null,null,{"$f":"IF(T8=\"Yes\",E8/2,0)","v":0},null,null,{"$f":"IF(OR(X8=\"GreenScreen List Translator\",X8=\"Cradle to Cradle v3 Silver\",X8=\"Cradle to Cradle v2 Gold\",X8=\"REACH\"),E8,IF(OR(X8=\"Full GreenScreen Assessment\",X8=\"Cradle to Cradle v3 Gold\",X8=\"Cradle to Cradle v3 Platinum\",X8=\"Cradle to Cradle v2 Platinum\"),E8*1.5,0))","v":0},null,null,{"$f":"IF(AA8=\"Yes\",E8,0)","v":0},null,null,null,{"$f":"IF(OR(ISBLANK(AD8),ISBLANK(AE8),AE8=\"No\"),0,E8)","v":0},null,null,{"$f":"SUM(AF8,Y8,V8,R8,O8,L8,I8)","v":0},{"$f":"IF(AH8>0,AI8+(AI8*AH8),AI8)","v":0}]
[{"$f":"IF(E9>0,0,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(G9+H9<=1,(E9*G9)+(E9*H9/2),\"Exceeds 100%\")","v":0},null,null,0,null,null,{"$f":"IF(N9>0,N9*E9,0)","v":0},null,null,{"$f":"Q9*E9","v":0},null,null,null,{"$f":"IF(T9=\"Yes\",E9/2,0)","v":0},null,null,{"$f":"IF(OR(X9=\"GreenScreen List Translator\",X9=\"Cradle to Cradle v3 Silver\",X9=\"Cradle to Cradle v2 Gold\",X9=\"REACH\"),E9,IF(OR(X9=\"Full GreenScreen Assessment\",X9=\"Cradle to Cradle v3 Gold\",X9=\"Cradle to Cradle v3 Platinum\",X9=\"Cradle to Cradle v2 Platinum\"),E9*1.5,0))","v":0},null,null,{"$f":"IF(AA9=\"Yes\",E9,0)","v":0},null,null,null,{"$f":"IF(OR(ISBLANK(AD9),ISBLANK(AE9),AE9=\"No\"),0,E9)","v":0},null,null,{"$f":"SUM(AF9,Y9,V9,R9,O9,L9,I9)","v":0},{"$f":"IF(AH9>0,AI9+(AI9*AH9),AI9)","v":0}]
[0,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[0,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[0,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[0,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[0,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[{"$f":"IF(E15>0,0,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(G15+H15<=1,(E15*G15)+(E15*H15/2),\"Exceeds 100%\")","v":0},null,null,{"$f":"K15*E15","v":0},null,null,{"$f":"IF(N15>0,N15*E15,0)","v":0},null,null,{"$f":"Q15*E15","v":0},null,null,null,{"$f":"IF(T15=\"Yes\",E15/2,0)","v":0},null,null,{"$f":"IF(OR(X15=\"GreenScreen List Translator\",X15=\"Cradle to Cradle v3 Silver\",X15=\"Cradle to Cradle v2 Gold\",X15=\"REACH\"),E15,IF(OR(X15=\"Full GreenScreen Assessment\",X15=\"Cradle to Cradle v3 Gold\",X15=\"Cradle to Cradle v3 Platinum\",X15=\"Cradle to Cradle v2 Platinum\"),E15*1.5,0))","v":0},null,null,0,null,null,null,{"$f":"IF(OR(ISBLANK(AD15),ISBLANK(AE15),AE15=\"No\"),0,E15)","v":0},null,null,{"$f":"SUM(AF15,Y15,V15,R15,O15,L15,I15)","v":0},{"$f":"IF(AH15>0,AI15+(AI15*AH15),AI15)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[null,"Option 1.","Total products and materials cost",null,{"$f":"SUMIF(B8:B17, \"Products and Materials\",E8:E17)","v":0},null,"Recycled content products and materials value",null,{"$f":"SUMIF(B8:B17, \"Products and Materials\",I8:I17)","v":0},null,"Wood products and materials value",{"$f":"SUMIF(B8:B17, \"Products and Materials\",L8:L17)","v":0},null,"Bio-based products and materials value",{"$f":"SUMIF(B8:B17, \"Products and Materials\",O8:O17)","v":0},null,"Products reuse value",{"$f":"SUMIF(B8:B17, \"Products and Materials\",R8:R17)","v":0},null,"Extended producer responsibility products and materials value",null,{"$f":"SUMIF(B8:B17, \"Products and Materials\",V8:V17)","v":0},null,"Ingredient reporting product and materials value",{"$f":"SUMIF(B8:B17, \"Products and Materials\",Y8:Y17)","v":0},null,"Supply chain optimization product and materials value",{"$f":"SUMIF(E8:E17, \"Products and Materials\",AB8:AB17)","v":0},null,"Low emissions product and materials value",null,{"$f":"SUMIF(B8:B17, \"Products and Materials\",AF8:AF17)","v":0},null,"Sustainable criteria value of products and materials",{"$f":"SUMIF(B8:B17, \"Products and Materials\",AI8:AI17)","v":0},{"$f":"SUMIF(B8:B17, \"Products and Materials\",AJ8:AJ17)","v":0}]
[null,"Option 2.","Total furniture cost",null,{"$f":"SUMIF(B8:B17, \"Furniture\",E8:E17)","v":0},null,"Recycled content furniture value",null,{"$f":"SUMIF(B8:B17, \"Furniture\",I8:I17)","v":0},null,"Wood furniture value",{"$f":"SUMIF(B8:B17, \"Furniture\",L8:L17)","v":0},null,"Bio-based furniture cost value",{"$f":"SUMIF(B8:B17, \"Furniture\",O8:O17)","v":0},null,"Furniture reuse value",{"$f":"SUMIF(B8:B17, \"Furniture\",R8:R17)","v":0},null,"Extended producer responsibility furniture value",null,{"$f":"SUMIF(B8:B17, \"Furniture\",V8:V17)","v":0},null,"Ingredient reporting furniture cost value",{"$f":"SUMIF(B8:B17, \"Furniture\",Y8:Y17)","v":0},null,"Supply chain optimization furniture value",{"$f":"SUMIF(E8:E17, \"Furniture\",AB8:AB17)","v":0},null,"Low emissions furniture value",null,{"$f":"SUMIF(B8:B17, \"Furniture\",AF8:AF17)","v":0},null,"Sustainable criteria value of furniture",{"$f":"SUMIF(B8:B17, \"Furniture\",AI8:AI17)","v":0},{"$f":"SUMIF(B8:B17, \"Furniture\",AJ8:AJ17)","v":0}]

{"sheet":"Lamps","index":3,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,15,7]]}
[]
[null,"Lamps"]
[]
[]
[null,"Bulb General Type","Bulb Specific Description or Code","Quantity of \nSpecific Bulb Type","Mercury Content \nper Bulb\n(mg)","Mean \nLight Output \nper Bulb Type\n(lumens)","Rated Life \nper Bulb \n(hrs)","Total \nLumen Hours \nper Bulb","Total \nMercury Content \nper Bulb\n(picograms/lumen-hr)",null,"Mercury Content invalid range","Cutsheets"]
[{"$f":"IF(B6>=0,0,0)","v":0},"Regular fluorescent","PHIL 281535 F32T8TL835ALTO30PK",30,1.7,2950,30000,{"$f":"D6*F6*G6","v":2655000000},{"$f":"IF(AND(F6>0,G6>0),(E6/(F6*G6))*1000000000,0)","v":19.209039548022599},null,{"$f":"IF(AND(OR(E6<0,E6>0.001),OR(E6<0.5,E6>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[{"$f":"IF(B7>=0,0,0)","v":0},"HID","PHIL 230821 F21T5835ALTO40PK",20,1.4,2100,24000,{"$f":"D7*F7*G7","v":1008000000},{"$f":"IF(AND(F7>0,G7>0),(E7/(F7*G7))*1000000000,0)","v":27.777777777777779},null,{"$f":"IF(AND(OR(E7<0,E7>0.001),OR(E7<0.5,E7>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,"",{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
[0,null,null,null,null,null,null,0,0,null,{"$f":"IF(AND(OR(E15<0,E15>0.001),OR(E15<0.5,E15>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(#REF!=\"Yes\",1,0)","v":{"$error":"#REF!"}}]
["A","Building maximum (picograms/lumen-hr)",null,null,null,null,null,null,{"$f":"MAX(I6:I15)","v":27.777777777777779}]

{"sheet":"Summary","index":4,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[56,3,56,4],[56,10,57,10],[49,3,50,5],[49,10,50,10],[51,3,52,4],[53,3,53,6],[53,10,54,10],[54,3,55,4]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"Total materials cost for the LEED project ($)",null,null,null,null,{"$f":"Instructions!H28","v":18970.38}]
[]
[null,null,"MR Credit Purchasing - Ongoing"]
[]
[null,null,"Ongoing Consumables"]
[]
[null,null,"Total ongoing consumables cost",null,null,null,null,{"$f":"Instructions!H16","v":4238.47}]
[]
[null,null,"Sustainable criteria value of ongoing consumables",null,null,null,null,{"$f":"Ongoing!Y81","v":3132.6965999999998}]
[]
[null,null,"Sustainable ongoing consumables as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H14/H12,0)","v":0.73911024497047273},null,null,"Must be at least 60%"]
[]
[null,null,"Electric-Powered Equipment"]
[]
[null,null,"Total electric-powered equipment cost",null,null,null,null,{"$f":"Instructions!H18","v":12236}]
[]
[null,null,"Sustainable criteria value of electric-powered equipment",null,null,null,null,{"$f":"Ongoing!AB80","v":12236}]
[]
[null,null,"Sustainable electric-powered equipment as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H22/H20,0)","v":1},null,null,"Must be at least 40%"]
[]
[null,null,"MR Credit Purchasing - Facility Maintenance and Renovation"]
[]
[null,null,"Option 1. Products and Materials"]
[]
[null,null,"Total products and materials cost",null,null,null,null,{"$f":"Instructions!H24","v":0}]
[]
[null,null,"Sustainable criteria value of facility maintenance and renovation products and materials",null,null,null,null,{"$f":"'Facility Maintenance'!AJ18","v":0}]
[]
[null,null,"Sustainable facility maintenance and renovation products and materials as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H32/H30,0)","v":0},null,null,"Must be at least 50% "]
[]
[null,null,"Option 2. Furniture"]
[]
[null,null,"Total furniture cost",null,null,null,null,{"$f":"Instructions!H26","v":0}]
[]
[null,null,"Sustainable criteria value of facility maintenance and renovation furniture",null,null,null,null,{"$f":"'Facility Maintenance'!AJ19","v":0}]
[]
[null,null,"Sustainable facility maintenance and renovation furniture as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H40/H38,0)","v":0},null,null,"Must be at least 75% "]
[]
[null,null,"MR Credit Purchasing - Lamps"]
[]
[null,null,"Overall picograms per lumen-hr",null,null,null,null,{"$f":"Lamps!I16","v":27.777777777777779},null,null,"Must be 70 or less"]

{"sheet":"Summary - Sch or Hos","index":5,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[61,3,61,6],[64,10,65,10],[62,3,63,4],[64,3,64,4],[57,10,58,10],[57,3,58,5],[61,10,62,10],[59,3,60,4]]}
[]
[]
[null,null,"Summary for Existing Buildings: Schools and Hospitality"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"Total materials cost for the LEED project",null,null,null,null,{"$f":"Instructions!H28","v":18970.38}]
[]
[null,null,"MR Credit Purchasing - Ongoing"]
[]
[null,null,"Ongoing Consumables"]
[]
[null,null,"Total ongoing consumables cost",null,null,null,null,{"$f":"Instructions!H16","v":4238.47}]
[]
[null,null,"Sustainable criteria value of ongoing consumables",null,null,null,null,{"$f":"Ongoing!Y81","v":3132.6965999999998}]
[]
[null,null,"Sustainable ongoing consumables as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H14/H12,0)","v":0.73911024497047273},null,null,"Must be at least 60%"]
[]
[null,null,"Electric-Powered Equipment"]
[]
[null,null,"Total electric-powered equipment cost",null,null,null,null,{"$f":"Instructions!H18","v":12236}]
[]
[null,null,"Sustainable criteria value of electric-powered equipment",null,null,null,null,{"$f":"Ongoing!AB80","v":12236}]
[]
[null,null,"Sustainable electric-powered equipment as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H22/H20,0)","v":1},null,null,"Must be at least 40%"]
[]
[null,null,"Food and Beverage"]
[]
[null,null,"Total food and beverage cost",null,null,null,null,{"$f":"Instructions!H20","v":2495.91}]
[]
[null,null,"Sustainable criteria value of food and beverage",null,null,null,null,{"$f":"Ongoing!Q80+Ongoing!N80","v":277.21999999999997}]
[]
[null,null,"Sustainable food and beverage as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H30/H28,0)","v":0.11106971004563465},null,null,"Must be at least 25%"]
[]
[null,null,"MR Credit Purchasing - Facility Maintenance and Renovation"]
[]
[null,null,"Option 1. Products and Materials"]
[]
[null,null,"Total products and materials cost",null,null,null,null,{"$f":"Instructions!H24","v":0}]
[]
[null,null,"Sustainable criteria value of facility maintenance and renovation products and materials",null,null,null,null,{"$f":"'Facility Maintenance'!AJ18","v":0}]
[]
[null,null,"Sustainable facility maintenance and renovation products and materials as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H40/H38,0)","v":0},null,null,"Must be at least 50% "]
[]
[null,null,"Option 2. Furniture"]
[]
[null,null,"Total furniture cost",null,null,null,null,{"$f":"Instructions!H26","v":0}]
[]
[null,null,"Sustainable criteria value of facility maintenance and renovation furniture",null,null,null,null,{"$f":"'Facility Maintenance'!AJ19","v":0}]
[]
[null,null,"Sustainable facility maintenance and renovation furniture as a percentage of total cost",null,null,null,null,{"$f":"IFERROR(H48/H46,0)","v":0},null,null,"Must be at least 75% "]
[]
[null,null,"MR Credit Purchasing - Lamps"]
[]
[null,null,"Overall picograms per lumen-hr",null,null,null,null,{"$f":"Lamps!I23","v":0},null,null,"Must be 70 or less"]