676INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Heating825INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Domestic space heating and hot water134182613401811IX.a.Scenario.ServiceDemand11265IX.a.Scenario.Insulation11839IX.a.Scenario.Electrification11836IX.a.Scenario.Fuel122581837123418391414431806183012277961572180711514123180810813164180932412259INDEX($E$18:$H$21, MATCH($E$10, $C$18:$C$21, 0), MATCH($E$11, $E$16:$H$16, 0))9682938INDEX(Modules[Module], MATCH(C28, Modules[Code], 0))Domestic lighting, appliances, and cookingPreferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205057INDEX(Vectors[Description], MATCH($C31, Vectors[Code], 0))Lighting & appliancesINDEX(INDIRECT("'"&F$30&"'!Year.Matrix"), MATCH($C$28, INDIRECT("'"&F$30&"'!Year.Modules"), 0), MATCH($C$31, INDIRECT("'"&F$30&"'!Year.Vectors"), 0))94.740506175844104INDEX(INDIRECT("'"&G$30&"'!Year.Matrix"), MATCH($C$28, INDIRECT("'"&G$30&"'!Year.Modules"), 0), MATCH($C$31, INDIRECT("'"&G$30&"'!Year.Vectors"), 0))95.39317091355827997.49406703210152699.479574068407231101.17895858855188102.58198044023743104.71146201375916106.85595455199297109.09596238766956111.436207749857371317INDEX(Modules[Module], MATCH(C33, Modules[Code], 0))Distributed solar thermalPreferences.EnergyUnitsTWh7841844220072010201520202025203020352040204520501319INDEX(Vectors[Description], MATCH($C36, Vectors[Code], 0))Domestic solar thermalINDEX(INDIRECT("'"&F$35&"'!Year.Matrix"), MATCH($C$33, INDIRECT("'"&F$30&"'!Year.Modules"), 0), MATCH($C$36, INDIRECT("'"&F$30&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&G$35&"'!Year.Matrix"), MATCH($C$33, INDIRECT("'"&G$30&"'!Year.Modules"), 0), MATCH($C$36, INDIRECT("'"&G$30&"'!Year.Vectors"), 0))000000000134212668331340804422007201020152020202520302035204020452050117.517.80746976694209118.3319709633271818.87192081741658419.42777435395860119.99999999999999320202020217.517.53442849734051717.59195990904158417.64968008442735917.70758964284173617.76568920566070617.82397939629903417.88246084021694717.9411341649268418317.517.46464400365588817.40587600786405917.34730576459032717.28893260840348117.23075587611147317.17277490675387217.1149890415943617.05739762411323916.999999999999996417.517.39093111147051817.21065814333237817.03225387002334316.85569892080579616.68097412573761316.5080605135907116.33693930979120916.16759193438091215.9999999999999641810Preferences.EnergyUnits & " (thermal energy removed)"TWh (thermal energy removed)13408044220072010201520202025203020352040204520501(Unit.TWh)*00(Unit.TWh)*1.081.08(Unit.TWh)*3.373.37(Unit.TWh)*6.46.4(Unit.TWh)*10.2510.25(Unit.TWh)*15.0515.05(Unit.TWh)*21.1321.13(Unit.TWh)*28.728.7(Unit.TWh)*38.0238.020000000000003(Unit.TWh)*49.7349.732(Unit.TWh)*00(Unit.TWh)*0.710.71(Unit.TWh)*2.232.23(Unit.TWh)*4.254.25(Unit.TWh)*6.756.75(Unit.TWh)*9.789.7799999999999994(Unit.TWh)*13.5813.58(Unit.TWh)*18.2418.239999999999998(Unit.TWh)*23.8823.88(Unit.TWh)*30.6430.643(Unit.TWh)*00(Unit.TWh)*0.340.34(Unit.TWh)*1.081.08(Unit.TWh)*2.022.02(Unit.TWh)*3.173.17(Unit.TWh)*4.564.5599999999999996(Unit.TWh)*6.36.3(Unit.TWh)*8.418.41(Unit.TWh)*10.7610.76(Unit.TWh)*13.5113.514(Unit.TWh)*00(Unit.TWh)*0000000000126783913408044220072010201520202025203020352040204520501246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.12802548227662246.8230.09213145937301213.62430671629201200.9602593887422192.10780984991348185.30666308234677179.81072389865994174.54184826508376169.50627521999087164.725406025971953246.8228.30283819197385203.47018693933961187.83847322273348178.01681076620719168.82477209324509160.25849106562734152.30950876279709147.14544840036086143.047467260448744246.8225.19898830907448194.19813453916186170.50265383586662158.40812277626478147.17216068306979136.78445042817398127.45070592362013122.78230401508345118.51274763672191268Preferences.EnergyUnitsTWh13401269442200720102015202020252030203520402045205019.4999999999999998E-3(Unit.TWh)*0.000004044.0400000000000003E-6F69*(1+$D69)^(G$68-F$68)4.1562372937950012E-64.3574453735330769E-64.5683941606682795E-64.789555213702236E-65.0214229198092126E-65.2645155999976037E-65.5193766677735158E-65.7865758438965483E-66.0667104299432579E-620(Unit.TWh)*0.000004044.0400000000000003E-6F70*(1+$D70)^(G$68-F$68)4.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-64.0400000000000003E-63-6.7000000000000002E-3(Unit.TWh)*0.000004044.0400000000000003E-6F71*(1+$D71)^(G$68-F$68)3.9593388517174792E-63.8284664790082703E-63.7019199744755394E-63.5795563504505155E-63.4612373455927814E-63.3468292686657566E-63.2362028474760383E-63.1292330828059171E-63.0257991071740218E-64-1.6E-2(Unit.TWh)*0.000004044.0400000000000003E-6F72*(1+$D72)^(G$68-F$68)3.8491661721600003E-63.5509303392001461E-63.2758020074712263E-63.0219907931423028E-62.7878450324556318E-62.5718410336075312E-62.3725731614003263E-62.1887446901417442E-62.019159365267454E-61812840838279131125413108167156141211273212740.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(F77:F89)1.00099999999999991.00099999999999991.00100000000000011.00099999999999991.00099999999999991.00100000000000011.00100000000000011.00100000000000011.00100000000000011.0010000000000001SUM(P77:P89)1.0010000000000001SUM(Q77:Q89)1.0010000000000001SUM(R77:R89)1.0010000000000001SUM(S77:S89)1.0010000000000001SUM(T77:T89)1.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$95:E$97)1111111111111111717109227018317848898337944220072010201520202025203020352040204520508481095.63.93641649048625824.19223044397462984.44804439746300064.70385835095137144.95967230443974225.21548625792811295.47130021141648375.72711416490485455.98292811839322528499.18.18111111111110928.31629629629629198.45148148148147458.58666666666665718.72185185185183988.85703703703702248.9922222222222059.12740740740738779.262592592592570385014.114.25348837209302214.50930232558139314.76511627906976415.02093023255813415.27674418604650515.53255813953487615.78837209302324716.04418604651161916.299999999999998519.99.998837209302324810.16356589147286510.32829457364340610.49302325581394710.65775193798448810.82248062015502810.98720930232556911.1519379844961111.3166666666666513078479442200715440353.8*(836.3/1245.1)*10^15/257510009228297640.43151281308110*(836.3/1245.1)*10^15/257510002869171114.888260811652.4*(836.3/1245.1)*10^15/257510001366768785.637680571268.8*(836.3/1245.1)*10^15/257510007011210869.8360405204460.1*(836.3/1245.1)*10^15/2575100012000960272.364443SUM(F118:F122)32476408683.15793612711275INDEX(Vectors[Description], MATCH(F$128, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$128, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$128, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$128, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$128, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$128, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$128, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$128, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$128, Vectors[Code], 0))Conversion losses8458382744245464749507511046341INDEX($D$77:$D$89, MATCH($C129, $C$77:$C$89, 0))Gas boiler (old)-10.760.24SUM(F129:N129)02INDEX($D$77:$D$89, MATCH($C130, $C$77:$C$89, 0))Gas boiler (new)-10.910.0903Resisitive heating-11004Oil-fired boiler-10.970.03-2.7755575615628914E-175Solid-fuel boiler117-10.870.1306Stirling engine μCHP0.22500000000000001-10.630.1449999999999999907Fuel-cell μCHP0.45-10.450.108Air-source heat pump-1-23SUM(F136:N136)09Ground-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 stations462-10.90.1012721275INDEX(Vectors[Description], MATCH(F$146, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$146, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$146, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$146, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$146, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$146, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$146, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$146, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$146, Vectors[Code], 0))Conversion losses8458382744245464749507511046341INDEX($D$77:$D$89, MATCH($C147, $C$77:$C$89, 0))Gas boiler (old)-10.760.24SUM(F147:N147)02Gas boiler (new)-10.910.0903Resisitive heating-11004Oil-fired boiler-10.970.03-2.7755575615628914E-175Solid-fuel boiler117-10.870.1306Stirling engine μCHP1180.22500000000000001-10.630.1449999999999999907Fuel-cell μCHP1180.45-10.450.108Air-source heat pump-1-12SUM(F154:N154)09Ground-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 stations462-10.90.1018151275INDEX(Vectors[Description], MATCH(F$146, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$146, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$146, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$146, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$146, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$146, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$146, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$146, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$146, Vectors[Code], 0))Conversion losses84583827442454647495075110463412268-1-1.52.5SUM(F165:N165)022269-1-56SUM(F166:N166)031814-10.30.7SUM(F167:N167)015958312404422007123912411INDEX($D$77:$D$89, MATCH($C173, $C$77:$C$89, 0))Gas boiler (old)15960.670.920072Gas boiler (new)0.150.920073Resisitive heating15940.1120074Oil-fired boiler0.040.7420075Solid-fuel boiler0.040.7420076Stirling engine μCHP00.920157Fuel-cell μCHP00.920158Air-source heat pump0120159Ground-source heat pump00.28999999999999998201510Geothermal00.01201511Community scale gas CHP00.68201512Community scale solid-fuel CHP00.68201513District heating from power stations00.42015148SUM(F173:F185)18312404422007123912411INDEX($D$95:$D$97, MATCH($C189, $C$95:$C$97, 0))Electric air conditioner (old)0120072INDEX($D$95:$D$97, MATCH($C190, $C$95:$C$97, 0))Electric air conditioner (new)0120073INDEX($D$95:$D$97, MATCH($C191, $C$95:$C$97, 0))Absorption chiller012015148SUM(F$189:F$191)01834128779442200720102015202020252030203520402045205018321300000$F197*(INDEX(Global.Assumptions[Households], MATCH(G$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1343668.450922719$F197*(INDEX(Global.Assumptions[Households], MATCH(H$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1421121.5470037553$F197*(INDEX(Global.Assumptions[Households], MATCH(I$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1497785.9353520768$F197*(INDEX(Global.Assumptions[Households], MATCH(J$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1569168.976983865$F197*(INDEX(Global.Assumptions[Households], MATCH(K$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1634561.8333038944$F197*(INDEX(Global.Assumptions[Households], MATCH(L$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1717940.9143122735$F197*(INDEX(Global.Assumptions[Households], MATCH(M$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1805573.1664201827$F197*(INDEX(Global.Assumptions[Households], MATCH(N$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1897675.5440984915$F197*(INDEX(Global.Assumptions[Households], MATCH(O$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1994476.068676500118331300000$F198*(INDEX(Global.Assumptions[Households], MATCH(G$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1343668.450922719$F198*(INDEX(Global.Assumptions[Households], MATCH(H$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1421121.5470037553$F198*(INDEX(Global.Assumptions[Households], MATCH(I$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1497785.9353520768$F198*(INDEX(Global.Assumptions[Households], MATCH(J$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1569168.976983865$F198*(INDEX(Global.Assumptions[Households], MATCH(K$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1634561.8333038944$F198*(INDEX(Global.Assumptions[Households], MATCH(L$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1717940.9143122735$F198*(INDEX(Global.Assumptions[Households], MATCH(M$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1805573.1664201827$F198*(INDEX(Global.Assumptions[Households], MATCH(N$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1897675.5440984915$F198*(INDEX(Global.Assumptions[Households], MATCH(O$196, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$196, Global.Assumptions[Year], 0)))1994476.06867650012751274027418003957.240014170327429150000274311900000274423660000274522333300274625132777.3093017532747200720102015202020252030203520402045205027410102160.2228767.00000000003326267.00000000006423767.00000000012521267.00000000012618767.00000000012716267.00000000023813767.00000000023911267.00000000023D203-M2117092690.2400141703M211/D2030.113852057510290612742019708053284675328467532846753284675328467532846753284675328467558653250.3589808743169398727430249069.76744186046664186.046511627851079302.32558139531494418.60465116291909534.88372093022324651.16279069752739767.44186046533154883.7209302327357000083300000.327440165069.76744186046440186.04651162791715302.3255813953990418.604651162751265534.88372093021540651.16279069781815767.44186046512090883.72093023272366000212940000.127450319774854345805609580578458059595806134580630958064845806659580156737200.2981905943143198827460175344.95797187273467586.55459166056759828.151211448481052069.74783123631344311.34445102421636552.94107081211928794.53769059992221036.13431038752513277.730930175622619499.5783715770.100000000000000022748200720102015202020252030203520402045205027410400197.862000708531067194.29866855611734190.73533640362059489.31000354262156989.31000354282254489.31000354282351989.31000354332449489.31000354332546989.3100035433D203-M2195456967.930010627M219/D2030.318216256487526442742019764003678300431880045750004575000457500045750004575000457500045750000.527430373604.65116279072996279.069767441831618953.48837209312241627.90697674412864302.32558139553486976.74418604654109651.16279069754732325.5813953485535500065450000.4527440577744.186046511521540651.16279069752503558.13953488323466465.11627906894429372.09302325555392279.06976744166355186.04651162687318093.02325581298280999.9999999991153790000.35274503215995.25536307.52631578975830166.73684210526124025.94736842076417885.15789473626711744.36842105177005603.57894736717299462.78947368367593321.9999999991147399780.33999999999999997274601449967.92169048593866581.12450796186283194.32732543816440274.18550857446597354.04369170966754433.90187484586911513.76005798217068593.61824111737225673.476424253517907103.8328774980.287499999999999982749200720102015202020252030203520402045205027410509342.733455447191358247.28921452582207151.84497360473056056.40073268353904960.95649176184753865.51225084075602770.06800991955700270.06800991955797770.0680099195D203-M2272206187.1720042508M227/D2030.724362948745545192742022875006100000686250068625006862500686250068625006862500686250022875000.7527430498139.534883720921328372.09302325572158604.65116279062988837.20930232573819069.76744186044649302.32558139515479534.88372093076309767.4418604653714000047600000.627440990418.604651162752641116.27906976734291813.95348837235942511.62790697727593209.30232558129243906.976744186110894604.6511627912545302.3255813961419600094640000.6274503215995.26382622.05263157568087005.47368420299791388.894736830111495772.31578945713200155.73684208514904539.15789470816608922.57894733518313305.9999999634019994.00000003730.81999999999999829274602899935.84338097187733162.249015923612566388.65465087612723468.51283401312880548.37101714713037628.22920028313194708.08738341913351787.94556655413508867.8037496911623909.5055520630.537499999999999872750200720102015202020252030203520402045205027410696295.448954722611856787.86387926043017280.27880379844177772.69372833575338265.10865287396498757.52357741177659249.93850194947671524.44445777687683798.9504136043D203-M235320158.28960056603M235/D2030.96000000000000008274202387982.53172243296367953.41792648758755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.9496489204394064.050351079550.9569328906720131527430794476.841790485312118604.91144129453442732.98109210284766861.05074291216090989.12039372147415117.19004453078739245.259695338110063373.32934614811387501.398996957512498.601003043350.95693289067201315274401579606.89720696494212285.05921857346844963.22123018099477641.383241789412110319.54525339814742997.70726500617375675.86927661320008354.03128822122641032.193299831018967.806700170.95693289067201315274503215995.27082846.57142857099954270.857142858212825695.14285714215697119.42857142918568543.7142857162143996821439968214399688933320.96274605550087.978739871614800234.60997299124050381.2412061124063228.73716003824076076.23311396724088923.72906789624101771.22502182424114618.72097575324127466.2169296821005311.0923720710.96442109853832134611712801181281440130645412954621305464159715961282159415988138168167944220072010201520202025203020352040204520501244INDEX(Global.Assumptions[Households], MATCH(F$261, Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$261, Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$261, Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$261, Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$261, Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$261, Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$261, Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$261, Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$261, Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$261, Global.Assumptions[Year], 0))39954878.820088171245651G262-F262874800H262-G2621551600I262-H2621535800143000013100001670313.8885144741755516.68365032971845065.6776347161939182.5702886507128483124044212831INDEX($D$77:$D$89, MATCH($C268, $C$77:$C$89, 0))Gas boiler (old)INDEX($E77:$T77, MATCH($E$23, $E$76:$T$76, 0))02Gas boiler (new)0.93Resisitive heating0.14Oil-fired boiler05Solid-fuel boiler06Stirling engine μCHP07Fuel-cell μCHP08Air-source heat pump09Ground-source heat pump010Geothermal011Community scale gas CHP012Community scale solid-fuel CHP013District heating from power stations083124044212831INDEX($D$95:$D$97, MATCH($C283, $C$95:$C$97, 0))Electric air conditioner (old)INDEX($E95:$T95, MATCH($E$23, $E$94:$T$94, 0))02INDEX($D$95:$D$97, MATCH($C284, $C$95:$C$97, 0))Electric air conditioner (new)INDEX($E96:$T96, MATCH($E$23, $E$94:$T$94, 0))13INDEX($D$95:$D$97, MATCH($C285, $C$95:$C$97, 0))Absorption chillerINDEX($E97:$T97, MATCH($E$23, $E$94:$T$94, 0))01242124383124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C291, $C$77:$C$89, 0))Gas boiler (old)INDEX($F$173:$F$185, MATCH($C291,$C$173:$C$185, 0))0.67G316/G$3290.57292524538031164H316/H$3290.43772176493584880.334062378480540490.254476389064604070.193502363403269590.147549939869572930.112510174928161758.5791559614020158E-26.5418009577404818E-22Gas boiler (new)INDEX($F$173:$F$185, MATCH($C292,$C$173:$C$185, 0))0.150.25866577009666608H317/H$3290.410012949698676630.526049576327753290.615138370450070140.683392876787384810.734832156862418320.77405577433414730.803964672073857910.826770884801412593Resisitive heating0.10.19.9999999999999992E-20.10.10.10.10.19.9999999999999992E-29.9999999999999992E-24Oil-fired boiler0.043.4204492261511142E-22.6132642682737243E-21.9944022595853161E-21.5192620242662928E-21.155237990467281E-28.8089516340043514E-36.7170253688454765E-35.1218841560609039E-33.905552810591332E-35Solid-fuel boiler0.043.4204492261511142E-22.6132642682737243E-21.9944022595853161E-21.5192620242662928E-21.155237990467281E-28.8089516340043514E-36.7170253688454765E-35.1218841560609039E-33.905552810591332E-36Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00000000009Ground-source heat pump000000000010Geothermal000000000011Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0000000000148SUM(F291:F303)1SUM(G291:G303)0.9999999999999998911.00000000000000020.9999999999999998910.999999999999999890.999999999999999890.99999999999999978183124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C307, $C$95:$C$97, 0))Electric air conditioner (old)INDEX($F$189:$F$191, MATCH($C307,$C$189:$C$191, 0))0G332/G$3350000000002INDEX($D$95:$D$97, MATCH($C308, $C$95:$C$97, 0))Electric air conditioner (new)INDEX($F$189:$F$191, MATCH($C308,$C$189:$C$191, 0))0G333/G$3351111111113INDEX($D$95:$D$97, MATCH($C309, $C$95:$C$97, 0))Absorption chillerINDEX($F$189:$F$191, MATCH($C309,$C$189:$C$191, 0))0G334/G$335000000000SUM(F307:F309)0111111111128881683124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C316, $C$77:$C$89, 0))Gas boiler (old)F291*F$26217448542F316+G365+G390-G4151542165812461500.92595868210023474.8538329217999414.39496801426336196.18916738225077947.98485481464069563.97293617723261425.87108315812613768.64531657612Gas boiler (new)3906390F317+G366+G391-G416696261011672658.66497162715784012.32779897219336751.64742386322377563.07182755725289332.36736286127998085.45569140830563276.76912946333033530.5142175113Resisitive heating2604260F318+G367+G392-G417269174028469003000480314348032744803441511.38885144753617063.05721648043801569.62497995143995487.88200881614Oil-fired boiler1041704F319+G368+G393-G418920696743970.20453484671598416.40918405494477576.97880406055378280.36950253026303161.07372267544242959.04316036875194711.9923034721156045.889272631415Solid-fuel boiler1041704F320+G369+G394-G419920696743970.20453484671598416.40918405494477576.97880406055378280.36950253026303161.07372267544242959.04316036875194711.9923034721156045.889272631416Stirling engine μCHP0F321+G370+G395-G4200000000007Fuel-cell μCHP0F322+G371+G396-G4210000000008Air-source heat pumpF298*F$2620F323+G372+G397-G4220000000009Ground-source heat pump0F324+G373+G398-G42300000000010Geothermal0F325+G374+G399-G42400000000011Community scale gas CHP0F326+G375+G400-G42500000000012Community scale solid-fuel CHP0F327+G376+G401-G42600000000013District heating from power stations0F328+G377+G402-G427000000000148SUM(F316:F328)26042600SUM(G316:G328)2691740028469000.0000000043000480031434799.9999999963274480034415113.88851447436170630.57216480438015696.2497995239954878.82008816383124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C332, $C$95:$C$97, 0))Electric air conditioner (old)F307*F$2620F332+G381+G406-G4310000000002INDEX($D$95:$D$97, MATCH($C333, $C$95:$C$97, 0))Electric air conditioner (new)F308*F$2620F333+G382+G407-G43239000009869744.886628832715044389.77039862819495375.52989848723287790.7624367426836087.04544758130096654.49315557633147896.44221270836053731.5882723783INDEX($D$95:$D$97, MATCH($C334, $C$95:$C$97, 0))Absorption chillerF309*F$2620F334+G383+G408-G433000000000148SUM(F332:F334)039000009869744.886628832715044389.77039862819495375.52989848723287790.7624367426836087.04544758130096654.49315557633147896.44221270836053731.588272378128683124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C341, $C$77:$C$89, 0))Gas boiler (old)(F$340>=$H173)*111111111112Gas boiler (new)(F$340>=$H174)*111111111113Resisitive heating(F$340>=$H175)*111111111114Oil-fired boiler(F$340>=$H176)*111111111115Solid-fuel boiler(F$340>=$H177)*111111111116Stirling engine μCHP(F$340>=$H178)*100111111117Fuel-cell μCHP(F$340>=$H179)*100111111118Air-source heat pump(F$340>=$H180)*100111111119Ground-source heat pump(F$340>=$H181)*1001111111110Geothermal(F$340>=$H182)*1001111111111Community scale gas CHP(F$340>=$H183)*1001111111112Community scale solid-fuel CHP(F$340>=$H184)*1001111111113District heating from power stations(F$340>=$H185)*1001111111183124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C356, $C$95:$C$97, 0))Electric air conditioner (old)(F$355>=$H189)*111111111112INDEX($D$95:$D$97, MATCH($C357, $C$95:$C$97, 0))Electric air conditioner (new)(F$355>=$H190)*111111111113INDEX($D$95:$D$97, MATCH($C358, $C$95:$C$97, 0))Absorption chiller(F$355>=$H191)*100111111111289129183124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C365, $C$77:$C$89, 0))Gas boiler (old)(F341*$F268*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000002Gas boiler (new)(F342*$F269*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)78732013964401382220128700011790001503282.49966302681579965.01528529681660559.10987124451745264.31325978583Resisitive heating(F343*$F270*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)87480155160153580143000131000167031.38885144741175551.66836503299184506.56776347163193918.257028865074Oil-fired boiler(F344*$F271*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000005Solid-fuel boiler(F345*$F272*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000006Stirling engine μCHP(F346*$F273*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000007Fuel-cell μCHP(F347*$F274*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000008Air-source heat pump(F348*$F275*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000009Ground-source heat pump(F349*$F276*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)00000000010Geothermal(F350*$F277*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)00000000011Community scale gas CHP(F351*$F278*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)00000000012Community scale solid-fuel CHP(F352*$F279*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)00000000013District heating from power stations(F353*$F280*G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280)0000000001285SUM(G$365:G$377)87480015516001535800143000013100001670313.88851447431755516.68365032971845065.6776347161939182.570288650983124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C381, $C$95:$C$97, 0))Electric air conditioner (old)(F356*$F283*G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)0000000002INDEX($D$95:$D$97, MATCH($C382, $C$95:$C$97, 0))Electric air conditioner (new)(F357*$F284*G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)87480015516001535800143000013100001670313.8885144741755516.68365032971845065.6776347161939182.57028865073INDEX($D$95:$D$97, MATCH($C383, $C$95:$C$97, 0))Absorption chiller(F358*$F285*G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)0000000001285SUM(G381:G383)87480015516001535800143000013100001670313.8885144741755516.68365032971845065.6776347161939182.57028865071290129183124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C390, $C$77:$C$89, 0))Gas boiler (old)(F341*$F268*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000002Gas boiler (new)(F342*$F269*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))27226804650068.02915223595012826.96151689915453036.7090843465882260.3964273935852245.75020449896150769.09911993526464520.13901957786794275.63518342663Resisitive heating(F343*$F270*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))302520516674.22546135954556980.77350187767605892.96767603839653584.48849193251650249.52780049993683418.78879110387718280.01544661971754919.515020380734Oil-fired boiler(F344*$F271*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000005Solid-fuel boiler(F345*$F272*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000006Stirling engine μCHP(F346*$F273*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000007Fuel-cell μCHP(F347*$F274*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000008Air-source heat pump(F348*$F275*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000009Ground-source heat pump(F349*$F276*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))00000000010Geothermal(F350*$F277*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))00000000011Community scale gas CHP(F351*$F278*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))00000000012Community scale solid-fuel CHP(F352*$F279*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))00000000013District heating from power stations(F353*$F280*(F$197*(G$196-F$196)-G$263)/SUMPRODUCT(F$341:F$353,$F$268:$F$280))0000000001292SUM(G390:G402)3025200SUM(H390:H402)5166742.25461359515569807.73501877676058929.67676038486535844.88491932586502495.27800499836834187.88791103947182800.15446619787549195.150203807383124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C406, $C$95:$C$97, 0))Electric air conditioner (old)MAX((F356*$F283*(F$198*(G$196-F$196)-G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)), 0)0000000002INDEX($D$95:$D$97, MATCH($C407, $C$95:$C$97, 0))Electric air conditioner (new)MAX((F357*$F284*(F$198*(G$196-F$196)-G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)), 0)30252005166742.25461359515569807.73501877676058929.67676038396535844.88491932496502495.27800499836834187.88791103857182800.15446619697549195.15020380733INDEX($D$95:$D$97, MATCH($C408, $C$95:$C$97, 0))Absorption chillerMAX((F358*$F285*(F$198*(G$196-F$196)-G$263)/SUMPRODUCT(F$356:F$358,$F$283:$F$285)), 0)0000000001292SUM(G406:G408)30252005166742.25461359515569807.73501877676058929.67676038396535844.88491932496502495.27800499836834187.88791103857182800.15446619697549195.15020380731293129183124044220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($C415, $C$77:$C$89, 0))Gas boiler (old)G$403/F$329*F31620268842960157.07404131812438026.07212576132024060.45886490631663218.20580063251258248.20431256761008384.0119186374808138.10185301909647657.225766581832Gas boiler (new)G$403/F$329*F3174537801336459.36418061032283693.2986895543187297.38945945174020448.97202370044443758.95433222135021981.02607668475559887.93545276586069286.20335516243Resisitive heatingG$403/F$329*F318302520516674.22546135949556980.77350187756605892.9676760385653584.48849193263650249.52780049981683418.78879110399718280.01544661983754919.515020380614Oil-fired boilerG$403/F$329*F319121008176725.79546515332145553.79535079174120839.430379994499296.60930153030575119.29577985478760202.03056230670348247.05085689665438666.1030308406995Solid-fuel boilerG$403/F$329*F320121008176725.79546515332145553.79535079174120839.430379994499296.60930153030575119.29577985478760202.03056230670348247.05085689665438666.1030308406996Stirling engine μCHPG$403/F$329*F3210000000007Fuel-cell μCHPG$403/F$329*F3220000000008Air-source heat pumpG$403/F$329*F3230000000009Ground-source heat pumpG$403/F$329*F32400000000010GeothermalG$403/F$329*F32500000000011Community scale gas CHPG$403/F$329*F32600000000012Community scale solid-fuel CHPG$403/F$329*F32700000000013District heating from power stationsG$403/F$329*F3280000000001294SUM(G415:G427)30252005166742.25461359515569807.73501877676058929.67676038576535844.88491932776502495.27800499836834187.88791103947182800.15446619887549195.150203806383124044220072010201520202025203020352040204520501INDEX($D$95:$D$97, MATCH($C431, $C$95:$C$97, 0))Electric air conditioner (old)G$409/F$262*F3320000000002INDEX($D$95:$D$97, MATCH($C432, $C$95:$C$97, 0))Electric air conditioner (new)G$409/F$262*F3330748597.367984761481930962.85124898283037943.91726052444053429.65238106814624512.88350862825329137.12385336965976623.88304377916582542.57443278753INDEX($D$95:$D$97, MATCH($C433, $C$95:$C$97, 0))Absorption chillerG$409/F$262*F3340000000001294SUM(G431:G433)0748597.367984761481930962.85124898283037943.91726052444053429.65238106814624512.88350862825329137.12385336965976623.88304377916582542.5744327875731112962130131303413025161661304711621159020072010201520202025203020352040204520501298INDEX(F$69:F$72, MATCH($E$8, $C69:$C$72, 0))4.0400000000000003E-6INDEX(G$69:G$72, MATCH($E$8, $C69:$C$72, 0))4.1562372937950012E-6INDEX(H$69:H$72, MATCH($E$8, $C69:$C$72, 0))4.3574453735330769E-6INDEX(I$69:I$72, MATCH($E$8, $C69:$C$72, 0))4.5683941606682795E-6INDEX(J$69:J$72, MATCH($E$8, $C69:$C$72, 0))4.789555213702236E-6INDEX(K$69:K$72, MATCH($E$8, $C69:$C$72, 0))5.0214229198092126E-6INDEX(L$69:L$72, MATCH($E$8, $C69:$C$72, 0))5.2645155999976037E-6INDEX(M$69:M$72, MATCH($E$8, $C69:$C$72, 0))5.5193766677735158E-6INDEX(N$69:N$72, MATCH($E$8, $C69:$C$72, 0))5.7865758438965483E-6INDEX(O$69:O$72, MATCH($E$8, $C69:$C$72, 0))6.0667104299432579E-6834852INDEX(Global.Assumptions[Households], MATCH(F$448,Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$448,Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$448,Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$448,Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$448,Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$448,Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$448,Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$448,Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$448,Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$448,Global.Assumptions[Year], 0))39954878.820088178361297F450*F451105.21210400000001G450*G451111.87510173199756124.05211233911317137.0737531120196150.55871023168706164.42548922456871181.17890394177863199.63933443866182219.98070960799851242.394680064947868581321MIN(F$36, F$453)00000000008361300Preferences.EnergyUnitsTWhF$453-F$454105.21210400000001G$453-G$454111.87510173199756124.05211233911317137.0737531120196150.55871023168706164.42548922456871181.17890394177863199.63933443866182219.98070960799851242.394680064947862161020072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($B461, $C$77:$C$89, 0))Gas boiler (old)F$456*F$291:F$30370.492109680000013G$456*G$291:G$30364.096070111752027H$456*H$291:H$30354.300309557096803I$456*I$291:I$30345.791183991855654J$456*J$291:J$30338.313636921983779K$456*K$291:K$30331.816720768692882L$456*L$291:L$30326.732936382244567M$456*M$291:M$30322.461456440235626N$456*N$291:N$30318.872488162269061O$456*O$291:O$30315.8569775020007372Gas boiler (new)15.78181560000000228.93825934415000850.86297249651138972.10758975023296192.614439668984275112.36720809835116133.13608476150608154.53197960647216176.85671906256908200.404864108452273Resisitive heating10.52121040000000111.18751017319975612.40521123391131513.70737531120196115.05587102316870616.44254892245687218.11789039417786319.96393344386618221.99807096079984724.2394680064947864Oil-fired boiler4.20848416000000033.82663105144788233.24180952579682422.73380202936451642.28738130877515111.89950571753390321.59599620192504821.34098247404391781.12671571118024220.946685224000043855Solid-fuel boiler4.20848416000000033.82663105144788233.24180952579682422.73380202936451642.28738130877515111.89950571753390321.59599620192504821.34098247404391781.12671571118024220.946685224000043856Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00000000009Ground-source heat pump000000000010Geothermal000000000011Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013INDEX($D$77:$D$89, MATCH($B473, $C$77:$C$89, 0))District heating from power stations0000000000Preferences.EnergyUnitsTWhSUM(F461:F473)105.21210400000001111.87510173199755124.05211233911315137.0737531120196150.55871023168703164.42548922456874181.17890394177863199.63933443866182219.98070960799851242.3946800649478986845INDEX(Vectors[Description], MATCH($B478, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$461:F$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-10.521210400000001SUM(G$461:G$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-11.187510173199756SUM(H$461:H$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-12.405211233911315SUM(I$461:I$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-13.707375311201961SUM(J$461:J$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-15.055871023168706SUM(K$461:K$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-16.442548922456872SUM(L$461:L$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-18.117890394177863SUM(M$461:M$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-19.963933443866182SUM(N$461:N$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-21.998070960799847SUM(O$461:O$473/$M$147:$M$159*($B478=$F$146:$N$146)*($F$147:$N$159))-24.23946800649478646INDEX(Vectors[Description], MATCH($B479, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$461:F$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(G$461:G$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(H$461:H$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(I$461:I$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(J$461:J$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(K$461:K$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(L$461:L$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(M$461:M$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(N$461:N$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))0SUM(O$461:O$473/$M$147:$M$159*($B479=$F$146:$N$146)*($F$147:$N$159))047INDEX(Vectors[Description], MATCH($B480, Vectors[Code], 0))Solid hydrocarbonsSUM(F$461:F$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-4.8373381149425292SUM(G$461:G$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-4.3984264959171062SUM(H$461:H$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-3.7262178457434763SUM(I$461:I$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-3.1423011831776053SUM(J$461:J$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-2.6291739181323575SUM(K$461:K$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-2.1833399052113829SUM(L$461:L$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-1.8344783930172968SUM(M$461:M$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-1.5413591655677217SUM(N$461:N$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-1.2950755300922323SUM(O$461:O$473/$M$147:$M$159*($B480=$F$146:$N$146)*($F$147:$N$159))-1.088143935632234249INDEX(Vectors[Description], MATCH($B481, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$461:F$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-4.338643463917526SUM(G$461:G$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-3.9449804654101879SUM(H$461:H$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-3.3420716760792004SUM(I$461:I$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-2.8183526075922849SUM(J$461:J$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-2.3581250605929394SUM(K$461:K$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-1.9582533170452612SUM(L$461:L$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-1.6453569092010807SUM(M$461:M$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-1.3824561588081627SUM(N$461:N$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-1.1615625888456105SUM(O$461:O$473/$M$147:$M$159*($B481=$F$146:$N$146)*($F$147:$N$159))-0.9759641484536534250INDEX(Vectors[Description], MATCH($B482, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$461:F$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-110.09543040023136SUM(G$461:G$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-116.13721935113989SUM(H$461:H$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-127.34115210281485SUM(I$461:I$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-139.49066749966121SUM(J$461:J$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-152.18678968686132SUM(K$461:K$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-165.34455473432246SUM(L$461:L$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-181.47830614023596SUM(M$461:M$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-199.36991015259292SUM(N$461:N$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-219.18026419204358SUM(O$461:O$473/$M$147:$M$159*($B482=$F$146:$N$146)*($F$147:$N$159))-241.0895694754835751INDEX(Vectors[Description], MATCH($B483, Vectors[Code], 0))Heat transportSUM(F$461:F$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(G$461:G$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(H$461:H$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(I$461:I$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(J$461:J$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(K$461:K$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(L$461:L$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(M$461:M$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(N$461:N$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0SUM(O$461:O$473/$M$147:$M$159*($B483=$F$146:$N$146)*($F$147:$N$159))0104INDEX(Vectors[Description], MATCH($B484, Vectors[Code], 0))Environmental heatSUM(F$461:F$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(G$461:G$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(H$461:H$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(I$461:I$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(J$461:J$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(K$461:K$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(L$461:L$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(M$461:M$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(N$461:N$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))0SUM(O$461:O$473/$M$147:$M$159*($B484=$F$146:$N$146)*($F$147:$N$159))06INDEX(Vectors[Description], MATCH($B485, Vectors[Code], 0))Heating and coolingSUM(F$461:F$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))105.21210400000001SUM(G$461:G$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))111.87510173199755SUM(H$461:H$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))124.05211233911315SUM(I$461:I$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))137.0737531120196SUM(J$461:J$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))150.55871023168703SUM(K$461:K$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))164.42548922456874SUM(L$461:L$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))181.17890394177863SUM(M$461:M$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))199.63933443866182SUM(N$461:N$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))219.98070960799851SUM(O$461:O$473/$M$147:$M$159*($B485=$F$146:$N$146)*($F$147:$N$159))242.3946800649478934INDEX(Vectors[Description], MATCH($B486, Vectors[Code], 0))Conversion lossesSUM(F$461:F$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))24.580518379091405SUM(G$461:G$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))23.793034753669389SUM(H$461:H$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))22.762540519435682SUM(I$461:I$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))22.084943489613458SUM(J$461:J$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))21.671249457068257SUM(K$461:K$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))21.503207654467243SUM(L$461:L$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))21.897127894853575SUM(M$461:M$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))22.618324482173179SUM(N$461:N$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))23.654263663782807SUM(O$461:O$473/$M$147:$M$159*($B486=$F$146:$N$146)*($F$147:$N$159))24.998465501116303Preferences.EnergyUnitsTWhSUM(F478:F486)0000-2.8421709430404007E-140004.9737991503207013E-143.1974423109204508E-14315912007201020152020202520302035204020452050838828INDEX(F$45:F$48, MATCH($E$8, $C$45:$C$48, 0))-F$11011.913.87105327645583214.1397405193525514.42387641995358314.72391600300722915.04032769556025114.78451374207188714.52869978858351614.27288583509514614.017071881606775834835829INDEX(F$61:F$64, MATCH($E$9, $C$61:$C$64, 0))246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.1280254822766834854711(31+31+28.25)*24*60*60779760083686084F492*F493*$F49422900927392G492*G493*$F49425192784740.10365724607889207.168824429137696.50559224271701395.42016224136966567.96176523105643828.10799822120684081.18692821199406796.83550620343703788.669868855828INDEX(F$45:F$48, MATCH($E$8, $C$45:$C$48, 0))-F$1118.49.626358655830982210.01567466703088810.42043933593510910.84110768729194311.27814814814815311.14296296296297811.00777777777779510.87259259259261210.73740740740743834835829INDEX(F$61:F$64, MATCH($E$9, $C$61:$C$64, 0))246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.1280254822766834864711(31+30+31)*24*60*60794880083686184F497*F498*$F49916478816256.00000217822531512.75437517768622020.14373417990895917.27371618217600098.26917318450315717.51300417752206165.02857617084885548.65419216462115646.11719115885934655.411701856828INDEX(F$45:F$48, MATCH($E$8, $C$45:$C$48, 0))-F$1123.40000000000000043.55398139484906933.8226686377457874.10680453834681994.40684412140046614.72325581395348774.4674418604651244.21162790697675333.95581395348838073.7000000000000099834835829INDEX(F$61:F$64, MATCH($E$9, $C$61:$C$64, 0))246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.1280254822766834865711(30+31+31)*24*60*60794880083686284F502*F503*$F5046669997056.000001G502*G503*$F5046579948625.44132716781725284.66305837090400953.36389927405343274.39525137726938841.13677127117222699.28172976536758119.28880025989469965.16875845474129461.1280394857828INDEX(F$45:F$48, MATCH($E$8, $C$45:$C$48, 0))-F$1137.67.80863255763976668.16840507185431448.54362624377317748.93475109814465369.34224806201550539.17751937984497179.0127906976744318.84806201550389038.6833333333333496834835829INDEX(F$61:F$64, MATCH($E$9, $C$61:$C$64, 0))246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.1280254822766834866711(30+31+30)*24*60*60786240083686384F507*F508*$F50914747346432G507*G508*$F50914299995638.02253314333900026.87116414590244423.86351214850925847.58153215117186353.19280114462072059.85799213836468887.64698213251170936.53709812707302775.24193685984(F$495+F$500+F$505+F$510)60797087136(G$495+G$500+G$505+G$510)63895260516.32189963492136538.84674864100678991.00672164745570615.66610765431407479.80434462437144752.27629959578796636.77690156902163344.65855454411070680.45154613098415115822611308115822611161158226171131122612041312226113132260$F$123/$F$512*F$51232476408683.1579434131381801.28674733916042224.02744734241111636.20485734585597942.13484234951956255.32021333352489823.21268831825625857.67369530395829780.51411429065145248.7135961310F$512-F$52028320678452.84206G$512-G$52029763878715.03515229576094314.81930229859567354.80186530159972673.53126530479451224.48413129084654929.0636127753170779.10320726506333564.1444425345925431.737949834852INDEX(Global.Assumptions[Households], MATCH(F$490,Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$490,Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$490,Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$490,Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$490,Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$490,Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$490,Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$490,Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$490,Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$490,Global.Assumptions[Year], 0))39954878.8200881783683784F$522*F5237.3754410067598464E+17G$522*G5238.0116622892408717E+178.4200182904859072E+178.9593034656735898E+179.4807270899792064E+179.98043534455488E+171.000951711791868E+181.0038496874571414E+181.0076567254703809E+181.0126933792080808E+181299Preferences.EnergyUnitsTWhMAX(F$524, 0)/Preferences.Unit.Energy204.87336129888465MAX(G$524, 0)/Preferences.Unit.Energy222.54617470113536233.8893969579419248.86954071315532263.35353027720021277.23431512652451278.04214216440784278.84713540476156279.90464596399477281.303716446689124159220072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($B531, $C$77:$C$89, 0))Gas boiler (old)F$526*F$291:F$303137.26515207025273G$526*G$291:G$303127.50232174909767H$526*H$291:H$303102.37847963621168I$526*I$291:I$30383.137950701996374J$526*J$291:J$30367.017255432357786K$526*K$291:K$30353.645495193469309L$526*L$291:L$30341.025101357565624M$526*M$291:M$30331.373139982606528N$526*N$291:N$30324.013456120461264O$526*O$291:O$30318.4023292166690772Gas boiler (new)30.73100419483269657.56507766113636495.897681549970443130.91771645303791161.99886146699015189.45995615849597204.31430702531895215.84323531659152225.03344690439235232.573722544554843Resisitive heating20.48733612988846522.25461747011353723.38893969579418924.88695407131553226.33535302772002127.72343151265245427.80421421644078427.88471354047615627.99046459639947328.1303716446689094Oil-fired boiler8.19493445195538687.61207891039389136.11214803798278714.96345974340276814.00103017506613593.20271613095339092.44925978254123061.8730232825436731.43363917137082141.09864652039815375Solid-fuel boiler8.19493445195538687.61207891039389136.11214803798278714.96345974340276814.00103017506613593.20271613095339092.44925978254123061.8730232825436731.43363917137082141.09864652039815376Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00000000009Ground-source heat pump000000000010Geothermal000000000011Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0000000000Preferences.EnergyUnitsTWhSUM(F531:F543)204.87336129888467SUM(G531:G543)222.54617470113539233.8893969579419248.86954071315537263.35353027720026277.23431512652451278.04214216440778278.8471354047615279.90464596399471281.3037164466891886845INDEX(Vectors[Description], MATCH($B548, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$531:F$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-20.487336129888465SUM(G$531:G$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-22.254617470113537SUM(H$531:H$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-23.388939695794189SUM(I$531:I$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-24.886954071315532SUM(J$531:J$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-26.335353027720021SUM(K$531:K$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-27.723431512652454SUM(L$531:L$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-27.804214216440784SUM(M$531:M$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-27.884713540476156SUM(N$531:N$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-27.990464596399473SUM(O$531:O$543/$M$129:$M$141*($B548=$F$128:$N$128)*($F$129:$N$141))-28.13037164466890946INDEX(Vectors[Description], MATCH($B549, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$531:F$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(G$531:G$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(H$531:H$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(I$531:I$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(J$531:J$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(K$531:K$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(L$531:L$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(M$531:M$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(N$531:N$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))0SUM(O$531:O$543/$M$129:$M$141*($B549=$F$128:$N$128)*($F$129:$N$141))047INDEX(Vectors[Description], MATCH($B550, Vectors[Code], 0))Solid hydrocarbonsSUM(F$531:F$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-9.4194648873050415SUM(G$531:G$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-8.7495159889584961SUM(H$531:H$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-7.0254575149227438SUM(I$531:I$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-5.7051261418422623SUM(J$531:J$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-4.5988852586967077SUM(K$531:K$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-3.6812829091418289SUM(L$531:L$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-2.8152411293577364SUM(M$531:M$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-2.1529003247628427SUM(N$531:N$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-1.6478611165181856SUM(O$531:O$543/$M$129:$M$141*($B550=$F$128:$N$128)*($F$129:$N$141))-1.26281209241167149INDEX(Vectors[Description], MATCH($B551, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$531:F$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-8.4483860329436986SUM(G$531:G$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-7.8475040313339086SUM(H$531:H$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-6.3011835443121518SUM(I$531:I$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-5.1169688076317197SUM(J$531:J$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-4.124773376356841SUM(K$531:K$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-3.3017692071684444SUM(L$531:L$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-2.5250100850940522SUM(M$531:M$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-1.9309518376738897SUM(N$531:N$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-1.4779785271864139SUM(O$531:O$543/$M$129:$M$141*($B551=$F$128:$N$128)*($F$129:$N$141))-1.132625278760983250INDEX(Vectors[Description], MATCH($B552, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$531:F$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-214.3823764777369SUM(G$531:G$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-231.02453992790993SUM(H$531:H$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-240.09059347445077SUM(I$531:I$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-253.25766287322946SUM(J$531:J$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-266.20132613990472SUM(K$531:K$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-278.78393190646909SUM(L$531:L$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-278.50161303445213SUM(M$531:M$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-278.47081582530581SUM(N$531:N$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-278.88615488281948SUM(O$531:O$543/$M$129:$M$141*($B552=$F$128:$N$128)*($F$129:$N$141))-279.78911035429513751INDEX(Vectors[Description], MATCH($B553, Vectors[Code], 0))Heat transportSUM(F$531:F$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(G$531:G$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(H$531:H$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(I$531:I$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(J$531:J$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(K$531:K$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(L$531:L$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(M$531:M$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(N$531:N$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0SUM(O$531:O$543/$M$129:$M$141*($B553=$F$128:$N$128)*($F$129:$N$141))0104INDEX(Vectors[Description], MATCH($B554, Vectors[Code], 0))Environmental heatSUM(F$531:F$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(G$531:G$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(H$531:H$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(I$531:I$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(J$531:J$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(K$531:K$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(L$531:L$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(M$531:M$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(N$531:N$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))0SUM(O$531:O$543/$M$129:$M$141*($B554=$F$128:$N$128)*($F$129:$N$141))06INDEX(Vectors[Description], MATCH($B555, Vectors[Code], 0))Heating and coolingSUM(F$531:F$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))204.87336129888465SUM(G$531:G$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))222.54617470113539SUM(H$531:H$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))233.88939695794187SUM(I$531:I$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))248.86954071315537SUM(J$531:J$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))263.35353027720026SUM(K$531:K$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))277.23431512652451SUM(L$531:L$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))278.04214216440778SUM(M$531:M$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))278.8471354047615SUM(N$531:N$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))279.90464596399471SUM(O$531:O$543/$M$129:$M$141*($B555=$F$128:$N$128)*($F$129:$N$141))281.3037164466891834INDEX(Vectors[Description], MATCH($B556, Vectors[Code], 0))Conversion lossesSUM(F$531:F$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))47.864202228989427SUM(G$531:G$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))47.33000271718052SUM(H$531:H$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))42.916777271537981SUM(I$531:I$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))40.09717118086364SUM(J$531:J$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))37.906807525478051SUM(K$531:K$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))36.25610040890728SUM(L$531:L$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))33.603936300936915SUM(M$531:M$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))31.592246123457144SUM(N$531:N$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))30.097813158928798SUM(O$531:O$543/$M$129:$M$141*($B556=$F$128:$N$128)*($F$129:$N$141))29.011202923447595Preferences.EnergyUnitsTWhSUM(F548:F556)0SUM(G548:G556)000000-4.2632564145606011E-14-3.1974423109204508E-148.1712414612411521E-145162020072010201520202025203020352040204520501824Preferences.EnergyUnitsTWhINDEX(F$53:F$56, MATCH($E$8, $C$53:$C$56, 0))01.083.376.410.2515.0521.1328.738.02000000000000349.731INDEX($D$95:$D$97, MATCH($C563, $C$95:$C$97, 0))Electric air conditioner (old)F$562*F307:F3090G$562*G307:G3090H$562*H307:H3090I$562*I307:I3090J$562*J307:J3090K$562*K307:K3090L$562*L307:L3090M$562*M307:M3090N$562*N307:N3090O$562*O307:O30902INDEX($D$95:$D$97, MATCH($C564, $C$95:$C$97, 0))Electric air conditioner (new)01.083.376.410.2515.0521.1328.738.02000000000000349.733INDEX($D$95:$D$97, MATCH($C565, $C$95:$C$97, 0))Absorption chiller0000000000SUM(F563:F565)01.083.376.410.2515.0521.1328.738.02000000000000349.73182845INDEX(Vectors[Description], MATCH($B570, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$563:F$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-0.18000000000000002SUM(H$563:H$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-0.56166666666666665SUM(I$563:I$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-1.0666666666666667SUM(J$563:J$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-1.7083333333333333SUM(K$563:K$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-2.5083333333333333SUM(L$563:L$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-3.5216666666666665SUM(M$563:M$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-4.7833333333333332SUM(N$563:N$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-6.3366666666666669SUM(O$563:O$565/$M$165:$M$167*($B570=$F$164:$N$164)*($F$165:$N$167))-8.288333333333332246INDEX(Vectors[Description], MATCH($B571, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$563:F$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B571=$F$164:$N$164)*($F$165:$N$167))047INDEX(Vectors[Description], MATCH($B572, Vectors[Code], 0))Solid hydrocarbonsSUM(F$563:F$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B572=$F$164:$N$164)*($F$165:$N$167))049INDEX(Vectors[Description], MATCH($B573, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$563:F$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B573=$F$164:$N$164)*($F$165:$N$167))050INDEX(Vectors[Description], MATCH($B574, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$563:F$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B574=$F$164:$N$164)*($F$165:$N$167))0751INDEX(Vectors[Description], MATCH($B575, Vectors[Code], 0))Heat transportSUM(F$563:F$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B575=$F$164:$N$164)*($F$165:$N$167))0104INDEX(Vectors[Description], MATCH($B576, Vectors[Code], 0))Environmental heatSUM(F$563:F$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-0.90000000000000013SUM(H$563:H$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-2.8083333333333331SUM(I$563:I$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-5.333333333333333SUM(J$563:J$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-8.5416666666666661SUM(K$563:K$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-12.541666666666666SUM(L$563:L$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-17.608333333333334SUM(M$563:M$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-23.916666666666664SUM(N$563:N$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-31.683333333333334SUM(O$563:O$565/$M$165:$M$167*($B576=$F$164:$N$164)*($F$165:$N$167))-41.4416666666666636INDEX(Vectors[Description], MATCH($B577, Vectors[Code], 0))Heating and coolingSUM(F$563:F$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))1.08SUM(H$563:H$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))3.37SUM(I$563:I$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))6.4SUM(J$563:J$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))10.25SUM(K$563:K$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))15.05SUM(L$563:L$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))21.13SUM(M$563:M$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))28.7SUM(N$563:N$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))38.020000000000003SUM(O$563:O$565/$M$165:$M$167*($B577=$F$164:$N$164)*($F$165:$N$167))49.7299999999999934INDEX(Vectors[Description], MATCH($B578, Vectors[Code], 0))Conversion lossesSUM(F$563:F$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(G$563:G$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(H$563:H$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(I$563:I$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(J$563:J$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(K$563:K$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(L$563:L$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(M$563:M$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(N$563:N$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0SUM(O$563:O$565/$M$165:$M$167*($B578=$F$164:$N$164)*($F$165:$N$167))0Preferences.EnergyUnitsTWhSUM(F570:F578)0SUM(G570:G578)04.4408920985006262E-168.8817841970012523E-1601.7763568394002505E-15-3.5527136788005009E-153.5527136788005009E-150-7.1054273576010019E-15182945INDEX(Vectors[Description], MATCH($B583, Vectors[Code], 0))Electricity (delivered to end user)F5700G570-0.18000000000000002-0.56166666666666665-1.0666666666666667-1.7083333333333333-2.5083333333333333-3.5216666666666665-4.7833333333333332-6.3366666666666669-8.288333333333332246INDEX(Vectors[Description], MATCH($B584, Vectors[Code], 0))Electricity (supplied to grid)F571000000000047INDEX(Vectors[Description], MATCH($B585, Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH($B586, Vectors[Code], 0))Liquid hydrocarbons000000000050INDEX(Vectors[Description], MATCH($B587, Vectors[Code], 0))Gaseous hydrocarbons0000000000751INDEX(Vectors[Description], MATCH($B588, Vectors[Code], 0))Heat transport0000000000104INDEX(Vectors[Description], MATCH($B589, Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH($B590, Vectors[Code], 0))Heating and cooling-SUM(F583:F589)-F5910-SUM(G583:G589)-G5910.180000000000000020.561666666666666651.06666666666666671.70833333333333332.50833333333333333.52166666666666654.78333333333333326.33666666666666698.288333333333332234INDEX(Vectors[Description], MATCH($B591, Vectors[Code], 0))Conversion lossesF5780000000000Preferences.EnergyUnitsTWhSUM(F583:F591)0SUM(G583:G591)00000000051593200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B597, Vectors[Code], 0))Electricity (delivered to end user)F478+F548+F583-31.008546529888466-33.622127643313291-36.355817596372169-39.660996049184163-43.099557384222059-46.674313768442659-49.443771277285315-52.631980317675669-56.325202223865986-60.65817298449702846INDEX(Vectors[Description], MATCH($B598, Vectors[Code], 0))Electricity (supplied to grid)F479+F549+F584000000000047INDEX(Vectors[Description], MATCH($B599, Vectors[Code], 0))Solid hydrocarbonsF480+F550+F585-14.256803002247571-13.147942484875603-10.751675360666219-8.8474273250198685-7.2280591768290652-5.8646228143532113-4.6497195223750332-3.6942594903305643-2.9429366466104181-2.35095602804390549INDEX(Vectors[Description], MATCH($B600, Vectors[Code], 0))Liquid hydrocarbonsF481+F551+F586-12.787029496861225-11.792484496744096-9.6432552203913531-7.9353214152240046-6.48289843694978-5.2600225242137055-4.1703669942951329-3.3134079964820522-2.6395411160320243-2.108589427214636450INDEX(Vectors[Description], MATCH($B601, Vectors[Code], 0))Gaseous hydrocarbonsF482+F552+F587-324.47780687796825-347.16175927904982-367.43174557726559-392.74833037289068-418.38811582676601-444.12848664079155-459.97991917468812-477.84072597789873-498.06641907486306-520.87867982977866751INDEX(Vectors[Description], MATCH($B602, Vectors[Code], 0))Heat transportF483+F553+F5880000000000104INDEX(Vectors[Description], MATCH($B603, Vectors[Code], 0))Environmental heatF484+F554+F58900000000006INDEX(Vectors[Description], MATCH($B604, Vectors[Code], 0))Heating and coolingF485+F555+F590310.08546529888463334.60127643313291358.50317596372167387.00996049184164415.62057384222061444.1681376844266462.74271277285305483.26980317675668506.22202223865986531.9867298449703434INDEX(Vectors[Description], MATCH($B605, Vectors[Code], 0))Conversion lossesF486+F556+F59172.44472060808082971.12303747084990865.6793177909736762.18211467047709859.57805698254630857.75930806337451955.50106419579049154.21057060563032353.75207682271160154.009668424563898Preferences.EnergyUnitsTWhSUM(F597:F605)000000-5.6843418860808015E-1400061163200720102015202020252030203520402045205010431063-SUM(F$597:F$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))67.291769164453711-SUM(G$597:G$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))70.875451116872867-SUM(H$597:H$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))73.329771002399895-SUM(I$597:I$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))76.974530758523997-SUM(J$597:J$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))80.830380147825736-SUM(K$597:K$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))84.840950999779849-SUM(L$597:L$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))87.111010489607892-SUM(M$597:M$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))89.888877502075673-SUM(N$597:N$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))93.210530875938801-SUM(O$597:O$605*SUMIFS(EF[CO2], EF[Vector], $B$597:$B$605))97.0929189021204451044-SUM(F$597:F$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.13655504882378258-SUM(G$597:G$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.14360862592181409-SUM(H$597:H$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.14824764064178664-SUM(I$597:I$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.1553304969790486-SUM(J$597:J$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.1628698426529244-SUM(K$597:K$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.17074929826753166-SUM(L$597:L$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.17515731890877551-SUM(M$597:M$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.18061361669164483-SUM(N$597:N$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.18718383361543475-SUM(O$597:O$605*SUMIFS(EF[CH4], EF[Vector], $B$597:$B$605))0.194896696207409041045-SUM(F$597:F$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.22513176941521534-SUM(G$597:G$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.22663134260036633-SUM(H$597:H$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21846694776423858-SUM(I$597:I$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21563187437128623-SUM(J$597:J$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21485157475052802-SUM(K$597:K$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21584197176578934-SUM(L$597:L$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21391401747885835-SUM(M$597:M$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21453770369214917-SUM(N$597:N$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.21748003875794078-SUM(O$597:O$605*SUMIFS(EF[N2O], EF[Vector], $B$597:$B$605))0.2225260254974255672905291520072010201520202025203020352040204520501INDEX($D$77:$D$89, MATCH($B617, $C$77:$C$89, 0))Gas boiler (old)2Gas boiler (new)3Resisitive heating4Oil-fired boiler5Solid-fuel boiler6Stirling engine μCHPF466+F5360G466+G5360000000007Fuel-cell μCHPF467+F5370G467+G5370000000008Air-source heat pump9Ground-source heat pump10Geothermal11Community scale gas CHPF471+F5410G471+G54100000000012Community scale solid-fuel CHPF472+F5420G472+G54200000000013District heating from power stationsPreferences.EnergyUnitsTWhSUM(F617:F629)0SUM(G617:G629)0000000001828200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B635, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$617:F$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B635=$F$128:$N$128)*($F$129:$N$141))046INDEX(Vectors[Description], MATCH($B636, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$617:F$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B636=$F$128:$N$128)*($F$129:$N$141))047INDEX(Vectors[Description], MATCH($B637, Vectors[Code], 0))Solid hydrocarbonsSUM(F$617:F$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B637=$F$128:$N$128)*($F$129:$N$141))049INDEX(Vectors[Description], MATCH($B638, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$617:F$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B638=$F$128:$N$128)*($F$129:$N$141))050INDEX(Vectors[Description], MATCH($B639, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$617:F$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B639=$F$128:$N$128)*($F$129:$N$141))0751INDEX(Vectors[Description], MATCH($B640, Vectors[Code], 0))Heat transportSUM(F$617:F$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B640=$F$128:$N$128)*($F$129:$N$141))0104INDEX(Vectors[Description], MATCH($B641, Vectors[Code], 0))Environmental heatSUM(F$617:F$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B641=$F$128:$N$128)*($F$129:$N$141))06INDEX(Vectors[Description], MATCH($B642, Vectors[Code], 0))Heating and coolingSUM(F$617:F$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B642=$F$128:$N$128)*($F$129:$N$141))034INDEX(Vectors[Description], MATCH($B643, Vectors[Code], 0))Conversion lossesSUM(F$617:F$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(G$617:G$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(H$617:H$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(I$617:I$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(J$617:J$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(K$617:K$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(L$617:L$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(M$617:M$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(N$617:N$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0SUM(O$617:O$629/$M$129:$M$141*($B643=$F$128:$N$128)*($F$129:$N$141))0Preferences.EnergyUnitsTWhSUM(F635:F643)00000000002906200720102015202020252030203520402045205010431063-SUM(F$635:F$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(G$635:G$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(H$635:H$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(I$635:I$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(J$635:J$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(K$635:K$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(L$635:L$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(M$635:M$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(N$635:N$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))0-SUM(O$635:O$643*SUMIFS(EF[CO2], EF[Vector], $B$635:$B$643))01044-SUM(F$635:F$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(G$635:G$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(H$635:H$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(I$635:I$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(J$635:J$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(K$635:K$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(L$635:L$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(M$635:M$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(N$635:N$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))0-SUM(O$635:O$643*SUMIFS(EF[CH4], EF[Vector], $B$635:$B$643))01045-SUM(F$635:F$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(G$635:G$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(H$635:H$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(I$635:I$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(J$635:J$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(K$635:K$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(L$635:L$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(M$635:M$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(N$635:N$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))0-SUM(O$635:O$643*SUMIFS(EF[N2O], EF[Vector], $B$635:$B$643))06832908Preferences.EnergyUnitsTWh291778418442691692720721722723724725726727291845INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)F688-F672-F673-31.008546529888466G688-G672-33.622127643313291-36.355817596372169-39.660996049184163-43.099557384222059-46.674313768442659-49.443771277285315-52.631980317675669-56.325202223865986-60.658172984497028291946INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)0G689-G673000000000292047INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbons-14.256803002247571G690-G674-13.147942484875603-10.751675360666219-8.8474273250198685-7.2280591768290652-5.8646228143532113-4.6497195223750332-3.6942594903305643-2.9429366466104181-2.35095602804390549INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbons-12.787029496861225G691-G675-11.792484496744096-9.6432552203913531-7.9353214152240046-6.48289843694978-5.2600225242137055-4.1703669942951329-3.3134079964820522-2.6395411160320243-2.108589427214636450INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbons-324.47780687796825G692-G676-347.16175927904982-367.43174557726559-392.74833037289068-418.38811582676601-444.12848664079155-459.97991917468812-477.84072597789873-498.06641907486306-520.87867982977866751INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Heat transport0G693-G6770000000001319INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Domestic solar thermal0G694-G678000000000104INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Environmental heat0G695-G6790000000006INDEX(Vectors[Description], MATCH(IX.a.NoCHP.Outputs[Vector], Vectors[Code], 0))Heating and cooling382.53018590696547G696-G680-G681405.72431390398282424.18249375469532449.19207516231876475.19863082476689501.92744574780113518.24377696864349537.48037378238701559.97409906137148585.99639826953421148SUBTOTAL(109,IX.a.NoCHP.Outputs[2007])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2010])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2015])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2020])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2025])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2030])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2035])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2040])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2045])0SUBTOTAL(109,IX.a.NoCHP.Outputs[2050])02907Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))046INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))047INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))049INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))050INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0751INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Heat transportINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))01319INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Domestic solar thermal104INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Environmental heatINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))06INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Heating and coolingINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))034INDEX(Vectors[Description], MATCH(IX.a.CHP.Outputs[Vector], Vectors[Code], 0))Conversion lossesINDEX(F$635:F$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(G$635:G$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(H$635:H$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(I$635:I$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(J$635:J$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(K$635:K$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(L$635:L$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(M$635:M$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(N$635:N$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0INDEX(O$635:O$643, MATCH(IX.a.CHP.Outputs[Vector], $B$635:$B$643, 0))0148SUBTOTAL(109,IX.a.CHP.Outputs[2007])0SUBTOTAL(109,IX.a.CHP.Outputs[2010])0SUBTOTAL(109,IX.a.CHP.Outputs[2015])0SUBTOTAL(109,IX.a.CHP.Outputs[2020])0SUBTOTAL(109,IX.a.CHP.Outputs[2025])0SUBTOTAL(109,IX.a.CHP.Outputs[2030])0SUBTOTAL(109,IX.a.CHP.Outputs[2035])0SUBTOTAL(109,IX.a.CHP.Outputs[2040])0SUBTOTAL(109,IX.a.CHP.Outputs[2045])0SUBTOTAL(109,IX.a.CHP.Outputs[2050])02904Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-31.008546529888466INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-33.622127643313291INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-36.355817596372169INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-39.660996049184163INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-43.099557384222059INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-46.674313768442659INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-49.443771277285315INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-52.631980317675669INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-56.325202223865986INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-60.65817298449702846INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))047INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-14.256803002247571INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-13.147942484875603INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-10.751675360666219INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-8.8474273250198685INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-7.2280591768290652INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-5.8646228143532113INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-4.6497195223750332INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-3.6942594903305643INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-2.9429366466104181INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-2.35095602804390549INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-12.787029496861225INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-11.792484496744096INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-9.6432552203913531INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-7.9353214152240046INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-6.48289843694978INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-5.2600225242137055INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-4.1703669942951329INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-3.3134079964820522INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-2.6395411160320243INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-2.108589427214636450INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-324.47780687796825INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-347.16175927904982INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-367.43174557726559INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-392.74833037289068INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-418.38811582676601INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-444.12848664079155INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-459.97991917468812INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-477.84072597789873INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-498.06641907486306INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))-520.87867982977866751INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Heat transportINDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))01319INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Domestic solar thermal-F$4540-G$454000000000104INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Environmental heatINDEX(F$597:F$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(G$597:G$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(H$597:H$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(I$597:I$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(J$597:J$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(K$597:K$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(L$597:L$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(M$597:M$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(N$597:N$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))0INDEX(O$597:O$605, MATCH(IX.a.Outputs[Vector], $B$597:$B$605, 0))06INDEX(Vectors[Description], MATCH(IX.a.Outputs[Vector], Vectors[Code], 0))Heating and coolingF$604+F$605+F$454382.53018590696547405.72431390398282424.18249375469532449.19207516231876475.19863082476689501.92744574780113518.24377696864349537.48037378238701559.97409906137148585.99639826953421148SUBTOTAL(109,IX.a.Outputs[2007])0SUBTOTAL(109,IX.a.Outputs[2010])0SUBTOTAL(109,IX.a.Outputs[2015])0SUBTOTAL(109,IX.a.Outputs[2020])0SUBTOTAL(109,IX.a.Outputs[2025])0SUBTOTAL(109,IX.a.Outputs[2030])0SUBTOTAL(109,IX.a.Outputs[2035])0SUBTOTAL(109,IX.a.Outputs[2040])0SUBTOTAL(109,IX.a.Outputs[2045])0SUBTOTAL(109,IX.a.Outputs[2050])0890290910641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.a.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF724-F71567.291769164453711G724-G71570.87545111687286773.32977100239989576.97453075852399780.83038014782573684.84095099977984987.11101048960789289.88887750207567393.21053087593880197.09291890212044510441053INDEX(IPCC[Sector_description], MATCH(IX.a.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF725-F7160.136555048823782580.143608625921814090.148247640641786640.15533049697904860.16286984265292440.170749298267531660.175157318908775510.180613616691644830.187183833615434750.1948966962074090410451053INDEX(IPCC[Sector_description], MATCH(IX.a.NoCHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF726-F7170.225131769415215340.226631342600366330.218466947764238580.215631874371286230.214851574750528020.215841971765789340.213914017478858350.214537703692149170.217480038757940780.22252602549742556148SUBTOTAL(109,IX.a.NoCHP.Emissions[2007])67.653455982692705SUBTOTAL(109,IX.a.NoCHP.Emissions[2010])71.245691085395052SUBTOTAL(109,IX.a.NoCHP.Emissions[2015])73.696485590805921SUBTOTAL(109,IX.a.NoCHP.Emissions[2020])77.345493129874328SUBTOTAL(109,IX.a.NoCHP.Emissions[2025])81.208101565229185SUBTOTAL(109,IX.a.NoCHP.Emissions[2030])85.227542269813171SUBTOTAL(109,IX.a.NoCHP.Emissions[2035])87.500081825995522SUBTOTAL(109,IX.a.NoCHP.Emissions[2040])90.284028822459462SUBTOTAL(109,IX.a.NoCHP.Emissions[2045])93.615194748312177SUBTOTAL(109,IX.a.NoCHP.Emissions[2050])97.510341623825283291010641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.a.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF6470G64700000000010441053INDEX(IPCC[Sector_description], MATCH(IX.a.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF648000000000010451053INDEX(IPCC[Sector_description], MATCH(IX.a.CHP.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF6490000000000148SUBTOTAL(109,IX.a.CHP.Emissions[2007])0SUBTOTAL(109,IX.a.CHP.Emissions[2010])0SUBTOTAL(109,IX.a.CHP.Emissions[2015])0SUBTOTAL(109,IX.a.CHP.Emissions[2020])0SUBTOTAL(109,IX.a.CHP.Emissions[2025])0SUBTOTAL(109,IX.a.CHP.Emissions[2030])0SUBTOTAL(109,IX.a.CHP.Emissions[2035])0SUBTOTAL(109,IX.a.CHP.Emissions[2040])0SUBTOTAL(109,IX.a.CHP.Emissions[2045])0SUBTOTAL(109,IX.a.CHP.Emissions[2050])0291110641060103044269169272072172272372472572672710431053INDEX(IPCC[Sector_description], MATCH(IX.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$60967.291769164453711G$60970.87545111687286773.32977100239989576.97453075852399780.83038014782573684.84095099977984987.11101048960789289.88887750207567393.21053087593880197.09291890212044510441053INDEX(IPCC[Sector_description], MATCH(IX.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$6100.13655504882378258G$6100.143608625921814090.148247640641786640.15533049697904860.16286984265292440.170749298267531660.175157318908775510.180613616691644830.187183833615434750.1948966962074090410451053INDEX(IPCC[Sector_description], MATCH(IX.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$6110.22513176941521534G$6110.226631342600366330.218466947764238580.215631874371286230.214851574750528020.215841971765789340.213914017478858350.214537703692149170.217480038757940780.22252602549742556148SUBTOTAL(109,IX.a.Emissions[2007])67.653455982692705SUBTOTAL(109,IX.a.Emissions[2010])71.245691085395052SUBTOTAL(109,IX.a.Emissions[2015])73.696485590805921SUBTOTAL(109,IX.a.Emissions[2020])77.345493129874328SUBTOTAL(109,IX.a.Emissions[2025])81.208101565229185SUBTOTAL(109,IX.a.Emissions[2030])85.227542269813171SUBTOTAL(109,IX.a.Emissions[2035])87.500081825995522SUBTOTAL(109,IX.a.Emissions[2040])90.284028822459462SUBTOTAL(109,IX.a.Emissions[2045])93.615194748312177SUBTOTAL(109,IX.a.Emissions[2050])97.510341623825283270227087827034426916927207217227237247257267272711INDEX(Vectors[Description], MATCH(IX.a.info[Vector], Vectors[Code], 0))Number of unitsF32926042600G3292691740028469000.0000000043000480031434799.9999999963274480034415113.88851447436170630.57216480438015696.2497995239954878.820088163