Spreadsheet: sally_beck__35047__Appendices April
Sheet: Appendix 9

 |  |  |  | UK Power Forward Delta PL (excluding intramonth) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Power Forward Delta PL (excluding intramonth)
 | Summary by Day |  |  |  |  |  |  |  |  |  |  |  |  | Front End Months |  |  |  |  |  |  |  |  |  |  | Three Year Seasons |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Five Year Annual |  |  |  |  |  |  | Long Term Curve Shift
 |  |  | VALUE | DPR | DPR | DPR | HIGHER | TOTAL DPR | FWD PPP |  | 2000-05-01 00:00:00 |  |  | 2000-06-01 00:00:00 |  |  | 2000-07-01 00:00:00 |  |  | Balance of Season for Summer-2000 |  |  | Winter-2000 |  |  | [NAME] |  |  | Winter-2001 |  |  | Summer-2002 |  |  | Winter-2002 |  |  | [NAME] |  |  | Winter-2003 |  |  | 2004 |  |  | 2005 |  |  | 2006 |  |  | 2007 |  |  | 2008 |  |  | 2009-2027
 |  |  | AT | SMP + ET | ASIANS + | PPP | ORDER | EXPECTED | DELTA | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks | Peaks | WD6 | Off Peaks
checks | Totals |  | RISK | LOLP | ADJUSTMENTS | TOTAL | DIFFERENCE | DELTA (FWD) |  | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP | GBP
0 | 2000-04-03 00:00:00 | 1 | -4212144.598594753 | 0 | 2878.21 | -5614943.018999588 | 35661.7562417211 | -5612064.808999588 | -5579281.262757867 | -967715.3143715799 | -100711.9291439535 | 165165.6749969403 | -1286433.74314993 | -122879.3622818618 | 226932.4847041488 | -1003493.189800013 | -97030.55592396218 | 120151.3183818499 | -2099902.777380274 | -202340.7609593456 | 283674.978845525 | -96306.40346422198 | -50921.50115527869 | 98063.86662438384 | -608677.1957182297 | -116647.5311921871 | 279790.6782301237 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-04 00:00:00 | 2 | -4212144.598594753 | 0 | 0 | 4242229.562517747 | -24767.43307449296 | 4242229.562517747 | 4217462.129443254 | 919845.2937323686 | 96253.46136712952 | 166665.4489346438 | 1219315.797098876 | 115891.8883509766 | 226463.9601727089 | 368834.5125968937 | 35144.33471074362 | 57824.01830885351 | 725823.3476753974 | 68081.63513742643 | 111668.8627844595 | 86194.01294755936 | 43962.23792850239 | -77918.01878740606 | 97279.08939104852 | 19354.19846527724 | -63221.95137220484 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-05 00:00:00 | 3 | -3954144.536271612 | 0 | 0 | 627461.8304447061 | 21209.41382337129 | 627461.8304447061 | 648671.2442680774 | 391312.7551070333 | 37730.57538738357 | -147016.1666747772 | 513593.257513003 | 44943.62822046933 | -197600.9010621853 | 372436.7153491842 | 32798.17528298716 | -118928.7086206248 | 817273.1609580726 | 70497.12860311102 | -256172.9302718735 | -278468.1449708182 | -150100.2778606486 | -511196.2802561529 | 63714.37755050358 | 11926.00600635239 | -48071.12599294224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-06 00:00:00 | 4 | -8874794.320656931 | 0 | 0 | -1448891.830821752 | -899.7270474268589 | -1448891.830821752 | -1449791.557869179 | -617461.1539160471 | -66127.28334785714 | -51790.28355936852 | -746760.3249710291 | -61854.69965901129 | -67917.84066027871 | -21140.70781281894 | -1874.384113577345 | 2756.660274207783 | -45366.76341254386 | -3747.960512148013 | 7927.247474396436 | 65794.65923700758 | 21356.84159936117 | 4131.839816023893 | 111203.3822200776 | 27216.55370316012 | -6137.340228733172 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-07 00:00:00 | 5 | -8874794.320656931 | 0 | 0 | -3249279.217315082 | 3777.413707993459 | -3249279.217315082 | -3245501.803607088 | -808312.0610575373 | -76403.60184104163 | 57591.15956501313 | -973603.2716822883 | -69172.78344685321 | 79726.70473553639 | -476069.2670367426 | -37315.24290374727 | 32680.10154062675 | -1012501.08242962 | -69354.57168608878 | 107232.1126356546 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-10 00:00:00 | 6 | -8897717.819393745 | 585461.4842802315 | 0 | -2392508.338743544 | 45355.96969992435 | -1807046.854463312 | -2347152.369043619 | -92258.83517910182 | 4488.028039987727 | 7515.576493465722 | -105647.3619189606 | 8495.599162132741 | 8359.524190687447 | -87242.68580993755 | 5103.331842522247 | 13482.5836916538 | -140061.8395206387 | 22941.09139865342 | 32277.3074290892 | -1636399.891878895 | -518476.4835091025 | 130271.6865248252 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-11 00:00:00 | 7 | -8765621.694692703 | 0 | 0 | 2293839.378238661 | -31986.80293571297 | 2293839.378238661 | 2261852.575302948 | 295291.0336854954 | -14364.74280826016 | 56128.23397104225 | 336167.0308679846 | -27032.76536114029 | 62066.14984435018 | 245110.4029898273 | -14337.93231946744 | 88385.82642306467 | 441419.744907943 | -70896.6620998643 | 221729.462574634 | 466639.8711685101 | 150293.3615205628 | 25253.55993826586 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-12 00:00:00 | 8 | -8635145.743803713 | 0 | 0 | -85327.6908124137 | 16536.38692066478 | -85327.6908124137 | -68791.30389174892 | -1371.604488603803 | 96.28729957212664 | 24048.72407236744 | -1720.916799838493 | 183.9795276358695 | 28740.39565988103 | 25174.78322391253 | -2015.585222137243 | 15247.51563977157 | 42399.22220325264 | -9083.99723742939 | 35338.83546484803 | -174391.9536448832 | -68177.00004245485 | 16740.01045235678 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-13 00:00:00 | 9 | -8635146 | 0 | 0 | -1225570.279591574 | 18307.07983979303 | -1225570.279591574 | -1207263.199751781 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -802621.8428645711 | -292228.7610955805 | -112412.5957916297 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-14 00:00:00 | 10 | -8705742.135985177 | 0 | 0 | -235271.9482413937 | 9874.60136604245 | -235271.9482413937 | -225397.3468753512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -180603.8160788341 | -68839.03509957372 | 24045.50430305658 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-17 00:00:00 | 11 | -8679101.168787766 | 0 | 0 | 101611.5401731887 | -3207.905263651177 | 101611.5401731887 | 98403.63490953755 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44206.14776570028 | -8676.840385036805 | 62874.32752887408 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-18 00:00:00 | 12 | -8663210.003217941 | 0 | 0 | 2244531.756835026 | -21204.95443726843 | 2244531.756835026 | 2223326.802397758 | 359627.1146988568 | -13690.5930157829 | 17212.36704082082 | 410542.8084214442 | -28918.14037942212 | 17050.33873652096 | 319027.0251590304 | -16549.04754926792 | 10079.88322917653 | 536152.9557754155 | -80850.8614097895 | 29122.61707648381 | 190934.516328917 | 71073.9233247311 | -33880.01414782751 | 0 | 0 | 0 | 295218.3698001821 | 106588.7716837944 | 34584.76762447354 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-19 00:00:00 | 13 | -8450824.470022496 | -3.673137265897822 | 0 | 384812.4985351674 | -38134.58827562188 | 384808.8253979015 | 346677.9102595455 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -120188.3917387975 | -79817.72269390704 | -382734.6518060473 | 317329.0385761276 | 73333.84941953086 | -149618.2815549969 | 471123.4098568104 | 172334.2722351483 | 44916.38796567711 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-20 00:00:00 | 14 | -8411648.2517558 | 0 | 0 | 1721452.844561325 | 1997.878758403938 | 1721452.844561325 | 1723450.723319729 | 119696.2608700712 | -3802.627598047452 | 56706.21589380167 | 136657.5035858628 | -8595.125975220239 | 51007.26466644154 | 95878.14285838562 | -4878.381729842111 | 49740.71622643224 | 177366.9732237791 | -24656.34347876101 | 111323.6625400413 | 104639.5235485742 | 42482.69444247044 | -34845.33224213312 | 420406.2455940028 | 95539.38020846414 | -82837.74230137063 | 288791.8720048738 | 104956.0956131246 | 27873.7253687783 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-25 00:00:00 | 17 | -8428630.716774054 | 0 | 0 | -51867.2910553126 | 7989.68638442528 | -51867.2910553126 | -43877.60467088732 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40413.65581323599 | 13981.45759386317 | -98272.71807798647 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-26 00:00:00 | 18 | -8433733.538165897 | 0 | 0 | -182502.3367828792 | -96616.69143591847 | -182502.3367828792 | -279119.0282187977 | 121899.255465811 | -5925.86439050151 | -109257.7354610255 | 36406.87353444171 | -2728.117554239773 | -74264.1127908302 | -13516.53204975374 | 846.5367541742471 | -58195.65359344696 | -36643.87195130964 | 5427.828372745394 | -129064.4878081946 | -22202.9034056154 | -8007.654434965048 | 16107.41109391242 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-27 00:00:00 | 19 | -8667332.047910549 | 0 | 0 | -1095521.369968816 | 3126.412790935021 | -1095521.369968816 | -1092394.957177881 | -305666.5162096942 | -12655.56719809582 | 10562.67388903832 | -222424.2426107802 | -5205.288273945869 | -4047.83923284531 | -97569.35164830906 | -2431.874206016031 | 1856.565480372971 | -178407.3426919937 | 2210.74188660003 | 3587.277516167166 | -168786.7714553531 | -58312.12813795482 | 91522.74751665673 | -125838.9065707066 | -29210.12254370655 | 8420.987312684887 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 2000-04-28 00:00:00 | 20 | -8766050.150117284 | -41248.82757528693 | 0 | 466697.6261063113 | -252392.8296465017 | 425448.7985310244 | 214304.7964598096 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 146184.5804261366 | 51564.13335561399 | 16556.08267805909 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 22 |  | 544208.9835676787 | 2878.21 | -3499046.284920221 | -305374.3325833197 | -2951959.091352542 | -3804420.617503541 | -585113.7716629279 | -155113.8572494672 | 253531.8891619621 | -683906.5901112142 | -156871.18767048 | 356516.1289641357 | -272570.1519803412 | -102540.6253775903 | 215080.826981938 | -772448.2726425193 | -291772.7319848904 | 558644.9462612307 | -1678525.889827915 | -668178.1269094308 | -669836.0615191979 | 275416.0310428237 | 81512.33406689105 | -61674.77590743918 | 398696.3892234316 | 143214.5117921008 | 11518.36784535833 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer-2000 Total |  |  |  |  |  |  |  |  | Winter-2000 Total |  |  | Summer-2001 Total |  |  | Winter-2001 Total |  |  | Summer-2002 Total |  |  | Winter-2002 Total |  |  | Summer-2003 Total |  |  | Winter-2003 Total |  |  | 2004 Total |  |  | 2005 Total |  |  | 2006 Total |  |  | 2007 Total |  |  | 2008 Total |  |  | 2009-2027 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1636563.397310164 |  |  |  |  |  |  |  |  | -3016540.078256544 |  |  | 295253.5892022756 |  |  | 553429.2688608908 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | 23 |  |  |  |  |  |  | 0
 | April Total |  |  | 544208.9835676787 | 2878.21 | -3499046.284920221 | -305374.3325833197 | -2951959.091352542 | -3804420.617503541 | -585113.7716629279 | -155113.8572494672 | 253531.8891619621 | -683906.5901112142 | -156871.18767048 | 356516.1289641357 | -272570.1519803412 | -102540.6253775903 | 215080.826981938 | -772448.2726425193 | -291772.7319848904 | 558644.9462612307 | -1678525.889827915 | -668178.1269094308 | -669836.0615191979 | 275416.0310428237 | 81512.33406689105 | -61674.77590743918 | 398696.3892234316 | 143214.5117921008 | 11518.36784535833 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Q2 Total to date | 29 |  | 544208.9835676787 | 2878.21 | -3499046.284920221 | -305374.3325833197 | -2951959.091352542 | -3804420.617503541 | -585113.7716629279 | -155113.8572494672 | 253531.8891619621 | -683906.5901112142 | -156871.18767048 | 356516.1289641357 | -272570.1519803412 | -102540.6253775903 | 215080.826981938 | -772448.2726425193 | -291772.7319848904 | 558644.9462612307 | -1678525.889827915 | -668178.1269094308 | -669836.0615191979 | 275416.0310428237 | 81512.33406689105 | -61674.77590743918 | 398696.3892234316 | 143214.5117921008 | 11518.36784535833 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer-2000 Q1 Total |  |  |  |  |  |  |  |  | Winter-2000 Q1 Total |  |  | Summer-2001 Q1 Total |  |  | Winter-2001 Q1 Total |  |  | Summer-2002 Q1 Total |  |  | Winter-2002 Q1 Total |  |  | [NAME] |  |  | Winter-2003 Q1 Total |  |  | 2004 Q1 Total |  |  | 2005 Q1 Total |  |  | 2006 Q1 Total |  |  | 2007 Q1 Total |  |  | 2008 Q1 Total |  |  | 2009-2027 Q1 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1636563.397310164 |  |  |  |  |  |  |  |  | -3016540.078256544 |  |  | 295253.5892022756 |  |  | 553429.2688608908 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | 31