Spreadsheet: 87069d1286984598-copy-paste-issue-formatting-lost-copy
Sheet: Local Report Lines

Local Report Lines - Total Variance
Last run 12 Oct 2010 15:22 by lerou1j
All volumes in GWh, all costs in £m
[NAME]: |  |  |  | Year: 2010   Report period: Budget-2010
Revenue |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Revenue |  | wddsgsd |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.88906309
 |  | sgsdgds |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.00
 |  | sgsdsgs |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.00
Revenue Total |  |  |  | 1 | 1 | 1 | 1 | 0.481510515 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 5.77812618 | 5.77812618 | 4.81510515 | 2.88906309
Cost |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Cost | 1 | wddsgsd |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.9810705549999998
 |  | sgsdgds |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.882092196
 |  | sgsdsgs |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.00
Cost Total |  |  |  | 0 | 0.227524926 | 0.23060007 | 0.72818603 | 0.226496573 | 0.218980925 | 0.231374227 | 0.229335133 | 0.221423651 | 0.235921677 | 0.186730395 | 0.215671129 | 0.248960467 | 3.201205203000002 | 3.201205203000002 | 2.736573607 | 1.863162751
Gross Margin (£m) |  |  |  | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2.576920977 | 2.576920977 | 2.078531543 | 1.025900339
Current Snapshot: |  |  |  | Year: 2010   Report period: Oct-2010
Revenue |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Revenue |  | wddsgsd |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -7.730727
 |  | sgsdgds |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -4.72755816
 |  | sgsdsgs |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
Revenue Total |  |  |  | -12.45828516 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12.45828516 | -12.45828516 | -12.45828516
Cost |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Cost | 1 | wddsgsd |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -2.760611509999999
 |  | sgsdgds |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -2.107586
 |  | sgsdsgs |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
Cost Total |  |  |  | -555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4.868197509999999 | -4.868197509999999 | -4.868197509999999
Gross Margin (£m) |  |  |  | -7777 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -7.590087649999998 | -7.590087650000002 | -7.590087650000002
Total Variance:  Oct-2010 vs Budget-2010
Revenue |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Revenue |  | wddsgsd |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -10.61979009
 |  | sgsdgds |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | -4.72755816
 |  | sgsdsgs |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
Revenue Total |  |  |  | -665697 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.481510515 | -0.66666 | -0.481510515 | -5.77812618 | -18.23641134 | -17.27339031 | -15.34734825
Cost |  |  | (£m) | PYA | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Year excl PYA | Year inc PYA | Year to October | Half Year
Cost | 1 | wddsgsd |  | 2.760611509999999 | 0.08050956 | 0.083584704 | 0.581170664 | 0.079481207 | 0.07196555899999998 | 0.08435886100000001 | 0.082319767 | 0.074408285 | 0.088906311 | 0.039715029 | 0.06865576300000001 | 0.101945101 | 1.437020811 | 4.197632321 | 4.027031457 | 3.741682064999999
 |  | sgsdgds |  | 2.107586 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 0.147015366 | 1.764184392 | 3.871770391999999 | 3.57773966 | 2.989678195999999
 |  | sgsdsgs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cost Total |  |  |  | 4.868197509999999 | 0.227524926 | 0.23060007 | 0.72818603 | 0.226496573 | 0.218980925 | 0.231374227 | 0.229335133 | 0.221423651 | 0.235921677 | 0.186730395 | 0.215671129 | 0.248960467 | 3.201205203000002 | 8.069402713 | 7.604771116999999 | 6.731360260999999
Gross Margin (£m) |  |  |  | -456664 | -4778 | -555674 | 0.2466755150000001 | -66656 | -0.26252959 | -26644 | -0.2521753819999999 | -477979 | -49796 | -6798989 | -0.265839386 | -0.232550048 | -2.576920976999999 | -10.167008627 | -9.668619193000001 | -8.615987989000002