Spreadsheet: 171876d1343899407-generating-a-list-of-electricity-meters-that-have-not-been-read-for-three-months-database-of-utilties-2012
Sheet: METER READINGS

 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
UTILITY | SCHEME | PAID BY DIRECT DEBIT YES/NO | Nominal Codes | expense code | SITE NO | First METER ID/NO | Second METER ID/NO | ACCOUNT NO | SUPPLY NO | Start Date | End Date | First Opening Read | Type | First Closing Read | Type | Second Opening Read | Type | Second Closing Read | Type | First Opening Read | Type | First Closing Read | Type | Second Opening Read | Type | Second Closing Read | Type | Cost | Ref
Electricity | Site1 |  | 7009/00 | 500/01 | 527419 | A01M83844 |  | 299985 | S 01 801 11 16 2000 0998 244 | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 33734 | E | 33975 | E |  |  |  |  |  |  |  |  |  |  |  |  | 30.71 | PRIN 586
Electricity | Site1 |  | 7009/00 | 500/01 | 527419 | A01M83844 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 33479 | E | 33734 | E |  |  |  |  |  |  |  |  |  |  |  |  | 32.42 | PRIN 553
Electricity | Site1 |  | 7009/00 | 500/01 | 527419 | A01M83844 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 33975 | E | 34218 | E |  |  |  |  |  |  |  |  |  |  |  |  | 31.04 | PRIN 632
Electricity | Site10 |  | 7026/00 | 500/01 | 527416 | K85M28493 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 85247 | E | 85991 | E |  |  |  |  |  |  |  |  |  |  |  |  | 87.65 | PRIN 584
Electricity | Site10 |  | 7026/00 | 500/01 | 527416 | K85M28493 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 84461 | E | 85247 | E |  |  |  |  |  |  |  |  |  |  |  |  | 92.55 | PRIN 549
Electricity | Site10 |  | 7026/00 | 500/01 | 527416 | K85M28493 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 85991 | E | 86742 | E |  |  |  |  |  |  |  |  |  |  |  |  | 88.55 | PRIN 620
Electricity | Site11 |  | 7028/00 | 500/01 | 527415 | A01M44629 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 2738 | E | 2760 | E |  |  |  |  |  |  |  |  |  |  |  |  | 6.01 | PRIN 583
Electricity | Site11 |  | 7028/00 | 500/01 | 527415 | A01M44629 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 2715 | E | 2738 | E |  |  |  |  |  |  |  |  |  |  |  |  | 6.24 | PRIN 548
Electricity | Site11 |  | 7028/00 | 500/01 | 527415 | A01M44629 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 2760 | E | 2783 | E |  |  |  |  |  |  |  |  |  |  |  |  | 6.24 | PRIN 630
Electricity | Site12 |  | 7031/00 | 500/01 | 527424 | 211238090 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 1252 | E | 3048 | E | 354 | E | 844 | E |  |  |  |  |  |  |  |  | 238.3 | PRIN 593
Electricity | Site12 |  | 7031/00 | 500/01 | 527424 | P02M00247 | 211238090 | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 221923 | E | 221744 | A | 66980 | E | 66042 | A | 0 | A | 1252 | E | 0 | A | 354 | E | 93.84 | PRIN 561
Electricity | Site12 |  | 7031/00 | 500/01 | 527424 | 211238090 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 3048 | A | 4986 | A | 844 | A | 1348 | A |  |  |  |  |  |  |  |  | 254.99 | PRIN 625
Electricity | Site13 |  | 7033/00 | 500/01 | 52712 | L91M10435 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 235783 | E | 236590 | E | 710787 | E | 712168 | E |  |  |  |  |  |  |  |  | 218.18 | PRIN 581
Electricity | Site13 |  | 7033/00 | 500/01 | 527412 | L91M10435 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 234767 | E | 235783 | E | 709374 | E | 710787 | E |  |  |  |  |  |  |  |  | 235.23 | PRIN 546
Electricity | Site13 |  | 7033/00 | 500/01 | 527412 | L91M10435 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 236590 | E | 237376 | E | 712168 | E | 713590 | E |  |  |  |  |  |  |  |  | 221.84 | PRIN 618
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 84419 | E | 84468 | E | 88096 | E | 88216 | E |  |  |  |  |  |  |  |  | 20.67 | PRIN 578
Electricity | Site14 |  | 7035/00 | 500/01 | 527410 | F87M05861 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 60780 | E | 60936 | E | 1065 | E | 1193 | E |  |  |  |  |  |  |  |  | 28.73 | PRIN 579
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 | 84753 | E | 84954 | E | 87913 | E | 88190 | E |  |  |  |  |  |  |  |  | -50.24 | PRCR 101
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 | 84517 | E | 84753 | E | 87606 | E | 87913 | E |  |  |  |  |  |  |  |  | -56.09 | PRCR 102
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | 84297 | E | 84517 | E | 87294 | E | 87606 | E |  |  |  |  |  |  |  |  | -55.84 | PRCR 103
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-04-01 00:00:00 | 2012-04-30 00:00:00 | 84954 | E | 85115 | E | 88190 | E | 88407 | E |  |  |  |  |  |  |  |  | -40.07 | PRCR 104
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-01-01 00:00:00 | 2012-05-31 00:00:00 | 84297 | A | 84419 | A | 87294 | A | 88096 | A |  |  |  |  |  |  |  |  | 120.83 | PRIN 551
Electricity | Site14 |  | 7035/00 | 500/01 | 527410 | F87M05861 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 59988 | A | 60780 | A | 903 | A | 1065 | A |  |  |  |  |  |  |  |  | 74.61 | PRIN 559
Electricity | Site14 |  | 7035/00 | 500/01 | 527409 | F88M85107 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 84468 | E | 84514 | E | 88216 | E | 88336 | E |  |  |  |  |  |  |  |  | 20.57 | PRIN 616
Electricity | Site14 |  | 7035/00 | 500/01 | 527410 | F87M05861 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 60936 | E | 61084 | E | 1193 | E | 1320 | E |  |  |  |  |  |  |  |  | 28.16 | PRIN 622
Electricity | Site2 |  | 7004/00 | 500/01 | 557128 | K98M00466 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 272607 | E | 274119 | E | 443622 | E | 445523 | E |  |  |  |  |  |  |  |  | 327.69 | PRIN 590
Electricity | Site2 |  | 7004/00 | 500/01 | 557128 | K98M00466 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 278105 | A | 272607 | A | 440519 | A | 443622 | A |  |  |  |  |  |  |  |  | 21.51 | PRIN 562
Electricity | Site2 |  | 7004/00 | 500/01 | 557128 | K98M00466 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 274119 | E | 275614 | E | 445523 | E | 447471 | E |  |  |  |  |  |  |  |  | 332.32 | PRIN 626
Electricity | Site3 |  | 7007/00 | 500/01 | 527417 | F94M00146 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 221040 | E | 221672 | E | 211188 | E | 211562 | E |  |  |  |  |  |  |  |  | 103.52 | PRIN 585
Electricity | Site3 |  | 7007/00 | 500/01 | 527417 | F94M00146 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 220340 | E | 221040 | E | 210633 | E | 211188 | E |  |  |  |  |  |  |  |  | 123.49 | PRIN 550
Electricity | Site3 |  | 7007/00 | 500/01 | 527417 | F94M00146 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 221672 | E | 222308 | E | 211562 | E | 211910 | E |  |  |  |  |  |  |  |  | 102.42 | PRIN 621
Electricity | [NAME] |  | 7010/00 | 500/01 | 557136 | F69M06445 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 42961 | E | 43888 | E |  |  |  |  |  |  |  |  |  |  |  |  | 108.15 | PRIN 594
Electricity | [NAME] |  | 7010/00 | 500/01 | 557136 | F69M06445 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 41983 | E | 42961 | E |  |  |  |  |  |  |  |  |  |  |  |  | 114.03 | PRIN 557
Electricity | [NAME] |  | 7010/00 | 500/01 | 557136 | F69306445 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 43888 | E | 44823 | E |  |  |  |  |  |  |  |  |  |  |  |  | 109.14 | PRIN 628
Electricity | Site5 |  | 7011/00 | 500/01 | 527411 | A98M00961 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 48887 | E | 48889 | E |  |  |  |  |  |  |  |  |  |  |  |  | 3.31 | PRIN 617
Electricity | Site5 |  | 7011/00 | 500/01 | 527411 | A98M00961 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 48885 | E | 48887 | E |  |  |  |  |  |  |  |  |  |  |  |  | 3.21 | PRIN 580
Electricity | Site5 |  | 7011/00 | 500/01 | 527421 | K96M11848 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 10840 | E | 10922 | E |  |  |  |  |  |  |  |  |  |  |  |  | 12.81 | PRIN 587
Electricity | Site5 |  | 7011/00 | 500/01 | 527411 | A98M00961 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 48883 | E | 48885 | E |  |  |  |  |  |  |  |  |  |  |  |  | 3.31 | PRIN 545
Electricity | Site5 |  | 7011/00 | 500/01 | 527421 | K96M11848 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 10753 | E | 10840 | E |  |  |  |  |  |  |  |  |  |  |  |  | 13.5 | PRIN 554
Electricity | Site5 |  | 7011/00 | 500/01 | 527421 | K96M11848 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 10922 | E | 11005 | E |  |  |  |  |  |  |  |  |  |  |  |  | 13.03 | PRIN 623
Electricity | Site6 |  | 7014/00 | 500/01 | 527423 | A05M12204 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 4408 | E | 4464 | E |  |  |  |  |  |  |  |  |  |  |  |  | 10 | PRIN 589
Electricity | Site6 |  | 7014/00 | 500/01 | 557133 | A05M12208 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 4252 | E | 4295 | E |  |  |  |  |  |  |  |  |  |  |  |  | 8.41 | PRIN 591
Electricity | Site6 |  | 7014/00 | 500/01 | 557133 | A05M12208 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 4211 | A | 4252 | A |  |  |  |  |  |  |  |  |  |  |  |  | 8.26 | PRIN 556
Electricity | Site6 |  | 7014/00 | 500/01 | 527423 | A05M12204 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 4406 | A | 4408 | A |  |  |  |  |  |  |  |  |  |  |  |  | 3.42 | PRIN 560
Electricity | Site6 |  | 7014/00 | 500/01 | 527423 | A05M12204 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 4464 | E | 4522 | E |  |  |  |  |  |  |  |  |  |  |  |  | 10.35 | PRIN 624
Electricity | Site6 |  | 7014/00 | 500/01 | 557133 | A05M12208 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 4295 | A | 4356 | A |  |  |  |  |  |  |  |  |  |  |  |  | 10.74 | PRIN 627
Electricity | Site7 |  | 7015/00 | 500/01 | 527413 | F98M01924 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 30504 | E | 30639 | E |  |  |  |  |  |  |  |  |  |  |  |  | 18.74 | PRIN 582
Electricity | Site7 |  | 7015/00 | 500/01 | 527422 | F97M21984 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 35798 | E | 35972 | E |  |  |  |  |  |  |  |  |  |  |  |  | 22.05 | PRIN 588
Electricity | Site7 |  | 7015/00 | 500/01 | 527413 | F98M01924 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 30361 | E | 30504 | E |  |  |  |  |  |  |  |  |  |  |  |  | 19.78 | PRIN 547
Electricity | Site7 |  | 701500 | 500/01 | 527422 | F97M21984 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 35614 | E | 35798 | E |  |  |  |  |  |  |  |  |  |  |  |  | 23.24 | PRIN 555
Electricity | Site7 |  | 7015/00 | 500/01 | 527413 | F98M01924 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 30639 | E | 30775 | E |  |  |  |  |  |  |  |  |  |  |  |  | 18.95 | PRIN 619
Electricity | Site7 |  | 7015/00 | 500/01 | 527422 | F97M21984 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 35972 | E | 36153 | E |  |  |  |  |  |  |  |  |  |  |  |  | 22.92 | PRIN 633
Electricity | Site8 |  | 7018/00 | 500/01 | 558896 | A06M11307 |  | 299985 |  | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 19711 | E | 19929 | E |  |  |  |  |  |  |  |  |  |  |  |  | 26.83 | PRIN 595
Electricity | Site8 |  | 7018/00 | 500/01 | 558896 | A06M11307 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 19057 | A | 19711 | A |  |  |  |  |  |  |  |  |  |  |  |  | 73.92 | PRIN 558
Electricity | Site8 |  | 7018/00 | 500/01 | 558896 | A06M11307 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 19929 | A | 20501 | A |  |  |  |  |  |  |  |  |  |  |  |  | 65.08 | PRIN 629
Electricity | Site9 |  | 7019/00 | 500/01 | 527418 | F36M12304 | 211168696 | 299985 |  | 2012-05-01 00:00:00 | 2012-06-30 00:00:00 | 166437 | E | 167357 | A | 394812 | E | 396129 | A | 0 | A | 3921 | E | 0 | A | 1346 | E | 716.3 | PRIN 592
Electricity | Site9 |  | 7019/00 | 500/01 | 527418 | F36M12304 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 166437 | E | 170946 | E | 394812 | E | 396279 | E |  |  |  |  |  |  |  |  | -592.94 | PRCR 110
Electricity | Site9 |  | 7019/00 | 500/01 | 527418 | F36M12304 |  | 299985 |  | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 166437 | E | 170946 | E | 394812 | E | 396279 | E |  |  |  |  |  |  |  |  | 592.94 | PRIN 552
Electricity | Site9 |  | 7019/00 | 500/01 | 527418 | 211168969 |  | 299985 |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 | 3921 | A | 7751 | A | 1346 | A | 2729 | A |  |  |  |  |  |  |  |  | 514.21 | PRIN 631