676INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Heating3635932INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Commercial heating and cooling133782513361811IX.c.Scenario.Demand21832IX.c.Scenario.Electrification31833IX.c.Scenario.Fuel318271829123418311414371798182212255961572179911514123180010813164180132411830INDEX($E$17:$H$20, MATCH($E$9, $C$17:$C$20, 0), MATCH($E$10, $E$15:$H$15, 0))1313381809Preferences.EnergyUnitsTWh13368044220072010201520202025203020352040204520501114(Unit.TWh)*74.5831688969274.58316889692(Unit.TWh)*76.860006585420776.860006585420706(Unit.TWh)*80.925923017145280.925923017145195(Unit.TWh)*85.352456869228185.352456869228106(Unit.TWh)*90.166329960749590.166329960749493(Unit.TWh)*95.396357697831595.396357697831505(Unit.TWh)*101.07361017105101.07361017105001(Unit.TWh)*107.231585720509107.231585720509(Unit.TWh)*113.906397931695113.906397931695(Unit.TWh)*121.136977099682121.1369770996822114(Unit.TWh)*74.5831688969274.58316889692(Unit.TWh)*73.307227955889773.307227955889701(Unit.TWh)*72.759717149155572.759717149155506(Unit.TWh)*73.722595700882273.722595700882195(Unit.TWh)*75.824364071713475.824364071713404(Unit.TWh)*78.821519640525378.821519640525295(Unit.TWh)*82.558069154870882.558069154870793(Unit.TWh)*86.938110587379886.938110587379796(Unit.TWh)*91.907286159238291.907286159238197(Unit.TWh)*97.440258462210197.4402584622100963114(Unit.TWh)*74.5831688969274.58316889692(Unit.TWh)*73.240231623450273.2402316234502(Unit.TWh)*71.640191422356871.640191422356807(Unit.TWh)*70.760791376441970.760791376441901(Unit.TWh)*70.528817531086170.528817531086105(Unit.TWh)*70.886142237593570.886142237593504(Unit.TWh)*71.787523750112171.787523750112101(Unit.TWh)*73.198782739488573.198782739488493(Unit.TWh)*75.095295962400675.095295962400598(Unit.TWh)*77.460757152093477.4607571520933934114(Unit.TWh)*74.5831688969274.58316889692(Unit.TWh)*72.936152802307972.936152802307902(Unit.TWh)*70.364786290956270.364786290956204(Unit.TWh)*68.002068136215568.002068136215499(Unit.TWh)*65.839225339429965.839225339429902(Unit.TWh)*63.868497963347563.868497963347501(Unit.TWh)*62.083097593698762.083097593698703(Unit.TWh)*60.477171213498760.4771712134987(Unit.TWh)*59.045770284555359.045770284555303(Unit.TWh)*57.784824859997857.7848248599977981810Preferences.EnergyUnitsTWh133680442200720102015202020252030203520402045205011603(Unit.TWh)*13.498601739099713.4986017390997(Unit.TWh)*13.910680303690113.9106803036901(Unit.TWh)*14.646559288560814.6465592885608(Unit.TWh)*15.447705424312915.4477054243129(Unit.TWh)*16.318955019175616.318955019175601(Unit.TWh)*17.265523293914417.265523293914399(Unit.TWh)*18.293033538406918.293033538406899(Unit.TWh)*19.407548524705619.4075485247056(Unit.TWh)*20.615604350901520.615604350901499(Unit.TWh)*21.924246903574121.92424690357410121603(Unit.TWh)*13.498601739099713.4986017390997(Unit.TWh)*13.58917650801813.589176508017999(Unit.TWh)*13.907569766113513.9075697661135(Unit.TWh)*14.395277198787314.3952771987873(Unit.TWh)*15.02109862238315.021098622383001(Unit.TWh)*15.765606213863315.7656062138633(Unit.TWh)*16.617495224214316.617495224214299(Unit.TWh)*17.571118517936617.571118517936601(Unit.TWh)*18.624825111950418.6248251119504(Unit.TWh)*19.779845075778219.77984507577820131603(Unit.TWh)*13.498601739099713.4986017390997(Unit.TWh)*13.494376484780613.4943764847806(Unit.TWh)*13.582111562524413.5821115625244(Unit.TWh)*13.780457504903713.780457504903699(Unit.TWh)*14.082360484892514.082360484892501(Unit.TWh)*14.482725729604214.4827257296042(Unit.TWh)*14.978162718569614.9781627185696(Unit.TWh)*15.566776687394515.566776687394499(Unit.TWh)*16.247999289984516.247999289984499(Unit.TWh)*17.022452463286117.02245246328610141603(Unit.TWh)*13.498601739099713.4986017390997(Unit.TWh)*13.485425414334713.485425414334699(Unit.TWh)*13.506731701457413.506731701457401(Unit.TWh)*13.58267296948213.582672969481999(Unit.TWh)*13.714149083581913.7141490835819(Unit.TWh)*13.902357586805113.902357586805101(Unit.TWh)*14.148800474792214.1488004747922(Unit.TWh)*14.455292663692114.4552926636921(Unit.TWh)*14.82397219747414.823972197473999(Unit.TWh)*15.257312250542415.25731225054241817Preferences.EnergyUnitsTWh133680442200720102015202020252030203520402045205011604(Unit.TWh)*27.338359407609827.338359407609801(Unit.TWh)*33.137251501941733.137251501941698(Unit.TWh)*42.573813220197242.573813220197202(Unit.TWh)*51.746160510585451.746160510585398(Unit.TWh)*60.67884288375260.678842883751997(Unit.TWh)*69.396689702337969.396689702337895(Unit.TWh)*77.924884326868777.924884326868707(Unit.TWh)*86.2890423830586.289042383050003(Unit.TWh)*94.515294516459994.515294516459903(Unit.TWh)*102.630374027547102.6303740275470121604(Unit.TWh)*27.338359407609827.338359407609801(Unit.TWh)*28.085133661803228.085133661803201(Unit.TWh)*29.667482565293629.6674825652936(Unit.TWh)*31.595890898168331.5958908981683(Unit.TWh)*33.801741623778733.801741623778703(Unit.TWh)*36.234837873676436.234837873676398(Unit.TWh)*38.860153437679238.860153437679202(Unit.TWh)*41.654857696456541.654857696456503(Unit.TWh)*44.605782233169444.6057822331694(Unit.TWh)*47.707361018467447.70736101846740231604(Unit.TWh)*27.338359407609827.338359407609801(Unit.TWh)*26.824975462522826.824975462522801(Unit.TWh)*26.206840387526226.206840387526199(Unit.TWh)*25.856606686486525.856606686486501(Unit.TWh)*25.746761082464625.746761082464602(Unit.TWh)*25.8554599126925.855459912690002(Unit.TWh)*26.165694272084726.1656942720847(Unit.TWh)*26.664598848977426.664598848977398(Unit.TWh)*27.342881495458327.3428814954583(Unit.TWh)*28.19435437306128.19435437306141604(Unit.TWh)*27.338359407609827.338359407609801(Unit.TWh)*25.979166729248625.9791667292486(Unit.TWh)*23.865187133718523.8651871337185(Unit.TWh)*21.929309816379621.9293098163796(Unit.TWh)*20.159826331781120.159826331781101(Unit.TWh)*18.546136985059518.546136985059501(Unit.TWh)*17.078671275131617.078671275131601(Unit.TWh)*15.748815851086215.748815851086199(Unit.TWh)*14.54884944024614.548849440246(Unit.TWh)*13.471884255739913.47188425573991804839838269131125413108167156141211270212710.91E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-338400.10.10.17.0000000000000007E-2484258410.10.10.10.10.050.150.05612730.10.190.190.24716010.90.20.16812740.60.550000000000000040.50.60.579999999999999960.180.250.14000000000000001912750.30.300.30.20.30.30.30.30.250.20.251030.010.010.010.010.011117960.150.330.130.30.240.150.231217970.20.70.450.20.330.350.630.250.231312760.030.117.0000000000000007E-27.0000000000000007E-27.0000000000000007E-27.0000000000000007E-20.117.0000000000000007E-20.117.0000000000000007E-21481SUM(F55:F67)1.00099999999999991.00099999999999991.00100000000000011.00099999999999991.00099999999999991.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011.00100000000000011805839838269131125413108167156141212246222471111110.970.880.930.930.930.920.880.920.890.92318060.030.127.0000000000000007E-27.0000000000000007E-27.0000000000000007E-20.080.120.080.110.08148SUM(E$73:E$75)11111111111111117178861091818181978437161*Unit.GW1Preferences.PowerUnits&"/degree temperature drop assuming no change in insulation"GW/degree temperature drop assuming no change in insulation18121606792007201020152020202520302035204020452050160500.010.040.080.080.080.080.080.080.0812681272INDEX(Vectors[Description], MATCH(F96, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G96, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H96, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I96, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J96, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K96, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L96, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M96, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N96, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$55:$D$67, MATCH($C97, $C$55:$C$67, 0))Gas boiler (old)-10.760.24SUM(F97:N97)02INDEX($D$55:$D$67, MATCH($C98, $C$55:$C$67, 0))Gas boiler (new)-10.910.0903Resisitive heating-11004Oil-fired boiler-10.970.03-2.7755575615628914E-175Solid-fuel boiler-10.870.1306Stirling engine μCHP0.22500000000000001-10.630.1449999999999999907Fuel-cell μCHP0.45-10.450.108Air-source heat pump-1-2309Ground-source heat pump-1-34010Geothermal-10.850.15011Community scale gas CHP0.38-10.380.24012Community scale solid-fuel CHP0.17-10.569999999999999950.26013District heating from power stations-10.90.1012691272INDEX(Vectors[Description], MATCH(F114, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G114, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H114, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I114, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J114, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K114, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L114, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M114, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N114, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$55:$D$67, MATCH($C115, $C$55:$C$67, 0))Gas boiler (old)-10.760.24SUM(F115:N115)02Gas boiler (new)-10.910.0903Resisitive heating-11004Oil-fired boiler-10.970.03-2.7755575615628914E-175Solid-fuel boiler-10.870.1306Stirling engine μCHP0.22500000000000001-10.630.1449999999999999907Fuel-cell μCHP0.45-10.450.108Air-source heat pump-1-1209Ground-source heat pump-1-23010Geothermal-10.850.15011Community scale gas CHP0.38-10.380.24012Community scale solid-fuel CHP0.17-10.569999999999999950.26013District heating from power stations-10.90.1036851272INDEX(Vectors[Description], MATCH(F132, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G132, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H132, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I132, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J132, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K132, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L132, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M132, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N132, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$55:$D$67, MATCH($C133, $C$55:$C$67, 0))Gas boiler (old)F970G97000-1000.760.2402Gas boiler (new)F980000-1000.910.0903Resisitive heating-10000001004Oil-fired boiler000-10000.970.03-2.7755575615628914E-175Solid-fuel boiler11700-100000.870.1306Stirling engine μCHP00.2250000000000000100-1000.630.1449999999999999907Fuel-cell μCHP00.4500-1000.450.108Air-source heat pump-100000-M140-F140-1.7000000000000002M104*90%2.7009Ground-source heat pump-100000-M141-F141-2.96M105*99%3.960010Geothermal000000-10.850.15011Community scale gas CHP00.3800-1000.380.24012Community scale solid-fuel CHP00.17-100000.569999999999999950.26013District heating from power stations46200000-100.90.1036841272INDEX(Vectors[Description], MATCH(F150, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G150, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H150, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I150, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J150, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K150, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L150, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M150, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N150, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$55:$D$67, MATCH($C151, $C$55:$C$67, 0))Gas boiler (old)F1150G115000-1000.760.2402Gas boiler (new)F1160000-1000.910.0903Resisitive heating-10000001004Oil-fired boiler000-10000.970.03-2.7755575615628914E-175Solid-fuel boiler11700-100000.870.1306Stirling engine μCHP11800.2250000000000000100-1000.630.1449999999999999907Fuel-cell μCHP11800.4500-1000.450.108Air-source heat pump-100000-M158-F158-0.8M122*90%1.8009Ground-source heat pump-100000-M159-F159-1.9699999999999998M123*99%2.96999999999999980010Geothermal000000-10.850.15011Community scale gas CHP00.3800-1000.380.24012Community scale solid-fuel CHP00.17-100000.569999999999999950.26013District heating from power stations46200000-100.90.1018071272INDEX(Vectors[Description], MATCH(F$168, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$168, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$168, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$168, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$168, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$168, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$168, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$168, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$168, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$73:$D$75, MATCH($C169, $C$73:$C$75, 0))Electric air conditioner (old)-1-1.52.5SUM(F169:N169)02INDEX($D$73:$D$75, MATCH($C170, $C$73:$C$75, 0))Electric air conditioner (new)-1-56SUM(F170:N170)03INDEX($D$73:$D$75, MATCH($C171, $C$73:$C$75, 0))Absorption chiller-10.30.7SUM(F171:N171)016158312374422007123612381INDEX($D$55:$D$67, MATCH($C176, $C$55:$C$67, 0))Gas boiler (old)0.550000000000000040.920072Gas boiler (new)0.150.920073Resisitive heating0.2120154Oil-fired boiler0.10.7420075Solid-fuel boiler00.7420076Stirling engine μCHP00.920157Fuel-cell μCHP00.920158Air-source heat pump0120159Ground-source heat pump00.28999999999999998201510Geothermal00.01201511Community scale gas CHP00.68201012Community scale solid-fuel CHP00.68201013District heating from power stations00.42015148SUM(F176:F188)1.00000000000000028312374422007123612381INDEX($D$73:$D$75, MATCH($C192, $C$73:$C$75, 0))Electric air conditioner (old)1120072INDEX($D$73:$D$75, MATCH($C193, $C$73:$C$75, 0))Electric air conditioner (new)0120103INDEX($D$73:$D$75, MATCH($C194, $C$73:$C$75, 0))Absorption chiller012015148SUM(F$192:F$194)17171607109161631703235336633673368336933701799337017993370179912709.51299999999999999.51299999999999990.475600000000000020.4756000000000000200127110.969.51299999999999990.475600000000000020.47560000000000002008409.90879999999999947.92699999999999960.237999999999999990.23799999999999999008427.92699999999999967.92699999999999960.554899999999999950.55489999999999995008416.34199999999999966.34199999999999960.634199999999999990.6341999999999999900127474740.220.2200127574740.220.220022461201200.725500000000000030.725500000000000030022471201200.725500000000000030.725500000000000030018061801800.725500000000000030.7255000000000000300336633673368337133701799337017993370179912732227.51182.22121.5121.5003372287211480000321162116434300179610005507.940.430017973000781.255013.13001276800600160.430033663367336833733370179933701799337017991273000000337200004.964.963000000179600005.220.72179700001.541.54127600000.970.973374838392007201020152020202520302035204020452050112700.80.80.80.80.80.80.80.80.80.8212710.850.90.90.90.90.90.90.90.90.938400.90.90.90.90.90.90.90.90.90.948420.750.750.750.750.750.750.750.750.750.7558410.540.540.540.540.540.540.540.540.540.54612730.70.70.70.70.70.70.70.70.70.7733720.70.70.70.70.70.70.70.70.70.7812742.18000000000000022.18000000000000022.49000000000000023333333912752.18000000000000022.18000000000000022.490000000000000233333331030.640.640.640.640.640.640.640.640.640.641117960.690.690.690.690.690.690.690.690.690.691217970.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000040.550000000000000041312760.640.640.640.640.640.640.640.640.640.641224633.33.633.633.633.633.633.633.633.632224733.33.633.633.633.633.633.633.633.63318064.54.54.54.54.54.54.54.54.54.533753376180117993176104999.83443734716104999.8344373471631775249.43984635785825249.439846357858233773376180117993176120971.11168225846104999.8344373471631775249.43984635785825249.439846357858233783376180117993176109368.4809705440487494.34327602763431772626.92742521692622626.92742521692623379337618011799317687494.34327602763487494.34327602763431776124.71440442383396124.71440442383393380337618011799317669999.88962489810469999.88962489810431776999.98896248980966999.988962489809633813382180117993176111375591113177607560753383338218011799317614360057399.99999999999331770033843385180117993176700093.50347918086700093.5034791808631772081.35906439756492081.359064397564933863385180117993176700093.50347918086700093.5034791808631772081.35906439756492081.35906439756493387338818011799317610580000010580000031772150000215000033893390180117993176100000055000031777939.9999999999991430339133901801179931763000000781250317750000131303392339318011799317680000060000031771600043033943382180117993176189214.46039977862189214.4603997786231771143.95909183366171143.959091833661733953396180117993176756857.84159911447756857.8415991144731774575.83636733464664575.83636733464663397339818011799317611352867.62398671511352867.623986715317745758.36367334646645758.363673346466323534123356324133563241323732463237324683123718011799180117991801179918011799112709.51299999999999999.51299999999999990.475999999999999980.47599999999999998212719.51299999999999999.51299999999999990.475999999999999980.4759999999999999838407.92699999999999967.92699999999999960.237800000000000010.2378000000000000148427.92699999999999967.92699999999999960.554899999999999950.5548999999999999558416.34199999999999966.34199999999999960.634000000000000010.634000000000000018127474740.220.229127574740.220.2232413241612731980287213513573372198028721351351032116211643431117965508627.9413.125100010000.430.43121797781.25100013.1250.43250030005050131276831237324132411224618.1418.140.725500000000000030.7255000000000000322247000.475999999999999980.47599999999999998318069.51299999999999999.51299999999999990.475999999999999980.4759999999999999834133414341518011799180117998127445244612.62.29999999999999989127510469003.80.72127197683.51.25841787.9396.922.15.09999999999999963840231680.70.23366336734163366336734253370179933701799341633701799337017991127096E381*G373*GBP3.3599999999999998E-4H347*$E381*GBP4.5695999999999998E-5F381/E3810G381/E38102127196E373*E382*GBP9.3119999999999991E-3F373*E382*GBP6.5279999999999999E-3E382*G373*GBP3.3599999999999998E-4H348*$E382*GBP4.5695999999999998E-5F382/E3829.6999999999999986E-5G382/E3826.7999999999999999E-53840179E383*E375*GBP4.1348999999999997E-2E383*F375*GBP1.2171999999999999E-2G375*$E383*GBP1.2529999999999998E-4H375*$E383*GBP3.5800000000000003E-5F383/E3832.3099999999999998E-46.7999999999999999E-5484296F384/E38400584196E374*E385*GBP7.5638399999999995E-2F374*E385*GBP3.8102399999999995E-2G374*$E385*GBP2.1216000000000004E-36.0863999999999999E-57.8789999999999991E-43.9689999999999994E-46127396E386*F356*GBP0.27571200000000001E386*E356*GBP0.19008G356*$E386*GBP1.2959999999999999E-2H356*$E386*GBP1.2959999999999999E-22.872E-31.98E-37337296E387*F357*GBP0.27571200000000001E387*E357*GBP0.19008G357*$E387*GBP1.2959999999999999E-2H357*$E387*GBP1.2959999999999999E-22.872E-31.98E-38127455E388*E371*GBP2.486E-2E388*F371*GBP2.453E-2G371*$E388*GBP6.9299999999999993E-4H371*$E388*GBP1.2649999999999998E-44.5199999999999998E-44.46E-49127555E389*E372*GBP5.7529999999999998E-2E389*F372*GBP4.9499999999999995E-2G372*$E389*GBP2.0899999999999998E-4H372*$E389*GBP3.8500000000000001E-51.0460000000000001E-38.9999999999999987E-4103AVERAGE($E$381:$E$389)96.111111111111114E390*E358*GBP0.20337111111111111E390*F358*GBP0.20337111111111111G358*$E390*GBP4.1327777777777778E-34.1327777777777778E-32.1159999999999998E-32.1159999999999998E-3111796AVERAGE($E$381:$E$389)96.111111111111114E391*J359*GBP9.6111111111111105E-2E391*E359*GBP5.2861111111111109E-27.6312222222222226E-41.2614583333333334E-39.999999999999998E-45.4999999999999992E-412179796.111111111111114E392*K360*GBP0.28833333333333327E392*E360*GBP7.5086805555555552E-21.2614583333333334E-34.1327777777777776E-52.9999999999999992E-37.8124999999999993E-413127696.111111111111114003426212394020072010201520202025203020352040204520503427F3962123940F398+F398*(('Global assumptions'!$C6-'Global assumptions'!$C5)/'Global assumptions'!$C5)2167461.8376628999G398+G398*(('Global assumptions'!$C7-'Global assumptions'!$C6)/'Global assumptions'!$C6)2241371.2084798189H398+H398*(('Global assumptions'!$C8-'Global assumptions'!$C7)/'Global assumptions'!$C7)2317233.1354907909I398+I398*(('Global assumptions'!$C9-'Global assumptions'!$C8)/'Global assumptions'!$C8)2391275.3287573187J398+J398*(('Global assumptions'!$C10-'Global assumptions'!$C9)/'Global assumptions'!$C9)2458440.2939668377K398+K398*(('Global assumptions'!$C11-'Global assumptions'!$C10)/'Global assumptions'!$C10)2517747.5903465473L398+L398*(('Global assumptions'!$C12-'Global assumptions'!$C11)/'Global assumptions'!$C11)2572612.1098981518M398+M398*(('Global assumptions'!$C13-'Global assumptions'!$C12)/'Global assumptions'!$C12)2624974.9135604287N398+N398*(('Global assumptions'!$C14-'Global assumptions'!$C13)/'Global assumptions'!$C13)2674893.0596004793428200720102015202020252030203520402045205011270IF((F494-E494)>0,F494-E494,0)0IF((G494-F494)>0,G494-F494,0)0IF((H494-G494)>0,H494-G494,0)0IF((I494-H494)>0,I494-H494,0)0IF((J494-I494)>0,J494-I494,0)0IF((K494-J494)>0,K494-J494,0)0IF((L494-K494)>0,L494-K494,0)0IF((M494-L494)>0,M494-L494,0)002127103.7500000000000006E-20000000384000000000048420000000005841000000000612730000000007337200000000081274008.2857142857142851E-28.2857142857142851E-28.2857142857142851E-28.2857142857142851E-28.2857142857142851E-28.2857142857142851E-28.2857142857142851E-291275004.2857142857142858E-24.2857142857142858E-24.2857142857142844E-24.2857142857142871E-24.2857142857142871E-24.2857142857142871E-24.2857142857142816E-2103001.4285714285714286E-31.4285714285714286E-31.4285714285714288E-31.4285714285714284E-31.4285714285714284E-31.4285714285714292E-31.4285714285714284E-3111796000000000121797000000000131276001.5714285714285715E-21.5714285714285715E-21.5714285714285715E-21.5714285714285715E-21.5714285714285708E-21.5714285714285708E-21.5714285714285722E-2COUNTIF(G402:G414,">0")0SUMIF(H402:H414,">0")3.7500000000000006E-2SUMIF(I402:I414,">0")0.142857142857142850.142857142857142850.142857142857142820.142857142857142850.142857142857142850.14285714285714285SUMIF(O402:O414,">0")0.142857142857142793428200720102015202020252030203520402045205011270IFERROR(G$398*G$91*(G402/G$415),0)00000000021271IFERROR(G$398*G$91*(G403/G$415),0)089654.84833919275800000003840IFERROR(G$398*G$91*(G404/G$415),0)0000000004842IFERROR(G$398*G$91*(G405/G$415),0)0000000005841IFERROR(G$398*G$91*(G406/G$415),0)00000000061273IFERROR(G$398*G$91*(G407/G$415),0)00000000073372IFERROR(G$398*G$91*(G408/G$415),0)00000000081274IFERROR(G$398*G$91*(G409/G$415),0)00107519.61748677269110955.17525433959114071.62964006128116823.48819207979119369.20189927424121798.83598920389124115.0379654622791275IFERROR(G$398*G$91*(G410/G$415),0)0055613.59525177899257390.60789017566359002.56705520409760425.9421683171661742.69063755566562999.39792545031464197.43343041146103IFERROR(G$398*G$91*(G411/G$415),0)001853.78650839263291913.02026300585521966.75223517347082014.19807227723752058.08968791852112099.97993084834432139.914447680384111796IFERROR(G$398*G$91*(G412/G$415),0)000000000121797IFERROR(G$398*G$91*(G413/G$415),0)000000000131276IFERROR(G$398*G$91*(G414/G$415),0)0020391.65159231896521043.22289306440921634.27458690817722156.17879504962222638.9865671037323099.77923933176523539.0589244842383429COUNTIF(G418:G430,">0")0SUMIF(H418:H430,">0")89654.848339192758SUMIF(I418:I430,">0")185378.65083926328191302.02630058551196675.22351734701201419.80722772382205808.96879185215209997.99308483431213991.4447680383535780.333605831237442200720102015202020252030203520402045205011270$E$433*F457385049.45091329492$E$433*G457392939.53241034149386021.64630927495342074.58610044705294170.70219379646241946.57934386036185837.46531200426126591.3802128817664584.0070590666$E$433*O457021271$E$433*F458105013.48661271679107165.32702100222138524.51422581635122863.15277483358105788.8515640465887170.22691192672967162.31202504012646033.22916832062823917.713619003604$E$433*O458881.694230235015883840261075.19588439309266424.91023276938268622.1205028955238040.53883245817204705.50957086246168364.14178623291129319.3127335626888091.54956799511344942.280031832459$E$433*O4590484270008.99107514452871443.55134733481170185.75387441361162195.37929099036453485.58221705388943990.28715342915533788.63005672803423016.61458416031411742.546738012106$E$433*O46005841000000000$E$433*O461061273000000000$E$433*O462073372000000000$E$433*O46308127400036257.90569047135874832.897926492049115402.15133177546157581.47643415554201269.19003144564246438.97430433269$E$433*O464292979.645255177119127500018754.08915024380638706.67134128899559690.76793022869281507.660224563224104104.75346454086127468.43498499971$E$433*O465151541.195821643341030001092.40990673137322254.63102425690113476.93698718167164747.75259893920526064.01425904564447424.9290412137852$E$433*O4668827.1470966815832111796000000000$E$433*O4670121797000000000$E$433*O468013127600012016.50897404510624800.9412668259138246.30685899838952225.27858833126166704.15684950210681674.21945335163$E$433*O46997098.61806349741534193430200720102015202020252030203520402045205011270E494*F$398*($E381/AVERAGE($E$381:$E$393))1166816.51791907541190725.85578891361169762.56457356041036589.6548498395891426.37028423161733171.4525571526563143.83427880076383610.24306933867195709.11230020181021271E495*F$398*($E382/AVERAGE($E$381:$E$393))318222.68670520239324743.41521515819419771.25522974652372312.58416616236320572.27746680781264152.2027634143203522.15765163672139494.6338433958372477.9200575866712671.8006976818663840E496*F$398*($E383/AVERAGE($E$381:$E$393))791136.95722543355807348.21282657387814006.42576635721334.96615896409620319.72597231041510194.3690491906391876.70525322022266944.08959998516136188.7273691892604842E497*F$398*($E384/AVERAGE($E$381:$E$393))212148.45780346825216495.61014343883212684.10264973823188470.84633633442162077.52186986027133303.90046493683102389.7880506910269747.31692169791535583.47496367304805841E498*F$398*($E385/AVERAGE($E$381:$E$393))000000000061273E499*F$398*($E386/AVERAGE($E$381:$E$393))000000000073372E500*F$398*($E387/AVERAGE($E$381:$E$393))000000000081274E501*F$398*($E388/AVERAGE($E$381:$E$393))000109872.44148627683226766.3573530062349703.48888416804477519.62555804709609906.63645892614746784.77061918995887817.1068338699491275E502*F$398*($E389/AVERAGE($E$381:$E$393))00056830.573182556982117292.9434584515180881.11494008693246992.90977140368315468.94989254803386267.98480302939459215.7449140707103E503*F$398*($E390/AVERAGE($E$381:$E$393))0003310.3330507011316832.215225020911910536.17268842930814387.1290876945618375.80078498680122499.78497337510626748.930596004797111796E504*F$398*($E391/AVERAGE($E$381:$E$393))0000000000121797E505*F$398*($E392/AVERAGE($E$381:$E$393))0000000000131276E506*F$398*($E393/AVERAGE($E$381:$E$393))00036413.6635577124475154.367475230029115897.89957272238158258.41996464017202133.80863485485247497.63470712616294238.236556052753431SUM(F457:F469)2488324.6196531793SUM(G457:G469)2539313.09397408462616224.34821939472525135.06278854752420441.77910491872297840.60092010072158090.56961613432005681.47920573341843009.4097933711SUM(O457:O469)1670691.81959767993420831237442200720102015202020252030203520402045205011270IF(G437-F437+F457>0,G437-F437+F457,0)1174706.5994161221IF(H437-G437+G457>0,H437-G437+G457,0)1183807.9696878471125815.5043647324988685.77094318892839202.24743429548677062.33852529654503897.74917967827321602.86991552351131125.1052411352321271IF(G438-F438+F458>0,G438-F438+F458,0)320374.52711348783356102.6024199723404109.89377876371355238.28295537538301953.65281468793244144.2878765277182393.07479491722117379.118294078849441.9006688180823840IF(G439-F439+F459>0,G439-F439+F459,0)796486.67157380981809545.42309669999783424.84409591265687999.9368973684583978.35818768083471149.53999652038350648.94208765263223794.820063822591246.4473373568034842IF(G440-F440+F460>0,G440-F440+F460,0)213583.01807565853215237.81267051763204693.72806631497179761.04926239795152582.22680623553123102.2433682357191617.77257812328858473.24907554970623840.9282256609445841IF(G441-F441+F461>0,G441-F441+F461,0)00000000061273IF(G442-F442+F462>0,G442-F442+F462,0)00000000073372IF(G443-F443+F463>0,G443-F443+F463,0)00000000081274IF(G444-F444+F464>0,G444-F444+F464,0)0036257.905690471358148447.43372229752267335.61075828958391882.81398654811521207.33915533719655076.42073181318793325.4415700343791275IF(G445-F445+F465>0,G445-F445+F465,0)0018754.08915024380676783.155373602174138277.0400473912202698.00723442147269590.00301138131338832.63141300686410340.74563967303103IF(G446-F446+F466>0,G446-F446+F466,0)001092.40990673137324472.55416822665948054.52118794568211806.9883001868415703.39074780100119736.71556715494123902.003028842904111796IF(G447-F447+F467>0,G447-F447+F467,0)000000000121797IF(G448-F448+F468>0,G448-F448+F468,0)000000000131276IF(G449-F449+F469>0,G449-F449+F469,0)0012016.50897404510649198.09585049324288599.7330674025129876.87130205525172737.29822581101217103.87123870436262922.033317271973419G52300000000O5230812181338041662831237200720102015202020252030203520402045205028891INDEX($D$55:$D$67, MATCH($C494, $C$55:$C$67, 0))Gas boiler (old)$F$176:$F$1880.550000000000000040.550000000000000040.52250000000000008G494+$O4940.44785714285714295H494+$O4940.373214285714285830.298571428571428710.223928571428571560.149285714285714417.4642857142857261E-2INDEX($E55:$T55, MATCH($E$22, $E$54:$T$54, 0))0(N494-G494)/7-7.464285714285715E-22Gas boiler (new)0.150.150.1875G495+$O4950.160857142857142870.134214285714285730.10757142857142868.0928571428571461E-25.4285714285714319E-22.7642857142857177E-2INDEX($E56:$T56, MATCH($E$22, $E$54:$T$54, 0))1E-3(N495-G495)/7-2.6642857142857142E-23Resisitive heating0.20.20.19500000000000001G496+$O4960.167142857142857150.139285714285714290.111428571428571438.3571428571428574E-25.5714285714285716E-22.7857142857142858E-20-2.7857142857142858E-24Oil-fired boiler0.10.19.5000000000000001E-2G497+$O4978.1428571428571433E-26.7857142857142866E-25.4285714285714298E-24.0714285714285731E-22.714285714285716E-21.3571428571428588E-20-1.3571428571428571E-25Solid-fuel boiler000G498+$O498000000006Stirling engine μCHP000G499+$O499000000007Fuel-cell μCHP000G500+$O500000000008Air-source heat pump000G501+$O5018.2857142857142851E-20.16571428571428570.248571428571428550.331428571428571410.414285714285714260.497142857142857110.579999999999999968.2857142857142851E-29Ground-source heat pump000G502+$O5024.2857142857142858E-28.5714285714285715E-20.128571428571428560.171428571428571430.21428571428571430.257142857142857170.34.2857142857142858E-210Geothermal000G503+$O5031.4285714285714286E-32.8571428571428571E-34.2857142857142859E-35.7142857142857143E-37.1428571428571426E-38.5714285714285719E-30.011.4285714285714286E-311Community scale gas CHP000G504+$O5040000000012Community scale solid-fuel CHP000G505+$O5050000000013District heating from power stations000G506+$O5061.5714285714285715E-23.1428571428571431E-24.7142857142857146E-26.2857142857142861E-27.857142857142857E-29.4285714285714278E-20.111.5714285714285715E-2181438041815831237200720102015202020252030203520402045205028891INDEX($D$73:$D$75, MATCH($C511, $C$73:$C$75, 0))Electric air conditioner (old)$F$192:$F$194110.95G511+$O5110.81428571428571428H511+$O5110.67857142857142860.542857142857142930.407142857142857250.271428571428571570.13571428571428587INDEX($E73:$T73, MATCH($E$22, $E$72:$T$72, 0))0(N511-G511)/7-0.13571428571428572INDEX($D$73:$D$75, MATCH($C512, $C$73:$C$75, 0))Electric air conditioner (new)000.05G512+$O5120.168571428571428570.287142857142857140.405714285714285690.524285714285714240.642857142857142790.76142857142857134INDEX($E74:$T74, MATCH($E$22, $E$72:$T$72, 0))0.88(N512-G512)/70.118571428571428563INDEX($D$73:$D$75, MATCH($C513, $C$73:$C$75, 0))Absorption chiller000G513+$O5131.7142857142857144E-23.4285714285714287E-25.1428571428571435E-26.8571428571428575E-28.5714285714285715E-20.10285714285714286INDEX($E75:$T75, MATCH($E$22, $E$72:$T$72, 0))0.121.7142857142857144E-273111610216113160841539511591158220072010201520202025203020352040204520501609Preferences.EnergyUnitsTWhINDEX(F$39:F$42, MATCH($E$8, $C$39:$C$42, 0))13.4986017390997INDEX(G$39:G$42, MATCH($E$8, $C$39:$C$42, 0))13.58917650801799913.907569766113514.395277198787315.02109862238300115.765606213863316.61749522421429917.57111851793660118.624825111950419.7798450757782011INDEX($D$55:$D$67, MATCH($B527, $C$55:$C$67, 0))Gas boiler (old)F$526*E$494:E$5067.424230956504835G$526*F$494:F$5067.4740470794099005H$526*G$494:G$5067.2667052027943049I$526*H$494:H$5066.4470277168854562J$526*I$494:I$5065.6060885929965147K$526*J$494:J$5064.707159569567759L$526*K$494:K$5063.7211319662794184M$526*L$494:L$5062.6231169787491089N$526*M$494:M$5061.3902101601420143O$526*N$494:N$50602Gas boiler (new)2.02479026086495482.03837647620269992.60766933114628152.31558316083352.01604602224697561.69592878271986681.3448301492167720.95386071954513030.51484337988034391.97798450757782E-23Resisitive heating2.69972034781994012.71783530160359992.71197610439213272.40606776036873442.09222445097477521.75673897811619641.38874781516648070.97896231742789630.5188344138329040704Oil-fired boiler1.349860173909971.35891765080179991.32121912778078251.17218685761553741.01928883509027510.855847194466865080.676569448414439560.476930359772565150.2527654836621843205Solid-fuel boiler00000000006Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0001.19275153932809052.48921062885203973.91887925887459155.50751270288245297.27946338600230559.259198769941056311.4723101439513569Ground-source heat pump0000.616940451376598591.28752273906140012.02700651321099562.84871346700816553.76523968241498614.78924074307296095.933953522733459910Geothermal0002.0564681712553285E-24.2917424635380001E-26.7566883773699862E-29.4957115566938852E-20.125507989413832840.159641358102432020.1977984507577820211Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0000.226211498838086140.472091670989180030.74323572151069851.04452827123632751.38058788355216141.75605493912675192.1757829583356023SUM(F527:F539)13.498601739099701SUM(G527:G539)13.58917650801799913.907569766113514.39733366695855715.02539036484654215.77236290224067316.62699093577099417.58366931687798718.64078924776064719.79962492085397986745INDEX(Vectors[Description], MATCH($B544, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$527:F$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-2.6997203478199401SUM(G$527:G$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-2.7178353016035999SUM(H$527:H$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-2.7119761043921327SUM(I$527:I$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-3.2080903471583126SUM(J$527:J$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-3.7660040117545952SUM(K$527:K$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-4.391847445290491SUM(L$527:L$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-5.0920753222770951SUM(M$527:M$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-5.8737739045673782SUM(N$527:N$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-6.7448473798277524SUM(O$527:O$539/$M$115:$M$127*($B544=$F$114:$N$114)*($F$115:$N$127))-7.714139579553497946INDEX(Vectors[Description], MATCH($B545, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$527:F$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(G$527:G$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(H$527:H$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(I$527:I$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(J$527:J$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(K$527:K$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(L$527:L$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(M$527:M$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(N$527:N$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))0SUM(O$527:O$539/$M$115:$M$127*($B545=$F$114:$N$114)*($F$115:$N$127))047INDEX(Vectors[Description], MATCH($B546, Vectors[Code], 0))Solid hydrocarbonsSUM(F$527:F$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(G$527:G$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(H$527:H$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(I$527:I$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(J$527:J$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(K$527:K$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(L$527:L$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(M$527:M$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(N$527:N$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))0SUM(O$527:O$539/$M$115:$M$127*($B546=$F$114:$N$114)*($F$115:$N$127))049INDEX(Vectors[Description], MATCH($B547, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$527:F$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-1.3916084267113094SUM(G$527:G$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-1.4009460317544329SUM(H$527:H$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-1.3620815750317345SUM(I$527:I$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-1.2084400593974614SUM(J$527:J$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-1.05081323205183SUM(K$527:K$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-0.88231669532666501SUM(L$527:L$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-0.69749427671591713SUM(M$527:M$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-0.49168078327068576SUM(N$527:N$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))-0.26058297284761273SUM(O$527:O$539/$M$115:$M$127*($B547=$F$114:$N$114)*($F$115:$N$127))050INDEX(Vectors[Description], MATCH($B548, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$527:F$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-11.993769185478261SUM(G$527:G$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-12.074246622581059SUM(H$527:H$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-12.427024907770376SUM(I$527:I$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-11.027528086465045SUM(J$527:J$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-9.5918675484883309SUM(K$527:K$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-8.0572890155780215SUM(L$527:L$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-6.3740616002299273SUM(M$527:M$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-4.4996683017871426SUM(N$527:N$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-2.3949858508361688SUM(O$527:O$539/$M$115:$M$127*($B548=$F$114:$N$114)*($F$115:$N$127))-2.1736093489866153E-2751INDEX(Vectors[Description], MATCH($B549, Vectors[Code], 0))Heat transportSUM(F$527:F$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))0SUM(G$527:G$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))0SUM(H$527:H$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))0SUM(I$527:I$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-0.2513461098200957SUM(J$527:J$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-0.52454630109908895SUM(K$527:K$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-0.82581746834522052SUM(L$527:L$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-1.160586968040364SUM(M$527:M$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-1.5339865372801793SUM(N$527:N$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-1.9511721545852798SUM(O$527:O$539/$M$115:$M$127*($B549=$F$114:$N$114)*($F$115:$N$127))-2.4175366203728914104INDEX(Vectors[Description], MATCH($B550, Vectors[Code], 0))Environmental heatSUM(F$527:F$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))0SUM(G$527:G$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))0SUM(H$527:H$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))0SUM(I$527:I$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-1.0318631471063502SUM(J$527:J$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-2.1534448949399492SUM(K$527:K$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-3.390267756409763SUM(L$527:L$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-4.7646129163881668SUM(M$527:M$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-6.2975479394117313SUM(N$527:N$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-8.0102399094926184SUM(O$527:O$539/$M$115:$M$127*($B550=$F$114:$N$114)*($F$115:$N$127))-9.92482814684635716INDEX(Vectors[Description], MATCH($B551, Vectors[Code], 0))Heating and coolingSUM(F$527:F$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))13.498601739099701SUM(G$527:G$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))13.589176508017999SUM(H$527:H$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))13.907569766113502SUM(I$527:I$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))14.397333666958557SUM(J$527:J$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))15.025390364846542SUM(K$527:K$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))15.772362902240673SUM(L$527:L$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))16.626990935770994SUM(M$527:M$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))17.583669316877987SUM(N$527:N$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))18.640789247760647SUM(O$527:O$539/$M$115:$M$127*($B551=$F$114:$N$114)*($F$115:$N$127))19.79962492085397934INDEX(Vectors[Description], MATCH($B552, Vectors[Code], 0))Conversion lossesSUM(F$527:F$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))2.5864962209098104SUM(G$527:G$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))2.6038514479210928SUM(H$527:H$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))2.5935128210807408SUM(I$527:I$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))2.3299340829887076SUM(J$527:J$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))2.0612856234872536SUM(K$527:K$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))1.7751754787094878SUM(L$527:L$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))1.461840147880475SUM(M$527:M$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))1.1129881494391305SUM(N$527:N$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))0.72103901982878449SUM(O$527:O$539/$M$115:$M$127*($B552=$F$114:$N$114)*($F$115:$N$127))0.27861551940863277Preferences.EnergyUnitsTWhSUM(F544:F552)0SUM(G544:G552)00000001.2212453270876722E-158.3266726846886741E-162158320072010201520202025203020352040204520501808Preferences.EnergyUnitsTWhINDEX(F$31:F$34, MATCH($E$8, $C$31:$C$34, 0))74.58316889692INDEX(G$31:G$34, MATCH($E$8, $C$31:$C$34, 0))73.30722795588970172.75971714915550673.72259570088219575.82436407171340478.82151964052529582.55806915487079386.93811058737979691.90728615923819797.4402584622100961INDEX($D$55:$D$67, MATCH($B559, $C$55:$C$67, 0))Gas boiler (old)F$558*E494:E50641.020742893306G$558*F494:F50640.318975375739342H$558*G494:G50638.016952210433757I$558*H494:H50633.017191074609393J$558*I494:I50628.298735876764475K$558*J494:J50623.533853721242565L$558*K494:K50618.487110485751433M$558*L494:L50612.978617937687423N$558*M494:M5066.860222431171719O$558*N494:N50602Gas boiler (new)11.18747533453810.99608419338345513.64244696546665711.85880610845619310.1767128636249648.4789434699022236.68130659660490344.71949743188633432.54057998168751639.7440258462210091E-23Resisitive heating14.91663377938414.66144559117794114.18814484408532412.32220528143316710.5612507099886548.78296933137281856.89949577937134524.84369473272544582.560274400150206904Oil-fired boiler7.4583168896927.33072279558897046.91217312916977286.00312564992897895.14522470486626744.27888249477137443.36129281559116942.35974871594316721.247313169303948505Solid-fuel boiler00000000006Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0006.10844364378738112.56518033188393519.59277773921628827.36210291990003236.01721724334305545.69105083344984356.5153499080818529Ground-source heat pump0003.1595398157520946.499231206146863110.13419538235325114.15281185512070818.62959512586710223.63330215523268129.23207753866302710Geothermal0000.105317993858403140.216641040204895440.337806512745108420.471760395170690240.620986504195570.787776738507755980.9744025846221009411Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0001.15849793244243452.383051442253853.71587164019619295.18936434687759276.830851546151278.66554412358531510.71842843084311SUM(F559:F571)74.5831688969273.30722795588970172.7597171491555273.7331275002680475.84602817573389278.85530029179982182.60524519438787687.00020923779935391.98606383308899197.53769872067229686745INDEX(Vectors[Description], MATCH($B576, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$559:F$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-14.916633779384SUM(G$559:G$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-14.661445591177941SUM(H$559:H$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-14.188144844085324SUM(I$559:I$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-15.148238116633649SUM(J$559:J$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-16.374451955486681SUM(K$559:K$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-17.847444090033228SUM(L$559:L$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-19.558399716451532SUM(M$559:M$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-21.50683259530657SUM(N$559:N$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-23.698950216774993SUM(O$559:O$571/$M$97:$M$109*($B576=$F$96:$N$96)*($F$97:$N$109))-26.14646935402637246INDEX(Vectors[Description], MATCH($B577, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$559:F$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(G$559:G$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(H$559:H$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(I$559:I$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(J$559:J$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(K$559:K$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(L$559:L$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(M$559:M$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(N$559:N$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))0SUM(O$559:O$571/$M$97:$M$109*($B577=$F$96:$N$96)*($F$97:$N$109))047INDEX(Vectors[Description], MATCH($B578, Vectors[Code], 0))Solid hydrocarbonsSUM(F$559:F$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(G$559:G$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(H$559:H$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(I$559:I$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(J$559:J$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(K$559:K$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(L$559:L$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(M$559:M$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(N$559:N$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))0SUM(O$559:O$571/$M$97:$M$109*($B578=$F$96:$N$96)*($F$97:$N$109))049INDEX(Vectors[Description], MATCH($B579, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$559:F$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-7.6889864842185567SUM(G$559:G$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-7.5574461810195572SUM(H$559:H$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-7.1259516795564668SUM(I$559:I$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-6.18878932982369SUM(J$559:J$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-5.3043553658415128SUM(K$559:K$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-4.4112190667746125SUM(L$559:L$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-3.4652503253517213SUM(M$559:M$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-2.4327306349929558SUM(N$559:N$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))-1.2858898652618027SUM(O$559:O$571/$M$97:$M$109*($B579=$F$96:$N$96)*($F$97:$N$109))050INDEX(Vectors[Description], MATCH($B580, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$559:F$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-66.268590640771166SUM(G$559:G$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-65.134892392848798SUM(H$559:H$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-65.014005502095685SUM(I$559:I$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-56.475327530828885SUM(J$559:J$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-48.418379734254835SUM(K$559:K$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-40.283117298230806SUM(L$559:L$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-31.667240537093019SUM(M$559:M$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-22.263389779538997SUM(N$559:N$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-11.818454595790596SUM(O$559:O$571/$M$97:$M$109*($B580=$F$96:$N$96)*($F$97:$N$109))-0.10707720710132977751INDEX(Vectors[Description], MATCH($B581, Vectors[Code], 0))Heat transportSUM(F$559:F$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))0SUM(G$559:G$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))0SUM(H$559:H$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))0SUM(I$559:I$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-1.2872199249360383SUM(J$559:J$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-2.647834935837611SUM(K$559:K$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-4.1287462668846588SUM(L$559:L$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-5.7659603854195476SUM(M$559:M$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-7.5898350512791888SUM(N$559:N$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-9.6283823595392395SUM(O$559:O$571/$M$97:$M$109*($B581=$F$96:$N$96)*($F$97:$N$109))-11.909364923159011104INDEX(Vectors[Description], MATCH($B582, Vectors[Code], 0))Environmental heatSUM(F$559:F$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))0SUM(G$559:G$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))0SUM(H$559:H$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))0SUM(I$559:I$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-6.5658541465253482SUM(J$559:J$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-13.506082104538532SUM(K$559:K$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-21.059917789668081SUM(L$559:L$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-29.411023067553128SUM(M$559:M$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-38.714246864506173SUM(N$559:N$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-49.11247333500804SUM(O$559:O$571/$M$97:$M$109*($B582=$F$96:$N$96)*($F$97:$N$109))-60.7473140746268646INDEX(Vectors[Description], MATCH($B583, Vectors[Code], 0))Heating and coolingSUM(F$559:F$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))74.58316889692SUM(G$559:G$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))73.307227955889701SUM(H$559:H$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))72.75971714915552SUM(I$559:I$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))73.73312750026804SUM(J$559:J$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))75.846028175733892SUM(K$559:K$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))78.855300291799821SUM(L$559:L$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))82.605245194387876SUM(M$559:M$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))87.000209237799368SUM(N$559:N$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))91.986063833088991SUM(O$559:O$571/$M$97:$M$109*($B583=$F$96:$N$96)*($F$97:$N$109))97.53769872067229634INDEX(Vectors[Description], MATCH($B584, Vectors[Code], 0))Conversion lossesSUM(F$559:F$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))14.291042007453724SUM(G$559:G$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))14.046556209156584SUM(H$559:H$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))13.568384876581966SUM(I$559:I$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))11.932301548479565SUM(J$559:J$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))10.405075920225269SUM(K$559:K$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))8.8751442197915598SUM(L$559:L$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))7.2626288374810741SUM(M$559:M$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))5.5068256878245156SUM(N$559:N$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))3.5580865392856849SUM(O$559:O$571/$M$97:$M$109*($B584=$F$96:$N$96)*($F$97:$N$109))1.3725268382412739Preferences.EnergyUnitsTWhSUM(F576:F584)0SUM(G576:G584)000000003.1086244689504383E-153161220072010201520202025203020352040204520501816Preferences.EnergyUnitsTWhINDEX(F$47:F$50, MATCH($E$8, $C$47:$C$50, 0))27.338359407609801INDEX(G$47:G$50, MATCH($E$8, $C$47:$C$50, 0))28.08513366180320129.667482565293631.595890898168333.80174162377870336.23483787367639838.86015343767920241.65485769645650344.605782233169447.7073610184674021INDEX($D$73:$D$75, MATCH($C592, $C$73:$C$75, 0))Electric air conditioner (old)F$591*E$511:E$51327.338359407609801G$591*F$511:F$51328.085133661803201H$591*G$511:G$51328.184108437028918I$591*H$511:H$51325.728082588508471J$591*I$511:I$51322.936896101849836K$591*J$511:J$51319.670340559995761L$591*K$511:K$51315.821633899626537M$591*L$511:L$51311.306318517609629N$591*M$511:M$5136.0536418745015688O$591*N$511:N$5130Q$591*Q$511:Q$51302INDEX($D$73:$D$75, MATCH($C593, $C$73:$C$75, 0))Electric air conditioner (new)001.48337412826468025.32616446569122739.705928666256456314.70099136589156620.37382330232609526.77812280486489333.96411704325612441.9824776962513163INDEX($D$73:$D$75, MATCH($C594, $C$73:$C$75, 0))Absorption chiller0000.541643843968599441.15891685567241281.86350594778907212.6646962357265743.57041637398198614.58802331541170985.7248833222160878SUM(F592:F594)27.33835940760980128.08513366180320129.66748256529359731.595890898168333.8017416237787136.23483787367639838.86015343767920941.65485769645650344.605782233169447.707361018467402182045INDEX(Vectors[Description], MATCH($B599, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$592:F$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-10.935343763043921SUM(G$592:G$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-11.234053464721281SUM(H$592:H$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-11.520872396189013SUM(I$592:I$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-11.178927113018593SUM(J$592:J$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-10.792413218449344SUM(K$592:K$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-10.318301451646899SUM(L$592:L$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-9.7242907769049634SUM(M$592:M$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-8.985547874521334SUM(N$592:N$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-8.0821429236766473SUM(O$592:O$594/$M$169:$M$171*($B599=$F$168:$N$168)*($F$169:$N$171))-6.997079616041886246INDEX(Vectors[Description], MATCH($B600, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$592:F$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(J$592:J$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(K$592:K$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(L$592:L$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(M$592:M$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(N$592:N$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))0SUM(O$592:O$594/$M$169:$M$171*($B600=$F$168:$N$168)*($F$169:$N$171))047INDEX(Vectors[Description], MATCH($B601, Vectors[Code], 0))Solid hydrocarbonsSUM(F$592:F$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(J$592:J$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(K$592:K$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(L$592:L$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(M$592:M$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(N$592:N$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))0SUM(O$592:O$594/$M$169:$M$171*($B601=$F$168:$N$168)*($F$169:$N$171))049INDEX(Vectors[Description], MATCH($B602, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$592:F$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(J$592:J$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(K$592:K$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(L$592:L$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(M$592:M$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(N$592:N$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))0SUM(O$592:O$594/$M$169:$M$171*($B602=$F$168:$N$168)*($F$169:$N$171))050INDEX(Vectors[Description], MATCH($B603, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$592:F$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(J$592:J$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(K$592:K$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(L$592:L$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(M$592:M$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(N$592:N$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0SUM(O$592:O$594/$M$169:$M$171*($B603=$F$168:$N$168)*($F$169:$N$171))0751INDEX(Vectors[Description], MATCH($B604, Vectors[Code], 0))Heat transportSUM(F$592:F$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-0.77377691995514208SUM(J$592:J$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-1.6555955081034468SUM(K$592:K$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-2.6621513539843891SUM(L$592:L$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-3.8067089081808203SUM(M$592:M$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-5.1005948199742663SUM(N$592:N$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-6.5543190220167284SUM(O$592:O$594/$M$169:$M$171*($B604=$F$168:$N$168)*($F$169:$N$171))-8.1784047460229825104INDEX(Vectors[Description], MATCH($B605, Vectors[Code], 0))Environmental heatSUM(F$592:F$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-16.403015644565883SUM(G$592:G$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-16.85108019708192SUM(H$592:H$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-18.14661016910458SUM(I$592:I$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-19.643186865194565SUM(J$592:J$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-21.353732897225914SUM(K$592:K$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-23.25438506804511SUM(L$592:L$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-25.32915375259342SUM(M$592:M$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-27.568715001960904SUM(N$592:N$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-29.969320287476023SUM(O$592:O$594/$M$169:$M$171*($B605=$F$168:$N$168)*($F$169:$N$171))-32.5318766564025316INDEX(Vectors[Description], MATCH($B606, Vectors[Code], 0))Heating and coolingSUM(F$592:F$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))27.338359407609801SUM(G$592:G$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))28.085133661803205SUM(H$592:H$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))29.667482565293597SUM(I$592:I$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))31.5958908981683SUM(J$592:J$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))33.80174162377871SUM(K$592:K$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))36.234837873676398SUM(L$592:L$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))38.860153437679209SUM(M$592:M$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))41.654857696456503SUM(N$592:N$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))44.6057822331694SUM(O$592:O$594/$M$169:$M$171*($B606=$F$168:$N$168)*($F$169:$N$171))47.70736101846740234INDEX(Vectors[Description], MATCH($B607, Vectors[Code], 0))Conversion lossesSUM(F$592:F$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(G$592:G$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(H$592:H$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(I$592:I$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(J$592:J$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(K$592:K$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(L$592:L$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(M$592:M$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(N$592:N$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0SUM(O$592:O$594/$M$169:$M$171*($B607=$F$168:$N$168)*($F$169:$N$171))0Preferences.EnergyUnitsTWhSUM(F599:F607)-3.5527136788005009E-15SUM(G599:G607)3.5527136788005009E-153.5527136788005009E-1507.1054273576010019E-1507.1054273576010019E-15007.1054273576010019E-15182145INDEX(Vectors[Description], MATCH($B612, Vectors[Code], 0))Electricity (delivered to end user)F599-10.935343763043921G599-11.234053464721281-11.520872396189013-11.178927113018593-10.792413218449344-10.318301451646899-9.7242907769049634-8.985547874521334-8.0821429236766473-6.997079616041886246INDEX(Vectors[Description], MATCH($B613, Vectors[Code], 0))Electricity (supplied to grid)F600000000000047INDEX(Vectors[Description], MATCH($B614, Vectors[Code], 0))Solid hydrocarbonsF601000000000049INDEX(Vectors[Description], MATCH($B615, Vectors[Code], 0))Liquid hydrocarbonsF602000000000050INDEX(Vectors[Description], MATCH($B616, Vectors[Code], 0))Gaseous hydrocarbonsF6030000000000751INDEX(Vectors[Description], MATCH($B617, Vectors[Code], 0))Heat transportF604000-0.77377691995514208-1.6555955081034468-2.6621513539843891-3.8067089081808203-5.1005948199742663-6.5543190220167284-8.1784047460229825104INDEX(Vectors[Description], MATCH($B618, Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH($B619, Vectors[Code], 0))Heating and cooling-SUM(F$612:F$618)-F62010.935343763043921-SUM(G$612:G$618)-G62011.23405346472128111.52087239618901311.95270403297373512.44800872655279112.98045280563128813.53099968508578314.08614269449559914.63646194569337715.17548436206486834INDEX(Vectors[Description], MATCH($B620, Vectors[Code], 0))Conversion lossesF6070000000000Preferences.EnergyUnitsTWhSUM(F612:F620)0SUM(G612:G620)0000000004158545INDEX(Vectors[Description], MATCH($B625, Vectors[Code], 0))Electricity (delivered to end user)SUMIFS(F$544:F$552, $B$544:$B$552, $B625)+SUMIFS(F$576:F$584, $B$576:$B$584, $B625)+SUMIFS(F$612:F$620, $B$612:$B$620, $B625)-28.551697890247862-28.613334357502822-28.420993344666471-29.535255576810556-30.93286918569062-32.557592986970619-34.374765815633594-36.366154374395279-38.525940520279391-40.85768854962175646INDEX(Vectors[Description], MATCH($B626, Vectors[Code], 0))Electricity (supplied to grid)000000000047INDEX(Vectors[Description], MATCH($B627, Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH($B628, Vectors[Code], 0))Liquid hydrocarbons-9.0805949109298663-8.9583922127739903-8.4880332545882009-7.3972293892211516-6.3551685978933428-5.2935357621012775-4.1627446020676384-2.9244114182636416-1.5464728381094155050INDEX(Vectors[Description], MATCH($B629, Vectors[Code], 0))Gaseous hydrocarbons-78.262359826249423-77.209139015429855-77.441030409866059-67.502855617293932-58.010247282743165-48.340406313808828-38.041302137322944-26.76305808132614-14.213440446626766-0.12881330059119592751INDEX(Vectors[Description], MATCH($B630, Vectors[Code], 0))Heat transport000-2.3123429547112764-4.8279767450401465-7.6167150892142681-10.733256261640731-14.224416408533635-18.133873536141248-22.505306289554884104INDEX(Vectors[Description], MATCH($B631, Vectors[Code], 0))Environmental heat000-7.5977172936316979-15.65952699947848-24.450185546077844-34.175635983941291-45.011794803917901-57.122713244500659-70.6721422214732236INDEX(Vectors[Description], MATCH($B632, Vectors[Code], 0))Heating and cooling99.01711439906361598.13045792862898598.188159311458037100.08316520020034103.31942726713322107.60811599967178112.76323581524466118.67002124917295125.26331502654301132.5128080035911534INDEX(Vectors[Description], MATCH($B633, Vectors[Code], 0))Conversion losses16.87753822836353416.65040765707767916.16189769766270614.26223563146827212.46636154371252310.6503196985010478.72446898536154876.61981383726364574.2791255591144691.6511423576499067Preferences.EnergyUnitsTWhSUM(F625:F633)0000-1.4210854715202004E-14000-7.1054273576010019E-15-1.021405182655144E-145116088910401060-SUM(F$625:F$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))16.670422935762357-SUM(G$625:G$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))16.446079632032589-SUM(H$625:H$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))16.371157909062401-SUM(I$625:I$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))14.26983278088737-SUM(J$625:J$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))12.262677649498077-SUM(K$625:K$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))10.218018702266143-SUM(L$625:L$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))8.0402857437843309-SUM(M$625:M$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))5.6555055415299194-SUM(N$625:N$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))3.0018912517066787-SUM(O$625:O$633*SUMIFS(EF[CO2], EF[Vector], $B$625:$B$633))2.3701647308780046E-21041-SUM(F$625:F$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))3.1691470049996472E-2-SUM(G$625:G$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))3.1264980025210304E-2-SUM(H$625:H$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))3.1204108693119684E-2-SUM(I$625:I$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))2.7199146068287834E-2-SUM(J$625:J$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))2.3373690891031442E-2-SUM(K$625:K$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))1.9476776042240549E-2-SUM(L$625:L$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))1.5326247497723097E-2-SUM(M$625:M$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))1.0781114975777223E-2-SUM(N$625:N$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))5.7236155810042278E-3-SUM(O$625:O$633*SUMIFS(EF[CH4], EF[Vector], $B$625:$B$633))4.7509613294200772E-51042-SUM(F$625:F$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))7.1890492881915569E-2-SUM(G$625:G$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))7.0923021886006313E-2-SUM(H$625:H$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))6.8899330427930644E-2-SUM(I$625:I$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))6.0050510504267324E-2-SUM(J$625:J$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))5.1597689113332033E-2-SUM(K$625:K$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))4.2986526080377035E-2-SUM(L$625:L$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))3.381466587555558E-2-SUM(M$625:M$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))2.377066570438955E-2-SUM(N$625:N$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))1.2594378049362837E-2-SUM(O$625:O$633*SUMIFS(EF[N2O], EF[Vector], $B$625:$B$633))5.1098898850558557E-562727272820072010201520202025203020352040204520501INDEX($D$55:$D$67, MATCH($B647, $C$55:$C$67, 0))Gas boiler (old)2Gas boiler (new)3Resisitive heating4Oil-fired boiler5Solid-fuel boiler6Stirling engine μCHPF532+F5640G532+G5640000000007Fuel-cell μCHPF533+F5650G533+G5650000000008Air-source heat pump9Ground-source heat pump10Geothermal11Community scale gas CHPF537+F5690G537+G56900000000012Community scale solid-fuel CHPF538+F5700G538+G57000000000013District heating from power stationsPreferences.EnergyUnitsTWhSUM(F647:F659)0SUM(G647:G659)0000000002729200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B665, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$647:F$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B665=$F$96:$N$96)*($F$97:$N$109))046INDEX(Vectors[Description], MATCH($B666, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$647:F$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B666=$F$96:$N$96)*($F$97:$N$109))047INDEX(Vectors[Description], MATCH($B667, Vectors[Code], 0))Solid hydrocarbonsSUM(F$647:F$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B667=$F$96:$N$96)*($F$97:$N$109))049INDEX(Vectors[Description], MATCH($B668, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$647:F$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B668=$F$96:$N$96)*($F$97:$N$109))050INDEX(Vectors[Description], MATCH($B669, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$647:F$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B669=$F$96:$N$96)*($F$97:$N$109))0751INDEX(Vectors[Description], MATCH($B670, Vectors[Code], 0))Heat transportSUM(F$647:F$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B670=$F$96:$N$96)*($F$97:$N$109))0104INDEX(Vectors[Description], MATCH($B671, Vectors[Code], 0))Environmental heatSUM(F$647:F$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B671=$F$96:$N$96)*($F$97:$N$109))06INDEX(Vectors[Description], MATCH($B672, Vectors[Code], 0))Heating and coolingSUM(F$647:F$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B672=$F$96:$N$96)*($F$97:$N$109))034INDEX(Vectors[Description], MATCH($B673, Vectors[Code], 0))Conversion lossesSUM(F$647:F$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(G$647:G$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(H$647:H$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(I$647:I$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(J$647:J$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(K$647:K$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(L$647:L$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(M$647:M$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(N$647:N$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0SUM(O$647:O$659/$M$97:$M$109*($B673=$F$96:$N$96)*($F$97:$N$109))0Preferences.EnergyUnitsTWhSUM(F665:F673)00000000002720200720102015202020252030203520402045205010401060-SUM(F$665:F$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(G$665:G$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(H$665:H$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(I$665:I$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(J$665:J$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(K$665:K$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(L$665:L$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(M$665:M$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(N$665:N$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))0-SUM(O$665:O$673*SUMIFS(EF[CO2], EF[Vector], $B$665:$B$673))01041-SUM(F$665:F$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(G$665:G$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(H$665:H$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(I$665:I$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(J$665:J$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(K$665:K$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(L$665:L$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(M$665:M$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(N$665:N$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))0-SUM(O$665:O$673*SUMIFS(EF[CH4], EF[Vector], $B$665:$B$673))01042-SUM(F$665:F$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(G$665:G$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(H$665:H$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(I$665:I$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(J$665:J$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(K$665:K$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(L$665:L$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(M$665:M$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(N$665:N$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))0-SUM(O$665:O$673*SUMIFS(EF[N2O], EF[Vector], $B$665:$B$673))08371336893712368020072010201520202025203020352040204520503686Preferences.PowerUnits&"e"GWeF612*Conversion.to.average.power-1.2474724803837463-1.2815484217113027-1.3142678982647742-1.2752597664862642-1.2311673760494344-1.1770820729690734-1.1093190482437785-1.0250453883779753-0.9219875568875936-0.798206663933593963715200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B689, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$527:F$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-2.6997203478199401SUM(G$527:G$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-2.7178353016035999SUM(H$527:H$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-2.7119761043921327SUM(I$527:I$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-3.2764315621424545SUM(J$527:J$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-3.9086285845327771SUM(K$527:K$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-4.616387897427332SUM(L$527:L$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-5.4076398780500536SUM(M$527:M$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-6.2908661118113276SUM(N$527:N$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-7.275372701198461SUM(O$527:O$539/$M$151:$M$163*($B689=$F$150:$N$150)*($F$151:$N$163))-8.371469784597035646INDEX(Vectors[Description], MATCH($B690, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$527:F$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(G$527:G$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(H$527:H$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(I$527:I$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(J$527:J$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(K$527:K$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(L$527:L$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(M$527:M$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(N$527:N$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))0SUM(O$527:O$539/$M$151:$M$163*($B690=$F$150:$N$150)*($F$151:$N$163))047INDEX(Vectors[Description], MATCH($B691, Vectors[Code], 0))Solid hydrocarbonsSUM(F$527:F$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(G$527:G$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(H$527:H$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(I$527:I$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(J$527:J$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(K$527:K$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(L$527:L$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(M$527:M$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(N$527:N$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))0SUM(O$527:O$539/$M$151:$M$163*($B691=$F$150:$N$150)*($F$151:$N$163))049INDEX(Vectors[Description], MATCH($B692, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$527:F$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-1.3916084267113094SUM(G$527:G$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-1.4009460317544329SUM(H$527:H$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-1.3620815750317345SUM(I$527:I$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-1.2084400593974614SUM(J$527:J$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-1.05081323205183SUM(K$527:K$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-0.88231669532666501SUM(L$527:L$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-0.69749427671591713SUM(M$527:M$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-0.49168078327068576SUM(N$527:N$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))-0.26058297284761273SUM(O$527:O$539/$M$151:$M$163*($B692=$F$150:$N$150)*($F$151:$N$163))050INDEX(Vectors[Description], MATCH($B693, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$527:F$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-11.993769185478261SUM(G$527:G$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-12.074246622581059SUM(H$527:H$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-12.427024907770376SUM(I$527:I$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-11.027528086465045SUM(J$527:J$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-9.5918675484883309SUM(K$527:K$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-8.0572890155780215SUM(L$527:L$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-6.3740616002299273SUM(M$527:M$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-4.4996683017871426SUM(N$527:N$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-2.3949858508361688SUM(O$527:O$539/$M$151:$M$163*($B693=$F$150:$N$150)*($F$151:$N$163))-2.1736093489866153E-2751INDEX(Vectors[Description], MATCH($B694, Vectors[Code], 0))Heat transportSUM(F$527:F$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))0SUM(G$527:G$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))0SUM(H$527:H$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))0SUM(I$527:I$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-0.2513461098200957SUM(J$527:J$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-0.52454630109908895SUM(K$527:K$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-0.82581746834522052SUM(L$527:L$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-1.160586968040364SUM(M$527:M$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-1.5339865372801793SUM(N$527:N$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-1.9511721545852798SUM(O$527:O$539/$M$151:$M$163*($B694=$F$150:$N$150)*($F$151:$N$163))-2.4175366203728914104INDEX(Vectors[Description], MATCH($B695, Vectors[Code], 0))Environmental heatSUM(F$527:F$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))0SUM(G$527:G$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))0SUM(H$527:H$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))0SUM(I$527:I$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-0.96352193212220838SUM(J$527:J$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-2.0108203221617673SUM(K$527:K$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-3.1657273042729224SUM(L$527:L$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-4.4490483606152083SUM(M$527:M$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-5.8804557321677811SUM(N$527:N$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-7.4797145881219107SUM(O$527:O$539/$M$151:$M$163*($B695=$F$150:$N$150)*($F$151:$N$163))-9.26749794180281766INDEX(Vectors[Description], MATCH($B696, Vectors[Code], 0))Heating and coolingSUM(F$527:F$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))13.498601739099701SUM(G$527:G$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))13.589176508017999SUM(H$527:H$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))13.907569766113502SUM(I$527:I$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))14.397333666958557SUM(J$527:J$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))15.025390364846542SUM(K$527:K$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))15.772362902240673SUM(L$527:L$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))16.626990935770994SUM(M$527:M$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))17.583669316877987SUM(N$527:N$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))18.640789247760647SUM(O$527:O$539/$M$151:$M$163*($B696=$F$150:$N$150)*($F$151:$N$163))19.79962492085397934INDEX(Vectors[Description], MATCH($B697, Vectors[Code], 0))Conversion lossesSUM(F$527:F$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))2.5864962209098104SUM(G$527:G$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))2.6038514479210928SUM(H$527:H$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))2.5935128210807408SUM(I$527:I$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))2.3299340829887076SUM(J$527:J$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))2.0612856234872536SUM(K$527:K$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))1.7751754787094878SUM(L$527:L$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))1.461840147880475SUM(M$527:M$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))1.1129881494391305SUM(N$527:N$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))0.72103901982878449SUM(O$527:O$539/$M$151:$M$163*($B697=$F$150:$N$150)*($F$151:$N$163))0.27861551940863277Preferences.EnergyUnitsTWhSUM(F689:F697)00000000-2.3314683517128287E-158.3266726846886741E-163709200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B701, Vectors[Code], 0))Electricity (delivered to end user)(F689-F544)*Conversion.to.average.power000-7.7961687182456982E-3-1.6270199951880199E-2-2.5614927234410334E-2-3.5998694475582758E-2-4.7580676162896338E-2-6.0520798696179386E-2-7.4986334136839777E-246INDEX(Vectors[Description], MATCH($B702, Vectors[Code], 0))Electricity (supplied to grid)(F690-F545)*Conversion.to.average.power000000000047INDEX(Vectors[Description], MATCH($B703, Vectors[Code], 0))Solid hydrocarbons(F691-F546)*Conversion.to.average.power000000000049INDEX(Vectors[Description], MATCH($B704, Vectors[Code], 0))Liquid hydrocarbons(F692-F547)*Conversion.to.average.power000000000050INDEX(Vectors[Description], MATCH($B705, Vectors[Code], 0))Gaseous hydrocarbons(F693-F548)*Conversion.to.average.power0000000000751INDEX(Vectors[Description], MATCH($B706, Vectors[Code], 0))Heat transport(F694-F549)*Conversion.to.average.power0000000000104INDEX(Vectors[Description], MATCH($B707, Vectors[Code], 0))Environmental heat(F695-F550)*Conversion.to.average.power0007.7961687182456982E-31.6270199951880199E-22.5614927234410285E-23.5998694475582758E-24.7580676162896435E-26.0520798696179288E-27.4986334136839985E-26INDEX(Vectors[Description], MATCH($B708, Vectors[Code], 0))Heating and cooling(F696-F551)*Conversion.to.average.power000000000034INDEX(Vectors[Description], MATCH($B709, Vectors[Code], 0))Conversion losses(F697-F552)*Conversion.to.average.power0000000000Preferences.PowerUnitsGWSUM(F701:F709)00000-4.8572257327350599E-1709.7144514654701197E-17-9.7144514654701197E-172.0816681711721685E-163710200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B713, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$559:F$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-14.916633779384SUM(G$559:G$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-14.661445591177941SUM(H$559:H$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-14.188144844085324SUM(I$559:I$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-15.38245540600562SUM(J$559:J$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-16.856241204831239SUM(K$559:K$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-18.598693927299706SUM(L$559:L$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-20.607550359583655SUM(M$559:M$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-22.887848036455306SUM(N$559:N$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-25.45089141470217SUM(O$559:O$571/$M$133:$M$145*($B713=$F$132:$N$132)*($F$133:$N$145))-28.31344883935599646INDEX(Vectors[Description], MATCH($B714, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$559:F$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(G$559:G$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(H$559:H$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(I$559:I$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(J$559:J$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(K$559:K$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(L$559:L$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(M$559:M$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(N$559:N$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))0SUM(O$559:O$571/$M$133:$M$145*($B714=$F$132:$N$132)*($F$133:$N$145))047INDEX(Vectors[Description], MATCH($B715, Vectors[Code], 0))Solid hydrocarbonsSUM(F$559:F$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(G$559:G$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(H$559:H$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(I$559:I$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(J$559:J$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(K$559:K$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(L$559:L$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(M$559:M$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(N$559:N$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))0SUM(O$559:O$571/$M$133:$M$145*($B715=$F$132:$N$132)*($F$133:$N$145))049INDEX(Vectors[Description], MATCH($B716, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$559:F$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-7.6889864842185567SUM(G$559:G$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-7.5574461810195572SUM(H$559:H$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-7.1259516795564668SUM(I$559:I$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-6.18878932982369SUM(J$559:J$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-5.3043553658415128SUM(K$559:K$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-4.4112190667746125SUM(L$559:L$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-3.4652503253517213SUM(M$559:M$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-2.4327306349929558SUM(N$559:N$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))-1.2858898652618027SUM(O$559:O$571/$M$133:$M$145*($B716=$F$132:$N$132)*($F$133:$N$145))050INDEX(Vectors[Description], MATCH($B717, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$559:F$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-66.268590640771166SUM(G$559:G$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-65.134892392848798SUM(H$559:H$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-65.014005502095685SUM(I$559:I$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-56.475327530828885SUM(J$559:J$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-48.418379734254835SUM(K$559:K$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-40.283117298230806SUM(L$559:L$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-31.667240537093019SUM(M$559:M$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-22.263389779538997SUM(N$559:N$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-11.818454595790596SUM(O$559:O$571/$M$133:$M$145*($B717=$F$132:$N$132)*($F$133:$N$145))-0.10707720710132977751INDEX(Vectors[Description], MATCH($B718, Vectors[Code], 0))Heat transportSUM(F$559:F$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))0SUM(G$559:G$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))0SUM(H$559:H$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))0SUM(I$559:I$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-1.2872199249360383SUM(J$559:J$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-2.647834935837611SUM(K$559:K$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-4.1287462668846588SUM(L$559:L$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-5.7659603854195476SUM(M$559:M$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-7.5898350512791888SUM(N$559:N$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-9.6283823595392395SUM(O$559:O$571/$M$133:$M$145*($B718=$F$132:$N$132)*($F$133:$N$145))-11.909364923159011104INDEX(Vectors[Description], MATCH($B719, Vectors[Code], 0))Environmental heatSUM(F$559:F$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))0SUM(G$559:G$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))0SUM(H$559:H$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))0SUM(I$559:I$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-6.3316368571533772SUM(J$559:J$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-13.024292855193973SUM(K$559:K$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-20.308667952401603SUM(L$559:L$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-28.361872424421005SUM(M$559:M$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-37.333231423357439SUM(N$559:N$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-47.36053213708086SUM(O$559:O$571/$M$133:$M$145*($B719=$F$132:$N$132)*($F$133:$N$145))-58.5803345892972376INDEX(Vectors[Description], MATCH($B720, Vectors[Code], 0))Heating and coolingSUM(F$559:F$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))74.58316889692SUM(G$559:G$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))73.307227955889701SUM(H$559:H$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))72.75971714915552SUM(I$559:I$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))73.73312750026804SUM(J$559:J$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))75.846028175733892SUM(K$559:K$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))78.855300291799821SUM(L$559:L$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))82.605245194387876SUM(M$559:M$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))87.000209237799368SUM(N$559:N$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))91.986063833088991SUM(O$559:O$571/$M$133:$M$145*($B720=$F$132:$N$132)*($F$133:$N$145))97.53769872067229634INDEX(Vectors[Description], MATCH($B721, Vectors[Code], 0))Conversion lossesSUM(F$559:F$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))14.291042007453724SUM(G$559:G$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))14.046556209156584SUM(H$559:H$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))13.568384876581966SUM(I$559:I$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))11.932301548479565SUM(J$559:J$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))10.405075920225269SUM(K$559:K$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))8.8751442197915598SUM(L$559:L$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))7.2626288374810741SUM(M$559:M$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))5.5068256878245156SUM(N$559:N$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))3.5580865392856849SUM(O$559:O$571/$M$133:$M$145*($B721=$F$132:$N$132)*($F$133:$N$145))1.3725268382412739Preferences.EnergyUnitsTWhSUM(F713:F721)0000000003.1086244689504383E-153711200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B725, Vectors[Code], 0))Electricity (delivered to end user)(F713-F576)*Conversion.to.average.power000-2.6718832919458237E-2-5.4961128147907629E-2-8.5700414928870386E-2-0.11968407975497633-0.15754225885794393-0.19985639948975323-0.2472027704003676446INDEX(Vectors[Description], MATCH($B726, Vectors[Code], 0))Electricity (supplied to grid)(F714-F577)*Conversion.to.average.power000000000047INDEX(Vectors[Description], MATCH($B727, Vectors[Code], 0))Solid hydrocarbons(F715-F578)*Conversion.to.average.power000000000049INDEX(Vectors[Description], MATCH($B728, Vectors[Code], 0))Liquid hydrocarbons(F716-F579)*Conversion.to.average.power000000000050INDEX(Vectors[Description], MATCH($B729, Vectors[Code], 0))Gaseous hydrocarbons(F717-F580)*Conversion.to.average.power0000000000751INDEX(Vectors[Description], MATCH($B730, Vectors[Code], 0))Heat transport(F718-F581)*Conversion.to.average.power0000000000104INDEX(Vectors[Description], MATCH($B731, Vectors[Code], 0))Environmental heat(F719-F582)*Conversion.to.average.power0002.6718832919458237E-25.4961128147907629E-28.5700414928870386E-20.119684079754976330.157542258857943510.199856399489753640.247202770400368036INDEX(Vectors[Description], MATCH($B732, Vectors[Code], 0))Heating and cooling(F720-F583)*Conversion.to.average.power000000000034INDEX(Vectors[Description], MATCH($B733, Vectors[Code], 0))Conversion losses(F721-F584)*Conversion.to.average.power0000000000Preferences.PowerUnitsGWSUM(F725:F733)0000000-4.163336342344337E-164.163336342344337E-163.8857805861880479E-163690Preferences.PowerUnits&"e"GWe-SUM(F701:F702)-SUM(F725:F726)+F686-1.2474724803837463-1.2815484217113027-1.3142678982647742-1.2407447648485603-1.1599360479496466-1.0657667308057928-0.95363627401321938-0.81992245335713498-0.66161035870166096-0.476017559396386573689371420072010201520202025203020352040204520503691Preferences.PowerUnits&"th/degree"GWth/degree$E$86*(F558/F31)1$E$86*(G558/G31)0.953775978075378950.899090358644910710.863743100141048270.840938786182388490.826252925611614010.816811322116180570.810750955543802050.806866759269757930.80438079928334194368720072010201520202025203020352040204520501INDEX($D$55:$D$67, MATCH($B743, $C$55:$C$67, 0))Gas boiler (old)F$740*E$494:E$5060.55000000000000004G$740*F$494:F$5060.52457678794145846H$740*G$494:G$5060.46977471239196594I$740*H$494:H$5060.38683351699174101J$740*I$494:I$5060.31385036841449865K$740*J$494:J$5060.246695516361182L$740*K$494:K$5060.18290739248815913M$740*L$494:L$5060.12103353550618198N$740*M$494:M$5066.0226840245492741E-2O$740*N$494:N$50602Gas boiler (new)0.150.143066396711306830.168579442245920750.138939247251260060.112865998516907728.8881207569363643E-26.6103373425545217E-24.4012194729520712E-22.2304102559814052E-28.0438079928334193E-43Resisitive heating0.20.190755195615075810.17532261993575760.144368489595003780.117130759503975549.2068183139579846E-26.8262089062566519E-24.5170410380297545E-22.2477002579657544E-204Oil-fired boiler0.19.5377597807537906E-28.5413584071266521E-27.0333366725771077E-25.7063703348090654E-24.4853730247487629E-23.325588954330165E-22.2006097364760356E-21.0950334590089586E-205Solid-fuel boiler00000000006Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0007.1567285440258283E-20.139355570281652940.205382870080601190.270714609615648420.335882538725289390.401128046036965340.466540863584338279Ground-source heat pump0003.7017561434616354E-27.2080467387061878E-20.106232519007207510.140024798077059530.173732347616529030.20748002381222350.2413142397850025810Geothermal0001.2339187144872119E-32.4026822462353955E-33.5410839669069174E-34.6674932692353172E-35.7910782538843006E-36.9160007937407826E-38.0438079928334197E-311Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0001.357310585935933E-22.6429504708589353E-23.8951923635976091E-25.1342425961588493E-26.37018607927273E-27.6076008731148601E-28.848188792116761E-2Preferences.PowerUnits&"th/degree"GWth/degreeSUM(F743:F755)1.00000000000000020.953775978075378950.899090358644910830.863866492012496990.841179054407012130.826607034008304820.817278071443104160.811330063369190560.807558359349132120.80518518008262533688200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B759, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$743:F$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.2SUM(G$743:G$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.19075519561507581SUM(H$743:H$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.1753226199357576SUM(I$743:I$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.18022276065905979SUM(J$743:J$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.18694607191142154SUM(K$743:K$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.19496230648775054SUM(L$743:L$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.2038865567847914SUM(M$743:M$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.21344315560259219SUM(N$743:N$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.22343689096343849SUM(O$743:O$755/$M$133:$M$145*($B759=$F$132:$N$132)*($F$133:$N$145))-0.2337308517782908946INDEX(Vectors[Description], MATCH($B760, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$743:F$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(G$743:G$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(H$743:H$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(I$743:I$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(J$743:J$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(K$743:K$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(L$743:L$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(M$743:M$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(N$743:N$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))0SUM(O$743:O$755/$M$133:$M$145*($B760=$F$132:$N$132)*($F$133:$N$145))047INDEX(Vectors[Description], MATCH($B761, Vectors[Code], 0))Solid hydrocarbonsSUM(F$743:F$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(G$743:G$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(H$743:H$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(I$743:I$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(J$743:J$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(K$743:K$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(L$743:L$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(M$743:M$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(N$743:N$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))0SUM(O$743:O$755/$M$133:$M$145*($B761=$F$132:$N$132)*($F$133:$N$145))049INDEX(Vectors[Description], MATCH($B762, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$743:F$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-0.10309278350515465SUM(G$743:G$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-9.832742042014217E-2SUM(H$743:H$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-8.8055241310584051E-2SUM(I$743:I$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-7.2508625490485645E-2SUM(J$743:J$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-5.8828560152670781E-2SUM(K$743:K$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-4.6240959018028487E-2SUM(L$743:L$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-3.4284422209589334E-2SUM(M$743:M$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-2.2686698314185936E-2SUM(N$743:N$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))-1.1289004732051119E-2SUM(O$743:O$755/$M$133:$M$145*($B762=$F$132:$N$132)*($F$133:$N$145))050INDEX(Vectors[Description], MATCH($B763, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$743:F$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.88851937536148062SUM(G$743:G$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.84744843627432098SUM(H$743:H$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.80337675590455282SUM(I$743:I$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.66167196121087613SUM(J$743:J$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.53698958087050841SUM(K$743:K$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.42227102030276453SUM(L$743:L$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.31330869139334755SUM(M$743:M$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.20761970113513786SUM(N$743:N$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-0.1037558452412624SUM(O$743:O$755/$M$133:$M$145*($B763=$F$132:$N$132)*($F$133:$N$145))-8.8393494426740869E-4751INDEX(Vectors[Description], MATCH($B764, Vectors[Code], 0))Heat transportSUM(F$743:F$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))0SUM(G$743:G$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))0SUM(H$743:H$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))0SUM(I$743:I$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-1.5081228732621478E-2SUM(J$743:J$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-2.9366116342877058E-2SUM(K$743:K$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-4.3279915151084543E-2SUM(L$743:L$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-5.7047139957320546E-2SUM(M$743:M$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-7.0779845325252555E-2SUM(N$743:N$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-8.4528898590165116E-2SUM(O$743:O$755/$M$133:$M$145*($B764=$F$132:$N$132)*($F$133:$N$145))-9.8313208801297347E-2104INDEX(Vectors[Description], MATCH($B765, Vectors[Code], 0))Environmental heatSUM(F$743:F$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))0SUM(G$743:G$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))0SUM(H$743:H$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))0SUM(I$743:I$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-7.4182244886685927E-2SUM(J$743:J$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.14444741025683988SUM(K$743:K$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.21288724687717556SUM(L$743:L$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.28060610852252466SUM(M$743:M$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.34815517435938764SUM(N$743:N$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.41578465298745587SUM(O$743:O$755/$M$133:$M$145*($B765=$F$132:$N$132)*($F$133:$N$145))-0.483587555112030446INDEX(Vectors[Description], MATCH($B766, Vectors[Code], 0))Heating and coolingSUM(F$743:F$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))1.0000000000000002SUM(G$743:G$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.95377597807537895SUM(H$743:H$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.89909035864491083SUM(I$743:I$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.86386649201249699SUM(J$743:J$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.84117905440701213SUM(K$743:K$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.82660703400830482SUM(L$743:L$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.81727807144310416SUM(M$743:M$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.81133006336919056SUM(N$743:N$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.80755835934913212SUM(O$743:O$755/$M$133:$M$145*($B766=$F$132:$N$132)*($F$133:$N$145))0.8051851800826251834INDEX(Vectors[Description], MATCH($B767, Vectors[Code], 0))Conversion lossesSUM(F$743:F$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))0.19161215886663527SUM(G$743:G$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))0.18275507423415993SUM(H$743:H$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))0.16766425850598371SUM(I$743:I$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))0.13980032896723193SUM(J$743:J$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))0.11539868512730554SUM(K$743:K$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))9.3034413828498877E-2SUM(L$743:L$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))7.1854847424469168E-2SUM(M$743:M$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))5.1354511367365574E-2SUM(N$743:N$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))3.1236933165240847E-2SUM(O$743:O$755/$M$133:$M$145*($B767=$F$132:$N$132)*($F$133:$N$145))1.1330370553260877E-2Preferences.PowerUnits&"/degree"GW/degreeSUM(F759:F767)0-2.2204460492503131E-160000-1.8041124150158794E-160-5.2041704279304213E-17-3.8163916471489756E-173692Preferences.PowerUnits&"e/degree"GWe/degree-SUM(F759:F760)0.2-SUM(G759:G760)0.190755195615075810.17532261993575760.180222760659059790.186946071911421540.194962306487750540.20388655678479140.213443155602592190.223436890963438490.2337308517782908993327Preferences.moneyunits&"/yr proceeding 5 years"£m/yr proceeding 5 years273931833176Preferences.moneyunits£mSUMPRODUCT(F$474:F$486,$G$381:$G$393)0SUMPRODUCT(G$474:G$486,$G$381:$G$393)11786.24067939326112178.42467853061114213.7750449682919045.1007939456124119.85095914193929376.2432267743934782.2981184881540345.39906411207646066.5253891900283177Preferences.moneyunits£mSUMPRODUCT(F$457:F$469,$I$381:$I$393)96.183054563181514SUMPRODUCT(G$457:G$469,$I$381:$I$393)98.153949826993397101.77676747216724119.97270028708954139.0286861807073158.58373478410005178.43702225425488198.70224407906591219.45683331142564240.658146744846253184Preferences.moneyunits£m181.48038121847481241.3896752606023975.538971080830812368.39300126221522511.04008268828721501.53516672558221493.84580428472322076.46387518947423040.61987847430324277.69499368154731853176Preferences.moneyunits£mSUMPRODUCT(F$474:F$486,$F$381:$F$393)0SUMPRODUCT(G$474:G$486,$F$381:$F$393)35917.25497938625636789.92113336022938359.36411018913340773.41472332628543197.8118685507845559.6573794090847857.77076811128850138.8452435328852423.3028178187673177Preferences.moneyunits£mSUMPRODUCT(F$457:F$469,$H$381:$H$393)598.10263349410411SUMPRODUCT(G$457:G$469,$H$381:$H$393)610.35840612453774636.07836860243481665.47448618322005694.85694539209078722.72043379835054748.70335049044979773.75274379620021798.41375661725101822.678456703822353184Preferences.moneyunits£m181.48038121847481289.13727293985814069.986370954338312600.21178339331922930.00571724149321915.86389206451321917.41650953582222517.52726208869423504.70832068655424769.0117780810766832722Preferences.EnergyUnitsTWh78418442691692720721722723724725726727273045INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)F818-F804-28.551697890247862-28.613334357502822-28.420993344666471-29.535255576810556-30.93286918569062-32.557592986970619-34.374765815633594-36.366154374395279-38.525940520279391-40.85768854962175646INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F819-F8050000000000273147INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsF820-F8060000000000273249INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsF821-F807-9.0805949109298663-8.9583922127739903-8.4880332545882009-7.3972293892211516-6.3551685978933428-5.2935357621012775-4.1627446020676384-2.9244114182636416-1.54647283810941550273350INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsF822-F808-78.262359826249423-77.209139015429855-77.441030409866059-67.502855617293932-58.010247282743165-48.340406313808828-38.041302137322944-26.76305808132614-14.213440446626766-0.12881330059119592751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportF823-F809000-2.3123429547112764-4.8279767450401465-7.6167150892142681-10.733256261640731-14.224416408533635-18.133873536141248-22.505306289554884104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heatF824-F810000-7.5977172936316979-15.65952699947848-24.450185546077844-34.175635983941291-45.011794803917901-57.122713244500659-70.6721422214732236INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and coolingF825-F811-F812115.89465262742715114.78086558570666114.35005700912075114.34540083166861115.78578881084574118.25843569817283121.48770480060621125.2898350864366129.54244058565749134.16395036124106148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02721Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)F6650G66500000000046INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F666000000000047INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons000000000050INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons0000000000751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transport0000000000104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and coolingF672000000000034INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion lossesF6730000000000148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)F625-28.551697890247862-28.613334357502822-28.420993344666471-29.535255576810556-30.93286918569062-32.557592986970619-34.374765815633594-36.366154374395279-38.525940520279391-40.85768854962175646INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F626000000000047INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsF627000000000049INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsF628-9.0805949109298663-8.9583922127739903-8.4880332545882009-7.3972293892211516-6.3551685978933428-5.2935357621012775-4.1627446020676384-2.9244114182636416-1.5464728381094155050INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsF629-78.262359826249423-77.209139015429855-77.441030409866059-67.502855617293932-58.010247282743165-48.340406313808828-38.041302137322944-26.76305808132614-14.213440446626766-0.12881330059119592751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportF630000-2.3123429547112764-4.8279767450401465-7.6167150892142681-10.733256261640731-14.224416408533635-18.133873536141248-22.505306289554884104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heatF631000-7.5977172936316979-15.65952699947848-24.450185546077844-34.175635983941291-45.011794803917901-57.122713244500659-70.6721422214732236INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and coolingF632+F633115.89465262742715114.78086558570666114.35005700912075114.34540083166861115.78578881084574118.25843569817283121.48770480060621125.2898350864366129.54244058565749134.16395036124106148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0889272310611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF852-F84316.670422935762357G852-G84316.44607963203258916.37115790906240114.2698327808873712.26267764949807710.2180187022661438.04028574378433095.65550554152991943.00189125170667872.3701647308780046E-210411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF853-F8443.1691470049996472E-23.1264980025210304E-23.1204108693119684E-22.7199146068287834E-22.3373690891031442E-21.9476776042240549E-21.5326247497723097E-21.0781114975777223E-25.7236155810042278E-34.7509613294200772E-510421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF854-F8457.1890492881915569E-27.0923021886006313E-26.8899330427930644E-26.0050510504267324E-25.1597689113332033E-24.2986526080377035E-23.381466587555558E-22.377066570438955E-21.2594378049362837E-25.1098898850558557E-5148SUBTOTAL(109,[2007])16.774004898694269SUBTOTAL(109,[2010])16.548267633943805SUBTOTAL(109,[2015])16.471261348183454SUBTOTAL(109,[2020])14.357082437459924SUBTOTAL(109,[2025])12.33764902950244SUBTOTAL(109,[2030])10.280482004388761SUBTOTAL(109,[2035])8.0894266571576097SUBTOTAL(109,[2040])5.6900573222100856SUBTOTAL(109,[2045])3.0202092453370457SUBTOTAL(109,[2050])2.3800255820924807E-2272410611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF6770G67700000000010411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF678000000000010421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF6790000000000148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0272510611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$63916.670422935762357G$63916.44607963203258916.37115790906240114.2698327808873712.26267764949807710.2180187022661438.04028574378433095.65550554152991943.00189125170667872.3701647308780046E-210411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$6403.1691470049996472E-2G$6403.1264980025210304E-23.1204108693119684E-22.7199146068287834E-22.3373690891031442E-21.9476776042240549E-21.5326247497723097E-21.0781114975777223E-25.7236155810042278E-34.7509613294200772E-510421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$6417.1890492881915569E-2G$6417.0923021886006313E-26.8899330427930644E-26.0050510504267324E-25.1597689113332033E-24.2986526080377035E-23.381466587555558E-22.377066570438955E-21.2594378049362837E-25.1098898850558557E-5148SUBTOTAL(109,[2007])16.774004898694269SUBTOTAL(109,[2010])16.548267633943805SUBTOTAL(109,[2015])16.471261348183454SUBTOTAL(109,[2020])14.357082437459924SUBTOTAL(109,[2025])12.33764902950244SUBTOTAL(109,[2030])10.280482004388761SUBTOTAL(109,[2035])8.0894266571576097SUBTOTAL(109,[2040])5.6900573222100856SUBTOTAL(109,[2045])3.0202092453370457SUBTOTAL(109,[2050])2.3800255820924807E-2261326187826144426916927207217227237247257267273693INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Additional electricity at peakPreferences.PowerUnitsGWF736-1.2474724803837463G736-1.2815484217113027-1.3142678982647742-1.2407447648485603-1.1599360479496466-1.0657667308057928-0.95363627401321938-0.81992245335713498-0.66161035870166096-0.476017559396386573696INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Temperature related additional electricity demandPreferences.PowerUnitsGWF7700.2G7700.190755195615075810.17532261993575760.180222760659059790.186946071911421540.194962306487750540.20388655678479140.213443155602592190.223436890963438490.233730851778290892621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units318931907841844269169272072172272372472572672731313132F7760G77611786.24067939326112178.42467853061114213.7750449682919045.1007939456124119.85095914193929376.2432267743934782.2981184881540345.39906411207646066.52538919002831333134F77796.18305456318151498.153949826993397101.77676747216724119.97270028708954139.0286861807073158.58373478410005178.43702225425488198.70224407906591219.45683331142564240.658146744846253135313631403141F7810G78135917.25497938625636789.92113336022938359.36411018913340773.41472332628543197.8118685507845559.6573794090847857.77076811128850138.8452435328852423.30281781876731423143F782598.10263349410411610.35840612453774636.07836860243481665.47448618322005694.85694539209078722.72043379835054748.70335049044979773.75274379620021798.41375661725101822.6784567038223531443145