676INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Heating824INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Domestic space heating and hot water3321133782513361803IX.a.Scenario.ServiceDemand21262IX.a.Scenario.Insulation21831IX.a.Scenario.Electrification31828IX.a.Scenario.Fuel322361829123418311414371798182212255961572179911514123180010813164180132412237INDEX($E$18:$H$21, MATCH($E$10, $C$18:$C$21, 0), MATCH($E$11, $E$16:$H$16, 0))136821313INDEX(Modules[Module], MATCH(C28, Modules[Code], 0))Solar thermalPreferences.EnergyUnitsTWh7841844220072010201520202025203020352040204520501315INDEX(Vectors[Description], MATCH($C31, Vectors[Code], 0))Domestic solar thermalINDEX(INDIRECT("'"&F$30&"'!Year.Matrix"), MATCH($C$28, INDIRECT("'"&F30&"'!Year.Modules"), 0), MATCH($C$31, INDIRECT("'"&F30&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&G$30&"'!Year.Matrix"), MATCH($C$28, INDIRECT("'"&G30&"'!Year.Modules"), 0), MATCH($C$31, INDIRECT("'"&G30&"'!Year.Vectors"), 0))0.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.26344572552911133812638321336804422007201020152020202520302035204020452050117.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.9999999999999641802Preferences.EnergyUnits & " (thermal energy removed)"TWh (thermal energy removed)13368044220072010201520202025203020352040204520501(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)*0000000000126483813368044220072010201520202025203020352040204520501246.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.51274763672191265Preferences.EnergyUnitsTWh13361266442200720102015202020252030203520402045205019.4999999999999998E-3(Unit.TWh)*0.000004044.0400000000000003E-6F64*(1+$D64)^(G$63-F$63)4.1562372937950012E-64.3574453735330769E-64.5683941606682795E-64.789555213702236E-65.0214229198092126E-65.2645155999976037E-65.5193766677735158E-65.7865758438965483E-66.0667104299432579E-620(Unit.TWh)*0.000004044.0400000000000003E-64.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-63.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-63.8491661721600003E-63.5509303392001461E-63.2758020074712263E-63.0219907931423028E-62.7878450324556318E-62.5718410336075312E-62.3725731614003263E-62.1887446901417442E-62.019159365267454E-63051839838269131125413108167156141211270212710.91E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-31E-338400.10.10.17.0000000000000007E-2484258410.10.10.10.10.050.150.05612730.10.190.190.24716010.90.20.16812740.60.550000000000000040.50.60.579999999999999960.180.250.14000000000000001912750.30.300.30.20.30.30.30.30.250.20.251030.010.010.010.010.011117960.150.330.130.30.240.150.231217970.20.70.450.20.330.350.630.250.231312760.030.117.0000000000000007E-27.0000000000000007E-27.0000000000000007E-27.0000000000000007E-20.117.0000000000000007E-20.117.0000000000000007E-21481SUM(F72:F84)1.00099999999999991.00099999999999991.00100000000000011.00099999999999991.00099999999999991.00100000000000011.00100000000000011.00100000000000011.00100000000000011.0010000000000001SUM(P72:P84)1.0010000000000001SUM(Q72:Q84)1.0010000000000001SUM(R72:R84)1.0010000000000001SUM(S72:S84)1.0010000000000001SUM(T72:T84)1.00100000000000011805839838269131125413108167156141212246222471111110.970.880.930.930.930.920.880.920.890.92318060.030.127.0000000000000007E-27.0000000000000007E-27.0000000000000007E-20.080.120.080.110.08148SUM(E$90:E$92)1111111111111111717109224818237848888327944220072010201520202025203020352040204520508471095.63.93641649048625824.19223044397462984.44804439746300064.70385835095137144.95967230443974225.21548625792811295.47130021141648375.72711416490485455.98292811839322528489.18.18111111111110928.31629629629629198.45148148148147458.58666666666665718.72185185185183988.85703703703702248.9922222222222059.12740740740738779.262592592592570384914.114.25348837209302214.50930232558139314.76511627906976415.02093023255813415.27674418604650515.53255813953487615.78837209302324716.04418604651161916.299999999999998509.99.998837209302324810.16356589147286510.32829457364340610.49302325581394710.65775193798448810.82248062015502810.98720930232556911.1519379844961111.316666666666653718((F105*$F$633)+(F106*$F$638)+(F107*$F$643)+(F108*$F$648))/($F$633+$F$638+$F$643+$F$648)9.69390828199863119.9988372093023248((H105*$F$633)+(H106*$F$638)+(H107*$F$643)+(H108*$F$648))/($F$633+$F$638+$F$643+$F$648)9.31742194909100099.52015826705899939.72289458502699779.925630902994997810.12836722096299610.33110353893099510.53383985689899310.73657617486699513038479442200715440353.8*(836.3/1245.1)*10^15/257510009228297640.43151281304110*(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(F114:F118)32476408683.15793636821272INDEX(Vectors[Description], MATCH(F$124, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$124, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$124, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$124, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$124, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$124, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$124, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$124, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$124, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$72:$D$84, MATCH($C125, $C$72:$C$84, 0))Gas boiler (old)-10.760.24SUM(F125:N125)02INDEX($D$72:$D$84, MATCH($C126, $C$72:$C$84, 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-2309Ground-source heat pump-1-34010Geothermal-10.850.15011Community scale gas CHP0.38-10.380.24012Community scale solid-fuel CHP0.17-10.569999999999999950.26013District heating from power stations462-10.90.1036831272INDEX(Vectors[Description], MATCH(F$142, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$142, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$142, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$142, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$142, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$142, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$142, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$142, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$142, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$72:$D$84, MATCH($C143, $C$72:$C$84, 0))Gas boiler (old)-10.760.24SUM(F143:N143)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-1209Ground-source heat pump-1-23010Geothermal-10.850.15011Community scale gas CHP0.38-10.380.24012Community scale solid-fuel CHP0.17-10.569999999999999950.26013District heating from power stations462-10.90.1036851272INDEX(Vectors[Description], MATCH(F$124, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$124, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$124, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$124, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$124, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$124, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$124, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$124, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$124, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$72:$D$84, MATCH($C161, $C$72:$C$84, 0))Gas boiler (old)F1250G125000-1000.760.2402INDEX($D$72:$D$84, MATCH($C162, $C$72:$C$84, 0))Gas boiler (new)F1260000-1000.910.0903Resisitive heatingF127-10000001004Oil-fired boilerF128000-10000.970.03-2.7755575615628914E-175Solid-fuel boiler117F12900-100000.870.1306Stirling engine μCHPF13000.2250000000000000100-1000.630.1449999999999999907Fuel-cell μCHPF13100.4500-1000.450.108Air-source heat pumpF132-100000-M168-F168-1.7000000000000002M132*90%2.7009Ground-source heat pumpF133-100000-M169-F169-2.96M133*99%3.960010GeothermalF134000000-10.850.15011Community scale gas CHPF13500.3800-1000.380.24012Community scale solid-fuel CHPF13600.17-100000.569999999999999950.26013District heating from power stations462F13700000-100.90.1036841272INDEX(Vectors[Description], MATCH(F$142, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$142, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$142, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$142, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$142, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$142, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$142, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$142, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$142, Vectors[Code], 0))Conversion losses8448382644245464749507511046341INDEX($D$72:$D$84, MATCH($C179, $C$72:$C$84, 0))Gas boiler (old)F1430G143000-1000.760.2402Gas boiler (new)F1440000-1000.910.0903Resisitive heatingF145-10000001004Oil-fired boilerF146000-10000.970.03-2.7755575615628914E-175Solid-fuel boiler117F14700-100000.870.1306Stirling engine μCHP118F14800.2250000000000000100-1000.630.1449999999999999907Fuel-cell μCHP118F14900.4500-1000.450.108Air-source heat pumpF150-100000-M186-F186-0.8M150*90%1.8N150009Ground-source heat pumpF151-100000-M187-F187-1.9699999999999998M151*99%2.9699999999999998N1510010GeothermalF152000000-10.850.15011Community scale gas CHPF15300.3800-1000.380.24012Community scale solid-fuel CHPF15400.17-100000.569999999999999950.26013District heating from power stations462F15500000-100.90.1018071272INDEX(Vectors[Description], MATCH(F$142, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(G$142, Vectors[Code], 0))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(H$142, Vectors[Code], 0))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(I$142, Vectors[Code], 0))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(J$142, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(K$142, Vectors[Code], 0))Heat transportINDEX(Vectors[Description], MATCH(L$142, Vectors[Code], 0))Environmental heatINDEX(Vectors[Description], MATCH(M$142, Vectors[Code], 0))Heating and coolingINDEX(Vectors[Description], MATCH(N$142, Vectors[Code], 0))Conversion losses84483826442454647495075110463412246-1-1.52.5SUM(F197:N197)022247-1-56SUM(F198:N198)031806-10.30.7SUM(F199:N199)015878312374422007123612381INDEX($D$72:$D$84, MATCH($C205, $C$72:$C$84, 0))Gas boiler (old)15880.670.920072Gas boiler (new)0.150.920073Resisitive heating15860.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(F205:F217)18312374422007123612381INDEX($D$90:$D$92, MATCH($C221, $C$90:$C$92, 0))Electric air conditioner (old)0120072INDEX($D$90:$D$92, MATCH($C222, $C$90:$C$92, 0))Electric air conditioner (new)0120073INDEX($D$90:$D$92, MATCH($C223, $C$90:$C$92, 0))Absorption chiller012015148SUM(F$221:F$223)01826128379442200720102015202020252030203520402045205018241300000$F229*(INDEX(Global.Assumptions[Households], MATCH(G$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1343668.450922719$F229*(INDEX(Global.Assumptions[Households], MATCH(H$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1421121.5470037553$F229*(INDEX(Global.Assumptions[Households], MATCH(I$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1497785.9353520768$F229*(INDEX(Global.Assumptions[Households], MATCH(J$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1569168.976983865$F229*(INDEX(Global.Assumptions[Households], MATCH(K$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1634561.8333038944$F229*(INDEX(Global.Assumptions[Households], MATCH(L$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1717940.9143122735$F229*(INDEX(Global.Assumptions[Households], MATCH(M$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1805573.1664201827$F229*(INDEX(Global.Assumptions[Households], MATCH(N$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1897675.5440984915$F229*(INDEX(Global.Assumptions[Households], MATCH(O$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1994476.068676500118251300000$F230*(INDEX(Global.Assumptions[Households], MATCH(G$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1343668.450922719$F230*(INDEX(Global.Assumptions[Households], MATCH(H$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1421121.5470037553$F230*(INDEX(Global.Assumptions[Households], MATCH(I$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1497785.9353520768$F230*(INDEX(Global.Assumptions[Households], MATCH(J$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1569168.976983865$F230*(INDEX(Global.Assumptions[Households], MATCH(K$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1634561.8333038944$F230*(INDEX(Global.Assumptions[Households], MATCH(L$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1717940.9143122735$F230*(INDEX(Global.Assumptions[Households], MATCH(M$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1805573.1664201827$F230*(INDEX(Global.Assumptions[Households], MATCH(N$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1897675.5440984915$F230*(INDEX(Global.Assumptions[Households], MATCH(O$228, Global.Assumptions[Year], 0))/INDEX(Global.Assumptions[Households], MATCH($F$228, Global.Assumptions[Year], 0)))1994476.068676500126593322332326498003957.240014170326509150000265111900000265223660000265322333300265425132777.30930175333192655332020072010201520202025203020352040204520502649102160.2228767.00000000003326267.00000000006423767.00000000012521267.00000000012618767.00000000012716267.00000000023813767.00000000023911267.0000000002326501970805328467532846753284675328467532846753284675328467532846752651249069.76744186046664186.046511627851079302.32558139531494418.60465116291909534.88372093022324651.16279069752739767.44186046533154883.720930232735700002652165069.76744186046440186.04651162791715302.3255813953990418.604651162751265534.88372093021540651.16279069781815767.44186046512090883.7209302327236600026533197748543458056095805784580595958061345806309580648458066595802654175344.95797187273467586.55459166056759828.151211448481052069.74783123631344311.34445102421636552.94107081211928794.53769059992221036.13431038752513277.7309301756265633202010201520202025203020352040204520502649400197.862000708531067194.29866855611734190.73533640362059489.31000354262156989.31000354282254489.31000354282351989.31000354332449489.31000354332546989.310003543326501976400367830043188004575000457500045750004575000457500045750002651373604.65116279072996279.069767441831618953.48837209312241627.90697674412864302.32558139553486976.74418604654109651.16279069754732325.581395348553550002652577744.186046511521540651.16279069752503558.13953488323466465.11627906894429372.09302325555392279.06976744166355186.04651162687318093.02325581298280999.999999999126533215995.25536307.52631578975830166.73684210526124025.94736842076417885.15789473626711744.36842105177005603.57894736717299462.78947368367593321.999999999126541449967.92169048593866581.12450796186283194.32732543816440274.18550857446597354.04369170966754433.90187484586911513.76005798217068593.61824111737225673.4764242535265733202010201520202025203020352040204520502649509342.733455447191358247.28921452582207151.84497360473056056.40073268353904960.95649176184753865.51225084075602770.06800991955700270.06800991955797770.068009919526502287500610000068625006862500686250068625006862500686250068625002651498139.534883720921328372.09302325572158604.65116279062988837.20930232573819069.76744186044649302.32558139515479534.88372093076309767.441860465371400002652990418.604651162752641116.27906976734291813.95348837235942511.62790697727593209.30232558129243906.976744186110894604.6511627912545302.3255813961419600026533215995.26382622.05263157568087005.47368420299791388.894736830111495772.31578945713200155.73684208514904539.15789470816608922.57894733518313305.99999996326542899935.84338097187733162.249015923612566388.65465087612723468.51283401312880548.37101714713037628.22920028313194708.08738341913351787.94556655413508867.80374969265833202010201520202025203020352040204520502649696295.448954722611856787.86387926043017280.27880379844177772.69372833575338265.10865287396498757.52357741177659249.93850194947671524.44445777687683798.950413604326502387982.53172243296367953.41792648758755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.94964892048755935.94964892042651794476.841790485312118604.91144129453442732.98109210284766861.05074291216090989.12039372147415117.19004453078739245.259695338110063373.32934614811387501.39899695726521579606.89720696494212285.05921857346844963.22123018099477641.383241789412110319.54525339814742997.70726500617375675.86927661320008354.03128822122641032.1932998326533215995.27082846.57142857099954270.857142858212825695.14285714215697119.42857142918568543.71428571621439968214399682143996826545550087.978739871614800234.60997299124050381.2412061124063228.73716003824076076.23311396724088923.72906789624101771.22502182424114618.72097575324127466.216929682442109852831134211712771181278440130245412914621301464158915881279158615903170Preferences.moneyunits£m332418011799180117992649K293*GBP8.199999999999999E-31.3089999999999998E-38200130926501.74E-32.9999999999999997E-4174030026511E-34.9999999999999996E-510005026524.0000000000000001E-304000026532.9729975102145043E-49.9999999999999991E-5297.2997510214504510026542E-33.9999999999999996E-52000403864180117994386550000*GBP4.9999999999999996E-215000*GBP1.4999999999999999E-23386620000*GBP0.0210000*GBP0.012386620000*GBP0.0210000*GBP0.0113867003151386333663367Preferences.moneyunits&"/household"£m/household336633673417337017993370179933701799337017991INDEX($D$72:$D$84, MATCH($C308, $C$72:$C$84, 0))Gas boiler (old)21156.89263934193733119.047619047619059.41355836051623920.61651642316858357$E308*F308*GBP3.2947454261806836E-3$E308*G308*GBP2.5000000000000001E-3$E308*H308*GBP1.9768472557084101E-4$E308*I308*GBP1.2946844886540254E-52Gas boiler (new)21156.89263934193733119.047619047619059.41355836051623920.616516423168583573.2947454261806836E-32.5000000000000001E-3$E309*H309*GBP1.9768472557084101E-4$E309*I309*GBP1.2946844886540254E-53Resisitive heating21183.041412565593531750.30799917107035540.30799917107035543.843869663877464E-33.6749999999999999E-3$E310*H310*GBP6.4679825924774633E-6$E310*I310*GBP6.4679825924774633E-64Oil-fired boiler211871870.718707905916485260.718707905916485263.9269999999999999E-33.9269999999999999E-3$E311*H311*GBP1.5092866024246189E-5$E311*I311*GBP1.5092866024246189E-55Solid-fuel boiler21528259.040105484620770.821158429178323490.821158429178323491.1087999999999999E-25.4398422151770362E-3$E312*H312*GBP1.7244327012744794E-5$E312*I312*GBP1.7244327012744794E-56Stirling engine μCHP6.51621.2239398666857632.80031201248062174.8523469070562719.1757670306812251.0537955609133455E-24.1132020280811241E-3$E313*H313*GBP1.1365402548958656E-3$E313*I313*GBP1.2464248569942795E-47Fuel-cell μCHP6.535002564.5010879701586174.85234690705627174.852346907056272.2749999999999999E-21.666925707180603E-2$E314*H314*GBP1.1365402548958656E-3$E314*I314*GBP1.1365402548958656E-38Air-source heat pump81449255.527999999999969.10.284944565330017611.1592E-22.0442239999999994E-3$E315*H315*GBP7.2799999999999994E-5$E315*I315*GBP2.2795565226401407E-69Ground-source heat pump81828.6503096487495511.055999999999939.06490805086748890.284944565330017611.4629202477189995E-24.0884479999999989E-3$E316*H316*GBP7.2519264406939907E-5$E316*I316*GBP2.2795565226401407E-610Geothermal6.52740.64863744689682740.648637446896855.69371049632162955.6937104963216291.7814216143404827E-21.7814216143404827E-2$E317*H317*GBP3.6200911822609059E-4$E317*I317*GBP3.6200911822609059E-411Community scale gas CHP6.51295.202569681898255016.9995337270749150.556937104963216258.4188167029323364E-33.5750000000000001E-3$E318*H318*GBP1.1049696922598694E-4$E318*I318*GBP3.6200911822609051E-612Community scale solid-fuel CHP6.53885.6077090456947781.2564.7601284840949210.556937104963216252.5256450108797016E-25.0781250000000002E-3$E319*H319*GBP4.2094083514661692E-4$E319*I319*GBP3.6200911822609051E-613District heating from power stations10122464250*GBP2.5000000000000001E-4250*GBP2.5000000000000001E-4E322*F3221E-3F322*G3226.2499999999999997E-8222474250*GBP2.5000000000000001E-4250*GBP2.5000000000000001E-4E323*F3231E-3F323*G3236.2499999999999997E-831806320933218128158157944220072010201520202025203020352040204520501241INDEX(Global.Assumptions[Households], MATCH(F$334, Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$334, Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$334, Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$334, Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$334, Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$334, Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$334, Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$334, Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$334, Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$334, Global.Assumptions[Year], 0))39954878.820088171242651G335-F335874800H335-G3351551600I335-H3351535800143000013100001670313.8885144741755516.68365032971845065.6776347161939182.57028865073326332520072010201520202025203020352040204520502649IF($E$9=1,G243-F243,IF($E$9=2,G251-F251,IF($E$9=3,G259-F259,G267-F267)))/3133399.28733356952IF($E$9=1,H243-G243,IF($E$9=2,H251-G251,IF($E$9=3,H259-G259,H267-G267)))/5133399.28733356955133399.2873335694965059.71493342779319500.0000000000471950019500.00000000009519500195002650IF($E$9=1,G244-F244,IF($E$9=2,G252-F252,IF($E$9=3,G260-F260,G268-F268)))/3658800IF($E$9=1,H244-G244,IF($E$9=2,H252-G252,IF($E$9=3,H260-G260,H268-G268)))/534038012810051240000002651124534.88372093024124534.88372093023124534.88372093024124534.8837209302124534.88372093029124534.8837209302124534.8837209302124534.8837209302124534.883720930292652192581.39534883716192581.39534883719192581.39534883713192581.39534883713192581.39534883731192581.39534883722192581.39534883705192581.39534883722192581.3953488372226531071998.4000000001464062.4652631579158771.84210526310258771.84210526310258771.84210526310258771.84210526310258771.84210526310258771.84210526328458771.8421052631022654IF($E$9=1,G248-F248,IF($E$9=2,G256-F256,IF($E$9=3,G264-F264,G272-F272)))/3483322.64056349528483322.64056349517483322.6405634952831415.97163662724131415.97163662705531415.97163662724131415.97163662724131415.97163662705531415.971636627241305083123744212801INDEX($D$72:$D$84, MATCH($C352, $C$72:$C$84, 0))Gas boiler (old)INDEX($E72:$T72, MATCH($E$23, $E$71:$T$71, 0))02Gas boiler (new)1E-33Resisitive heating04Oil-fired boiler05Solid-fuel boiler06Stirling engine μCHP07Fuel-cell μCHP08Air-source heat pump0.579999999999999969Ground-source heat pump0.310Geothermal0.0111Community scale gas CHP012Community scale solid-fuel CHP013District heating from power stations0.1183123744212801INDEX($D$90:$D$92, MATCH($C367, $C$90:$C$92, 0))Electric air conditioner (old)INDEX($E90:$T90, MATCH($E$23, $E$89:$T$89, 0))02INDEX($D$90:$D$92, MATCH($C368, $C$90:$C$92, 0))Electric air conditioner (new)INDEX($E91:$T91, MATCH($E$23, $E$89:$T$89, 0))0.883INDEX($D$90:$D$92, MATCH($C369, $C$90:$C$92, 0))Absorption chillerINDEX($E92:$T92, MATCH($E$23, $E$89:$T$89, 0))0.1212391240831237442200720102015202020252030203520402045205028891INDEX($D$72:$D$84, MATCH($C375, $C$72:$C$84, 0))Gas boiler (old)INDEX($F$205:$F$217, MATCH($C375,$C$205:$C$217, 0))0.670.605424669544606830.4624862467351879H375+$P3750.39641678291587534I375+$P3750.330347319096562790.264277855277250230.198208391457937670.132138927638625116.6069463819312557E-2F3520(O375-H375)/7-6.6069463819312557E-22Gas boiler (new)INDEX($F$205:$F$217, MATCH($C376,$C$205:$C$217, 0))0.150.240655115278593040.41986273683253178H376+$P3760.360025202999312950.300187669166094130.24035013533287530.180512601499656480.120675067666437656.0837533833218826E-2F3531E-3(O376-H376)/7-5.9837533833218826E-23Resisitive heating0.18.5511230653777859E-26.5322359837963029E-2H377+$P3775.5990594146825452E-24.6658828455687876E-23.7327062764550299E-22.7995297073412723E-21.8663531382275146E-29.3317656911375713E-3F3540-9.3317656911375748E-34Oil-fired boiler0.043.4204492261511142E-22.6128943935185212E-2H378+$P3782.2396237658730181E-21.866353138227515E-21.4930825105820118E-21.1198118829365087E-27.4654125529100565E-33.7327062764550261E-3F3550-3.7327062764550304E-35Solid-fuel boiler0.043.4204492261511142E-22.6128943935185212E-2H379+$P3792.2396237658730181E-21.866353138227515E-21.4930825105820118E-21.1198118829365087E-27.4654125529100565E-33.7327062764550261E-3F3560-3.7327062764550304E-36Stirling engine μCHP000H380+$P380000000007Fuel-cell μCHP000H381+$P381000000008Air-source heat pump000H382+$P3828.2857142857142851E-20.16571428571428570.248571428571428550.331428571428571410.414285714285714260.497142857142857110.579999999999999968.2857142857142851E-29Ground-source heat pump000H383+$P3834.2857142857142858E-28.5714285714285715E-20.128571428571428560.171428571428571430.21428571428571430.257142857142857170.34.2857142857142858E-210Geothermal000H384+$P3841.4285714285714286E-32.8571428571428571E-34.2857142857142859E-35.7142857142857143E-37.1428571428571426E-38.5714285714285719E-30.011.4285714285714286E-311Community scale gas CHP000H385+$P3850000000012Community scale solid-fuel CHP000H386+$P3860000000013District heating from power stations000H387+$P3871.5714285714285715E-23.1428571428571431E-24.7142857142857146E-26.2857142857142861E-27.857142857142857E-29.4285714285714278E-20.111.5714285714285715E-2148SUM(F375:F387)1SUM(G375:G387)1SUM(H375:H387)0.999929231276053041.0000821982366171.0002351651971811.00038813215774461.00054109911830841.00069406607887231.00084703303943611.001000000000000183123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C391, $C$90:$C$92, 0))Electric air conditioner (old)INDEX($F$221:$F$223, MATCH($C391,$C$221:$C$223, 0))0G469/G$4720000000002INDEX($D$90:$D$92, MATCH($C392, $C$90:$C$92, 0))Electric air conditioner (new)INDEX($F$221:$F$223, MATCH($C392,$C$221:$C$223, 0))0110.943322863790728610.918998096456415280.905859322636028310.897983982661098130.892851282675654720.88935122179038950.886890230359361543INDEX($D$90:$D$92, MATCH($C393, $C$90:$C$92, 0))Absorption chillerINDEX($F$221:$F$223, MATCH($C393,$C$221:$C$223, 0))0005.6677136209271464E-28.1001903543584608E-29.4140677363971761E-20.102016017338901820.107148717324345250.110648778209610540.11310976964063835SUM(F391:F393)01110.9999999999999998911110.99999999999999989341883123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C398, $C$72:$C$84, 0))Gas boiler (old)F$411*F37517448542G$411*G3751629645813166520.95830406411894406.28803425510384401.906336638653725.51548250216821364.36568418424779548.33581872662511676.667942105302Gas boiler (new)F$411*F3763906390647781011953072.25488534810802484.2109537839436339.34270233477870217.11144793416212361.73892270594364893.29183370622312781.206790548339954.8788200881543Resisitive heating260426023017401859662.26222696951679986.57925666821466710.9407388571222267.2048126466963461.33712429483675071.69880027859354753.5699885864204Oil-fired boiler1041704920696743864.90489078779671994.63170266722586684.37629554281488906.88192505855385384.53484971786270028.67952011141141901.4279954344705Solid-fuel boiler1041704920696743864.90489078779671994.63170266722586684.37629554281488906.88192505855385384.53484971786270028.67952011141141901.4279954344706Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0002486111.99999999955209195.42857142728139421.714285712711406152.03162193914984975.52275398918899231.84990033123173829.7156511289Ground-source heat pump0001285919.99999999982694411.42857142824210045.71428571365899733.80945962397750849.40832102959775464.749948449411986463.64602644610Geothermal00042863.99999999999389813.714285714275140334.85714285713196657.79364865413258361.64694403429325848.82499828161399548.7882008815611Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations000471504987950.857142857041543683.42857142842163235.73013519592841978.11638437723584337.07498109714395036.67020969743419F46626042600G466269174002846900030004799.99999999631434799.99999999632744799.99999999634415113.88851447436170630.57216480438015696.2497995239954878.82008815635780.33360583123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C417, $C$72:$C$84, 0))Gas boiler (old)$E$413*F3985758018.8600000003$E$413*G3985377831.14000000064344951.9162403413925154.07505130443426852.62909108822855729.42010922592251050.24067578091577250.9508201799828853.3004208947502Gas boiler (new)$E$413*F3991289108.7$E$413*G3992137677.30000000033944513.84411216483564819.78961474873113991.98309177072597171.64677781842050079.37384449291440414.786305123763217.7982408809513185.1100106290913Resisitive heating$E$413*F400859405.8759574.20000000007613688.54653489997554395.57115470059484014.61044382286403348.17758817342317942.24125101732222773.66060409194117068.6780962335204Oil-fired boiler$E$413*F401343762.32303829.68245475.41861395998221758.22846188018193605.84417752913161339.27103526934127176.896500406989109.46424163677146827.47123849337405Solid-fuel boiler$E$413*F402343762.32303829.68245475.41861395998221758.22846188018193605.84417752913161339.27103526934127176.896500406989109.46424163677146827.47123849337406Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump000820416.959999999851719034.49142857112686009.16571428533764030.170435244945041.92250881726236746.51046710937647363.80616487289Ground-source heat pump000424353.59999999992889155.771428571321389315.08571428551946912.1571216762557780.304745943225903.36748298863955533.003188727410Geothermal00014145.11999999999929638.52571428571246310.50285714285664897.07190405586985259.343491531326107530.11224943293131851.1001062909211Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations000155596.32326023.78285714285509415.53142857138713867.79094461468937852.778406844471182831.23474376211450362.10116920013419G466269174002846900030004799.99999999631434799.99999999632744799.99999999634415113.88851447436170630.57216480438015696.2497995239954878.820088156342083123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C434, $C$72:$C$84, 0))Gas boiler (old)IF(G398-F398+F417>0,G398-F398+F417,0)4605934.8600000003IF(H398-G398+G417>0,H398-G398+G417,0)2247894.09830406493072837.24597053142415149.69335367951696176.23823696051023368.2703109081209234.21081032325002Gas boiler (new)IF(G399-F399+F418>0,G399-F399+F418,0)3860528.77612939.55488534832793925.80018060052198674.92136330021547869.75183737939316.27425259026202610.92675549327003Resisitive heatingIF(G400-F400+F419>0,G400-F400+F419,0)556885.80000000005317496.46222696954434012.86356459872341119.9326368894239570.87451761245144542.3098998216429552.602927001077004Oil-fired boilerIF(G401-F401+F420>0,G401-F401+F420,0)222754.32126998.58489078778173605.14542583941136447.9730547557795828.3498070448757816.92395992865211821.041170800454005Solid-fuel boilerIF(G402-F402+F421>0,G402-F402+F421,0)222754.32126998.58489078778173605.14542583941136447.9730547557795828.3498070448757816.92395992865211821.041170800454006Stirling engine μCHPIF(G403-F403+F422>0,G403-F403+F422,0)0000000007Fuel-cell μCHPIF(G404-F404+F423>0,G404-F404+F423,0)0000000008Air-source heat pumpIF(G405-F405+F424>0,G405-F405+F424,0)002486111.99999999953543500.38857142774649260.77714285635952739.48305051127342853.66156729128859298.249655159210511344.3762179059Ground-source heat pumpIF(G406-F406+F425>0,G406-F406+F425,0)001285919.99999999981832845.02857142832404790.05714285653079003.18088819553798027.75598308164582395.64637335955436902.263560984310GeothermalIF(G407-F407+F426>0,G407-F407+F426,0)0042863.99999999999361094.83428571428580159.66857142857102633.43936293985126600.92519943602152746.52154577864181230.0754520329111Community scale gas CHPIF(G408-F408+F427>0,G408-F408+F427,0)00000000012Community scale solid-fuel CHPIF(G409-F409+F428>0,G409-F409+F428,0)00000000013District heating from power stationsIF(G410-F410+F429>0,G410-F410+F429,0)00471504672043.17714285711881756.354285714221128967.83299233881392610.1771937961680211.73700356441993530.82997236243419G483011111111128481583123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C453, $C$72:$C$84, 0))Gas boiler (old)F375*F$33517448542F453+G502+G527-G5521542165812461500.92595868210023474.8538329197999414.39496801336336196.18916738135077947.98485481374069563.97293617673261425.87108315812613768.64531657612Gas boiler (new)3906390735261012659633.15363450910189942.0790458518139748.00645103586455189.99450613935181476.52531538624161114.83527992393343815.31819977662689276.01208158493Resisitive heating260426023017401859925.51133711661496041.02296013711193942.4470101511945700.9237563255757902.68430668861607397.60790092195486779.98075868038390114.723181578624Oil-fired boiler1041704920696743970.20453484671598416.40918405494477576.97880406055378280.36950253032303161.07372267556242959.04316036886194711.99230347219156045.889272631475Solid-fuel boiler1041704920696743970.20453484671598416.40918405494477576.97880406055378280.36950253032303161.07372267556242959.04316036886194711.99230347219156045.889272631476Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0004117135.35095992967624993.892498350710585668.24906775413219049.43702349615571048.92044168517709865.63518755919690784.0433586359Ground-source heat pump0002129552.76773789483943962.35818880245475345.64606952676837439.36397766888053990.82091811119160275.328545285410184888.29828894910Geothermal00070985.092257929835131465.41193962676182511.52153565091227914.64546592237268466.36069727043305342.51095150958339496.276609631611Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations000780836.014837228231446119.53133589452007626.73689216052507061.10012514612953129.9676699753358767.62046660583734459.0427059489148SUM(F453:F465)26042600SUM(G453:G465)26917400SUM(H453:H465)2846900030004799.99999999631434799.99999999632744799.99999999634415113.88851447436170630.57216480438015696.2497995239954878.82008815683123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C469, $C$90:$C$92, 0))Electric air conditioner (old)F391*F$3350F469+G518+G543-G5680G469+H518+H543-H568000000002INDEX($D$90:$D$92, MATCH($C470, $C$90:$C$92, 0))Electric air conditioner (new)F392*F$335039000009869744.886628832714191716.84219637317916213.00167968921095462.36575050324098376.32411092526871836.56845996929480122.20066318331975702.3136374883INDEX($D$90:$D$92, MATCH($C471, $C$90:$C$92, 0))Absorption chillerF393*F$335000852672.928202253181579162.52821879692192328.39668623922737710.72133665953224817.92469561293667774.24154953334078029.2746348958148SUM(F469:F471)039000009869744.886628832715044389.77039862619495375.52989848723287790.7624367426836087.04544758430096654.49315558433147896.44221271636053731.588272385128283123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C478, $C$72:$C$84, 0))Gas boiler (old)(F$477>=$H205)*111111111112Gas boiler (new)(F$477>=$H206)*111111111112883Resisitive heating(F$477>=$H207)*111111111114Oil-fired boiler(F$477>=$H208)*111111111115Solid-fuel boiler(F$477>=$H209)*111111111116Stirling engine μCHP(F$477>=$H210)*100111111117Fuel-cell μCHP(F$477>=$H211)*100111111118Air-source heat pump(F$477>=$H212)*100111111119Ground-source heat pump(F$477>=$H213)*1001111111110Geothermal(F$477>=$H214)*1001111111111Community scale gas CHP(F$477>=$H215)*1001111111112Community scale solid-fuel CHP(F$477>=$H216)*1001111111113District heating from power stations(F$477>=$H217)*1001111111183123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C493, $C$90:$C$92, 0))Electric air conditioner (old)(F$492>=$H221)*111111111112INDEX($D$90:$D$92, MATCH($C494, $C$90:$C$92, 0))Electric air conditioner (new)(F$492>=$H222)*111111111113INDEX($D$90:$D$92, MATCH($C495, $C$90:$C$92, 0))Absorption chiller(F$492>=$H223)*100111111111285128783123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C502, $C$72:$C$84, 0))Gas boiler (old)(F478*$F352*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000002Gas boiler (new)(F479*$F353*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)87480015516001534.2657342657341428.57142857142841308.69130869130841668.64524327120261753.76292072961843.22245517953641937.24532496368693Resisitive heating(F480*$F354*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000004Oil-fired boiler(F481*$F355*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000005Solid-fuel boiler(F482*$F356*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000006Stirling engine μCHP(F483*$F357*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000007Fuel-cell μCHP(F484*$F358*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0000000008Air-source heat pump(F485*$F359*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)00889874.12587412563828571.42857142852759040.9590409589967814.24109729741017182.49402316791069069.02400413091123602.28847893849Ground-source heat pump(F486*$F360*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)00460279.7202797202428571.42857142852392607.39260739257500593.57298136078526128.87621887994552966.73655386083581173.59748910610Geothermal(F487*$F361*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)0015342.65734265734114285.71428571428413086.91308691308616686.45243271202717537.62920729599918432.22455179536319372.4532496368711Community scale gas CHP(F488*$F362*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)00000000012Community scale solid-fuel CHP(F489*$F363*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)00000000013District heating from power stations(F490*$F364*G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364)00168769.23076923075157142.85714285713143956.04395604393183550.97675983229192913.92128025601202754.47006974899213096.985746005551281SUM(G$502:G$514)87480015516001535799.999999999814300001309999.99999999981670313.88851447381755516.68365032951845065.67763471561939182.570288650583123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C518, $C$90:$C$92, 0))Electric air conditioner (old)(F493*$F367*G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)0000000002INDEX($D$90:$D$92, MATCH($C519, $C$90:$C$92, 0))Electric air conditioner (new)(F494*$F368*G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)87480015516001351504125840011528001469876.22189273711544854.68161229021623657.79631855011706480.66185401263INDEX($D$90:$D$92, MATCH($C520, $C$90:$C$92, 0))Absorption chiller(F495*$F369*G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)00184296171600157200200437.66662173689210662.00203803956221407.88131616591232701.908434638081281SUM(G518:G520)87480015516001535800143000013100001670313.8885144741755516.68365032971845065.6776347161939182.57028865071286128783123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C527, $C$72:$C$84, 0))Gas boiler (old)(F478*$F352*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000002Gas boiler (new)(F479*$F353*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))30252005166742.25461359515564.24349152724886052.87679996042246529.31556934997396495.99927872627186827.36052738365477175.62452993626087541.65349670709933Resisitive heating(F480*$F354*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000004Oil-fired boiler(F481*$F355*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000005Solid-fuel boiler(F482*$F356*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000006Stirling engine μCHP(F483*$F357*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000007Fuel-cell μCHP(F484*$F358*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0000000008Air-source heat pump(F485*$F359*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))003227261.22508580423510668.54397704453787003.0302229853767679.58166123693959869.10588251894161862.22736303044374159.02809011759Ground-source heat pump(F486*$F360*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))001669273.04745817461815863.03998812681958794.67080499231948799.78361788112048208.15821509622152687.35898087782262496.049012129710Geothermal(F487*$F361*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))0055642.4349152724960528.76799960422865293.15569349974264959.99278726271668273.6052738365471756.24529936259275416.53496707099811Community scale gas CHP(F488*$F362*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))00000000012Community scale solid-fuel CHP(F489*$F363*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))00000000013District heating from power stations(F490*$F364*(F$229*(G$228-F$228)-G$336)/SUMPRODUCT(F$478:F$490,$F$352:$F$364))00612066.78406799748665816.44799564651718224.71262849728714559.92065988982751009.65801220189789318.69829298859829581.884637780951288SUM(G527:G539)3025200SUM(H527:H539)5166742.25461359515569807.73501877676058929.6767603836535844.8849193236502495.27800499556834187.88791103757182800.1544661957549195.150203807383123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C543, $C$90:$C$92, 0))Electric air conditioner (old)MAX((F493*$F367*(F$230*(G$228-F$228)-G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)), 0)0000000002INDEX($D$90:$D$92, MATCH($C544, $C$90:$C$92, 0))Electric air conditioner (new)MAX((F494*$F368*(F$230*(G$228-F$228)-G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)), 0)30252005166742.25461359514901430.80681652395331858.11554913785751543.49872900645722195.84464439846014085.34136171366320864.13593025326643291.73217935023INDEX($D$90:$D$92, MATCH($C545, $C$90:$C$92, 0))Absorption chillerMAX((F495*$F369*(F$230*(G$228-F$228)-G$336)/SUMPRODUCT(F$493:F$495,$F$367:$F$369)), 0)00668376.92820225318727071.56121124607784301.38619031897780299.4333605998820102.54654932453861936.01853594359905903.418024456831288SUM(G543:G545)30252005166742.25461359515569807.73501877676058929.67676038396535844.88491932496502495.27800499836834187.88791103857182800.15446619697549195.15020380731289128783123744220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($C552, $C$72:$C$84, 0))Gas boiler (old)G$540/F$466*F45320268842960157.07404131812438026.07212576182024060.45886490561663218.20580063181258248.20431256711008384.011918637808138.10185301874647657.225766581832Gas boiler (new)4537801411319.10097908652476789.58381445192057675.52082334531692396.01882293731281878.11371275041028942.8134835762826318.36406526307664018.204939862833Resisitive heating302520441814.48866288335363884.48837697937302098.57594998588248241.52325382561187798.23944963687150505.07640576671120617.627142241696665.2575771017734Oil-fired boiler121008176725.79546515332145553.79535079177120839.4303799943999296.60930153026175119.29577985477260202.03056230671148247.05085689666238666.1030308407135Solid-fuel boiler121008176725.79546515332145553.79535079177120839.4303799943999296.60930153026175119.29577985477260202.03056230671148247.05085689666238666.1030308407136Stirling engine μCHP0000000007Fuel-cell μCHP0000000008Air-source heat pump000831381.431010051511585369.63269454332102112.63480279272625052.11648749793092114.53662128933516842.90839797639Ground-source heat pump000430024.87810864742820018.775531660421087299.63869109941357785.5774935331599369.58790756321819056.676757573210Geothermal00014334.16260362158227333.95918438868536243.32128970332345259.51924978444753312.3195969187860635.22255858578911Community scale gas CHP00000000012Community scale solid-fuel CHP00000000013District heating from power stations000157675.78863983741300673.55102827551398676.53418673662497854.71174762893586435.51556610665666987.44814444381290SUM(G552:G564)30252005166742.25461359515569807.73501877776058929.6767603836535844.8849193246502495.27800499656834187.88791103857182800.1544661957549195.150203807383123744220072010201520202025203020352040204520501INDEX($D$90:$D$92, MATCH($C568, $C$90:$C$92, 0))Electric air conditioner (old)G$546/F$335*F4690000000002INDEX($D$90:$D$92, MATCH($C569, $C$90:$C$92, 0))Electric air conditioner (new)G$546/F$335*F4700748597.367984761481930962.85124898282865761.95606582153725094.13465819094189158.10817671194785479.77862496025336236.30004559185854192.28105905653INDEX($D$90:$D$92, MATCH($C570, $C$90:$C$92, 0))Absorption chillerG$546/F$335*F471000172181.96119470245328335.51772287698435354.77533191646543657.34522841091640387.58299818868728350.293373732591290SUM(G568:G570)0748597.367984761481930962.85124898283037943.91726052394053429.65238106814624512.88350862825329137.12385337155976623.88304378096582542.57443278937311129221297312994129851608613007115983678936791158220072010201520202025203020352040204520501294INDEX(F$64:F$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(G$64:G$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(H$64:H$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(I$64:I$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(J$64:J$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(K$64:K$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(L$64:L$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(M$64:M$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(N$64:N$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6INDEX(O$64:O$67, MATCH($E$8, $C64:$C$67, 0))4.0400000000000003E-6833851INDEX(Global.Assumptions[Households], MATCH(F$587,Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$587,Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$587,Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$587,Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$587,Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$587,Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$587,Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$587,Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$587,Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$587,Global.Assumptions[Year], 0))39954878.820088178351293F589*F590105.21210400000001G589*G590108.746296115.01476000000001121.21939200000001126.99659200000001132.28899200000001139.03706010959849146.12934751154583153.58341284919007161.417710433156238571317MIN(F$31, F$592)00.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.263445725529118351296Preferences.EnergyUnitsTWhF$592-F$593105.21210400000001G$592-G$593107.84087604218605112.46113042418605116.84588537413954120.65236218065117123.84464874995349128.23260317811139132.74597025838284137.38612703405514142.154264707627142160220072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($B600, $C$72:$C$84, 0))Gas boiler (old)F$595*F$375:F$38770.492109680000013G$595*G$375:G$38765.289526741241403H$595*H$375:H$38752.011726113478254I$595*I$375:I$38746.319669976973529J$595*J$375:J$38739.857184389045635K$595*K$375:K$38732.729398159202098L$595*L$375:L$38725.416778008397486M$595*M$375:M$38717.540910158291531N$595*N$375:N$3879.0770277493519842O$595*O$375:O$38702Gas boiler (new)15.78181560000000225.95245845567674847.2182380071790642.06746360145903936.21835138239308129.76607808730372923.14760079675400616.0191289433772688.35823315164922850.142154264707627133Resisitive heating10.5212104000000019.2216060251488397.34622642935277356.54227054570993535.62949786976052654.62275697694323.58990982046827692.47750858178789151.282055146694663704Oil-fired boiler4.20848416000000033.6886424100595352.93849057174110942.6169082182839742.25179914790421031.84910279077727971.43596392818731040.991003432715156230.5128220586778651205Solid-fuel boiler4.20848416000000033.6886424100595352.93849057174110942.6169082182839742.25179914790421031.84910279077727971.43596392818731040.991003432715156230.5128220586778651206Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0009.681516216714419119.99382001850790830.78424126070272142.49994848188834654.99475910704431768.30053172550168582.4494735304237319Ground-source heat pump0005.007680801748837710.34163104405581515.92288341070830521.98273197339052528.44556505536775535.3278612373284742.64627941228813810Geothermal0000.166922693391627910.34472103480186050.530762780356943580.732757732446350780.948185501845591691.17759537457761551.421542647076271311Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013INDEX($D$72:$D$84, MATCH($B612, $C$72:$C$84, 0))District heating from power stations0001.83614962730790723.79193138282046555.83839058392637978.060335056909860210.43004052030150912.95354912035376815.636969117838985Preferences.EnergyUnitsTWhSUM(F600:F612)105.21210400000001107.84087604218605112.45317169349231116.85548989987322120.68073541719372123.89271684069794128.30198972662947132.83810473344616137.50249762281317142.2964189723347586745INDEX(Vectors[Description], MATCH($B617, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$600:F$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-10.521210400000001SUM(G$600:G$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-9.221606025148839SUM(H$600:H$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-7.3462264293527735SUM(I$600:I$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-13.052255587983424SUM(J$600:J$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-19.073618227033084SUM(K$600:K$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-25.322505410863997SUM(L$600:L$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-32.167461385875953SUM(M$600:M$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-39.45674315376597SUM(N$600:N$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-47.208274755221666SUM(O$600:O$612/$M$143:$M$155*($B617=$F$142:$N$142)*($F$143:$N$155))-55.4401632359745846INDEX(Vectors[Description], MATCH($B618, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$600:F$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(G$600:G$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(H$600:H$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(I$600:I$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(J$600:J$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(K$600:K$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(L$600:L$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(M$600:M$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(N$600:N$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))0SUM(O$600:O$612/$M$143:$M$155*($B618=$F$142:$N$142)*($F$143:$N$155))047INDEX(Vectors[Description], MATCH($B619, Vectors[Code], 0))Solid hydrocarbonsSUM(F$600:F$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-4.8373381149425292SUM(G$600:G$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-4.2398188621373967SUM(H$600:H$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-3.3775753698173672SUM(I$600:I$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-3.0079404807861772SUM(J$600:J$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-2.5882748826485176SUM(K$600:K$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-2.1254055066405515SUM(L$600:L$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-1.6505332507900121SUM(M$600:M$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-1.1390844054197198SUM(N$600:N$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))-0.58945064215846565SUM(O$600:O$612/$M$143:$M$155*($B619=$F$142:$N$142)*($F$143:$N$155))049INDEX(Vectors[Description], MATCH($B620, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$600:F$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-4.338643463917526SUM(G$600:G$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-3.8027241340819948SUM(H$600:H$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-3.0293717234444428SUM(I$600:I$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-2.6978435240040972SUM(J$600:J$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-2.3214424205198045SUM(K$600:K$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-1.9062915368837936SUM(L$600:L$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-1.4803751836982582SUM(M$600:M$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-1.0216530234176868SUM(N$600:N$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))-0.52868253471944859SUM(O$600:O$612/$M$143:$M$155*($B620=$F$142:$N$142)*($F$143:$N$155))050INDEX(Vectors[Description], MATCH($B621, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$600:F$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-110.09543040023136SUM(G$600:G$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-114.42645714407752SUM(H$600:H$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-120.32465536252356SUM(I$600:I$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-107.17491615985364SUM(J$600:J$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-92.244049804294775SUM(K$600:K$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-75.774973498011491SUM(L$600:L$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-58.880052910894676SUM(M$600:M$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-40.683583344436116SUM(N$600:N$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-21.128329160155751SUM(O$600:O$612/$M$143:$M$155*($B621=$F$142:$N$142)*($F$143:$N$155))-0.15621347770068914751INDEX(Vectors[Description], MATCH($B622, Vectors[Code], 0))Heat transportSUM(F$600:F$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))0SUM(G$600:G$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))0SUM(H$600:H$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))0SUM(I$600:I$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-2.0401662525643411SUM(J$600:J$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-4.2132570920227392SUM(K$600:K$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-6.4871006488070879SUM(L$600:L$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-8.955927841010956SUM(M$600:M$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-11.588933911446121SUM(N$600:N$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-14.392832355948631SUM(O$600:O$612/$M$143:$M$155*($B622=$F$142:$N$142)*($F$143:$N$155))-17.374410130932205104INDEX(Vectors[Description], MATCH($B623, Vectors[Code], 0))Environmental heatSUM(F$600:F$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))0SUM(G$600:G$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))0SUM(H$600:H$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))0SUM(I$600:I$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-8.3755916154740362SUM(J$600:J$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-17.296884863881587SUM(K$600:K$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-26.631803037910164SUM(L$600:L$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-36.767196810396314SUM(M$600:M$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-47.576601945546457SUM(N$600:N$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-59.087579677335647SUM(O$600:O$612/$M$143:$M$155*($B623=$F$142:$N$142)*($F$143:$N$155))-71.3279928209446726INDEX(Vectors[Description], MATCH($B624, Vectors[Code], 0))Heating and coolingSUM(F$600:F$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))105.21210400000001SUM(G$600:G$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))107.84087604218605SUM(H$600:H$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))112.45317169349231SUM(I$600:I$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))116.85548989987322SUM(J$600:J$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))120.68073541719372SUM(K$600:K$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))123.89271684069794SUM(L$600:L$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))128.30198972662947SUM(M$600:M$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))132.83810473344616SUM(N$600:N$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))137.50249762281317SUM(O$600:O$612/$M$143:$M$155*($B624=$F$142:$N$142)*($F$143:$N$155))142.2964189723347534INDEX(Vectors[Description], MATCH($B625, Vectors[Code], 0))Conversion lossesSUM(F$600:F$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))24.580518379091405SUM(G$600:G$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))23.849730123259679SUM(H$600:H$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))21.624657191645838SUM(I$600:I$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))19.493223720792475SUM(J$600:J$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))17.056791873206802SUM(K$600:K$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))14.355362798419142SUM(L$600:L$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))11.599557656036694SUM(M$600:M$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))8.6284950505858902SUM(N$600:N$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))5.4326515027264612SUM(O$600:O$612/$M$143:$M$155*($B625=$F$142:$N$142)*($F$143:$N$155))2.0023606932173892Preferences.EnergyUnitsTWhSUM(F617:F625)000000-2.8421709430404007E-14-2.1316282072803006E-143.1974423109204508E-14-2.2648549702353193E-14315832007201020152020202520302035204020452050837827INDEX(F$40:F$43, MATCH($E$8, $C$40:$C$43, 0))-F$10511.913.59801200685425813.39972946506695513.20163568696435913.00373129189036412.80601690122096412.60849313837092112.41116062880046312.21402000002198612.017071881606775833834828INDEX(F$56:F$59, MATCH($E$9, $C$56:$C$59, 0))246.8230.09213145937301213.62430671629201200.9602593887422192.10780984991348185.30666308234677179.81072389865994174.54184826508376169.50627521999087164.72540602597195833853711(31+31+28.25)*24*60*60779760083585984F631*F632*$F63322900927392G631*G632*$F63324397096307.52545222320691734.85304320687065019.74584219479327555.21031618504018726.24043317678268630.68938816891682898.47560116143784830.91075715435482109.631683854827INDEX(F$40:F$43, MATCH($E$8, $C$40:$C$43, 0))-F$1068.49.35331738622940819.27566361274529259.19819860294588499.12092297617507879.04383735380886668.96694235926201178.89023861799474178.81372675751945248.7374074074074297833834828INDEX(F$56:F$59, MATCH($E$9, $C$56:$C$59, 0))246.8230.09213145937301213.62430671629201200.9602593887422192.10780984991348185.30666308234677179.81072389865994174.54184826508376169.50627521999087164.72540602597195833863711(31+30+31)*24*60*60794880083586084F636*F637*$F63816478816256.00000217106809082.54727615750604499.76935814693137231.54692313927891626.6197413321261345.88993512816266731.49672512334301442.80840511875364069.72525811440493085.676855855827INDEX(F$40:F$43, MATCH($E$8, $C$40:$C$43, 0))-F$1073.40000000000000043.28094012524749523.08265758346019152.88456380535759572.68665941028360142.48894501961420112.29142125676415812.09408874719371.89694811841522081.7000000000000099833834828INDEX(F$56:F$59, MATCH($E$9, $C$56:$C$59, 0))246.8230.09213145937301213.62430671629201200.9602593887422192.10780984991348185.30666308234677179.81072389865994174.54184826508376169.50627521999087164.72540602597195833864711(30+31+31)*24*60*60794880083586184F641*F642*$F6436669997056.000001G641*G642*$F6436000696225.33185775234527946.72077564607781770.62825784102600274.31568343666130402.9166473275081387.19962362905335049.56766222555893794.68136172225927822.612731856827INDEX(F$40:F$43, MATCH($E$8, $C$40:$C$43, 0))-F$1087.67.53559128803819267.42839401756871897.32138551078395327.2145663870277897.10793726767621877.00149877614400576.89525153789137776.78919618043073046.6833333333333496833834828INDEX(F$56:F$59, MATCH($E$9, $C$56:$C$59, 0))246.8230.09213145937301213.62430671629201200.9602593887422192.10780984991348185.30666308234677179.81072389865994174.54184826508376169.50627521999087164.72540602597195833865711(30+31+30)*24*60*60786240083586284F646*F647*$F64814747346432G646*G647*$F64813632460166.22017512476728728.31879411568008334.34567610897086283.27598410355945508.1953589898325734.60027129462476612.60952959048139207.63633168655832499.463010885884(F$634+F$639+F$644+F$649)60797087136(G$634+G$639+G$644+G$649)61137061781.62475655782552909.66196451555992356.26669348406905739.42172245847355983.24237143667942483.98600841593796003.46119739623181902.95371237757735517.38428513058415115522391304115522391161155223971130722392041308223913092238$F$119/$F$651*F$65132476408683.1579432658015336.59057629797759580.67806227540027930.6546425857858130.01031924490605390.73661823326412715.96075822218451266.76213521165794438.94876920169315790.9051281306F$651-F$65928320678452.84206G$651-G$65928479046445.0341825984793328.98390224015964425.61205322549047609.41140421356750592.50575320341529768.02524919375344736.69906218457387464.00494417588419726.479156833851INDEX(Global.Assumptions[Households], MATCH(F$629,Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$629,Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$629,Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$629,Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$629,Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$629,Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$629,Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$629,Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$629,Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$629,Global.Assumptions[Year], 0))39954878.8200881783583684F$661*F6627.3754410067598464E+17G$661*G6627.6658188477956301E+177.3976108128284275E+177.2059420939760448E+177.0882480179232563E+176.9932252680148237E+177.0005606363319642E+177.0081843667947955E+177.0167043539646938E+177.0274317880832307E+171295Preferences.EnergyUnitsTWhMAX(F$663, 0)/Preferences.Unit.Energy204.87336129888465MAX(G$663, 0)/Preferences.Unit.Energy212.93941243876753205.48918924523412200.16505816600127196.89577827564602194.25625744485623194.46001767588791194.67178796652212194.90845427679707195.206438557867564158420072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($B670, $C$72:$C$84, 0))Gas boiler (old)F$665*F$375:F$387137.26515207025273G$665*G$375:G$387128.91877340876357H$665*H$375:H$38795.035923878685068I$665*I$375:I$38779.348788410335288J$665*J$375:J$38765.043992494790913K$665*K$375:K$38751.33762709171198L$665*L$375:L$38738.543607306419872M$665*M$375:M$38725.723721303390036N$665*N$375:N$38712.877497067918981O$665*O$375:O$38702Gas boiler (new)30.73100419483269651.24495884780746786.27725338600204572.06446569958389159.10568474921025546.68951776612905735.1024836783437123.49203118560646111.8577496814450270.195206438557867573Resisitive heating20.48733612988846518.20871121233138413.42303876268846511.2073605341482889.18692634221252297.25101551405079015.4439659637375713.63326302395679871.81884002653287104Oil-fired boiler8.19493445195538687.28348448493255335.36921550507538654.48294421365931493.6747705368850092.90040620562031572.17758638549502811.4533052095827190.7275360106131478805Solid-fuel boiler8.19493445195538687.28348448493255335.36921550507538654.48294421365931493.6747705368850092.90040620562031572.17758638549502811.4533052095827190.7275360106131478806Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump00016.58510481946867532.62844325710705148.28655542200711964.44960585829427780.64974072898772396.897345840464823113.219734363563189Ground-source heat pump0008.578502492828626216.87678099505537324.97580452862436933.33600303015221341.71538313568331150.11931681403353958.56193156736026110Geothermal0000.285950083094287540.562559366501845790.832526817620812491.11120010100507381.39051277118944361.67064389380111791.952064385578675711Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013District heating from power stations0003.14545091403716316.18815303152030449.157794993828936512.22320111105581315.29564048308388118.37708283181229521.472708241365432Preferences.EnergyUnitsTWhSUM(F670:F682)204.87336129888467SUM(G670:G682)212.93941243876756205.47464703752632200.18151138081487196.94208131016831194.33165454521369194.56523981999857194.80690305106307195.07354817723495195.401644996425486745INDEX(Vectors[Description], MATCH($B687, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$670:F$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-20.487336129888465SUM(G$670:G$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-18.208711212331384SUM(H$670:H$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-13.423038762688465SUM(I$670:I$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-18.880354430511666SUM(J$670:J$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-24.28226934334538SUM(K$670:K$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-29.590485120209252SUM(L$670:L$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-35.261168674040384SUM(M$670:M$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-40.945355717540203SUM(N$670:N$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-46.647784510196196SUM(O$670:O$682/$M$125:$M$137*($B687=$F$124:$N$124)*($F$125:$N$137))-52.38039434636112246INDEX(Vectors[Description], MATCH($B688, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$670:F$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(G$670:G$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(H$670:H$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(I$670:I$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(J$670:J$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(K$670:K$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(L$670:L$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(M$670:M$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(N$670:N$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))0SUM(O$670:O$682/$M$125:$M$137*($B688=$F$124:$N$124)*($F$125:$N$137))047INDEX(Vectors[Description], MATCH($B689, Vectors[Code], 0))Solid hydrocarbonsSUM(F$670:F$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-9.4194648873050415SUM(G$670:G$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-8.3718212470489117SUM(H$670:H$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-6.1715120747992946SUM(I$670:I$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-5.1528094409877188SUM(J$670:J$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-4.2238741803275968SUM(K$670:K$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-3.3338002363451906SUM(L$670:L$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-2.5029728568908371SUM(M$670:M$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-1.6704657581410565SUM(N$670:N$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))-0.83624828806108953SUM(O$670:O$682/$M$125:$M$137*($B689=$F$124:$N$124)*($F$125:$N$137))049INDEX(Vectors[Description], MATCH($B690, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$670:F$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-8.4483860329436986SUM(G$670:G$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-7.5087468916830451SUM(H$670:H$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-5.5352737165725632SUM(I$670:I$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-4.6215919728446551SUM(J$670:J$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-3.7884232339020714SUM(K$670:K$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-2.9901094903302226SUM(L$670:L$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-2.2449344180361117SUM(M$670:M$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-1.4982527933842464SUM(N$670:N$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))-0.75003712434345149SUM(O$670:O$682/$M$125:$M$137*($B690=$F$124:$N$124)*($F$125:$N$137))050INDEX(Vectors[Description], MATCH($B691, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$670:F$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-214.3823764777369SUM(G$670:G$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-225.94310660252822SUM(H$670:H$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-219.85743681747391SUM(I$670:I$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-183.59802108890813SUM(J$670:J$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-150.53550257324974SUM(K$670:K$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-118.85667171156157SUM(L$670:L$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-89.28943065989489SUM(M$670:M$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-59.662420600268717SUM(N$670:N$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-29.974569244801174SUM(O$670:O$682/$M$125:$M$137*($B691=$F$124:$N$124)*($F$125:$N$137))-0.21451256984381051751INDEX(Vectors[Description], MATCH($B692, Vectors[Code], 0))Heat transportSUM(F$670:F$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))0SUM(G$670:G$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))0SUM(H$670:H$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))0SUM(I$670:I$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-3.4949454600412921SUM(J$670:J$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-6.8757255905781154SUM(K$670:K$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-10.17532777092104SUM(L$670:L$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-13.581334567839791SUM(M$670:M$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-16.995156092315423SUM(N$670:N$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-20.418980924235882SUM(O$670:O$682/$M$125:$M$137*($B692=$F$124:$N$124)*($F$125:$N$137))-23.858564712628258104INDEX(Vectors[Description], MATCH($B693, Vectors[Code], 0))Environmental heatSUM(F$670:F$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))0SUM(G$670:G$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))0SUM(H$670:H$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))0SUM(I$670:I$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-17.827025278397791SUM(J$670:J$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-35.071715799855262SUM(K$670:K$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-51.90233365932103SUM(L$670:L$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-69.275700414620232SUM(M$670:M$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-86.688928548957577SUM(N$670:N$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-104.15318157530695SUM(O$670:O$682/$M$125:$M$137*($B693=$F$124:$N$124)*($F$125:$N$137))-121.697817920537226INDEX(Vectors[Description], MATCH($B694, Vectors[Code], 0))Heating and coolingSUM(F$670:F$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))204.87336129888465SUM(G$670:G$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))212.93941243876756SUM(H$670:H$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))205.47464703752632SUM(I$670:I$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))200.18151138081487SUM(J$670:J$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))196.94208131016831SUM(K$670:K$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))194.33165454521369SUM(L$670:L$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))194.56523981999857SUM(M$670:M$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))194.80690305106307SUM(N$670:N$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))195.07354817723495SUM(O$670:O$682/$M$125:$M$137*($B694=$F$124:$N$124)*($F$125:$N$137))195.4016449964253834INDEX(Vectors[Description], MATCH($B695, Vectors[Code], 0))Conversion lossesSUM(F$670:F$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))47.864202228989427SUM(G$670:G$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))47.092973514824031SUM(H$670:H$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))39.512614334007893SUM(I$670:I$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))33.393236290876409SUM(J$670:J$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))27.835429411089894SUM(K$670:K$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))22.517073443474619SUM(L$670:L$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))17.590301771323659SUM(M$670:M$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))12.653676459544116SUM(N$670:N$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))7.7072534897097853SUM(O$670:O$682/$M$125:$M$137*($B695=$F$124:$N$124)*($F$125:$N$137))2.7496445529450058Preferences.EnergyUnitsTWhSUM(F687:F695)0SUM(G687:G695)6.3948846218409017E-140000-4.9737991503207013E-14-1.4210854715202004E-140-2.2648549702353193E-145161220072010201520202025203020352040204520501816Preferences.EnergyUnitsTWhINDEX(F$48:F$51, MATCH($E$8, $C$48:$C$51, 0))00.712.234.256.759.779999999999999413.5818.23999999999999823.8830.641INDEX($D$90:$D$92, MATCH($C702, $C$90:$C$92, 0))Electric air conditioner (old)F$701*F391:F3930G$701*G391:G3930H$701*H391:H3930I$701*I391:I3930J$701*J391:J3930K$701*K391:K3930L$701*L391:L3930M$701*M391:M3930N$701*N391:N3930O$701*O391:O39302INDEX($D$90:$D$92, MATCH($C703, $C$90:$C$92, 0))Electric air conditioner (new)00.712.234.00912217111059646.20323715108080358.859304175380355412.19462248453771216.2856073960039421.23770717635450127.1743166582108383INDEX($D$90:$D$92, MATCH($C704, $C$90:$C$92, 0))Absorption chiller0000.240877828889403730.546762848919196130.920695824619643721.38537751546228671.95439260399605712.64229282364549973.465683341789159SUM(F702:F704)00.712.234.256.759.779999999999999413.57999999999999818.23999999999999523.88000000000000330.639999999999997182045INDEX(Vectors[Description], MATCH($B709, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$702:F$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-0.11833333333333333SUM(H$702:H$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-0.37166666666666665SUM(I$702:I$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-0.6681870285184327SUM(J$702:J$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-1.0338728585134673SUM(K$702:K$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-1.4765506958967258SUM(L$702:L$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-2.0324370807562855SUM(M$702:M$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-2.7142678993339899SUM(N$702:N$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-3.5396178627257502SUM(O$702:O$704/$M$197:$M$199*($B709=$F$196:$N$196)*($F$197:$N$199))-4.529052776368472746INDEX(Vectors[Description], MATCH($B710, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$702:F$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(J$702:J$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(K$702:K$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(L$702:L$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(M$702:M$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(N$702:N$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))0SUM(O$702:O$704/$M$197:$M$199*($B710=$F$196:$N$196)*($F$197:$N$199))047INDEX(Vectors[Description], MATCH($B711, Vectors[Code], 0))Solid hydrocarbonsSUM(F$702:F$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(J$702:J$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(K$702:K$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(L$702:L$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(M$702:M$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(N$702:N$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))0SUM(O$702:O$704/$M$197:$M$199*($B711=$F$196:$N$196)*($F$197:$N$199))049INDEX(Vectors[Description], MATCH($B712, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$702:F$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(J$702:J$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(K$702:K$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(L$702:L$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(M$702:M$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(N$702:N$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))0SUM(O$702:O$704/$M$197:$M$199*($B712=$F$196:$N$196)*($F$197:$N$199))050INDEX(Vectors[Description], MATCH($B713, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$702:F$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(J$702:J$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(K$702:K$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(L$702:L$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(M$702:M$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(N$702:N$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0SUM(O$702:O$704/$M$197:$M$199*($B713=$F$196:$N$196)*($F$197:$N$199))0751INDEX(Vectors[Description], MATCH($B714, Vectors[Code], 0))Heat transportSUM(F$702:F$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-0.34411118412771963SUM(J$702:J$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-0.78108978417028019SUM(K$702:K$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-1.315279749456634SUM(L$702:L$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-1.9791107363746954SUM(M$702:M$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-2.7919894342800817SUM(N$702:N$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-3.7747040337792854SUM(O$702:O$704/$M$197:$M$199*($B714=$F$196:$N$196)*($F$197:$N$199))-4.9509762025559416104INDEX(Vectors[Description], MATCH($B715, Vectors[Code], 0))Environmental heatSUM(F$702:F$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-0.59166666666666667SUM(H$702:H$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-1.8583333333333332SUM(I$702:I$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-3.2377017873538474SUM(J$702:J$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-4.9350373573162525SUM(K$702:K$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-6.9881695546466389SUM(L$702:L$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-9.5684521828690183SUM(M$702:M$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-12.733742666385925SUM(N$702:N$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-16.565678103494964SUM(O$702:O$704/$M$197:$M$199*($B715=$F$196:$N$196)*($F$197:$N$199))-21.1599710210755816INDEX(Vectors[Description], MATCH($B716, Vectors[Code], 0))Heating and coolingSUM(F$702:F$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))0.71SUM(H$702:H$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))2.23SUM(I$702:I$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))4.25SUM(J$702:J$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))6.7500000000000009SUM(K$702:K$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))9.7799999999999994SUM(L$702:L$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))13.58SUM(M$702:M$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))18.239999999999995SUM(N$702:N$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))23.880000000000003SUM(O$702:O$704/$M$197:$M$199*($B716=$F$196:$N$196)*($F$197:$N$199))30.63999999999999334INDEX(Vectors[Description], MATCH($B717, Vectors[Code], 0))Conversion lossesSUM(F$702:F$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(G$702:G$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(H$702:H$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(I$702:I$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(J$702:J$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(K$702:K$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(L$702:L$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(M$702:M$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(N$702:N$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0SUM(O$702:O$704/$M$197:$M$199*($B717=$F$196:$N$196)*($F$197:$N$199))0Preferences.EnergyUnitsTWhSUM(F709:F717)0SUM(G709:G717)0008.8817841970012523E-161.7763568394002505E-151.7763568394002505E-1503.5527136788005009E-150182145INDEX(Vectors[Description], MATCH($B722, Vectors[Code], 0))Electricity (delivered to end user)F7090G709-0.11833333333333333-0.37166666666666665-0.6681870285184327-1.0338728585134673-1.4765506958967258-2.0324370807562855-2.7142678993339899-3.5396178627257502-4.529052776368472746INDEX(Vectors[Description], MATCH($B723, Vectors[Code], 0))Electricity (supplied to grid)F710000000000047INDEX(Vectors[Description], MATCH($B724, Vectors[Code], 0))Solid hydrocarbons000000000049INDEX(Vectors[Description], MATCH($B725, Vectors[Code], 0))Liquid hydrocarbons000000000050INDEX(Vectors[Description], MATCH($B726, Vectors[Code], 0))Gaseous hydrocarbons0000000000751INDEX(Vectors[Description], MATCH($B727, Vectors[Code], 0))Heat transport000-0.34411118412771963-0.78108978417028019-1.315279749456634-1.9791107363746954-2.7919894342800817-3.7747040337792854-4.9509762025559416104INDEX(Vectors[Description], MATCH($B728, Vectors[Code], 0))Environmental heat00000000006INDEX(Vectors[Description], MATCH($B729, Vectors[Code], 0))Heating and cooling-SUM(F722:F728)-F7300-SUM(G722:G728)-G7300.118333333333333330.371666666666666651.01229821264615241.81496264268374752.79183044535335964.01154781713098095.50625733361407127.31432189650503529.480028978924414334INDEX(Vectors[Description], MATCH($B730, Vectors[Code], 0))Conversion lossesF7170000000000Preferences.EnergyUnitsTWhSUM(F722:F730)0SUM(G722:G730)00000000051585200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B736, Vectors[Code], 0))Electricity (delivered to end user)F617+F687+F722-31.008546529888466-27.548650570813557-21.140931858707905-32.600797047013522-44.389760428891933-56.389541226969975-69.461067140672625-83.11636677064017-97.395677128143603-112.3496103587041846INDEX(Vectors[Description], MATCH($B737, Vectors[Code], 0))Electricity (supplied to grid)000000000047INDEX(Vectors[Description], MATCH($B738, Vectors[Code], 0))Solid hydrocarbons-14.256803002247571-12.611640109186308-9.5490874446166618-8.1607499217738955-6.8121490629761148-5.4592057429857421-4.1535061076808493-2.8095501635607762-1.4256989302195553049INDEX(Vectors[Description], MATCH($B739, Vectors[Code], 0))Liquid hydrocarbons-12.787029496861225-11.311471025765041-8.5646454400170065-7.3194354968487527-6.1098656544218759-4.8964010272140159-3.7253096017343701-2.5199058168019333-1.2787196590629050INDEX(Vectors[Description], MATCH($B740, Vectors[Code], 0))Gaseous hydrocarbons-324.47780687796825-340.36956374660576-340.18209217999748-290.77293724876176-242.77955237754452-194.63164520957307-148.16948357078957-100.34600394470483-51.102898404956925-0.37072604754449967751INDEX(Vectors[Description], MATCH($B741, Vectors[Code], 0))Heat transport000-5.8792228967333537-11.870072466771134-17.977708169184766-24.516373145225444-31.376079438041629-38.586517313963796-46.183951046116405104INDEX(Vectors[Description], MATCH($B742, Vectors[Code], 0))Environmental heat000-26.202616893871827-52.368600663736849-78.53413669723119-106.04289722501655-134.26553049450405-163.24076125264259-193.025810741481916INDEX(Vectors[Description], MATCH($B743, Vectors[Code], 0))Heating and cooling310.08546529888463320.89862181428697318.29948539768532318.04929949333422319.43777937004575321.01620183126499326.87877736375901333.15126511812332339.89036769655314347.1780929476845534INDEX(Vectors[Description], MATCH($B744, Vectors[Code], 0))Conversion losses72.44472060808082970.94270363808371461.1372715256537352.88646001166888844.89222128429669636.87243624189375929.18985942736035421.28217151013000613.1399049924362474.7520052461623949Preferences.EnergyUnitsTWhSUM(F736:F744)0000000-6.3948846218409017E-140-7.3718808835110394E-1461160200720102015202020252030203520402045205010401060-SUM(F$736:F$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))67.291769164453711-SUM(G$736:G$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))69.340252639446092-SUM(H$736:H$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))67.675785254065715-SUM(I$736:I$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))57.845590303890702-SUM(J$736:J$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))48.297045962470293-SUM(K$736:K$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))38.717758344204547-SUM(L$736:L$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))29.47379225862457-SUM(M$736:M$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))19.95898263040289-SUM(N$736:N$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))10.16172849178542-SUM(O$736:O$744*SUMIFS(EF[CO2], EF[Vector], $B$736:$B$744))6.8213592748187932E-21041-SUM(F$736:F$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))0.13655504882378258-SUM(G$736:G$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))0.14046853444863866-SUM(H$736:H$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))0.13677346814360333-SUM(I$736:I$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))0.11690639026200543-SUM(J$736:J$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))9.7608530686676367E-2-SUM(K$736:K$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))7.8248538092932945E-2-SUM(L$736:L$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))5.9566225576337527E-2-SUM(M$736:M$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))4.0336530732123836E-2-SUM(N$736:N$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))2.0536007640052169E-2-SUM(O$736:O$744*SUMIFS(EF[CH4], EF[Vector], $B$736:$B$744))1.3673317177722002E-41042-SUM(F$736:F$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.22513176941521534-SUM(G$736:G$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.22031008538679159-SUM(H$736:H$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.1995245256768505-SUM(I$736:I$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.17053548650114853-SUM(J$736:J$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.14237679661246122-SUM(K$736:K$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))0.11412744247608923-SUM(L$736:L$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))8.6866301984324656E-2-SUM(M$736:M$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))5.8806424007998584E-2-SUM(N$736:N$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))2.9913594429615283E-2-SUM(O$736:O$744*SUMIFS(EF[N2O],EF[Vector], $B$736:$B$744))1.4706317373905183E-472719272820072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($B756, $C$72:$C$84, 0))Gas boiler (old)2Gas boiler (new)3Resisitive heating4Oil-fired boiler5Solid-fuel boiler6Stirling engine μCHPF605+F6750G605+G6750000000007Fuel-cell μCHPF606+F67600000000008Air-source heat pump9Ground-source heat pump10Geothermal11Community scale gas CHPF610+F6800G610+G68000000000012Community scale solid-fuel CHPF611+F681000000000013District heating from power stationsPreferences.EnergyUnitsTWhSUM(F756:F768)0SUM(G756:G768)0000000001820200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B774, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$756:F$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B774=$F$124:$N$124)*($F$125:$N$137))046INDEX(Vectors[Description], MATCH($B775, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$756:F$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B775=$F$124:$N$124)*($F$125:$N$137))047INDEX(Vectors[Description], MATCH($B776, Vectors[Code], 0))Solid hydrocarbonsSUM(F$756:F$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B776=$F$124:$N$124)*($F$125:$N$137))049INDEX(Vectors[Description], MATCH($B777, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$756:F$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B777=$F$124:$N$124)*($F$125:$N$137))050INDEX(Vectors[Description], MATCH($B778, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$756:F$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B778=$F$124:$N$124)*($F$125:$N$137))0751INDEX(Vectors[Description], MATCH($B779, Vectors[Code], 0))Heat transportSUM(F$756:F$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B779=$F$124:$N$124)*($F$125:$N$137))0104INDEX(Vectors[Description], MATCH($B780, Vectors[Code], 0))Environmental heatSUM(F$756:F$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B780=$F$124:$N$124)*($F$125:$N$137))06INDEX(Vectors[Description], MATCH($B781, Vectors[Code], 0))Heating and coolingSUM(F$756:F$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B781=$F$124:$N$124)*($F$125:$N$137))034INDEX(Vectors[Description], MATCH($B782, Vectors[Code], 0))Conversion lossesSUM(F$756:F$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(G$756:G$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(H$756:H$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(I$756:I$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(J$756:J$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(K$756:K$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(L$756:L$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(M$756:M$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(N$756:N$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0SUM(O$756:O$768/$M$125:$M$137*($B782=$F$124:$N$124)*($F$125:$N$137))0Preferences.EnergyUnitsTWhSUM(F774:F782)00000000002720200720102015202020252030203520402045205010401060-SUM(F$774:F$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(G$774:G$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(H$774:H$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(I$774:I$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(J$774:J$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(K$774:K$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(L$774:L$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(M$774:M$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(N$774:N$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(O$774:O$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))01041-SUM(F$774:F$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(G$774:G$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(H$774:H$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(I$774:I$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(J$774:J$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(K$774:K$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(L$774:L$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(M$774:M$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(N$774:N$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(O$774:O$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))01042-SUM(F$774:F$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(G$774:G$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(H$774:H$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(I$774:I$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(J$774:J$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(K$774:K$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(L$774:L$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(M$774:M$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(N$774:N$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))0-SUM(O$774:O$782*SUMIFS(EF[CO2], EF[Vector], $B$774:$B$782))08371336893712368020072010201520202025203020352040204520503686Preferences.PowerUnits&"e"GWeF722*Conversion.to.average.power0-1.3499125408776329E-2-4.2398661495170721E-2-7.622484924919376E-2-0.11794123414481715-0.16844064520838758-0.23185456088937773-0.30963585436162322-0.40378939798377245-0.51666127953096874368120072010201520202025203020352040204520503708Preferences.PowerUnits&"th"GWthF592*Conversion.to.average.power12.00229340634268612.40546383755418313.1205521332420713.82835865845311214.48740497376226215.09114670317134215.8609468525665616.67001454614941717.52035282331622718.414066898603263368720072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($B801, $C$72:$C$84, 0))Gas boiler (old)F$798*F$375:F$3878.0415365822496003G$798*G$375:G$3877.5105738443988113H$798*H$375:H$3876.0680749111964882I$798*I$375:I$3875.4817934523908729J$798*J$375:J$3874.7858753937485723K$798*K$375:K$3873.9882558843884679L$798*L$375:L$3873.1437727626470573M$798*M$375:M$3872.202757845848466N$798*N$375:N$3871.1575603169616822O$798*O$375:O$38702Gas boiler (new)1.80034401095140282.98543832991101925.50883092741692874.9785576331568894.34894033133897213.62715915243550712.86310077860457792.01165513335708071.06589505765843181.8414066898603264E-23Resisitive heating1.20022934063426861.06080647958019590.857065427720391960.774258017362187910.675965343438852730.563308180178312970.444031919003211370.311121339625042850.1634958273732476404Oil-fired boiler0.480091736253707440.424322591832078380.342826171088156770.309703206944875130.270386137375541070.225323272071325190.17761276760128450.12444853585001716.5398330949299019E-205Solid-fuel boiler0.480091736253707440.424322591832078380.342826171088156770.309703206944875130.270386137375541070.225323272071325190.17761276760128450.12444853585001716.5398330949299019E-206Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0001.14577828884325772.40076996708060313.75122789478830495.25677095685063116.90614888340475828.710118260734352810.6801588011898929Ground-source heat pump0000.592643942505133411.24177756917962251.94029029040774372.71901946043998163.57214597417487534.50523358313845895.524220069580978910Geothermal0001.9754798083504447E-24.1392585639320745E-26.4676343013591472E-29.0633982014666062E-20.119071532472495830.150174452771281940.1841406689860326211Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013INDEX($D$72:$D$84, MATCH($B813, $C$72:$C$84, 0))District heating from power stations0000.217302778918548930.455318442032528250.711439773149506130.996973802161326691.30978685719745421.65191898048410122.0255473588463588Preferences.PowerUnits&"th"GWthSUM(F801:F813)12.00229340634268412.40546383755418313.11962360851012513.82949532515014314.49081190720955315.09700406250408415.86952919692401816.68158463778020517.53519314102015518.4324809655018673688200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B817, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$801:F$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-1.2002293406342686SUM(G$801:G$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-1.0608064795801959SUM(H$801:H$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-0.85706542772039196SUM(I$801:I$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-1.6103449261488911SUM(J$801:J$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-2.4278333619111145SUM(K$801:K$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-3.3006200713596083SUM(L$801:L$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-4.2799549961895824SUM(M$801:M$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-5.3506134715417861SUM(N$801:N$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-6.5193640810264935SUM(O$801:O$813/$M$179:$M$191*($B817=$F$178:$N$178)*($F$179:$N$191))-7.793428313651279646INDEX(Vectors[Description], MATCH($B818, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$801:F$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(G$801:G$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(H$801:H$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(I$801:I$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(J$801:J$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(K$801:K$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(L$801:L$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(M$801:M$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(N$801:N$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))0SUM(O$801:O$813/$M$179:$M$191*($B818=$F$178:$N$178)*($F$179:$N$191))047INDEX(Vectors[Description], MATCH($B819, Vectors[Code], 0))Solid hydrocarbonsSUM(F$801:F$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.5518295819008131SUM(G$801:G$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.48772711704836597SUM(H$801:H$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.39405307021627217SUM(I$801:I$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.3559806976377875SUM(J$801:J$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.3107886636500472SUM(K$801:K$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.25899226674864967SUM(L$801:L$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.20415260643825806SUM(M$801:M$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-0.14304429408047942SUM(N$801:N$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))-7.5170495344021857E-2SUM(O$801:O$813/$M$179:$M$191*($B819=$F$178:$N$178)*($F$179:$N$191))049INDEX(Vectors[Description], MATCH($B820, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$801:F$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.49493993428217264SUM(G$801:G$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.43744597096090554SUM(H$801:H$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.35342904235892453SUM(I$801:I$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.31928165664420116SUM(J$801:J$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.27874859523251655SUM(K$801:K$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.23229203306322185SUM(L$801:L$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.18310594598070568SUM(M$801:M$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-0.1282974596391929SUM(N$801:N$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))-6.7420959741545383E-2SUM(O$801:O$813/$M$179:$M$191*($B820=$F$178:$N$178)*($F$179:$N$191))050INDEX(Vectors[Description], MATCH($B821, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$801:F$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-12.559369199205035SUM(G$801:G$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-13.163035467228589SUM(H$801:H$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-14.037969453478413SUM(I$801:I$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-12.683828575585498SUM(J$801:J$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-11.076259774622354SUM(K$801:K$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-9.233594289538015SUM(L$801:L$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-7.2828077006192906SUM(M$801:M$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-5.1089756232988517SUM(N$801:N$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-2.6944189303868402SUM(O$801:O$813/$M$179:$M$191*($B821=$F$178:$N$178)*($F$179:$N$191))-2.0235238350113476E-2751INDEX(Vectors[Description], MATCH($B822, Vectors[Code], 0))Heat transportSUM(F$801:F$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))0SUM(G$801:G$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))0SUM(H$801:H$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))0SUM(I$801:I$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-0.24144753213172104SUM(J$801:J$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-0.5059093800361425SUM(K$801:K$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-0.79048863683278459SUM(L$801:L$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-1.1077486690681408SUM(M$801:M$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-1.4553187302193935SUM(N$801:N$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-1.8354655338712236SUM(O$801:O$813/$M$179:$M$191*($B822=$F$178:$N$178)*($F$179:$N$191))-2.250608176495954104INDEX(Vectors[Description], MATCH($B823, Vectors[Code], 0))Environmental heatSUM(F$801:F$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))0SUM(G$801:G$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))0SUM(H$801:H$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))0SUM(I$801:I$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-0.92557626148345784SUM(J$801:J$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-1.9393766773636352SUM(K$801:K$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-3.0302961093248606SUM(L$801:L$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-4.2464955542391429SUM(M$801:M$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-5.5788868815128856SUM(N$801:N$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-7.0361594170093085SUM(O$801:O$813/$M$179:$M$191*($B823=$F$178:$N$178)*($F$179:$N$191))-8.62758663827962916INDEX(Vectors[Description], MATCH($B824, Vectors[Code], 0))Heating and coolingSUM(F$801:F$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))12.002293406342684SUM(G$801:G$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))12.405463837554183SUM(H$801:H$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))13.119623608510125SUM(I$801:I$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))13.829495325150143SUM(J$801:J$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))14.490811907209553SUM(K$801:K$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))15.097004062504084SUM(L$801:L$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))15.869529196924018SUM(M$801:M$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))16.681584637780205SUM(N$801:N$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))17.535193141020155SUM(O$801:O$813/$M$179:$M$191*($B824=$F$178:$N$178)*($F$179:$N$191))18.43248096550186734INDEX(Vectors[Description], MATCH($B825, Vectors[Code], 0))Conversion lossesSUM(F$801:F$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))2.804074649679603SUM(G$801:G$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))2.7435511972638742SUM(H$801:H$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))2.5228933852638784SUM(I$801:I$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))2.3069643244814118SUM(J$801:J$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))2.0481045456062557SUM(K$801:K$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))1.7492793443630557SUM(L$801:L$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))1.4347362756110993SUM(M$801:M$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))1.083551822512381SUM(N$801:N$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))0.6928062763592796SUM(O$801:O$813/$M$179:$M$191*($B825=$F$178:$N$178)*($F$179:$N$191))0.25937740127511139Preferences.PowerUnitsGWSUM(F817:F825)000000-3.5527136788005009E-15-5.9952043329758453E-151.8873791418627661E-151.609823385706477E-153709200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B829, Vectors[Code], 0))Electricity (delivered to end user)F817-(F617*Conversion.to.average.power)0-8.8322581395345878E-3-1.9029102218136473E-2-0.12138124967348363-0.25197000039695983-0.41190168088915513-0.6103837680495019-0.84950200065814929-1.1339802394543215-1.468974373886897746INDEX(Vectors[Description], MATCH($B830, Vectors[Code], 0))Electricity (supplied to grid)F818-(F618*Conversion.to.average.power)000000000047INDEX(Vectors[Description], MATCH($B831, Vectors[Code], 0))Solid hydrocarbonsF819-(F619*Conversion.to.average.power)0-4.0608083400159867E-3-8.7490125140857189E-3-1.2843522097498117E-2-1.5525729284485146E-2-1.6532135943202353E-2-1.5864533110627244E-2-1.3100830080967713E-2-7.9276659853102921E-3049INDEX(Vectors[Description], MATCH($B832, Vectors[Code], 0))Liquid hydrocarbonsF820-(F620*Conversion.to.average.power)0-3.6421683049627784E-3-7.8470524610871895E-3-1.151944765445706E-2-1.3925138636600054E-2-1.4827792031532006E-2-1.4229014233242993E-2-1.1750229041692706E-2-7.1103808321855283E-3050INDEX(Vectors[Description], MATCH($B833, Vectors[Code], 0))Gaseous hydrocarbonsF821-(F621*Conversion.to.average.power)0-0.10959522720149728-0.31167977032491834-0.45762321854082266-0.5533245927498065-0.58940383801948038-0.56594106693292723-0.46790976151056629-0.28416007114023456-2.4148553133020341E-3751INDEX(Vectors[Description], MATCH($B834, Vectors[Code], 0))Heat transportF822-(F622*Conversion.to.average.power)000-8.7112496124031324E-3-2.5273161461794091E-2-5.0458902768549252E-2-8.6082248692718188E-2-0.13328657057461601-0.19357272575479323-0.26858557429059227104INDEX(Vectors[Description], MATCH($B835, Vectors[Code], 0))Environmental heatF823-(F623*Conversion.to.average.power)0002.9887075896651072E-23.3802065949344984E-27.7831785955315702E-3-5.2199773906458802E-2-0.15148533627601068-0.29561872828747049-0.49069491788895376INDEX(Vectors[Description], MATCH($B836, Vectors[Code], 0))Heating and coolingF824-(F624*Conversion.to.average.power)00.10328769767441770.291290081988075040.498958033355345170.723901638307694380.963680215744110671.23320821510455231.52779673754678851.84930475146811982.199715853439954634INDEX(Vectors[Description], MATCH($B837, Vectors[Code], 0))Conversion lossesF825-(F625*Conversion.to.average.power)02.2842764311595598E-25.6014855530153618E-28.3233578326669555E-20.102314918272603080.11166095531227560.111492189820922249.9237990595213765E-27.3065059986194947E-23.0953867939794405E-2Preferences.PowerUnitsGWSUM(F829:F837)02.6645352591003757E-159.4368957093138306E-161.2212453270876722E-15-3.1086244689504383E-15-1.3322676295501878E-15-1.7763568394002505E-15-5.5511151231257827E-16-7.7715611723760958E-163.0253577421035516E-153710200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B841, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$670:F$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-20.487336129888465SUM(G$670:G$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-18.208711212331384SUM(H$670:H$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-13.423038762688465SUM(I$670:I$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-19.516280457056375SUM(J$670:J$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-25.533348338545611SUM(K$670:K$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-31.441946275221191SUM(L$670:L$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-37.732372939070189SUM(M$670:M$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-44.037725028552408SUM(N$670:N$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-50.363139028228645SUM(O$670:O$682/$M$161:$M$173*($B841=$F$160:$N$160)*($F$161:$N$173))-56.72160150688204546INDEX(Vectors[Description], MATCH($B842, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$670:F$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(G$670:G$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(H$670:H$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(I$670:I$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(J$670:J$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(K$670:K$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(L$670:L$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(M$670:M$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(N$670:N$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))0SUM(O$670:O$682/$M$161:$M$173*($B842=$F$160:$N$160)*($F$161:$N$173))047INDEX(Vectors[Description], MATCH($B843, Vectors[Code], 0))Solid hydrocarbonsSUM(F$670:F$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-9.4194648873050415SUM(G$670:G$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-8.3718212470489117SUM(H$670:H$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-6.1715120747992946SUM(I$670:I$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-5.1528094409877188SUM(J$670:J$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-4.2238741803275968SUM(K$670:K$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-3.3338002363451906SUM(L$670:L$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-2.5029728568908371SUM(M$670:M$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-1.6704657581410565SUM(N$670:N$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))-0.83624828806108953SUM(O$670:O$682/$M$161:$M$173*($B843=$F$160:$N$160)*($F$161:$N$173))049INDEX(Vectors[Description], MATCH($B844, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$670:F$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-8.4483860329436986SUM(G$670:G$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-7.5087468916830451SUM(H$670:H$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-5.5352737165725632SUM(I$670:I$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-4.6215919728446551SUM(J$670:J$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-3.7884232339020714SUM(K$670:K$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-2.9901094903302226SUM(L$670:L$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-2.2449344180361117SUM(M$670:M$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-1.4982527933842464SUM(N$670:N$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))-0.75003712434345149SUM(O$670:O$682/$M$161:$M$173*($B844=$F$160:$N$160)*($F$161:$N$173))050INDEX(Vectors[Description], MATCH($B845, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$670:F$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-214.3823764777369SUM(G$670:G$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-225.94310660252822SUM(H$670:H$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-219.85743681747391SUM(I$670:I$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-183.59802108890813SUM(J$670:J$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-150.53550257324974SUM(K$670:K$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-118.85667171156157SUM(L$670:L$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-89.28943065989489SUM(M$670:M$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-59.662420600268717SUM(N$670:N$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-29.974569244801174SUM(O$670:O$682/$M$161:$M$173*($B845=$F$160:$N$160)*($F$161:$N$173))-0.21451256984381051751INDEX(Vectors[Description], MATCH($B846, Vectors[Code], 0))Heat transportSUM(F$670:F$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))0SUM(G$670:G$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))0SUM(H$670:H$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))0SUM(I$670:I$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-3.4949454600412921SUM(J$670:J$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-6.8757255905781154SUM(K$670:K$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-10.17532777092104SUM(L$670:L$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-13.581334567839791SUM(M$670:M$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-16.995156092315423SUM(N$670:N$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-20.418980924235882SUM(O$670:O$682/$M$161:$M$173*($B846=$F$160:$N$160)*($F$161:$N$173))-23.858564712628258104INDEX(Vectors[Description], MATCH($B847, Vectors[Code], 0))Environmental heatSUM(F$670:F$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))0SUM(G$670:G$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))0SUM(H$670:H$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))0SUM(I$670:I$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-17.191099251853085SUM(J$670:J$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-33.820636804655031SUM(K$670:K$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-50.050872504309091SUM(L$670:L$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-66.804496149590435SUM(M$670:M$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-83.596559237945357SUM(N$670:N$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-100.43782705727449SUM(O$670:O$682/$M$161:$M$173*($B847=$F$160:$N$160)*($F$161:$N$173))-117.35661076001636INDEX(Vectors[Description], MATCH($B848, Vectors[Code], 0))Heating and coolingSUM(F$670:F$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))204.87336129888465SUM(G$670:G$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))212.93941243876756SUM(H$670:H$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))205.47464703752632SUM(I$670:I$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))200.18151138081487SUM(J$670:J$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))196.94208131016831SUM(K$670:K$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))194.33165454521369SUM(L$670:L$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))194.56523981999857SUM(M$670:M$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))194.80690305106307SUM(N$670:N$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))195.07354817723495SUM(O$670:O$682/$M$161:$M$173*($B848=$F$160:$N$160)*($F$161:$N$173))195.401644996425434INDEX(Vectors[Description], MATCH($B849, Vectors[Code], 0))Conversion lossesSUM(F$670:F$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))47.864202228989427SUM(G$670:G$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))47.092973514824031SUM(H$670:H$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))39.512614334007893SUM(I$670:I$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))33.393236290876409SUM(J$670:J$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))27.835429411089894SUM(K$670:K$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))22.517073443474619SUM(L$670:L$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))17.590301771323659SUM(M$670:M$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))12.653676459544116SUM(N$670:N$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))7.7072534897097853SUM(O$670:O$682/$M$161:$M$173*($B849=$F$160:$N$160)*($F$161:$N$173))2.7496445529450058Preferences.EnergyUnitsTWhSUM(F841:F849)06.3948846218409017E-140000-4.9737991503207013E-14-1.4210854715202004E-1405.773159728050814E-153711200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B853, Vectors[Code], 0))Electricity (delivered to end user)(F841-F687)*Conversion.to.average.power000-7.2544607180550877E-2-0.1427194838238913-0.21120934919141449-0.2819078559240023-0.35276857301074666-0.42383692881958107-0.4952323933973217846INDEX(Vectors[Description], MATCH($B854, Vectors[Code], 0))Electricity (supplied to grid)(F842-F688)*Conversion.to.average.power000000000047INDEX(Vectors[Description], MATCH($B855, Vectors[Code], 0))Solid hydrocarbons(F843-F689)*Conversion.to.average.power000000000049INDEX(Vectors[Description], MATCH($B856, Vectors[Code], 0))Liquid hydrocarbons(F844-F690)*Conversion.to.average.power000000000050INDEX(Vectors[Description], MATCH($B857, Vectors[Code], 0))Gaseous hydrocarbons(F845-F691)*Conversion.to.average.power0000000000751INDEX(Vectors[Description], MATCH($B858, Vectors[Code], 0))Heat transport(F846-F692)*Conversion.to.average.power0000000000104INDEX(Vectors[Description], MATCH($B859, Vectors[Code], 0))Environmental heat(F847-F693)*Conversion.to.average.power0007.2544607180550474E-20.14271948382389130.211209349191414490.281907855924001470.352768573010748270.42383692881958190.495232393397321786INDEX(Vectors[Description], MATCH($B860, Vectors[Code], 0))Heating and cooling(F848-F694)*Conversion.to.average.power0000000003.2422666473196442E-1534INDEX(Vectors[Description], MATCH($B861, Vectors[Code], 0))Conversion losses(F849-F695)*Conversion.to.average.power0000000000Preferences.PowerUnitsGWSUM(F853:F861)000-4.0245584642661925E-1600-8.3266726846886741E-161.609823385706477E-158.3266726846886741E-163.2422666473196442E-153690Preferences.PowerUnits&"e"GWe-SUM(F829:F830)-SUM(F853:F854)+F7950-4.6668672692417416E-3-2.3369559277034248E-20.117701007604840760.276748250076033990.454670384872181980.660437063084126420.892634719307272671.154027770290131.44754548775325053689371420072010201520202025203020352040204520503691Preferences.PowerUnits&"th/degree"GWth/degreeF632*F662*Unit.W6.42731368000000016.19348193934452776.08167038790611786.02977239090733266.03887058107005986.06782962129882996.1882065413486146.31328871297918956.44389907119809286.5815836363575313371720072010201520202025203020352040204520501INDEX($D$72:$D$84, MATCH($B871, $C$72:$C$84, 0))Gas boiler (old)F$868*F$375:F$3874.3063001656000006G$868*G$375:G$3873.7496867564581513H$868*H$375:H$3872.8126889115832348I$868*I$375:I$3872.3903029729184508J$868*J$375:J$3871.9949247068275966K$868*K$375:K$3871.6035929985046242L$868*L$375:L$3871.2265544645701967M$868*M$375:M$3870.83423120040610577N$868*N$375:N$3870.42574495653982419O$868*O$375:O$38702Gas boiler (new)0.964097051999999951.49049311008884122.55346677357962772.1708700290760651.81279448412711771.45840367065600331.11704926139602990.761856542636520810.392030927761861336.5815836363575311E-33Resisitive heating0.642731368000000080.529612262665297370.39726906149468760.337610538737025790.281766626508248070.22649425711881890.173240680476690330.117828262020050586.0132956269759626E-204Oil-fired boiler0.257092547200000020.211844905066118920.158907624597875050.135044215494810330.112706650603299249.059770284752755E-26.929627219067612E-24.7131304808020219E-22.4053182507903833E-205Solid-fuel boiler0.257092547200000020.211844905066118920.158907624597875050.135044215494810330.112706650603299249.059770284752755E-26.929627219067612E-24.7131304808020219E-22.4053182507903833E-206Stirling engine μCHP00000000007Fuel-cell μCHP00000000008Air-source heat pump0000.499609712389464671.00072712486303851.50828907729428052.05094845370411212.61550532394852113.20353839539562293.8173185090873689Ground-source heat pump0000.258418816753171410.517617478377433660.780149522738420861.06083540708833391.35284758135268351.65700261830808131.974475090907259310Geothermal0008.6139605584390471E-31.7253915945914456E-22.60049840912807E-23.5361180236277795E-24.5094919378422783E-25.5233420610269368E-26.5815836363575311E-211Community scale gas CHP000000000012Community scale solid-fuel CHP000000000013INDEX($D$72:$D$84, MATCH($B883, $C$72:$C$84, 0))District heating from power stations0009.4753566142829523E-20.189793075405059050.286054825004087690.388972982599055770.496044113162650570.607567626712962940.72397419999932844Preferences.PowerUnits&"th/degree"GWth/degreeSUM(F871:F883)6.42731368000000016.19348193934452866.08123999585329946.03026802756506626.04029071326100736.07018474110257166.19155497445204796.31767055252099576.44935726661418946.58816521999388893688200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B887, Vectors[Code], 0))Electricity (delivered to end user)SUM(F$871:F$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.64273136800000008SUM(G$871:G$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.52961226266529737SUM(H$871:H$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.3972690614946876SUM(I$871:I$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.58790844991321756SUM(J$871:J$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.78311778682219324SUM(K$871:K$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-0.98212729653886066SUM(L$871:L$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-1.2007389479483312SUM(M$871:M$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-1.4281621146658032SUM(N$871:N$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-1.6650636628913913SUM(O$871:O$883/$M$161:$M$173*($B887=$F$160:$N$160)*($F$161:$N$173))-1.912426490968535146INDEX(Vectors[Description], MATCH($B888, Vectors[Code], 0))Electricity (supplied to grid)SUM(F$871:F$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(G$871:G$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(H$871:H$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(I$871:I$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(J$871:J$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(K$871:K$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(L$871:L$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(M$871:M$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(N$871:N$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))0SUM(O$871:O$883/$M$161:$M$173*($B888=$F$160:$N$160)*($F$161:$N$173))047INDEX(Vectors[Description], MATCH($B889, Vectors[Code], 0))Solid hydrocarbonsSUM(F$871:F$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.29550867494252875SUM(G$871:G$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.24349989088059645SUM(H$871:H$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.18265244206652306SUM(I$871:I$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.15522323620093142SUM(J$871:J$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.12954787425666578SUM(K$871:K$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-0.10413529062934201SUM(L$871:L$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-7.9650887575489798E-2SUM(M$871:M$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-5.4173913572437032E-2SUM(N$871:N$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))-2.7647336215981418E-2SUM(O$871:O$883/$M$161:$M$173*($B889=$F$160:$N$160)*($F$161:$N$173))049INDEX(Vectors[Description], MATCH($B890, Vectors[Code], 0))Liquid hydrocarbonsSUM(F$871:F$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-0.26504386309278355SUM(G$871:G$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-0.21839680934651434SUM(H$871:H$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-0.1638222933998712SUM(I$871:I$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-0.13922084071629931SUM(J$871:J$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-0.11619242330237035SUM(K$871:K$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-9.3399693657244903E-2SUM(L$871:L$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-7.143945586667641E-2SUM(M$871:M$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-4.8588974028886824E-2SUM(N$871:N$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))-2.4797095368973024E-2SUM(O$871:O$883/$M$161:$M$173*($B890=$F$160:$N$160)*($F$161:$N$173))050INDEX(Vectors[Description], MATCH($B891, Vectors[Code], 0))Gaseous hydrocarbonsSUM(F$871:F$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-6.7256317383111632SUM(G$871:G$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-6.5717028803418689SUM(H$871:H$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-6.5069139061036161SUM(I$871:I$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-5.5307069512053202SUM(J$871:J$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-4.6169827807254515SUM(K$871:K$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-3.7126321838313627SUM(L$871:L$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-2.8414141142565956SUM(M$871:M$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-1.9348776240215617SUM(N$871:N$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-0.99099394960996912SUM(O$871:O$883/$M$161:$M$173*($B891=$F$160:$N$160)*($F$161:$N$173))-7.2325094905027814E-3751INDEX(Vectors[Description], MATCH($B892, Vectors[Code], 0))Heat transportSUM(F$871:F$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))0SUM(G$871:G$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))0SUM(H$871:H$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))0SUM(I$871:I$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.10528174015869947SUM(J$871:J$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.21088119489451004SUM(K$871:K$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.31783869444898633SUM(L$871:L$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.43219220288783972SUM(M$871:M$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.55116012573627837SUM(N$871:N$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.67507514079218101SUM(O$871:O$883/$M$161:$M$173*($B892=$F$160:$N$160)*($F$161:$N$173))-0.80441577777703155104INDEX(Vectors[Description], MATCH($B893, Vectors[Code], 0))Environmental heatSUM(F$871:F$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))0SUM(G$871:G$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))0SUM(H$871:H$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))0SUM(I$871:I$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-0.51786468921166662SUM(J$871:J$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-1.0372921675687792SUM(K$871:K$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-1.5633996595435782SUM(L$871:L$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-2.1258869818340727SUM(M$871:M$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-2.711071898983008SUM(N$871:N$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-3.3205908019176835SUM(O$871:O$883/$M$161:$M$173*($B893=$F$160:$N$160)*($F$161:$N$173))-3.95679750474794566INDEX(Vectors[Description], MATCH($B894, Vectors[Code], 0))Heating and coolingSUM(F$871:F$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.4273136800000001SUM(G$871:G$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.1934819393445277SUM(H$871:H$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.0812399958532994SUM(I$871:I$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.0302680275650662SUM(J$871:J$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.0402907132610073SUM(K$871:K$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.0701847411025716SUM(L$871:L$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.1915549744520479SUM(M$871:M$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.3176705525209957SUM(N$871:N$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.4493572666141894SUM(O$871:O$883/$M$161:$M$173*($B894=$F$160:$N$160)*($F$161:$N$173))6.588165219993888934INDEX(Vectors[Description], MATCH($B895, Vectors[Code], 0))Conversion lossesSUM(F$871:F$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))1.5016019643464751SUM(G$871:G$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))1.3697299038897497SUM(H$871:H$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))1.1694177072113974SUM(I$871:I$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))1.0059378798410681SUM(J$871:J$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))0.85372351430896387SUM(K$871:K$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))0.70334807754680351SUM(L$871:L$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))0.55976761591695745SUM(M$871:M$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))0.41036409848697974SUM(N$871:N$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))0.25481072018199014SUM(O$871:O$883/$M$161:$M$173*($B895=$F$160:$N$160)*($F$161:$N$173))9.2707062990126404E-2Preferences.PowerUnits&"/degree"GW/degreeSUM(F887:F895)00008.8817841970012523E-1600005.2735593669694936E-163692Preferences.PowerUnits&"e/degree"GWe/degree-SUM(F887:F888)0.64273136800000008-SUM(G887:G888)0.529612262665297370.39726906149468760.587908449913217560.783117786822193240.982127296538860661.20073894794833121.42816211466580321.66506366289139131.912426490968535193327Preferences.moneyunits&"/yr proceeding 5 years"£m/yr proceeding 5 years332820072010201520202025203020352040204520502649Preferences.moneyunits£mG341*$G293174.61966711964249H341*$G293174.61966711964251174.6196671196424385.16316684785697125.52550000000005825.52549999999999725.52550000000012225.52549999999999725.5254999999999972650£mG342*$G294197.64102.1139999999999938.4315.371999999999998000002651£mG343*$G2956.22674418604651166.22674418604651076.22674418604651166.22674418604650986.22674418604651436.22674418604650986.22674418604650986.22674418604650986.22674418604651432652£mG344*$G2960000000002653£mG345*$G297107.1998400000000146.4062465263157835.87718421052630995.87718421052630995.87718421052630995.87718421052630995.87718421052630995.87718421052632775.87718421052630992654£mG346*$G29819.33290562253980819.33290562253980519.3329056225398081.25663886546508951.25663886546508221.25663886546508951.25663886546508951.25663886546508221.2566388654650895148£mSUM(G903:G908)505.01915692822877SUM(H903:H908)348.6995634545446244.48650113875507113.8957341098948938.88606726203796938.88606726203791238.88606726203803338.88606726203791938.88606726203791233292010201520202025203020352040204520502649Preferences.moneyunits£mG341*$F2931093.8741561352699H341*$F2931093.87415613527011093.8741561352697533.48966245410782159.90000000000038159.89999999999998159.90000000000074159.89999999999998159.899999999999982650£mG342*$F2941146.3119999999999592.26120000000003222.8940000000000189.157600000000002000002651£mG343*$F295124.53488372093025124.53488372093024124.53488372093025124.5348837209302124.5348837209303124.5348837209302124.5348837209302124.5348837209302124.53488372093032652£mG344*$F296770.32558139534865770.32558139534876770.32558139534854770.32558139534854770.32558139534922770.32558139534888770.32558139534819770.32558139534888770.325581395348882653£mG345*$F297318.70485741539329137.9656553811373417.47285402496671817.47285402496671817.47285402496671817.47285402496671817.47285402496671817.47285402496677217.4728540249667182654£mG346*$F298966.64528112699054966.64528112699031966.6452811269905462.83194327325448162.83194327325411262.83194327325448162.83194327325448162.83194327325411262.831943273254481148£mG347*$F29900000000038681801Preferences.moneyunits£m(G336/(G$334-F$334))*INDEX($F$301:$F$304,MATCH($E$9,$C$301:$C$304,0))5832(H336/(H$334-G$334))*INDEX($F$301:$F$304,MATCH($E$9,$C$301:$C$304,0))6206.40000000000056143.2572052406681.25555405789697022.06673460131887380.26271053886387756.73028115460331799Preferences.moneyunits£m(G336/(G$334-F$334))*INDEX($G$301:$G$304,MATCH($E$9,$C$301:$C$304,0))2916(H336/(H$334-G$334))*INDEX($G$301:$G$304,MATCH($E$9,$C$301:$C$304,0))3103.20000000000033071.6286026203340.62777702894853511.03336730065943690.13135526943193878.3651405773016342131832883176Preferences.moneyunits£mSUMPRODUCT(G$434:G$446,$M$308:$M$320)/(G785-F785)8433.0729277296869SUMPRODUCT(H$434:H$446,$M$308:$M$320)/(H785-G785)5401.69186757608535798.24246478866555978.36412726573876130.42363915524586512.97558812759876808.54347979045827913.26719413933289388.90127351382223177Preferences.moneyunits£mSUMPRODUCT(F$398:F$410,$O$308:$O$320)327.00908384830581SUMPRODUCT(G$398:G$410,$O$308:$O$320)339.5152537332919361.30224310702027350.5653837654566335.60455132527323316.60220824556916298.08119484408815276.84685887180456252.67057903197775225.30747019400133184Preferences.moneyunits£mSUM(F927:F928)327.00908384830581SUM(G927:G928)8772.58818146297935762.99411068310566148.80784855412186313.96867859101176447.02584740081516811.05678297168657085.39033866226248165.93777317131039614.208743707822631853176Preferences.moneyunits£mSUMPRODUCT(G$434:G$446,$L$308:$L$320)/(G785-F785)11126.698212633188SUMPRODUCT(H$434:H$446,$L$308:$L$320)/(H785-G785)7123.247069770445714399.80875311777717507.80770851526920710.08416580161124753.22403213291228916.75742339177734490.96772027242740922.7039614464593177Preferences.moneyunits£mSUMPRODUCT(F$398:F$410,$N$308:$N$320)4272.0739636856624SUMPRODUCT(G$398:G$410,$N$308:$N$320)4546.78525818957955001.84265696337664809.18519860911244553.85572671070084238.90835978533233924.6666118405513567.33614286327343163.33870216683772708.84310350943633184Preferences.moneyunits£mSUM(F932:F933)4272.0739636856624SUM(G932:G933)15673.48347082276812125.08972673382219208.9939517268922061.66343522597224948.99252558694228677.89064397346432484.09356625505137654.30642243926643631.54706495589938691801Preferences.moneyunits£mF$472*$L$3220G$472*$L$322/(G902-F902)1300H$472*$L$322/(H902-G902)1973.94897732576653008.8779540797253899.07510597969764657.55815248734785367.21740908951696019.33089863111676629.57928844254377210.7463176544771799Preferences.moneyunits£mF$472*$L$3220G$472*$L$322/(G902-F902)1300H$472*$L$322/(H902-G902)1973.94897732576653008.8779540797253899.07510597969764657.55815248734785367.21740908951696019.33089863111676629.57928844254377210.7463176544776832722Preferences.EnergyUnitsTWh273078418442691692720721722723724725726727273145INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)F976-F960-F961-31.008546529888466G976-G960-27.548650570813557-21.140931858707905-32.600797047013522-44.389760428891933-56.389541226969975-69.461067140672625-83.11636677064017-97.395677128143603-112.34961035870418273246INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)0000000000273347INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbons-14.256803002247571-12.611640109186308-9.5490874446166618-8.1607499217738955-6.8121490629761148-5.4592057429857421-4.1535061076808493-2.8095501635607762-1.4256989302195553049INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-12.787029496861225-11.311471025765041-8.5646454400170065-7.3194354968487527-6.1098656544218759-4.8964010272140159-3.7253096017343701-2.5199058168019333-1.2787196590629050INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-324.47780687796825-340.36956374660576-340.18209217999748-290.77293724876176-242.77955237754452-194.63164520957307-148.16948357078957-100.34600394470483-51.102898404956925-0.37072604754449967751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transport000-5.8792228967333537-11.870072466771134-17.977708169184766-24.516373145225444-31.376079438041629-38.586517313963796-46.1839510461164051315INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic solar thermal0-0.90541995781395357-2.5536295758139533-4.3735066258604656-6.3442298193488371-8.4443432500465114-10.804456931487104-13.383377253162976-16.197285815134933-19.26344572552911104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heat000-26.202616893871827-52.368600663736849-78.53413669723119-106.04289722501655-134.26553049450405-163.24076125264259-193.025810741481916INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and cooling382.53018590696547392.74674541018464381.99038649915298375.30926613086353370.67423047369124366.33298132320527366.87309372260648367.81681388141629369.22755850412432371.19354391937605148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02721Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))046INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))047INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))049INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))050INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))0751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))01315INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic solar thermal104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heatINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))06INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and coolingINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))034INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion lossesINDEX(F$774:F$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(G$774:G$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(H$774:H$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(I$774:I$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(J$774:J$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(K$774:K$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(L$774:L$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(M$774:M$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(N$774:N$782, MATCH([Vector], $B$774:$B$782, 0))0INDEX(O$774:O$782, MATCH([Vector], $B$774:$B$782, 0))0148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02718Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))-31.008546529888466INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))-27.548650570813557INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))-21.140931858707905INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-32.600797047013522INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-44.389760428891933INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-56.389541226969975INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-69.461067140672625INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-83.11636677064017INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-97.395677128143603INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))-112.3496103587041846INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))047INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))-14.256803002247571INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))-12.611640109186308INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))-9.5490874446166618INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-8.1607499217738955INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-6.8121490629761148INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-5.4592057429857421INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-4.1535061076808493INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-2.8095501635607762INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-1.4256989302195553INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))049INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))-12.787029496861225INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))-11.311471025765041INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))-8.5646454400170065INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-7.3194354968487527INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-6.1098656544218759INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-4.8964010272140159INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-3.7253096017343701INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-2.5199058168019333INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-1.2787196590629INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))050INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))-324.47780687796825INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))-340.36956374660576INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))-340.18209217999748INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-290.77293724876176INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-242.77955237754452INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-194.63164520957307INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-148.16948357078957INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-100.34600394470483INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-51.102898404956925INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))-0.37072604754449967751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportINDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-5.8792228967333537INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-11.870072466771134INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-17.977708169184766INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-24.516373145225444INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-31.376079438041629INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-38.586517313963796INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))-46.1839510461164051315INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic solar thermal-F$5930-G$593-0.90541995781395357-2.5536295758139533-4.3735066258604656-6.3442298193488371-8.4443432500465114-10.804456931487104-13.383377253162976-16.197285815134933-19.26344572552911104INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Environmental heatINDEX(F$736:F$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(G$736:G$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(H$736:H$744, MATCH([Vector], $B$736:$B$744, 0))0INDEX(I$736:I$744, MATCH([Vector], $B$736:$B$744, 0))-26.202616893871827INDEX(J$736:J$744, MATCH([Vector], $B$736:$B$744, 0))-52.368600663736849INDEX(K$736:K$744, MATCH([Vector], $B$736:$B$744, 0))-78.53413669723119INDEX(L$736:L$744, MATCH([Vector], $B$736:$B$744, 0))-106.04289722501655INDEX(M$736:M$744, MATCH([Vector], $B$736:$B$744, 0))-134.26553049450405INDEX(N$736:N$744, MATCH([Vector], $B$736:$B$744, 0))-163.24076125264259INDEX(O$736:O$744, MATCH([Vector], $B$736:$B$744, 0))-193.025810741481916INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heating and coolingF$743+F$744+F$593382.53018590696547392.74674541018464381.99038649915298375.30926613086353370.67423047369124366.33298132320527366.87309372260648367.81681388141629369.22755850412432371.19354391937605148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0889272310611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF1012-F100367.291769164453711G1012-G100369.34025263944609267.67578525406571557.84559030389070248.29704596247029338.71775834420454729.4737922586245719.9589826304028910.161728491785426.8213592748187932E-210411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF1013-F10040.136555048823782580.140468534448638660.136773468143603330.116906390262005439.7608530686676367E-27.8248538092932945E-25.9566225576337527E-24.0336530732123836E-22.0536007640052169E-21.3673317177722002E-410421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion0.225131769415215340.220310085386791590.19952452567685050.170535486501148530.142376796612461220.114127442476089238.6866301984324656E-25.8806424007998584E-22.9913594429615283E-21.4706317373905183E-4148SUBTOTAL(109,[2007])67.653455982692705SUBTOTAL(109,[2010])69.701031259281521SUBTOTAL(109,[2015])68.012083247886167SUBTOTAL(109,[2020])58.133032180653856SUBTOTAL(109,[2025])48.53703128976943SUBTOTAL(109,[2030])38.910134324773573SUBTOTAL(109,[2035])29.620224786185233SUBTOTAL(109,[2040])20.05812558514301SUBTOTAL(109,[2045])10.212178093855087SUBTOTAL(109,[2050])6.8497389093704203E-2272410611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF7860G78600000000010411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF787000000000010421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion0000000000148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0272510611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$74867.291769164453711G$74869.34025263944609267.67578525406571557.84559030389070248.29704596247029338.71775834420454729.4737922586245719.9589826304028910.161728491785426.8213592748187932E-210411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$7490.13655504882378258G$7490.140468534448638660.136773468143603330.116906390262005439.7608530686676367E-27.8248538092932945E-25.9566225576337527E-24.0336530732123836E-22.0536007640052169E-21.3673317177722002E-410421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$7500.22513176941521534G$7500.220310085386791590.19952452567685050.170535486501148530.142376796612461220.114127442476089238.6866301984324656E-25.8806424007998584E-22.9913594429615283E-21.4706317373905183E-4148SUBTOTAL(109,[2007])67.653455982692705SUBTOTAL(109,[2010])69.701031259281521SUBTOTAL(109,[2015])68.012083247886167SUBTOTAL(109,[2020])58.133032180653856SUBTOTAL(109,[2025])48.53703128976943SUBTOTAL(109,[2030])38.910134324773573SUBTOTAL(109,[2035])29.620224786185233SUBTOTAL(109,[2040])20.05812558514301SUBTOTAL(109,[2045])10.212178093855087SUBTOTAL(109,[2050])6.8497389093704203E-2261326187826144426916927207217227237247257267272621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of unitsF4640G4640000000003693INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Additional electricity at peakPreferences.PowerUnitsGWF8640G864-4.6668672692417416E-3-2.3369559277034248E-20.117701007604840760.276748250076033990.454670384872181980.660437063084126420.892634719307272671.154027770290131.44754548775325053696INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Temperature related additional electricity demandPreferences.PowerUnitsGWF8980.64273136800000008G8980.529612262665297370.39726906149468760.587908449913217560.783117786822193240.982127296538860661.20073894794833121.42816211466580321.66506366289139131.912426490968535131893330784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C1034,CostVectors[Code], 0))Low estimate of capital costsG909505.01915692822877348.6995634545446244.48650113875507113.8957341098948938.88606726203796938.88606726203791238.88606726203803338.88606726203791938.8860672620379123140INDEX(CostVectors[Description], MATCH(C1035, CostVectors[Code], 0))High estimate of capital costsG91800000000031893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C1043, CostVectors[Code], 0))Low estimate of capital costsF909+F927+F922+F9380G909+G927+G922+G93813154.09208465791610827.54040835639712123.20692000714612851.33496735533113446.86785890463215259.70684150810116377.79381298427118271.86390511334720516.8987990076383133INDEX(CostVectors[Description], MATCH(C1044, CostVectors[Code], 0))Low estimate of operating costsF928327.00908384830581G928339.5152537332919361.30224310702027350.5653837654566335.60455132527323316.60220824556916298.08119484408815276.84685887180456252.67057903197775225.30747019400133135INDEX(CostVectors[Description], MATCH(C1045, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C1046, CostVectors[Code], 0))High estimate of capital costsF918+F932+F921+F9370G918+G932+G921+G93718258.69821263318615303.59604709621323551.88670719750427126.88281449496630607.64231828895936801.69699528032741958.15505662421548500.80971925384155890.180560255543142INDEX(CostVectors[Description], MATCH(C1047, CostVectors[Code], 0))High estimate of operating costsF9334272.0739636856624G9334546.78525818957955001.84265696337664809.18519860911244553.85572671070084238.90835978533233924.6666118405513567.33614286327343163.33870216683772708.84310350943633144INDEX(CostVectors[Description], MATCH(C1048, CostVectors[Code], 0))High estimate of fuel costs