679INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Transport890INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Domestic passenger transport3317133782513361878XII.a.Scenario.Demand21884XII.a.Scenario.Technology31338136313921336804422007201020152020202520302035204020452050110914104.004213212675142471411314427146831486215056151521525415363214104.004213212675140791401814373146671479214934149561498415023314104.004213212675G1814079H181401814373146671479214934149561498415023414104.00421321267514077139461415014300143001432314231141471407618761336140183133344220071234139513961172.1680038900835603E-22.1999999999999999E-22.1999999999999999E-22.1999999999999999E-22.1999999999999999E-2135113445.084268859379436E-37.0000000000000001E-38.9999999999999993E-30.014.7E-2134913970.832103179442072020.822999999999999950.803000000000000050.735999999999999990.624135013985.9627670922358024E-27.1999999999999995E-28.7999999999999995E-20.132000000000000010.187135213997.0097236274669239E-25.5E-25.7000000000000002E-27.9000000000000001E-29.8000000000000004E-2135314001.1407605600685865E-22.1000000000000001E-22.1000000000000001E-22.1000000000000001E-22.1000000000000001E-2148SUM(F25:F30)1SUM(G25:G30)1SUM(H25:H30)1SUM(I25:I30)1SUM(J25:J30)0.9990000000000001118771336187283133344220071234134913971.4535833325868115$F361.4535833325868115$F361.4535833325868115$F36*1.041.5117266658902839$F36*1.061.5407983325420203135013989.0545454545454547$F379.05454545454545471218181352139918700.324183510963039160.368115063567138580.368115063567138580.405884801103089670.421901465327602751353140018700.6510.65100000000000002$F390.65100000000000002G390.65100000000000002H390.65100000000000002I390.651000000000000021879188014111333826442200720102015202020252030203520402045205013491354110.9960.991999999999999990.955999999999999960.920.880.840.80750.7750000000000000213491864003.5000000000000001E-37.0000000000000001E-33.8500000000000006E-27.0000000000000007E-20.105000000000000010.140000000000000010.170.213491355005.0000000000000001E-41E-35.4999999999999997E-30.011.4999999999999999E-20.022.2499999999999999E-22.5000000000000001E-21349135600000000001350135410.986999999999999990.939000000000000060.891000000000000010.842500000000000030.794000000000000040.7460.697999999999999950.649499999999999970.600999999999999981350186501.0999999999999999E-25.9499999999999997E-20.1080.1560.203999999999999990.25250.300999999999999990.348999999999999980.3970000000000000213501355001E-32E-32E-32E-32E-32E-32E-32E-313501356001E-32E-32E-32E-32E-32E-32E-32E-3135214021-F560.351-G560.3633544137826361-H560.3633544137826360.3633544137826360.3633544137826360.3633544137826360.3633544137826360.3633544137826360.3633544137826360.363354413782636135214030.650.6366455862173640.6366455862173640.6366455862173640.6366455862173640.6366455862173640.6366455862173640.6366455862173640.6366455862173640.636645586217364135313531$F571$F5711111111188114111333826442200720102015202020252030203520402045205013491354110.984999999999999990.970.840.710.620.530.440.3513491864005.0000000000000001E-30.010.130.250.3150.380.460.5413491355000.010.020.030.046.5000000000000002E-20.099.5000000000000001E-20.113491356000000005.0000000000000001E-30.011350135410.988999999999999990.893499999999999960.798000000000000040.448000000000000019.8000000000000004E-24.9000000000000002E-20001350186501.0999999999999999E-20.105500000000000010.20.550000000000000040.90.949000000000000070.9980.9980.99813501355001E-32E-32E-32E-32E-32E-32E-32E-313501356001E-32E-32E-32E-32E-32E-32E-32E-3135214021-F710.350.3633544137826360.3633544137826360.297294521267376210.297294521267376210.2686939799152690.2686939799152690.2686939799152690.2686939799152690.268693979915269135214030.650.6366455862173640.6366455862173640.702705478732623790.702705478732623790.7313060200847310.7313060200847310.7313060200847310.7313060200847310.731306020084731135313531$F721$F7211111111188214111333826442200720102015202020252030203520402045205013491354110.984999999999999990.970.704999999999999960.440.410000000000000030.380.290000000000000040.213491864005.0000000000000001E-30.010.227500000000000010.445000000000000010.382500000000000010.320.320.3213491355000.010.020.050.080.140000000000000010.20.240000000000000020.280000000000000031349135600001.7500000000000002E-23.5000000000000003E-26.7500000000000004E-20.10.150000000000000020.21350135410.988999999999999990.711999999999999970.4350.2175000001350186501.0999999999999999E-20.271000000000000020.531000000000000030.727999999999999980.925000000000000040.892500000000000070.860.820000000000000060.7813501355008.5000000000000006E-31.7000000000000001E-22.725E-23.7499999999999999E-25.3750000000000006E-27.0000000000000007E-20.090.1113501356008.5000000000000006E-31.7000000000000001E-22.725E-23.7499999999999999E-25.3750000000000006E-27.0000000000000007E-20.090.11135214021-F860.350.3633544137826360.3633544137826360.297294521267376210.282994250591322550.241824581923742120.214955183932215240.188085785940688370.161216387949161490.1343469899576345135214030.650.6366455862173640.6366455862173640.702705478732623790.717005749408677450.758175418076257880.785044816067784760.811914214059311630.838783612050838510.8656530100423655135313531$F871$F8711111111188314111333826442200720102015202020252030203520402045205013491354110.990.970.660.340.260.180.09013491864000.010.010.230.445000000000000010.382500000000000010.320.16013491355000.010.029.9999999999999992E-20.180.290000000000000040.40.600000000000000090.81349135600001.7500000000000002E-23.5000000000000003E-26.7500000000000004E-20.10.150000000000000020.21350135410.988999999999999990.711999999999999970.4350.2175000001350186501.0999999999999999E-20.271000000000000020.531000000000000030.677999999999999940.824999999999999960.747500000000000050.670.590000000000000080.5113501355008.5000000000000006E-31.7000000000000001E-25.2249999999999998E-28.7499999999999994E-20.126250.165000000000000010.205000000000000020.24513501356008.5000000000000006E-31.7000000000000001E-25.2249999999999998E-28.7499999999999994E-20.126250.165000000000000010.205000000000000020.245135214021-F1010.350.3633544137826360.3633544137826360.297294521267376210.2686939799152690.214955183932215240.161216387949161490.107477591966107735.3738795983053977E-20135214030.650.6366455862173640.6366455862173640.702705478732623790.7313060200847310.785044816067784760.838783612050838510.892522408033892270.946261204016946021135313531$F1021$F102111111117171091393117139411818711404187018871873784186863Preferences.EnergyUnits & " / bn vehicle-km"TWh / bn vehicle-km13338264422007201020152020202520302035204020452050134913540.546297407872344*1000000000*Unit.kWh*$F$360.79408880671861848(Unit.TJ)*25200.7(Unit.TJ)*22460.62388888888888894(Unit.TJ)*19730.54805555555555552(Unit.TJ)*16960.47111111111111109(Unit.TJ)*14190.39416666666666667(Unit.TJ)*13400.37222222222222223(Unit.TJ)*12610.3502777777777778(Unit.TJ)*12060.33500000000000002(Unit.TJ)*11520.3213491864(Unit.TJ)*5080.1411111111111111(Unit.TJ)*5080.1411111111111111(Unit.TJ)*4540.12611111111111112(Unit.TJ)*3469.6111111111111105E-2(Unit.TJ)*2777.694444444444444E-2(Unit.TJ)*2476.8611111111111109E-2(Unit.TJ)*2145.9444444444444446E-2(Unit.TJ)*1774.9166666666666664E-2(Unit.TJ)*1423.9444444444444442E-2135013540.239492423538389*1000000000*Unit.kWh*$F$372.1684950349475951(Unit.TJ)*141213.9224999999999999G122+(I122-G122)/(I$119-G$119)*(H$119-G$119)3.6413888888888888(Unit.TJ)*120973.3602777777777777I122+(K122-I122)/(K$119-I$119)*(J$119-I$119)3.0791666666666666(Unit.TJ)*100732.7980555555555555K122+(M122-K122)/(M$119-K$119)*(L$119-K$119)2.777222222222222(Unit.TJ)*99232.756388888888889M122+(O122-M122)/(O$119-M$119)*(N$119-M$119)2.7355555555555555(Unit.TJ)*97732.71472222222222213501865(Unit.TJ)*98852.7458333333333331G123+(I123-G123)/(I$119-G$119)*(H$119-G$119)2.5490277777777779(Unit.TJ)*84682.3522222222222222I123+(K123-I123)/(K$119-I$119)*(J$119-I$119)2.1554166666666665(Unit.TJ)*70511.9586111111111111K123+(M123-K123)/(M$119-K$119)*(L$119-K$119)1.9440277777777779(Unit.TJ)*69461.9294444444444445M123+(O123-M123)/(O$119-M$119)*(N$119-M$119)1.9148611111111111(Unit.TJ)*68411.9002777777777777135214024390.230406475694183*1000000000*Unit.kWh*$F$387.4693980239160393E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.01003146927597340.1059406157140987(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.009529895812174760.10064358492839408(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.009028322348376099.5346554142689152E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.008526748884577429.0049523356984212E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.008025175420778758.4752492571279273E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.007523601956980087.9455461785574333E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.007022028493181417.4158430999869407E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.006520455029382736.886140021416437E-2(Constants.Density.Diesel*Constants.GCV.Diesel*1000000000)*0.006018881565584066.356436942845943E-213531353439(2.14/0.245)*Unit.TWh/(9.5/0.651)0.59855639097744362$F125*(1-0.01)^(G$119-$F$119)0.580778667609022530.55231473409035980.525245816533096430.499503545274575630.475022901445895540.451742052749674940.429602197286341750.408547415034487770.3885245266101634618675Preferences.EnergyUnits & " / bn vehicle-km"TWh / bn vehicle-km1333826442200720102015202020252030203520402045205013491864(Unit.TJ)*4170.11583333333333333(Unit.TJ)*4170.11583333333333333(Unit.TJ)*4040.11222222222222222(Unit.TJ)*3770.10472222222222222(Unit.TJ)*3559.8611111111111108E-2(Unit.TJ)*3389.3888888888888883E-2(Unit.TJ)*3279.0833333333333335E-2(Unit.TJ)*3240.09(Unit.TJ)*3259.0277777777777776E-213491355(Unit.TJ)*6000.16666666666666666(Unit.TJ)*6000.16666666666666666(Unit.TJ)*5720.15888888888888889(Unit.TJ)*5160.14333333333333334(Unit.TJ)*4700.13055555555555556(Unit.TJ)*4330.12027777777777778(Unit.TJ)*4060.11277777777777778(Unit.TJ)*3890.10805555555555556(Unit.TJ)*3790.1052777777777777813501355(Unit.TJ)*33610.93361111111111106G132+(I132-G132)/(I$129-G$129)*(H$129-G$129)0.8666666666666667(Unit.TJ)*28790.79972222222222222I132+(K132-I132)/(K$129-I$129)*(J$129-I$129)0.73277777777777775(Unit.TJ)*23970.66583333333333339K132+(M132-K132)/(M$129-K$129)*(L$129-K$129)0.66097222222222229(Unit.TJ)*23620.65611111111111109M132+(O132-M132)/(O$129-M$129)*(N$129-M$129)0.65111111111111108(Unit.TJ)*23260.64611111111111108135214034390.10954818290623*1000000000*Unit.kWh*$F$383.5513714554162835E-2(1000000000*Unit.kWh)*0.03185791833536213.1857918335362098E-2(1000000000*Unit.kWh)*0.0306632463977863.0663246397786E-2(1000000000*Unit.kWh)*0.029468574460212.9468574460209999E-2(1000000000*Unit.kWh)*0.02827390252263392.8273902522633901E-2(1000000000*Unit.kWh)*0.02707923058505782.70792305850578E-2(1000000000*Unit.kWh)*0.02588455864748172.5884558647481699E-2(1000000000*Unit.kWh)*0.02468988670990562.4689886709905601E-2(1000000000*Unit.kWh)*0.02349521477232962.34952147723296E-2(1000000000*Unit.kWh)*0.02230054283475352.2300542834753499E-21869107Preferences.EnergyUnits & " / bn vehicle-km"TWh / bn vehicle-km1333826442200720102015202020252030203520402045205013491356(Unit.TJ)*8750.24305555555555555(Unit.TJ)*8750.24305555555555555(Unit.TJ)*8340.23166666666666666(Unit.TJ)*7530.20916666666666667(Unit.TJ)*6710.18638888888888888(Unit.TJ)*5900.16388888888888889(Unit.TJ)*5350.14861111111111111(Unit.TJ)*5060.14055555555555554(Unit.TJ)*4880.13555555555555557135013566.46.45.965.555.174.824.494.183.891885Preferences.EnergyUnitsTWh133379442200720102015202020252030203520402045205013521414(8434-2900-1246)*Unit.GWh4.2880000000000003F$1444.2880000000000003G$1444.28800000000000034.28800000000000034.28800000000000034.28800000000000034.28800000000000034.28800000000000034.28800000000000034.288000000000000371710918751404439187411714151673812114051401831333442200720102015202020252030203520402045205013951396F252.1680038900835603E-2$F160+($O160-$F160)/($O$159-$F$159)*(G$159-$F$159)2.1702361768219165E-2$F160+($O160-$F160)/($O$159-$F$159)*(H$159-$F$159)2.1739566547191769E-22.1776771326164374E-22.1813976105136978E-22.1851180884109582E-22.1888385663082186E-22.192559044205479E-22.1962795221027395E-2INDEX($G25:$J25, MATCH($E$8, $G$24:$J$24, 0))2.1999999999999999E-2135113445.084268859379436E-35.3574594040738943E-35.8127769785646568E-36.2680945530554201E-36.7234121275461835E-37.178729702036946E-37.6340472765277102E-38.0893648510184726E-38.5446824255092368E-38.9999999999999993E-3134913970.832103179442072020.83007272506239260.826688634429593510.823304543796794410.819920453163995420.816536362531196320.813152271898397230.809768181265598130.806384090632799140.80300000000000005135013985.9627670922358024E-26.1607135741728394E-26.4906243774012343E-26.8205351806296291E-27.1504459838580239E-27.4803567870864202E-27.810267590314815E-28.1401783935432098E-28.4700891967716047E-28.7999999999999995E-2135213997.0097236274669239E-26.9183475604343472E-26.7660541153800546E-26.6137606703257606E-26.4614672252714681E-26.3091737802171741E-26.1568803351628808E-26.0045868901085875E-25.8522934450542935E-25.7000000000000002E-2135314001.1407605600685865E-21.2076842419242666E-21.3192237116837332E-21.4307631814431999E-21.5423026512026667E-21.6538421209621332E-21.7653815907216E-21.8769210604810668E-21.9884605302405337E-22.1000000000000001E-2148SUM(F160:F165)11.00000000000000021.00000000000000021.00000000000000021.00000000000000021111121406123914111333826442200720102015202020252030203520402045205013491354CHOOSE($E$9, $F$47:$O$57, $F$62:$O$72, $F$77:$O$87, $F$92:$O$102)110.984999999999999990.970.704999999999999960.440.410000000000000030.380.290000000000000040.213491864005.0000000000000001E-30.010.227500000000000010.445000000000000010.382500000000000010.320.320.3213491355000.010.020.050.080.140000000000000010.20.240000000000000020.280000000000000031349135600001.7500000000000002E-23.5000000000000003E-26.7500000000000004E-20.10.150000000000000020.21350135410.988999999999999990.711999999999999970.4350.2175000001350186501.0999999999999999E-20.271000000000000020.531000000000000030.727999999999999980.925000000000000040.892500000000000070.860.820000000000000060.7813501355008.5000000000000006E-31.7000000000000001E-22.725E-23.7499999999999999E-25.3750000000000006E-27.0000000000000007E-20.090.1113501356008.5000000000000006E-31.7000000000000001E-22.725E-23.7499999999999999E-25.3750000000000006E-27.0000000000000007E-20.090.11135214020.350.3633544137826360.3633544137826360.297294521267376210.282994250591322550.241824581923742120.214955183932215240.188085785940688370.161216387949161490.1343469899576345135214030.650.6366455862173640.6366455862173640.702705478732623790.717005749408677450.758175418076257880.785044816067784760.811914214059311630.838783612050838510.8656530100423655135313531111111111318661872831333442200720102015202020252030203520402045205013491397$F$36:$F$391.4535833325868115$F188+($O188-$F188)/($O$159-$F$159)*(G$159-$F$159)1.45358333258681151.45358333258681151.45358333258681151.45358333258681151.45358333258681151.45358333258681151.45358333258681151.4535833325868115INDEX($G$36:$J$39, ,MATCH($E$8, $G$35:$J$35, 0))1.4535833325868115135013989.05454545454545479.26004228329809829.6025369978858359.945031712473573610.2875264270613110.63002114164904910.97251585623678611.31501057082452511.65750528541226112135213990.324183510963039160.327248503005185650.332356823075429740.337465143145673880.342573463215917970.347681783286162120.35279010335640620.357898423426650350.363006743496894440.36811506356713858135314000.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000020.651000000000000024186863Preferences.EnergyUnits & " / bn passenger-km"TWh / bn passenger-km1333826442200720102015202020252030203520402045205013491354F120/INDEX(F$188:F$191, MATCH($C196, $C$188:$C$191, 0))0.546297407872344040.481568537769536010.429207514218403970.377037589293370830.324103269863941720.271168950434512560.256072158972689810.240975367510867070.230464943075420840.2201456172660736213491864G121/INDEX(G$188:G$191, MATCH($C197, $C$188:$C$191, 0))9.7078102058303292E-29.7078102058303292E-28.6758776248956102E-26.6120124630261692E-25.2934319429429159E-24.7201360646458489E-24.0895105985190756E-23.3824456819526935E-22.7136004906061155E-213501354F122/INDEX(F$188:F$191, MATCH($C198, $C$188:$C$191, 0))0.23949242353838901G122/INDEX(G$188:G$191, MATCH($C198, $C$188:$C$191, 0))0.423594178082191740.379211128235236560.337885074168556290.299310693245650070.263222012286749740.253107150503104280.243604623401428330.234660460242614780.2262268518518518513501865G123/INDEX(G$188:G$191, MATCH($C199, $C$188:$C$191, 0))0.29652492389649920.265453575272762870.236522345049130750.209517485271955050.18425279545655440.177172473774352410.170520781431655890.164259939346310420.1583564814814814913521402439F124/INDEX(F$188:F$191, MATCH($C200, $C$188:$C$191, 0))0.23040647569418302G124/INDEX(G$188:G$191, MATCH($C200, $C$188:$C$191, 0))0.323731399047591460.302817869051397850.282537488920835970.262861934814336730.243764547484281310.225220211762302340.207205246365294030.189697303005483930.1726752739007819913531353439F125/INDEX(F$188:F$191, MATCH($C201, $C$188:$C$191, 0))0.91944146079484423G125/INDEX(G$188:G$191, MATCH($C201, $C$188:$C$191, 0))0.892133129967776490.848409729785498890.806829211264357030.767286551881068530.729681876260976250.693920203916551290.659911209349219210.627568993908583340.5968118688328163418675Preferences.EnergyUnits & " / bn passenger-km"TWh / bn passenger-km1333826442200720102015202020252030203520402045205013491864G130/INDEX(G$188:G$191, MATCH($C206, $C$188:$C$191, 0))7.9688127083292273E-27.9688127083292273E-27.7203844944004979E-27.2044182039331384E-26.7840012265152891E-26.4591335621469514E-26.2489250734380275E-26.19159548560832E-26.2107053482182227E-213491355G131/INDEX(G$188:G$191, MATCH($C207, $C$188:$C$191, 0))0.114659175659413330.114659175659413330.109308414128640729.8606891067095484E-28.9816354266540457E-28.2745705100876629E-27.7586042196203034E-27.4337365552519657E-27.2426379291529425E-213501355G132/INDEX(G$188:G$191, MATCH($C208, $C$188:$C$191, 0))0.100821473871131389.0253926317334518E-28.0414245559334838E-27.1229734666849343E-26.2637065765049058E-26.023889424106188E-25.7985903504401262E-25.5853383307137391E-25.3842592592592588E-213521403439F133/INDEX(F$188:F$191, MATCH($C209, $C$188:$C$191, 0))0.10954818290623002G133/INDEX(G$188:G$191, MATCH($C209, $C$188:$C$191, 0))9.7350845130855401E-29.2260017754553073E-28.7323313411036566E-28.2533837435076987E-27.7885100361355528E-27.3370988588452049E-26.8985737555129753E-26.4723907181439472E-26.0580359354640262E-21869107Preferences.EnergyUnits & " / bn passenger-km"TWh / bn passenger-km1333826442200720102015202020252030203520402045205013491356G138/INDEX(G$188:G$191, MATCH($C214, $C$188:$C$191, 0))0.167211297836644460.167211297836644460.159376254166584550.143897265452563730.128227178112443910.112748189398423130.10223776496297699.6695904806105251E-29.3256129536322854E-213501356G139/INDEX(G$188:G$191, MATCH($C215, $C$188:$C$191, 0))0.69114155251141551H139/INDEX(H$188:H$191, MATCH($C215, $C$188:$C$191, 0))0.666490532804931760.59929421768707480.53948828606658450.486358392999204410.439279383429672490.396818011958146480.358567283278926340.3241666666666666631703222327431723173327313493400869.62940000000003759.6159999999999932623263134918641655.5070000000001889.6159999999999932645536134913552393.86511223.30230000000013265144811349340216306.279933.33600000000001326620272135034012864.02039999999992046.0586000000001326754000135018653305.1722185.3890000000001326863537135013555366.74709999999962494.317300000000232691860001350340312794.0632275.590999999999932701860001352140219696.4718539.12327110000001352140318655.906118539.1175327217000001353339944269.21710000000244269.21710000000232751349340082.39530000000000681.85439999999999813491864150.9190000000000177.34720000000000113491355111.51461.021999999999998134934021095.469000000000178.76699999999999613503401303.43490000000003300.9456999999999913501865304.57260000000002300.9456999999999913501355460.94569999999999241.78380000000001135034031138.8810000000001244.9079999999999913521402203.93029999999999203.9302999999999913521403145.91560000000001145.91560000000001135333991161.9480000000001611.78499999999997Preferences.moneyunits&" per veh/unit"£m per veh/unit"Cost per Vehicle/Unit"Cost per Vehicle/Unit3237330633101801179918011799331813491354((E224/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.6310619808050979E-2((F224/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.4247227354678272E-2((E237/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.5453921087193038E-3((F237/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.5352470811314887E-31213491864((E225/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20003.1050405226142372E-2((F225/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.6685485048181535E-2((E238/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20002.8306108680447627E-3((F238/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.4507108113148894E-31213491355((E226/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20004.4898923056030465E-2((F226/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20002.2944048034271067E-2((E239/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20002.0915374494871E-3((F239/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.1445181613304321E-31213491356((E227/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20000.30583777095508241((F227/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.7505489866335093E-2((E240/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20002.0546428594187132E-2((F240/1000000000)*XII.a!$J$226*1000)*(kGBP)*Price20001.4773403364936276E-31213501354((E228/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.23568964894156047((F228/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.16837688486711222((E241/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20002.4970654907911099E-2((F241/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20002.4765810461221633E-21513501865((E229/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.27199346358408455((F229/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.17984284127681074((E242/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20002.5064279979017726E-2((F242/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20002.4765810461221633E-21513501355((E230/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.44164725221829348((F230/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.20526556612022076((E243/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20003.7932736168402238E-2((F243/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20001.9897183323748836E-21513501356((E231/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20001.0528654813374263((F231/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20000.1872658602308051((E244/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20009.3722259476997222E-2((F244/1000000000)*XII.a!$J$229*1000)*(kGBP)*Price20002.0154284006838667E-21513521402((E232/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.7450308517252102((F232/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.4662163506372403((E245/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.912837503885608E-2((F245/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.912837503885608E-24013521403((E233/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.4943510188063414((F233/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20004.4662157483680449((E246/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20003.5152188374261734E-2((F246/1000000000)*XII.a!$J$230*1000)*(kGBP)*Price20003.5152188374261734E-24013531353((E234/1000000000)*XII.a!$J$232*1000)*(kGBP)*Price200057.337603745725851((F234/1000000000)*XII.a!$J$232*1000)*(kGBP)*Price200057.337603745725851((E247/1000000000)*XII.a!$J$232*1000)*(kGBP)*Price20001.5049580354367427((F247/1000000000)*XII.a!$J$232*1000)*(kGBP)*Price20000.7923855040928401430442109331711734048127311140721408314094141320072010201520202025203020352040204520501198813621364INDEX(F$17:F$20, MATCH($E$8, $C$17:$C$20, 0))14104.0042132126751407914018143731466714792149341495614984150238338141886INDEX(Global.Assumptions[Population], MATCH(F$280, Global.Assumptions[Year], 0))/100000060.972999999999999INDEX(Global.Assumptions[Population], MATCH(G$280, Global.Assumptions[Year], 0))/100000062.222403INDEX(Global.Assumptions[Population], MATCH(H$280, Global.Assumptions[Year], 0))/100000064.344155999999998INDEX(Global.Assumptions[Population], MATCH(I$280, Global.Assumptions[Year], 0))/100000066.521962000000002INDEX(Global.Assumptions[Population], MATCH(J$280, Global.Assumptions[Year], 0))/100000068.647527999999994INDEX(Global.Assumptions[Population], MATCH(K$280, Global.Assumptions[Year], 0))/100000070.575665999999998INDEX(Global.Assumptions[Population], MATCH(L$280, Global.Assumptions[Year], 0))/100000072.278230000000022INDEX(Global.Assumptions[Population], MATCH(M$280, Global.Assumptions[Year], 0))/100000073.853252999999995INDEX(Global.Assumptions[Population], MATCH(N$280, Global.Assumptions[Year], 0))/100000075.356458000000003INDEX(Global.Assumptions[Population], MATCH(O$280, Global.Assumptions[Year], 0))/100000076.78948300000000483513451365F283*F284/1000859.96344889221643G283*G284/1000876.02921183699993901.97637880800005956.120159825999961006.85329317599991043.95525147199991079.40308682000021104.54925186800011129.14116667200011153.6084031090002833135713951396INDEX(F$160:F$165, MATCH($C288, $C$160:$C$165, 0))2.1680038900835603E-22.1702361768219165E-22.1739566547191769E-22.1776771326164374E-22.1813976105136978E-22.1851180884109582E-22.1888385663082186E-22.192559044205479E-22.1962795221027395E-22.1999999999999999E-2135113445.084268859379436E-35.3574594040738943E-35.8127769785646568E-36.2680945530554201E-36.7234121275461835E-37.178729702036946E-37.6340472765277102E-38.0893648510184726E-38.5446824255092368E-38.9999999999999993E-3134913970.832103179442072020.83007272506239260.826688634429593510.823304543796794410.819920453163995420.816536362531196320.813152271898397230.809768181265598130.806384090632799140.80300000000000005135013985.9627670922358024E-26.1607135741728394E-26.4906243774012343E-26.8205351806296291E-27.1504459838580239E-27.4803567870864202E-27.810267590314815E-28.1401783935432098E-28.4700891967716047E-28.7999999999999995E-2135213997.0097236274669239E-26.9183475604343472E-26.7660541153800546E-26.6137606703257606E-26.4614672252714681E-26.3091737802171741E-26.1568803351628808E-26.0045868901085875E-25.8522934450542935E-25.7000000000000002E-2135314001.1407605600685865E-21.2076842419242666E-21.3192237116837332E-21.4307631814431999E-21.5423026512026667E-21.6538421209621332E-21.7653815907216E-21.8769210604810668E-21.9884605302405337E-22.1000000000000001E-28351346133413951396F288*F$28518.644041025280004G288*G$28519.01190287481447419.60857551109156920.82121008086653521.96347367871973722.81165503483077523.62639105023755124.2178945195357924.79909621924910125.379384868398002135113444.37228538340723554.6932909391995775.24298752994425685.9930515658718286.76948964199933027.49427257133949448.24021419521382558.93510189427975029.648152682781235610.38247562798113491397715.57832002718305727.16795510379859745.65362088453526787.17807200046309825.53960841052697852.4274236822871877.71907234182606894.42883880342742910.52147288285869926.347547696527161350139851.27761753580113453.96965056736139158.54389872131294965.21251187002457171.99450086524554178.09157750763084584.3042694587601689.91227954660210795.63926397458593101.517539473592011352139960.28106106457713860.60674560581732461.0282098980946863.23549909162778765.05749554513367665.86495100307168166.45755638956171766.32361957245841266.08065448255503365.755678977213009135314009.810123855967981810.57966674600879911.89908626302142713.67981521714628515.52872503437480517.26537167284009319.05558338440097220.73151753169655722.45252642997019924.225776465289005SUM(F296:F301)859.96344889221655SUM(G296:G301)876.02921183700016901.97637880800016956.120159826000081006.8532931761043.95525147199991079.40308682000021104.54925186800011129.14116667200031153.60840310900023291198914101334133382613491354SUMIFS(F$296:F$301, $C$296:$C$301, $C308)*SUMIFS(F$173:F$183, $C$173:$C$183, $C308, $D$173:$D$183, $D308)715.57832002718305727.16795510379859734.46881657126721763.56272984044915582.00542392942145375.06806642020632359.86481966014873339.8829587453024264.05122713602907185.2695095393054313491864003.72826810442267627.8717807200046312187.8102609133949379.33020353861775335.7275451707485286.21722841709681291.36687132251478296.4312152628887113491355007.456536208845352415.74356144000926241.2769804205263568.194193894582966122.88067012785567178.8857677606855218.5251534918861259.3773133550276413491356000014.44694314718422329.83495982888005259.24603738307326589.442883880342748136.57822093242882185.269509539305431350135451.27761753580113453.37598441112041341.68325588957481628.3674426634606915.658803938190905000001350186500.593666156240975315.8653965534758134.62784380298305152.41199662989875272.23470919455853375.24156049194344677.32456041007780878.4241964591604779.18368078940177713501355000.497623139131160131.10861270179041771.96185014857794092.92843415653615674.5313544834083596.29385956826214798.607533757712733511.16692934209512213501356000.497623139131160131.10861270179041771.96185014857794092.92843415653615674.5313544834083596.29385956826214798.607533757712733511.1669293420951221352140221.09837137260199622.02172852087510422.17486943172585618.79956742954908618.41089719714340915.92776423974556914.28539625740380512.47453011371706210.6532844289940898.83407754320907481352140339.18268969197514238.58501708494222338.8533404663688244.43593166207870146.64659834799026349.9371867633261152.17216013215791353.84908945874134655.42737005356094256.921601434003932135313539.810123855967981810.57966674600879911.89908626302142713.67981521714628515.52872503437480517.26537167284009319.05558338440097220.73151753169655722.45252642997019924.2257764652890053292329414103295133382613491354F308/F$188492.28572176438809G308/G$188500.25886978885706505.28153433363821525.29683900654345400.39357282232919258.0299718714657247.57082142633658233.82419922251259181.65537621164165127.4570954316034613491864F309/F$188002.56488088494232575.4154313299643659129.20501818025519260.96213064273235230.96546145261888196.90458881895802200.44731168181144203.9313526905655513491355F310/F$188005.129761769884651410.83086265992873228.39670729236377546.91454034026648484.536378048017369123.06536801184875150.3354837613586178.4399336042448913491356F311/F$18800009.938847552327322520.52511139886659240.75861084457980661.53268400592437493.95967735084912127.4570954316034613501354F312/F$1895.6631906917049442G312/G$1895.76411886448857394.34085866045109812.8524235501311451.52211554927338640000013501865F313/F$18906.4110523265292527E-21.65220884407619063.48192391981525965.09471319480931146.79534953242366416.85727516622143626.83380363863355816.72735671475932236.598640065783481413501355F314/F$189005.1822048614935876E-20.111474023798228640.190701833184826560.275487143206364750.412973154268237770.556239831051568710.738368419912608490.9305774451745935113501356F315/F$189005.1822048614935876E-20.111474023798228640.190701833184826560.275487143206364750.412973154268237770.556239831051568710.738368419912608490.9305774451745935113521402F316/105.80.19941749879586007G316/105.80.20814488204985920.209592338674157440.177689673247155820.174016041560901810.150545975800997820.135022648935763770.117906711849877720.100692669461191788.3497897383828693E-213521403F317/105.80.37034678347802591G317/105.80.364697704016467120.367233841837134420.41999935408391970.440894124272119710.471996094171324320.493120606164063450.508970599799067560.523888185761445580.5380113557089218913531353F318/64.80.15139080024641949G318/64.80.163266462129765420.183627874429343030.211108259523862420.239640818431709950.266440920877161920.294067644821002670.319930826106428370.346489605400774670.373854575081620453293329614103297133382613491354F324*1000000000/XII.a!$J$226/100033995.284977859817G324*1000000000/XII.a!$J$226/100034545.878723075555H324*1000000000/XII.a!$J$226/100034892.723868078043I324*1000000000/XII.a!$J$226/100036274.900836029519J324*1000000000/XII.a!$J$226/100027649.580334391903K324*1000000000/XII.a!$J$226/100017818.518877941144L324*1000000000/XII.a!$J$226/100017096.251738577208M324*1000000000/XII.a!$J$226/100016146.964934915586N324*1000000000/XII.a!$J$226/100012544.394462512371O324*1000000000/XII.a!$J$226/10008801.677745432185513491864F325*1000000000/XII.a!$J$226/10000G325*1000000000/XII.a!$J$226/10000H325*1000000000/XII.a!$J$226/1000177.12042572628448I325*1000000000/XII.a!$J$226/1000373.96804985597447J325*1000000000/XII.a!$J$226/10008922.382306488169K325*1000000000/XII.a!$J$226/100018021.002047008657L325*1000000000/XII.a!$J$226/100015949.551926843373M325*1000000000/XII.a!$J$226/100013597.444155718389N325*1000000000/XII.a!$J$226/100013842.090441392958O325*1000000000/XII.a!$J$226/100014082.68439269149713491355F326*1000000000/XII.a!$J$226/10000G326*1000000000/XII.a!$J$226/10000H326*1000000000/XII.a!$J$226/1000354.24085145256896I326*1000000000/XII.a!$J$226/1000747.93609971194894J326*1000000000/XII.a!$J$226/10001960.9631442831139K326*1000000000/XII.a!$J$226/10003239.7307050802074L326*1000000000/XII.a!$J$226/10005837.7444960995344M326*1000000000/XII.a!$J$226/10008498.4025973239932N326*1000000000/XII.a!$J$226/100010381.567831044722O326*1000000000/XII.a!$J$226/100012322.34884360505913491356F327*1000000000/XII.a!$J$226/10000G327*1000000000/XII.a!$J$226/10000H327*1000000000/XII.a!$J$226/10000I327*1000000000/XII.a!$J$226/10000J327*1000000000/XII.a!$J$226/1000686.33710049908996K327*1000000000/XII.a!$J$226/10001417.3821834725911L327*1000000000/XII.a!$J$226/10002814.6268106194188M327*1000000000/XII.a!$J$226/10004249.2012986619966N327*1000000000/XII.a!$J$226/10006488.4798944029499O327*1000000000/XII.a!$J$226/10008801.677745432185513501354F328*1000000000/XII.a!$J$229/100089.132170100963918G328*1000000000/XII.a!$J$229/100090.720664565348912H328*1000000000/XII.a!$J$229/100068.320170301573867I328*1000000000/XII.a!$J$229/100044.893897258780633J328*1000000000/XII.a!$J$229/100023.956364783880048K328*1000000000/XII.a!$J$229/10000L328*1000000000/XII.a!$J$229/10000M328*1000000000/XII.a!$J$229/10000N328*1000000000/XII.a!$J$229/10000O328*1000000000/XII.a!$J$229/1000013501865F329*1000000000/XII.a!$J$229/10000G329*1000000000/XII.a!$J$229/10001.0090266028501902H329*1000000000/XII.a!$J$229/100026.003885044559716I329*1000000000/XII.a!$J$229/100054.801515964166697J329*1000000000/XII.a!$J$229/100080.184981897308845K329*1000000000/XII.a!$J$229/1000106.95106052258785L329*1000000000/XII.a!$J$229/1000107.92569945419891M329*1000000000/XII.a!$J$229/1000107.55628434823109N329*1000000000/XII.a!$J$229/1000105.88093102852389O329*1000000000/XII.a!$J$229/1000103.8550776049149513501355F330*1000000000/XII.a!$J$229/10000G330*1000000000/XII.a!$J$229/10000H330*1000000000/XII.a!$J$229/10000.81562001062272182I330*1000000000/XII.a!$J$229/10001.7544741457454498J330*1000000000/XII.a!$J$229/10003.0014296108539367K330*1000000000/XII.a!$J$229/10004.3358538049697772L330*1000000000/XII.a!$J$229/10006.4997269979419512M330*1000000000/XII.a!$J$229/10008.7545812841583448N330*1000000000/XII.a!$J$229/100011.621077795813596O330*1000000000/XII.a!$J$229/100014.64622889300082813501356F331*1000000000/XII.a!$J$229/10000G331*1000000000/XII.a!$J$229/10000H331*1000000000/XII.a!$J$229/10000.81562001062272182I331*1000000000/XII.a!$J$229/10001.7544741457454498J331*1000000000/XII.a!$J$229/10003.0014296108539367K331*1000000000/XII.a!$J$229/10004.3358538049697772L331*1000000000/XII.a!$J$229/10006.4997269979419512M331*1000000000/XII.a!$J$229/10008.7545812841583448N331*1000000000/XII.a!$J$229/100011.621077795813596O331*1000000000/XII.a!$J$229/100014.64622889300082813521402F332*1000000000/XII.a!$J$230/10001.0721370903003231G332*1000000000/XII.a!$J$230/10001.1190585056444042H332*1000000000/XII.a!$J$230/10001.1268405305062228I332*1000000000/XII.a!$J$230/10000.95532082390943995J332*1000000000/XII.a!$J$230/10000.93557011591882699K332*1000000000/XII.a!$J$230/10000.80938696667203136L332*1000000000/XII.a!$J$230/10000.72592822008475155M332*1000000000/XII.a!$J$230/10000.63390705295633176N332*1000000000/XII.a!$J$230/10000.54135843796339667O332*1000000000/XII.a!$J$230/10000.4489134267947779113521403F333*1000000000/XII.a!$J$230/10001.9911117391291717G333*1000000000/XII.a!$J$230/10001.9607403441745543H333*1000000000/XII.a!$J$230/10001.9743754937480347I333*1000000000/XII.a!$J$230/10002.2580610434619337J333*1000000000/XII.a!$J$230/10002.3703985175920415K333*1000000000/XII.a!$J$230/10002.537613409523249L333*1000000000/XII.a!$J$230/10002.6511860546455024M333*1000000000/XII.a!$J$230/10002.7364010741885356N333*1000000000/XII.a!$J$230/10002.8166031492550836O333*1000000000/XII.a!$J$230/10002.892534170478074713531353F334*1000000000/XII.a!$J$232/10000.15139080024641952G334*1000000000/XII.a!$J$232/10000.16326646212976542H334*1000000000/XII.a!$J$232/10000.18362787442934303I334*1000000000/XII.a!$J$232/10000.21110825952386242J334*1000000000/XII.a!$J$232/10000.23964081843170992K334*1000000000/XII.a!$J$232/10000.26644092087716192L334*1000000000/XII.a!$J$232/10000.29406764482100267M334*1000000000/XII.a!$J$232/10000.31993082610642842N334*1000000000/XII.a!$J$232/10000.34648960540077467O334*1000000000/XII.a!$J$232/10000.37385457508162045329838511410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354IF(G340>F340,((G340-F340)/5+F340/$J252)*$E252*1000,((G340-F340)*$E252*1000/5))48003.11909439913948086.84300740769751935.66202963415-28136.864684959739-32070.141145150457-2356.1249420027457-3096.6912286649303-11752.031461415889-12209.20588430632213491864IF(G341>F341,((G341-F341)/5+F341/$J253)*$E253*1000,((G341-F341)*$E253*1000/5))01099.9321985255971680.74478212504654054.00029934397879590.131504932942-12863.873127374674-14606.77988579785436703.11918436129837310.9843850692851349135503181.00654653432234860.717926213843413691.18203713314718820.15170799521435451.30589776785245734.50675231774248707.84521249201556271.2300742301231349135600041981.56178808321462208.557140559118121590.12041450228159484.3452242488245268.38264728693306861.17388996249135013541475.3803325643448-1055.9129258293158-1104.2660138930157-986.95193574236816-1129.253441165730200001350186554.8897281115411531377.98419990807432038.07925936215072374.53763916827032910.0257499491241992.3517094525378-20.095698834493668-91.137030430851027-110.2037778802140313501355072.043267309156079106.94289223853239161.80013666451717206.24049841565852318.79492456400612390.542477852697510.95851280452189609.37107234598579135013560171.74763101454576254.94663251450672385.72362425917976491.66727641802527759.99153173290802931.034194963930871218.10014174272531452.710877688292613521402171.71180195170376140.13436796584955-162.77325989611813-18.743543751774826-119.74858722877839-79.202865480591754-87.328655407222726-87.829206685183081-87.73088601663552313521403-27.299941971370878232.56261376181976476.83490067127866354.68978204160743416.6395587950438387.21020197343239374.48126062369619379.5499294481948384.722213354204613531353425.53058956635289545.5385083794074666.09129628921994730.67910236958414765.34507382373101826.04616148693287858.62437113570638916.03225040765312976.03781416424522329938521410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354IF(G340>F340,((G340-F340)/5+F340/$J252)*$F252*1000,((G340-F340)*$F252*1000/5))41930.433025851125IF(H340>G340,((H340-G340)/5+G340/$J252)*$F252*1000,((H340-G340)*$F252*1000/5))42003.56535544337445365.485399070654-24577.380438759752-28013.073541573696-2058.0608290662176-2704.9409833125924-10265.328116315861-10664.66719847929713491864IF(G341>F341,((G341-F341)/5+F341/$J253)*$F253*1000,((G341-F341)*$F253*1000/5))0591.06804303669355903.1779691024892129046.87417830379542769.166441997775-6912.6300016143377-7849.211809363501719723.07098448678220049.7181133681661349135501625.54382228576472483.9024633378996996.40697203182759617.3902492414818116.16871925781723371.04429964572424890.46649975618528755.473804114903134913560002402.93343153532623560.68272150506356959.55445305393559128.537591820881114038.62960927432517564.06722795323135013541054.0129594447505-754.34508872361164-788.88857579838611-705.07929898555176-806.7396150099824600001350186536.293242236093256911.127019305774981347.58372470122341570.05094945869931924.11719077118191317.3485403993418-13.287332453565293-60.260060231735942-72.86704714243710213501355033.48374064389069849.70413199135229175.20027914575470695.854944079403282148.16716358633622181.51346443972537237.47954474519409283.2190113583224613501356030.54755658214447745.3455843097160668.60597824565746887.44943879136521135.17440782397426165.59657668968538216.65500002997246258.3835798580622613521402161.62214355155368131.90017621650176-153.20882361181071-17.64218699286744-112.71224886818757-74.548963722359801-82.197288246734132-82.668427502055522-82.57588408322547513521403-27.129040489243589231.10673904161072473.84984702756748352.4693740455067414.03133647041384.78621156783129372.13695518390432377.17389342760436382.3137981078103313531353425.53058956635289545.5385083794074666.09129628921994730.67910236958414765.34507382373101826.04616148693287858.62437113570638916.03225040765312976.03781416424522330138531410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354$E252*F340*1000/$J25246207.014045018186$E252*AVERAGE(F340:G340)*1000/$J25246581.202596972551$E252*AVERAGE(G340:H340)*1000/$J25247191.11028611040848366.1695496147843443.66286656905930900.53665196277123728.39788380585422592.39451491675619498.91062114991714506.98617412445513491864$E253*F341*1000/$J2530$E253*AVERAGE(F341:G341)*1000/$J2530229.15254135949939712.9800200952586212027.3102370282834858.45843082418343949.97777686027338226.92506578266335500.36118571086336128.1489352960421349135500662.709697194650522061.93992185274745067.77744677805919729.398040855610816982.03585836641326819.89855281490635320.43081514406442474.2253269011491349135600008746.158705850668426808.20068854670253929.50822562337390016.060139686786136832.85338805386194846.15542162504135013541400.50199203304261412.98171545492641249.4759512385906889.44612795153523540.90980301230468188.2089068609550100001350186509.1482880185901916244.91118001566267732.618029888812541223.84816968094511696.65934464019571948.16913966040741953.65637047975131935.11758226886061901.560780883683135013550012.00721121819268237.83583407007654470.014394197225968108.01636864484659159.51681625984185224.56744457601178299.96179482687762386.69612740966966135013560028.62460516909095990.198780700902731166.91089659621625257.50574784367831380.2802999209411535.3578210634339715.09427016006521921.8646833452131713521402127.18308926884826129.96613381152673133.21075270493299123.49899831215336112.15419808416004103.4984398978754991.06397410353984980.65575404805144969.70838766727608558.73588187341240313521403223.71887683281147222.01263045960081221.07239844110444237.77569328803511260.02402429658605275.72910506180352291.5035769771078302.67134626728989311.9643773633718320.7358391181003313531353289.34619050925124300.69489043067642331.50150018771035377.22040054547756430.74786700946498483.62523719066377535.63696726810838586.75335044197698636.84917716359416688.38015301731991330238541410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354$F252*F340*1000/$J25240361.546172220646$F252*AVERAGE(F340:G340)*1000/$J25240688.397600060329$F252*AVERAGE(G340:H340)*1000/$J25241221.14826280487642247.55539382659537947.77569853518126991.43111929904320726.61145874905619734.31941450347617032.18001874754612671.7643281652213491864$F253*F341*1000/$J2530$F253*AVERAGE(F341:G341)*1000/$J2530123.13917563264449383.132438314705726463.088119726552618731.8098657366523617.29876704799220541.9150564276119076.74767704838819414.1005403313391349135500338.654962976201031053.68337124104732589.71309892597084971.87372880542268678.084460240517713705.38531407854118049.28951642121321704.989781218846134913560000500.611131569859541534.44319196583253086.80794001319375152.32380768994977832.015388047305411152.570817450003135013541000.51980953639091009.4353345211176892.62667805190881635.42106729824241386.4264215009195134.4566025016637500001350186506.0488737060155433161.93595939432174484.40909693071427809.211843647129971121.83591913640021288.13490128602071291.76307369975731279.5051749188741257.317323689844913501355005.580623440648448517.58506106630613232.54077590038858950.20305447111873374.139054258369072104.37280750992298139.41403987076853179.7257859310984413501356005.091259430357413716.04302976888170229.68728027181672545.80075635404826867.63781200525542795.220372089113567127.18884417935199163.9656594342404513521402119.70990507059847122.32941997565815125.38338746420436116.24228857195268105.564100409160397.41694816784436785.71312238093514775.91648163286677765.61237439856742555.28460492448736113521403222.31836515147984220.62280012090213219.68845408727975236.28718395569348258.39623727829888274.00300202575636289.67872352492685300.77658100629452310.01143641872693318.727987587349513531353289.34619050925124300.69489043067642331.50150018771035377.22040054547756430.74786700946498483.62523719066377535.63696726810838586.75335044197698636.84917716359416688.38015301731991385533001410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354$G252*F340*100052536.045138448448$G252*AVERAGE(F340:G340)*100052961.486752931756$G252*AVERAGE(G340:H340)*100053654.93424243228254990.942807012398$G252*AVERAGE(I340:J340)*100049394.19437737249235133.020860602948$G252*AVERAGE(K340:L340)*100026978.50549425603825686.902357830873$G252*AVERAGE(M340:N340)*100022169.70020060730216494.02577115498213491864$G253*F341*10000$G253*AVERAGE(F341:G341)*10000250.67950100676799$G253*AVERAGE(H341:I341)*1000779.9585141186815913157.175175909768$G253*AVERAGE(J341:K341)*100038133.11828645766948078.709635943385$G253*AVERAGE(L341:M341)*100041818.02411468767238835.32242233683139522.08556653117613491355$G254*F342*100000370.45400347562236$G254*AVERAGE(H342:I342)*10001152.62218466105172832.8821078514839$G254*AVERAGE(J342:K342)*10005438.72297463030469492.93966502894$G254*AVERAGE(L342:M342)*100014992.29426362547219744.08259807108723743.04598753231813491356$G255*F343*1000000$G255*AVERAGE(H343:I343)*100007050.8881134729954$G255*AVERAGE(J343:K343)*100021611.95902516931243476.335303534594$G255*AVERAGE(L343:M343)*100072568.219924481251110310.4999502275157079.0660703687213501354$G256*F344*10002225.68866078440172245.52153433104381985.6769018640018$G256*AVERAGE(H344:I344)*10001413.5147058852724859.61806689326511$G256*AVERAGE(J344:K344)*1000299.103058933151490$G256*AVERAGE(L344:M344)*100000013501865$G257*F345*1000012.645262640057148338.52959028957548$G257*AVERAGE(H345:I345)*10001012.66459734976011691.66968789355$G257*AVERAGE(J345:K345)*10002345.21508068881442692.8656365211868$G257*AVERAGE(L345:M345)*10002700.4503862291342674.82506207244712628.441021035095213501355$G258*F346*10000015.469349338310568$G258*AVERAGE(H346:I346)*100048.74535178073309590.202221220698817$G258*AVERAGE(J346:K346)*1000139.16161800261705205.51161391412734$G258*AVERAGE(L346:M346)*1000289.3188257481919386.45225006894253498.195407240652413501356$G259*F347*10000038.220875135106979$G259*AVERAGE(H347:I347)*1000120.43751570172603222.86702296181679$G259*AVERAGE(J347:K347)*1000343.83339007704933507.76755779723146$G259*AVERAGE(L347:M347)*1000714.83411947855586954.826403653982311230.915666625465113521402$G260*F348*100052.67235306534217953.82493951053115955.168685073706698$G260*AVERAGE(H348:I348)*100051.14660195557260646.448199624729071$G260*AVERAGE(J348:K348)*100042.86345299011593137.713770148919295$G260*AVERAGE(L348:M348)*100033.40324864251380228.8694419040648624.32522378113348413521403$G261*F349*100069.99193492807252469.45812442975562869.163966604597817$G261*AVERAGE(H349:I349)*100074.38970321905642981.350241186411054$G261*AVERAGE(J349:K349)*100086.26367990254001991.198828100364139$G261*AVERAGE(L349:M349)*100094.69273881776102597.600125252780543100.3443352588938613531353$G262*F350*1000227.83680132204788236.7729877107835261.03070962606404$G262*AVERAGE(H350:I350)*1000297.03065833505548339.17922341747067$G262*AVERAGE(J350:K350)*1000380.81589008034479421.77093493928805$G262*AVERAGE(L350:M350)*1000462.02096628405531501.46739168799337542.04388134853787385633031410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years133382613491354$H252*F340*100052191.16203449243$H252*AVERAGE(F340:G340)*100052613.81075460829$H252*AVERAGE(G340:H340)*100053302.70597295899654629.94404902117849069.93656486715234902.38330016562426801.39983869263225518.27568270072522024.1628842978916385.74752543443513491864$H253*F341*10000$H253*AVERAGE(F341:G341)*10000128.47525825290839399.735004759112266743.157983859736319543.52948751513824640.72495811156121432.07332942551519903.41474873919320255.38637767013613491355$H254*F342*10000$H254*AVERAGE(F342:G342)*10000202.71754398631049630.730768803797791550.19219098331342976.14428105789785194.66761338841668203.990355963856910804.23452032474612992.5224837347513491356$H255*F343*10000$H255*AVERAGE(F343:G343)*1000000506.976741499693161553.95467743542833126.0587956879745217.83909794947617931.604773461932411294.38331633732413501354$H256*F344*10002207.4304307178381$H256*AVERAGE(F344:G344)*10002227.10060712966741969.38758595432931401.9190693718399852.56626997698834296.64939478872896000013501865$H257*F345*10000$H257*AVERAGE(F345:G345)*100012.494680798259083334.498324932739991000.60562281256311671.52501043070112317.28787851714652660.79855505325762668.29298432950552642.97281069582692597.141118354445113501355$H258*F346*10000$H258*AVERAGE(F346:G346)*100008.114270436939133225.56881729427656347.31454445758188172.995636611473245107.79876882741412151.75888418296486202.7091120282046261.3227083042372713501356$H259*F347*10000$H259*AVERAGE(F347:G347)*100008.219118667875552125.89920377588028147.92591750984747373.938846900589226109.19168644046597153.71983072266033205.32840996213775264.6993795505493913521402$H260*F348*100052.672353065342179$H260*AVERAGE(F348:G348)*100053.82493951053115955.16868507370669851.14660195557260646.44819962472907142.86345299011593137.71377014891929533.40324864251380228.8694419040648624.32522378113348413521403$H261*F349*100069.991934928072524$H261*AVERAGE(F349:G349)*100069.45812442975562869.16396660459781774.38970321905642981.35024118641105486.26367990254001991.19882810036413994.69273881776102597.600125252780543100.3443352588938613531353$H262*F350*1000119.9598755682776$H262*AVERAGE(F350:G350)*1000124.66492673221319137.43702187067026156.39159524308479178.58351767760456200.5059170572209222.06943118954746243.26174394903276264.03094477880154285.3951432859432231990141249INDEX(Vectors[Description], MATCH(F450, Vectors[Code], 0))Liquid hydrocarbons1333826Preferences.EnergyUnitsTWh13491354F$308:F$318*SUMIFS(F$196:F$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)390.91858136049677G$308:G$318*SUMIFS(G$196:G$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)350.18120885219992H$308:H$318*SUMIFS(H$196:H$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)315.23953503148653I$308:I$318*SUMIFS(I$196:I$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)287.89185093330832J$308:J$318*SUMIFS(J$196:J$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)188.62986097407509K$308:K$318*SUMIFS(K$196:K$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)101.70681391266939L$308:L$318*SUMIFS(L$196:L$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)92.151361308691961M$308:M$318*SUMIFS(M$196:M$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)81.903420894330111N$308:N$318*SUMIFS(N$196:N$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)60.854551030899955O$308:O$318*SUMIFS(O$196:O$201, $C$196:$C$201, $C452:$C462, $D$196:$D$201, $D452:$D462)40.78627053811310813491864000.361933191541861540.6829460621677283512.41803785843563720.07958616334357115.84679693855468211.7048838909047259.85532615768906168.04395891168341851349135500000000001349135600000000001350135412.28060089692360922.60975624595642915.8067544944037359.58493546831568294.686847462137635000001350186500.176036811799282414.21152623824032368.190258820276561410.98122973197856913.30944709808868313.33073340300020113.1854444649857512.88195375366483112.539249080562444135013550000000000135013560000000000135214024.86120139084826877.12912498350914446.71494670780820525.31158257434273384.83952405890896563.88262424233789673.21735997020088642.58478808550402312.02089932433049581.5254267594343742135214030000000000135313539.01983460870955169.438471208132831710.0953005611043511.03727452189228611.91498188673467112.59822879658106813.22305430785236913.68096080598641414.09050942236227414.45823092617519SUM(F452:F462)417.08021825697824SUM(G452:G462)389.53459810159762352.42999622458501322.69884838030328233.47048197227056151.57670021302062137.7693059283001123.0594981417110399.70323968894662477.353136215968533545INDEX(Vectors[Description], MATCH(F465, Vectors[Code], 0))Electricity (delivered to end user)1333Preferences.EnergyUnitsTWh13491354F$308:F$318*SUMIFS(F$206:F$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0G$308:G$318*SUMIFS(G$206:G$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0H$308:H$318*SUMIFS(H$206:H$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0I$308:I$318*SUMIFS(I$206:I$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0J$308:J$318*SUMIFS(J$206:J$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0K$308:K$318*SUMIFS(K$206:K$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0L$308:L$318*SUMIFS(L$206:L$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0M$308:M$318*SUMIFS(M$206:M$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0N$308:N$318*SUMIFS(N$206:N$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0O$308:O$318*SUMIFS(O$206:O$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)0U$308:U$318*SUMIFS(U$206:U$209, $C$206:$C$209, $C467:$C477, $D$206:$D$209, $D467:$D477)013491864000.297098702505819430.6077317381404454513.53063662609894625.73376566060277121.68509054749588217.88550015105535418.04025805136302918.410469340120503191413491355000.854960294980775191.72090373374423174.07019471190547496.124953877757014310.16784769299764513.8790387257807216.24458421754680518.785759676669112191413491356000000000013501354000000000013501865000000000013501355004.491244213294443E-28.9148254031972296E-20.139742065539325690.183428522851571210.272963783494797720.364955133595501470.480759882298653960.60125642707669558135013560000000000135214020000000000135214034.29239245713454663.75628402260762023.58460988125088293.88029278723910133.84992276495235913.8893628028254093.82792296569145133.71481915298343473.58747595465797623.4483310699135648135313530000000000SUM(F467:F477)4.29239245713454663.75628402260762024.78158132087042196.298076513155750821.59049616849610935.93151086403676735.95382498967977435.84431316341501638.35307810586646641.2458165137798791071457INDEX(Vectors[Description], MATCH(F480, Vectors[Code], 0))H21333Preferences.EnergyUnitsTWh13491354F$308:O$318*SUMIFS(O$214:O$215, $C$214:$C$215, $C482:$C492, $D$214:$D$215, $D482:$D492)00000000001349186400000000001349135500000000001349135600001.34726600153770362.78229287851302685.52505613670970698.341097165247527212.73675626311510317.27751738072846913501354000000000013501865000000000013501355000000000013501356000.161312834268351080.359375284163727050.635966423164015860.949300739077137411.46891407837154312.04025947671164642.79027552645854463.6199462617291687135214020000000000135214030000000000135313530000000000SUM(F482:F492)000.161312834268351080.359375284163727051.98323242470171953.73159361759016416.993970215081249710.38135664195917415.527031789573648SUM(O482:O492)20.89746364245763741991Preferences.EnergyUnitsTWh24SUM(F$452:F$459)+SUM(F$467:F$474)+SUM(F$482:F$489)403.19918225742038372.96700190995563336.97803322956031309.12715029414863236.43978185487239170.86958885290318160.44876388931641149.30459990261133133.88446488303597SUM(O$452:O$459)+SUM(O$467:O$474)+SUM(O$482:O$489)120.0644276166829225SUM(F$460:F$461)+SUM(F$475:F$476)+SUM(F$490:F$491)9.1535938479828154SUM(G$460:G$461)+SUM(G$475:G$476)+SUM(G$490:G$491)10.88540900611676510.2995565890590899.1918753615818368.68944682386132437.77198704516330537.04528293589233816.29960723848745735.6083752789884724.9737578293479388184F$462+F$477+F$4929.0198346087095516G$462+G$477+G$4929.438471208132831710.0953005611043511.03727452189228611.91498188673467112.59822879658106813.22305430785236913.68096080598641414.09050942236227414.45823092617519SUM(F497:F499)421.37261071411274SUM(G497:G499)393.29088212420527357.37289037972374329.35630017762276257.0442105654684191.23980469464755180.71710113306113169.2851679470852153.58334958438672139.49641637220606106210401061F$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))104.27005456424456G$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))97.383649525399406H$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))88.107499056146253I$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))80.674712095075819J$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))58.367620493067641K$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))37.894175053255154L$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))34.442326482075025M$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))30.764874535427758N$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))24.925809922236656O$463*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))19.33828405399213310411061F$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))0.12981580630025488G$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))0.1212422592127062H$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))0.10969348849841987I$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))0.10043969807468058J$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))7.2667457093027299E-2K$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))4.7178098344528879E-2L$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))4.288056050044884E-2M$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))3.8302147344538212E-2N$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))3.1032534952289428E-2O$463*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))2.4076087304486765E-210421061F$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))1.8760319404027712G$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))1.7521314028858934H$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))1.585234448271001I$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))1.4515033803872119J$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))1.0501530932146546K$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.68179385780717139L$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.61968802886107033M$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.55352313290855237N$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.44846639574464553O$463*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.347935356028013563858142131833176Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsIF($F$507="C",SUM(F372:F382),(IF($F$507="A",SUM(F404:F414),0)))0IF($F$507="C",SUM(G372:G382),(IF($F$507="A",SUM(G404:G414),0)))43580.76292016063245349.53587221154950393.04301641992115943.11834039797830301.51199122854818842.00586277325823427.81584553923349991.25117807807757449.1032192197743177Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F436:F446)54641.216628771959SUM(G436:G446)55101.35403320871456215.88774873907858396.33043625635860795.97718207375162066.51655294190362991.62224564055263717.30789668401864104.92777144558264461.2676117118543184Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F510:F511)54641.216628771959SUM(G510:G511)98682.116953369346101565.42362095063108789.3734526762976739.09552247173392368.02854417044781833.62810841380387145.123742223252114096.17894952366121910.3708309316331853176Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsIF($F$507="C",SUM(F356:F366),(IF($F$507="A",SUM(F388:F398),0)))0IF($F$507="C",SUM(G356:G366),(IF($F$507="A",SUM(G388:G398),0)))50103.33160462170853851.87941497714960752.980445259684591.614244609606132089.61533734392146026.61990662199189962.63881243806321772.99018001143391459.089778611493177Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F420:F430)55112.234888548308SUM(G420:G430)55579.70960155392857039.32782484603459941.45264001930675766.474437804674103954.07731753486131983.31844018411159360.16094582554195703.64584588297241862.488930876953184Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F515:F516)55112.234888548308SUM(G515:G516)105683.04120617564110891.20723982318120694.4330852789160358.08868241427236043.69265487877278009.9383468061349322.79975826363517476.63602589443633321.57870948856832633Preferences.EnergyUnitsTWh7841844269169272072172272372472572672736INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Road transportF497403.19918225742038G497372.96700190995563336.97803322956031309.12715029414863236.43978185487239170.86958885290318160.44876388931641149.30459990261133133.88446488303597120.0644276166829237INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Rail transportF498+F$14413.441593847982816G498+G$14415.17340900611676514.58755658905908913.47987536158183612.97744682386132512.05998704516330611.33328293589233810.5876072384874589.89637527898847229.261757829347939141638INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic aviationF4999.0198346087095516G4999.438471208132831710.0953005611043511.03727452189228611.91498188673467112.59822879658106813.22305430785236913.68096080598641414.09050942236227414.4582309261751949INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F463-417.08021825697824-G463-389.53459810159762-352.42999622458501-322.69884838030328-233.47048197227056-151.57670021302062-137.7693059283001-123.05949814171103-99.703239688946624-77.35313621596853345INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F478-F$144-8.5803924571345469-G478-G$144-8.04428402260762-9.069581320870423-10.586076513155751-25.87849616849611-40.219510864036764-40.24182498967977-40.13231316341502-42.64107810586647-45.5338165137798821457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H2-F$4930-G$4930-0.16131283426835108-0.35937528416372705-1.9832324247017195-3.7315936175901641-6.9939702150812497-10.381356641959174-15.527031789573648-O$493-20.897463642457637148SUBTOTAL(109,[2007])-3.907985046680551E-14SUBTOTAL(109,[2010])-2.1316282072803006E-14SUBTOTAL(109,[2015])-3.2085445411667024E-14SUBTOTAL(109,[2020])1.4377388168895777E-14SUBTOTAL(109,[2025])2.375877272697835E-14SUBTOTAL(109,[2030])1.4210854715202004E-14SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])-1.5987211554602254E-14SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02634Preferences.EnergyUnitsTWh7841844269169272072172272372472572672736INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Road transportF497403.19918225742038G497372.96700190995563336.97803322956031309.12715029414863236.43978185487239170.86958885290318160.44876388931641149.30459990261133133.88446488303597120.0644276166829249INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-SUM(F452:F459)-403.19918225742038-SUM(G452:G459)-372.96700190995563-335.61974895567243-306.34999128406827-216.71597602662692-135.09584717410166-121.32889165024683-106.79374925022059-83.59183094225385-61.36947853035896845INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-SUM(F467:F474)0-SUM(G467:G474)0-1.196971439619539-2.4177837259166495-17.740573403543749-32.042148061211357-32.125902023988324-32.129494010431578-34.765602151208491-37.7974854438663141457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H2-SUM(F482:F489)0-SUM(G482:G489)0-0.16131283426835108-0.35937528416372705-1.9832324247017195-3.7315936175901641-6.9939702150812497-10.381356641959174-15.527031789573648-20.897463642457637148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])-1.4765966227514582E-14SUBTOTAL(109,[2020])-8.7152507433074788E-15SUBTOTAL(109,[2025])5.9952043329758453E-15SUBTOTAL(109,[2030])-7.1054273576010019E-15SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])-1.4210854715202004E-14SUBTOTAL(109,[2050])02635Preferences.EnergyUnitsTWh7841844269169272072172272372472572672737INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Rail transportF498+F$14413.441593847982816G498+G$14415.17340900611676514.58755658905908913.47987536158183612.97744682386132512.05998704516330611.33328293589233810.5876072384874589.89637527898847229.26175782934793949INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-SUM(F460:F461)-4.8612013908482687-SUM(G460:G461)-7.1291249835091444-6.7149467078082052-5.3115825743427338-4.8395240589089656-3.8826242423378967-3.2173599702008864-2.5847880855040231-2.0208993243304958-1.525426759434374245INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-(SUM(F475:F476)+F144)-8.5803924571345469-8.04428402260762-7.8726098812508827-8.1682927872391016-8.1379227649523589-8.1773628028254102-8.1159229656914516-8.0028191529834345-7.8754759546579765-7.73633106991356461457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H20000000000148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])8.8817841970012523E-16SUBTOTAL(109,[2020])1.7763568394002505E-15SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])-1.7763568394002505E-15SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02636Preferences.EnergyUnitsTWh7841844269169272072172272372472572672738INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic aviationF4999.0198346087095516G4999.438471208132831710.0953005611043511.03727452189228611.91498188673467112.59822879658106813.22305430785236913.68096080598641414.09050942236227414.4582309261751949INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F462-9.0198346087095516-G462-9.4384712081328317-10.09530056110435-11.037274521892286-11.914981886734671-12.598228796581068-13.223054307852369-13.680960805986414-14.090509422362274-14.4582309261751945INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)00000000001457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H20000000000148SUBTOTAL(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])0889263710611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF503104.27005456424456G$50397.38364952539940688.10749905614625380.67471209507581958.36762049306764137.89417505325515434.44232648207502530.76487453542775824.92580992223665619.33828405399213310411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF5040.12981580630025488G$5040.12124225921270620.109693488498419870.100439698074680587.2667457093027299E-24.7178098344528879E-24.288056050044884E-23.8302147344538212E-23.1032534952289428E-22.4076087304486765E-210421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF5051.8760319404027712G$5051.75213140288589341.5852344482710011.45150338038721191.05015309321465460.681793857807171390.619688028861070330.553523132908552370.448466395744645530.34793535602801356148SUBTOTAL(109,[2007])106.27590231094759SUBTOTAL(109,[2010])99.257023187498007SUBTOTAL(109,[2015])89.80242699291567SUBTOTAL(109,[2020])82.226655173537708SUBTOTAL(109,[2025])59.49044104337532SUBTOTAL(109,[2030])38.623147009406857SUBTOTAL(109,[2035])35.104895071436545SUBTOTAL(109,[2040])31.356699815680848SUBTOTAL(109,[2045])25.40530885293359SUBTOTAL(109,[2050])19.710295497324633263910611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF566*(F$537/F$528)100.79979556435509G$566*(G537/G528)93.24175047748890783.90493723891810976.58749782101706754.1789940066567333.77396179352541630.33222291256171126.69843731255514620.89795773556346215.34236963258974210411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion0.125495347545111520.116085611249244440.104461315626639149.5351132438782349E-26.7452633653100821E-24.2048449101742061E-23.7763497782070929E-23.3239449055344102E-22.6017874880839471E-21.9101189624716606E-210421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion1.81359487011955211.67761015188744561.50962174974901631.37796602052441460.974791119848827830.607662778574240780.545738843670804720.480359594770654870.375997081472211720.27604066759617713148SUBTOTAL(109,[2007])102.73888578201976SUBTOTAL(109,[2010])95.035446240625603SUBTOTAL(109,[2015])85.519020304293761SUBTOTAL(109,[2020])78.060814973980257SUBTOTAL(109,[2025])55.221237760158658SUBTOTAL(109,[2030])34.423673021201395SUBTOTAL(109,[2035])30.915725254014585SUBTOTAL(109,[2040])27.212036356381144SUBTOTAL(109,[2045])21.299972691916512SUBTOTAL(109,[2050])15.637511489810636263810611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF566*(F$546/F$528)1.2153003477120672G566*(G$546/G$528)1.78228124587728611.67873667695205131.32789564358568371.20988101472724140.970656060584474180.804339992550221590.646197021376005760.505224831082623950.3813566898585935610411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF567*(F$546/F$528)1.5130441351981576E-32.2189331151143527E-32.0900205355706284E-31.6532248340625994E-31.5062970870262278E-31.2084629635190744E-31.0014001153908815E-38.0451274058808192E-46.2900292019595029E-44.7478757337263155E-410421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF568*(F$546/F$528)2.186574351589772E-23.2066891669136996E-23.0203912701965836E-22.389156360663007E-22.1768238610796253E-21.7464091492155383E-21.447172463152221E-21.1626408530817308E-29.0900299626448591E-36.8613882849767596E-3148SUBTOTAL(109,[2007])1.2386791353631632SUBTOTAL(109,[2010])1.8165670706615373SUBTOTAL(109,[2015])1.7110306101895878SUBTOTAL(109,[2020])1.3534404320263764SUBTOTAL(109,[2025])1.233155550425064SUBTOTAL(109,[2030])0.98932861504014857SUBTOTAL(109,[2035])0.81981311729713469SUBTOTAL(109,[2040])0.6586279426474112SUBTOTAL(109,[2045])0.51494386396546477SUBTOTAL(109,[2050])0.38869286571694295264010611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF566*(F$555/F$528)2.25495865217738792.35961780203320792.52382514027608762.7593186304730712.97874547168366773.14955719914526713.30576357696309223.42024020149660363.52262735559056853.614557731543797610411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion2.807414619945197E-32.937714848347412E-33.1421523362100863E-33.4353408018356303E-33.7085263529002543E-33.9211862792677497E-34.1156626029870309E-34.2581855486060246E-34.3856571512540035E-34.5001101063975252E-310421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel Combustion4.0571326767321059E-24.2454359329310791E-24.5408785820018706E-24.9645796256167114E-25.3593734755030487E-25.6666987740775256E-25.9477460558743374E-26.1537129607080174E-26.3379284309788897E-26.5033300146859652E-2148SUBTOTAL(109,[2007])2.2983373935646543SUBTOTAL(109,[2010])2.4050098762108663SUBTOTAL(109,[2015])2.5723760784323164SUBTOTAL(109,[2020])2.8123997675310739SUBTOTAL(109,[2025])3.0360477327915985SUBTOTAL(109,[2030])3.21014537316531SUBTOTAL(109,[2035])3.3693567001248228SUBTOTAL(109,[2040])3.4860355166522896SUBTOTAL(109,[2045])3.5903922970516113SUBTOTAL(109,[2050])3.6840911417970545261319157826144426916927207217227237247257267273673INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Shiftable electricity demandPreferences.PowerUnitsGWF468*Conversion.to.average.power003.3892163187978483E-26.9328284068040757E-21.5435360057151432.93563377373976352.47377259268718672.0403262777840922.05798061274960362.100213248930013619017826144426916927207217227237247257267273673INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Shiftable electricity demandPreferences.PowerUnitsGWF469*Conversion.to.average.power009.753140485749201E-20.196315735083758990.464316074823804940.698717074806868951.15991874207137151.58328071250065231.85313532027684262.143025288235125326187826144426916927207217227237247257267272615INDEX(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 unitsF501031893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C621,CostVectors[Code], 0))Low estimate of capital costsF5100G51043580.76292016063245349.53587221154950393.04301641992115943.11834039797830301.51199122854818842.00586277325823427.81584553923349991.25117807807757449.1032192197743133INDEX(CostVectors[Description], MATCH(C622, CostVectors[Code], 0))Low estimate of operating costsF51154641.216628771959G51155101.35403320871456215.88774873907858396.33043625635860795.97718207375162066.51655294190362991.62224564055263717.30789668401864104.92777144558264461.2676117118543135INDEX(CostVectors[Description], MATCH(C623, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C624, CostVectors[Code], 0))High estimate of capital costsF5150G51550103.33160462170853851.87941497714960752.980445259684591.614244609606132089.61533734392146026.61990662199189962.63881243806321772.99018001143391459.089778611493142INDEX(CostVectors[Description], MATCH(C625, CostVectors[Code], 0))High estimate of operating costsF51655112.234888548308G51655579.70960155392857039.32782484603459941.45264001930675766.474437804674103954.07731753486131983.31844018411159360.16094582554195703.64584588297241862.488930876953144INDEX(CostVectors[Description], MATCH(C626, CostVectors[Code], 0))High estimate of fuel costsTRUE