{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Solv Calc","DEFRA Formula"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Data","index":0,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,59,2],[2,6,2,7],[39,6,39,7],[0,0,0,4],[57,0,57,2],[58,0,58,2]]}
["GE Solvent Inventory "]
[]
["SHOP","DATE","LSOL","KGDC","DRUMS",null,"KEY"]
[6071,"2018-10-05",null,133,null,null,"DATE","Week commencing date "]
[6071,"2018-10-12",18.95,186,null,null,"LSOL","Litres of solvent delivered per week"]
[6071,"2018-10-19",null,142,null,null,"KGDC","Weight of clothes cleaned per week"]
[6071,"2018-10-26",null,187,null,null,"DRUMS","Number of still residue drums removed per week"]
[6071,"2018-11-02",37.9,196]
[6071,"2018-11-09",null,140]
[6071,"2018-11-16",null,130]
[6071,"2018-11-23",null,101]
[6071,"2018-11-30",null,124]
[6071,"2018-12-07",null,134]
[6071,"2018-12-14",null,147]
[6071,"2018-12-21",null,150]
[6071,"2018-12-28",null,170]
[6071,"2019-01-04",null,118]
[6071,"2019-01-11",null,0]
[6071,"2019-01-18",null,80]
[6071,"2019-01-25",null,154]
[6071,"2019-02-01",37.9,155]
[6071,"2019-02-08",null,139]
[6071,"2019-02-15",null,145]
[6071,"2019-02-22",null,126]
[6071,"2019-03-01",null,129]
[6071,"2019-03-08",null,148]
[6071,"2019-03-15",null,15]
[6071,"2019-03-22",null,151]
[6071,"2019-03-29",null,145]
[6071,"2019-04-05",null,167]
[6071,"2019-04-12",37.9,123]
[6071,"2019-04-19",null,248]
[6071,"2019-04-26",null,183]
[6071,"2019-05-03",null,123]
[6071,"2019-05-10",null,126]
[6071,"2019-05-17",null,155]
[6071,"2019-05-24",null,181]
[6071,"2019-05-31",null,135]
[6071,"2019-06-07",37.9,184]
[6071,"2019-06-14",null,180]
[6071,"2019-06-21",null,131]
[6071,"2019-06-28",null,101]
[6071,"2019-07-05",null,165]
[6071,"2019-07-12",null,128]
[6071,"2019-07-19",null,119]
[6071,"2019-07-26",null,162]
[6071,"2019-08-02",null,130]
[6071,"2019-08-09",null,142,120]
[6071,"2019-08-16",null,163]
[6071,"2019-08-23",null,147]
[6071,"2019-08-30",null,10]
[6071,"2019-09-06",null,131]
[6071,"2019-09-13",null,190]
[6071,"2019-09-20",null,109]
[6071,"2019-09-27",null,148]
["Totals",null,{"$f":"SUM(C4:C55)","v":170.55},{"$f":"SUM(D4:D55)","v":7226},{"$f":"SUM(E4:E55)","v":120}]
[]
["Solvent used(delivered)  ",null,null,170.55]
["Weight of Dry Cleaning",null,null,7226]
["Residue removed  ",null,null,120]

{"sheet":"Solv Calc","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,6,1,6],[1,1,1,3],[16,0,16,4],[14,1,14,2],[4,0,4,5],[0,1,0,3],[0,4,1,5],[12,0,12,5],[10,1,10,2],[8,0,8,5],[6,1,6,2],[17,0,17,6],[33,0,36,2],[31,0,31,5],[35,3,36,3],[29,0,29,2],[21,0,23,2],[21,3,21,4],[22,3,23,4],[22,5,23,5],[19,0,19,5],[26,0,26,1],[26,3,26,4],[25,0,25,1],[25,3,25,4],[24,0,24,1],[24,3,24,4],[43,3,43,5],[40,0,40,1],[39,0,39,1],[38,0,38,1],[37,0,37,1]]}
["Site:","Branh 6071 Cannon Park Coventry",null,null,"Month and year:",null,"Oct 18 to Sept 19"]
["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"]
[7226,null,null,null,null,null,{"$f":"IF(SUM(A11:F11)>0.1,SUM(A11:F11),0)","v":7226}]
[]
["Solvent used (litres)",null,null,null,null,null,"Monthly Total (litres)"]
[null,null,null,null,null,null,"c"]
[170.55,null,null,null,null,null,{"$f":"IF(SUM(A15:F15)>0.1,SUM(A15:F15),0)","v":170.55}]
[]
["Estimated still residue for month (litres)",null,null,null,null,"d",120]
["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,{"$f":"IF(C25<>\"\",G17,0)","v":0},{"$f":"IF(F25>0.1,D25*F25,0)","v":0}]
["Ecological powder rake out",null,"x",0.35,null,{"$f":"IF(C26<>\"\",G17,0)","v":120},{"$f":"IF(F26>0.1,D26*F26,0)","v":42}]
["Pumped out",null,null,0.5,null,{"$f":"IF(C27<>\"\",G17,0)","v":0},{"$f":"IF(F27>0.1,D27*F27,0)","v":0}]
[{"$f":"IF((COUNTA(C25:C27))>1,\"Error, you have selected both types of still cleaning\",\"\")","v":""}]
[null,{"$f":"IF((COUNTA(C25:C27))<1,\"Select a method of still cleaning (see Instruction 2.5)\",\"\")","v":""}]
["Nominal Monthly Solvent Use",null,null,"(litres)","g = c - f",{"$f":"IF((G17+G15)>0.1,G15-(G25+G26+G27),0)","v":128.55000000000001}]
[null,null,null,null,null,{"$f":"IF(F30<0,\" Please check that you have entered all sovent used this month in row 15\",\"\")","v":""}]
["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,{"$f":"IF(C38<>\"\",IF(F$30<>0,G$11/F$30,\"\"),\"\")","v":""},{"$f":"IF(C38<>\"\",IF(F$30<>0,D38/E38,\"0\"),\"\")","v":""},{"$f":"IF(C38<>\"\",IF(F$30<>0,F$30*D38/1000,\"0\"),\"\")","v":""}]
["Siloxane",null,"x",970,{"$f":"IF(C39<>\"\",IF(F$30<>0,G$11/F$30,\"\"),\"\")","v":56.211590820692329},{"$f":"IF(C39<>\"\",IF(F$30<>0,D39/E39,\"0\"),\"\")","v":17.256227511763079},{"$f":"IF(C39<>\"\",IF(F$30<>0,F$30*D39/1000,\"0\"),\"\")","v":124.69350000000001}]
["Hydrocarbon",null,null,970,{"$f":"IF(C40<>\"\",IF(F$30<>0,G$11/F$30,\"\"),\"\")","v":""},{"$f":"IF(C40<>\"\",IF(F$30<>0,D40/E40,\"0\"),\"\")","v":""},{"$f":"IF(C40<>\"\",IF(F$30<>0,F$30*D40/1000,\"0\"),\"\")","v":""}]
["Other",null,null,null,{"$f":"IF(C41<>\"\",IF(F$30<>0,G$11/F$30,\"\"),\"\")","v":""},{"$f":"IF(C41<>\"\",IF(F$30<>0,D41/E41,\"0\"),\"\")","v":""},{"$f":"IF(C41<>\"\",IF(F$30<>0,F$30*D41/1000,\"0\"),\"\")","v":""}]
[{"$f":"IF((COUNTA(C38:C41))>1,\"Error, you have selected more than one type of solvent\",\"\")","v":""},null,null,null,{"$f":"IF(SUM(E38:E41)<0,\"Please ensure you have accounted for all solvent used this month\",\"\")","v":""},{"$f":"IF(F41=0,\"Enter the sg for your solvent\",\"\")","v":""}]
[null,{"$f":"IF((COUNTA(C38:C41))<1,\"Select a solvent type (see Instruction 2.6)\",\"\")","v":""}]
[{"$f":"SUM(G38:G41)","v":124.69350000000001},{"$f":"IF(C38<>\"\",1600,970)","v":970},null,"Solvent Usage Check : ",null,null,{"$f":"IF(SUM(F38:F41)<=20,\"OK\", \"PROBLEM\")","v":"OK"}]

{"sheet":"DEFRA Formula","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,2],[26,3,26,4],[26,9,26,10],[26,11,26,13],[23,3,23,4],[23,5,23,6],[23,11,23,13],[24,3,24,4],[24,5,24,6],[24,9,24,10],[24,11,24,13],[20,3,20,4],[20,5,20,6],[20,11,20,13],[21,0,22,0],[21,3,21,4],[21,5,21,6],[21,11,21,13],[22,3,22,4],[22,5,22,6],[22,11,22,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:","Branch 6071 Cannon Park Coventry",null,null,null,null,null,null,null,null,null,null,"Year:","Oct 18 to Sept 19"]
["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"]
[{"$f":"IF('[1]Monthly machine 1'!G$1<>\"\",'[1]Monthly machine 1'!G$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$G$11<>\"\",'[1]Monthly machine 1'!$G$11,\"\")","v":7226},{"$f":"IF('[1]Monthly machine 2'!$G$11<>\"\",'[1]Monthly machine 2'!$G$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$G$11<>\"\",'[1]Monthly machine 3'!$G$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$G$11<>\"\",'[1]Monthly machine 4'!$G$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$A$44<>\"\",'[1]Monthly machine 1'!$A$44,\"\")","v":124.69350000000001},{"$f":"IF('[1]Monthly machine 2'!$A$44<>\"\",'[1]Monthly machine 2'!$A$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$A$44<>\"\",'[1]Monthly machine 3'!$A$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$A$44<>\"\",'[1]Monthly machine 4'!$A$44,\"\")","v":0},{"$f":"IF(B7<>0,IF(F7<>0,(SUM(F7:I7))*1000/(SUM(B7:E7)),\"\"),\"\")","v":17.256227511763079},{"$f":"IF('[1]Monthly machine 1'!$G$17<>\"\",'[1]Monthly machine 1'!$G$17,\"\")","v":120},{"$f":"IF('[1]Monthly machine 2'!$G$17<>\"\",'[1]Monthly machine 2'!$G$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$G$17<>\"\",'[1]Monthly machine 3'!$G$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$G$17<>\"\",'[1]Monthly machine 4'!$G$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!O$1<>\"\",'[1]Monthly machine 1'!O$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$O$11<>\"\",'[1]Monthly machine 1'!$O$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$O$11<>\"\",'[1]Monthly machine 2'!$O$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$O$11<>\"\",'[1]Monthly machine 3'!$O$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$O$11<>\"\",'[1]Monthly machine 4'!$O$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$I$44<>\"\",'[1]Monthly machine 1'!$I$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$I$44<>\"\",'[1]Monthly machine 2'!$I$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$I$44<>\"\",'[1]Monthly machine 3'!$I$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$I$44<>\"\",'[1]Monthly machine 4'!$I$44,\"\")","v":0},{"$f":"IF(B8<>0,IF(F8<>0,(SUM(F8:I8))*1000/(SUM(B8:E8)),\"\"),\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$O$17<>\"\",'[1]Monthly machine 1'!$O$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$O$17<>\"\",'[1]Monthly machine 2'!$O$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$O$17<>\"\",'[1]Monthly machine 3'!$O$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$O$17<>\"\",'[1]Monthly machine 4'!$O$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!W$1<>\"\",'[1]Monthly machine 1'!W$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$W$11<>\"\",'[1]Monthly machine 1'!$W$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$W$11<>\"\",'[1]Monthly machine 2'!$W$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$W$11<>\"\",'[1]Monthly machine 3'!$W$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$W$11<>\"\",'[1]Monthly machine 4'!$W$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$Q$44<>\"\",'[1]Monthly machine 1'!$Q$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$Q$44<>\"\",'[1]Monthly machine 2'!$Q$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$Q$44<>\"\",'[1]Monthly machine 3'!$Q$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$Q$44<>\"\",'[1]Monthly machine 4'!$Q$44,\"\")","v":0},{"$f":"IF(B9<>0,IF(F9>0,(SUM(F9:I9))*1000/(SUM(B9:E9)),\"\"),\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$W$17<>\"\",'[1]Monthly machine 1'!$W$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$W$17<>\"\",'[1]Monthly machine 2'!$W$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$W$17<>\"\",'[1]Monthly machine 3'!$W$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$W$17<>\"\",'[1]Monthly machine 4'!$W$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!AE$1<>\"\",'[1]Monthly machine 1'!AE$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$AE$11<>\"\",'[1]Monthly machine 1'!$AE$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AE$11<>\"\",'[1]Monthly machine 2'!$AE$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AE$11<>\"\",'[1]Monthly machine 3'!$AE$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AE$11<>\"\",'[1]Monthly machine 4'!$AE$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$Y$44<>\"\",'[1]Monthly machine 1'!$Y$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$Y$44<>\"\",'[1]Monthly machine 2'!$Y$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$Y$44<>\"\",'[1]Monthly machine 3'!$Y$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$Y$44<>\"\",'[1]Monthly machine 4'!$Y$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$AE$17<>\"\",'[1]Monthly machine 1'!$AE$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$AE$17<>\"\",'[1]Monthly machine 2'!$AE$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$AE$17<>\"\",'[1]Monthly machine 3'!$AE$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$AE$17<>\"\",'[1]Monthly machine 4'!$AE$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!AM$1<>\"\",'[1]Monthly machine 1'!AM$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$AM$11<>\"\",'[1]Monthly machine 1'!$AM$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AM$11<>\"\",'[1]Monthly machine 2'!$AM$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AM$11<>\"\",'[1]Monthly machine 3'!$AM$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AM$11<>\"\",'[1]Monthly machine 4'!$AM$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$AG$44<>\"\",'[1]Monthly machine 1'!$AG$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AG$44<>\"\",'[1]Monthly machine 2'!$AG$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AG$44<>\"\",'[1]Monthly machine 3'!$AG$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AG$44<>\"\",'[1]Monthly machine 4'!$AG$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$AM$17<>\"\",'[1]Monthly machine 1'!$AM$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$AM$17<>\"\",'[1]Monthly machine 2'!$AM$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$AM$17<>\"\",'[1]Monthly machine 3'!$AM$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$AM$17<>\"\",'[1]Monthly machine 4'!$AM$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!AU$1<>\"\",'[1]Monthly machine 1'!AU$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$AU$11<>\"\",'[1]Monthly machine 1'!$AU$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AU$11<>\"\",'[1]Monthly machine 2'!$AU$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AU$11<>\"\",'[1]Monthly machine 3'!$AU$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AU$11<>\"\",'[1]Monthly machine 4'!$AU$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$AO$44<>\"\",'[1]Monthly machine 1'!$AO$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AO$44<>\"\",'[1]Monthly machine 2'!$AO$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AO$44<>\"\",'[1]Monthly machine 3'!$AO$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AO$44<>\"\",'[1]Monthly machine 4'!$AO$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$AU$17<>\"\",'[1]Monthly machine 1'!$AU$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$AU$17<>\"\",'[1]Monthly machine 2'!$AU$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$AU$17<>\"\",'[1]Monthly machine 3'!$AU$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$AU$17<>\"\",'[1]Monthly machine 4'!$AU$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!BC$1<>\"\",'[1]Monthly machine 1'!BC$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$BC$11<>\"\",'[1]Monthly machine 1'!$BC$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BC$11<>\"\",'[1]Monthly machine 2'!$BC$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BC$11<>\"\",'[1]Monthly machine 3'!$BC$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BC$11<>\"\",'[1]Monthly machine 4'!$BC$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$AW$44<>\"\",'[1]Monthly machine 1'!$AW$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$AW$44<>\"\",'[1]Monthly machine 2'!$AW$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$AW$44<>\"\",'[1]Monthly machine 3'!$AW$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$AW$44<>\"\",'[1]Monthly machine 4'!$AW$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$BC$17<>\"\",'[1]Monthly machine 1'!$BC$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$BC$17<>\"\",'[1]Monthly machine 2'!$BC$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$BC$17<>\"\",'[1]Monthly machine 3'!$BC$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$BC$17<>\"\",'[1]Monthly machine 4'!$BC$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!BK$1<>\"\",'[1]Monthly machine 1'!BK$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$BK$11<>\"\",'[1]Monthly machine 1'!$BK$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BK$11<>\"\",'[1]Monthly machine 2'!$BK$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BK$11<>\"\",'[1]Monthly machine 3'!$BK$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BK$11<>\"\",'[1]Monthly machine 4'!$BK$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$BE$44<>\"\",'[1]Monthly machine 1'!$BE$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BE$44<>\"\",'[1]Monthly machine 2'!$BE$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BE$44<>\"\",'[1]Monthly machine 3'!$BE$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BE$44<>\"\",'[1]Monthly machine 4'!$BE$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$BK$17<>\"\",'[1]Monthly machine 1'!$BK$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$BK$17<>\"\",'[1]Monthly machine 2'!$BK$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$BK$17<>\"\",'[1]Monthly machine 3'!$BK$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$BK$17<>\"\",'[1]Monthly machine 4'!$BK$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!BS$1<>\"\",'[1]Monthly machine 1'!BS$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$BS$11<>\"\",'[1]Monthly machine 1'!$BS$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BS$11<>\"\",'[1]Monthly machine 2'!$BS$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BS$11<>\"\",'[1]Monthly machine 3'!$BS$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BS$11<>\"\",'[1]Monthly machine 4'!$BS$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$BM$44<>\"\",'[1]Monthly machine 1'!$BM$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BM$44<>\"\",'[1]Monthly machine 2'!$BM$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BM$44<>\"\",'[1]Monthly machine 3'!$BM$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BM$44<>\"\",'[1]Monthly machine 4'!$BM$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$BS$17<>\"\",'[1]Monthly machine 1'!$BS$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$BS$17<>\"\",'[1]Monthly machine 2'!$BS$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$BS$17<>\"\",'[1]Monthly machine 3'!$BS$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$BS$17<>\"\",'[1]Monthly machine 4'!$BS$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!CA$1<>\"\",'[1]Monthly machine 1'!CA$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$CA$11<>\"\",'[1]Monthly machine 1'!$CA$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$CA$11<>\"\",'[1]Monthly machine 2'!$CA$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$CA$11<>\"\",'[1]Monthly machine 3'!$CA$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$CA$11<>\"\",'[1]Monthly machine 4'!$CA$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$BU$44<>\"\",'[1]Monthly machine 1'!$BU$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$BU$44<>\"\",'[1]Monthly machine 2'!$BU$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$BU$44<>\"\",'[1]Monthly machine 3'!$BU$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$BU$44<>\"\",'[1]Monthly machine 4'!$BU$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$CA$17<>\"\",'[1]Monthly machine 1'!$CA$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$CA$17<>\"\",'[1]Monthly machine 2'!$CA$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$CA$17<>\"\",'[1]Monthly machine 3'!$CA$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$CA$17<>\"\",'[1]Monthly machine 4'!$CA$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!CI$1<>\"\",'[1]Monthly machine 1'!CI$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$CI$11<>\"\",'[1]Monthly machine 1'!$CI$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$CI$11<>\"\",'[1]Monthly machine 2'!$CI$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$CI$11<>\"\",'[1]Monthly machine 3'!$CI$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$CI$11<>\"\",'[1]Monthly machine 4'!$CI$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$CC$44<>\"\",'[1]Monthly machine 1'!$CC$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$CC$44<>\"\",'[1]Monthly machine 2'!$CC$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$CC$44<>\"\",'[1]Monthly machine 3'!$CC$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$CC$44<>\"\",'[1]Monthly machine 4'!$CC$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$CI$17<>\"\",'[1]Monthly machine 1'!$CI$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$CI$17<>\"\",'[1]Monthly machine 2'!$CI$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$CI$17<>\"\",'[1]Monthly machine 3'!$CI$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$CI$17<>\"\",'[1]Monthly machine 4'!$CI$17,\"\")","v":""}]
[{"$f":"IF('[1]Monthly machine 1'!CQ$1<>\"\",'[1]Monthly machine 1'!CQ$1,\"\")","v":""},{"$f":"IF('[1]Monthly machine 1'!$CQ$11<>\"\",'[1]Monthly machine 1'!$CQ$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$CQ$11<>\"\",'[1]Monthly machine 2'!$CQ$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$CQ$11<>\"\",'[1]Monthly machine 3'!$CQ$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$CQ$11<>\"\",'[1]Monthly machine 4'!$CQ$11,\"\")","v":0},{"$f":"IF('[1]Monthly machine 1'!$CK$44<>\"\",'[1]Monthly machine 1'!$CK$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 2'!$CK$44<>\"\",'[1]Monthly machine 2'!$CK$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 3'!$CK$44<>\"\",'[1]Monthly machine 3'!$CK$44,\"\")","v":0},{"$f":"IF('[1]Monthly machine 4'!$CK$44<>\"\",'[1]Monthly machine 4'!$CK$44,\"\")","v":0},"",{"$f":"IF('[1]Monthly machine 1'!$CQ$17<>\"\",'[1]Monthly machine 1'!$CQ$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 2'!$CQ$17<>\"\",'[1]Monthly machine 2'!$CQ$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 3'!$CQ$17<>\"\",'[1]Monthly machine 3'!$CQ$17,\"\")","v":""},{"$f":"IF('[1]Monthly machine 4'!$CQ$17<>\"\",'[1]Monthly machine 4'!$CQ$17,\"\")","v":""}]
["Sub Totals",{"$f":"IF((SUM(B7:C18))>1,SUM(B7:B18),\"\")","v":7226},{"$f":"IF((SUM(C7:C18))>1,SUM(C7:C18),\"\")","v":""},{"$f":"IF((SUM(D7:D18))>1,SUM(D7:D18),\"\")","v":""},{"$f":"IF((SUM(E7:E18))>1,SUM(E7:E18),\"\")","v":""},{"$f":"IF((SUM(F7:F18))<>0,SUM(F7:F18),\"\")","v":124.69350000000001},{"$f":"IF((SUM(G7:G18))<>0,SUM(G7:G18),\"\")","v":""},{"$f":"IF((SUM(H7:H18))<>0,SUM(H7:H18),\"\")","v":""},{"$f":"IF((SUM(I7:I18))<>0,SUM(I7:I18),\"\")","v":""},null,{"$f":"IF((SUM(K7:K18))>1,SUM(K7:K18),\"\")","v":120},{"$f":"IF((SUM(L7:L18))>1,SUM(L7:L18),\"\")","v":""},{"$f":"IF((SUM(M7:M18))>1,SUM(M7:M18),\"\")","v":""},{"$f":"IF((SUM(N7:N18))>1,SUM(N7:N18),\"\")","v":""}]
[]
["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,{"$f":"SUM(B7:E18)","v":7226},null,{"$f":"SUM(F7:I18)+A25","v":130.94350000000003},null,null,null,"Annual result",null,{"$f":"IF(D25>1,F25*1000/D25,\"\")","v":18.121159701079439}]
[]
["Weight of work required to comply with regulations (kg):",null,null,{"$f":"F25*1000/20","v":6547.1750000000011},null,null,null,null,null,"Complies with Regulations?",null,{"$f":"IF(SUM($L$25)<=20,\"YES\", \"NO\")","v":"YES"}]