23
36
3528
16263738201320142015201620172018201920207
011505050+(C5+D5+E5)*0.91125F5*(1-$O$5)1102.5G5*(1-$O$5)1080.451058.84100000000011037.664181016.9108964996.57267847199989976.6412249025598880.02
27350+(C6+D6+E6)*0.95332.5F6*(1-$O$5)325.84999999999997319.33299999999997312.94633999999996306.68741319999998300.55366493599996294.54259163727994288.6517398045343280.01
39550100100+(C7+D7+E7)*0.95712.5F7*(1-$O$5)698.25684.28499999999997670.59929999999997657.18731400000001644.04356772000006631.16269636560003618.5394424382880180.01
2+SUM(F5:F7)2170+SUM(G5:G7)2126.62084.06799999999982042.38664000000022001.53890721961.50812905599991922.277966474881883.83240714538218
29F42013G42014201520162017201820192020
00F110G110000005
+$B$6Leakage sectors0.9+F12+$O$120.8750.850.824999999999999960.799999999999999930.774999999999999910.749999999999999890.72499999999999987-2.5000000000000001E-2
10.8F13+$O$130.685714285714285720.57142857142857140.457142857142857070.342857142857142750.228571428571428450.1142857142857141605(M13-F13)/(M10-F10)-0.1142857142857143
43+(F6*F12+F7*F13)/(F6+F7)0.83181818181818179+(G6*G12+G7*G13)/(G6+G7)0.745941558441558520.660064935064935020.574188311688311640.48831168831168820.402435064935064870.316558441558441370.23068181818181807
30((F11*F5)+(F12*F6)+(F13*F7))/F80.400576036866359450.359220704410796620.317865371955233730.276510039499670790.235154707044107930.193799374588545040.152444042132982130.111088709677419325
|
441-F140.168181818181818211-G140.254058441558441480.339935064935064980.425811688311688360.511688311688311750.597564935064935130.683441558441558630.7693181818181819
322010F102013G102014201520162017201820192020
32+(2100+100)*0.935+1502207+D19*(1-3*O19)2091.7946000000002+F19*(1-$O$19)2055.3973739600001+G19*(1-$O$19)2019.63345965309621984.49183745513231949.9616794834131916.03234626040171882.69338343547091849.93451856369371.7399999999999999E-233
31+$F$6*F12+$F$7*F13*F$19/F$8848.70756774193546+$F$6*G12+$F$7*G13*G$19/G$8763.15062483664065677.17994597320001590.79387952103366503.99076799798542416.76894805089819329.12675043612882241.06249999999994
34+F19-F201243.0870322580647+G19-G201292.24674912335951342.45351367989631393.69795793409871445.97091148542771499.26339820950351553.56663299934211608.8720185636937
24F102013G102014201520162017201820192020
2525+F24*(1+$O$24)26.2527.562528.94062500000000130.38765625000000331.90703906250000433.50239101562500835.17751056640626240.05
40+F24*F2131077.175806451618+G24*G2133921.47716448818437001.37497080214240334.48996383652443939.66700571835847837.05581164712952048.19680757195656596.112433019705
41F102013G102014201520162017201820192020'OLD UK'!N1710
0+F5*(1-F11)*(F$19/F$8)1084.4557258064517+G5*(1-G11)*(G$19/G$8)1065.58619617741941047.04499636393261028.82641342719991010.9248338335667993.33474172486262976.05071721884997959.06743473924212Power_sector3.2650000000000001
+$B$6Leakage sectors+F6*(1-F12)*(F$19/F$8)32.051691451612903+G6*(1-G12)*(G$19/G$8)39.36749002544354446.41899483880101253.21318838337351359.75689017771751666.0567603247033972.1193029945039477.950869834639533
1+F7*(1-F13)*(F$19/F$8)137.36439193548387+G7*(1-G13)*(G$19/G$8)212.10239523912443284.19792758449597353.72031928306586420.73728798597023485.31497381414727547.51797375419324607.40937533485339
2+SUM(F28:F30)1253.8718091935484+SUM(G28:G30)1317.05608144198751377.66191878722951435.75992109363941491.41901199725431544.70647586371341595.68799396754711644.4276799087349
|
42
0+F28*F2427111.393145161292+G28*G2427971.63764965725928859.17771228089329774.87942109155830719.63634512279931694.37040635354432700.03277934714433737.604819435837
39+(F29+F30)*F244235.4020846774192+(G29+G30)*G246601.08448819490979112.62892429212311776.91004530904714601.09191616440117592.63945912667620759.330333491924109.267266244624
|
|
1724286
1817858
19F39/F400.13557422969187674
200.9
21F42*F410.12201680672268907
22F$42013G$42014201520162017201820192020
2$F$43*F31152.99343419739765$F$43*G31160.70297733224922168.09790807387034175.18684079226591181.97818532941287188.48015150874889194.70075354965363200.6478143888641111