673INDEX(Workstreams[Workstream], MATCH($A1,Workstreams[Code], 0))Electricity distribution, storage, and balancing
792INDEX(Modules[Module], MATCH($A2,Modules[Code], 0))Storage, demand shifting, interconnection3638
1337
|
|
8251336
1439VII.c.Scenario2
|
682
|
366246Preferences.PowerUnits&"e"GWe
|
743418442691692720721722723724725726727
1701878IFERROR(INDEX(INDIRECT($C16&".Outputs["&F$15&"]"), MATCH($N$13, INDIRECT($C16&".Outputs[Vector]"), 0)), 0)*Conversion.to.average.power0.568768199999999951.31201999999999932.81201999999999914.31201999999999865.46401999999999886.0100199999999996.0100199999999996.0100199999999996.0100199999999996.010019999999999
17028790.111445399999999970.470330000000000192.51432999999999975.914005999999999712.3335219.19519999999999324.20999999999999726.99999999999999326.99999999999999326.999999999999993
25602003.4246575342465743E-31.8074581430745799E-24.5186453576864447E-29.0372907153729115E-20.361491628614916460.813356164383560731.73515981735159832.1689497716894963
96315921.9399999999999997E-34.6678417599999994E-32.0166945138172999E-28.7129276680124837E-20.221360100459016770.562386099624347491.04998749572510741.96035026810850543.66001803766164546.8333359879272102
1574159406.0000000000000038E-46.7552734375000041E-31.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-2
|
36983693Preferences.PowerUnits&"e"GWe
|
784184422007201020152020202520302035204020452050
8243699IFERROR(INDEX(INDIRECT($C25&".Info["&F$24&"]"), MATCH($N$22, INDIRECT($C25&".Info[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C25&".Info["&G$24&"]"), MATCH($N$22, INDIRECT($C25&".Info[Vector]"), 0)), 0)-4.6668672692417416E-3-2.3369559277034248E-20.117701007604840760.276748250076033990.454670384872181980.660437063084126420.892634719307272671.154027770290131.4475454877532505
9323700IFERROR(INDEX(INDIRECT($C26&".Info["&F$24&"]"), MATCH($N$22, INDIRECT($C26&".Info[Vector]"), 0)), 0)-1.2474724803837463-1.2815484217113027-1.3142678982647742-1.2407447648485603-1.1599360479496466-1.0657667308057928-0.95363627401321938-0.81992245335713498-0.66161035870166096-0.47601755939638657
|
888832
|
794422007201020152020202520302035204020452050
3718IX.a!F1099.6939082819986311IX.a!G1099.9988372093023248IX.a!H1099.3174219490910009IX.a!I1099.5201582670589993IX.a!J1099.7228945850269977IX.a!K1099.9256309029949978IX.a!L10910.128367220962996IX.a!M10910.331103538930995IX.a!N10910.533839856898993IX.a!O10910.7365761748669953720
|
37013696Preferences.PowerUnits&"e/degree drop in temperature"GWe/degree drop in temperature
|
784184422007201020152020202520302035204020452050
8243699IFERROR(INDEX(INDIRECT($C36&".Info["&F$35&"]"), MATCH($L$33, INDIRECT($C36&".Info[Vector]"), 0)), 0)0.642731368000000080.529612262665297370.39726906149468760.587908449913217560.783117786822193240.982127296538860661.20073894794833121.42816211466580321.66506366289139131.9124264909685351
93237000.20.190755195615075810.17532261993575760.180222760659059790.186946071911421540.194962306487750540.20388655678479140.213443155602592190.223436890963438490.23373085177829089
|
2661Preferences.PowerUnits&"e"GWe
|
794422007201020152020202520302035204020452050
10002554MAX(-INDIRECT(F41&"!T103"),0)*Conversion.to.average.power06.4845332946392885E-15000002.78389769558964067.286509304024233911.7785690888095833720
|
18992620Preferences.PowerUnits&"e"GWe
|
794422007201020152020202520302035204020452050
36671900IFERROR(INDEX(INDIRECT($C47&".Info["&F$15&"]"), MATCH($N$44, INDIRECT($C47&".Info[Vector]"), 0)), 0)30.34366769886848326.90328948460775427.42617300579042429.77168089658439228.01379671905038618.3841428741622475.6327833654901847000
36687184.09999999999999964.056800000000
3669260928.13799999999999828.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.6000
8682610000.850000000000000091.70000000000000024.400000000000000410.09999999999999817.59999999999999825.09999999999999832.640.1
754011107.26.800000000000000710.416.39999999999999921.227.233.20000000000000339.200000000000003
148SUM(F47:F51)73.58166769886847269.09808948460775558.89817300579043355.32668089658439251.42579671905038246.68414287416224845.03278336549018252.365.800000000000011SUM(O47:O51)79.300000000000011
|
26683670839
|
794422007201020152020202520302035204020452050
36671900IFERROR(INDEX(INDIRECT($C57&".Info["&F$15&"]"), MATCH($N$54, INDIRECT($C57&".Info[Vector]"), 0)), 0)0.632000000000000010.70.70.70.70.70.70.70.70.7
36687186.0299999999999999E-20.060.060.060.060.060.060.060.060.06
366926090.606397043144501930.606397043144501930.607685082401161260.610554089709762440.620901068276823010.700000000000000070.900000000000000130.900000000000000130.900000000000000130.90000000000000013
868261000.849999999999999870.849999999999999870.849999999999999870.849999999999999870.849999999999999870.849999999999999870.849999999999999870.849999999999999870.84999999999999987
75400.595999999999999970.60.70.80.80.80.80.80.80.8
|
36773673Preferences.PowerUnits&"e"GWe
|
794422007201020152020202520302035204020452050
36761915IFERROR(INDEX(INDIRECT($C66&".Info["&F$15&"]"), MATCH($N$63, INDIRECT($C66&".Info[Vector]"), 0)), 0)003.3892163187978483E-26.9328284068040757E-21.5435360057151432.93563377373976352.47377259268718672.0403262777840922.05798061274960362.1002132489300136
36751901009.753140485749201E-20.196315735083758990.464316074823804940.698717074806868951.15991874207137151.58328071250065231.85313532027684262.1430252882351253
148SUM(F66:F67)000.131423568045470510.265644019151799752.00785208053894813.63435084854663253.63369133475855843.62360699028474453.911115933026446SUM(O66:O67)4.2432385371651389
|
|
1338
|
1905Preferences.PowerUnitsGW
|
1336804422007201020152020202520302035204020452050
1(Unit.GW)*3.53.53.53.53.53.53.53.53.53.53.5
2(Unit.GW)*3.53.53.53.5(Unit.GW)*3.753.753.753.753.753.753.75(Unit.GW)*44
33.53.53.5(Unit.GW)*3.753.75(Unit.GW)*7777777
43.53.53.5(Unit.GW)*3.753.75(Unit.GW)*77(Unit.GW)*1010(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*2020(Unit.GW)*2020
1280(INDEX(F76:F79,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F76:F79,ROUNDUP($E$8,0))*MOD($E$8,1))3.5(INDEX(G76:G79,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G76:G79,ROUNDUP($E$8,0))*MOD($E$8,1))3.53.53.753.753.753.753.753.754
|
1906Preferences.EnergyUnitsTWh
|
1336804422007201020152020202520302035204020452050
1(Unit.GWh)*272.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-2
2(Unit.GWh)*272.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.03
32.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*353.5000000000000003E-2(Unit.GWh)*800.08(Unit.GWh)*1000.1(Unit.GWh)*1000.1(Unit.GWh)*1000.1(Unit.GWh)*1000.1
42.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*353.5000000000000003E-2(Unit.GWh)*1500.15(Unit.GWh)*3000.3(Unit.GWh)*3500.35000000000000003(Unit.GWh)*4000.4(Unit.GWh)*4000.4
1280(INDEX(F85:F88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F85:F88,ROUNDUP($E$8,0))*MOD($E$8,1))2.7E-2(INDEX(G85:G88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G85:G88,ROUNDUP($E$8,0))*MOD($E$8,1))2.7E-2(INDEX(H85:H88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(H85:H88,ROUNDUP($E$8,0))*MOD($E$8,1))2.7E-2(INDEX(I85:I88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(I85:I88,ROUNDUP($E$8,0))*MOD($E$8,1))2.8000000000000001E-2(INDEX(J85:J88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(J85:J88,ROUNDUP($E$8,0))*MOD($E$8,1))2.8000000000000001E-2(INDEX(K85:K88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(K85:K88,ROUNDUP($E$8,0))*MOD($E$8,1))0.03(INDEX(L85:L88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(L85:L88,ROUNDUP($E$8,0))*MOD($E$8,1))0.03(INDEX(M85:M88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(M85:M88,ROUNDUP($E$8,0))*MOD($E$8,1))0.03(INDEX(N85:N88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(N85:N88,ROUNDUP($E$8,0))*MOD($E$8,1))0.03(INDEX(O85:O88,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(O85:O88,ROUNDUP($E$8,0))*MOD($E$8,1))0.03
|
1907Preferences.PowerUnitsGW
|
1336804422007201020152020202520302035204020452050
1(Unit.GW)*2.52.52.5(Unit.GW)*444444444
22.52.5(Unit.GW)*44(Unit.GW)*66(Unit.GW)*88(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*1010
32.52.5(Unit.GW)*44(Unit.GW)*66(Unit.GW)*1010(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*1515
42.52.5(Unit.GW)*44(Unit.GW)*99(Unit.GW)*1515(Unit.GW)*2525(Unit.GW)*3030(Unit.GW)*3030(Unit.GW)*3030(Unit.GW)*3030
1280(INDEX(F94:F97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F94:F97,ROUNDUP($E$8,0))*MOD($E$8,1))2.5(INDEX(G94:G97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G94:G97,ROUNDUP($E$8,0))*MOD($E$8,1))2.5(INDEX(H94:H97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(H94:H97,ROUNDUP($E$8,0))*MOD($E$8,1))4(INDEX(I94:I97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(I94:I97,ROUNDUP($E$8,0))*MOD($E$8,1))6(INDEX(J94:J97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(J94:J97,ROUNDUP($E$8,0))*MOD($E$8,1))8(INDEX(K94:K97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(K94:K97,ROUNDUP($E$8,0))*MOD($E$8,1))10(INDEX(L94:L97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(L94:L97,ROUNDUP($E$8,0))*MOD($E$8,1))10(INDEX(M94:M97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(M94:M97,ROUNDUP($E$8,0))*MOD($E$8,1))10(INDEX(N94:N97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(N94:N97,ROUNDUP($E$8,0))*MOD($E$8,1))10(INDEX(O94:O97,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(O94:O97,ROUNDUP($E$8,0))*MOD($E$8,1))10
|
19081910
|
1336804421909
10.75
20.75
30.75
40.75
1280(INDEX(F103:F106,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F103:F106,ROUNDUP($E$8,0))*MOD($E$8,1))0.75
|
19121911
|
13367944213551864
100
233%*75%0.247533%*90%0.29700000000000004
366%*75%0.49566%*90%0.59400000000000008
475%0.7590%0.9
1280(INDEX(G112:G115,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G112:G115,ROUNDUP($E$8,0))*MOD($E$8,1))0.2475(INDEX(H112:H115,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(H112:H115,ROUNDUP($E$8,0))*MOD($E$8,1))0.29700000000000004
|
784
|
974Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
46168109('DUKES 09 (5.6)'!$K$248-'DUKES 09 (5.6)'!$M$249)*Unit.GWh-1.22549999999999960000000002441
|
1902
|
41844212501249
190352555
190412556
2660-1.4827
878-0.832667
879-0.852667
2-0.432667
1592-0.82667
1593-0.82667
1594F132-0.832667
|
2674
|
41844212501249
26631428-0.16152675
521428-0.12652675
2676F143/F1420.783281733746129972677
|
14282678
|
1971
|
41844212501249
191311972
12550.41976
19771978
|
1172679
1182680
|
2669
|
794422007201020152020202520302035204020452050
74019000.9$F161+(((G$160-$F$160)/($O$160-$F$160))*($O161-$F161))0.9$F161+(((H$160-$F$160)/($O$160-$F$160))*($O161-$F161))0.90.90.90.90.90.90.90.9
7407180.8$F162+(((G$160-$F$160)/($O$160-$F$160))*($O162-$F162))0.806976744186046590.818604651162790690.830232558139534890.84186046511627910.853488372093023310.865116279069767510.876744186046511720.888372093023255820.9
74026090.9$F163+(((G$160-$F$160)/($O$160-$F$160))*($O163-$F163))0.90.90.90.90.90.90.90.90.9
86826100.50.630.770.90.90.90.90.9
75400.75$F165+(((G$160-$F$160)/($O$160-$F$160))*($O165-$F165))0.760465116279069760.777906976744186070.795348837209302270.812790697674418580.830232558139534890.84767441860465120.865116279069767510.882558139534883710.9
|
1092671
|
|
3170
|
3432
343332413434145
3433324134351.2988
3358324134341450
3358324134351614.7908
|
3436
3433324134370.29799999999999999
335832413437150
|
33583357
34381801179918011799
3439F176*(MGBP/Unit.GW)*Price20002091.4811936586884F175*(MGBP/Unit.GW)*Price20001878.0437260387525F173*(MGBP/Unit.GW)*Price2000187.80437260387527F174*(MGBP/Unit.GW)*Price20001.6822090975028494
3440150%*F180*(MGBP/Unit.GW)*Price2000291.4205781784270950%*F180*(MGBP/Unit.GW)*Price200097.140192726142374150%*F179*(MGBP/Unit.GW)*Price20000.5789555486478085250%*F179*(MGBP/Unit.GW)*Price20000.19298518288260283
3442I.a!F126/plantsize.I.a864.3I.a!G126/plantsize.I.a403.20574162679429I.a!F127/plantsize.I.a39.024999999999999I.a!G127/plantsize.I.a0.6216972334473112
|
812
|
2670Preferences.PowerUnits&"_e"GW_e
|
1336794422007201020152020202520302035204020452050
7401900MAX(F161-F57,0)*F478.13210294329675425.38065789692155245.4852346011580875.95433617931688015.60275934381007893.67682857483245051.1265566730980372000
740718MAX(F162-F58,0)*F483.03276999999999973.03033525581395400000000
7402609MAX(F163-F59,0)*F498.26140000000000548.26140000000000546.84660000000000144.93650000000000322.40360000000000040.359999999999999880000
8682610MAX(F164-F60,0)*F50000000.505000000000001450.880000000000002671.25500000000000391.63000000000000522.0050000000000061
7540MAX(F165-F61,0)*F511.69400000000000041.60465116279069790.5609302325581401200.13302325581395280.495813953488371481.01069767441860451.7711627906976752.74093023255813823.9199999999999995
148SUM(F194:F198)21.120272943296758SUM(G194:G198)18.27704431552621112.8927648337162310.8908361793168838.13938259962403175.03764252832082353.01725434751664423.02616279069767914.37093023255814295.925000000000006
|
731
11919
21943
31916
41917
51921
61918
71975
11920
1939Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
2557F420G426.4845332946392885E-15000002.78389769558964067.286509304024233911.778569088809583
1953F19921.120272943296758G19918.27704431552621112.8927648337162310.8908361793168838.13938259962403175.03764252832082353.01725434751664423.02616279069767914.37093023255814295.925000000000006
1954F982.5G982.5H984681010101010
1955($G$116*F67)+($H$116*F66)0($G$116*G67)+($H$116*G66)03.420499516905888E-26.9178644801438455E-20.573348422216289231.044815706815411.02179034869075910.997838880845786981.06987123375515081.1541620937704078
1956F803.5G803.53.53.753.753.753.753.753.754
1945SUM(F216:F220)27.120272943296758SUM(G216:G220)24.27704431552621920.42696982888528720.71001482411832520.4627310218403219.83245823513623317.78904469620740520.55789936713310726.47731077033752832.857731182579997
|
1940Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
2557F216*Conversion.to.energy.per.second*$F$129*Unit.day07.7814399535671445E-16000000.334067723470756860.874381116482908061.4134282906571498
1953F217*Conversion.to.energy.per.second*$F$129*Unit.day2.5344327531956112.19324531786314521.54713178004594761.30690034151802580.976725911954883790.604517103398498730.362070521701997330.363139534883721420.524511627906977140.71100000000000063
1954F218*$F$107*Conversion.to.energy.per.second*$F$129*Unit.day0.224999999999999950.224999999999999950.360000000000000040.539999999999999920.720000000000000080.89999999999999980.89999999999999980.89999999999999980.89999999999999980.8999999999999998
1955F219*Conversion.to.energy.per.second*$F$129*Unit.day004.1045994202870651E-38.3014373761726139E-36.8801810665954699E-20.12537788481784920.122614841842891090.119740665701494430.128384548050618110.13849945125244892
1956F892.7E-2G892.7E-22.7E-22.8000000000000001E-22.8000000000000001E-20.030.030.030.030.03
1946SUM(F226:F230)2.7864327531956112SUM(G226:G230)2.44524531786314641.93823637946623471.88320177889419821.79352772262083861.65989498821634781.41468536354488841.74694792405597242.45727729244050333.1929277419095992
|
21944
3703Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
C25IX.aD25Residential Heating & CoolingF250-4.6668672692417416E-3-2.3369559277034248E-20.117701007604840760.276748250076033990.454670384872181980.660437063084126420.892634719307272671.154027770290131.4475454877532505
C26IX.cD26Commercial Heating & CoolingF26-1.2474724803837463-1.2815484217113027-1.3142678982647742-1.2407447648485603-1.1599360479496466-1.0657667308057928-0.95363627401321938-0.81992245335713498-0.66161035870166096-0.47601755939638657
3702SUM(F238:F239)-1.2474724803837463SUM(G238:G239)-1.2862152889805445-1.3376374575418084-1.1230437572437195-0.88318779787361257-0.61109634593361073-0.293199210929092967.2712265950137689E-20.492417411588469080.97152792835686397
|
3705827
|
4184422007201020152020202520302035204020452050
3719F319.6939082819986311G319.99883720930232489.31742194909100099.52015826705899939.72289458502699779.925630902994997810.12836722096299610.33110353893099510.53383985689899310.736576174866995
3706$F$131-1.4$F$131-1.4-1.4-1.4-1.4-1.4-1.4-1.4-1.4-1.4
3707-(F246-F245)11.093908281998631-(G246-G245)11.39883720930232510.71742194909100110.92015826705911.12289458502699811.32563090299499811.52836722096299711.73110353893099511.93383985689899312.136576174866995
|
3704Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
C36IX.aD36Residential Heating & CoolingF36*F$2477.1304028465555112G36*G$2476.03696396617198874.2577001593579486.42005331959366478.710536590482899311.12321126035545213.84255952846113616.75391763752317719.87060310448751523.210309786473214
C37IX.cD37Commercial Heating & CoolingF37*F$2472.21878165639972652.174387421644871.87900649507162811.96806106972322732.07938145095561832.20807112327684952.35047909803279962.50392375805016832.66646007488107672.8366922870237743
3702SUM(F252:F253)9.3491845029552376SUM(G252:G253)8.2113513878168582SUM(H252:H253)6.1367066544295756SUM(I252:I253)8.3881143893168915SUM(J252:J253)10.789918041438519SUM(K252:K253)13.331282383632303SUM(L252:L253)16.193038626493937SUM(M252:M253)19.257841395573344SUM(N252:N253)22.537063179368591SUM(O252:O253)26.047002073496987
|
|
1947Preferences.PowerUnits&"e"GWe
|
7434184422007201020152020202520302035204020452050
67629-F240-F254-8.1017120225714905-G240-G254-6.9251360988363135-4.7990691968877677-7.2650706320731722-9.9067302435649065-12.720186037698692-15.899839415564845-19.330553661523481-23.029480590957061-27.018530001853851
1701878$F$132*F16-0.47207760599999993$F$132*G16-1.0889765999999994-2.3339765999999993-3.5789765999999985-4.5351365999999986-4.9883165999999992-4.9883165999999992-4.9883165999999992-4.9883165999999992-4.9883165999999992
1702879$F$133*F17-9.4728589999999974E-2$F$133*G17-0.39978050000000015-2.1371804999999999-5.0269050999999996-10.483492-16.315919999999995-20.578499999999998-22.949999999999992-22.949999999999992-22.949999999999992
25602$F$134*F180$F$134*G180-1.4726027397260269E-3-7.7720700152206935E-3-1.9430175038051712E-2-3.8860350076103521E-2-0.15544140030441408-0.34974315068493111-0.7461187214611873-0.93264840182648345
9631592$F$135*F19-1.5519999999999998E-3$F$135*G19-3.7342734079999999E-3-1.6133556110538402E-2-6.9703421344099875E-2-0.17708808036721344-0.44990887969947801-0.839989996580086-1.5682802144868044-2.9280144301293163-5.4666687903417683
15741594$F$137*F200$F$137*G20-4.9800000000000029E-4-5.6068769531250028E-3-1.264920000000001E-2-1.264920000000001E-2-1.264920000000001E-2-1.264920000000001E-2-1.264920000000001E-2-1.264920000000001E-2-1.264920000000001E-2
1948SUM(F260:F265)-8.6700702185714906SUM(G260:G265)-8.4181254722443128-9.2934393326911575-15.961077023432491-25.134526298970172-34.525841067474275-42.474736612449341-49.199542826695208-54.654579542547559-61.368812994022093
|
1949Preferences.EnergyUnits&"e"TWhe
|
7434184422007201020152020202520302035204020452050
67629F260*Conversion.to.energy.per.second*$F$129*Unit.day-0.97220544270857878-0.8310163318603575-0.57588830362653209-0.87180847584878074-1.1888076292277887-1.5264223245238431-1.9079807298677816-2.3196664393828175-2.7635376709148467-3.2422236002224616
1701878-5.664931271999999E-2-0.13067719199999991-0.28007719199999992-0.42947719199999979-0.54421639199999983-0.59859799199999986-0.59859799199999986-0.59859799199999986-0.59859799199999986-0.59859799199999986
1702879F262*Conversion.to.energy.per.second*$F$129*Unit.day-1.1367430799999996E-2-4.7973660000000015E-2H262*Conversion.to.energy.per.second*$F$129*Unit.day-0.25646165999999998-0.603228612-1.25801904-1.9579103999999989-2.4694199999999995-2.7539999999999991-2.7539999999999991-2.7539999999999991
25602F263*Conversion.to.energy.per.second*$F$129*Unit.day0G263*Conversion.to.energy.per.second*$F$129*Unit.day0-1.7671232876712321E-4-9.3264840182648323E-4-2.3316210045662049E-3-4.663242009132422E-3-1.8652968036529688E-2-4.1969178082191735E-2-8.9534246575342466E-2-0.11191780821917802
9631592F264*Conversion.to.energy.per.second*$F$129*Unit.day-1.8623999999999998E-4G264*Conversion.to.energy.per.second*$F$129*Unit.day-4.4811280895999997E-4-1.9360267332646081E-3-8.3644105612919843E-3-2.125056964406561E-2-5.3989065563937351E-2-0.10079879958961031-0.1881936257384165-0.35136173161551798-0.65600025484101221
15741594F265*Conversion.to.energy.per.second*$F$129*Unit.day0G265*Conversion.to.energy.per.second*$F$129*Unit.day-5.9760000000000024E-5-6.7282523437500036E-4-1.5179040000000009E-3-1.5179040000000009E-3-1.5179040000000009E-3-1.5179040000000009E-3-1.5179040000000009E-3-1.5179040000000009E-3-1.5179040000000009E-3
1948SUM(F271:F276)-1.0404084262285787SUM(G271:G276)-1.0101750566693175-1.1152127199229387-1.9153292428118986-3.0161431558764202-4.1431009280969118-5.0969683934939205-5.9039451392034241-6.5585495451057065-7.3642575592826507
|
31950
|
1951Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
1952F266-8.6700702185714906G266-8.4181254722443128-9.2934393326911575-15.961077023432491-25.134526298970172-34.525841067474275-42.474736612449341-49.199542826695208-54.654579542547559-61.368812994022093
2558F284+F310-8.6700702185714906G284+G310-8.4181254722443057-9.2934393326911575-15.961077023432491-25.134526298970172-34.525841067474275-42.474736612449341-46.415645131105563-47.368070238523323-49.59024390521251
"…after "&D217…after boosting thermal plantF285+F311000-5.0702408441156077-16.995143699346141-29.488198539153451-39.457482264932693-43.389482340407881-42.997140005965178-43.665243905212506
"…after "&D218…after drawing from interconnectionF286+F3120000-8.9951436993461407-19.488198539153451-29.457482264932693-33.389482340407881-32.997140005965178-33.665243905212506
"…after "&D219…after shifting demand from electric vehiclesF287+F3130000-8.421795277129851-18.443382832338042-28.435691916241936-32.391643459562097-31.927268772210027-32.511081811442097
"…after "&D220…after drawing from pumped storageF288+F3140000-4.671795277129851-14.693382832338042-24.685691916241936-28.641643459562097-28.177268772210027-28.511081811442097
1957F2890G289000-4.671795277129851-14.693382832338042-24.685691916241936-28.641643459562097-28.177268772210027-28.511081811442097
|
41959
|
1958Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
1952F277-1.0404084262285787G277-1.0101750566693175-1.1152127199229387-1.9153292428118986-3.0161431558764202-4.1431009280969118-5.0969683934939205-5.9039451392034241-6.5585495451057065-7.3642575592826507
2558F297+F320-1.0404084262285787-1.0101750566693166-1.1152127199229387-1.9153292428118986-3.0161431558764202-4.1431009280969118-5.0969683934939205-5.5698774157326669-5.6841684286227983-5.9508292686255011
"…after "&D227…after boosting thermal plant000-0.60842890129387284-2.0394172439215366-3.5385838246984131-4.7348978717919232-5.2067378808489453-5.1596568007158208-5.2398292686255008
"…after "&D228…after drawing from interconnection000-6.8428901293872912E-2-1.3194172439215364-2.6385838246984132-3.8348978717919233-4.3067378808489458-4.2596568007158213-4.3398292686255013
"…after "&D229…after shifting demand from electric vehicles000-6.0127463917700297E-2-1.2506154332555817-2.5132059398805642-3.7122830299490324-4.1869972151474517-4.1312722526652035-4.2013298173730522
"…after "&D230…after drawing from pumped storage000-3.21274639177003E-2-1.2226154332555816-2.4832059398805644-3.6822830299490326-4.1569972151474515-4.1012722526652032-4.171329817373052
1966F302000-3.21274639177003E-2-1.2226154332555816-2.4832059398805644-3.6822830299490326-4.1569972151474515-4.1012722526652032-4.171329817373052
|
51964
|
1960Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
2557MIN(ABS(F284),F216)06.4845332946392885E-15000002.78389769558964067.286509304024233911.778569088809583
1953MIN(ABS(F285),F217)8.67007021857149068.41812547224430579.293439332691157510.8908361793168838.13938259962403175.03764252832082353.01725434751664423.02616279069767914.37093023255814295.925000000000006
1954MIN(ABS(F286),F218)0005.070240844115607781010101010
1955MIN(ABS(F287),F219)00000.573348422216289231.044815706815411.02179034869075910.997838880845786981.06987123375515081.1541620937704078
1956MIN(ABS(F288),F220)00003.753.753.753.753.754
1962SUM(F310:F314)8.6700702185714906SUM(G310:G314)8.41812547224431289.293439332691157515.96107702343249120.4627310218403219.83245823513623317.78904469620740520.55789936713310726.47731077033752832.857731182579997
|
1961Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
2557MIN(ABS(F297),F226)07.7814399535671445E-16000000.334067723470756860.874381116482908061.4134282906571498
1953MIN(ABS(F298),F227)1.04040842622857871.01017505666931661.11521271992293871.30690034151802580.976725911954883790.604517103398498730.362070521701997330.363139534883721420.524511627906977140.71100000000000063
1954MIN(ABS(F299),F228)0000.539999999999999920.720000000000000080.89999999999999980.89999999999999980.89999999999999980.89999999999999980.8999999999999998
1955MIN(ABS(F300),F229)0008.3014373761726139E-36.8801810665954699E-20.12537788481784920.122614841842891090.119740665701494430.128384548050618110.13849945125244892
1956MIN(ABS(F301),F230)0002.8000000000000001E-22.8000000000000001E-20.030.030.030.030.03
1963SUM(F320:F324)1.0404084262285787SUM(G320:G324)1.01017505666931751.11521271992293871.88320177889419821.79352772262083861.65989498821634781.41468536354488841.74694792405597242.45727729244050333.1929277419095992
|
19601965
|
4184422007201020152020202520302035204020452050
2557IF(F216=0,0,F310/F216)0100000111
1953IF(F217=0,0,F311/F217)0.410509383181207170.460584617891043320.720825940172865391111111
1954IF(F218=0,0,F312/F218)0000.84504014068593458111111
1955IF(F219=0,0,F313/F219)0000111111
1956IF(F220=0,0,F314/F220)0000111111
1962IF(F221=0,0,F315/F221)0.31968963722079530.346752486127833880.454959272498142550.77069365517037924111111
|
19611965
|
4184422007201020152020202520302035204020452050
2557IF(F226=0,0,F320/F226)0100000111
1953IF(F227=0,0,F321/F227)0.410509383181207050.460584617891043320.720825940172865161111111
1954IF(F228=0,0,F322/F228)0001111111
1955IF(F229=0,0,F323/F229)0001111111
1956IF(F230=0,0,F324/F230)0001111111
1963IF(F231=0,0,F325/F231)0.373383647976212480.413118082382053330.575374980955652981111111
|
19861965
|
4184422007201020152020202520302035204020452050
2557MAX(F340,F330)0MAX(G340,G330)100000111
1953MAX(F341,F331)0.410509383181207170.460584617891043320.720825940172865391111111
1954MAX(F342,F332)0001111111
19550001111111
19560001111111
19850.373383647976212480.413118082382053330.575374980955652981111111
|
61973
|
19672007201020152020202520302035204020452050
1968Preferences.EnergyUnits&"e"TWheF303000-3.21274639177003E-2-1.2226154332555816-2.4832059398805644-3.6822830299490326-4.1569972151474515-4.1012722526652032-4.171329817373052
14191969Preferences.PowerUnits&"e"GWeF360/(Conversion.to.energy.per.second*$F$129*Unit.day)000-0.2677288659808359-10.188461943796515-20.693382832338038-30.685691916241943-34.641643459562104-34.177268772210034-34.761081811442104
14201952Preferences.PowerUnits&"e"GWeF2900000-4.671795277129851-14.693382832338042-24.685691916241936-28.641643459562097-28.177268772210027-28.511081811442097
1970Preferences.PowerUnits&"e"GWeMIN(F361:F362)0MIN(G361:G362)00-0.2677288659808359-10.188461943796515-20.693382832338038-30.685691916241943-34.641643459562104-34.177268772210034-34.761081811442104
1974Preferences.PowerUnits&"capacity"GWcapacity-F363/$F$1510-G363/$F$151000.267728865980835910.18846194379651520.69338283233803830.68569191624194334.64164345956210434.17726877221003434.761081811442104
|
71983
|
1979INDIRECT("EF."&$F$153&".CO2")+INDIRECT("EF."&$F$153&".CH4")+INDIRECT("EF."&$F$153&".N2O")0.18476551498713398"MtCO2e/"&Preferences.EnergyUnits&"th"MtCO2e/TWhth
|
19672007201020152020202520302035204020452050
1968Preferences.EnergyUnits&"e"TWheF3030G30300-3.21274639177003E-2-1.2226154332555816-2.4832059398805644-3.6822830299490326-4.1569972151474515-4.1012722526652032-4.171329817373052
1980Preferences.EnergyUnits&"th"TWhthF371/$F$1520G371/$F$15200-8.0318659794250749E-2-3.0565385831389538-6.2080148497014109-9.2057075748725801-10.392493037868627-10.253180631663007-10.428324543432629
19811982$E$368*-F3720$E$368*-G372001.4840118539961152E-20.564742925391713671.14702706075285631.70089730089229251.92017432814200141.89443419966532311.9267947547202984
|
19841982F373*$F$1300001.4840118539961152E-20.564742925391713671.14702706075285631.70089730089229251.92017432814200141.89443419966532311.9267947547202984
|
3441
3646
168Preferences.PowerUnitsGWF803.5G803.53.53.753.753.753.753.753.754
3440Preferences.PowerUnitsGWF982.5G982.54681010101010
3443Preferences.PowerUnitsGWF3640G364000.267728865980835910.18846194379651520.69338283233803830.68569191624194334.64164345956210434.17726877221003434.761081811442104
|
3444
168Preferences.PowerUnitsGW(INDEX($F$76:$O$79,MATCH($E$8,$C$76:$C$79,0),MATCH(G$370,$F$75:$O$75,0))-INDEX($F$76:$O$79,MATCH($E$8,$C$76:$C$79,0),MATCH(F$370,$F$75:$O$75,0)))/(G$370-F$370)000.05000000.05
3440Preferences.PowerUnitsGW(INDEX($F$94:$O$97,MATCH($E$8,$C$94:$C$97,0),MATCH(G$370,$F$93:$O$93,0))-INDEX($F$94:$O$97,MATCH($E$8,$C$94:$C$97,0),MATCH(F$370,$F$93:$O$93,0)))/(G$370-F$370)00.30.40.40.40000
3443Preferences.PowerUnitsGWMAX((G405-F405)/(G370-F370),0)0MAX((H405-G405)/(H370-G370),0)05.3545773196167178E-21.9841466155631362.10098417770830451.99846181678078110.7911903086640321700.11676260784641386
|
1799
3312Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$384:F$386,$F$184:$F$186)0SUMPRODUCT(G$384:G$386,$F$184:$F$186)029.142057817842712154.3482265849353838.87538471488506885.98496060949446805.79127894792555319.012475172813370140.98154019292949
3313Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$379:F$381,$H$184:$H$186)6.3701947984664802SUMPRODUCT(G$379:G$381,$H$184:$H$186)6.37019479846648026.65967257279038457.632641508225574114.18630418223801521.10315480199235727.31534571520585129.77474984533961729.48604938692987430.269556612646632
3314Preferences.moneyunits&"/yr"£m/yrSUM(F389:F390)6.3701947984664802SUM(G389:G390)6.370194798466480235.801730390633097161.98086809316086853.06168889712308907.0881154114868833.10662466313136348.7872250181529829.486049386929874171.25109680557611
|
1801
3312Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$384:F$386,$E$184:$E$186)0SUMPRODUCT(G$384:G$386,$E$184:$E$186)087.426173453528122267.421902727752581831.46615110258931932.44885606465851727.270548243629683.825783778322940205.49198164458994
3313Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$379:F$381,$G$184:$G$186)658.76269298518298SUMPRODUCT(G$379:G$381,$G$184:$G$186)658.76269298518298659.63112630815465718.188249551321181106.50276901037361517.61521778300221907.56507978235192061.94608876042142043.82386658650692113.558263593507
3314Preferences.moneyunits&"/yr"£m/yrSUM(F394:F395)658.76269298518298SUM(G394:G395)658.76269298518298SUM(H394:H395)747.05729976168277SUM(I394:I395)985.61015227907376SUM(J394:J395)2937.9689201129631SUM(K394:K395)3450.0640738476604SUM(L394:L395)3634.8356280259809SUM(M394:M395)2745.7718725387444SUM(N394:N395)2043.8238665865069SUM(O394:O395)2319.050245238097
|
2613
|
2618
|
782614442691692720721722723724725726727
2615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0F3640000.267728865980835910.18846194379651520.69338283233803830.68569191624194334.64164345956210434.17726877221003434.761081811442104
26212891F404/Unit.GW0000.267728865980835910.18846194379651520.69338283233803830.68569191624194334.64164345956210434.17726877221003434.761081811442104
2662INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Sea area839F3540G354001111111
3732INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Interconnector capacityPreferences.PowerUnitsGWF982.5G982.54681010101010
|
|
889
|
10581061
|
10571027442691692720721722723724725726727
10401050INDIRECT("EF."&$F$153&"."&$C415)*-F$372*$F$1300001.4778633402142135E-20.562403099297567381.14227473234505951.69385019377655441.9122187189678271.88658523622599291.9188117159916034
104110500002.9623559443163064E-51.1273289748594574E-32.2896733759660251E-33.3952985054680257E-33.8330150933618612E-33.7816331435512681E-33.8462306616710473E-3
104210500003.1861578375854112E-51.2124971192867789E-32.4626550318309235E-33.6518086102700605E-34.1225940808124802E-34.0673302957789691E-34.1368080670241125E-3
148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])1.4840118539961152E-2SUBTOTAL(109,[2025])0.56474292539171356SUBTOTAL(109,[2030])1.1470270607528565SUBTOTAL(109,[2035])1.7008973008922925SUBTOTAL(109,[2040])1.9201743281420014SUBTOTAL(109,[2045])1.8944341996653231SUBTOTAL(109,[2050])1.9267947547202986
|
|
3189
|
3190
|
78418442691692720721722723724725726727
3131INDEX(CostVectors[Description], MATCH(C426,CostVectors[Code], 0))Low estimate of capital costsF3890G3890H38929.142057817842712154.3482265849353838.87538471488506885.98496060949446805.79127894792555319.012475172813370140.98154019292949
3133INDEX(CostVectors[Description], MATCH(C427, CostVectors[Code], 0))Low estimate of operating costs6.37019479846648026.37019479846648026.65967257279038457.632641508225574114.18630418223801521.10315480199235727.31534571520585129.77474984533961729.48604938692987430.269556612646632
3135INDEX(CostVectors[Description], MATCH(C428, CostVectors[Code], 0))Low estimate of fuel costs
3140INDEX(CostVectors[Description], MATCH(C429, CostVectors[Code], 0))High estimate of capital costsF3940G394087.426173453528122267.421902727752581831.46615110258931932.44885606465851727.270548243629683.825783778322940205.49198164458994
3142INDEX(CostVectors[Description], MATCH(C430, CostVectors[Code], 0))High estimate of operating costsF395658.76269298518298658.76269298518298659.63112630815465718.188249551321181106.50276901037361517.61521778300221907.56507978235192061.94608876042142043.82386658650692113.558263593507
3144INDEX(CostVectors[Description], MATCH(C431, CostVectors[Code], 0))High estimate of fuel costs
|
|
|