672INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Agriculture and waste
911INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Agriculture and land use
1337
|
|
8251336
2573VI.a.2.Scenario3
2572VI.a.Scenario3
|
6432333
2334
|
1338
|
1459Preferences.AreaUnitskm^2
|
13367914242007201020152020202520302035204020452050
120191419(Unit.Mha/1000)*4171.04241710.420000000006(Unit.Mha/1000)*4647.35246473.5246473.5246473.5246473.5246473.5246473.5246473.5246473.5246473.52
120201420(Unit.Mha/1000)*347.943479.4(Unit.Mha/1000)*70700700700700700700700700700
120232047(Unit.Mha/1000)*16160(Unit.Mha/1000)*30300300300300300300300300300
120212048(Unit.Mha/1000)*00(Unit.Mha/1000)*12120(Unit.Mha/1000)*42420(Unit.Mha/1000)*72720(Unit.Mha/1000)*1021020(Unit.Mha/1000)*1321320(Unit.Mha/1000)*1621620(Unit.Mha/1000)*1921920(Unit.Mha/1000)*2222220(Unit.Mha/1000)*2522520
120221422(Unit.Mha/1000)*13202.018132020.18(Unit.Mha/1000)*12942.3763683129423.763683(Unit.Mha/1000)*12877.7937808631128777.93780863099(Unit.Mha/1000)*12813.533461183128135.33461183001(Unit.Mha/1000)*12749.5938011405127495.938011405(Unit.Mha/1000)*12685.9732006406126859.73200640599(Unit.Mha/1000)*12622.6700675731126226.700675731(Unit.Mha/1000)*12559.6828177723125596.828177723(Unit.Mha/1000)*12497.0098749775124970.098749775(Unit.Mha/1000)*12434.6496707938124346.496707938
114601469(Unit.Mha/1000)*2124.06221240.62(Unit.Mha/1000)*2169.06221690.62(Unit.Mha/1000)*2244.06222440.62(Unit.Mha/1000)*2319.06223190.62(Unit.Mha/1000)*2394.06223940.62(Unit.Mha/1000)*2469.06224690.62(Unit.Mha/1000)*2544.06225440.62(Unit.Mha/1000)*2619.06226190.62(Unit.Mha/1000)*2694.06226940.62(Unit.Mha/1000)*2769.06227690.62
114611043(Unit.Mha/1000)*2436.9724369.699999999997(Unit.Mha/1000)*2441.46424414.639999999999(Unit.Mha/1000)*2477.62424776.239999999998(Unit.Mha/1000)*2513.78425137.84(Unit.Mha/1000)*2549.94425499.439999999999(Unit.Mha/1000)*2586.10425861.039999999997(Unit.Mha/1000)*2622.26426222.639999999999(Unit.Mha/1000)*2658.42426584.239999999998(Unit.Mha/1000)*2694.58426945.839999999997(Unit.Mha/1000)*2730.74427307.440000000002
11231470(Unit.Mha/1000)*2134.96221349.62(Unit.Mha/1000)*2120.739631721207.396316999999(Unit.Mha/1000)*2044.1622191368820441.622191368799(Unit.Mha/1000)*1967.2625388169519672.625388169501(Unit.Mha/1000)*1890.0421988595318900.421988595299(Unit.Mha/1000)*1812.5027993594318125.0279935943(Unit.Mha/1000)*1734.6459324269417346.459324269399(Unit.Mha/1000)*1656.4731822277316564.731822277299(Unit.Mha/1000)*1577.9861250224615779.861250224601(Unit.Mha/1000)*1499.1863292062114991.8632920621
220491419(Unit.Mha/1000)*4171.04241710.420000000006(Unit.Mha/1000)*4624.0938507941146240.9385079411(Unit.Mha/1000)*4566.4564446376945664.564446376899(Unit.Mha/1000)*4509.5374647709645095.374647709599(Unit.Mha/1000)*4453.327956309144533.279563090997(Unit.Mha/1000)*4397.8190759862143978.190759862104(Unit.Mha/1000)*4343.00209076443430.020907639999(Unit.Mha/1000)*4288.8683764578842888.683764578804(Unit.Mha/1000)*4235.4094163801342354.094163801303(Unit.Mha/1000)*4182.6168000000141826.1680000001
220501420(Unit.Mha/1000)*347.943479.4(Unit.Mha/1000)*100100010001000100010001000100010001000
220512047(Unit.Mha/1000)*16160(Unit.Mha/1000)*11.1061492058862111.061492058862(Unit.Mha/1000)*68.7435553623137687.43555362313703(Unit.Mha/1000)*125.6625352290431256.6253522904301(Unit.Mha/1000)*181.8720436908991818.72043690899(Unit.Mha/1000)*237.3809240137932373.8092401379299(Unit.Mha/1000)*292.1979092360042921.9790923600403(Unit.Mha/1000)*346.3316235421243463.31623542124(Unit.Mha/1000)*399.7905836198723997.90583619872(Unit.Mha/1000)*452.5831999999954525.8319999999494
220212048(Unit.Mha/1000)*00(Unit.Mha/1000)*20200(Unit.Mha/1000)*70700(Unit.Mha/1000)*1201200(Unit.Mha/1000)*1701700(Unit.Mha/1000)*2202200(Unit.Mha/1000)*3203200(Unit.Mha/1000)*4204200(Unit.Mha/1000)*5205200(Unit.Mha/1000)*6206200
220521422(Unit.Mha/1000)*13202.018132020.18(Unit.Mha/1000)*12916.4786732129164.78673199999(Unit.Mha/1000)*12787.8295133295127878.295133295(Unit.Mha/1000)*12660.461709373126604.61709372999(Unit.Mha/1000)*12534.3624989232125343.62498923199(Unit.Mha/1000)*12409.5192466872124095.19246687199(Unit.Mha/1000)*12285.919443221122859.19443221(Unit.Mha/1000)*12163.5507036755121635.50703675501(Unit.Mha/1000)*12042.4007665555120424.00766555499(Unit.Mha/1000)*11922.4574924916119224.574924916
214601469(Unit.Mha/1000)*2124.06221240.62(Unit.Mha/1000)*2169.06221690.62(Unit.Mha/1000)*2244.06222440.62(Unit.Mha/1000)*2319.06223190.62(Unit.Mha/1000)*2394.06223940.62(Unit.Mha/1000)*2469.06224690.62(Unit.Mha/1000)*2544.06225440.62(Unit.Mha/1000)*2619.06226190.62(Unit.Mha/1000)*2694.06226940.62(Unit.Mha/1000)*2769.06227690.62
214611043(Unit.Mha/1000)*2436.9724369.699999999997(Unit.Mha/1000)*2478.58624785.859999999997(Unit.Mha/1000)*2547.94625479.46(Unit.Mha/1000)*2617.30626173.06(Unit.Mha/1000)*2686.66626866.660000000003(Unit.Mha/1000)*2756.02627560.26(Unit.Mha/1000)*2825.38628253.86(Unit.Mha/1000)*2894.74628947.46(Unit.Mha/1000)*2964.10629641.06(Unit.Mha/1000)*3033.46630334.66
21231470(Unit.Mha/1000)*2134.96221349.62(Unit.Mha/1000)*2113.667326821136.673267999999(Unit.Mha/1000)*2047.9564866704620479.564866704601(Unit.Mha/1000)*1980.9642906269719809.642906269699(Unit.Mha/1000)*1912.7035010768319127.035010768301(Unit.Mha/1000)*1843.1867533127518431.867533127501(Unit.Mha/1000)*1722.4265567789317224.265567789302(Unit.Mha/1000)*1600.4352963244916004.352963244901(Unit.Mha/1000)*1477.2252334444614772.2523344446(Unit.Mha/1000)*1352.8085075084113528.0850750841
320491419(Unit.Mha/1000)*4171.04241710.420000000006(Unit.Mha/1000)*4570.8905871226445708.905871226394(Unit.Mha/1000)*4385.1956027138743851.956027138702(Unit.Mha/1000)*4207.0445808168542070.445808168501(Unit.Mha/1000)*4036.1310437388340361.310437388303(Unit.Mha/1000)*3872.1609646145738721.609646145698(Unit.Mha/1000)*3714.8522615845637148.522615845599(Unit.Mha/1000)*3563.9343125224635639.343125224601(Unit.Mha/1000)*3419.1474894770334191.474894770297(Unit.Mha/1000)*3280.2427120276532802.427120276501
320501420(Unit.Mha/1000)*347.943479.4(Unit.Mha/1000)*100100010001000100010001000100010001000
320512047(Unit.Mha/1000)*16160(Unit.Mha/1000)*64.3094128773601643.09412877360103(Unit.Mha/1000)*250.0043972861292500.0439728612901(Unit.Mha/1000)*428.1554191831464281.5541918314602(Unit.Mha/1000)*599.068956261175990.6895626117002(Unit.Mha/1000)*763.0390353854297630.39035385429(Unit.Mha/1000)*920.3477384154399203.4773841543902(Unit.Mha/1000)*1071.2656874775410712.656874775401(Unit.Mha/1000)*1216.0525105229712160.525105229699(Unit.Mha/1000)*1354.9572879723513549.572879723501
320212048(Unit.Mha/1000)*00(Unit.Mha/1000)*30300(Unit.Mha/1000)*1051050(Unit.Mha/1000)*1801800(Unit.Mha/1000)*2552550(Unit.Mha/1000)*3303300(Unit.Mha/1000)*4804800(Unit.Mha/1000)*6306300(Unit.Mha/1000)*7807800(Unit.Mha/1000)*9309300
320521422(Unit.Mha/1000)*13202.018132020.18(Unit.Mha/1000)*12890.6069147128906.069147(Unit.Mha/1000)*12698.4044903555126984.04490355501(Unit.Mha/1000)*12509.0678559749125090.67855974899(Unit.Mha/1000)*12322.5542818571123225.54281857099(Unit.Mha/1000)*12138.8216754126121388.21675412601(Unit.Mha/1000)*11957.8285716636119578.285716636(Unit.Mha/1000)*11779.5341238864117795.341238864(Unit.Mha/1000)*11603.8980943929116038.980943929(Unit.Mha/1000)*11430.8808454498114308.80845449799
314601469(Unit.Mha/1000)*2124.06221240.62(Unit.Mha/1000)*2169.06221690.62(Unit.Mha/1000)*2244.06222440.62(Unit.Mha/1000)*2319.06223190.62(Unit.Mha/1000)*2394.06223940.62(Unit.Mha/1000)*2469.06224690.62(Unit.Mha/1000)*2544.06225440.62(Unit.Mha/1000)*2619.06226190.62(Unit.Mha/1000)*2694.06226940.62(Unit.Mha/1000)*2769.06227690.62
314611043(Unit.Mha/1000)*2436.9724369.699999999997(Unit.Mha/1000)*2471.14424711.439999999999(Unit.Mha/1000)*2581.50425815.040000000001(Unit.Mha/1000)*2691.86426918.639999999999(Unit.Mha/1000)*2802.22428022.240000000002(Unit.Mha/1000)*2912.58429125.839999999997(Unit.Mha/1000)*3022.94430229.439999999999(Unit.Mha/1000)*3133.30431333.040000000001(Unit.Mha/1000)*3243.66432436.640000000003(Unit.Mha/1000)*3354.02433540.239999999998
31231470(Unit.Mha/1000)*2134.96221349.62(Unit.Mha/1000)*2136.981085321369.810852999999(Unit.Mha/1000)*2068.8235096444820688.235096444801(Unit.Mha/1000)*1997.8001440251219978.001440251202(Unit.Mha/1000)*1923.953718142919239.537181429001(Unit.Mha/1000)*1847.326324587418473.263245874001(Unit.Mha/1000)*1692.9594283363816929.5942833638(Unit.Mha/1000)*1535.8938761135915358.938761135902(Unit.Mha/1000)*1376.169905607113761.699056071(Unit.Mha/1000)*1213.8271545502212138.271545502201
420191419(Unit.Mha/1000)*4171.04241710.420000000006(Unit.Mha/1000)*4570.8905871226445708.905871226394(Unit.Mha/1000)*4385.1956027138743851.956027138702(Unit.Mha/1000)*4207.0445808168542070.445808168501(Unit.Mha/1000)*4036.1310437388340361.310437388303(Unit.Mha/1000)*3872.1609646145738721.609646145698(Unit.Mha/1000)*3714.8522615845637148.522615845599(Unit.Mha/1000)*3563.9343125224635639.343125224601(Unit.Mha/1000)*3419.1474894770334191.474894770297(Unit.Mha/1000)*3280.2427120276532802.427120276501
420201420(Unit.Mha/1000)*347.943479.4(Unit.Mha/1000)*100100010001000100010001000100010001000
420232047(Unit.Mha/1000)*16160(Unit.Mha/1000)*64.3094128773601643.09412877360103(Unit.Mha/1000)*250.0043972861292500.0439728612901(Unit.Mha/1000)*428.1554191831464281.5541918314602(Unit.Mha/1000)*599.068956261175990.6895626117002(Unit.Mha/1000)*763.0390353854297630.39035385429(Unit.Mha/1000)*920.3477384154399203.4773841543902(Unit.Mha/1000)*1071.2656874775410712.656874775401(Unit.Mha/1000)*1216.0525105229712160.525105229699(Unit.Mha/1000)*1354.9572879723513549.572879723501
420212048(Unit.Mha/1000)*00(Unit.Mha/1000)*80800(Unit.Mha/1000)*2802800(Unit.Mha/1000)*4804800(Unit.Mha/1000)*6806800(Unit.Mha/1000)*111311130(Unit.Mha/1000)*151315130(Unit.Mha/1000)*191319130(Unit.Mha/1000)*231323130(Unit.Mha/1000)*271327130
420221422(Unit.Mha/1000)*13202.018132020.18(Unit.Mha/1000)*12754.9366609163127549.366609163(Unit.Mha/1000)*12236.7602313477122367.60231347699(Unit.Mha/1000)*11739.635008798117396.35008798001(Unit.Mha/1000)*11262.705776218112627.05776217999(Unit.Mha/1000)*10805.1520602294108051.52060229401(Unit.Mha/1000)*10366.1867196432103661.86719643199(Unit.Mha/1000)*9945.0545913210399450.545913210299(Unit.Mha/1000)*9541.0311910492295410.311910492193(Unit.Mha/1000)*9153.4214671899791534.214671899696
414601469(Unit.Mha/1000)*2124.06221240.62(Unit.Mha/1000)*2169.06221690.62(Unit.Mha/1000)*2244.06222440.62(Unit.Mha/1000)*2319.06223190.62(Unit.Mha/1000)*2394.06223940.62(Unit.Mha/1000)*2469.06224690.62(Unit.Mha/1000)*2544.06225440.62(Unit.Mha/1000)*2619.06226190.62(Unit.Mha/1000)*2694.06226940.62(Unit.Mha/1000)*2769.06227690.62
414611043(Unit.Mha/1000)*2436.9724369.699999999997(Unit.Mha/1000)*2493.4324934.3(Unit.Mha/1000)*2659.50526595.050000000003(Unit.Mha/1000)*2825.5828255.8(Unit.Mha/1000)*2991.65529916.550000000003(Unit.Mha/1000)*3157.7331577.3(Unit.Mha/1000)*3323.80533238.049999999996(Unit.Mha/1000)*3489.8834898.800000000003(Unit.Mha/1000)*3655.95536559.550000000003(Unit.Mha/1000)*3822.0338220.300000000003
41231470(Unit.Mha/1000)*2134.96221349.62(Unit.Mha/1000)*2200.3653390837322003.653390837299(Unit.Mha/1000)*2277.4667686522822774.6676865228(Unit.Mha/1000)*2333.5169912020423335.169912020399(Unit.Mha/1000)*2369.37122378223693.71223782(Unit.Mha/1000)*2152.8499397706121528.499397706102(Unit.Mha/1000)*1950.7402803568419507.402803568399(Unit.Mha/1000)*1730.7974086789717307.974086789698(Unit.Mha/1000)*1493.7458089507814937.4580895078(Unit.Mha/1000)*1240.2805328100312402.805328100301
|
202913361064
|
1424791234
114672.2189740965115057E-30-2.4472451512579374E-3-5.175943317647369E-3
214680000
314732.2189740965115057E-30-2.4472451512579374E-3-5.175943317647369E-3
|
203013361064
|
1424791234
1465321.475507415268118E-28.8859995024890281E-31.125341116489631E-21.125341116489631E-2
146520251.475507415268118E-28.8859995024890281E-31.125341116489631E-21.125341116489631E-2
146520422.5000000000000001E-32.5000000000000001E-30.011.4999999999999999E-2
5314750000
5314760000
5314775.0000000000000001E-32E-32E-32E-3
147914802E-32E-302E-3
147914821E-31E-31E-31E-3
147914843.0000000000000001E-32E-302E-3
147914860000
|
20311336202713362028
|
14247912341234
20331490-2.4472451512579374E-3-2.4472451512579374E-3-3.772376630140406E-3-1.1921561279377713E-3-7.4310483882145117E-4-7.4310483882145117E-4-3.772376630140406E-3-1.1921561279377713E-3
20341491-2.4472451512579374E-3-2.4472451512579374E-3-3.772376630140406E-3-2.4472451512579374E-3-7.4310483882134015E-4-2.4472451512579374E-3-3.772376630140406E-3-2.4472451512579374E-3
|
20351336202713362028
|
14247912341234
20321492-6.3934443203000901E-3-6.3934443203000901E-3-6.3934443203000901E-3-6.3934443203000901E-30-6.7319687848443888E-4-2.416099615924483E-3-6.7319687848443888E-4
|
21611061
|
1336794422007201020152020202520302035204020452050
12015-14.183165399999998-10.63661229-7.2915988299999999-4.0474132699999998-1.05174021999999990.616304579999999990.88085168999999996-0.14352334999999999-1.42479723-1.93614847
21462-14.183165399999998-10.582451516666699-7.2689570166666702-4.2283102499999998-1.60029287666667-0.61735176333333297-0.929239486666669-2.50554051666668-4.3207360266666601-5.3787944533333398
31463-14.183165399999998-10.5326948133333-7.5910687149999996-4.7967910199999997-2.69593621666667-2.5354317183333399-3.0805327149999902-5.2834375800000002-7.4420078616666601-8.8947345183333706
41464-14.183165399999998-10.456307131999999-7.3616709504333304-5.0482864033333303-3.6393750815333301-4.4265016063666698-5.8748650194999898-8.6591228508333895-11.7321817720333-14.1107599681333
|
15021503
|
1336794422007201020152020202520302035204020452050
120150.030.050.050.050.050.050.050.050.050.05
214620.033.4728750000000003E-24.4323663313671886E-25.6569474269697086E-27.2198577010732554E-29.2145712677534339E-20.11760387415375960.150095656261013680.191564318697269480.24449000798619908
314630.030.050.10.5111111
414640.030.050.10.5111111
|
15042235
|
1336794422007201020152020202520302035204020452050
120150.020.10.20.50.50.50.50.50.50.5
214620.020.10.20.50.50.50.50.50.50.5
314630.020.10.50.90.90.90.90.90.90.9
414640.020.10.50.90.90.90.90.90.90.9
|
20361503
|
1336794422007201020152020202520302035204020452050
120150.030.050.050.050.050.050.050.050.050.05
214620.033.4728750000000003E-24.4323663313671886E-25.6569474269697086E-27.2198577010732554E-29.2145712677534339E-20.11760387415375960.150095656261013680.191564318697269480.24449000798619908
314630.030.050.10.20.40.80.80.80.80.8
414640.030.050.10.20.40.80.80.80.80.8
|
20652066
|
1336794422007201020152020202520302035204020452050
120150000000000
214620000001.2436379999999993E-20.181594324999999830.315379863333333340.3712013616666674
314630000.36960000000000010.369600000000000150.739199999999998971.25803655999999652.06862264399999863.01897376000000023.5673428559999878
414640000.36960000000000010.369600000000000150.739199999999998971.30678716959999842.5678254198666653.85781033146666364.5288289243999769
|
|
|
784
|
14711472
|
1424792007
114671954
21468167667
3147349594
|
1474
|
14247912492007
14653220249.6999999999999993
1465202520243
14652042202410
53147520243.28
53147620241.72
53202614780.36499999999999999
14791480148170
1479148214831.7
1479148414856913
147914861487298
|
2037
|
14247912492007
10411490203915561/(F$132+F$134)*1000301.87398153177617
1041149120401000*(4556.87)/((F$132+F$134)*F$144*F$186)484.38641043166575
|
2038
|
14247912492007
10422201106123.28
|
2170"Mt CO2e / " & Preferences.AreaUnitsMt CO2e / km^2
|
1057794422007
2165216615.28835/(F$20+F$21)3.3831402736279978E-4
21672168-7.96705/F$24-6.0347213585074652E-5
|
2171"Mt CO2e / " & Preferences.AreaUnitsMt CO2e / km^2
|
1057794422007
216914606.329816.3298100000000002
2173123-1.29274
|
2041Preferences.EnergyUnits & " / million odt"TWh / million odt
|
1424794422007
114965.3*Unit.GJ * 10000001.4722222222222221
2202514*Unit.GJ *10000003.8888888888888888
3204218.5*Unit.GJ *10000005.1388888888888884
4149515*Unit.GJ *10000004.1666666666666661
522318.6*Unit.GJ *10000005.166666666666667
6149418.6*Unit.GJ *10000005.166666666666667
|
1505
|
1424794422007
149415060.5
|
2053Preferences.AreaUnitskm^2
|
1424794422007
146120541128*Unit.ha11.28
|
2072839
|
715794422007
49INDEX(Vectors[Description], MATCH($C196, Vectors[Code], 0))Liquid hydrocarbons0.31
|
2078Preferences.EnergyUnitsTWh
|
715794422007
20752075314*Unit.ktoe3.6518199999999998
20762076251*Unit.ktoe2.91913
20772077332*Unit.ktoe3.8611599999999999
|
2079839
|
715794422007
45INDEX(Vectors[Description], MATCH($C208, Vectors[Code], 0))Electricity (delivered to end user)0.4
47INDEX(Vectors[Description], MATCH($C209, Vectors[Code], 0))Solid hydrocarbons0.08
49INDEX(Vectors[Description], MATCH($C210, Vectors[Code], 0))Liquid hydrocarbons0.33
50INDEX(Vectors[Description], MATCH($C211, Vectors[Code], 0))Gaseous hydrocarbons0.19
SUM(F$208:F$211)1
|
|
3170
|
3459Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh
|
7157944217991801
2221(50%*4.53*GBP/Unit.GJ)*(Price2000)10.561081753186199(150%*4.53*GBP/Unit.GJ)*(Price2000)31.683245259558596Price20101
2215(3.61*GBP/Unit.GJ)*(Price2000)16.832452595585952(5.97*GBP/Unit.GJ)*(Price2000)27.83649362760336
1509(1.102*GBP/Unit.GJ)*(Price2000)5.1383276344420272(4.34*GBP/Unit.GJ)*(Price2000)20.236244948709981
1510(2.64*GBP/Unit.GJ)*(Price2000)12.309605222256764(5.28*GBP/Unit.GJ)*(Price2000)24.619210444513527
1511(0.675*GBP/Unit.GJ)*(Price2000)3.1473422443270129(3.377*GBP/Unit.GJ)*(Price2000)15.746036680136774
|
3460Preferences.moneyunits&"/MtCO2e"£m/MtCO2e
|
71579346117991801
34622.20000000000000020*(Price2010)0(59*MGBP)*(Price2010)59
34632.2000000000000002(59*MGBP)*(Price2010)59(432*MGBP)*(Price2010)432
|
3464Preferences.moneyunits&"/MtCO2e"£m/MtCO2e
|
7157917991801
34650*(Price2010)0(1692*MGBP)*(Price2010)1692
|
3466Preferences.moneyunits&"/MtCO2e"£m/MtCO2e
|
71579346117991801
3467(9*MGBP)*(Price2010)9(70*MGBP)*(Price2010)70
|
7173448
|
|
|
812
|
2055
|
1459Preferences.AreaUnitskm^2
|
1424794422007201020152020202520302035204020452050
14192049SUMIFS(F$20:F$51, $C$20:$C$51, $E$9, $E$20:$E$51, $C253)41710.42000000000645708.90587122639443851.95602713870242070.44580816850140361.31043738830338721.60964614569837148.52261584559935639.34312522460134191.47489477029732802.427120276501
142020503479.4100010001000100010001000100010001000
20472051160643.094128773601032500.04397286129014281.55419183146025990.68956261170027630.390353854299203.477384154390210712.65687477540112160.52510522969913549.572879723501
20482021030010501800255033004800630078009300
14222052132020.18128906.069147126984.04490355501125090.67855974899123225.54281857099121388.21675412601119578.285716636117795.341238864116038.980943929114308.80845449799
1469146021240.6221690.6222440.6223190.6223940.6224690.6225440.6226190.6226940.6227690.62
1043146124369.69999999999724711.43999999999925815.04000000000126918.63999999999928022.24000000000229125.83999999999730229.43999999999931333.04000000000132436.64000000000333540.239999999998
147012321349.6221369.81085299999920688.23509644480119978.00144025120219239.53718142900118473.26324587400116929.594283363815358.93876113590213761.69905607112138.271545502201
SUM(F253:F260)244329.94SUM(G253:G260)244329.94244329.93999999983244329.94000000012244329.93999999997244329.94244329.9399999998244329.93999999992244329.94244329.94000000021
|
14661472
|
14247913112007201020152020202520302035204020452050
11467INDEX($G56:$J56, MATCH($E$8, $G$55:$J$55, 0))-2.4472451512579374E-3F$132:F$1341954$F266*(1+$E266)^(G$265-$F$265)1939.6893278541461$F266*(1+$E266)^(H$265-$F$265)1916.07073556230031892.73973463564791869.69282322309161846.92654211376111824.43747421780521802.22224405350561780.27751724063751758.5999999999963
21468INDEX($G57:$J57, MATCH($E$8, $G$55:$J$55, 0))0167667$F267*(1+$E267)^(G$265-$F$265)167667167667167667167667167667167667167667167667167667
31473INDEX($G58:$J58, MATCH($E$8, $G$55:$J$55, 0))-2.4472451512579374E-349594$F268*(1+$E268)^(G$265-$F$265)49230.78430173926648631.32654016208848039.16806526116947454.21999740327746876.39453919645246305.60496231209345741.76559446753545184.79180656713344634.599999999904
|
|
2056
|
14881489
|
14247913112007201020152020202520302035204020452050
146532INDEX($G63:$J63, MATCH($E$9, $G$62:$J$62, 0))1.125341116489631E-2F139:F1489.6999999999999993$F276*(1+$E276)^(G$275-$F$275)10.031173291147145$F276*(1+$E276)^(H$275-$F$275)10.60844504542855311.21893750765897511.86456245583282712.54734168652406513.26941334621121414.03303862695606514.84060884740385515.694652941279271
14652025INDEX($G64:$J64, MATCH($E$9, $G$62:$J$62, 0))1.125341116489631E-23$F277*(1+$E277)^(G$275-$F$275)3.10242472922076653.28096238518408883.46977448690483753.66945230592767853.88062114016208254.10394227202408774.34011503926476294.58987902497026484.8540163735915272
14652042INDEX($G65:$J65, MATCH($E$9, $G$62:$J$62, 0))0.0110$F278*(1+$E278)^(G$275-$F$275)10.30300999999999910.82856705628080211.38093280433289511.96147475686665212.57163018348430413.21290966898251213.88690085316408614.5952723614177215.339777935796782
531475INDEX($G66:$J66, MATCH($E$9, $G$62:$J$62, 0))03.283.283.283.283.283.283.283.283.283.28
531476INDEX($G67:$J67, MATCH($E$9, $G$62:$J$62, 0))01.721.721.721.721.721.721.721.721.721.72
532026INDEX($G68:$J68, MATCH($E$8, $G$62:$J$62, 0))2E-30.364999999999999990.367194382919999950.37088104392945470.37460471931067230.37836578069090920.382164603428589710.38600156665076640.389877053290957840.393791450127365880.39774514782147657
14791480INDEX($G69:$J69, MATCH($E$8, $G$62:$J$62, 0))070707070707070707070
14791482INDEX($G70:$J70, MATCH($E$8, $G$62:$J$62, 0))1E-31.71.70510510169999921.71364769531909331.72223308741768791.7308614924165931.73953312581086951.74824820417521191.75700694516935351.76580956754350681.7746562911438251
14791484INDEX($G71:$J71, MATCH($E$8, $G$62:$J$62, 0))06913691369136913691369136913691369136913
14791486INDEX($G72:$J72, MATCH($E$8, $G$62:$J$62, 0))0298298298298298298298298298298
|
|
1160
|
20462045
|
1424792007201020152020202520302035204020452050
10411490INDEX($G77:$J77, MATCH($E$9, $G$76:$J$76, 0))-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3INDEX($K77:$N77, MATCH($E$9, $K$76:$N$76, 0))-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3
10411491-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3-3.772376630140406E-3
|
20442045
|
1424792007201020152020202520302035204020452050
10411490F153:F154301.87398153177617F299*(1+F293)^(G$298-F$298)298.47050601423734292.8831050935575287.40030093677672282.02013548089337276.74068731806204271.56007100940485266.47643641166854261.48796801648638256.59288430200934
10411491484.38641043166575478.92520015919604469.95966738330884461.16197037369329452.52896722622114444.05757485355741435.74476788410334427.5875775815515419.58309078466687411.7284488669153
|
20351061
|
1424792007201020152020202520302035204020452050
10421492INDEX($G83:$J83, MATCH($E$9, $G$82:$J$82, 0))-6.3934443203000901E-3INDEX($G83:$J83, MATCH($E$9, $G$82:$J$82, 0))-6.3934443203000901E-3INDEX($G83:$J83, MATCH($E$9, $G$82:$J$82, 0))-6.3934443203000901E-3INDEX($K83:$N83, MATCH($E$9, $K$82:$N$82, 0))-2.416099615924483E-3-2.416099615924483E-3-2.416099615924483E-3-2.416099615924483E-3-2.416099615924483E-3-2.416099615924483E-3
|
20431061
|
1424792007201020152020202520302035204020452050
10421492F$15923.28F310*(1+F305)^(G$309-F$309)22.83633055363073122.11559163272466921.41759999999999321.16011196762400520.90571952424103220.65438545386427920.40607298792734920.16074579990524319.918368000000019
|
|
2057
|
2058Preferences.AreaUnitskm^2
|
1424792007201020152020202520302035204020452050
20592061F$25924369.699999999997F318-$F$191*(G$317-F$317)24335.85999999999724279.45999999999524223.05999999999424166.65999999999324110.25999999999124053.8599999999923997.45999999998823941.05999999998723884.659999999985
206020620G$259-G318375.58000000000175H$259-H3181535.58000000000542695.58000000000543855.5800000000095015.58000000000546175.5800000000097335.58000000001278495.58000000001639655.5800000000127
|
|
731
12068
22069
31493
42080
51159
62074
120702007201020152020202520302035204020452050
20251497F$277*F$254/Unit.Mha1.043820.310242472922076630.328096238518408860.346977448690483750.366945230592767850.388062114016208270.41039422720240870.434011503926476310.458987902497026530.48540163735915276
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1773.8888888888888888
8351507Preferences.EnergyUnitsTWhF333*$F3344.0592999999999995G333*$F3341.20649850580807571.27592981646047891.34935674490743681.4270092300829861.50913044339636551.59597755023158941.687822515269631.78495295415510321.887673034174483
|
2124
2216INDEX(Vectors[Description], MATCH(C338, Vectors[Code], 0))Energy crops (first generation)Preferences.EnergyUnitsTWhF3354.0592999999999995G3351.20649850580807571.27592981646047891.34935674490743681.4270092300829861.50913044339636551.59597755023158941.687822515269631.78495295415510321.887673034174483
|
|
220712007201020152020202520302035204020452050
|
20421498F$278*(F$255+F$256)/Unit.Mha0.160.971670823969569723.84418892128739836.921375960314289710.21592426094143513.74128252897802818.50266817284714823.62530792689063529.13293003877435835.050737390276304
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1785.1388888888888884
8351508Preferences.EnergyUnitsTWhF343*$F3440.822222222222222194.993308400954732419.75485973439357335.5681820182817652.49849967428237170.61492410724818695.083155888242274121.40783240207686149.71089047703489180.12184492225322
|
2073Preferences.EnergyUnitsTWhF335+F3454.88152222222222146.199806906762807721.03078955085405336.91753876318919953.92550890436535872.12405455064454496.679133438473869123.09565491734649151.49584343119182.00951795642769
1499839F347/(F254+F255+F256)/Unit.GWyear*1000000000/10000000000/Global.UKIncidentSolarEnergy1.5301497031163935E-73.6399277766905135E-75.2728865362086164E-75.9472007567520064E-76.4479688364095446E-76.8965822790147178E-77.3510480833843141E-77.796027987064817E-78.2453102427208466E-78.7060656187368955E-7
|
2124
1772INDEX(Vectors[Description], MATCH(C351, Vectors[Code], 0))Energy crops (second generation)Preferences.EnergyUnitsTWhF3450.82222222222222219G3454.993308400954732419.75485973439357335.5681820182817652.49849967428237170.61492410724818695.083155888242274121.40783240207686149.71089047703489180.12184492225322
|
|
320632007201020152020202520302035204020452050
|
15971497(F$253+F$254+$F255)*F$279/Unit.Mha14.87474096000000215.37300112576225614.76392157690149414.17958622507926813.61898982346336413.08116796393578912.56519541799735712.07018454507366911.59528376548465711.139676095450691
8331501INDEX(F$96:F$99, MATCH($E$9, $C$96:$C$99, 0))0.030.050.10.5111111
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1794.1666666666666661
8351509Preferences.EnergyUnitsTWhF356*F357*$F3581.8593426199999998G356*G357*$F3583.20270856786713686.151633990375621929.54080463558180456.74579093109733954.50486651639911252.35498090832231150.29243560447361748.31368235618606446.415317064377874
|
20641497F$318*F$280/Unit.Mha4.19158839999999884.18576791999999914.1760671199999994.1663663199999994.15666551999999894.14696471999999884.13726391999999884.12756311999999784.11786231999999774.1081615199999968
8331501INDEX(F$112:F$115, MATCH($E$9, $C$112:$C$115, 0))0.030.050.10.20.40.80.80.80.80.8
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1805.166666666666667
8351510Preferences.EnergyUnitsTWhF361*F362*$F3630.649696201999999781.08132337933333322.15763467866666634.30524519733333218.590442074666665217.14078750933333217.10069086933333117.06059422933332617.02049758933332816.980400949333323
|
20671497INDEX(F$120:F$123, MATCH($E$9, $C$120:$C$123, 0))0000.36960000000000010.369600000000000150.739199999999998971.25803655999999652.06862264399999863.01897376000000023.5673428559999878
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1805.166666666666667
8351510Preferences.EnergyUnitsTWhF366*$F3670001.90960000000000061.90960000000000093.8191999999999956.499855559999982510.6878836606666615.59803109333333518.431271422666605
|
15001497(F$266+F$268)*F$281/100018.815020000000001(G$266+G$268)*G$281*1000/100000018.78951048814268518.74707146953753418.70472830602671618.66248078110664518.62032867876276418.57827178346840918.53630988018371918.49444275435453418.452670191911288
8331506$F$1860.5
8331501INDEX(F$104:F$107, MATCH($E$9, $C$104:$C$107, 0))0.020.10.50.90.90.90.90.90.90.9
833902Preferences.EnergyUnits & " / M odt"TWh / M odt$F$1815.166666666666667
8351511Preferences.EnergyUnitsTWhF370*$F371*F372*$F3730.97210936666666681G370*$F371*G372*$F3734.853956876103527724.21496731481931543.48849331151211643.39026781607294943.29226417812342543.19448189656404943.09692047142715442.99957940387429342.902458196193756
|
2124
753INDEX(Vectors[Description], MATCH(C377, Vectors[Code], 0))Dry biomass and wasteF$359+F$364+F$3682.50903882199999954.28403194720046988.309268669042287735.75564983291513267.24583300576399875.46485402573243675.95552733765562478.040913494473680.93221103885272881.826989436377801
916INDEX(Vectors[Description], MATCH(C378, Vectors[Code], 0))Wet biomass and wastePreferences.EnergyUnitsTWhF$3740.972109366666666814.853956876103527724.21496731481931543.48849331151211643.39026781607294943.29226417812342543.19448189656404943.09692047142715442.99957940387429342.902458196193756
|
|
422402007201020152020202520302035204020452050
|
2081Preferences.EnergyUnitsTWhF201:F2033.6518199999999998$F383*(G$266/$F$266)3.6250748624587144$F383*(H$266/$F$266)3.58093420344990763.53733102238339383.4942587746686543.45171099540525813.40968129841252043.36816337527096853.32715099437548873.2866379999999928
2082Preferences.EnergyUnitsTWh2.91913$F3842.919132.919132.919132.919132.919132.919132.919132.919132.91913
2083Preferences.EnergyUnitsTWh3.8611599999999999$F385*(SUM(G$253:G$256)/SUM($F$253:$F$256))4.05717147984269744.12102774211672524.1848840043907524.24874026666478424.3125965289388124.44030905348686924.56802157803492834.6957341025829864$F385*(SUM(O$253:O$256)/SUM($F$253:$F$256))4.8234466271310446
|
2084SUM(F$383:F$385)10.4321110.60137634230141210.62109194556663310.64134502677414710.66212904133343810.6834375243440710.76912035189938910.85531495330589610.94201509695847511.029214627131037
45INDEX(Vectors[Description], MATCH($B388, Vectors[Code], 0))Electricity (delivered to end user)F$387*$F$208:$F$2114.1728440000000004G$387*$F$208:$F$2114.2405505369205647H$387*$F$208:$F$2114.2484367782266537I$387*$F$208:$F$2114.2565380107096589J$387*$F$208:$F$2114.2648516165333756K$387*$F$208:$F$2114.2733750097376282L$387*$F$208:$F$2114.3076481407597553M$387*$F$208:$F$2114.3421259813223587N$387*$F$208:$F$2114.37680603878339O$387*$F$208:$F$2114.4116858508524146
47INDEX(Vectors[Description], MATCH($B389, Vectors[Code], 0))Solid hydrocarbons0.83456880.848110107384112970.84968735564533060.85130760214193180.85297032330667510.854675001947525660.861529628151951110.868425196264471680.875361207756678030.88233717017048297
49INDEX(Vectors[Description], MATCH($B390, Vectors[Code], 0))Liquid hydrocarbons3.44259629999999993.49845419295946643.5049603420369893.51164385883546843.51850258364003483.52553438303354313.55380971612679853.58225393459094613.6108649819962973.6396408269532423
50INDEX(Vectors[Description], MATCH($B391, Vectors[Code], 0))Gaseous hydrocarbons1.98210090000000012.01426150503726832.01800746965766022.02185555508708782.02580451785335352.02985312962537322.0461328668608842.06250984112812042.07898286842211012.0955507791548968
|
511602007201020152020202520302035204020452050
|
1062
104010621060SUM(F$388:F$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.4824028309999999SUM(G$388:G$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5064555782410307SUM(H$388:H$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5092571654650184SUM(I$388:I$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5121351283046061SUM(J$388:J$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5150885367734817SUM(K$388:K$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5181164722092921SUM(L$388:L$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5302920020049031SUM(M$388:M$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5425402548647678SUM(N$388:N$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5548603452777991SUM(O$388:O$391*SUMIFS(EF[CO2],EF[Vector], $B$388:$B$391))1.5672513985153202
10411062SUM(F$388:F$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.5576655538874478E-3SUM(G$388:G$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.5991649910230654E-3SUM(H$388:H$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6039987129973896E-3SUM(I$388:I$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6089642097343432E-3SUM(J$388:J$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6140598766808952E-3SUM(K$388:K$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6192841288218225E-3SUM(L$388:L$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6402911941804047E-3SUM(M$388:M$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.661423732367644E-3SUM(N$388:N$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.6826802155658939E-3SUM(O$388:O$391*SUMIFS(EF[CH4],EF[Vector], $B$388:$B$391))2.7040591345609513E-3
10421062SUM(F$388:F$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.8548175243751668E-2SUM(G$388:G$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.884912891274821E-2SUM(H$388:H$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.8884183035490356E-2SUM(I$388:I$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.8920192788020086E-2SUM(J$388:J$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.8957146534128437E-2SUM(K$388:K$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.8995032779294534E-2SUM(L$388:L$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.9147375891174701E-2SUM(M$388:M$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.9300628931255111E-2SUM(N$388:N$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.9454780819811356E-2SUM(O$388:O$391*SUMIFS(EF[N2O],EF[Vector], $B$388:$B$391))1.9609820612031096E-2
|
2162
104114901061(F$266+F$268)*F$299/100000015.56099999999999815.27287715721293414.8044786685117914.35044532803773313.91033657612082113.4837253644604113.07019774174972912.66935245200879512.28080054523591311.904164999999955
10411491F$370*$F$371*(1-F$372)*F$300/10004.46573259999999914.04944653214217182.20259186805874490.43129546804559360.422265657687669440.413424899803376820.404769236298761330.39629479194843670.387997772660608090.37987446377841982
10421512F$31023.28G$31022.83633055363073122.115591632724669I$31021.41759999999999321.16011196762400520.90571952424103220.65438545386427920.40607298792734920.16074579990524319.918368000000019
1513F401+F402+F40343.306732599999997G401+G402+G40342.15865424298583339.122662169295204I401+I402+I40336.1993407960833235.49271420143249134.80286978850482234.12935243191277133.47172023188458232.8295441178017632.202407463778393
|
1418
216421631061INDEX(F$88:F$91, MATCH($E$9, $C$88:$C$91, 0))-14.183165399999998-10.5326948133333-7.5910687149999996-4.7967910199999997-2.69593621666667-2.5354317183333399-3.0805327149999902-5.2834375800000002-7.4420078616666601-8.8947345183333706
21652166(F$253+F$254)*$F$16415.28834999999999915.80227805900452515.17404587864049514.57133598167270313.99311151107584213.43837773272058712.90618032410757412.39560373262224511.905769600486611.43583525369827
21672168F$257*$F$165-7.9670500000000004-7.7791220872264111-7.6631332796915448-7.5488738965470912-7.4363181516090657-7.3254406431725796-7.2162163482789143-7.1086206170684783-7.0026291672176901-6.8982180784589779
21691460$F$1706.3298100000000002$F$1706.32981000000000026.32981000000000026.32981000000000026.32981000000000026.32981000000000026.32981000000000026.32981000000000026.32981000000000026.3298100000000002
2173123$F$171-1.29274$F$171-1.29274-1.29274-1.29274-1.29274-1.29274-1.29274-1.29274-1.29274-1.29274
2172SUM(F$407:F$411)-1.8247953999999991SUM(G$407:G$411)2.52753115844481354.95691388394895067.26274106512561178.89792714280010528.61457537121466827.64650126082866955.04061553555376652.498202571602250.67995265690592199
|
43327
|
2338
17992007201020152020202520302035204020452050
2221Preferences.moneyunits&"/yr"£m/yr$F$220*F$33842.87059916070873612.74192935493608313.47519910296698114.25066689718065615.07076114145771115.93804998893115316.85524938424564917.82523156863092618.85103407442326419.935869237201761
2215$F$221*F$35113.84001657859289384.049626954211618332.52274001162954598.69973773390041883.678507106742591188.62236257615471600.48271412754732043.5915836408032520.00146699765043031.8924160833117
1509$F$222*F$3599.553911566241840316.45656593933595631.609110929719936151.79033280266313291.57846567952726280.0638618327875269.01704520191726258.41901166986293248.25152917244503238.49710633328141
1510$F$223*(F$364+F$368)7.997503761019582513.31066391718992926.5596311082374976.502290896611754129.25137275623254258.00917170332605290.51340957463458341.5728083444202401.52121101448557435.90370715921586
1511$F$224*F$3743.059560875815978215.27706352830221376.212789574928692136.87317214145483136.56402289018919136.25557190037293135.94781759487444135.64075840012433135.33439274610731135.02871906635431
3468SUM(F418:F422)77.32159194237903SUM(G418:G422)141.8358496939758480.37947072748267978.116200471810661456.14312957414931878.88901800157242312.81623588321872797.04939362384133323.95963400511163861.2578178793651
|
18012007201020152020202520302035204020452050
2221Preferences.moneyunits&"/yr"£m/yr$G$220*F$338128.6117974821262138.22578806480824240.4255973089009442.75200069154196645.21228342437312647.81414996679345850.56574815273694453.47569470589277156.55310222326978959.807607711605279
2215$G$221*F$35122.887783649362763138.99619748383472549.90602711064491990.093472097336641461.37415164189841965.6718849251092646.7816629754733379.56835300154944167.42624874680685013.9605883704626
1509$G$222*F$35937.62611270189617664.810795078691527124.4859722640513597.794958587620611148.32172508997111102.97382972259331059.46821794584481017.7300459593513977.68751053394874939.27172548678891
1510$G$223*(F$364+F$368)15.99500752203916526.62132783437985953.119262216474979153.00458179322351258.50274551246508516.01834340665209581.02681914926916683.14561668884039803.04242202897115871.80741431843171
1511$G$224*F$37415.30686974463786376.43058301492826381.28976354745799684.77141084695256683.22474859284284681.6815797149028680.14189632280136678.60569054402936677.07295452385836675.54368042530143
3468SUM(F426:F430)220.42757110006218SUM(G426:G430)345.084691476642661149.22662244753022468.41642401667513596.63565426155044314.15978773605095017.98434454612565812.52540089966266681.7822380568557560.3910163125902
|
3469
|
34702007201020152020202520302035204020452050
15123471$F403-F40300.44366944636927031.16440836727533181.8624000000000082.11988803237599652.37428047575896882.62561454613572212.87392701207265233.11925420009475833.3616319999999824
3472Preferences.moneyunits&"/yr"£m/yrIF(F$436<$E$229,F$436*$F$229,($E$229*$F$229)+((F$436-$E$229)*$F$230))0000010.2825480697791525.11125822200759239.7616937122864854.23599780559072868.536287999998947
3473Preferences.moneyunits&"/yr"£m/yrIF(F$436<$E$229,F$436*$G$229,($E$229*$G$229)+((F$436-$E$229)*$G$230))026.17649733578694868.70009366924458109.88160000000047125.0733939101838205.08916552787446313.66548393063186420.93646921538573526.91781444093544631.62502399999232
|
34743475($F$299-F299)/10000($F$299-G299)/10003.4034755175388226E-38.9908764382186628E-31.447368059499945E-21.9853846050882792E-22.5133294213714123E-23.0313910522371316E-23.5397545120107621E-24.0386013515289788E-24.528109722976683E-23476
3472Preferences.moneyunits&"/yr"£m/yrF$440*$F$235*(F$266+F$268)/10000G$440*$F$235*(G$266+G$268)/1000000000000
3473Preferences.moneyunits&"/yr"£m/yrF$440*$G$235*(F$266+F$268)/10000G$440*$G$235*(G$266+G$268)/1000294.6744125388646768.955462179863961222.80583661097851656.92377703125292071.98523795946312468.64458136126182847.5352493589933209.27041618263593554.4436200000232
|
34773478($F$300-F300)/10000($F$300-G300)/10005.4612102724697137E-31.4426743048356911E-22.3224440057972459E-23.1857443205444612E-24.0328835578108339E-24.8641642547562411E-25.679883285011425E-26.4803319646998883E-27.2657961564750448E-23479
3472Preferences.moneyunits&"/yr"£m/yrF$444*$F$240*F370*($F$371*F$372)0G$444*$F$240*G370*($F$371*G$372)4.617606046163502E-20.60853316175045181.75934770744311212.40788263230506643.04129150346944373.65989450373388754.26400510449702894.85393020628941585.4299702763621722
3473Preferences.moneyunits&"/yr"£m/yrF$444*$G$240*F370*($F$371*F$372)0G$444*$G$240*G370*($F$371*G$372)0.359147136923827944.733035702503513213.68381550233531418.72797602903940723.65448947142900228.46584614015245833.16448414608800737.7527904933621242.233102149483557
|
|
683
|
729Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
45INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F$388-4.1728440000000004-G$388-4.2405505369205647-4.2484367782266537-4.2565380107096589-4.2648516165333756-4.2733750097376282-4.3076481407597553-4.3421259813223587-4.37680603878339-4.4116858508524146
47INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbons-F$389-0.8345688-G$389-0.84811010738411297-0.8496873556453306-0.8513076021419318-0.8529703233066751-0.85467500194752566-0.86152962815195111-0.86842519626447168-0.87536120775667803-0.88233717017048297
49INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F$390-3.4425962999999999-G$390-3.4984541929594664-3.504960342036989-3.5116438588354684-3.5185025836400348-3.5255343830335431-3.5538097161267985-3.5822539345909461-3.610864981996297-3.6396408269532423
50INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-F$391-1.9821009000000001-G$391-2.0142615050372683-2.0180074696576602-2.0218555550870878-2.0258045178533535-2.0298531296253732-2.046132866860884-2.0625098411281204-2.0789828684221101-2.0955507791548968
13INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))IndustryF$38710.43211G$38710.60137634230141210.62109194556663310.64134502677414710.66212904133343810.6834375243440710.76912035189938910.85531495330589610.94201509695847511.029214627131037
2216INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Energy crops (first generation)F$3384.0592999999999995G$3381.20649850580807571.27592981646047891.34935674490743681.4270092300829861.50913044339636551.59597755023158941.687822515269631.78495295415510321.887673034174483
1772INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Energy crops (second generation)F$3510.82222222222222219G$3514.993308400954732419.75485973439357335.5681820182817652.49849967428237170.61492410724818695.083155888242274121.40783240207686149.71089047703489180.12184492225322
753INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Dry biomass and wasteF$3772.5090388219999995G$3774.28403194720046988.309268669042287735.75564983291513267.24583300576399875.46485402573243675.95552733765562478.040913494473680.93221103885272881.826989436377801
916INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wet biomass and wasteF$3780.97210936666666681G$3784.853956876103527724.21496731481931543.48849331151211643.39026781607294943.29226417812342543.19448189656404943.09692047142715442.99957940387429342.902458196193756
1012INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Agriculture-(F$351+F$338)-4.8815222222222214-(G$351+G$338)-6.1998069067628077-21.030789550854053-36.917538763189199-53.925508904365358-72.124054550644544-96.679133438473869-123.09565491734649-151.49584343119-182.00951795642769
54INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Waste-(F$377+F$378)-3.4811481886666664-(G$377+G$378)-9.1379888233039974-32.524235983861601-79.244143144427255-110.63610082183695-118.75711820385587-119.15000923421968-121.13783396590075-123.93179044272702-124.72944763257155
148SUBTOTAL(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])0
|
|
889
|
10581061
|
10571027442691692720721722723724725726727
10401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$3961.4824028309999999G$3961.50645557824103071.50925716546501841.51213512830460611.51508853677348171.51811647220929211.53029200200490311.54254025486476781.55486034527779911.5672513985153202
10411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$3972.5576655538874478E-3G$3972.5991649910230654E-32.6039987129973896E-32.6089642097343432E-32.6140598766808952E-32.6192841288218225E-32.6402911941804047E-32.661423732367644E-32.6826802155658939E-32.7040591345609513E-3
10421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$3981.8548175243751668E-2G$3981.884912891274821E-21.8884183035490356E-21.8920192788020086E-21.8957146534128437E-21.8995032779294534E-21.9147375891174701E-21.9300628931255111E-21.9454780819811356E-21.9609820612031096E-2
10414INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))AgricultureF$401+F$40220.026732599999995G$401+G$40219.32232368935510517.00707053657053414.78174079608332614.3326022338084913.89715026426378813.4749669780484913.06564724395723212.6687983178965212.284039463778374
10424INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))AgricultureF$40323.28G$40322.83633055363073122.11559163272466921.41759999999999321.16011196762400520.90571952424103220.65438545386427920.40607298792734920.16074579990524319.918368000000019
10405INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Land Use, Land-Use Change and ForestryF412-1.8247953999999991G4122.52753115844481354.95691388394895067.26274106512561178.89792714280010528.61457537121466827.64650126082866955.04061553555376652.498202571602250.67995265690592199
148SUBTOTAL(109,[2007])42.985445871797637SUBTOTAL(109,[2010])46.214089273575453SUBTOTAL(109,[2015])45.610321400457657SUBTOTAL(109,[2020])44.995746146511294SUBTOTAL(109,[2025])45.927301087416893SUBTOTAL(109,[2030])44.957175948836898SUBTOTAL(109,[2035])43.327933361831697SUBTOTAL(109,[2040])40.076838074966744SUBTOTAL(109,[2045])36.904744495717189SUBTOTAL(109,[2050])34.471925398946226
|
|
2613
|
2997
|
782614442691692720721722723724725726727
26152998Preferences.AreaUnitskm^2F254+F255+F2563639.4G254+G255+G2561943.09412877360094550.04397286129017081.55419183146029540.689562611700211930.39035385429115003.4773841543918012.65687477539920960.52510522969923849.572879723499
|
2999
|
782614442691692720721722723724725726727
26153000Preferences.AreaUnitskm^2F25924369.699999999997G25924711.43999999999925815.04000000000126918.63999999999928022.24000000000229125.83999999999730229.43999999999931333.04000000000132436.64000000000333540.239999999998
|
3189
|
3190
|
78418442691692720721722723724725726727
3133INDEX(CostVectors[Description], MATCH(C500, CostVectors[Code], 0))Low estimate of operating costsF437+F441+F4450G437+G441+G4454.617606046163502E-20.60853316175045181.75934770744311212.407882632305066413.32383957324859328.7711527257414844.0256988167835159.08992801188014773.966258276361117
3135INDEX(CostVectors[Description], MATCH(C501, CostVectors[Code], 0))Low estimate of fuel costsF42377.32159194237903G423141.8358496939758480.37947072748267978.116200471810661456.14312957414931878.88901800157242312.81623588321872797.04939362384133323.95963400511163861.2578178793651
3142INDEX(CostVectors[Description], MATCH(C502, CostVectors[Code], 0))High estimate of operating costsF438+F442+F4460G438+G442+G446321.21005701157537842.388591551611971346.37125211331431800.72514697047612300.72889295876672810.77591143204613301.63620272046683773.94102111693344228.3017461494992
3144INDEX(CostVectors[Description], MATCH(C503, CostVectors[Code], 0))High estimate of fuel costsF431220.42757110006218G431345.084691476642661149.22662244753022468.41642401667513596.63565426155044314.15978773605095017.98434454612565812.52540089966266681.7822380568557560.3910163125902
|