676INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Heating933INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Commercial heating and cooling134182613401819IX.c.Scenario.Demand11840IX.c.Scenario.Electrification11841IX.c.Scenario.Fuel118351837123418391414431806183012277961572180711514123180810813164180932411838INDEX($E$17:$H$20, MATCH($E$9, $C$17:$C$20, 0), MATCH($E$10, $E$15:$H$15, 0))913421817Preferences.EnergyUnitsTWh13408044220072010201520202025203020352040204520501114(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.7848248599977981818Preferences.EnergyUnitsTWh134080442200720102015202020252030203520402045205011611(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.92424690357410121611(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.77984507577820131611(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.02245246328610141611(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.25731225054241825Preferences.EnergyUnitsTWh134080442200720102015202020252030203520402045205011612(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.6303740275470121612(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.70736101846740231612(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.19435437306141612(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.47188425573991812840838279131125413108167156141211273212740.91E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-338410.10.10.17.0000000000000007E-2484358420.10.10.10.10.050.150.05612760.10.190.190.24716090.90.20.16812770.60.550000000000000040.50.60.579999999999999960.180.250.14000000000000001912780.30.300.30.20.30.30.30.30.250.20.251030.010.010.010.010.011118040.150.330.130.30.240.150.231218050.20.70.450.20.330.350.630.250.231312790.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.00100000000000011813840838279131125413108167156141212268222691111110.970.880.930.930.930.920.880.920.890.92318140.030.127.0000000000000007E-27.0000000000000007E-27.0000000000000007E-20.080.120.080.110.08148SUM(E$73:E$75)11111111111111117178871091826182778418201614792007201020152020202520302035204020452050161300.010.040.080.080.080.080.080.080.0812711275INDEX(Vectors[Description], MATCH(F94, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G94, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H94, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I94, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J94, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K94, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L94, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M94, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N94, Vectors[Code], 0))Conversion losses8458382744245464749507511046341INDEX($D$55:$D$67, MATCH($C95, $C$55:$C$67, 0))Gas boiler (old)-10.760.24SUM(F95:N95)02INDEX($D$55:$D$67, MATCH($C96, $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.1012721275INDEX(Vectors[Description], MATCH(F112, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G112, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H112, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I112, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J112, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K112, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L112, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M112, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N112, Vectors[Code], 0))Conversion losses8458382744245464749507511046341INDEX($D$55:$D$67, MATCH($C113, $C$55:$C$67, 0))Gas boiler (old)-10.760.24SUM(F113:N113)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.1018151275INDEX(Vectors[Description], MATCH(F$130, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$130, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$130, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$130, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$130, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$130, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$130, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$130, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$130, Vectors[Code], 0))Conversion losses8458382744245464749507511046341INDEX($D$73:$D$75, MATCH($C131, $C$73:$C$75, 0))Electric air conditioner (old)-1-1.52.5SUM(F131:N131)02INDEX($D$73:$D$75, MATCH($C132, $C$73:$C$75, 0))Electric air conditioner (new)-1-56SUM(F132:N132)03INDEX($D$73:$D$75, MATCH($C133, $C$73:$C$75, 0))Absorption chiller-10.30.7SUM(F133:N133)016238312404422007123912411INDEX($D$55:$D$67, MATCH($C138, $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(F138:F150)1.00000000000000028312404422007123912411INDEX($D$73:$D$75, MATCH($C154, $C$73:$C$75, 0))Electric air conditioner (old)1120072INDEX($D$73:$D$75, MATCH($C155, $C$73:$C$75, 0))Electric air conditioner (new)0120103INDEX($D$73:$D$75, MATCH($C156, $C$73:$C$75, 0))Absorption chiller012015148SUM(F$154:F$156)17171615109162481318211670831240141220072010201520202025203020352040204520501INDEX($D$55:$D$67, MATCH($C170, $C$55:$C$67, 0))Gas boiler (old)INDEX($E55:$T55, MATCH($E$22, $E$54:$T$54, 0))0$F$138:$F$1500.55000000000000004F170+F$89*(G$169-F$169)*(-F170+$E170/SUM($E$170:$E$182))0.550000000000000040.522500000000000080.418000000000000040.250800000000000020.150489.0288000000000007E-25.41728E-23.250368E-21.9502208E-22Gas boiler (new)INDEX($E56:$T56, MATCH($E$22, $E$54:$T$54, 0))0.90.15F171+F$89*(G$169-F$169)*(-F171+$E171/SUM($E$170:$E$182))0.150.18750.330.558000000000000050.694800000000000080.776880000000000010.826127999999999970.855676800000000020.873406079999999973Resisitive heating0.10.2F172+F$89*(G$169-F$169)*(-F172+$E172/SUM($E$170:$E$182))0.20.195000000000000010.175999999999999990.145600000000000010.127360.116416000000000010.109849600000000010.105909760000000010.103545856000000014Oil-fired boiler00.1F173+F$89*(G$169-F$169)*(-F173+$E173/SUM($E$170:$E$182))0.19.5000000000000001E-27.5999999999999998E-24.5600000000000002E-22.7359999999999999E-21.6416E-29.8496E-35.90976E-33.545856E-35Solid-fuel boiler00F174+F$89*(G$169-F$169)*(-F174+$E174/SUM($E$170:$E$182))0000000006Stirling engine μCHP00F175+F$89*(G$169-F$169)*(-F175+$E175/SUM($E$170:$E$182))0000000007Fuel-cell μCHP00F176+F$89*(G$169-F$169)*(-F176+$E176/SUM($E$170:$E$182))0000000008Air-source heat pump00F177+F$89*(G$169-F$169)*(-F177+$E177/SUM($E$170:$E$182))0000000009Ground-source heat pump00F178+F$89*(G$169-F$169)*(-F178+$E178/SUM($E$170:$E$182))00000000010Geothermal00F179+F$89*(G$169-F$169)*(-F179+$E179/SUM($E$170:$E$182))00000000011Community scale gas CHP00F180+F$89*(G$169-F$169)*(-F180+$E180/SUM($E$170:$E$182))00000000012Community scale solid-fuel CHP00F181+F$89*(G$169-F$169)*(-F181+$E181/SUM($E$170:$E$182))00000000013District heating from power stations00F182+F$89*(G$169-F$169)*(-F182+$E182/SUM($E$170:$E$182))00000000018221823831240141220072010201520202025203020352040204520501INDEX($D$73:$D$75, MATCH($C187, $C$73:$C$75, 0))Electric air conditioner (old)INDEX($E73:$T73, MATCH($E$22, $E$72:$T$72, 0))0$F$154:$F$1561F187+F$89*(G$186-F$186)*(-F187+$E187/SUM($E$187:$E$189))10.950.760.455999999999999960.273599999999999950.164159999999999979.8495999999999986E-25.9097599999999986E-23.5458559999999986E-22INDEX($D$73:$D$75, MATCH($C188, $C$73:$C$75, 0))Electric air conditioner (new)INDEX($E74:$T74, MATCH($E$22, $E$72:$T$72, 0))10F188+F$89*(G$186-F$186)*(-F188+$E188/SUM($E$187:$E$189))00.050.240.544000000000000040.726400000000000050.835840000000000030.901503999999999970.940902400000000030.964541439999999973INDEX($D$73:$D$75, MATCH($C189, $C$73:$C$75, 0))Absorption chillerINDEX($E75:$T75, MATCH($E$22, $E$72:$T$72, 0))00F189+F$89*(G$186-F$186)*(-F189+$E189/SUM($E$187:$E$189))00000000073111618216193161641546511621159020072010201520202025203020352040204520501617Preferences.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.910680303690114.646559288560815.447705424312916.31895501917560117.26552329391439918.29303353840689919.407548524705620.61560435090149921.9242469035741011INDEX($D$55:$D$67, MATCH($B203, $C$55:$C$67, 0))Gas boiler (old)F$202*F$170:F$1827.424230956504835G$202*G$170:G$1827.6508741670295555H$202*H$170:H$1827.6528272282730194I$202*I$170:I$1826.457140867362793J$202*J$170:J$1824.0927939188092406K$202*K$170:K$1822.5981159452682387L$202*L$170:L$1821.6516414121156822M$202*M$170:M$1821.0513612447191716N$202*N$170:N$1820.67008300682831001O$202*O$170:O$1820.427571223356858042Gas boiler (new)2.02479026086495482.08660204555351482.74622986660514995.09774279002325779.105976900699985811.99608558461172514.21149189531755216.03311924761798617.64029436104547319.1487705450027943Resisitive heating2.69972034781994012.78213606073802032.85607906126935612.71879615467907022.37603985079196762.19893704671293792.12960179240717772.13191144241950032.18339370905893352.27016491278592984Oil-fired boiler1.349860173909971.39106803036901021.3914231324132761.17402561224778030.744144348874407390.472384717321497950.300298438566487640.191156589948940280.121833273968783647.7740222428519648E-25Solid-fuel boiler00000000006Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00000000009Ground-source heat pump000000000010Geothermal000000000011Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0000000000SUM(F203:F215)13.498601739099701SUM(G203:G215)13.910680303690114.64655928856080215.447705424312916.31895501917560117.26552329391439918.29303353840689919.40754852470559720.61560435090149921.92424690357410186845INDEX(Vectors[Description], MATCH($B220, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$203:F$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.6997203478199401SUM(G$203:G$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.7821360607380203SUM(H$203:H$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.8560790612693561SUM(I$203:I$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.7187961546790702SUM(J$203:J$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.3760398507919676SUM(K$203:K$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.1989370467129379SUM(L$203:L$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.1296017924071777SUM(M$203:M$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.1319114424195003SUM(N$203:N$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.1833937090589335SUM(O$203:O$215/$M$113:$M$125*($B220=$F$112:$N$112)*($F$113:$N$125))-2.270164912785929846INDEX(Vectors[Description], MATCH($B221, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$203:F$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(G$203:G$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(H$203:H$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(I$203:I$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(J$203:J$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(K$203:K$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(L$203:L$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(M$203:M$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(N$203:N$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))0SUM(O$203:O$215/$M$113:$M$125*($B221=$F$112:$N$112)*($F$113:$N$125))047INDEX(Vectors[Description], MATCH($B222, Vectors[Code], 0))Solid hydrocarbonsSUM(F$203:F$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(G$203:G$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(H$203:H$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(I$203:I$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(J$203:J$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(K$203:K$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(L$203:L$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(M$203:M$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(N$203:N$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))0SUM(O$203:O$215/$M$113:$M$125*($B222=$F$112:$N$112)*($F$113:$N$125))049INDEX(Vectors[Description], MATCH($B223, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$203:F$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-1.3916084267113094SUM(G$203:G$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-1.4340907529577425SUM(H$203:H$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-1.4344568375394597SUM(I$203:I$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-1.2103356827296705SUM(J$203:J$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-0.76715912255093544SUM(K$203:K$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-0.4869945539396886SUM(L$203:L$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-0.30958601914070893SUM(M$203:M$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-0.1970686494318972SUM(N$203:N$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-0.12560131336988004SUM(O$203:O$215/$M$113:$M$125*($B223=$F$112:$N$112)*($F$113:$N$125))-8.0144559204659432E-250INDEX(Vectors[Description], MATCH($B224, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$203:F$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-11.993769185478261SUM(G$203:G$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-12.359908974287979SUM(H$203:H$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-13.08734452913297SUM(I$203:I$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-14.098153137243807SUM(J$203:J$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-15.391823179075185SUM(K$203:K$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-16.601085243636508SUM(L$203:L$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-17.790236445151258SUM(M$203:M$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-19.00218241886078SUM(N$203:N$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-20.266627025171083SUM(O$203:O$215/$M$113:$M$125*($B224=$F$112:$N$112)*($F$113:$N$125))-21.605198709451798751INDEX(Vectors[Description], MATCH($B225, Vectors[Code], 0))Heat transportSUM(F$203:F$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(G$203:G$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(H$203:H$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(I$203:I$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(J$203:J$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(K$203:K$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(L$203:L$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(M$203:M$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(N$203:N$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0SUM(O$203:O$215/$M$113:$M$125*($B225=$F$112:$N$112)*($F$113:$N$125))0104INDEX(Vectors[Description], MATCH($B226, Vectors[Code], 0))Environmental heatSUM(F$203:F$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(G$203:G$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(H$203:H$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(I$203:I$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(J$203:J$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(K$203:K$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(L$203:L$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(M$203:M$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(N$203:N$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))0SUM(O$203:O$215/$M$113:$M$125*($B226=$F$112:$N$112)*($F$113:$N$125))06INDEX(Vectors[Description], MATCH($B227, Vectors[Code], 0))Heating and coolingSUM(F$203:F$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))13.498601739099701SUM(G$203:G$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))13.9106803036901SUM(H$203:H$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))14.646559288560802SUM(I$203:I$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))15.4477054243129SUM(J$203:J$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))16.318955019175601SUM(K$203:K$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))17.265523293914399SUM(L$203:L$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))18.293033538406899SUM(M$203:M$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))19.407548524705597SUM(N$203:N$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))20.615604350901499SUM(O$203:O$215/$M$113:$M$125*($B227=$F$112:$N$112)*($F$113:$N$125))21.92424690357410134INDEX(Vectors[Description], MATCH($B228, Vectors[Code], 0))Conversion lossesSUM(F$203:F$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.5864962209098104SUM(G$203:G$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.6654554842936418SUM(H$203:H$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.7313211393809844SUM(I$203:I$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.579579550339647SUM(J$203:J$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.2160671332424866SUM(K$203:K$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.0214935503747338SUM(L$203:L$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))1.9363907182922451SUM(M$203:M$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))1.9236139860065791SUM(N$203:N$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))1.9600176966983973SUM(O$203:O$215/$M$113:$M$125*($B228=$F$112:$N$112)*($F$113:$N$125))2.0312612778682868Preferences.EnergyUnitsTWhSUM(F220:F228)0SUM(G220:G228)000000-3.5527136788005009E-15002159120072010201520202025203020352040204520501816Preferences.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))76.86000658542070680.92592301714519585.35245686922810690.16632996074949395.396357697831505101.07361017105001107.231585720509113.906397931695121.1369770996821INDEX($D$55:$D$67, MATCH($B235, $C$55:$C$67, 0))Gas boiler (old)F$234*F170:F18241.020742893306G$234*G170:G18242.273003621981388H$234*H170:H18242.283794776458372I$234*I170:I18235.677326971337351J$234*J170:J18222.613715554155974K$234*K170:K18214.355243906369685L$234*L170:L1829.1257341151237643M$234*M170:M1825.80903524691999N$234*N170:N1823.7023771083244759O$234*O170:O1822.36243852388923512Gas boiler (new)11.18747533453811.52900098781310615.17361056571472528.16631076684527850.31281211809822266.28138932845334478.52206626968532588.58701544811265297.467062081719391105.801772311683023Resisitive heating14.91663377938415.37200131708414115.78055498834331315.02203240898414513.12821764228512812.14968011639582111.76658540167295911.77934679876362612.06379926741031412.543231987038974Oil-fired boiler7.4583168896927.68600065854207067.68796268662879366.48678672206133564.11158464621017662.61004434661266991.65922438456795681.05618822671272540.673159474240813790.429534277070770025Solid-fuel boiler00000000006Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00000000009Ground-source heat pump000000000010Geothermal000000000011Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0000000000SUM(F235:F247)74.5831688969276.86000658542070680.92592301714520985.35245686922812190.16632996074949395.396357697831505101.07361017105001107.23158572050899113.906397931695121.13697709968286845INDEX(Vectors[Description], MATCH($B252, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$235:F$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-14.916633779384SUM(G$235:G$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-15.372001317084141SUM(H$235:H$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-15.780554988343313SUM(I$235:I$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-15.022032408984145SUM(J$235:J$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-13.128217642285128SUM(K$235:K$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-12.149680116395821SUM(L$235:L$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-11.766585401672959SUM(M$235:M$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-11.779346798763626SUM(N$235:N$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-12.063799267410314SUM(O$235:O$247/$M$95:$M$107*($B252=$F$94:$N$94)*($F$95:$N$107))-12.5432319870389746INDEX(Vectors[Description], MATCH($B253, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$235:F$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(G$235:G$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(H$235:H$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(I$235:I$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(J$235:J$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(K$235:K$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(L$235:L$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(M$235:M$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(N$235:N$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))0SUM(O$235:O$247/$M$95:$M$107*($B253=$F$94:$N$94)*($F$95:$N$107))047INDEX(Vectors[Description], MATCH($B254, Vectors[Code], 0))Solid hydrocarbonsSUM(F$235:F$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(G$235:G$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(H$235:H$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(I$235:I$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(J$235:J$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(K$235:K$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(L$235:L$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(M$235:M$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(N$235:N$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))0SUM(O$235:O$247/$M$95:$M$107*($B254=$F$94:$N$94)*($F$95:$N$107))049INDEX(Vectors[Description], MATCH($B255, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$235:F$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-7.6889864842185567SUM(G$235:G$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-7.9237120191155368SUM(H$235:H$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-7.9257347284832926SUM(I$235:I$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-6.6874089918158104SUM(J$235:J$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-4.2387470579486362SUM(K$235:K$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-2.6907673676419277SUM(L$235:L$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-1.7105406026473782SUM(M$235:M$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-1.0888538419718818SUM(N$235:N$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-0.69397883942351934SUM(O$235:O$247/$M$95:$M$107*($B255=$F$94:$N$94)*($F$95:$N$107))-0.4428188423410000550INDEX(Vectors[Description], MATCH($B256, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$235:F$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-66.268590640771166SUM(G$235:G$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-68.29160504155729SUM(H$235:H$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-72.31086939924856SUM(I$235:I$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-77.895841131751595SUM(J$235:J$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-85.043693412429988SUM(K$235:K$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-91.725170393899575SUM(L$235:L$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-98.295529800062852SUM(M$235:M$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-104.99183605445749SUM(N$235:N$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-111.97821045500579SUM(O$235:O$247/$M$95:$M$107*($B256=$F$94:$N$94)*($F$95:$N$107))-119.37415560095185751INDEX(Vectors[Description], MATCH($B257, Vectors[Code], 0))Heat transportSUM(F$235:F$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(G$235:G$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(H$235:H$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(I$235:I$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(J$235:J$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(K$235:K$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(L$235:L$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(M$235:M$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(N$235:N$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0SUM(O$235:O$247/$M$95:$M$107*($B257=$F$94:$N$94)*($F$95:$N$107))0104INDEX(Vectors[Description], MATCH($B258, Vectors[Code], 0))Environmental heatSUM(F$235:F$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(G$235:G$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(H$235:H$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(I$235:I$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(J$235:J$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(K$235:K$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(L$235:L$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(M$235:M$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(N$235:N$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))0SUM(O$235:O$247/$M$95:$M$107*($B258=$F$94:$N$94)*($F$95:$N$107))06INDEX(Vectors[Description], MATCH($B259, Vectors[Code], 0))Heating and coolingSUM(F$235:F$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))74.58316889692SUM(G$235:G$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))76.860006585420706SUM(H$235:H$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))80.925923017145209SUM(I$235:I$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))85.352456869228121SUM(J$235:J$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))90.166329960749493SUM(K$235:K$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))95.396357697831505SUM(L$235:L$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))101.07361017105001SUM(M$235:M$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))107.23158572050899SUM(N$235:N$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))113.906397931695SUM(O$235:O$247/$M$95:$M$107*($B259=$F$94:$N$94)*($F$95:$N$107))121.13697709968234INDEX(Vectors[Description], MATCH($B260, Vectors[Code], 0))Conversion lossesSUM(F$235:F$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))14.291042007453724SUM(G$235:G$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))14.727311792336264SUM(H$235:H$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))15.091236098929969SUM(I$235:I$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))14.252825663323437SUM(J$235:J$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))12.244328151914258SUM(K$235:K$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))11.169260180105814SUM(L$235:L$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))10.699045633333188SUM(M$235:M$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))10.628450974684014SUM(N$235:N$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))10.829590630144637SUM(O$235:O$247/$M$95:$M$107*($B260=$F$94:$N$94)*($F$95:$N$107))11.223229330649824Preferences.EnergyUnitsTWhSUM(F252:F260)0SUM(G252:G260)01.4210854715202004E-1400000003162020072010201520202025203020352040204520501824Preferences.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))33.13725150194169842.57381322019720251.74616051058539860.67884288375199769.39668970233789577.92488432686870786.28904238305000394.515294516459903102.630374027547011INDEX($D$73:$D$75, MATCH($C268, $C$73:$C$75, 0))Electric air conditioner (old)F$267*F$187:F$18927.338359407609801G$267*G$187:G$18933.137251501941698H$267*H$187:H$18940.44512255918734I$267*I$187:I$18939.327081988044903J$267*J$187:J$18927.669552354990909K$267*K$187:K$18918.986934302559646L$267*L$187:L$18912.792149011098765M$267*M$187:M$1898.4991255185608914N$267*N$187:N$1895.5856270692159393O$267*O$187:O$1893.6391252752782157Q$267*Q$187:Q$18902INDEX($D$73:$D$75, MATCH($C269, $C$73:$C$75, 0))Electric air conditioner (new)002.128690661009860412.41907852254049533.00929052876109250.40975539977824865.13273531576994977.78991686448910188.92966744724397298.9912487522687883INDEX($D$73:$D$75, MATCH($C270, $C$73:$C$75, 0))Absorption chiller0000000000SUM(F268:F270)27.33835940760980133.13725150194169842.57381322019720251.74616051058539860.67884288375199769.39668970233789577.92488432686872186.28904238304998894.515294516459917102.63037402754701182845INDEX(Vectors[Description], MATCH($B275, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$268:F$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-10.935343763043921SUM(G$268:G$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-13.254900600776679SUM(H$268:H$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-16.532830800509913SUM(I$268:I$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-17.800679215641377SUM(J$268:J$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-16.569369363456545SUM(K$268:K$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-15.996399620986899SUM(L$268:L$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-15.972315490401165SUM(M$268:M$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-16.364636351505872SUM(N$268:N$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-17.055862068893703SUM(O$268:O$270/$M$131:$M$133*($B275=$F$130:$N$130)*($F$131:$N$133))-17.9541915688227546INDEX(Vectors[Description], MATCH($B276, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$268:F$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B276=$F$130:$N$130)*($F$131:$N$133))047INDEX(Vectors[Description], MATCH($B277, Vectors[Code], 0))Solid hydrocarbonsSUM(F$268:F$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B277=$F$130:$N$130)*($F$131:$N$133))049INDEX(Vectors[Description], MATCH($B278, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$268:F$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B278=$F$130:$N$130)*($F$131:$N$133))050INDEX(Vectors[Description], MATCH($B279, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$268:F$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B279=$F$130:$N$130)*($F$131:$N$133))0751INDEX(Vectors[Description], MATCH($B280, Vectors[Code], 0))Heat transportSUM(F$268:F$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B280=$F$130:$N$130)*($F$131:$N$133))0104INDEX(Vectors[Description], MATCH($B281, Vectors[Code], 0))Environmental heatSUM(F$268:F$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-16.403015644565883SUM(G$268:G$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-19.882350901165019SUM(H$268:H$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-26.040982419687289SUM(I$268:I$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-33.945481294944017SUM(J$268:J$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-44.109473520295452SUM(K$268:K$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-53.400290081351002SUM(L$268:L$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-61.952568836467556SUM(M$268:M$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-69.924406031544109SUM(N$268:N$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-77.459432447566215SUM(O$268:O$270/$M$131:$M$133*($B281=$F$130:$N$130)*($F$131:$N$133))-84.6761824587242426INDEX(Vectors[Description], MATCH($B282, Vectors[Code], 0))Heating and coolingSUM(F$268:F$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))27.338359407609801SUM(G$268:G$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))33.137251501941698SUM(H$268:H$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))42.573813220197202SUM(I$268:I$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))51.746160510585398SUM(J$268:J$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))60.678842883751997SUM(K$268:K$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))69.396689702337895SUM(L$268:L$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))77.924884326868721SUM(M$268:M$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))86.289042383049988SUM(N$268:N$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))94.515294516459917SUM(O$268:O$270/$M$131:$M$133*($B282=$F$130:$N$130)*($F$131:$N$133))102.6303740275470134INDEX(Vectors[Description], MATCH($B283, Vectors[Code], 0))Conversion lossesSUM(F$268:F$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(G$268:G$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(H$268:H$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(I$268:I$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(J$268:J$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(K$268:K$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(L$268:L$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(M$268:M$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(N$268:N$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0SUM(O$268:O$270/$M$131:$M$133*($B283=$F$130:$N$130)*($F$131:$N$133))0Preferences.EnergyUnitsTWhSUM(F275:F283)-3.5527136788005009E-15SUM(G275:G283)0000-1.4210854715202004E-1401.4210854715202004E-1401.4210854715202004E-14182945INDEX(Vectors[Description], MATCH($B288, Vectors[Code], 0))Electricity (delivered to end user)F275-10.935343763043921G275-13.254900600776679-16.532830800509913-17.800679215641377-16.569369363456545-15.996399620986899-15.972315490401165-16.364636351505872-17.055862068893703-17.9541915688227546INDEX(Vectors[Description], MATCH($B289, Vectors[Code], 0))Electricity (supplied to grid)F276000000000047INDEX(Vectors[Description], MATCH($B290, Vectors[Code], 0))Solid hydrocarbonsF277000000000049INDEX(Vectors[Description], MATCH($B291, Vectors[Code], 0))Liquid hydrocarbonsF278000000000050INDEX(Vectors[Description], MATCH($B292, Vectors[Code], 0))Gaseous hydrocarbonsF2790000000000751INDEX(Vectors[Description], MATCH($B293, Vectors[Code], 0))Heat transportF2800000000000104INDEX(Vectors[Description], MATCH($B294, Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH($B295, Vectors[Code], 0))Heating and cooling-SUM(F$288:F$294)-F29610.935343763043921-SUM(G$288:G$294)-G29613.25490060077667916.53283080050991317.80067921564137716.56936936345654515.99639962098689915.97231549040116516.36463635150587217.05586206889370317.9541915688227534INDEX(Vectors[Description], MATCH($B296, Vectors[Code], 0))Conversion lossesF2830000000000Preferences.EnergyUnitsTWhSUM(F288:F296)0SUM(G288:G296)0000000004159345INDEX(Vectors[Description], MATCH($B301, Vectors[Code], 0))Electricity (delivered to end user)SUMIFS(F$220:F$228, $B$220:$B$228, $B301)+SUMIFS(F$252:F$260, $B$252:$B$260, $B301)+SUMIFS(F$288:F$296, $B$288:$B$296, $B301)-28.551697890247862-31.409037978598839-35.16946485012258-35.541507779304595-32.073626856533636-30.345016784095659-29.8685026844813-30.275894592688999-31.303055045362949-32.76758846864765246INDEX(Vectors[Description], MATCH($B302, Vectors[Code], 0))Electricity (supplied to grid)000000000047INDEX(Vectors[Description], MATCH($B303, Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH($B304, Vectors[Code], 0))Liquid hydrocarbons-9.0805949109298663-9.3578027720732795-9.3601915660227526-7.8977446745454811-5.0059061804995713-3.1777619215816162-2.0201266217880871-1.285922491403779-0.81958015279339935-0.5229634015456594650INDEX(Vectors[Description], MATCH($B305, Vectors[Code], 0))Gaseous hydrocarbons-78.262359826249423-80.651514015845265-85.398213928381523-91.993994268995408-100.43551659150518-108.32625563753608-116.0857662452141-123.99401847331828-132.24483748017687-140.97935431040366751INDEX(Vectors[Description], MATCH($B306, Vectors[Code], 0))Heat transport0000000000104INDEX(Vectors[Description], MATCH($B307, Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH($B308, Vectors[Code], 0))Heating and cooling99.017114399063615104.02558748988749112.10531310621593118.6008415091824123.05465434338164128.6582806127328135.33895919985807143.00377059672047151.57786435149021161.0154155720788434INDEX(Vectors[Description], MATCH($B309, Vectors[Code], 0))Conversion losses16.87753822836353417.39276727662990817.82255723831095316.83240521366308314.46039528515674513.19075373048054812.63543635162543312.55206496069059312.78960832684303413.254490608518111Preferences.EnergyUnitsTWhSUM(F301:F309)00000-1.7763568394002505E-14000-4.2632564145606011E-145116389010431063-SUM(F$301:F$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))16.670422935762357-SUM(G$301:G$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))17.179329271933845-SUM(H$301:H$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))18.053319254327885-SUM(I$301:I$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))18.901331114131523-SUM(J$301:J$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))19.731611597961841-SUM(K$301:K$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))20.726471517702041-SUM(L$301:L$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))21.864812644566413-SUM(M$301:M$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))23.136380021941505-SUM(N$301:N$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))24.537945134550888-SUM(O$301:O$309*SUMIFS(EF[CO2], EF[Vector], $B$301:$B$309))26.0709420435006831044-SUM(F$301:F$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))3.1691470049996472E-2-SUM(G$301:G$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))3.2658931401947748E-2-SUM(H$301:H$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))3.4410378264801728E-2-SUM(I$301:I$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))3.6387884239927212E-2-SUM(J$301:J$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))3.8601249959483386E-2-SUM(K$301:K$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))4.0942546614003247E-2-SUM(L$301:L$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))4.34441381429264E-2-SUM(M$301:M$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))4.6132381888665371E-2-SUM(N$301:N$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))4.9030344671768492E-2-SUM(O$301:O$309*SUMIFS(EF[CH4], EF[Vector], $B$301:$B$309))5.2159534405262074E-21045-SUM(F$301:F$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))7.1890492881915569E-2-SUM(G$301:G$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))7.4085129903368269E-2-SUM(H$301:H$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))7.5978841297249272E-2-SUM(I$301:I$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))7.2017214807104074E-2-SUM(J$301:J$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))6.2358354025685014E-2-SUM(K$301:K$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))5.7265512961339554E-2-SUM(L$301:L$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))5.5136572465139151E-2-SUM(M$301:M$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))5.4971234821976758E-2-SUM(N$301:N$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))5.6146635489782944E-2-SUM(O$301:O$309*SUMIFS(EF[N2O], EF[Vector], $B$301:$B$309))5.8277341836730404E-262914291520072010201520202025203020352040204520501INDEX($D$55:$D$67, MATCH($B323, $C$55:$C$67, 0))Gas boiler (old)2Gas boiler (new)3Resisitive heating4Oil-fired boiler5Solid-fuel boiler6Stirling engine μCHPF208+F2400G208+G2400000000007Fuel-cell μCHPF209+F2410G209+G2410000000008Air-source heat pump9Ground-source heat pump10Geothermal11Community scale gas CHPF213+F2450G213+G24500000000012Community scale solid-fuel CHPF214+F2460G214+G24600000000013District heating from power stationsPreferences.EnergyUnitsTWhSUM(F323:F335)0SUM(G323:G335)0000000002916200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B341, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$323:F$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B341=$F$94:$N$94)*($F$95:$N$107))046INDEX(Vectors[Description], MATCH($B342, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$323:F$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B342=$F$94:$N$94)*($F$95:$N$107))047INDEX(Vectors[Description], MATCH($B343, Vectors[Code], 0))Solid hydrocarbonsSUM(F$323:F$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B343=$F$94:$N$94)*($F$95:$N$107))049INDEX(Vectors[Description], MATCH($B344, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$323:F$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B344=$F$94:$N$94)*($F$95:$N$107))050INDEX(Vectors[Description], MATCH($B345, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$323:F$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B345=$F$94:$N$94)*($F$95:$N$107))0751INDEX(Vectors[Description], MATCH($B346, Vectors[Code], 0))Heat transportSUM(F$323:F$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B346=$F$94:$N$94)*($F$95:$N$107))0104INDEX(Vectors[Description], MATCH($B347, Vectors[Code], 0))Environmental heatSUM(F$323:F$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B347=$F$94:$N$94)*($F$95:$N$107))06INDEX(Vectors[Description], MATCH($B348, Vectors[Code], 0))Heating and coolingSUM(F$323:F$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B348=$F$94:$N$94)*($F$95:$N$107))034INDEX(Vectors[Description], MATCH($B349, Vectors[Code], 0))Conversion lossesSUM(F$323:F$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(G$323:G$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(H$323:H$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(I$323:I$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(J$323:J$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(K$323:K$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(L$323:L$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(M$323:M$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(N$323:N$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0SUM(O$323:O$335/$M$95:$M$107*($B349=$F$94:$N$94)*($F$95:$N$107))0Preferences.EnergyUnitsTWhSUM(F341:F349)00000000002906200720102015202020252030203520402045205010431063-SUM(F$341:F$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(G$341:G$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(H$341:H$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(I$341:I$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(J$341:J$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(K$341:K$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(L$341:L$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(M$341:M$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(N$341:N$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))0-SUM(O$341:O$349*SUMIFS(EF[CO2], EF[Vector], $B$341:$B$349))01044-SUM(F$341:F$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(G$341:G$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(H$341:H$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(I$341:I$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(J$341:J$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(K$341:K$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(L$341:L$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(M$341:M$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(N$341:N$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))0-SUM(O$341:O$349*SUMIFS(EF[CH4], EF[Vector], $B$341:$B$349))01045-SUM(F$341:F$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(G$341:G$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(H$341:H$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(I$341:I$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(J$341:J$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(K$341:K$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(L$341:L$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(M$341:M$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(N$341:N$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))0-SUM(O$341:O$349*SUMIFS(EF[N2O], EF[Vector], $B$341:$B$349))06832908Preferences.EnergyUnitsTWh78418442691692720721722723724725726727291745INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)F391-F377-28.551697890247862-31.409037978598839-35.16946485012258-35.541507779304595-32.073626856533636-30.345016784095659-29.8685026844813-30.275894592688999-31.303055045362949-32.76758846864765246INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F392-F3780000000000291847INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsF393-F3790000000000291949INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsF394-F380-9.0805949109298663-9.3578027720732795-9.3601915660227526-7.8977446745454811-5.0059061804995713-3.1777619215816162-2.0201266217880871-1.285922491403779-0.81958015279339935-0.52296340154565946292050INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsF395-F381-78.262359826249423-80.651514015845265-85.398213928381523-91.993994268995408-100.43551659150518-108.32625563753608-116.0857662452141-123.99401847331828-132.24483748017687-140.97935431040366751INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Heat transportF396-F3820000000000104INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Environmental heatF397-F38300000000006INDEX(Vectors[Description], MATCH(IX.c.NoCHP.Outputs[Vector], Vectors[Code], 0))Heating and coolingF398-F384-F385115.89465262742715121.4183547665174129.92787034452689135.4332467228455137.51504962853838141.84903434321333147.9743955514835155.55583555741106164.36747267833323174.26990618059693148SUBTOTAL(109,IX.c.NoCHP.Outputs[2007])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2010])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2015])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2020])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2025])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2030])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2035])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2040])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2045])0SUBTOTAL(109,IX.c.NoCHP.Outputs[2050])02907Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)F3410G34100000000046INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F342000000000047INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbons000000000050INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbons0000000000751INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Heat transport0000000000104INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Heating and coolingF348000000000034INDEX(Vectors[Description], MATCH(IX.c.CHP.Outputs[Vector], Vectors[Code], 0))Conversion lossesF3490000000000148SUBTOTAL(109,IX.c.CHP.Outputs[2007])0SUBTOTAL(109,IX.c.CHP.Outputs[2010])0SUBTOTAL(109,IX.c.CHP.Outputs[2015])0SUBTOTAL(109,IX.c.CHP.Outputs[2020])0SUBTOTAL(109,IX.c.CHP.Outputs[2025])0SUBTOTAL(109,IX.c.CHP.Outputs[2030])0SUBTOTAL(109,IX.c.CHP.Outputs[2035])0SUBTOTAL(109,IX.c.CHP.Outputs[2040])0SUBTOTAL(109,IX.c.CHP.Outputs[2045])0SUBTOTAL(109,IX.c.CHP.Outputs[2050])0729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)F301-28.551697890247862-31.409037978598839-35.16946485012258-35.541507779304595-32.073626856533636-30.345016784095659-29.8685026844813-30.275894592688999-31.303055045362949-32.76758846864765246INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F302000000000047INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsF303000000000049INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsF304-9.0805949109298663-9.3578027720732795-9.3601915660227526-7.8977446745454811-5.0059061804995713-3.1777619215816162-2.0201266217880871-1.285922491403779-0.81958015279339935-0.5229634015456594650INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsF305-78.262359826249423-80.651514015845265-85.398213928381523-91.993994268995408-100.43551659150518-108.32625563753608-116.0857662452141-123.99401847331828-132.24483748017687-140.97935431040366751INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Heat transportF3060000000000104INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Environmental heatF30700000000006INDEX(Vectors[Description], MATCH(IX.c.Outputs[Vector], Vectors[Code], 0))Heating and coolingF308+F309115.89465262742715121.4183547665174129.92787034452689135.4332467228455137.51504962853838141.84903434321333147.9743955514835155.55583555741106164.36747267833323174.26990618059693148SUBTOTAL(109,IX.c.Outputs[2007])0SUBTOTAL(109,IX.c.Outputs[2010])0SUBTOTAL(109,IX.c.Outputs[2015])0SUBTOTAL(109,IX.c.Outputs[2020])0SUBTOTAL(109,IX.c.Outputs[2025])0SUBTOTAL(109,IX.c.Outputs[2030])0SUBTOTAL(109,IX.c.Outputs[2035])0SUBTOTAL(109,IX.c.Outputs[2040])0SUBTOTAL(109,IX.c.Outputs[2045])0SUBTOTAL(109,IX.c.Outputs[2050])0890290910641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.c.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF425-F41616.670422935762357G425-G41617.17932927193384518.05331925432788518.90133111413152319.73161159796184120.72647151770204121.86481264456641323.13638002194150524.53794513455088826.07094204350068310441053INDEX(IPCC[Sector_description], MATCH(IX.c.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF426-F4173.1691470049996472E-23.2658931401947748E-23.4410378264801728E-23.6387884239927212E-23.8601249959483386E-24.0942546614003247E-24.34441381429264E-24.6132381888665371E-24.9030344671768492E-25.2159534405262074E-210451053INDEX(IPCC[Sector_description], MATCH(IX.c.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF427-F4187.1890492881915569E-27.4085129903368269E-27.5978841297249272E-27.2017214807104074E-26.2358354025685014E-25.7265512961339554E-25.5136572465139151E-25.4971234821976758E-25.6146635489782944E-25.8277341836730404E-2148SUBTOTAL(109,IX.c.NoCHP.Emissions[2007])16.774004898694269SUBTOTAL(109,IX.c.NoCHP.Emissions[2010])17.286073333239163SUBTOTAL(109,IX.c.NoCHP.Emissions[2015])18.163708473889937SUBTOTAL(109,IX.c.NoCHP.Emissions[2020])19.009736213178556SUBTOTAL(109,IX.c.NoCHP.Emissions[2025])19.832571201947012SUBTOTAL(109,IX.c.NoCHP.Emissions[2030])20.824679577277386SUBTOTAL(109,IX.c.NoCHP.Emissions[2035])21.963393355174478SUBTOTAL(109,IX.c.NoCHP.Emissions[2040])23.237483638652147SUBTOTAL(109,IX.c.NoCHP.Emissions[2045])24.643122114712437SUBTOTAL(109,IX.c.NoCHP.Emissions[2050])26.181378919742677291010641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.c.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF3530G35300000000010441053INDEX(IPCC[Sector_description], MATCH(IX.c.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF354000000000010451053INDEX(IPCC[Sector_description], MATCH(IX.c.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF3550000000000148SUBTOTAL(109,IX.c.CHP.Emissions[2007])0SUBTOTAL(109,IX.c.CHP.Emissions[2010])0SUBTOTAL(109,IX.c.CHP.Emissions[2015])0SUBTOTAL(109,IX.c.CHP.Emissions[2020])0SUBTOTAL(109,IX.c.CHP.Emissions[2025])0SUBTOTAL(109,IX.c.CHP.Emissions[2030])0SUBTOTAL(109,IX.c.CHP.Emissions[2035])0SUBTOTAL(109,IX.c.CHP.Emissions[2040])0SUBTOTAL(109,IX.c.CHP.Emissions[2045])0SUBTOTAL(109,IX.c.CHP.Emissions[2050])0291110641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.c.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$31516.670422935762357G$31517.17932927193384518.05331925432788518.90133111413152319.73161159796184120.72647151770204121.86481264456641323.13638002194150524.53794513455088826.07094204350068310441053INDEX(IPCC[Sector_description], MATCH(IX.c.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$3163.1691470049996472E-2G$3163.2658931401947748E-23.4410378264801728E-23.6387884239927212E-23.8601249959483386E-24.0942546614003247E-24.34441381429264E-24.6132381888665371E-24.9030344671768492E-25.2159534405262074E-210451053INDEX(IPCC[Sector_description], MATCH(IX.c.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$3177.1890492881915569E-2G$3177.4085129903368269E-27.5978841297249272E-27.2017214807104074E-26.2358354025685014E-25.7265512961339554E-25.5136572465139151E-25.4971234821976758E-25.6146635489782944E-25.8277341836730404E-2148SUBTOTAL(109,IX.c.Emissions[2007])16.774004898694269SUBTOTAL(109,IX.c.Emissions[2010])17.286073333239163SUBTOTAL(109,IX.c.Emissions[2015])18.163708473889937SUBTOTAL(109,IX.c.Emissions[2020])19.009736213178556SUBTOTAL(109,IX.c.Emissions[2025])19.832571201947012SUBTOTAL(109,IX.c.Emissions[2030])20.824679577277386SUBTOTAL(109,IX.c.Emissions[2035])21.963393355174478SUBTOTAL(109,IX.c.Emissions[2040])23.237483638652147SUBTOTAL(109,IX.c.Emissions[2045])24.643122114712437SUBTOTAL(109,IX.c.Emissions[2050])26.181378919742677270227087827034426916927207217227237247257267272711INDEX(Vectors[Description], MATCH(IX.c.info[Vector], Vectors[Code], 0))Number of units