673INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Electricity distribution, storage, and balancing782INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Electricity grid distribution3307682777Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.55512401053005INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.8504854064858INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-366.15566020407942INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-397.63425015561921INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-448.92851921942582INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-501.34410096666102INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-546.84345506583895INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-607.82760141187271INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-678.37819759429806INDEX(INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VII.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-756.086397646219553304Preferences.PowerUnitsGWPeak_Electricity_Generation_Capacity88.98886769886847590.8152894846077692.46837300579044103.7358808965844119.18099671905037131.18954287416224139.3661833654902153.33339999999998167.33340000000001181.3334000000000178497078418442200720102015202020252030203520402045205035INDEX(Vectors[Description], MATCH($C18, Vectors[Code], 0))Distribution losses and own use109-'2007 (Actual, frozen)'!$AZ$125/'2007 (Actual, frozen)'!$U$1256.9749984639583235E-2$F186.9749984639583235E-2$F186.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-210977931703305179918013237Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW((150000*GBP/Unit.MW)*50%)*(Price2000)97.140192726142374((150000*GBP/Unit.MW)*150%)*(Price2000)291.420578178427093306Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW((9400*GBP/Unit.MW)*50%)*(Price2000)6.0874520775049223((9400*GBP/Unit.MW)*150%)*(Price2000)18.2623562325147693310331120203315179918013237Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW((82000*GBP/Unit.MW)*50%)*(Price2000)53.103305356957819((82000*GBP/Unit.MW)*150%)*(Price2000)159.309916070873443306Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW((2500*GBP/Unit.MW)*50%)*(Price2000)1.6190032121023727((2500*GBP/Unit.MW)*150%)*(Price2000)4.8570096363071187331033112020320933077311971774Preferences.EnergyUnitsTWh-VII.b.Inputs[2007]354.55512401053005-VII.b.Inputs[2010]354.8504854064858-VII.b.Inputs[2015]366.15566020407942-VII.b.Inputs[2020]397.63425015561921-VII.b.Inputs[2025]448.92851921942582-VII.b.Inputs[2030]501.34410096666102-VII.b.Inputs[2035]546.84345506583895-VII.b.Inputs[2040]607.82760141187271-VII.b.Inputs[2045]678.37819759429806-VII.b.Inputs[2050]756.08639764621955775(1-F$18)0.93025001536041674(1-G$18)0.930250015360416740.930250015360416740.930250015360416740.930250015360416740.930250015360416740.930250015360416740.930250015360416740.930250015360416740.93025001536041674780F41/F42381.13960565016595G41/G42381.45711319230912393.60994803339594427.44879719411722482.58910164649944538.93479461262882587.84568238246095653.40240943331298729.24287706834025812.77762446827899776F$186.9749984639583235E-2G$186.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-26.9749984639583235E-2781F43*F4426.584481639635886G43*G4426.60662778582332427.4542878293165229.81454703849800633.66058242707360637.59069364596780441.00222731662197645.57480802144025550.86467947404221956.6912268220594132330817993309Preferences.moneyunits£mF10*$F$268644.3957587492696G10*$F$268821.81472301520818982.395574855303510076.92346291035911577.26499058229512743.77747845063813538.05791163061614894.83602735467716254.79872552067417614.7614236866683312Preferences.moneyunits&"/yr"£m/yr(F49/$F$28)+((G49-F49)/5)467.70358079065119(G49/$F$28)+((H49-G49)/5)473.20690651877948668.02535635377637803.91447867990496812.16574710278337796.04496055852746948.258518726343031016.73434100093321084.73247590923263313Preferences.moneyunits&"/yr"£m/yrG10*$F$27552.83372264228649H10*$F$27562.89678935759912631.48720367571593725.50860607649054798.61005531624005848.38496246218529933.409724380893181018.63405346596221103.85838255103113314Preferences.moneyunits&"/yr"£m/yrSUM(G50:G51)1020.5373034329377SUM(H50:H51)1036.10369587637871299.51256002949231529.42308475639541610.77580241902341644.42992302071271881.66824310723632035.36839446689562188.590858460263918013309Preferences.moneyunits£mF10*$G$2625933.187276247805G10*$G$2626465.44416904562226947.18672456590930230.77038873107834731.7949717468838231.33243535191340614.1737348918444684.50808206402948764.39617656201952844.2842710599943312Preferences.moneyunits&"/yr"£m/yr(F55/$G$28)+((G55-F55)/5)1403.1107423719536(G55/$G$28)+((H55-G55)/5)1419.62071955633842004.07606906132922411.74343603971472436.49724130835062388.13488167558132844.775556179033050.20302300279953254.19742772769633313Preferences.moneyunits&"/yr"£m/yrG10*$G$271658.5011679268596H10*$G$271688.69036807279741894.46161102714792176.5258182294722395.83016594872022545.15488738655592800.22917314267993055.90216039788723311.57514765309363314Preferences.moneyunits&"/yr"£m/yrSUM(G56:G57)3061.6119102988132SUM(H56:H57)3108.31108762913573898.53768008847694588.26925426918664832.32740725707124933.28976906213765645.00472932171036106.10518340068676565.77257538078993331617993309Preferences.moneyunits£mF10*$F$314725.6030147829333G10*$F$314822.5920485816459H10*$F$314910.37624758756565508.71815972432896328.90486151832016966.59835488634697400.80499169140158142.51036162055528885.95663661796619629.40291161537613312Preferences.moneyunits&"/yr"£m/yr(F62/$F$33)+((G62-F62)/5)255.67795749888921(G62/$F$33)+((H62-G62)/5)258.68644223026621365.18719480673099439.47324834501467443.98394174952136435.17124510532824518.38132357040081555.81477308050989592.987086830380353313Preferences.moneyunits&"/yr"£m/yrG10*$F$32147.03024538358679H10*$F$32149.70659291425505167.94872438183933192.95441650970488212.39629130751061225.6342985271769248.24726712257794270.91331209201121293.57935706144443314Preferences.moneyunits&"/yr"£m/yrSUM(G63:G64)402.70820288247603SUM(H63:H64)408.39303514452126SUM(I63:I64)533.13591918857037SUM(J63:J64)632.42766485471952SUM(K63:K64)656.380233057032SUM(L63:L64)660.80554363250508SUM(M63:M64)766.62859069297872SUM(N63:N64)826.72808517252111SUM(O63:O64)886.5664438918247518013309Preferences.moneyunits£mF10*$G$3114176.809044348798G10*$G$3114467.776145744938H10*$G$3114731.12874276269416526.15447917298718986.71458455495720899.7950646590422202.41497507420424427.53108486166526657.86990985389628888.2087348461253312Preferences.moneyunits&"/yr"£m/yr(F68/$G$33)+((G68-F68)/5)767.03387249666775(G68/$G$33)+((H68-G68)/5)776.059326690798121095.56158442019321318.41974503504341331.95182524856451305.51373531598461555.14397071120221667.44431924152971778.96126049114063313Preferences.moneyunits&"/yr"£m/yrG10*$G$32441.09073615076045H10*$G$32449.11977874276522503.84617314551798578.8632495291148637.18887392253191676.90289558153074744.74180136773384812.73993627603363880.738071184333313314Preferences.moneyunits&"/yr"£m/yrSUM(G69:G70)1208.1246086474282SUM(H69:H70)1225.17910543356331599.40775756571111897.28299456415831969.14069917109651982.41663089751552299.8857720789362480.18425551756352659.6993316754738683778Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)000000000046INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)-(F$43-F$41)-26.584481639635896-(G$43-G$41)-26.606627785823321-27.454287829316513-29.814547038498006-33.660582427073621-37.590693645967804-41.002227316621997-45.574808021440276-50.864679474042191-56.69122682205943435INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Distribution losses and own useF$4526.584481639635886G$4526.60662778582332427.4542878293165229.81454703849800633.66058242707360637.59069364596780441.00222731662197645.57480802144025550.86467947404221956.691226822059413148SUBTOTAL(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])0261326187826144426916927207217227237247257267272615INDEX(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(C99,CostVectors[Code], 0))Low estimate of capital costsG50+G63723.38153828954046H50+H63731.893348749045691033.21255116050721243.38772702491951256.14968885230471231.21620566385581466.63984229674381572.54911408144311677.71956273961293133INDEX(CostVectors[Description], MATCH(C100, CostVectors[Code], 0))Low estimate of operating costsG64+G51699.86396802587331H64+H51712.60338227185412799.4359280575552918.463022586195391011.00634662375071074.01926098936221181.65699150347111289.54736555797351397.43773961247553135INDEX(CostVectors[Description], MATCH(C101, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C102, CostVectors[Code], 0))High estimate of capital costsG56+G692170.1446148686214H56+H692195.68004624713653099.63765348152263730.16318107475813768.44906655691513693.64861699156614399.91952689023224717.64734224432875033.15868821883673142INDEX(CostVectors[Description], MATCH(C103, CostVectors[Code], 0))High estimate of operating costsG57+G702099.5919040776198H57+H702137.81014681556282398.30778417266582755.38906775858693033.01903987125213222.05778296808653544.97097451041373868.64209667392064192.31321883742663144INDEX(CostVectors[Description], MATCH(C104, CostVectors[Code], 0))High estimate of fuel costs