{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CoventryASDA","SolvCalc","DEFRAFormula"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"CoventryASDA","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,0,58,2],[1,5,1,6],[9,5,9,6],[0,0,0,4],[56,0,56,2],[57,0,57,2]]}
["GE Solvent Inventory - Johnsons, Coventry, ASDA"]
["SHOP","DATE","LSOL","KGDC","DRUMS","KEY"]
[6082,"2016-10-01",0,269,0,"DATE","Week commencing date "]
[6082,"2016-10-08",10,274,0,"LSOL","Litres of solvent delivered per week"]
[6082,"2016-10-15",0,273,0,"KGDC","Weight of clothes cleaned per week"]
[6082,"2016-10-22",10,197,0,"DRUMS","Number of still residue drums removed per week (1 drum = 120 Ltrs)"]
[6082,"2016-10-29",0,294,0]
[6082,"2016-11-05",10,233,0]
[6082,"2016-11-12",10,267,0]
[6082,"2016-11-19",10,203,0,"Trained colleagues"]
[6082,"2016-11-26",0,193,0,"Sanfra","Adams"]
[6082,"2016-12-03",0,251,0,"Zoe","Grant"]
[6082,"2016-12-10",0,231,0,"Elaine","Wall"]
[6082,"2016-12-17",20,201,0,"Stephanie","Dawson"]
[6082,"2016-12-24",10,310,0,"Amanda","Charnley"]
[6082,"2016-12-31",10,158,0]
[6082,"2017-01-07",0,187,0]
[6082,"2017-01-14",10,211,0]
[6082,"2017-01-21",10,187,0]
[6082,"2017-01-28",0,163,0]
[6082,"2017-02-04",0,221,0]
[6082,"2017-02-11",0,127,1]
[6082,"2017-02-18",0,209,0]
[6082,"2017-02-25",20,239,0]
[6082,"2017-03-04",0,164,0]
[6082,"2017-03-11",10,231,0]
[6082,"2017-03-18",10,307,0]
[6082,"2017-03-25",10,157,0]
[6082,"2017-04-01",0,193,0]
[6082,"2017-04-08",0,182,0]
[6082,"2017-04-15",10,226,0]
[6082,"2017-04-22",0,206,0]
[6082,"2017-04-29",10,193,0]
[6082,"2017-05-06",0,220,0]
[6082,"2017-05-13",0,260,0]
[6082,"2017-05-20",0,218,0]
[6082,"2017-05-27",10,231,0]
[6082,"2017-06-03",0,181,0]
[6082,"2017-06-10",0,218,0]
[6082,"2017-06-17",10,209,0]
[6082,"2017-06-22",10,140,0]
[6082,"2017-06-29",0,244,0]
[6082,"2017-07-06",10,174,0]
[6082,"2017-07-13",0,189,0]
[6082,"2017-07-20",0,171,0]
[6082,"2017-07-27",10,242,0]
[6082,"2017-08-03",0,178,0]
[6082,"2017-08-10",10,217,0]
[6082,"2017-08-17",0,207,0]
[6082,"2017-08-24",10,217,0]
[6082,"2017-08-31",10,215,0]
[6082,"2017-09-07",0,252,1]
[6082,"2017-09-14",10,250,0]
[6082,"2017-09-21",0,224,0]
[6082,"2017-09-28",0,216,0]
["Totals",null,270,11430,2]
["Solvent used(delivered)  ",null,null,270]
["Weight of Dry Cleaning",null,null,11430]
["Residue removed  ",null,null,240]

{"sheet":"SolvCalc","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,0,23,2],[19,0,19,5],[22,3,23,3],[18,0,18,2],[28,3,28,5],[27,0,27,1],[26,0,26,1],[25,0,25,1],[24,0,24,1],[6,0,6,5],[5,1,5,2],[3,0,3,5],[17,0,17,1],[17,3,17,4],[16,0,16,1],[16,3,16,4],[15,0,15,1],[15,3,15,4],[12,0,14,2],[12,3,12,4],[13,3,14,4],[13,5,14,5],[11,0,11,5],[10,0,10,6],[9,0,9,4],[8,1,8,2],[2,0,2,5],[0,1,0,3],[0,4,1,5],[0,6,1,6],[1,1,1,3]]}
["Site:","Johnsons, Coventry, ASDA",null,null,"Month and year:",null,"Oct 2016 / Sept 2017"]
["Machine:"]
["Week ending / Week No."]
["Weight of work processed (kg)",null,null,null,null,null,"Monthly Total Weight (kg)"]
[null,null,null,null,null,null,"a"]
[11430,null,null,null,null,null,11430]
["Solvent used (litres)",null,null,null,null,null,"Monthly Total (litres)"]
[null,null,null,null,null,null,"c"]
[270,null,null,null,null,null,270]
["Estimated still residue for month (litres)",null,null,null,null,"d",240]
["Note: Estimate the amount of residue collected so that a draft solvent usage figure can be obtained. You will need to adjust this figure from time to time so that the total for the year corresponds to your waste collection transfer notes."]
["Still type / Allowance factor "]
["Method of still cleaning",null,null,"Waste Allowance Factor",null,"Total","Allowance"]
[null,null,null,"e",null,"d","f"]
[null,null,null,null,null,null,"= e × d"]
["Powder filter rake out",null,null,0.15,null,0,0]
["Ecological powder rake out",null,"x",0.35,null,240,84]
["Pumped out",null,null,0.5,null,0,0]
["Nominal Monthly Solvent Use",null,null,"(litres)","g = c - f",186]
["Solvent emission calculation"]
["Type of Solvent",null,null,"Factor: specific gravity of solvent","Weight of work / litre of solvent","Solvent emitted (should be 20g/kg or less)","Weight of solvent used"]
[null,null,null,"(g/l)","(kg / l)","g / kg","(kg)"]
[null,null,null,"h","j","k","b"]
[null,null,null,null,"= a ÷ g","= h ÷  j","= g × (h ÷ 1000)"]
["Perc",null,null,1600]
["Siloxane",null,"x",970,61.45,15.78,180.42]
["Hydrocarbon",null,null,970]
["Other"]
[180.42,970,null,"Solvent Usage Check : ",null,null,"OK"]

{"sheet":"DEFRAFormula","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,2],[13,3,13,4],[13,9,13,10],[12,3,12,4],[13,11,13,13],[12,11,12,13],[12,5,12,6],[12,9,12,10],[8,3,8,4],[8,5,8,6],[8,11,8,13],[11,3,11,4],[11,5,11,6],[11,11,11,13],[9,0,10,0],[9,3,9,4],[9,5,9,6],[9,11,9,13],[10,3,10,4],[10,5,10,6],[10,11,10,13],[0,1,0,11],[1,0,5,0],[1,1,2,4],[1,5,2,8],[1,9,2,9],[1,10,1,13],[2,10,3,13],[3,1,3,4],[3,5,3,8],[4,1,4,4],[4,5,4,8],[4,10,4,13]]}
["Site:","Johnsons, Coventry, ASDA",null,null,null,null,null,null,null,null,null,null,"Year:","Oct 2016 / Sept 2017"]
["Month and Year","Annual weight of work processed",null,null,null,"Annual weight of solvent used",null,null,null,"Annual solvent emitted per kg of work processed","Estimated still residue"]
[null,null,null,null,null,null,null,null,null,null,"(Use this to check the total for each method of still cleaning against your waste collection notes, adjust the final months figure as necessary to correspond)"]
[null,"a",null,null,null,"b",null,null,null,"l"]
[null,"(kg)",null,null,null,"(kg)",null,null,null,"= Total b × 1000 ÷ Total a","(litres)"]
[null,"Machine 1","Machine 2","Machine 3","Machine 4","Machine 1","Machine 2","Machine 3","Machine 4","(g/kg)","Machine 1","Machine 2","Machine 3","Machine 4"]
[null,11430,0,0,0,180.42,0,0,0,15.78,240]
["Sub Totals",11430,null,null,null,180.42,null,null,null,null,240]
["Annual Spot Cleaning Correction Factor (see Note 1):",null,null,"Total annual weight of work processed",null,"Total annual weight of solvent used",null,null,null,null,null,"Annual total of solvent emitted per kg of work processed"]
["m",null,null,"n",null,"p",null,null,null,null,null,"q"]
[null,null,null,"= Total a",null,"= Total b + m",null,null,null,null,null,"= p × 1000 ÷ n"]
["(lts)",null,null,"(kg)",null,"(kg)",null,null,null,null,null,"(g/kg)"]
[6.25,null,null,11430,null,186.67,null,null,null,"Annual result",null,16.329999999999998]
["Weight of work required to comply with regulations (kg):",null,null,9334,null,null,null,null,null,"Complies with Regulations?",null,"YES"]