74INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Hydrocarbon fuel power generation
740INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Biomass/Coal power stations3639
|
1341
|
8251336
1336I.a.scenario1
|
682
|
745Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
45INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.55512401053005INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.91515826061539INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-366.33806231663755INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-397.94664348603783INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-449.38167849223646INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-501.94726834166431INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-547.61520198951655INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-608.78355692995581INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-679.53514658109339INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-757.46235805518597
46INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))39.720546221022559INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))45.73729964184956INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))73.277348318506398INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))123.98129716841669INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))230.60986386479951INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))378.09333083722993INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))508.31767670219568INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))633.1872041294946INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))743.40868714017006INDEX(INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&I.a.Inputs[#Headers]&"'!Year.Vectors"), 0))860.71329468769068
|
1338
|
2597
|
1336794422007201020152020202520302035204020452050
1(Unit.GW)*0.60.60.60.60.60.60.60.60.60.60.6
2(Unit.GW)*0.60.60.6(Unit.GW)*1.51.5(Unit.GW)*2.42.4(Unit.GW)*3.33.3(Unit.GW)*4.24.2(Unit.GW)*5.15.0999999999999996(Unit.GW)*66(Unit.GW)*6.96.9(Unit.GW)*7.87.8
30.60.6(Unit.GW)*2.12.1(Unit.GW)*3.63.6(Unit.GW)*5.15.0999999999999996(Unit.GW)*6.66.6(Unit.GW)*8.18.1(Unit.GW)*9.69.6(Unit.GW)*11.111.1(Unit.GW)*12.612.6
40.60.6(Unit.GW)*3.353.35(Unit.GW)*6.16.1(Unit.GW)*8.858.85(Unit.GW)*11.611.6(Unit.GW)*14.3514.35(Unit.GW)*17.117.100000000000001(Unit.GW)*19.8519.850000000000001(Unit.GW)*22.622.6
1280(INDEX(F$24:F$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$24:F$27,ROUNDUP($E$7,0))*MOD($E$7,1))0.6(INDEX(G$24:G$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$24:G$27,ROUNDUP($E$7,0))*MOD($E$7,1))0.60.60.60.60.60.60.60.60.6
|
2600
|
1336794422007201020152020202520302035204020452050
10000000000
200(Unit.GW)*-0.5-0.5-0.5-0.5-0.5-0.5-0.5-0.5-0.5
300(Unit.GW)*-0.5-0.5(Unit.GW)*-1-1-1-1-1-1-1-1
400(Unit.GW)*-0.5-0.5(Unit.GW)*-1-1(Unit.GW)*-2-2-2-2-2-2-2
1280(INDEX(F$33:F$36,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$33:F$36,ROUNDUP($E$7,0))*MOD($E$7,1))0(INDEX(G$33:G$36,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$33:G$36,ROUNDUP($E$7,0))*MOD($E$7,1))000000000
|
717
1092598
1172599
2601
|
784
|
1780
|
715730442691692720721722723724725726727
472602'2007 (Actual, frozen)'!$AZ$88/'2007 (Actual, frozen)'!$U$885.3497576519792589E-20.050.050.050.050.050.050.050.050.05
49718'2007 (Actual, frozen)'!$AZ$89/'2007 (Actual, frozen)'!$U$890.202811615464494550.20.20.20.20.20.20.20.20.2
50737'2007 (Actual, frozen)'!$AZ$90/'2007 (Actual, frozen)'!$U$901.9761196093076236E-20.020.020.020.020.020.020.020.020.02
|
728
|
715730442691692720721722723724725726727
4726020.356999999999999980.350.350.350.350.350.350.350.350.35
497181090.275000000000000020.30.30.30.30.30.30.30.30.3
505671170.488999999999999990.50.50.50.50.50.50.50.50.5
|
771
|
715730442691692720721722723724725726727
497186.0299999999999999E-20.060.060.060.060.060.060.060.060.06
507370.632000000000000010.70.70.70.70.70.70.70.70.7
|
2603
|
1410.6
25370.9
|
2607
|
730442691692720721722723724725726727
14111828.137999999999998F7628.13799999999999822.82199999999999916.4550000000000028.01200000000000051.20000
7181184.09999999999999964.056800000000
|
869
|
730442691692720721722723724725726727
870440'2007 (Actual, frozen)'!$U$88/'2007 (Actual, frozen)'!$U$900.859927123817409880.859927123817409880.859927123817409880.859927123817409880.859927123817409880.859927123817409880.859927123817409880.859927123817409880.859927123817409880.85992712381740988
|
2738
|
85
28122*Unit.GW2Preferences.PowerUnits&"peak"GWpeak
|
755
717
109811
117742
1182241
2606
2612
440871
|
|
3170
18011799
3774343337743433
3361377533613775
2029204050016
1413014.788949.3650000000000118
14864.339.024999999999999403.205741626794290.6216972334473112
3777321085.4833695990052861053.190468.8
|
"Cost of a "&$F$87/Unit.GW&" GW plant"Cost of a 2 GW plant
|
3803Preferences.moneyunits&"/ 2 GW capacity"£m/ 2 GW capacity
|
18011799
3176109D103*GBP*plantsize.I.a/Unit.kW1840F103*GBP*plantsize.I.a/Unit.kW1000.0000000000001
3177E103*GBP*plantsize.I.a/Unit.kW80G103*GBP*plantsize.I.a/Unit.kW32
|
|
3776Preferences.moneyunits&"/ 2 GW capacity"£m/ 2 GW capacity
|
18011799
3176109D104*GBP*plantsize.I.a/Unit.kW6029.4F104*GBP*plantsize.I.a/Unit.kW1898.73
3177E104*GBP*plantsize.I.a/Unit.kW176G104*GBP*plantsize.I.a/Unit.kW36
|
3802Preferences.moneyunits&"/ 2 GW capacity"£m/ 2 GW capacity
|
18011799
3176109D105*GBP*plantsize.I.a/Unit.kW1728.6F105*GBP*plantsize.I.a/Unit.kW806.41148325358859
3177E105*GBP*plantsize.I.a/Unit.kW78.05G105*GBP*plantsize.I.a/Unit.kW1.2433944668946224
|
3362
|
18011799
3176109D106*GBP*50000160.5F106*GBP*5000052.659520000000001
3177E106*GBP*500004.2741684799502639G106*GBP*500003.4399999999999995
|
442
1093179
|
|
812
|
2604
|
7157304422007201020152020202520302035204020452050
47141F151-F14627.537999999999997F14527.537999999999997H76+G3722.821999999999999I76+H3716.4550000000000028.01200000000000051.20000
4725370.6G280.6H280.60.60.60.60.60.60.60.6
|
2605
|
71573044269169220152020202520302035204020452050
47253828.137999999999998G7628.137999999999998H145+H14623.42200000000000117.0550000000000038.61200000000000011.79999999999999980.60.60.60.6
497184.0999999999999996G774.0568H7700000000
5071927.8651651651651651651651651651
|
2539
|
715730442691201020152020202520302035204020452050
472538((F146*$D$71)+(F145*$D$70))/F1510.606397043144501930.606397043144501930.607685082401161260.610554089709762440.620901068276823010.700000000000000070.900000000000000130.900000000000000130.900000000000000130.90000000000000013
|
|
731
1866
22568
32616
42622
52623
|
2007201020152020202520302035204020452050
202
810Preferences.PowerUnitsGWF$1524.09999999999999964.056800000000
833771F$656.0299999999999999E-2G$650.060.060.060.060.060.060.060.060.06
8351260F171*F1720.247229999999999980.2434079999999999900000000
872Preferences.EnergyUnitsTWhF173*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy2.16721817999999992.133714528000000100000000
12171763F$52*F1740.439537020149821710.4267429056000000600000000
835884F174+F1752.60675520014982182.560457433599999900000000
20011764F$590.275000000000000020.30.30.30.30.30.30.30.30.3
8352231F176/F1779.47910981872662368.534858112000000200000000
|
2608
Preferences.EnergyUnitsTWhMAX(-SUM(I.a.Inputs[2007])-F$174,0)312.66735960950746MAX(-SUM(I.a.Inputs[2010])-G$174,0)307.04414409076583MAX(-SUM(I.a.Inputs[2015])-H$174,0)293.06071399813118MAX(-SUM(I.a.Inputs[2020])-I$174,0)273.96534631762114MAX(-SUM(I.a.Inputs[2025])-J$174,0)218.77181462743695MAX(-SUM(I.a.Inputs[2030])-K$174,0)123.85393750443438MAX(-SUM(I.a.Inputs[2035])-L$174,0)39.297525287320866MAX(-SUM(I.a.Inputs[2040])-M$174,0)0MAX(-SUM(I.a.Inputs[2045])-N$174,0)0MAX(-SUM(I.a.Inputs[2050])-O$174,0)0
|
2542
2569Preferences.PowerUnitsGWIF(AND(F181=0,$E$7=1),0,F$151)28.13799999999999828.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.6000
833771F1580.60639704314450193G1580.606397043144501930.607685082401161260.610554089709762440.620901068276823010.700000000000000070.900000000000000130.900000000000000130.900000000000000130.90000000000000013
835791F184*F18517.06279999999999617.06279999999999614.233210.4135.34721.260.5400O184*O1850
8571763
835791Preferences.EnergyUnitsTWhF186*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy149.57250479999996149.57250479999996124.768231291.280357999999993J186*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy46.87355519999999811.0451599999999994.7336400000000003000
|
2608
F$181*F$82/(1+F$82)144.56004206699379141.96017915531573135.4950168020828126.6663780895969101.1479508609800957.26318998620355718.168995688448945000
|
790IF(MIN(F188,F191)=0,(F$146*$D$71*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy),MIN(F188,F191))144.56004206699379IF(MIN(G188,G191)=0,(G$146*$D$71*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy),MIN(G188,G191))141.96017915531573IF(MIN(H188,H191)=0,(H$146*$D$71*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy),MIN(H188,H191))124.7682312IF(MIN(I188,I191)=0,(I$146*$D$71*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy),MIN(I188,I191))91.280357999999993IF(MIN(J188,J191)=0,(J$146*$D$71*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy),MIN(J188,J191))46.873555199999998K18811.045159999999999L1884.7336400000000003M1880N1880O1880
12171763F$51*F1937.73361191218343617.09800895776578686.23841156000000034.56401789999999962.34367775999999980.552258000000000030.23668200000000003000
835884F193+F194152.29365397917724149.05818811308151131.0066427600000195.84437589999998949.21723295999999711.5974179999999994.9703220000000004000
20011764F$580.356999999999999980.350.350.350.350.350.350.350.350.35
8352232F195/F196426.5928682890119425.88053746594721374.30469360000006273.84107399999999140.620665633.13548000000000114.200920000000002000
O$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))0
2543
2608
Preferences.EnergyUnitsTWhF$181-F$193168.10731754251367165.0839649354501168.29248279813118182.68498831762116171.89825942743695112.8087775044343934.563885287320865000
|
741IF(F201>0,F201,0)168.10731754251367IF(G201>0,G201,0)165.0839649354501168.29248279813118182.68498831762116171.89825942743695112.8087775044343934.563885287320865000
12171763F$53*F2033.3220016666386472G$53*G2033.3016792987090023.36584965596262363.65369976635242333.4379651885487392.25617555008868780.69127770574641734000
835884F203+F204171.42931920915231G203+G204168.38564423415909171.6583324540938186.33868808397358175.33622461598569115.0649530545230735.25516299306728000
20012233F$600.48899999999999999G$600.50.50.50.50.50.50.50.50.5
8352234F205/F206350.57120492669185G205/G206336.77128846831818343.31666490818759372.67737616794716350.67244923197137230.1299061090461570.510325986134561000
|
889
10401060F$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+F$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+F$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))198.26548259420858G$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+G$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+G$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))195.27083714568226H$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+H$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+H$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))178.45611197190652I$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+I$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+I$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))152.91568800690226J$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+J$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+J$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))107.83489566348271K$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+K$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+K$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))52.549630564064486L$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+L$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+L$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))17.347783341448757M$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+M$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+M$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0N$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+N$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+N$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0O$178*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+O$197*INDEX(EF[CO2], MATCH("V.03", EF[Vector], 0))+O$207*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0
1041F$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+F$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+F$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.5182280295123709G$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+G$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+G$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.51219986107632132H$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+H$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+H$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.46529204897474091I$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+I$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+I$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.38522227493680039J$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+J$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+J$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.2565694471138632K$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+K$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+K$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0.11485848813205599L$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+L$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+L$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))3.8854885788467325E-2M$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+M$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+M$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0N$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+N$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+N$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0O$178*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+O$197*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))+O$207*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0
1042F$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+F$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+F$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.345630535228558G$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+G$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+G$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.3339654567038288H$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+H$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+H$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.1574513688243511I$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+I$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+I$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.8949912942878786J$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+J$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+J$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.52278065666912499K$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+K$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+K$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18169772147250551L$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+L$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+L$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))6.6716818711770667E-2M$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+M$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+M$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0N$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+N$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+N$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0O$178*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+O$197*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))+O$207*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0
|
2624
|
202Preferences.PowerUnitsGWF$1714.09999999999999964.056800000000
2609Preferences.PowerUnitsGWF18428.13799999999999828.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.60001914
14Preferences.PowerUnitsGWF203*Preferences.Unit.Energy/(Preferences.Unit.Power*Unit.year*F$66)30.34366769886848326.90328948460775427.42617300579042429.77168089658439228.01379671905038618.3841428741622475.63278336549018470001914
|
27392007201020152020202520302035204020452050
33542740(G218-F218)/2-1.7201891071303645(H218-G218)/20.261441760591335281.172753945396984-0.87894208876700297-4.8148269224440696-6.3756797543360317-2.816391682745092300
"Approximate total "&$F$87/Unit.GW&" GW locations"Approximate total 2 GW locations2740F218/plantsize.I.a15.171833849434242G218/plantsize.I.a13.45164474230387713.71308650289521214.88584044829219614.0068983595251939.19207143708112362.8163916827450923000
3827555G22213.451644742303877H22213.71308650289521214.88584044829219614.0068983595251939.1920714370811236
3828G221+G2233.27981089286963555.26144176059133536.172753945396984-0.878942088767002978.63681781985980737.337406748559180512.06944876554710414.0068983595251939.1920714370811236
"Approximate build rate of "&$F$87/Unit.GW&" GW locations"Approximate build rate of 2 GW locations2741IF((G224/(G$169-F$169))>0,G224/(G$169-F$169),0)1.0932702976232118IF((H224/(H$169-G$169))>0,H224/(H$169-G$169),0)1.05228835211826711.234550789079396701.72736356397196161.46748134971183622.41388975310942082.80137967190503861.8384142874162248
|
2739
3355
"Approximate total "&$F$87/Unit.GW&" GW locations"Approximate total 2 GW locations2740IF((F145/plantsize.I.a)>0,F145/plantsize.I.a,0)13.76899999999999813.76899999999999811.4118.22750000000000094.00600000000000020.60000
"Approximate build rate of "&$F$87/Unit.GW&" GW locations"Approximate build rate of 2 GW locations2741
|
2739
3363G146-F146000000000
33642740IF(F184>0,F146/0.05,0)11.999999999999998IF(G184>0,G146/0.05,0)11.99999999999999811.99999999999999811.99999999999999811.99999999999999811.99999999999999811.999999999999998000
3829G23411.999999999999998H23411.99999999999999811.99999999999999811.999999999999998
3828IF(H234-G234+H235>H234,0,H234-G234+H235)000011.99999999999999800IF(O234-N234+O235>O234,0,O234-N234+O235)0
33652741F236/(F$169-E$169)0G236/(G$169-F$169)0H236/(H$169-G$169)0I236/(I$169-H$169)0002.39999999999999950N236/(N$169-M$169)00
|
31833859
3176Preferences.moneyunits£m(IF(F221>0,F225*$G$126,0))+(F237*$G$132)00848.57741084216627995.5559329734045400(IF(L221>0,L225*$G$126,0))+(L237*$G$132)126.382847999999970(IF(N221>0,N225*$G$126,0))+(N237*$G$132)00($O$222*$G$126/40)+($O$229*$G$120/40)+($O$234*$G$132/40)0
3177Preferences.moneyunits£m(F222*$G$127)+(F229*$G$121)+(F234*$G$133)+(F171*$G$114/2)621.42857426103103618.59850064321279469.12677588174722355.97897164848268202.9120999185889874.30937076416675844.78188583493327000O2410
3184Preferences.moneyunits£mSUM(F240:F241)621.42857426103103SUM(G240:G241)618.598500643212791317.70418672391361351.5349046218871202.9120999185889874.309370764166758171.16473383493323000SUM(Q240:Q241)0
Q242/'Global cost assumptions'!$P$50Q243*'Global cost assumptions'!$P$60R243/SUM(O216:O218)#DIV/0!
3185
3176Preferences.moneyunits£m(IF(F221>0,F225*$F$126,0))+(F237*$F$132)001818.98564547163642134.04449400264500385.19999999999993000($O$222*$F$126/40)+($O$229*$F$120/40)+($O$234*$F$132/40)0
3177Preferences.moneyunits£m(F222*$F$127)+(F229*$F$121)+(F234*$F$133)+(F171*$F$114/2)3822.79565370774533686.80689389622063129.93242331037442661.16986874860961849.5844387203445874.33119742358485271.10939259765763000O2460
3184Preferences.moneyunits£mSUM(F245:F246)3822.7956537077453SUM(G245:G246)3686.80689389622064948.91806878201084795.21436275125421849.5844387203445874.33119742358485656.30939259765751000SUM(Q245:Q246)0
Q247/'Global cost assumptions'!$P$50Q248*'Global cost assumptions'!$P$60
|
683
|
729Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
46INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$174+F$193+F$203314.83457778950742G$174+G$193+G$203309.17785861876587293.06071399813118273.96534631762114218.77181462743695123.8539375044343839.297525287320866000
47INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbons-F$197-426.5928682890119-G$197-425.88053746594721-374.30469360000006-273.84107399999999-140.6206656-33.135480000000001-14.200920000000002000
49INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F$178-9.4791098187266236-G$178-8.534858112000000200000000
50INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-F$207-350.57120492669185-G$207-336.77128846831818-343.31666490818759-372.67737616794716-350.67244923197137-230.12990610904615-70.510325986134561000
34INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion losses(F$197+F$207)-(F$195+F$205)+(F$178-F$176)460.31345464595103(G$197+G$207)-(G$195+G$205)+(G$178-G$176)451.18239426542482414.95638329409383364.33538618397353266.73965725598566136.603015054523144.485760993067274000
35INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Distribution losses and own useF$175+F$194+F$20411.495150598971904G$175+G$194+G$20410.8264311620747899.60426121596262318.21771766635242255.78164294854873882.80843355008868790.9279597057464174000
148SUBTOTAL(109,[2007])-1.4210854715202004E-14SUBTOTAL(109,[2010])9.0594198809412774E-14SUBTOTAL(109,[2015])-2.8421709430404007E-14SUBTOTAL(109,[2020])-6.2172489379008766E-14SUBTOTAL(109,[2025])-3.9968028886505635E-14SUBTOTAL(109,[2030])2.2648549702353193E-14SUBTOTAL(109,[2035])-6.9944050551384862E-15SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0
0
|
889
|
10581061
|
10571027442691692720721722723724725726727
10401050F$210198.26548259420858G$210195.27083714568226178.45611197190652152.91568800690226107.8348956634827152.54963056406448617.347783341448757000
10411050F$2110.5182280295123709G$2110.512199861076321320.465292048974740910.385222274936800390.25656944711386320.114858488132055993.8854885788467325E-2000
10421050F$2121.345630535228558G$2121.33396545670382881.15745136882435110.89499129428787860.522780656669124990.181697721472505516.6716818711770667E-2000
148SUBTOTAL(109,[2007])200.1293411589495SUBTOTAL(109,[2010])197.1170024634624SUBTOTAL(109,[2015])180.07885538970561SUBTOTAL(109,[2020])154.19590157612694SUBTOTAL(109,[2025])108.6142457672657SUBTOTAL(109,[2030])52.846186773669046SUBTOTAL(109,[2035])17.453355045948996SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0
|
|
|
2613
|
3664
|
782614442691692720721722723724725726727
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF2164.0999999999999996G2164.056800000000
3670INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Load factor839F656.0299999999999999E-2G650.060.060.060.060.060.060.060.060.06
2621$F$87&" GW thermal power stations"2 GW thermal power stations2740F281/$F$872.0499999999999998G281/$F$872.028400000000
|
3663
|
782614442691692720721722723724725726727
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF21728.137999999999998G21728.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.6000
3670INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Load factor839F1580.60639704314450193G1580.606397043144501930.607685082401161260.610554089709762440.620901068276823010.700000000000000070.900000000000000130.900000000000000130.900000000000000130.90000000000000013
2621$F$87&" GW thermal power stations"2 GW thermal power stations2740F288/$F$8714.068999999999999G288/$F$8714.06899999999999911.7118.52750000000000164.3060.899999999999999910.3000
|
3665
|
782614442691692720721722723724725726727
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF21830.343667698868483G21826.90328948460775427.42617300579042429.77168089658439228.01379671905038618.3841428741622475.6327833654901847000
3670INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Load factor839F660.63200000000000001G660.70.70.70.70.70.70.70.70.7
2621$F$87&" GW thermal power stations"2 GW thermal power stations2740F295/$F$8715.171833849434242G295/$F$8713.45164474230387713.71308650289521214.88584044829219614.0068983595251939.19207143708112362.8163916827450923000
|
3666
|
782614442691692720721722723724725726727
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWSUM(F$216:F$218)62.58166769886848659.09808948460775550.84817300579042946.82668089658439236.62579671905038520.1841428741622486.2327833654901843000
2621$F$87&" GW thermal power stations"2 GW thermal power stations2740F302/$F$8731.290833849434243G302/$F$8729.54904474230387725.42408650289521423.41334044829219618.31289835952519210.0920714370811243.1163916827450922000
|
3189
|
3190
|
78418442691692720721722723724725726727
3131INDEX(CostVectors[Description], MATCH(C311,CostVectors[Code], 0))Low estimate of capital costsF2400G2400848.57741084216627995.5559329734045400126.38284799999997000
3133INDEX(CostVectors[Description], MATCH(C312, CostVectors[Code], 0))Low estimate of operating costsF241621.42857426103103618.59850064321279469.12677588174722355.97897164848268202.9120999185889874.30937076416675844.78188583493327000
3135INDEX(CostVectors[Description], MATCH(C313, CostVectors[Code], 0))Low estimate of fuel costs
3140INDEX(CostVectors[Description], MATCH(C314, CostVectors[Code], 0))High estimate of capital costsF2450G24501818.98564547163642134.04449400264500385.19999999999993000
3142INDEX(CostVectors[Description], MATCH(C315, CostVectors[Code], 0))High estimate of operating costsF2463822.79565370774533686.80689389622063129.93242331037442661.16986874860961849.5844387203445874.33119742358485271.1093925976576300O2460
3144INDEX(CostVectors[Description], MATCH(C316, CostVectors[Code], 0))High estimate of fuel costs
|