Spreadsheet: 196251d1353933739-merging-data-from-differently-shaped-streams-elec-monitoring-example-workbook
Sheet: Source A

Account Number | Invoice Number | [NAME] or MPAN Number | Month | Date | Measured in | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00 Status | 00:30 Status | 01:00 Status | [NAME] | 02:00 Status | 02:30 Status | 03:00 Status | 03:30 Status | 04:00 Status | 04:30 Status | 05:00 Status | 05:30 Status | 06:00 Status | 06:30 Status | 07:00 Status | 07:30 Status | 08:00 Status | 08:30 Status | 09:00 Status | [NAME] | 10:00 Status | 10:30 Status | 11:00 Status | 11:30 Status | 12:00 Status | 12:30 Status | 13:00 Status | 13:30 Status | 14:00 Status | 14:30 Status | 15:00 Status | 15:30 Status | 16:00 Status | 16:30 Status | 17:00 Status | 17:30 Status | 18:00 Status | [NAME] | 19:00 Status | 19:30 Status | 20:00 Status | 20:30 Status | 21:00 Status | 21:30 Status | [NAME] | 22:30 Status | 23:00 Status | 23:30 Status
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-01 00:00:00 | KWH | 7 | 7 | 7 | 7 | 8 | 8 | 7 | 7 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 8 | 13 | 13 | 16 | 14 | 15 | 15 | 16 | 19 | 17 | 16 | 16 | 18 | 20 | 17 | 16 | 18 | 20 | 16 | 17 | 18 | 16 | 17 | 17 | 15 | 13 | 13 | 13 | 12 | 10 | 9 | 9 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-02 00:00:00 | KWH | 9 | 7 | 8 | 7 | 8 | 8 | 7 | 8 | 7 | 7 | 7 | 8 | 8 | 7 | 9 | 11 | 14 | 15 | 16 | 18 | 14 | 16 | 18 | 18 | 14 | 16 | 15 | 17 | 17 | 19 | 20 | 20 | 19 | 18 | 17 | 17 | 17 | 18 | 17 | 17 | 15 | 17 | 12 | 11 | 10 | 11 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-03 00:00:00 | KWH | 8 | 6 | 7 | 5 | 6 | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 7 | 7 | 7 | 15 | 12 | 19 | 16 | 19 | 20 | 21 | 17 | 15 | 18 | 18 | 17 | 18 | 18 | 21 | 21 | 19 | 18 | 17 | 17 | 19 | 17 | 16 | 17 | 15 | 15 | 11 | 10 | 10 | 10 | 10 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-04 00:00:00 | KWH | 7 | 8 | 6 | 7 | 6 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 7 | 8 | 9 | 8 | 11 | 15 | 17 | 16 | 17 | 17 | 20 | 20 | 20 | 20 | 20 | 21 | 20 | 18 | 19 | 20 | 18 | 20 | 18 | 17 | 16 | 18 | 18 | 16 | 14 | 12 | 13 | 11 | 10 | 9 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-05 00:00:00 | KWH | 8 | 7 | 6 | 7 | 7 | 7 | 7 | 6 | 6 | 6 | 7 | 6 | 7 | 7 | 9 | 10 | 13 | 15 | 18 | 18 | 18 | 20 | 21 | 20 | 21 | 20 | 19 | 19 | 19 | 20 | 23 | 22 | 21 | 18 | 20 | 18 | 20 | 18 | 16 | 16 | 17 | 14 | 15 | 14 | 12 | 10 | 10 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-06 00:00:00 | KWH | 8 | 9 | 7 | 7 | 7 | 6 | 8 | 7 | 6 | 6 | 7 | 6 | 7 | 6 | 6 | 6 | 9 | 8 | 9 | 9 | 8 | 8 | 7 | 5 | 7 | 9 | 10 | 11 | 10 | 10 | 11 | 12 | 13 | 13 | 12 | 13 | 12 | 12 | 13 | 11 | 12 | 12 | 10 | 10 | 10 | 8 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-07 00:00:00 | KWH | 9 | 9 | 7 | 7 | 7 | 6 | 6 | 6 | 7 | 6 | 5 | 5 | 5 | 5 | 5 | 4 | 7 | 8 | 8 | 6 | 6 | 3 | 6 | 5 | 7 | 6 | 8 | 4 | 8 | 9 | 11 | 11 | 14 | 13 | 14 | 14 | 14 | 13 | 13 | 13 | 13 | 11 | 9 | 10 | 10 | 9 | 7 | 7 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-08 00:00:00 | KWH | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 7 | 7 | 6 | 7 | 7 | 8 | 8 | 8 | 13 | 16 | 18 | 22 | 22 | 24 | 25 | 23 | 24 | 23 | 24 | 22 | 22 | 22 | 22 | 22 | 21 | 20 | 19 | 20 | 18 | 18 | 19 | 18 | 17 | 16 | 14 | 12 | 10 | 11 | 9 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-09 00:00:00 | KWH | 8 | 7 | 7 | 7 | 6 | 7 | 7 | 6 | 6 | 7 | 6 | 7 | 9 | 9 | 9 | 8 | 10 | 13 | 15 | 19 | 18 | 19 | 19 | 17 | 19 | 21 | 20 | 21 | 22 | 21 | 22 | 22 | 21 | 21 | 20 | 20 | 20 | 20 | 19 | 17 | 15 | 15 | 13 | 11 | 11 | 8 | 10 | 8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-10 00:00:00 | KWH | 7 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 6 | 6 | 7 | 7 | 9 | 9 | 10 | 9 | 13 | 14 | 17 | 18 | 21 | 22 | 21 | 21 | 18 | 20 | 19 | 18 | 22 | 20 | 22 | 22 | 20 | 18 | 17 | 17 | 16 | 16 | 16 | 15 | 13 | 13 | 13 | 11 | 11 | 11 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-11 00:00:00 | KWH | 8 | 7 | 7 | 7 | 8 | 6 | 6 | 6 | 6 | 7 | 6 | 6 | 8 | 8 | 10 | 10 | 12 | 13 | 17 | 17 | 16 | 18 | 16 | 17 | 19 | 20 | 19 | 17 | 20 | 19 | 22 | 21 | 22 | 22 | 17 | 19 | 19 | 19 | 19 | 19 | 19 | 16 | 16 | 15 | 14 | 11 | 11 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-12 00:00:00 | KWH | 9 | 8 | 7 | 8 | 8 | 9 | 7 | 8 | 7 | 7 | 7 | 7 | 9 | 10 | 11 | 11 | 13 | 13 | 17 | 17 | 16 | 15 | 18 | 16 | 17 | 18 | 17 | 16 | 15 | 18 | 22 | 20 | 21 | 21 | 20 | 20 | 22 | 22 | 20 | 19 | 17 | 13 | 13 | 12 | 11 | 11 | 11 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-13 00:00:00 | KWH | 10 | 9 | 9 | 8 | 8 | 8 | 8 | 8 | 7 | 8 | 7 | 8 | 8 | 8 | 9 | 8 | 10 | 10 | 9 | 12 | 11 | 12 | 10 | 7 | 11 | 10 | 13 | 14 | 13 | 15 | 16 | 15 | 15 | 15 | 14 | 17 | 14 | 15 | 14 | 14 | 15 | 12 | 10 | 10 | 10 | 9 | 9 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-14 00:00:00 | KWH | 8 | 9 | 9 | 7 | 7 | 6 | 7 | 7 | 7 | 7 | 7 | 6 | 8 | 7 | 7 | 7 | 9 | 7 | 7 | 9 | 8 | 7 | 5 | 5 | 4 | 6 | 7 | 7 | 10 | 11 | 14 | 12 | 14 | 14 | 13 | 14 | 14 | 14 | 12 | 11 | 11 | 9 | 10 | 9 | 10 | 9 | 9 | 7 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-15 00:00:00 | KWH | 7 | 8 | 7 | 7 | 6 | 7 | 6 | 7 | 6 | 7 | 6 | 7 | 8 | 8 | 9 | 10 | 18 | 19 | 19 | 20 | 22 | 22 | 22 | 22 | 24 | 23 | 20 | 21 | 21 | 21 | 23 | 23 | 23 | 20 | 22 | 21 | 20 | 21 | 22 | 21 | 16 | 14 | 13 | 10 | 8 | 10 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-16 00:00:00 | KWH | 7 | 6 | 6 | 7 | 6 | 6 | 6 | 7 | 6 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 14 | 17 | 16 | 17 | 16 | 17 | 14 | 16 | 15 | 17 | 14 | 17 | 16 | 20 | 18 | 20 | 19 | 19 | 20 | 19 | 20 | 19 | 18 | 16 | 15 | 12 | 14 | 12 | 11 | 11 | 11 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-17 00:00:00 | KWH | 9 | 8 | 8 | 8 | 7 | 8 | 9 | 8 | 8 | 8 | 8 | 8 | 9 | 9 | 11 | 10 | 15 | 15 | 19 | 16 | 16 | 16 | 16 | 20 | 18 | 19 | 20 | 19 | 19 | 18 | 17 | 18 | 18 | 17 | 20 | 20 | 17 | 19 | 15 | 15 | 14 | 12 | 13 | 11 | 11 | 10 | 10 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-18 00:00:00 | KWH | 9 | 8 | 9 | 9 | 9 | 8 | 9 | 8 | 8 | 8 | 8 | 8 | 10 | 11 | 12 | 12 | 14 | 16 | 15 | 13 | 15 | 12 | 16 | 12 | 12 | 17 | 17 | 18 | 20 | 20 | 23 | 23 | 24 | 22 | 19 | 21 | 21 | 20 | 20 | 19 | 19 | 17 | 17 | 14 | 12 | 13 | 11 | 12 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-19 00:00:00 | KWH | 11 | 9 | 8 | 8 | 8 | 9 | 9 | 9 | 8 | 9 | 8 | 9 | 11 | 12 | 11 | 9 | 11 | 12 | 16 | 17 | 17 | 19 | 17 | 18 | 17 | 18 | 18 | 18 | 21 | 22 | 20 | 23 | 21 | 19 | 19 | 18 | 18 | 16 | 16 | 17 | 17 | 14 | 15 | 15 | 14 | 13 | 13 | 13 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-20 00:00:00 | KWH | 12 | 12 | 10 | 8 | 8 | 7 | 8 | 8 | 9 | 7 | 7 | 8 | 7 | 9 | 9 | 8 | 11 | 14 | 14 | 14 | 14 | 12 | 12 | 12 | 12 | 11 | 10 | 10 | 12 | 11 | 13 | 13 | 15 | 17 | 15 | 15 | 15 | 16 | 15 | 16 | 15 | 15 | 14 | 13 | 13 | 12 | 12 | 12 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-21 00:00:00 | KWH | 12 | 11 | 11 | 7 | 8 | 8 | 7 | 7 | 8 | 6 | 7 | 7 | 6 | 7 | 7 | 7 | 9 | 12 | 10 | 11 | 10 | 11 | 9 | 8 | 7 | 8 | 9 | 12 | 13 | 13 | 13 | 14 | 12 | 14 | 14 | 12 | 12 | 13 | 12 | 11 | 12 | 12 | 9 | 10 | 10 | 9 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-22 00:00:00 | KWH | 8 | 7 | 8 | 7 | 7 | 7 | 6 | 7 | 6 | 7 | 6 | 6 | 8 | 8 | 10 | 11 | 17 | 21 | 22 | 23 | 25 | 24 | 21 | 22 | 22 | 23 | 22 | 25 | 24 | 26 | 24 | 23 | 23 | 19 | 21 | 20 | 20 | 19 | 20 | 18 | 17 | 14 | 13 | 12 | 10 | 10 | 8 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-23 00:00:00 | KWH | 8 | 7 | 7 | 7 | 8 | 7 | 6 | 7 | 6 | 6 | 7 | 7 | 9 | 10 | 10 | 13 | 16 | 17 | 20 | 20 | 19 | 22 | 23 | 23 | 23 | 22 | 22 | 23 | 22 | 24 | 24 | 24 | 20 | 22 | 21 | 20 | 21 | 20 | 19 | 18 | 17 | 15 | 15 | 11 | 10 | 10 | 10 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-24 00:00:00 | KWH | 9 | 8 | 8 | 8 | 7 | 8 | 7 | 8 | 7 | 8 | 7 | 8 | 10 | 10 | 11 | 13 | 15 | 19 | 21 | 22 | 24 | 24 | 26 | 26 | 24 | 23 | 23 | 22 | 23 | 24 | 22 | 23 | 22 | 19 | 19 | 21 | 19 | 18 | 18 | 16 | 17 | 15 | 15 | 12 | 11 | 10 | 11 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-25 00:00:00 | KWH | 8 | 8 | 6 | 8 | 7 | 7 | 6 | 6 | 6 | 7 | 5 | 6 | 9 | 9 | 11 | 11 | 15 | 17 | 19 | 20 | 20 | 21 | 23 | 23 | 23 | 21 | 23 | 23 | 23 | 22 | 24 | 24 | 24 | 22 | 23 | 21 | 22 | 20 | 19 | 20 | 18 | 17 | 18 | 14 | 10 | 11 | 11 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-26 00:00:00 | KWH | 8 | 8 | 8 | 7 | 8 | 6 | 7 | 7 | 8 | 7 | 7 | 9 | 10 | 9 | 11 | 12 | 15 | 17 | 18 | 20 | 19 | 19 | 20 | 21 | 20 | 21 | 19 | 22 | 23 | 22 | 24 | 24 | 20 | 21 | 21 | 20 | 21 | 20 | 18 | 17 | 17 | 14 | 14 | 13 | 12 | 11 | 9 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-27 00:00:00 | KWH | 9 | 9 | 7 | 7 | 7 | 5 | 7 | 6 | 7 | 7 | 6 | 7 | 8 | 7 | 8 | 7 | 10 | 11 | 13 | 12 | 10 | 8 | 11 | 9 | 10 | 11 | 12 | 13 | 13 | 16 | 17 | 17 | 16 | 17 | 17 | 16 | 15 | 13 | 12 | 12 | 13 | 10 | 11 | 9 | 10 | 11 | 10 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-28 00:00:00 | KWH | 10 | 9 | 10 | 8 | 7 | 7 | 7 | 7 | 7 | 8 | 7 | 8 | 7 | 8 | 8 | 8 | 8 | 8 | 11 | 13 | 13 | 12 | 12 | 11 | 10 | 12 | 12 | 12 | 13 | 16 | 14 | 15 | 17 | 18 | 16 | 19 | 18 | 17 | 18 | 20 | 17 | 17 | 13 | 11 | 12 | 10 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-29 00:00:00 | KWH | 7 | 7 | 8 | 7 | 8 | 8 | 7 | 7 | 6 | 7 | 6 | 7 | 7 | 8 | 9 | 10 | 10 | 11 | 13 | 16 | 19 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 18 | 18 | 19 | 20 | 21 | 20 | 21 | 22 | 21 | 22 | 20 | 18 | 18 | 17 | 15 | 12 | 10 | 10 | 8 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-30 00:00:00 | KWH | 10 | 8 | 8 | 7 | 7 | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 10 | 10 | 10 | 9 | 14 | 19 | 18 | 17 | 17 | 17 | 18 | 18 | 18 | 20 | 21 | 22 | 23 | 21 | 25 | 24 | 23 | 22 | 23 | 21 | 21 | 20 | 21 | 19 | 15 | 13 | 14 | 11 | 9 | 9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
13709958 | 124 | 2200030352157 | 2012-10-31 00:00:00 | 2012-10-31 00:00:00 | KWH | 9 | 9 | 8 | 7 | 7 | 8 | 7 | 7 | 6 | 7 | 6 | 7 | 7 | 8 | 9 | 9 | 10 | 10 | 13 | 18 | 19 | 19 | 21 | 22 | 21 | 21 | 23 | 22 | 22 | 24 | 23 | 23 | 24 | 26 | 22 | 22 | 23 | 20 | 18 | 18 | 16 | 17 | 14 | 14 | 13 | 13 | 10 | 10 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N