{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Products and Materials","Equipment","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[14,4,14,7],[12,4,12,7],[2,4,2,5],[7,4,7,5],[4,4,4,5],[5,4,5,5],[9,4,9,7]]}
[]
[]
[null,null,null,null,"LEED v4\nGreen Cleaning Calculator"]
[]
[null,null,null,null,"Step 1. "]
[null,null,null,null,"Enable macros."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"For projects pursuing EQ Credit Green Cleaning - Products and Materials"]
[null,null,null,null,"Complete the Products and Materials tab for all products and materials purchased during the performance period."]
[]
[null,null,null,null,"For projects pursuing EQ Credit Green Cleaning - Equipment"]
[null,null,null,null,"Complete the Equipment tab for all equipment products."]
[]
[null,null,null,null,"Step 3. \nUse the information on the Summary tab to complete the LEED Credit Form(s)."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"product category","Cleaning product","Paper product or trash bag","Disinfectant, metal polish, etc.",{"$f":"J26","v":"Hand soap or sanitizer"}]
[null,null,null,null,null,null,null,null,null,"Cleaning product","GS-37","EPA's CPG","CCD-112","No antimicrobial agents"]
[null,null,null,null,null,null,null,null,null,"Disinfectant, metal polish, etc","CCD-110","GS-01","CCD-113","GS-41"]
[null,null,null,null,null,null,null,null,null,"Paper product or trash bag","CCD-146","CCD-082","CCD-115","CCD-104"]
[null,null,null,null,null,null,null,null,null,"Hand soap or sanitizer","CCD-148","CCD-086","GS-53/53","CCD-170"]
[null,null,null,null,null,null,null,null,null,null,"GS-40","Rapidly renewable/tree-free fibers","CA Code of Reg's VOC limits","Type 1 eco-label"]
[null,null,null,null,null,null,null,null,null,null,"CCD-147","FSC Certified","US EPA's DfE","None"]
[null,null,null,null,null,null,null,null,null,null,"US EPA's DfE","California IWM","EcoForm's IBEL"]
[null,null,null,null,null,null,null,null,null,null,"EcoForm's IBEL","Type 1 eco-label","Ionized water system"]
[null,null,null,null,null,null,null,null,null,null,"Ionized water system","None","Type 1 eco-label"]
[null,null,null,null,null,null,null,null,null,null,"Type 1 eco-label",null,"None"]
[null,null,null,null,null,null,null,null,null,null,"None"]
[]
[null,null,null,null,null,null,null,null,null,"product category","vacuum cleaner","carpet extraction equipment","powered floor maintenance equipment","propane powered equipment","automated scrubbing machines"]
[null,null,null,null,null,null,null,null,null,"Vacuum cleaner","CRI certified","CRI certified","N/A","High-efficiency, low-emissions engines with catalytic converters and mufflers meeting CARB or EPA standards","Equipped with variable speed pumps and onboard chemical metering"]
[null,null,null,null,null,null,null,null,null,"Carpet extraction equipment","None","None",null,"None","Equipped with variable speed pumps and dilution control system"]
[null,null,null,null,null,null,null,null,null,"Powered floor maintenance equipment",null,null,null,null,"Uses tap water only"]
[null,null,null,null,null,null,null,null,null,"Propane powered equipment",null,null,null,null,"None"]
[null,null,null,null,null,null,null,null,null,"Automated scrubbing machines"]

{"sheet":"Products and Materials","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,4,9],[15,1,15,5],[15,7,15,8]]}
[]
[null,"Product and Materials "]
[]
[]
[null,"Complete the table by identifying each cleaning product and material in use, the date of purchase, and the applicable sustainability criteria met by each product, if any. "]
[null,"Purchase \nDate","Purchaser","Product \nManufacturer and Name","Cost \nper Item ($)","Number of\nItems","Total \nCost","Product \nCategory","Sustainability \nCriterion","Sustainability \nValue "]
[{"$f":"IF(E7>0,0,0)","v":0},"2013-11-22","StopWaste.org","10941 Regular Rol Bath Tissue",50.63,1,{"$f":"E7*F7","v":50.63},"Paper product or trash bag","EPA's CPG",{"$f":"IF(OR(ISBLANK(I7),I7=\"None\"),0,G7)","v":50.63},null,{"$f":"IF(H7=Instructions!$J$23,\"cleaningproduct\",IF(H7=Instructions!$J$24,\"Disinfectant\",IF(H7=Instructions!$J$25,\"paperproduct\",IF(H7=Instructions!$J$26,\"handsoap\",\"\"))))","v":"paperproduct"}]
[{"$f":"IF(E8>0,0,0)","v":0},"2013-11-22","StopWaste.org","20487 TORK Roll Towel",41.52,1,{"$f":"E8*F8","v":41.52},"Paper product or trash bag","EPA's CPG",{"$f":"IF(ISBLANK(I8),0,G8)","v":41.52},null,{"$f":"IF(H8=Instructions!$J$23,\"cleaningproduct\",IF(H8=Instructions!$J$24,\"Disinfectant\",IF(H8=Instructions!$J$25,\"paperproduct\",IF(H8=Instructions!$J$26,\"handsoap\",\"\"))))","v":"paperproduct"}]
[{"$f":"IF(E9>0,0,0)","v":0},"2013-11-22","StopWaste.org","18426 GOJ Green Seal Handsoap",13.2,1,{"$f":"E9*F9","v":13.2},"Hand soap or sanitizer","GS-41",{"$f":"IF(ISBLANK(I9),0,G9)","v":13.2},null,{"$f":"IF(H9=Instructions!$J$23,\"cleaningproduct\",IF(H9=Instructions!$J$24,\"Disinfectant\",IF(H9=Instructions!$J$25,\"paperproduct\",IF(H9=Instructions!$J$26,\"handsoap\",\"\"))))","v":"handsoap"}]
[0,"2013-11-22","StopWaste.org","11227 Terminator disenfectant",25.47,1,25.47,"Disinfectant, metal polish, etc",null,0,null,{"$f":"IF(H10=Instructions!$J$23,\"cleaningproduct\",IF(H10=Instructions!$J$24,\"Disinfectant\",IF(H10=Instructions!$J$25,\"paperproduct\",IF(H10=Instructions!$J$26,\"handsoap\",\"\"))))","v":"Disinfectant"}]
[0,"2013-11-22","StopWaste.org","17460 Marauder General Purpose Cleaner",20.36,1,20.36,"Cleaning product","GS-37",20.36,null,{"$f":"IF(H11=Instructions!$J$23,\"cleaningproduct\",IF(H11=Instructions!$J$24,\"Disinfectant\",IF(H11=Instructions!$J$25,\"paperproduct\",IF(H11=Instructions!$J$26,\"handsoap\",\"\"))))","v":"cleaningproduct"}]
[0,"2013-11-22","StopWaste.org","11905 Ram Heavy Duty Degreaser",19.82,1,19.82,"Cleaning product","GS-37",19.82,null,{"$f":"IF(H12=Instructions!$J$23,\"cleaningproduct\",IF(H12=Instructions!$J$24,\"Disinfectant\",IF(H12=Instructions!$J$25,\"paperproduct\",IF(H12=Instructions!$J$26,\"handsoap\",\"\"))))","v":"cleaningproduct"}]
[0,"2013-11-22","StopWaste.org","11904 Buckeye True 7 cleaner",13.5,1,13.5,"Cleaning product","GS-37",13.5,null,{"$f":"IF(H13=Instructions!$J$23,\"cleaningproduct\",IF(H13=Instructions!$J$24,\"Disinfectant\",IF(H13=Instructions!$J$25,\"paperproduct\",IF(H13=Instructions!$J$26,\"handsoap\",\"\"))))","v":"cleaningproduct"}]
[null,"2013-11-22","StopWaste.org","20152 24x33 Compostable liners",90.58,1,{"$f":"E14*F14","v":90.58},"Paper product or trash bag","Rapidly renewable/tree-free fibers",90.58,null,{"$f":"IF(H14=Instructions!$J$23,\"cleaningproduct\",IF(H14=Instructions!$J$24,\"Disinfectant\",IF(H14=Instructions!$J$25,\"paperproduct\",IF(H14=Instructions!$J$26,\"handsoap\",\"\"))))","v":"paperproduct"}]
[null,"2013-11-22","StopWaste.org","11202 24x24 Hi-Density Liners",18.989999999999998,1,{"$f":"E15*F15","v":18.989999999999998},"Paper product or trash bag",null,{"$f":"IF(ISBLANK(I15),0,G15)","v":0},null,{"$f":"IF(H15=Instructions!$J$23,\"cleaningproduct\",IF(H15=Instructions!$J$24,\"Disinfectant\",IF(H15=Instructions!$J$25,\"paperproduct\",IF(H15=Instructions!$J$26,\"handsoap\",\"\"))))","v":"paperproduct"}]
["A","Total cost of cleaning products and materials purchased",null,null,null,null,{"$f":"SUM('Products and Materials'!G7:G15)","v":294.07},"Total value of sustainable cleaning products and materials ($)",null,{"$f":"SUM('Products and Materials'!J7:J15)","v":249.61}]

{"sheet":"Equipment","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,4,10],[12,1,12,3],[12,5,12,9]]}
[]
[null,"Equipment"]
[]
[]
[null,"Complete the table by identifying each piece of powered cleaning equipment in use, the date of equipment purchase, and the applicable sustainability criteria met by each equipment, if any. Estimated purchase dates may be used for equipment purchased before the performance period."]
[null,"Purchase \nDate","Purchaser","Product \nManufacturer and Name","Number of Items","Product \nCategory","Sustainability \nCriterion","Includes safeguards, ergonomic design?","Includes environmentally preferable batteries?","Maximum\nOperating Sound Level (dBA)","Credit Compliance"]
[{"$f":"IF(E7>0,0,0)","v":0},"2012-06-01","StopWaste.org","Perfect",1,"Vacuum cleaner","CRI certified","Yes","N/A",70,{"$f":"IF(AND(G7<>\"none\",G7<>\"\",H7=\"Yes\",OR(I7=\"Yes\",I7=\"N/A\"),OR(AND(F7=Instructions!J36,J7>0,J7<=70),Equipment!F7=Instructions!J37,AND(F7=Instructions!J38,J7>0,J7<=70),AND(F7=Instructions!J39,J7>0,J7<=90),F7=Instructions!J40)),\"Yes\",\"No\")","v":"Yes"}]
[{"$f":"IF(E8>0,0,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G8<>\"none\",G8<>\"\",(OR(AND(F8=Instructions!J37,J8<=70),Equipment!F8=Instructions!J38,AND(F8=Instructions!J39,J8<=70),AND(F8=Instructions!J40,J8<=90)))),\"Yes\",\"No\")","v":"No"}]
[0,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G9<>\"none\",G9<>\"\",(OR(AND(F9=Instructions!J38,J9<=70),Equipment!F9=Instructions!J39,AND(F9=Instructions!J40,J9<=70),AND(F9=Instructions!J41,J9<=90)))),\"Yes\",\"No\")","v":"No"}]
[{"$f":"IF(E10>0,0,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G10<>\"none\",G10<>\"\",(OR(AND(F10=Instructions!J39,J10<=70),Equipment!F10=Instructions!J40,AND(F10=Instructions!J41,J10<=70),AND(F10=Instructions!J42,J10<=90)))),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G11<>\"none\",G11<>\"\",(OR(AND(F11=Instructions!J39,J11<=70),Equipment!F11=Instructions!J40,AND(F11=Instructions!J41,J11<=70),AND(F11=Instructions!J42,J11<=90)))),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G12<>\"none\",G12<>\"\",(OR(AND(F12=Instructions!J40,J12<=70),Equipment!F12=Instructions!J41,AND(F12=Instructions!J42,J12<=70),AND(F12=Instructions!J43,J12<=90)))),\"Yes\",\"No\")","v":"No"}]
["A","Total number of equipment products purchased",null,null,{"$f":"SUM(E7:E12)","v":1},"Total number of equipment products meeting sustainability criteria",null,null,null,null,{"$f":"SUMIF(Equipment!K7:K12,\"Yes\",Equipment!E7:E12)","v":1}]

{"sheet":"Summary","index":3,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,2,12,5],[31,3,31,4],[31,10,32,10],[24,3,25,5],[24,10,25,10],[26,3,27,4],[28,3,28,6],[28,10,29,10],[29,3,30,4]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"EQ Credit Green Cleaning - Products and Materials"]
[]
[null,null,"Total cost of cleaning products and materials purchased",null,null,null,null,{"$f":"'Products and Materials'!G16","v":294.07}]
[]
[null,null,"Total value of sustainable cleaning products and materials",null,null,null,null,{"$f":"SUM('Products and Materials'!J7:J15)","v":249.61}]
[]
[null,null,"Sustainable cleaning products and materials as a percentage of total cost of cleaning products and materials",null,null,null,null,{"$f":"IFERROR(H10/H8,0)","v":0.8488115074642093}]
[]
[]
[null,null,"EQ Credit Green Cleaning - Equipment"]
[]
[null,null,"Total number of equipment products purchased",null,null,null,null,{"$f":"Equipment!E13","v":1}]
[]
[null,null,"Total number of equipment products meeting sustainability criteria",null,null,null,null,{"$f":"Equipment!K13","v":1}]
[]
[null,null,"Sustainable equipment products as a percentage of total equipment (%)",null,null,null,null,{"$f":"IFERROR(H19/H17,0)","v":1}]