956INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Fossil fuel production
975INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Indigenous fossil-fuel production3214
|
1338
|
150384687
|
784184422007201020152020202520302035204020452050
642196109124.39570139421789127.93127.93127.93127.9363.96500000000000363.96500000000000363.96500000000000363.96500000000000363.965000000000003
651417109975.89120834979815802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.70336000383915
3848838.80929321419171637.88198465125163508.98355251965154404.31570071063896321.17184343559597255.12576641104135202.66146618133868160.98597351628524127.88066797955751101.5831683077875
663847109828.54657487902409645.77289588411463495.88758312334966383.12064593855996296.45145258994444229.38848290828395177.49643535647462137.34335815304101106.2736724310583382.232541885272198
|
150384987
|
784184422007201020152020202520302035204020452050
642196109124.39570139421789127.93108.4647065422744894.92292827872347585.50207064113148259.48279609610214241.38148941750169728.78862089206695220.02790872279796413.933183159852558
651417109975.89120834979815802.54795283721205558.32327659437317388.41900983617211270.21858755804715187.98792853280705130.7810154490734690.98283137316397563.29569759229330144.034080641688455
3848773.86250093700858603.15188475576315419.60575114595827291.91484076363321203.08175954532109141.281618132659198.28797853077489368.37780350586815847.56964261731322833.093647100622412
663847109730.52620088453602569.37537920944044396.10782908178459275.56760968086974191.70918101078311133.369847517230292.78385173305149264.54864650953953744.90574263074368831.240402862987555
|
150385087
|
784184422007201020152020202520302035204020452050
642196109124.39570139421789127.9375.54138570000000644.60643284199301226.33965252886845615.5533014217715389.18406895654187675.42310087814841423.20228683753785731.8909183546977297
651417109975.89120834979815802.54795283721205473.89654067084547279.8311683007276165.2375065698966897.57109525445829957.6147560368050934.02093729217304520.0890232616552611.862367345774818
3848773.86250093700858603.15188475576315356.15515642943069210.30605832001456124.1836243773854173.32918835860232343.30015243387109125.56830701067654115.0978296067343928.9151174044805934
663847109730.52620088453602569.37537920944044336.21046766938258198.52891905409373117.2293414122518369.22275381052058740.87534389757431124.13648181807865414.2523511487572658.4158708298296805
|
717
109886
|
|
784
|
150Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
64INDEX(Vectors[Description], MATCH($C40, Vectors[Code], 0))Coal and fossil waste109124.39570139421789127.93127.93127.93127.9363.96500000000000363.96500000000000363.96500000000000363.96500000000000363.965000000000003
65INDEX(Vectors[Description], MATCH($C41, Vectors[Code], 0))Oil and petroleum products109975.89120834979815802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.70336000383915
66INDEX(Vectors[Description], MATCH($C42, Vectors[Code], 0))Natural gas109828.54657487902409645.77289588411463495.88758312334966383.12064593855996296.45145258994444229.38848290828395177.49643535647462137.34335815304101106.2736724310583382.232541885272198
|
9821563
|
784184422007201020152020202520302035204020452050
45INDEX(Vectors[Description], MATCH($C47, Vectors[Code], 0))Electricity (delivered to end user)118-'2007 (Actual, frozen)'!$T$47/$F$407.9024278455408197E-3$F477.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-37.9024278455408197E-3
47INDEX(Vectors[Description], MATCH($C48, Vectors[Code], 0))Solid hydrocarbons118-'2007 (Actual, frozen)'!$V$47/$F$403.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-43.5927666752850644E-4
50INDEX(Vectors[Description], MATCH($C49, Vectors[Code], 0))Gaseous hydrocarbons118-'2007 (Actual, frozen)'!$X$47/$F$407.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-47.3153653205117761E-4
|
9801563
|
78418442691692720721722723724725726727
45INDEX(Vectors[Description], MATCH($C54, Vectors[Code], 0))Electricity (delivered to end user)117-'2007 (Actual, frozen)'!$T$46/$F$415.7422811010645301E-4$F545.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-45.7422811010645301E-4
50INDEX(Vectors[Description], MATCH($C55, Vectors[Code], 0))Gaseous hydrocarbons117-'2007 (Actual, frozen)'!$X$46/XV.b!$F$416.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-26.5816549762543738E-2
|
11861188
|
784184422007
116611874400.12572918863103702
119011914405.0916819860234304
|
717
1091024
1025
1026
|
117981
118983
4401192
1189
|
|
3170
|
32081799180117991801
14132043283Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh(F77*(GBP/(Constants.GCV.Coal*1000)))*(Price2009)4.5424816073855068(G77*(GBP/(Constants.GCV.Coal*1000)))*(Price2009)11.782061669156159
202320560153Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh(F78*(USD2009_/Unit.boe))*(Price2009)23.703076768209044(G78*(USD2009_/Unit.boe))*(Price2009)60.442845758933061
14320635121Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh((F79/100)*(GBP/Unit.therm))*(Price2009)12.290626819799765((G79/100)*(GBP/Unit.therm))*(Price2009)42.490452719879187
|
32093201
|
|
731
1990
2991
31185
43220
11157
992Preferences.EnergyUnitsTWhF$40124.39570139421789G$40127.93127.93127.93127.9363.96500000000000363.96500000000000363.96500000000000363.96500000000000363.965000000000003
993F$92*F$470.983028054563248491.01095759428003711.01095759428003711.01095759428003711.01095759428003710.505478797140018530.505478797140018530.505478797140018530.505478797140018530.50547879714001853
997F$92*F$484.4692473051785787E-24.5962264076921833E-24.5962264076921833E-24.5962264076921833E-24.5962264076921833E-22.2981132038460916E-22.2981132038460916E-22.2981132038460916E-22.2981132038460916E-22.2981132038460916E-2
994F92*F$499.0999999999999998E-29.3585468545307152E-29.3585468545307152E-29.3585468545307152E-29.3585468545307152E-24.6792734272653576E-24.6792734272653576E-24.6792734272653576E-24.6792734272653576E-24.6792734272653576E-2
|
21158
995F$41975.89120834979815G$41802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.70336000383915
996F$42828.54657487902409G$42645.77289588411463495.88758312334966383.12064593855996296.45145258994444229.38848290828395177.49643535647462137.34335815304101106.2736724310583382.232541885272198
993F$98*F$540.560384164240207320.460845594227515090.371427304384478850.288141320472576180.22295826108775790.172520852287855020.133493346821595440.103294607053626747.9927397884649393E-26.1846296867119496E-2
994F$98*F$5564.22979227718343552.82093727473797242.57204276825913133.02601740275768825.55490270779715119.77389657496056315.30066422980101811.8393623121081459.16107286926520467.0886635532858424
|
31160
12291061(F$92/$F$92)*$F$60*GWP.CH42.64031296125177752.71532885258236292.71532885258236292.71532885258236292.71532885258236291.35766442629118141.35766442629118141.35766442629118141.35766442629118141.3576644262911814
12301060(F$98/$F$98)*$F$615.09168198602343044.18726894905739933.37480934604183162.61806821909111112.02581128100727481.56753415221588451.21292804586487460.938540600449365380.726224825697522670.56193892646400301
1231
10401060F$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.818281779001751G$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))9.7190524585517846H$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))7.8332558693596788I$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))6.0767872021074139J$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))4.7021020982346746K$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))3.6383969697927432L$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))2.815322218283387M$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))2.1784426654278981N$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))1.6856374079447973O$101*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))1.3043140938045947
1041F$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))2.3689576922962512E-2G$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.948170175162451E-2H$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.5701649439781581E-2I$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.2180833099154388E-2J$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))9.42529645499471E-3K$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))7.2931147271612312E-3L$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))5.6432731508778726E-3M$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))4.3666571892548578E-3N$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))3.3788360936427377E-3O$101*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))2.6144789601977142E-3
1042F$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))2.5479291685726012E-2G$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))2.0953517366653133E-2H$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.6887887332231039E-2I$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.3101078188005414E-2J$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.0137364562575628E-2K$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))7.8440994550090445E-3L$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))6.0696146301401355E-3M$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))4.6965520987735489E-3N$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))3.634102486006588E-3O$101*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))2.8119992285932571E-3
|
43220
|
1799691692720721722723724725726727
141Preferences.moneyunits£mF92*$J77565.06518562105441G92*$J77581.11967203282791581.11967203282791581.11967203282791581.11967203282791290.55983601641395290.55983601641395290.55983601641395290.55983601641395290.55983601641395
202Preferences.moneyunits£mF98*$J7823131.624228935554G98*$J7819022.85573626944815331.83373416207411893.9420050133949203.30559520989127121.34243156050345510.35902295141394263.81077074092813299.2554955065122552.9010103650548
14Preferences.moneyunits£mF99*$J7910183.356754661369G99*$J797936.95367365306086094.76922874152664708.79288619147523643.574173970572819.3282401857352181.54244881114211688.03596123713061306.17004861978031010.689484755434
148Preferences.moneyunits£mSUM(F114:F116)33880.046169217974SUM(G114:G116)27540.92908195533522007.72263493642817183.85456323769913427.99944121328910231.2305077626527982.461307778976242.40656799447244895.98538014270623854.1503311369029
|
1801691692720721722723724725726727
141Preferences.moneyunits£mF92*$K771465.63782520461G92*$K771507.27914933514741507.27914933514741507.27914933514741507.2791493351474753.6395746675737753.6395746675737753.6395746675737753.6395746675737753.6395746675737
202Preferences.moneyunits£mF98*$K7858985.641783785657G98*$K7848508.28212748709539096.17602211328630329.55211278415323468.42926778522518159.42320047928314051.41550852610610872.7174653893678413.10151354160556509.8975764308898
14Preferences.moneyunits£mF99*$K7935205.319066115015G99*$K7927439.18270034343721070.48790507784716278.96969226195712596.356430012549746.82048749925347541.90389446137765835.78146599122284515.6164537998123494.0979330116434
148Preferences.moneyunits£mSUM(F120:F122)95656.598675105284SUM(G120:G122)77454.74397716567961673.9430765262848115.80095438125937572.06484713291128659.88326264610822346.95897765505717462.13850604816313682.35754200899110757.635084110107
3213
|
683
|
Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
13INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))IndustryF$93+F$94+F$95+F$100+F$10165.908896969038679G$93+G$94+G$95+G$100+G$10154.43228819586775644.09397539954587634.46466405013253426.92836629578717520.52167009069955116.00941024007374812.5179095826129059.81625293060098697.7257625136040948
45INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-(F$93+F$100)-1.5434122188034558-1.4718031885075522-1.382384898664516-1.2990989147526133-1.2339158553677949-0.6779996494278735-0.63897214396161395-0.60877340419364523-0.58540619502466795-0.56732509400713804
47INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbons-F$94-4.4692473051785787E-2-4.5962264076921833E-2-4.5962264076921833E-2-4.5962264076921833E-2-4.5962264076921833E-2-2.2981132038460916E-2-2.2981132038460916E-2-2.2981132038460916E-2-2.2981132038460916E-2-2.2981132038460916E-2
50INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-(F$95+F$101)-64.320792277183429-52.914522743283278-42.665628236804437-33.119602871302995-25.648488176342457-19.820689309233217-15.347456964073672-11.886155046380798-9.2078656035378579-7.1354562875584957
64INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Coal and fossil wasteF$92124.39570139421789127.93127.93127.93127.9363.96500000000000363.96500000000000363.96500000000000363.96500000000000363.965000000000003
65INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Oil and petroleum productsF$98975.89120834979815802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.70336000383915
66INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Natural gasF$99828.54657487902409645.77289588411463495.88758312334966383.12064593855996296.45145258994444229.38848290828395177.49643535647462137.34335815304101106.2736724310583382.232541885272198
985INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Coal reserves-F$92-124.39570139421789-127.93-127.93-127.93-127.93-63.965000000000003-63.965000000000003-63.965000000000003-63.965000000000003-63.965000000000003
986INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Oil reserves-F$98-975.89120834979815-802.54795283721205-646.82884353331633-501.7889500727494-388.27472421443264-300.43958011019754-232.47441995977493-179.88427462124332-139.19102265793308-107.70336000383915
987INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gas reserves-F$99-828.54657487902409-645.77289588411463-495.88758312334966-383.12064593855996-296.45145258994444-229.38848290828395-177.49643535647462-137.34335815304101-106.27367243105833-82.232541885272198
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
10401049INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fugitive Emissions from FuelsF$1055.0916819860234304G$1054.18726894905739933.37480934604183162.61806821909111112.02581128100727481.56753415221588451.21292804586487460.938540600449365380.726224825697522670.56193892646400301
10411049INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fugitive Emissions from FuelsF$1042.6403129612517775G$1042.71532885258236292.71532885258236292.71532885258236292.71532885258236291.35766442629118141.35766442629118141.35766442629118141.35766442629118141.3576644262911814
10401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$10711.818281779001751G$1079.71905245855178467.83325586935967886.07678720210741394.70210209823467463.63839696979274322.8153222182833872.17844266542789811.68563740794479731.3043140938045947
10411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$1082.3689576922962512E-2G$1081.948170175162451E-21.5701649439781581E-21.2180833099154388E-29.42529645499471E-37.2931147271612312E-35.6432731508778726E-34.3666571892548578E-33.3788360936427377E-32.6144789601977142E-3
10421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$1092.5479291685726012E-2G$1092.0953517366653133E-21.6887887332231039E-21.3101078188005414E-21.0137364562575628E-27.8440994550090445E-36.0696146301401355E-34.6965520987735489E-33.634102486006588E-32.8119992285932571E-3
148SUBTOTAL(109,[2007])19.599445594885648SUBTOTAL(109,[2010])16.662085479309823SUBTOTAL(109,[2015])13.955983604755886SUBTOTAL(109,[2020])11.43546618506805SUBTOTAL(109,[2025])9.4628048928418824SUBTOTAL(109,[2030])6.5787327624819794SUBTOTAL(109,[2035])5.3976275782204608SUBTOTAL(109,[2040])4.4837109014564733SUBTOTAL(109,[2045])3.7765395985131511SUBTOTAL(109,[2050])3.2293439247485702
|
2613
|
2618
|
782614442691692720721722723724725726727
2615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0
2621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units
|
|
3189
|
3190
|
78418442691692720721722723724725726727
3135INDEX(CostVectors[Description], MATCH(C173, CostVectors[Code], 0))Low estimate of fuel costsF11733880.04616921797427540.92908195533522007.72263493642817183.85456323769913427.99944121328910231.2305077626527982.461307778976242.40656799447244895.98538014270623854.1503311369029
3144INDEX(CostVectors[Description], MATCH(C174, CostVectors[Code], 0))High estimate of fuel costsF12395656.59867510528477454.74397716567961673.9430765262848115.80095438125937572.06484713291128659.88326264610822346.95897765505717462.13850604816313682.35754200899110757.635084110107
|