Spreadsheet: 730433d1619699704-sumproduct-with-dates-book10
Sheet: Sheet1

 |  |  | MONTH
2021-04-04 00:00:00
 |  | SWAP Profile | Annual Profile (12 months: Oct 2020 to Sep 2021) | Expected Starts Until current month | Current Month Starts profile | Actually starts curent month | Achieved Vs Profile |  | Adjusted weekly Profile |  | % Profile Expected to have been  Achieved | % Profile Achieved | % Dif.  Expected V Achieved
 |  | ACTON
 |  | EALING
 |  | FULHAM
 |  | HARLESDEN
 |  | HARROW
 |  | HAYES
 |  | HOUNSLOW
 |  | KINGSTON
 |  | SHEPHERDS BUSH
 |  | TWICKENHAM
 |  | UXBRIDGE
 |  | WANDSWORTH
 |  | WEMBLEY
 |  | West London
 |  |  |  | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021
 |  | Office | WEEK FRIDAY | 2020-10-09 00:00:00 | 2020-10-16 00:00:00 | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2021-01-01 00:00:00 | 2021-01-08 00:00:00 | 2021-01-15 00:00:00 | 2021-01-22 00:00:00 | 2021-01-29 00:00:00 | 2021-02-05 00:00:00 | 2021-02-12 00:00:00 | 2021-02-19 00:00:00 | 2021-02-26 00:00:00 | 2021-03-05 00:00:00 | 2021-03-12 00:00:00 | 2021-03-19 00:00:00 | 2021-03-26 00:00:00 | 2021-04-02 00:00:00 | 2021-04-09 00:00:00 | 2021-04-16 00:00:00 | 2021-04-23 00:00:00 | 2021-04-30 00:00:00 | 2021-05-07 00:00:00 | 2021-05-14 00:00:00 | 2021-05-21 00:00:00 | 2021-05-28 00:00:00 | 2021-06-04 00:00:00 | 2021-06-11 00:00:00 | 2021-06-18 00:00:00 | 2021-06-25 00:00:00 | 2021-07-02 00:00:00 | 2021-07-09 00:00:00 | 2021-07-16 00:00:00 | 2021-07-23 00:00:00 | 2021-07-30 00:00:00 | 2021-08-06 00:00:00 | 2021-08-13 00:00:00 | 2021-08-20 00:00:00 | 2021-08-27 00:00:00 | 2021-09-03 00:00:00 | 2021-09-10 00:00:00 | 2021-09-17 00:00:00
 |  |  |  | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38
 |  | ACTON | 712 | 0 | 0 | 17 | 107 | 103 | 51 | 26 | 18 | 31 | 26 | 20 | 18 | 1 | 14 | 14 | 31 | 22 | 56 | 30 | 22 | 4 | 33 | 10 | 13 | 20 | 0 | 20 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | EALING | 1328 | 0 | 0 | 26 | 87 | 64 | 66 | 41 | 37 | 45 | 36 | 33 | 12 | 2 | 42 | 51 | 104 | 47 | 117 | 91 | 96 | 39 | 86 | 18 | 32 | 19 | 0 | 58 | 79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | FULHAM | 433 | 0 | 0 | 41 | 66 | 24 | 14 | 15 | 22 | 10 | 14 | 9 | 2 | 1 | 14 | 12 | 27 | 17 | 31 | 25 | 21 | 8 | 19 | 8 | 15 | 6 | 0 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | HARLESDEN | 550 | 0 | 0 | 8 | 50 | 37 | 37 | 64 | 51 | 4 | 15 | 27 | 18 | 2 | 14 | 32 | 23 | 8 | 23 | 7 | 14 | 9 | 37 | 9 | 21 | 10 | 0 | 19 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | HARROW | 645 | 0 | 0 | 47 | 74 | 71 | 60 | 56 | 48 | 13 | 9 | 7 | 8 | 0 | 7 | 10 | 39 | 12 | 24 | 28 | 21 | 9 | 30 | 10 | 17 | 23 | 0 | 16 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | HAYES | 523 | 0 | 0 | 35 | 48 | 91 | 71 | 51 | 43 | 9 | 10 | 15 | 4 | 2 | 6 | 12 | 16 | 8 | 13 | 13 | 12 | 7 | 16 | 3 | 15 | 5 | 0 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | HOUNSLOW | 950 | 0 | 0 | 48 | 71 | 60 | 40 | 51 | 48 | 57 | 34 | 28 | 7 | 2 | 37 | 34 | 49 | 14 | 46 | 36 | 47 | 17 | 51 | 43 | 50 | 30 | 0 | 38 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | KINGSTON | 590 | 0 | 12 | 20 | 25 | 43 | 30 | 24 | 20 | 26 | 25 | 26 | 11 | 10 | 14 | 31 | 29 | 19 | 27 | 25 | 27 | 24 | 17 | 12 | 25 | 31 | 14 | 6 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | SHEPHERDS BUSH | 473 | 0 | 0 | 3 | 48 | 105 | 57 | 40 | 41 | 5 | 13 | 9 | 10 | 6 | 10 | 5 | 16 | 6 | 17 | 12 | 8 | 3 | 16 | 5 | 7 | 2 | 0 | 9 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TWICKENHAM | 611 | 0 | 11 | 0 | 0 | 24 | 49 | 55 | 49 | 23 | 19 | 39 | 12 | 0 | 31 | 25 | 29 | 19 | 12 | 22 | 19 | 24 | 32 | 26 | 25 | 26 | 17 | 6 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | UXBRIDGE | 463 | 0 | 0 | 45 | 37 | 65 | 62 | 35 | 24 | 14 | 7 | 11 | 14 | 0 | 1 | 31 | 13 | 1 | 3 | 8 | 20 | 8 | 16 | 12 | 12 | 11 | 0 | 9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | WANDSWORTH | 447 | 0 | 0 | 43 | 44 | 23 | 12 | 21 | 20 | 18 | 19 | 14 | 23 | 6 | 19 | 13 | 17 | 26 | 27 | 23 | 7 | 16 | 6 | 7 | 11 | 11 | 8 | 5 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | WEMBLEY | 1343 | 0 | 0 | 44 | 90 | 86 | 112 | 90 | 91 | 56 | 70 | 55 | 35 | 6 | 34 | 56 | 75 | 26 | 59 | 44 | 43 | 28 | 86 | 31 | 28 | 40 | 0 | 40 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | West London | 9068 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Site | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | TOTAL
 |  | South London | Kingston | 8 | 39 | 26 | 44 | 46 | 44 | 46 | 44 | 42 | 50 | 44 | 44
 |  | South London | TWICKENHAM | 6 | 28 | 19 | 31 | 33 | 32 | 33 | 32 | 30 | 36 | 32 | 32
 |  | Central  London | Wandsworth | 11.14561888558061 | 25.75197788175245 | 36.28687792428754 | 41.12173543173118 | 41.12173543173118 | 41.12173543173118 | 58.52722245852829 | 58.52722245852829 | 58.52722245852829 | 46.82177796682263 | 46.82177796682263 | 46.82177796682263
 |  | WEST | [NAME] | 24 | 28 | 40 | 44 | 44 | 44 | 65 | 65 | 65 | 52 | 52 | 52
 |  | WEST | Ealing | 49 | 57 | 80 | 85 | 85 | 85 | 130 | 130 | 130 | 104 | 104 | 104
 |  | WEST | Fulham | 28 | 32 | 45 | 48 | 48 | 48 | 74 | 74 | 74 | 59 | 59 | 59
 |  | WEST | Harlesden | 52 | 60 | 84 | 88 | 88 | 88 | 136 | 136 | 136 | 109 | 109 | 109
 |  | WEST | [NAME] | 37 | 43 | 60 | 64 | 64 | 64 | 98 | 98 | 98 | 79 | 79 | 79
 |  | WEST | [NAME] | 19 | 23 | 32 | 33 | 33 | 33 | 52 | 52 | 52 | 41 | 41 | 41
 |  | WEST | Hounslow | 51 | 59 | 83 | 87 | 87 | 87 | 135 | 135 | 135 | 108 | 108 | 108
 |  | WEST | [NAME] | 15 | 17 | 24 | 25 | 25 | 25 | 39 | 39 | 39 | 31 | 31 | 31
 |  | WEST | Uxbridge | 22 | 26 | 36 | 38 | 38 | 38 | 58 | 58 | 58 | 47 | 47 | 47
 |  | WEST | Wembley | 25 | 29 | 41 | 43 | 43 | 43 | 67 | 67 | 67 | 53 | 53 | 53
 |  |  | West London
 |  | Kingston