956INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Fossil fuel production958INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Petroleum refineries36596822181Preferences.EnergyUnitsTWh78418442691692720721722723724725726727986INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Oil reservesINDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-975.89120834979815INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-802.54795283721205INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-646.82884353331633INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-501.7889500727494INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-388.27472421443264INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-300.43958011019754INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-232.47441995977493INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-179.88427462124332INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-139.19102265793308INDEX(INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.NetBalance"), MATCH([Vector], INDIRECT("'"&XV.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-107.703360003839157842179Preferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205065INDEX(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.162075386086372182Preferences.EnergyUnitsTWh78418442200765INDEX(Vectors[Description], MATCH($C22, Vectors[Code], 0))Oil and petroleum products109-'DUKES 09 (1.2)'!$D$7*Unit.ktoe648.418098480884742188218678418442200720102015202020252030203520402045205034INDEX(Vectors[Description], MATCH($C27, Vectors[Code], 0))Conversion losses-'2007 (Actual, frozen)'!$AY$116/'2007 (Actual, frozen)'!$AH$116-3.1480490285906312E-30000000002187218578418442200720102015202020252030203520402045205045INDEX(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-349INDEX(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-250INDEX(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-3751INDEX(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-42738707Preferences.EnergyUnitsTWh69836571010F40*Unit.Mtoe116.30000000000001F40*Unit.Mtoe.y13.267168605977639717109959117785118783317035941801179932423.519*((MGBP/Unit.PJ))12.6683999999999982.96*((MGBP/Unit.PJ))10.655999999999999Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh36550.1883*((MGBP/Unit.PJ))0.677879999999999930.12*((MGBP/Unit.PJ))0.43199999999999994Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh36560*((MGBP/Unit.PJ))00.0394*((MGBP/Unit.PJ))0.14183999999999997Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh3658Preferences.moneyunits&"/refinery"£m/refinery180117993176E51*$G$401473.33492F51*$G$401239.29279999999993177(E52+E53)*$G$4078.837444000000005(F52+F53)*$G$4066.737591999999992331030364371736598122191Preferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205065INDEX(Vectors[Description], MATCH($C72, Vectors[Code], 0))Oil and petroleum products-INDIRECT("XV.a.Inputs["&F$76&"]")975.89120834979815-INDIRECT("XV.a.Inputs["&G$76&"]")802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.703360003839152184Preferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205065INDEX(Vectors[Description], MATCH($C77, Vectors[Code], 0))Oil and petroleum products$F$22/$F$72*F$72648.41809848088474533.24244861103875429.77693125823049333.40707863848957257.98404187802663199.62313378441866154.46457560639533119.5217441232561892.48364721932826271.562083248791055442109218373121742180217521761218921182311591219020072010201520202025203020352040204520502191F$72975.89120834979815G$72802.54795283721205646.82884353331633501.7889500727494388.27472421443264300.43958011019754232.47441995977493179.88427462124332139.19102265793308107.703360003839154F$17728.16207538608637G$17728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637728.16207538608637151-F77-648.41809848088474-G77-533.24244861103875-429.77693125823049-333.40707863848957-257.98404187802663-199.62313378441866-154.46457560639533-119.52174412325618-92.483647219328262-71.5620832487910552192SUM(F95:F97)1055.6351852549999SUM(G95:G97)997.46757961225967945.21398766117227896.54394682034626858.45275772249238828.97852171186526806.17191973946592788.52460588407348774.86945082469117764.303352141134521183960Preferences.EnergyUnitsTWhF$981055.6351852549999G$98997.46757961225967945.21398766117227896.54394682034626858.45275772249238828.97852171186526806.17191973946592788.52460588407348774.86945082469117764.303352141134585720F$27*F101-3.3231913194880933G$27*G101000000000835961F101-F1021058.9583765744881G101-G102997.46757961225967945.21398766117227896.54394682034626858.45275772249238828.97852171186526806.17191973946592788.52460588407348774.86945082469117764.3033521411345962Preferences.EnergyUnitsTWh786F$103*F$326.86481613512663376.46619516523206356.12745541012997475.81194642596937525.56501603162189355.37394599958645455.22609965106991765.11169896490884055.02317789472047954.9546819780416254787F$103*F$3356.26668514219077452.99943367286665150.22299177401593147.636958248593745.61302133938944.04693754034374142.83513175011493241.89745952968376541.17190663989082840.610487644621017788F$103*F$342.50311519125819262.35776618472157922.2342516418424962.11920772578045742.02916959378857211.95949980360514211.90559064804157941.86387677110977281.83159936831071991.8066237293128036789F$103*F$350.806141937622635420.759331495110777130.719552961038971590.68250243866196070.653505165808777710.63106762883549850.613705890441123560.600271708229694450.589876594123588950.581833052985147231160118410401061F$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+F$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))14.527244480739201G$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+G$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))13.683687396205434H$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+H$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))12.966850245603002I$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+I$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))12.299173783692028J$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+J$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.776622540104347K$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+K$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.372282348949282L$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+L$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))11.059411616768383M$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+M$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.817318208305139N$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+N$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.629990943741879O$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+O$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))10.48504067734881P$107*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))+P$108*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))010411061F$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+F$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.8436162606187686E-2G$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+G$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.7365625409771289E-2H$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+H$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.6455905311910705E-2I$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+I$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.5608573814431257E-2J$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+J$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.4945417101565234E-2K$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+K$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.4432279078574346E-2L$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+L$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.4035222658077558E-2M$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+M$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3727987968785162E-2N$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+N$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3490255622871969E-2O$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+O$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.3306302865377186E-2P$107*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))+P$108*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))010421061F$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+F$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.25408120011739066G$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+G$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.23932740446880518H$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+H$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.22678993779676851I$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+I$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.21511229053493619J$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+J$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.20597288028617045K$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+K$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.19890097885568342L$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+L$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.19342887633689357M$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+M$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18919466771980825N$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+N$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18591831780650941O$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+O$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0.18338314069901898P$107*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))+P$108*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))043661274020072010201520202025203020352040204520503660 (F103*0.1141) / 139.2943962128576221 (G103*0.1141) / 138.75469621798144898.29607046093382657.86889725632319257.5345738197027987.27588071748644797.0757089263286976.92081981010559846.80096956454594276.708231729177187636473648F120*(1/$E$61)0.30981320709525406G120*(1/$E$61)0.291823207266048270.276535682031127550.26229657521077310.251152460656759950.242529357249548270.235856964210956560.230693993670186610.2266989854848647536493648MAX((G120-F120)/(G119-F119),0)0MAX((H120-G120)/(H119-G119),0)0000000036503648SUM(G121:G122)0.30981320709525406SUM(H121:H122)0.291823207266048270.276535682031127550.26229657521077310.251152460656759950.242529357249548270.235856964210956560.230693993670186610.22669898548486475533273183Preferences.moneyunits£m20072010201520202025203020352040204520503176 F123*$G$580 G123*$G$58383.94927689805724361.65439963772127342.70867968426575325.06225712336959311.25143619420584300.56488622799299292.29583757649613285.89740535870783280.946420478697413177$G$59 * F120620.28562234003709$G$59 * G120584.26734427958888553.65976562505364525.15125458241653502.83931347320686485.57475876427776472.21577543608259461.87884879234485453.88033200308473447.691232183281613184 F128 + F129620.28562234003709 G128 + G129968.21662117764618915.31416526277485867.85993426668233827.90157059657645796.8261949584836772.78066166407552754.17468636884098739.77773736179256728.637652661979023185Preferences.moneyunits£m20072010201520202025203020352040204520503176 $F$58 * F1230 $F$58 * G123456.45861669062958429.95332173146664407.42967696247678386.45070365443837370.03169052953058357.32697116091464347.49630149719258339.88951670854493334.003531643424373177 $F$59 * F120732.74644094497489 $F$59 * G120690.19787282212428654.04099038392474620.36374678713332594.00654157468546573.61183861551774557.83080623973876545.6197442132908536.17105719059521528.859843288029773184 F133 + F134732.74644094497489 G133 + G1341146.6564895127541083.99431211539151027.7934237496102980.45724522912383943.64352914504832915.15777740065346893.11604571048338876.06057389914008862.86337493145413683Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F$106-6.8648161351266337-G$106-6.4661951652320635-6.1274554101299747-5.8119464259693752-5.5650160316218935-5.3739459995864545-5.2260996510699176-5.1116989649088405-5.0231778947204795-4.954681978041625449INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F$107-56.266685142190774-G$107-52.999433672866651-50.222991774015931-47.6369582485937-45.613021339389-44.046937540343741-42.835131750114932-41.897459529683765-41.171906639890828-40.61048764462101750INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-F$108-2.5031151912581926-G$108-2.3577661847215792-2.234251641842496-2.1192077257804574-2.0291695937885721-1.9594998036051421-1.9055906480415794-1.8638767711097728-1.8315993683107199-1.8066237293128036751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transport-F109-0.80614193762263542-G109-0.75933149511077713-0.71955296103897159-0.6825024386619607-0.65350516580877771-0.6310676288354985-0.61370589044112356-0.60027170822969445-0.58987659412358895-0.581833052985147265INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Oil and petroleum products-F$101+F$1033.3231913194881599-G$101+G$10300000000034INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion lossesF$102-3.3231913194880933G$10200000000035INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Distribution losses and own useF$106+F$107+F$108+F$10966.440758406198242G$106+G$107+G$108+G$10962.58272651793107159.30425178702737656.25061483900549353.86071213060824952.01145097237083150.58052793966755449.47330697393206848.61656049704561947.953626404960595148SUBTOTAL(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])0889105810611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$11314.527244480739201G$11313.68368739620543412.96685024560300212.29917378369202811.77662254010434711.37228234894928211.05941161676838310.81731820830513910.62999094374187910.4850406773488110411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$1141.8436162606187686E-2G$1141.7365625409771289E-21.6455905311910705E-21.5608573814431257E-21.4945417101565234E-21.4432279078574346E-21.4035222658077558E-21.3727987968785162E-21.3490255622871969E-21.3306302865377186E-210421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF$1150.25408120011739066G$1150.239327404468805180.226789937796768510.215112290534936190.205972880286170450.198900978855683420.193428876336893570.189194667719808250.185918317806509410.18338314069901898148SUBTOTAL(109,[2007])14.799761843462779SUBTOTAL(109,[2010])13.94038042608401SUBTOTAL(109,[2015])13.210096088711682SUBTOTAL(109,[2020])12.529894648041395SUBTOTAL(109,[2025])11.997540837492082SUBTOTAL(109,[2030])11.58561560688354SUBTOTAL(109,[2035])11.266875715763355SUBTOTAL(109,[2040])11.020240863993733SUBTOTAL(109,[2045])10.829399517171259SUBTOTAL(109,[2050])10.681730120913207261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))02620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))02621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units31893190Preferences.moneyunits£m784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C180,CostVectors[Code], 0))Low estimate of capital costsF1280G128383.94927689805724361.65439963772127342.70867968426575325.06225712336959311.25143619420584300.56488622799299292.29583757649613285.89740535870783280.946420478697413133INDEX(CostVectors[Description], MATCH(C181, CostVectors[Code], 0))Low estimate of operating costsF129620.28562234003709584.26734427958888553.65976562505364525.15125458241653502.83931347320686485.57475876427776472.21577543608259461.87884879234485453.88033200308473447.691232183281613135INDEX(CostVectors[Description], MATCH(C182, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C183, CostVectors[Code], 0))High estimate of capital costsF1330G133456.45861669062958429.95332173146664407.42967696247678386.45070365443837370.03169052953058357.32697116091464347.49630149719258339.88951670854493334.003531643424373142INDEX(CostVectors[Description], MATCH(C184, CostVectors[Code], 0))High estimate of operating costsF134732.74644094497489690.19787282212428654.04099038392474620.36374678713332594.00654157468546573.61183861551774557.83080623973876545.6197442132908536.17105719059521528.859843288029773144INDEX(CostVectors[Description], MATCH(C185, CostVectors[Code], 0))High estimate of fuel costs