998INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Transfers999INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Fossil fuel transfers36416821194Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-479.45526789915641INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-463.01751711372873INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-388.80477376749172INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-255.22379451924886INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-92.165145532644772INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-10.969289234458387INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-35.832014103034169INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-64.327845453587457INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-99.764540741624444INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-132.1578663606416649INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-892.42984169570263INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-872.26240962821657INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-837.79861817518611INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-814.88290816733274INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-726.62771845443706INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-647.15083425497335INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-644.07417218102864INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-638.32723000236604INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-623.33267975168962INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-611.9902459373679450INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-967.16729432391946INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-945.9344711372471INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-917.57761334500003INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-846.67429705427253INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-755.55248025501385INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-584.59254088863031INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-383.56089315047245INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-255.77235640890922INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-193.24718293715421INDEX(INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVI.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-121.921400857361537841195122278418442200720102015202020252030203520402045205050INDEX(Vectors[Description], MATCH($C19, Vectors[Code], 0))Gaseous hydrocarbons109-('2007 (Consistent)'!$Z$141+'2007 (Consistent)'!$W$143)/'2007 (Consistent)'!$W$1411.1525360288796723E-2$F191.1525360288796723E-2$F191.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21.1525360288796723E-21210106110571027442200710411164117208.126255432784/1000*GWP.CH44.37065136408846397171091212117121131703642179918013237Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh((9.57*MGBP/Unit.PJ)*50%)*(Price2000)22.311159465340378((9.57*MGBP/Unit.PJ)*150%)*(Price2000)66.933478396021133306Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh((0.001*MGBP/Unit.PJ)*50%)*(Price2000)2.3313646254274167E-3((0.001 *MGBP/Unit.PJ)*50%)*(Price2000)2.3313646254274167E-33310303643320936417311165721159116561215Preferences.EnergyUnitsTWh-F$9479.45526789915641-G$9463.01751711372873388.80477376749172255.2237945192488692.16514553264477210.96928923445838735.83201410303416964.32784545358745799.764540741624444132.157866360641661658Preferences.EnergyUnitsTWh-F$10892.42984169570263-G$10872.26240962821657837.79861817518611814.88290816733274726.62771845443706647.15083425497335644.07417218102864638.32723000236604623.33267975168962611.990245937367941216Preferences.EnergyUnitsTWh-F$11967.16729432391946-G$11945.9344711372471917.57761334500003846.67429705427253755.55248025501385584.59254088863031383.56089315047245255.77235640890922193.24718293715421121.9214008573615312171218F51*F$1911.146951526623873G51*G$1910.90223558944915710.5754125867353389.75822632081419358.70801455203300636.73763965588459434.42067748625185792.94786855952720432.22724340814571291.40518807179590138351219F51+F52978.31424585054333G51+G52956.83670672669621928.15302593173533856.4325233750867764.26049480704683591.33018054451486387.98157063672431258.72022496843641195.47442634529992123.326588929157442116012201221170012101060F$244.3706513640884639$F60*(G$51/$F$51)4.2746997452021471$F60*(H$51/$F$51)4.14655444922459453.8261407236125343.41435912674795362.64178720813434251.73332054412671831.15584119210333870.873288487594009570.55096562931369675336443645Preferences.EnergyUnits&"/yr average flow"TWh/yr average flow20072010201520202025203020352040204520503646148F51967.16729432391946G51945.9344711372471917.57761334500003846.67429705427253755.55248025501385584.59254088863031383.56089315047245255.77235640890922193.24718293715421121.9214008573615336473648F65*(1/$E$37)32.238909810797317G65*(1/$E$37)31.53114903790823630.58592044483333428.22247656847575225.18508267516712719.4864180296210112.7853631050157478.52574521363030696.441572764571806636493648MAX((G65-F65)/(G64-F64),0)0MAX((H65-G65)/(H64-G64),0)0000000036503648SUM(G66:G67)32.238909810797317SUM(H66:H67)31.53114903790823630.58592044483333428.22247656847575225.18508267516712719.4864180296210112.7853631050157478.52574521363030696.44157276457180664332717993309Preferences.moneyunits£mF$65*$F$3421578.623733322758G$65*$F$3421104.894829305536H$65*$F$3420472.2204531667318890.28525678284516857.25187140305213042.9374020147468557.68825174857195706.57783066504734311.56871473865162720.20781676628033312Preferences.moneyunits&"/yr"£m/yrG$68*$F$34719.28745777742529H$68*$F$34703.49649431018452682.40734843889106629.67617522609476561.90839571343497434.76458006715819285.25627505828572190.21926102216824143.718957157955063313Preferences.moneyunits&"/yr"£m/yrG$65*$F$352.2053181639817696H$65*$F$352.13920798883664891.97390650541095551.76146832512048611.36289837011648340.894220297988356670.596298623893944390.450529646263181980.284243241041408583314Preferences.moneyunits&"/yr"£m/yrSUM(G73:G74)721.4927759414071SUM(H73:H74)705.6357022990212684.38125494430199631.43764355121527563.27129408355142435.65880036514653285.8525736821797190.66979066843143144.0032003989964618013309Preferences.moneyunits£mF$65*$G$3464735.871199968271G$65*$G$3463314.684487916602H$65*$G$3461416.66135950019156670.85577034852850571.75561420914939128.81220604423325673.06475524571617119.73349199514312934.7061442159548160.623450298843312Preferences.moneyunits&"/yr"£m/yrG$68*$G$342157.8623733322756H$68*$G$342110.48948293055352047.22204531667311889.02852567828431685.7251871403051304.2937402014745855.76882517485717570.65778306650475431.156871473865123313Preferences.moneyunits&"/yr"£m/yrG$65*$G$352.2053181639817696H$65*$G$352.13920798883664891.97390650541095551.76146832512048611.36289837011648340.894220297988356670.596298623893944390.450529646263181980.284243241041408583314Preferences.moneyunits&"/yr"£m/yrSUM(G79:G80)2160.0676914962573SUM(H79:H80)2112.628690919392049.19595182208421890.78999400340471687.08808551042151305.1879604994629856.36512379875114571.10831271276788431.44111471490652683778Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsF$48479.45526789915641G$48463.01751711372873388.80477376749172255.2237945192488692.16514553264477210.96928923445838735.83201410303416964.32784545358745799.764540741624444132.1578663606416649INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsF$49892.42984169570263G$49872.26240962821657837.79861817518611814.88290816733274726.62771845443706647.15083425497335644.07417218102864638.32723000236604623.33267975168962611.9902459373679450INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsF$51967.16729432391946G$51945.9344711372471917.57761334500003846.67429705427253755.55248025501385584.59254088863031383.56089315047245255.77235640890922193.24718293715421121.9214008573615364INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Coal and fossil waste-F$48-479.45526789915641-G$48-463.01751711372873-388.80477376749172-255.22379451924886-92.165145532644772-10.969289234458387-35.832014103034169-64.327845453587457-99.764540741624444-132.1578663606416665INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Oil and petroleum products-F49-892.42984169570263-G49-872.26240962821657-837.79861817518611-814.88290816733274-726.62771845443706-647.15083425497335-644.07417218102864-638.32723000236604-623.33267975168962-611.9902459373679466INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Natural gas-F$53-978.31424585054333-G$53-956.83670672669621-928.15302593173533-856.4325233750867-764.26049480704683-591.33018054451486-387.98157063672431-258.72022496843641-195.47442634529992-123.3265889291574435INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Distribution losses and own useF$5211.146951526623873G$5210.90223558944915710.5754125867353389.75822632081419358.70801455203300636.73763965588459434.42067748625185792.94786855952720432.22724340814571291.4051880717959013148SUBTOTAL(109,[2007])1.2079226507921703E-13SUBTOTAL(109,[2010])5.1514348342607263E-14SUBTOTAL(109,[2015])-1.865174681370263E-13SUBTOTAL(109,[2020])1.9539925233402755E-14SUBTOTAL(109,[2025])-1.9895196601282805E-13SUBTOTAL(109,[2030])1.5809575870662229E-13SUBTOTAL(109,[2035])-1.1723955140041653E-13SUBTOTAL(109,[2040])1.021405182655144E-14SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])-3.219646771412954E-14889105810611057102744269169272072172272372472572672710411049INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fugitive Emissions from FuelsF$604.3706513640884639G$604.27469974520214714.14655444922459453.8261407236125343.41435912674795362.64178720813434251.73332054412671831.15584119210333870.873288487594009570.55096562931369675148SUBTOTAL(109,[2007])4.3706513640884639SUBTOTAL(109,[2010])4.2746997452021471SUBTOTAL(109,[2015])4.1465544492245945SUBTOTAL(109,[2020])3.826140723612534SUBTOTAL(109,[2025])3.4143591267479536SUBTOTAL(109,[2030])2.6417872081343425SUBTOTAL(109,[2035])1.7333205441267183SUBTOTAL(109,[2040])1.1558411921033387SUBTOTAL(109,[2045])0.87328848759400957SUBTOTAL(109,[2050])0.55096562931369675261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))02621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units31893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C122,CostVectors[Code], 0))Low estimate of capital costsG73719.28745777742529H73703.49649431018452682.40734843889106629.67617522609476561.90839571343497434.76458006715819285.25627505828572190.21926102216824143.718957157955063133INDEX(CostVectors[Description], MATCH(C123, CostVectors[Code], 0))Low estimate of operating costsG742.20531816398176962.13920798883664891.97390650541095551.76146832512048611.36289837011648340.894220297988356670.596298623893944390.450529646263181980.284243241041408583135INDEX(CostVectors[Description], MATCH(C124, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C125, CostVectors[Code], 0))High estimate of capital costsG792157.8623733322756H792110.48948293055352047.22204531667311889.02852567828431685.7251871403051304.2937402014745855.76882517485717570.65778306650475431.156871473865123142INDEX(CostVectors[Description], MATCH(C126, CostVectors[Code], 0))High estimate of operating costsG802.20531816398176962.13920798883664891.97390650541095551.76146832512048611.36289837011648340.894220297988356670.596298623893944390.450529646263181980.284243241041408583144INDEX(CostVectors[Description], MATCH(C127, CostVectors[Code], 0))High estimate of fuel costs