{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PES CHP Calculator","Annex I & IV","Annex II","Annex III","Background workings"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":1,"comments":1,"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":"PES CHP Calculator","index":0,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,4,5],[39,0,39,1],[23,3,23,5],[49,0,49,1],[31,0,31,2],[30,0,30,2],[5,3,5,5],[1,0,1,1],[14,0,14,1],[21,0,22,1],[25,0,25,1],[5,0,5,1],[3,0,3,1],[6,0,6,1],[9,0,9,1],[12,0,12,1],[2,0,2,1],[4,0,4,1]]}
[null,null,null,null,null,null,1]
["User Input - Please select ",null,1,null,null,null,null,"GWh to kWh"]
["CHP Data Approach",null,null,null,null,null,null,"MWh to kWh",null,null,3]
[null,null,null,"Information Provided By Applicant"]
[]
["Fuel Category",null,null,{"$f":"IF(C2=1,\"Operational Metered Data Approach\",\"Rated Values Approach\")","v":"Operational Metered Data Approach"}]
[null,null,null,"Figures","Action Required","Comment"]
[null,null,null,0,"User Input",{"$f":"IF(C2=1,\"Metered Annual Operational Hours\",\"Projected Annual Operational Hours\")","v":"Metered Annual Operational Hours"}]
[null,null,null,0,{"$f":"IF(C$2=1,\"User Input\",\"\")","v":"User Input"},{"$f":"IF(C2=1,\"Metered Annual [kWh] Electricity Generated Consumed On-Site\",\"\")","v":"Metered Annual [kWh] Electricity Generated Consumed On-Site"}]
["Type of Fuel Input into CHP unit",null,null,{"$f":"IF(C2=2,\"\",D9/D15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$2=1,\"Automated\",\"\")","v":"Automated"},{"$f":"IF(C2=1,\"Metered Annual Fuel Input [kWh] - NCV\",\"\")","v":"Metered Annual Fuel Input [kWh] - NCV"}]
[null,null,null,{"$f":"IF(C2=2,\"\",D10*D16)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$2=1,\"Automated\",\"\")","v":"Automated"},{"$f":"IF(C2=1,\"Metered Annual Useful Heat Generated Consumed on site[kWh]\",\"\")","v":"Metered Annual Useful Heat Generated Consumed on site[kWh]"},null,null,null,null,3]
[null,null,null,{"$f":"IF(C2=1,\"\",D8*D17)","v":""},{"$f":"IF(C$2=2,\"Automated\",\"\")","v":""},{"$f":"IF(C2=1,\"\",\"Projected Annual [kWh] Electricity Generated Consumed On-Site\")","v":""}]
[null,null,null,{"$f":"IF(C2=1,\"\",D12/D15)","v":""},{"$f":"IF(C$2=2,\"Automated\",\"\")","v":""},{"$f":"IF(C2=1,\"\",\"Projected Annual Fuel Input (kWh) - NCV\")","v":""}]
[null,null,null,{"$f":"IF(C2=1,\"\",D13*D16)","v":""},"",{"$f":"IF(C2=1,\"\",\"Projected Useful Heat Generated Consumed on site[kWh]\")","v":""},null,null,null,null,1]
["Year of Construction of CHP unit (make sure both are selected)",null,null,0,"User Input","Rated Electrical Efficiency",null,null,null,null,2]
[null,null,null,0,"User Input","Rated Thermal Efficiency"]
[null,null,null,0,"User Input",{"$f":"IF(C6=1,\"\",\"Rated Electrical Output kW of CHP Unit\")","v":"Rated Electrical Output kW of CHP Unit"}]
[]
[null,null,null,"Percentage of Heat Generated by CHP which is Dumped","User Input","Heat Dumped (%)"]
[]
[]
["Proposed Use of Heat generated by CHP unit",null,null,{"$f":"D20/D21","v":{"$error":"#DIV/0!"}},"Automated","Power to Heat Ratio"]
[]
[null,null,null,"Unit Converter"]
[null,null,null,"Input Original Figure Below(GWh/MWh)","Choose Convertion Option","Output kWh"]
["Onsite Voltage",null,null,0,null,{"$f":"IF(G1=1, D26*1000000,D26*1000)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,2]
[]
["Worked Calculation as per figure 1"]
["Calculation of Electricty and Heat Reference Values as per EU CHP Directive"]
["Grid Loss Correction Factor",null,{"$f":"INDEX('Background workings'!M41:M47,'PES CHP Calculator'!K33)","v":0.85099999999999998},"See Annex IV",null,null,null,null,null,null,7]
["Harmonised Reference Value fo Separate Electricty Production","(%)",{"$f":"VLOOKUP((INDEX('Background workings'!P3:P23,'PES CHP Calculator'!K11)),'Background workings'!D65:G92,'PES CHP Calculator'!K15+1,FALSE)","v":0.42},"See Annex I"]
["Climate Adjustment","(%)",6.0000000000000001E-3,"See Annex III"]
["Harmonised Reference Value fo Separate Heat Production","Ref Hh (%)",{"$f":"IF(K14=2,'Background workings'!R14,'Background workings'!R16)","v":0.65},"See Annex II"]
["Efficiency of grid electricity generation","Ref Eh (%)",{"$f":"IF(K3=3,(C34+C35)*C33,C33*C34)","v":0.36252599999999996},"See Annex I & IV, III"]
["Power to Heat Ratio","C",{"$f":"D22","v":{"$error":"#DIV/0!"}}]
[]
["CHP Unit"]
["Overall Efficiency ",{"$f":"IF(C2=1,D15+D16,D20+D21)","v":0}]
["Percentage of Heat Generated by CHP which is Dumped",{"$f":"D19","v":"Percentage of Heat Generated by CHP which is Dumped"},"%"]
["Heat load required (i.e. \"useful\")",{"$f":"IF(C2=1,D11*(1-B42),D14*(1-B42))","v":{"$error":"#DIV/0!"}},"kWh"]
["Electricty Generated",{"$f":"IF(C2=1,D9,D12)","v":0},"kWh"]
["Total Fuel input - CHP",{"$f":"IF(C2=1,D10,D13)","v":{"$error":"#DIV/0!"}},"kWh"]
["Useful heat out / total fuel input: CHP Hh",{"$f":"B43/B45","v":{"$error":"#DIV/0!"}},"%"]
["Electricity out / total fuel input: CHP Eh",{"$f":"B44/B45","v":{"$error":"#DIV/0!"}},"%"]
["PES",{"$f":"(1-1/(B46/C36+B47/C37))","v":{"$error":"#DIV/0!"}}]
[]
["Separate Production - Reference Units"]
["CHP Useful Heat / Ref Hŋ - Fuel Input to reference boiler (To produce CHP usefule heat)",{"$f":"B43/C36","v":{"$error":"#DIV/0!"}},"kWh"]
["Electricty Generated by CHP / Ref Eŋ - Fuel Input to reference Power plant (To produce CHP electricty )",{"$f":"B44/C37","v":0},"kWh"]
["Total Reference Input",{"$f":"B52+B51","v":{"$error":"#DIV/0!"}},"kWh"]
[]
["PES x Total Reference Input",{"$f":"B48*B53","v":{"$error":"#DIV/0!"}},"kWh"]
[null,null,null,{"$f":"B45/(1-B48)","v":{"$error":"#DIV/0!"}},"kWh"]
[null,null,null,{"$f":"B45*(B48/(1-B48))","v":{"$error":"#DIV/0!"}},"kWh"]
[]
[]
[]
[null,null,null,{"$f":"D57/1000000","v":{"$error":"#DIV/0!"}}]

{"sheet":"Annex I & IV","index":1,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,16,36,19],[1,1,3,9]]}
[]
[null,"Annex I & IV - 2015/2402/EU"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of En"]

{"sheet":"Annex II","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,3,9]]}
[]
[null,"Annex II - 2015/2402/EU"]

{"sheet":"Annex III","index":3,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,2,4,10],[16,14,17,15]]}
[]
[]
[null,null,"Annex III- 2015/2402/EU"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Climate Correction Calculation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"degC as per application "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"as per (a) (ii)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O20-O19","v":6},"Degrees Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,"Percentage Point per Degree diff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O22*O23","v":0.60000000000000009},"% - Climate adj factor "]

{"sheet":"Background workings","index":4,"n_rows":92,"n_cols":19,"rows_kept":92,"cut":false,"hidden":true,"merged":[[1,5,1,11],[2,5,2,7],[2,9,2,11]]}
["Solids",1,"Before 2016","Hot Water"]
["Liquids",2,"From 2016","Steam",null,"Year of Construction"]
["Gaseous",3,null,"Direct Use of Exhaust gases",null,"Before 2016",null,null,null,"From  2016",null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E5,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E14,IF('PES CHP Calculator'!K$3=3,'Background workings'!E20,'Background workings'!E28)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E5,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E14,IF('PES CHP Calculator'!K$3=3,'Background workings'!E20,'Background workings'!E28))))","v":"Natural gas, LPG, LNG and biomethane"}]
["Other",4,null,"Type of fuel",null,"Hot Water","Steam","Direct Use of Exhaust gases",".","Hot Water","Steam","Direct Use of Exhaust gases",null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E6,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E15,IF('PES CHP Calculator'!K$3=3,'Background workings'!E21,'Background workings'!E29)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E6,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E15,IF('PES CHP Calculator'!K$3=3,'Background workings'!E21,'Background workings'!E29))))","v":"Refinery gases hydrogen and synthesis gas"}]
[null,"Solids",1,null,"Hard coal including anthracite, bituminous coal, sub-bituminous coal, coke, semi-coke, pet coke",{"$f":"88/100","v":0.88},0.83,0.8,"Hard coal including anthracite, bituminous coal, sub-bituminous coal, coke, semi-coke, pet coke",0.88,0.83,0.8,"Hard coal including anthracite, bituminous coal, sub-bituminous coal, coke, semi-coke, pet coke",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E7,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E16,IF('PES CHP Calculator'!K$3=3,'Background workings'!E22,'Background workings'!E30)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E7,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E16,IF('PES CHP Calculator'!K$3=3,'Background workings'!E22,'Background workings'!E30))))","v":"Biogas produced from anaerobic digestion, landfill, and sewage treatment"}]
[null,"Solids",{"$f":"C5+1","v":2},null,"Lignite, lignite briquettes, shale oil",0.86,0.81,0.78,"Lignite, lignite briquettes, shale oil",0.86,0.81,0.78,"Lignite, lignite briquettes, shale oil",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E8,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E17,IF('PES CHP Calculator'!K$3=3,'Background workings'!E23,'Background workings'!E31)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E8,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E17,IF('PES CHP Calculator'!K$3=3,'Background workings'!E23,'Background workings'!E31))))","v":"Coke oven gas, blast furnace gas, mining gas, and other recovered gases (excluding refinery gas)"}]
[null,"Solids",{"$f":"C6+1","v":3},null,"Peat, peat briquettes",0.86,0.81,0.78,"Peat, peat briquettes",0.86,0.81,0.78,"Peat, peat briquettes",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E9,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E18,IF('PES CHP Calculator'!K$3=3,'Background workings'!E24,'Background workings'!E32)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E9,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E18,IF('PES CHP Calculator'!K$3=3,'Background workings'!E24,'Background workings'!E32))))","v":""}]
[null,"Solids",4,null,"Dry biomass including wood and other solid biomass including wood pellets and briquettes, dried woodchips, clean and dry waste wood, nut shells and olive and other stones",0.86,0.81,0.78,"Dry biomass including wood and other solid biomass including wood pellets and briquettes, dried woodchips, clean and dry waste wood, nut shells and olive and other stones",0.86,0.81,0.78,"Dry biomass including wood and other solid biomass including wood pellets and briquettes, dried woodchips, clean and dry waste wood, nut shells and olive and other stones",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E10,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E19,IF('PES CHP Calculator'!K$3=3,'Background workings'!E25,'Background workings'!D33)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E10,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E19,IF('PES CHP Calculator'!K$3=3,'Background workings'!E25,'Background workings'!D33))))","v":""}]
[null,"Solids",5,null,"Other solid biomass including all wood not included under S4 and black and brown liquor.",0.8,0.75,0.72,"Other solid biomass including all wood not included under S4 and black and brown liquor.",0.8,0.75,0.72,"Other solid biomass including all wood not included under S4 and black and brown liquor.",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E11,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E20,IF('PES CHP Calculator'!K$3=3,'Background workings'!E26,'Background workings'!D34)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E11,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E20,IF('PES CHP Calculator'!K$3=3,'Background workings'!E26,'Background workings'!D34))))","v":""}]
[null,"Solids",6,null,"Municipal and industrial waste (non-renewable) and renewable/bio-degradable waste",0.8,0.75,0.72,"Municipal and industrial waste (non-renewable) and renewable/bio-degradable waste",0.8,0.75,0.72,"Municipal and industrial waste (non-renewable) and renewable/bio-degradable waste",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E12,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E21,IF('PES CHP Calculator'!K$3=3,'Background workings'!E27,'Background workings'!D35)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E12,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E21,IF('PES CHP Calculator'!K$3=3,'Background workings'!E27,'Background workings'!D35))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E13,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E22,IF('PES CHP Calculator'!K$3=3,'Background workings'!E28,'Background workings'!D36)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E13,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E22,IF('PES CHP Calculator'!K$3=3,'Background workings'!E28,'Background workings'!D36))))","v":"Waste heat (including high temperature process exhaust gases, product from exothermic chemical reactions)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E14,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E23,IF('PES CHP Calculator'!K$3=3,'Background workings'!E29,'Background workings'!D37)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E14,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E23,IF('PES CHP Calculator'!K$3=3,'Background workings'!E29,'Background workings'!D37))))","v":"Nuclear"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E15,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E24,IF('PES CHP Calculator'!K$3=3,'Background workings'!E30,'Background workings'!D38)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E15,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E24,IF('PES CHP Calculator'!K$3=3,'Background workings'!E30,'Background workings'!D38))))","v":"Solar thermal"}]
[null,"Liquids",{"$f":"C10+1","v":7},null,"Heavy fuel oil, gas/diesel oil, other oil products",0.89,0.84,0.81,"Heavy fuel oil, gas/diesel oil, other oil products",0.85,0.8,0.77,"Heavy fuel oil, gas/diesel oil, other oil products",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E16,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E25,IF('PES CHP Calculator'!K$3=3,'Background workings'!E31,'Background workings'!D39)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E16,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E25,IF('PES CHP Calculator'!K$3=3,'Background workings'!E31,'Background workings'!D39))))","v":"Geothermal"},{"$f":"IF('PES CHP Calculator'!K14=1,\"Before 2016\",\"From 2016\")","v":"Before 2016"},{"$f":"VLOOKUP(INDEX(P3:P8,'PES CHP Calculator'!K11), I4:L32,'PES CHP Calculator'!K29+1,FALSE)","v":0.75},1]
[null,"Liquids",8,null,"Bio-liquids including bio-methanol, bioethanol, bio-butanol, biodiesel and other bio-liquids",0.89,0.84,0.81,"Bio-liquids including bio-methanol, bioethanol, bio-butanol, biodiesel and other bio-liquids",0.85,0.8,0.77,"Bio-liquids including bio-methanol, bioethanol, bio-butanol, biodiesel and other bio-liquids",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E17,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E26,IF('PES CHP Calculator'!K$3=3,'Background workings'!E32,'Background workings'!D40)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E17,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E26,IF('PES CHP Calculator'!K$3=3,'Background workings'!E32,'Background workings'!D40))))","v":"Other fuels not mentioned"}]
[null,"Liquids",{"$f":"9","v":9},null,"Waste liquids including biodegradable and non-renewable waste (including tallow, fat and spent grain)",0.8,0.75,0.72,"Waste liquids including biodegradable and non-renewable waste (including tallow, fat and spent grain)",0.75,0.7,0.67,"Waste liquids including biodegradable and non-renewable waste (including tallow, fat and spent grain)",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E18,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E27,IF('PES CHP Calculator'!K$3=3,'Background workings'!D33,'Background workings'!D41)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E18,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E27,IF('PES CHP Calculator'!K$3=3,'Background workings'!D33,'Background workings'!D41))))","v":""},{"$f":"IF('PES CHP Calculator'!K16=1,\"Before 2016\",\"From 2016\")","v":"From 2016"},{"$f":"VLOOKUP(INDEX(P3:P8,'PES CHP Calculator'!K11), 'Background workings'!E4:H32,'PES CHP Calculator'!K29+1,FALSE)","v":0.65},2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E19,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E28,IF('PES CHP Calculator'!K$3=3,'Background workings'!D34,'Background workings'!D42)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E19,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E28,IF('PES CHP Calculator'!K$3=3,'Background workings'!D34,'Background workings'!D42))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E20,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E29,IF('PES CHP Calculator'!K$3=3,'Background workings'!D35,'Background workings'!D43)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E20,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E29,IF('PES CHP Calculator'!K$3=3,'Background workings'!D35,'Background workings'!D43))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E21,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E30,IF('PES CHP Calculator'!K$3=3,'Background workings'!D36,'Background workings'!D44)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E21,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E30,IF('PES CHP Calculator'!K$3=3,'Background workings'!D36,'Background workings'!D44))))","v":""}]
[null,"Gaseous",{"$f":"9+1","v":10},null,"Natural gas, LPG, LNG and biomethane",0.9,0.85,0.82,"Natural gas, LPG, LNG and biomethane",0.92,0.87,0.84,"Natural gas, LPG, LNG and biomethane",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E22,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E31,IF('PES CHP Calculator'!K$3=3,'Background workings'!D37,'Background workings'!D45)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E22,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E31,IF('PES CHP Calculator'!K$3=3,'Background workings'!D37,'Background workings'!D45))))","v":""}]
[null,"Gaseous",{"$f":"C20+1","v":11},null,"Refinery gases hydrogen and synthesis gas",0.89,0.84,0.81,"Refinery gases hydrogen and synthesis gas",0.9,0.85,0.82,"Refinery gases hydrogen and synthesis gas",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E23,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E32,IF('PES CHP Calculator'!K$3=3,'Background workings'!D38,'Background workings'!D46)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E23,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E32,IF('PES CHP Calculator'!K$3=3,'Background workings'!D38,'Background workings'!D46))))","v":""}]
[null,"Gaseous",{"$f":"C21+1","v":12},null,"Biogas produced from anaerobic digestion, landfill, and sewage treatment",0.7,0.65,0.62,"Biogas produced from anaerobic digestion, landfill, and sewage treatment",0.8,0.75,0.72,"Biogas produced from anaerobic digestion, landfill, and sewage treatment",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E24,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D33,IF('PES CHP Calculator'!K$3=3,'Background workings'!D39,'Background workings'!D47)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E24,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D33,IF('PES CHP Calculator'!K$3=3,'Background workings'!D39,'Background workings'!D47))))","v":""}]
[null,"Gaseous",13,null,"Coke oven gas, blast furnace gas, mining gas, and other recovered gases (excluding refinery gas)",0.8,0.75,0.72,"Coke oven gas, blast furnace gas, mining gas, and other recovered gases (excluding refinery gas)",0.8,0.75,0.72,"Coke oven gas, blast furnace gas, mining gas, and other recovered gases (excluding refinery gas)",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E25,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D34,IF('PES CHP Calculator'!K$3=3,'Background workings'!D40,'Background workings'!D48)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E25,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D34,IF('PES CHP Calculator'!K$3=3,'Background workings'!D40,'Background workings'!D48))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E26,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D35,IF('PES CHP Calculator'!K$3=3,'Background workings'!D41,'Background workings'!D49)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E26,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D35,IF('PES CHP Calculator'!K$3=3,'Background workings'!D41,'Background workings'!D49))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E27,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D36,IF('PES CHP Calculator'!K$3=3,'Background workings'!D42,'Background workings'!D50)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E27,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D36,IF('PES CHP Calculator'!K$3=3,'Background workings'!D42,'Background workings'!D50))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E28,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D37,IF('PES CHP Calculator'!K$3=3,'Background workings'!D43,'Background workings'!D51)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E28,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D37,IF('PES CHP Calculator'!K$3=3,'Background workings'!D43,'Background workings'!D51))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E29,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D38,IF('PES CHP Calculator'!K$3=3,'Background workings'!D44,'Background workings'!D52)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E29,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D38,IF('PES CHP Calculator'!K$3=3,'Background workings'!D44,'Background workings'!D52))))","v":""}]
[null,"Other",14,null,"Waste heat (including high temperature process exhaust gases, product from exothermic chemical reactions)",0,0,0,"Waste heat (including high temperature process exhaust gases, product from exothermic chemical reactions)",0.92,0.87,0,"Waste heat (including high temperature process exhaust gases, product from exothermic chemical reactions)",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E30,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D39,IF('PES CHP Calculator'!K$3=3,'Background workings'!D45,'Background workings'!D53)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E30,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D39,IF('PES CHP Calculator'!K$3=3,'Background workings'!D45,'Background workings'!D53))))","v":""}]
[null,"Other",15,null,"Nuclear",0,0,0,"Nuclear",0.92,0.87,0,"Nuclear",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E31,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D40,IF('PES CHP Calculator'!K$3=3,'Background workings'!D46,'Background workings'!D54)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E31,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D40,IF('PES CHP Calculator'!K$3=3,'Background workings'!D46,'Background workings'!D54))))","v":""}]
[null,"Other",16,null,"Solar thermal",0,0,0,"Solar thermal",0.92,0.87,0,"Solar thermal",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E32,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D41,IF('PES CHP Calculator'!K$3=3,'Background workings'!D47,'Background workings'!D55)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E32,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D41,IF('PES CHP Calculator'!K$3=3,'Background workings'!D47,'Background workings'!D55))))","v":""}]
[null,"Other",17,null,"Geothermal",0,0,0,"Geothermal",0.92,0.87,0,"Geothermal",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D33,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D42,IF('PES CHP Calculator'!K$3=3,'Background workings'!D48,'Background workings'!D56)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D33,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D42,IF('PES CHP Calculator'!K$3=3,'Background workings'!D48,'Background workings'!D56))))","v":""}]
[null,"Other",18,null,"Other fuels not mentioned",0,0,0,"Other fuels not mentioned",0.92,0.87,0,"Other fuels not mentioned",null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D34,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D43,IF('PES CHP Calculator'!K$3=3,'Background workings'!D49,'Background workings'!D57)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D34,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D43,IF('PES CHP Calculator'!K$3=3,'Background workings'!D49,'Background workings'!D57))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D35,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D44,IF('PES CHP Calculator'!K$3=3,'Background workings'!D50,'Background workings'!D58)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D35,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D44,IF('PES CHP Calculator'!K$3=3,'Background workings'!D50,'Background workings'!D58))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metered data",{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D36,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D45,IF('PES CHP Calculator'!K$3=3,'Background workings'!D51,'Background workings'!D59)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D36,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D45,IF('PES CHP Calculator'!K$3=3,'Background workings'!D51,'Background workings'!D59))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Metered Data",{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D37,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D46,IF('PES CHP Calculator'!K$3=3,'Background workings'!D52,'Background workings'!D60)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D37,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D46,IF('PES CHP Calculator'!K$3=3,'Background workings'!D52,'Background workings'!D60))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D38,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D47,IF('PES CHP Calculator'!K$3=3,'Background workings'!D53,'Background workings'!D61)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D38,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D47,IF('PES CHP Calculator'!K$3=3,'Background workings'!D53,'Background workings'!D61))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!D39,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D48,IF('PES CHP Calculator'!K$3=3,'Background workings'!D54,'Background workings'!D62)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!D39,IF('PES CHP Calculator'!K$3=2, 'Background workings'!D48,IF('PES CHP Calculator'!K$3=3,'Background workings'!D54,'Background workings'!D62))))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Voltage","Corection Factor"]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 345 kV",0.97599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 200 - < 345 kV",0.96299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 100 - <200 kV",0.95099999999999996]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 50 - < 100 kV",0.93600000000000005]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 12 - < 50 kV",0.91400000000000003]
[null,null,null,null,null,null,null,null,null,null,null,"≥ 0.45 - < 12 kV",0.89100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"<0.45 kV",0.85099999999999998]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"≥"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Before 2012",null,null,null,"Before 2012","2012 - 2015","From 2016"]
["2012 - 2015","Solids",1,"Hard coal including anthracite, bituminous coal, sub-bituminous coal, coke, semi-coke, pet coke",0.442,0.442,0.442]
["From 2016","Solids",{"$f":"C65+1","v":2},"Lignite, lignite briquettes, shale oil",0.41799999999999998,0.41799999999999998,0.41799999999999998,null,null,null,null,null,{"$f":"IF(IF('PES CHP Calculator'!K$3=1,'Background workings'!E5,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E14,IF('PES CHP Calculator'!K$3=3,'Background workings'!E20,'Background workings'!E28)))=0,\"\",IF('PES CHP Calculator'!K$3=1,'Background workings'!E5,IF('PES CHP Calculator'!K$3=2, 'Background workings'!E14,IF('PES CHP Calculator'!K$3=3,'Background workings'!E20,'Background workings'!E28))))","v":"Natural gas, LPG, LNG and biomethane"}]
[null,"Solids",{"$f":"C66+1","v":3},"Peat, peat briquettes",0.39,0.39,0.39]
[null,"Solids",4,"Dry biomass including wood and other solid biomass including wood pellets and briquettes, dried woodchips, clean and dry waste wood, nut shells and olive and other stones",0.33,0.33,0.37]
[null,"Solids",5,"Other solid biomass including all wood not included under S4 and black and brown liquor.",0.25,0.25,0.3]
[null,"Solids",6,"Municipal and industrial waste (non-renewable) and renewable/bio-degradable waste",0.25,0.25,0.25]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,"Liquids",{"$f":"C70+1","v":7},"Heavy fuel oil, gas/diesel oil, other oil products",0.442,0.442,0.442]
[null,"Liquids",8,"Bio-liquids including bio-methanol, bioethanol, bio-butanol, biodiesel and other bio-liquids",0.442,0.442,0.442]
[null,"Liquids",{"$f":"9","v":9},"Waste liquids including biodegradable and non-renewable waste (including tallow, fat and spent grain)",0.25,0.25,0.28999999999999998]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,"Gaseous",{"$f":"9+1","v":10},"Natural gas, LPG, LNG and biomethane",0.52500000000000002,0.52500000000000002,0.53]
[null,"Gaseous",{"$f":"C80+1","v":11},"Refinery gases hydrogen and synthesis gas",0.442,0.442,0.442]
[null,"Gaseous",{"$f":"C81+1","v":12},"Biogas produced from anaerobic digestion, landfill, and sewage treatment",0.42,0.42,0.42]
[null,"Gaseous",13,"Coke oven gas, blast furnace gas, mining gas, and other recovered gases (excluding refinery gas)",0.35,0.35,0.35]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,null,null,null,"-","-","-"]
[null,"Other",14,"Waste heat (including high temperature process exhaust gases, product from exothermic chemical reactions)",0,0,0.3]
[null,"Other",15,"Nuclear",0,0,0.33]
[null,"Other",16,"Solar thermal",0,0,0.3]
[null,"Other",17,"Geothermal",0,0,0.19500000000000001]
[null,"Other",18,"Other fuels not mentioned",0,0,0.3]