957INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Fossil fuel production
959INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Petroleum refineries
682
|
2202Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
988INDEX(Vectors[Description], MATCH(XV.a.Inputs[Vector], Vectors[Code], 0))Oil reservesINDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-975.89120834979803INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-815.4323959706519INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-664.52033513004915INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-527.86775447758896INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-419.31653778914142INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-333.08789440544865INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-264.59138956080642INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-210.18056977027507INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-166.95884163987617INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH(XV.a.Inputs[Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-132.62526993906516
|
|
784
|
2200Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
65INDEX(Vectors[Description], MATCH($C17, Vectors[Code], 0))Oil and petroleum products109'DUKES 09 (1.2)'!$D$6*Unit.ktoe728.16207538608637$F17728.16207538608637$F17728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637
|
2203Preferences.EnergyUnitsTWh
|
784184422007
65INDEX(Vectors[Description], MATCH($C22, Vectors[Code], 0))Oil and petroleum products109-'DUKES 09 (1.2)'!$D$7*Unit.ktoe648.41809848088474
|
22092207
|
784184422007201020152020202520302035204020452050
34INDEX(Vectors[Description], MATCH($C27, Vectors[Code], 0))Conversion losses-'2007 (Actual, frozen)'!$AY$116/'2007 (Actual, frozen)'!$AH$116-3.1480490285906312E-3000000000
|
22082206
|
784184422007201020152020202520302035204020452050
45INDEX(Vectors[Description], MATCH($C32, Vectors[Code], 0))Electricity (delivered to end user)-'2007 (Actual, frozen)'!$T$116/'2007 (Actual, frozen)'!$W$1186.4826118636814581E-3$F326.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-36.4826118636814581E-3
49INDEX(Vectors[Description], MATCH($C33, Vectors[Code], 0))Liquid hydrocarbons-'2007 (Actual, frozen)'!$W$119/'2007 (Actual, frozen)'!$W$1185.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-25.3133991275655136E-2
50INDEX(Vectors[Description], MATCH($C34, Vectors[Code], 0))Gaseous hydrocarbons-'2007 (Actual, frozen)'!$X$119/'2007 (Actual, frozen)'!$W$1182.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-32.3637521989818468E-3
751INDEX(Vectors[Description], MATCH($C35, Vectors[Code], 0))Heat transport-'2007 (Actual, frozen)'!$Z$119/'2007 (Actual, frozen)'!$W$1187.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-47.6125932374258029E-4
|
|
717
109960
117785
118783
|
813
|
2212Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
65INDEX(Vectors[Description], MATCH($C49, Vectors[Code], 0))Oil and petroleum products-INDIRECT("XV.a.Inputs["&F$53&"]")975.89120834979803-INDIRECT("XV.a.Inputs["&G$53&"]")815.4323959706519664.52033513004915527.86775447758896419.31653778914142333.08789440544865264.59138956080642210.18056977027507166.95884163987617132.62526993906516
|
2205Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
65INDEX(Vectors[Description], MATCH($C54, Vectors[Code], 0))Oil and petroleum products$F$22/$F$49*F$49648.41809848088474$F$22/$F$49*G$49541.80334765909708441.5318105340076350.73479777168609278.60936728242984221.31587749683558175.80427431408637139.65171959948717110.9336099090005488.121119043402715
|
442
1092204
|
731
2195
2201
2196
2197
|
12210
21185
31162
|
122112007201020152020202520302035204020452050
|
2212F$49975.89120834979803G$49815.4323959706519664.52033513004915527.86775447758896419.31653778914142333.08789440544865264.59138956080642210.18056977027507166.95884163987617132.62526993906516
4F$17728.16207538608637G$17728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637
151-F54-648.41809848088474-G54-541.80334765909708-441.5318105340076-350.73479777168609-278.60936728242984-221.31587749683558-175.80427431408637-139.65171959948717-110.93360990900054-88.121119043402715
2213SUM(F72:F74)1055.6351852549997SUM(G72:G74)1001.7911236976412951.1505999821278905.29503209198924868.86924589279795839.93409229469944816.94919063280645798.69092555687428784.18730711696196772.66622628174889
|
21186
961Preferences.EnergyUnitsTWhF$751055.6351852549997G$751001.7911236976412951.1505999821278905.29503209198924868.86924589279795839.93409229469944816.94919063280645798.69092555687428784.18730711696196772.66622628174889
85820F$27*F78-3.3231913194880929G$27*G78000000000
836962F78-F791058.9583765744878G78-G791001.7911236976412951.1505999821278905.29503209198924868.86924589279795839.93409229469944816.94919063280645798.69092555687428784.18730711696196772.66622628174889
|
963Preferences.EnergyUnitsTWh
786F$80*F$326.86481613512663196.49422302341310786.16594016359187875.86867631517141595.63254208141261445.44496671142013525.2959645152211965.17760326942971725.08358194046483285.0088952451600477
787F$80*F$3356.26668514219075953.22916082657922550.53842768128452448.1019383370696946.16649093095298244.62905073211187843.4077711677370642.43763667048388341.66700153483215341.054840526247823
788F$80*F$342.50311519125819222.36798597156079452.24828432227065772.13989312283478132.05379159060680031.98539605766141741.93106544581473631.88790743159190821.85362447161137171.8263914914524892
789F$80*F$350.806141937622635310.76262283335738590.72407226251974410.689164283917865220.661434814549077040.639407659088600870.621910188393178580.60801091386876160.596969899103373610.58819936889797564
|
31163
1187
10431064F$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+F$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))14.527244480739197G$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+G$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))13.742999625411992H$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+H$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))13.048291235618931I$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+I$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))12.419224918869022J$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+J$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.919520385409896K$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+K$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.522575557637671L$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+L$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.207258833964177M$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+M$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.956784135033882N$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+N$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.757817286484531O$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+O$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.599766165989214P$84*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+P$85*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0
10441064F$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+F$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.8436162606187682E-2G$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+G$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.7440897076303603E-2H$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+H$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.6559260035288102E-2I$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+I$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.5760927707292011E-2J$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+J$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.5126765182794258E-2K$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+K$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.4623012430495181E-2L$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+L$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.4222851863375775E-2M$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+M$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3904980687989605E-2N$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+N$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3652476837176053E-2O$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+O$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3451898113426678E-2P$84*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+P$85*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0
10451064F$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+F$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.2540812001173906G$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+G$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.2403647741088922H$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+H$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.22821433899752142I$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+I$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.21721198236167366J$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+J$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.20847216059205098K$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+K$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.20152960391143082L$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+L$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.19601472105293236M$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+M$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.19163392384203468N$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+N$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18815399784987419O$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+O$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18538968707995557P$84*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+P$85*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0
|
|
683
|
Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
45INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)-F$83-6.8648161351266319-G$83-6.4942230234131078-6.1659401635918787-5.8686763151714159-5.6325420814126144-5.4449667114201352-5.295964515221196-5.1776032694297172-5.0835819404648328-5.0088952451600477
49INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbons-F$84-56.266685142190759-G$84-53.229160826579225-50.538427681284524-48.10193833706969-46.166490930952982-44.629050732111878-43.40777116773706-42.437636670483883-41.667001534832153-41.054840526247823
50INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbons-F$85-2.5031151912581922-G$85-2.3679859715607945-2.2482843222706577-2.1398931228347813-2.0537915906068003-1.9853960576614174-1.9310654458147363-1.8879074315919082-1.8536244716113717-1.8263914914524892
751INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Heat transport-F86-0.80614193762263531-G86-0.7626228333573859-0.7240722625197441-0.68916428391786522-0.66143481454907704-0.63940765908860087-0.62191018839317858-0.6080109138687616-0.59696989910337361-0.58819936889797564
65INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Oil and petroleum products-F$78+F$803.3231913194881599-G$78+G$80000000000
34INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Conversion lossesF$79-3.3231913194880929G$79000000000
35INDEX(Vectors[Description], MATCH(XV.a.Outputs[Vector], Vectors[Code], 0))Distribution losses and own useF$83+F$84+F$85+F$8666.440758406198228G$83+G$84+G$85+G$8662.85399265491050659.67672442966679856.79967205899375754.51425941752147352.69882116028203751.25671131716617250.11115828537426649.20117784601172448.478326631758335
148SUBTOTAL(109,XV.a.Outputs[2007])0SUBTOTAL(109,XV.a.Outputs[2010])0SUBTOTAL(109,XV.a.Outputs[2015])0SUBTOTAL(109,XV.a.Outputs[2020])0SUBTOTAL(109,XV.a.Outputs[2025])0SUBTOTAL(109,XV.a.Outputs[2030])0SUBTOTAL(109,XV.a.Outputs[2035])0SUBTOTAL(109,XV.a.Outputs[2040])0SUBTOTAL(109,XV.a.Outputs[2045])0SUBTOTAL(109,XV.a.Outputs[2050])0
|
|
890
|
10611064
|
10601030442691692720721722723724725726727
10431053INDEX(IPCC[Sector_description], MATCH(XV.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$9014.527244480739197G$9013.74299962541199213.04829123561893112.41922491886902211.91952038540989611.52257555763767111.20725883396417710.95678413503388210.75781728648453110.599766165989214
10441053INDEX(IPCC[Sector_description], MATCH(XV.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$911.8436162606187682E-2G$911.7440897076303603E-21.6559260035288102E-21.5760927707292011E-21.5126765182794258E-21.4623012430495181E-21.4222851863375775E-21.3904980687989605E-21.3652476837176053E-21.3451898113426678E-2
10451053INDEX(IPCC[Sector_description], MATCH(XV.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$920.2540812001173906G$920.24036477410889220.228214338997521420.217211982361673660.208472160592050980.201529603911430820.196014721052932360.191633923842034680.188153997849874190.18538968707995557
148SUBTOTAL(109,XV.a.Emissions[2007])14.799761843462775SUBTOTAL(109,XV.a.Emissions[2010])14.000805296597187SUBTOTAL(109,XV.a.Emissions[2015])13.293064834651741SUBTOTAL(109,XV.a.Emissions[2020])12.652197828937988SUBTOTAL(109,XV.a.Emissions[2025])12.143119311184741SUBTOTAL(109,XV.a.Emissions[2030])11.738728173979597SUBTOTAL(109,XV.a.Emissions[2035])11.417496406880487SUBTOTAL(109,XV.a.Emissions[2040])11.162323039563907SUBTOTAL(109,XV.a.Emissions[2045])10.959623761171581SUBTOTAL(109,XV.a.Emissions[2050])10.798607751182598
|
|
2702
|
2708
|
782703442691692720721722723724725726727
2704INDEX(Vectors[Description], MATCH(XV.a.info[Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH(XV.a.info[Information type], Vectors[Description], 0))0
2710INDEX(Vectors[Description], MATCH(XV.a.info[Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH(XV.a.info[Information type], Vectors[Description], 0))0
2711INDEX(Vectors[Description], MATCH(XV.a.info[Vector], Vectors[Code], 0))Number of units
|