Spreadsheet: 117105d1312453675-if-and-advice-index-area
Sheet: Sheet1

Notes | Index | Area | Dates |  | Numbers should be
 |  | ASHFORD, KENT | 2011-02-14 00:00:00 |  | 1
 |  | ASHFORD, KENT | 2011-02-11 00:00:00 |  | 2
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-05-10 00:00:00 |  | 3
 |  | ASHFORD, KENT | 2011-03-17 00:00:00 |  | 4
 |  | ASHFORD, KENT | 2010-11-28 00:00:00 |  | 5
 |  | ASHFORD, KENT | 2011-03-14 00:00:00 |  | 6
 |  | ASHFORD, KENT | 2010-11-28 00:00:00 |  | 7
 |  | ASHFORD, KENT | 2011-01-28 00:00:00 |  | 8
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2010-11-28 00:00:00 |  | 9
 |  | ASHFORD, KENT | 2011-04-13 00:00:00 |  | 10
 |  | ASHFORD, KENT | 2010-12-21 00:00:00 |  | 11
 |  | ASHFORD, KENT | 2011-02-14 00:00:00 |  | 12
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-03-09 00:00:00 |  | 13
 |  | ASHFORD, KENT | 2010-12-24 00:00:00 |  | 14
 |  | ASHFORD, KENT | 2011-06-13 00:00:00 |  | 15
 |  | ASHFORD, KENT | 2011-02-04 00:00:00 |  | 16
 |  | ASHFORD, KENT | 2011-03-25 00:00:00 |  | 17
 |  | ASHFORD, KENT | 2011-02-28 00:00:00 |  | 18
 |  | ASHFORD, KENT | 2011-03-25 00:00:00 |  | 19
 |  | ASHFORD, KENT | 2011-01-25 00:00:00 |  | 20
 |  | ASHFORD, KENT | 2011-01-14 00:00:00 |  | 21
 |  | ASHFORD, KENT | 2011-01-25 00:00:00 |  | 22
 |  | ASHFORD, KENT | 2011-02-11 00:00:00 |  | 23
 |  | ASHFORD, KENT | 2011-05-26 00:00:00 |  | 24
 |  | ASHFORD, KENT | 2011-03-27 00:00:00 |  | 25
 |  | ASHFORD, KENT | 2011-02-03 00:00:00 |  | 26
 |  | ASHFORD, KENT | 2010-12-20 00:00:00 |  | 27
 |  | ASHFORD, KENT | 2010-12-10 00:00:00 |  | 28
 |  | ASHFORD, KENT | 2011-02-08 00:00:00 |  | 29
 |  | ASHFORD, KENT | 2011-02-09 00:00:00 |  | 30
 |  | ASHFORD, KENT | 2011-02-03 00:00:00 |  | 31
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-01-25 00:00:00 |  | 32
 |  | ASHFORD, KENT | 2011-01-18 00:00:00 |  | 33
 |  | ASHFORD, KENT | 2011-02-08 00:00:00 |  | 34
 |  | ASHFORD, KENT | 2011-04-20 00:00:00 |  | 35
 |  | ASHFORD, KENT | 2011-02-14 00:00:00 |  | 36
 |  | ASHFORD, KENT | 2011-07-05 00:00:00 |  | 37
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-01-25 00:00:00 |  | 38
 |  | ASHFORD, KENT | 2011-03-10 00:00:00 |  | 39
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-01-31 00:00:00 |  | 40
 |  | ASHFORD, KENT | 2011-02-11 00:00:00 |  | 41
 |  | ASHFORD, KENT | 2011-05-26 00:00:00 |  | 42
 |  | ASHFORD, KENT | 2011-01-14 00:00:00 |  | 43
 |  | ASHFORD, KENT | 2010-12-20 00:00:00 |  | 44
 |  | ASHFORD, KENT | 2011-02-03 00:00:00 |  | 45
 |  | ASHFORD, KENT | 2011-02-03 00:00:00 |  | 46
 |  | ASHFORD, KENT | 2011-01-27 00:00:00 |  | 47
 |  | ASHFORD, KENT | 2010-11-29 00:00:00 |  | 48
 |  | ASHFORD, KENT | 2011-01-27 00:00:00 |  | 49
 |  | ASHFORD, KENT | 2010-12-30 00:00:00 |  | 50
 |  | ASHFORD, KENT | 2010-12-23 00:00:00 |  | 51
 |  | ASHFORD, KENT | 2011-01-21 00:00:00 |  | 52
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | ASHFORD, KENT | 2011-03-27 00:00:00 |  | 53
 |  | ASHFORD, KENT | 2011-06-15 00:00:00 |  | 54
 |  | ASHFORD, KENT | 2011-03-21 00:00:00 |  | 55
 |  | ASHFORD, KENT | 2011-03-07 00:00:00 |  | 56
 |  | ASHFORD, KENT | 2011-01-14 00:00:00 |  | 57
 |  | ASHFORD, KENT | 2011-07-05 00:00:00 |  | 58
 |  | ASHFORD, KENT | 00:00:00 |  | 0
 |  | BARNET | 00:00:00 |  | 0
 |  | BARNET | 00:00:00 |  | 0
 |  | BARNET | 00:00:00 |  | 0
 |  | BARNET | 00:00:00 |  | 0
 |  | BEARSTED |  | This doesn’t have a date, so next one down is 59 instead of 1 <----- | 0
I want this to start from 1 as Bearstead is a different Area  -----> |  | BEARSTED | 2011-03-29 00:00:00 |  | 1
 |  | BEARSTED | 00:00:00 |  | 0
 |  | BEARSTED | 2011-03-29 00:00:00 |  | 2
 |  | BEARSTED | 00:00:00 |  | 0
 |  | BEARSTED | 2011-05-06 00:00:00 |  | 3
 |  | BEARSTED | 2011-03-29 00:00:00 |  | 4
 |  | BEARSTED | 2011-03-31 00:00:00 |  | 5
 |  | BEARSTED | 2011-07-01 00:00:00 |  | 6
 |  | BEARSTED | 2011-07-01 00:00:00 |  | 7
 |  | BEARSTED | 2011-03-31 00:00:00 |  | 8
 |  | BEARSTED | 2011-03-31 00:00:00 |  | 9
 |  | BEARSTED | 2011-03-31 00:00:00 |  | 10
 |  | BEARSTED | 2011-03-31 00:00:00 |  | 11
 |  | BEARSTED | 2011-05-06 00:00:00 |  | 12
 |  | BEARSTED | 00:00:00 |  | 0
 |  | BEARSTED | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BIGGIN HILL | 00:00:00 |  | 0
 |  | BILLERICAY | 00:00:00 |  | 0
 |  | CAXTON | 00:00:00 |  | 0
 |  | CAXTON | 00:00:00 |  | 0
 |  | CAXTON | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHAFFORD | 00:00:00 |  | 0
 |  | CHELMSFORD | 00:00:00 |  | 0
 |  | CHELMSFORD | 00:00:00 |  | 0
 |  | CHELMSFORD | 00:00:00 |  | 0
 |  | CHINGFORD | 2011-06-15 00:00:00 |  | 1
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COBHAM | 00:00:00 |  | 0
 |  | COPTHORNE | 2011-07-11 00:00:00 |  | 1
 |  | COPTHORNE | 2011-06-28 00:00:00 |  | 2
 |  | COPTHORNE | 2011-07-07 00:00:00 |  | 3
 |  | COPTHORNE | 2011-07-01 00:00:00 |  | 4
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 2011-06-24 00:00:00 |  | 5
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 2011-06-27 00:00:00 |  | 6
 |  | COPTHORNE | 2011-07-14 00:00:00 |  | 7
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 2011-06-24 00:00:00 |  | 8
 |  | COPTHORNE | 2011-06-27 00:00:00 |  | 9
 |  | COPTHORNE | 00:00:00 |  | 0
 |  | COPTHORNE | 2011-07-07 00:00:00 |  | 10
 |  | COPTHORNE | 00:00:00 |  | 0