Spreadsheet: 794610d1662139371-multiple-data-pull-from-source-sonal-file
Sheet: Agency  Total Hours 2021-22

Total WORKED Hours
Region | Home Name | 2021-11-21 00:00:00 | 2021-11-28 00:00:00 | 2021-12-05 00:00:00 | 2021-12-12 00:00:00 | 2021-12-19 00:00:00 | 2021-12-26 00:00:00 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | WE 27Mar22 | WE 03Apr22 | WE 10Apr22 | WE 17Apr22 | WE 24Apr22 | WE 01May22 | WE 08May22 | WE 15May22 | WE 22May22 | WE 29May22 | WE 05Jun22 | WE 12Jun22 | WE 19Jun22 | WE 26Jun22 | WE 03Jul22 | WE 10Jul22 | WE 17Jul22 | WE 24Jul22 | WE 31Jul22 | Weekly Movement
Central | Acton Care Centre | 3955.5 | 3809.25 | 3762 | 3828.25 | 3887.42 | 3953.25 | 3801.73 | 3839.75 | 3862.5 | 3995.75 | 4025 | 4057.25 | 4046.02 | 3913 | 4036.25 | 4020.75 | 4000 | 4066.25 | 4060.25 | 3792.67 | 4100.42 | 4058.969999999999 | 3973.070000000001 | 3987.13 | 3986 | 4077.01 | 4100 | 5557 | 5535.25 | 4066.59 | 4009.77 | 3973.5 | 4085.7 | 4096.42 | 4177.75 | 4243
Central | [NAME] | 1254.5 | 1216.25 | 1282.27 | 1265 | 1187.25 | 1221.2 | 1153.5 | 1156.77 | 1152.5 | 1166.25 | 1268.5 | 1261.5 | 1189.5 | 1269.72 | 1299 | 1232 | 1251 | 1230.25 | 1290.5 | 1339.5 | 1374.75 | 1321.5 | 1342.25 | 1310.25 | 1306.25 | 1323.5 | 1271.5 | 1281.25 | 1302.75 | 1306.25 | 1360 | 1311 | 1383 | 1359.75 | 1256.25 | 1330.5
Central | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1575.5 | 1537.58 | 1566.42 | 1573.17 | 1519.63 | 1594.01 | 1518.22 | 1564.42 | 1524.37 | 1560.36 | 1570.57 | 1587.6 | 1574.93 | 1577.26 | 1556.51 | 1529.62 | 1525 | 1585.14 | 1540.25
[NAME] | Autumn Vale Care Centre | 2171.25 | 2108.57 | 2135.25 | 2102 | 2172.29 | 2080.5 | 2077.25 | 2142.75 | 2166.17 | 2222.45 | 2047.25 | 2000.75 | 2001.5 | 2005.5 | 2063.25 | 2104.5 | 2131.25 | 2042.5 | 2065.52 | 2094.5 | 2075.75 | 2243.5 | 2163 | 2162.25 | 2254.25 | 2175.25 | 2233 | 2319.75 | 2357.25 | 2050.25 | 2032.44 | 2059.5 | 2105.03 | 2224.28 | 2149 | 2132.75
South | Baugh House | 1836.25 | 1842 | 1684.5 | 1822.77 | 1854 | 1918 | 1638.75 | 1752.25 | 1886 | 1971.5 | 1998.75 | 1973 | 2075.52 | 2159.72 | 2032.5 | 1939.25 | 2097.25 | 1949 | 2056 | 1953.5 | 2023.25 | 2005.03 | 2091.5 | 2080.5 | 2168.5 | 2069.5 | 2082.5 | 2316.75 | 2368.25 | 2010.75 | 1791.5 | 1773 | 2053.85 | 1902.75 | 1968.37 | 2027.08
Central | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2839.75 | 2804.5 | 2795.75 | 2845.25 | 2866.92 | 2904.5 | 2873.75 | 2783.75 | 2710.5 | 2612 | 2650.5 | 2620.25 | 2740.25 | 2768.25 | 2191 | 2272.42 | 2400 | 2091.5 | 2523.5 | 2410.75 | 2496.25
Midlands | Bletchley House | 1265.5 | 1279.75 | 1319 | 1303.93 | 1383.25 | 1479.25 | 1363.52 | 1281.75 | 1261 | 1330.25 | 1370.25 | 1373.5 | 1402.5 | 1487.5 | 1549 | 1564.5 | 1588.5 | 1447.75 | 1453.75 | 1458.98 | 1474.25 | 1516.75 | 1437.25 | 1437.5 | 1418.5 | 1455 | 1392.25 | 1423.5 | 1428.25 | 1374.5 | 1367.88 | 1386.75 | 1196.77 | 1283.25 | 1354 | 1277.23
Central | Brackenbridge House | 860.25 | 812.5 | 822.75 | 771.5 | 811.5 | 850.25 | 849.25 | 843.57 | 806.5 | 860.75 | 822.75 | 887 | 811.75 | 849.75 | 864.5 | 847.25 | 808.5 | 831.1800000000001 | 875 | 877.25 | 896.75 | 882.75 | [NAME]:YX10:Y10 | 914.75 | 885.35 | 953.25 | 916.75 | 915.25 | 882.25 | 866.25 | 861 | 900.25 | 899.1 | 902.5 | 919.33 | 841
[NAME] | Broxbourne Nursing Home |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 57 | 55 | 179.25 | 132 | 319 | 243 | 243.5 | 314 | 294.5 | 345.5 | 263 | 275.5 | 565.25 | 713 | 712.75 | 735.25 | 975 | 1129.25
South | Burrows House | 1253 | 1231.17 | 1237.5 | 1218.75 | 1225.25 | 1325.63 | 1242.75 | 1274.5 | 1244.75 | 1515.25 | 1472.5 | 1461.5 | 1456.63 | 1417 | 1296.67 | 1460.5 | 1373.25 | 1437 | 1606.75 | 1471.5 | 1488.25 | 1338 | 1274 | 1300.25 | 1403.75 | 1410 | 1406.25 | 1388.5 | 1403.47 | 1387.5 | 1382 | 1409.75 | 1408.77 | 1386.5 | 1382.75 | 1391.25
Central | Drayton Village Care Centre | 1871 | 2223 | 2219.25 | 2346.25 | 2296.25 | 2510.62 | 2400.25 | 2386 | 2409.42 | 2359.25 | 2520 | 2445.5 | 2494.72 | 2483 | 2506.25 | 2515.25 | 2408.98 | 2490 | 2585.5 | 2565.5 | 2537.5 | 2500.25 | 2520 | 2580.5 | 2521.5 | 2592.5 | 2479.5 | 2647.75 | 2623.25 | 2448.75 | 2458.75 | 2540.75 | 2685.75 | 2674 | 2652.58 | 2579
[NAME] | Halcyon Days | 1207 | 1251.25 | 1241 | 1314.47 | 1408.48 | 1417 | 1457.27 | 1471 | 1348.25 | 1282 | 1079.25 | 1265.5 | 1313.42 | 1266.82 | 1312.91 | 1388.5 | 1314.5 | 1277.25 | 1307.25 | 1359.25 | 1299.25 | 1303 | 1316.25 | 1276.25 | 1258.5 | 1337.75 | 1291.75 | 1379.5 | 1413.25 | 1346.25 | 1336.75 | 1362 | 1380.75 | 1343.5 | 1327.5 | 1345.02
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | 1356.75 | 1366.63 | 1363.5 | 1360 | 1359.5 | 1398.75 | 1349.5 | 1367 | 2223.25 | 2285.75 | 2285.5 | 2272.75 | 2234.5 | 2192.25 | 2195.5 | 2307 | 2317.25 | 2377.75 | 2283.75 | 2294.25 | 2330.5 | 2250.75 | 2164.5 | 2239.75 | 2176.5 | 2213 | 1666.75 | 1954 | 1838 | 1466.5 | 1592 | 1609.75 | 1561 | 1610 | 1623.25 | 1652.25
South | Hillside Nursing Home | 1135.82 | 1082.5 | 1048 | 1127.5 | 1145.5 | 1092 | 1074.75 | 1118.25 | 1407.57 | 1362.25 | 1391.05 | 1387.75 | 1338 | 1156.3 | 1367.85 | 1400.25 | 1309.25 | 1363 | 1387.25 | 1309.5 | 1406 | 1528.5 | 1441.5 | 1591.25 | 1360.5 | 1519 | 1439.75 | 3640 | 3779.75 | 1481.75 | 1390.75 | 1418 | 1533.25 | 1399 | 1216.5 | 1382.8
Central | [NAME] | 978.5 | 1059 | 1017.5 | 1107.75 | 1031 | 697.25 | 673 | 582.5 | 678.8 | 661.5 | 542.5 | 630.25 | 861.5 | 754 | 849 | 864 | 859.5 | 876.75 | 914.55 | 885.25 | 909.9200000000001 | 927 | 965.75 | 928.75 | 860.4300000000001 | 897.75 | 946.75 | 1179.6 | 1096.5 | 841.75 | 869 | 941.5 | 952.25 | 947.5 | 873 | 925.25
Midlands | Lucton House | 981.83 | 1089.75 | 1053.53 | 1041.5 | 1025.48 | 1119.25 | 1061.57 | 1030.25 | 1034.5 | 1058 | 1115.75 | 1101.75 | 991.25 | 995.52 | 1097.88 | 964 | 1054 | 1088 | 1076.3 | 1075.75 | 1163.25 | 1077.5 | 1124.12 | 1157.25 | 1113.25 | 1109.5 | 1189.75 | 1151.5 | 1109.75 | 1135.75 | 1130 | 1086.5 | 1139.51 | 1125.25 | 1136.25 | 1174.93
Midlands | Manor House | 832.75 | 812 | 777.25 | 806 | 806.5 | 834.5 | 764 | 822.5 | 836.5 | 830.75 | 801.75 | 799 | 823.75 | 793 | 801 | 822.75 | 838 | 880 | 813.5 | 865 | 905.75 | 868.5 | 855.25 | 821.25 | 820.75 | 830.5 | 842.5 | 820.25 | 862.5 | 940 | 960 | 924 | 942 | 926.25 | 952.02 | 939.28
[NAME] | Martins House | 1458.85 | 1488.5 | 1456.33 | 1487 | 1489.25 | 1592 | 1509 | 1522.75 | 1473.25 | 1460.5 | 1483.5 | 1482.5 | 1491 | 1430.25 | 1447.75 | 1461.75 | 1513.75 | 1536.5 | 1486.75 | 1374.75 | 1449.5 | 1493.5 | 1546.75 | 1551.5 | 1456.25 | 1515.75 | 1598.75 | 1449.25 | 1453.25 | 1448.75 | 1435.25 | 1455.25 | 1463 | 1427.5 | 1412.75 | 1514.08
South | Partridge House |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1291.75 | 1312.75 | 1450.5 | 1455.75 | 1510.25 | 1539.58 | 1572 | 1614 | 1667.5 | 1676.25 | 1671.5 | 1674.75 | 1573.25 | 1692.5 | 1474.25 | 1494.25 | 1439 | 1128.25 | 1523 | 1518 | 1462.5
South | Peregrine House | 1026 | 1059.25 | 934.75 | 1020.97 | 952.8299999999999 | 1014.5 | 961.5 | 998.25 | 1045.25 | 1035.5 | 1054.5 | 1073.5 | 1024.25 | 1097.25 | 1037.75 | 1006.75 | 1016.75 | 1009.75 | 1083.75 | 1080.75 | 1086.5 | 1055.5 | 1074.5 | 1062.75 | 1027.25 | 1083.33 | 1043.75 | 1259.5 | 1149.5 | 1067.5 | 1100.5 | 1052 | 1066.53 | 1100.5 | 1091.25 | 1102.5
[NAME] | Queensway House | 1484.5 | 1443 | 1454.5 | 1269 | 1267.75 | 1448.35 | 1487.06 | 1463.77 | 1410.45 | 1453.75 | 1523.25 | 1518.75 | 1471.43 | 1553 | 1512.25 | 1545.75 | 1520.25 | 1592.5 | 1556.88 | 1512.75 | 1511.25 | 1544 | 1566.25 | 1512 | 1579.5 | 1543.5 | 1602.5 | 1679.75 | 1674.5 | 1580.75 | 1658.75 | 1612 | 1622.5 | 1577.8 | 1613.25 | 1644.5
Midlands | St Katharines House | 2013.65 | 1951 | 1810.23 | 1826.5 | 1878.25 | 1993.15 | 1957.5 | 1860.27 | 1917 | 1876 | 1937.69 | 1911.75 | 1849.75 | 1885.47 | 1752.53 | 1964.75 | 2021.25 | 1997 | 2102.75 | 2179 | 2100.75 | 2243.68 | 2236.92 | 2220.33 | 2147.5 | 2237.33 | 2238.75 | 2281.25 | 2169.5 | 2113.75 | 2082.75 | 2042.25 | 2074 | 2113.5 | 2021.5 | 2151.75
Midlands | St Stephens Care Home | 964 | 1027 | 918.25 | 834.02 | 941.25 | 985.62 | 866.0799999999999 | 884.5 | 922.5 | 925.75 | 1022.84 | 979.1700000000001 | 895.73 | 1022.68 | 1155.47 | 1069.5 | 1242.25 | 1099 | 1311 | 1024.4 | 1128.93 | 1097.25 | 1083.82 | 1058.94 | 965.07 | 1233 | 1174.88 | 1188.5 | 1197.13 | 1195.5 | 1196.53 | 1193.58 | 1201.83 | 1153 | 1152.5 | 1132.63
South | Sycamore Court |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1086.23 | 1373 | 1405.5 | 1586.75 | 1544 | 1614.92 | 1652.5 | 1796.75 | 1636.5 | 1591.75 | 1606.5 | 1567.33 | 1679.25 | 1599.25 | 1488.5 | 1639 | 1630.5 | 1322.5 | 1650.5 | 1634.5 | 1666.25
Midlands | The Tudors | 1131.25 | 1177.75 | 1140 | 1159.5 | 1169.75 | 1212 | 1132.5 | 1104 | 1162.5 | 1207.75 | 1150.75 | 1179.25 | 1230.25 | 1250.25 | 1212.25 | 1213.75 | 1207.5 | 1227.75 | 1091.25 | 1149 | 1124.5 | 1246 | 1240 | 1126.75 | 1191.1 | 1244.25 | 1221.25 | 1165 | 1184 | 1189.25 | 1163.75 | 1166.75 | 1218.65 | 1233.25 | 1227.75 | 1222.25
South | Willowmead | 1232.25 | 1301 | 1209.13 | 1298.75 | 1271.75 | 1170.99 | 1278.83 | 1287.04 | 1050.52 | 1309.13 | 1363.75 | 1246.75 | 1274 | 1238.78 | 1403 | 1405.75 | 1371.22 | 1345.5 | 1338.52 | 1384 | 1313.98 | 1494 | 1389.25 | 1374 | 1457.25 | 1527.5 | 1475.25 | 1553.5 | 1577.75 | 1581 | 1590.25 | 1623.5 | 1617 | 1471 | 1549.25 | 1635.5
 | Grand Total | 30270.4 | 30631.12 | 29886.49 | 30311.41 | 30564.5 | 31314.06 | 30099.56 | 30189.42 | 31299.18 | 32170.08 | 32277.08 | 32308.67 | 32276.97 | 32220.76 | 32792.56 | 38316.23 | 38734.45 | 40391.93 | 41229.09999999999 | 40589.64 | 41512.42000000001 | 41745.81 | 41786.77 | 41469.62 | 41045.87 | 42115.04 | 41331.32 | 46460.17 | 46316.7 | 39903.52 | 40317.8 | 40580.59
 | Worked Hours - Beachcroft | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Total AGENCY Worked Hours
Region | Home Name | 2021-11-21 00:00:00 | 2021-11-28 00:00:00 | 2021-12-05 00:00:00 | 2021-12-12 00:00:00 | 2021-12-19 00:00:00 | 2021-12-26 00:00:00 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | WE 27Mar22 | WE 03Apr22 | WE 10Apr22 | WE 17Apr22 | WE 24Apr22 | WE 01May22 | WE 08May22 | WE 15May22 | WE 22May22 | WE 29May22 | WE 05Jun22 | WE 12Jun22 | WE 19Jun22 | WE 26Jun22 | WE 03Jul22 | WE 10Jul22 | WE 17Jul22 | WE 24Jul22 | WE 31Jul22 | Weekly Movement
Central | Acton Care Centre | 99 | 88 | 198 | 286 | 206 | 191 | 181 | 226 | 207 | 219 | 268.25 | 239 | 225 | 412 | 375 | 363 | 345 | 266.5 | 197 | 133 | 237 | 180 | 218 | 227 | 225 | 205 | 180 | 170 | 205 | 183 | 149 | 161 | 160 | 116 | 140 | 107.5
Central | [NAME] | 22 | 43.75 | 22 | 74.5 | 77 | 77 | 66 | 121 | 22 | 27.5 | 176 | 99 | 121 | 76 | 82.5 | 126.75 | 225.5 | 170.5 | 92.25 | 87 | 88 | 76 | 82.5 | 176 | 140 | 115.5 | 129 | 169.75 | 169 | 141.75 | 155.5 | 132 | 93.25 | 98.75 | 107.25 | 38.5
Central | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 70 | 85.5 | 82.75 | 132.25 | 107.75 | 97.25 | 131.5 | 194.75 | 140.5 | 182.75 | 205.75 | 177 | 220.75 | 322.5 | 283.5 | 270.25 | 292.25 | 319.25 | 308.75
[NAME] | Autumn Vale Care Centre | 219.5 | 402.5 | 362 | 446.25 | 451.5 | 128 | 414.5 | 547 | 592.5 | 641 | 539.75 | 358.5 | 276.5 | 397.5 | 311 | 253 | 359 | 169.5 | 102.5 | 90 | 70.25 | 138.75 | 176 | 147 | 279 | 285 | 269.25 | 143 | 197 | 83 | 87 | 155 | 123.5 | 413.5 | 186.5 | 181.5
South | Baugh House | 255.75 | 373 | 101.5 | 111 | 242.5 | 313.5 | 133 | 197.5 | 270.75 | 267 | 211.75 | 148.5 | 260.75 | 499.75 | 447.25 | 498.75 | 506.25 | 485.5 | 583.25 | 509.5 | 556.25 | 472.03 | 392.75 | 541.75 | 468.5 | 324.5 | 422 | 502.75 | 227.75 | 306 | 321.5 | 275.5 | 399 | 237.75 | 387 | 330.33
Central | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 787 | 707.25 | 782 | 967.25 | 800.42 | 681.75 | 691.5 | 707 | 769.5 | 776 | 707.5 | 691 | 388.5 | 320 | 361.75 | 377.75 | 422 | 205.25 | 560.25 | 660.75 | 818.5
Midlands | Bletchley House | 346.5 | 601 | 467.5 | 539 | 539 | 634.5 | 484 | 506 | 506.75 | 702 | 758.25 | 829.5 | 670 | 973.5 | 981 | 856.5 | 846.75 | 730 | 547.75 | 555.5 | 598 | 659.75 | 583 | 451 | 464 | 569 | 504 | 367.5 | 417.25 | 396 | 209 | 220 | 66 | 226.5 | 226.5 | 236
Central | Brackenbridge House | 103 | 59 | 114 | 110.5 | 135.5 | 66.5 | 114 | 191 | 119.5 | 152.5 | 128 | 154 | 93.5 | 122 | 98 | 131 | 165 | 139 | 98 | 55 | 55 | 77 | 77 | 55 | 44 | 22 | 0 | 0 | 0 | 60.5 | 107 | 22 | 93.5 | 66 | 97.5 | 44
[NAME] | Broxbourne Nursing Home |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81 | 168.75 | 193.5 | 228.75 | 300.25 | 423.75
South | Burrows House | 192.5 | 88 | 88 | 201.5 | 134 | 187 | 116 | 271 | 435.5 | 254.5 | 403.5 | 257 | 287 | 342 | 384 | 363 | 350.25 | 336.5 | 314.25 | 285.5 | 320 | 226 | 236.5 | 264 | 182.5 | 209 | 176 | 232 | 231 | 214.5 | 254 | 274 | 262 | 238 | 315 | 277
Central | Drayton Village Care Centre | 210 | 497 | 538 | 756 | 511 | 639 | 547 | 932 | 779 | 723 | 725.75 | 603.5 | 663.25 | 767 | 802.5 | 740.5 | 704 | 635.5 | 427 | 472 | 516 | 491 | 437 | 529 | 604 | 519 | 416.25 | 485.25 | 551.75 | 649.5 | 485 | 550.5 | 659 | 565.5 | 493.58 | 468.5
[NAME] | Halcyon Days | 701 | 689 | 761.5 | 743 | 737.75 | 801 | 897 | 968.5 | 916.5 | 841 | 618.5 | 862 | 731.5 | 840 | 808.25 | 761 | 830.75 | 816.25 | 728.5 | 822.5 | 787 | 762 | 824 | 756.5 | 693.5 | 848.5 | 868.75 | 963.5 | 912.75 | 957 | 808.25 | 864.5 | 881.5 | 977 | 944.25 | 982.52
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | 225.5 | 350 | 408.5 | 382 | 274 | 306 | 318 | 480.5 | 1286.5 | 1354.5 | 1313.5 | 1253.25 | 1225 | 1184 | 1168 | 1450 | 1471.5 | 1308 | 1106.5 | 1135.5 | 1044 | 920.5 | 882 | 1092 | 937.5 | 877 | 215.5 | 197.5 | 217 | 154 | 132 | 110 | 110 | 191 | 111 | 121
South | Hillside Nursing Home | 55 | 22 | 22 | 88 | 95.5 | 22 | 44 | 32 | 11 | 11 | 33 | 33 | 33 | 71.5 | 44 | 29 | 22 | 22 | 18 | 18 | 14.5 | 44 | 44 | 44 | 33 | 22 | 51.5 | 32 | 44 | 22 | 32.75 | 33 | 20.5 | 16.5 | 33 | 22.5
Central | [NAME] | 0 | 54.5 | 106.25 | 65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Midlands | Lucton House | 110 | 137.5 | 159.5 | 110 | 209 | 165 | 264 | 242 | 194.5 | 308 | 330 | 286 | 326.5 | 392 | 396 | 242 | 244.5 | 198 | 68 | 46 | 94.5 | 55 | 77 | 88 | 55 | 55 | 19 | 43 | 49.5 | 11 | 39.25 | 40 | 43 | 66 | 84 | 114.5
Midlands | Manor House | 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
[NAME] | Martins House | 546 | 579 | 634.8299999999999 | 585.25 | 611.5 | 722 | 746 | 704 | 713.5 | 710 | 754 | 662 | 617.5 | 612 | 643 | 546 | 656.5 | 692.5 | 613 | 451.5 | 546.25 | 565 | 501.5 | 636.5 | 526.5 | 624.5 | 628.25 | 524.5 | 460 | 416.5 | 383 | 504.75 | 513 | 525.5 | 683 | 660
South | Partridge House |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 329.75 | 374.5 | 396.5 | 523.5 | 622.25 | 715.5 | 563.5 | 606.25 | 747.25 | 707 | 835.5 | 780.25 | 751.5 | 938.25 | 766.75 | 784.25 | 816 | 460 | 812 | 902.5 | 856.5
South | Peregrine House | 173.25 | 186.75 | 268.5 | 255.5 | 90.25 | 157.5 | 170.25 | 195.25 | 215 | 304.5 | 303.5 | 368.5 | 254.5 | 232.25 | 139.5 | 200.5 | 292.5 | 204.5 | 262.75 | 239.75 | 206 | 208.5 | 233.5 | 287.5 | 247.5 | 208.25 | 214 | 271.5 | 85.5 | 216.25 | 197.5 | 212 | 244.5 | 163.5 | 178.75 | 227.5
[NAME] | Queensway House | 590 | 536 | 563 | 435.5 | 270.75 | 543.5 | 508 | 497 | 446 | 758.25 | 601 | 525 | 473.5 | 548.5 | 611 | 652.5 | 715 | 580.5 | 444.25 | 438 | 436.75 | 527.5 | 542.25 | 559.5 | 615.5 | 470.5 | 620.5 | 694 | 757 | 617 | 505 | 545.5 | 541.75 | 540 | 511.5 | 675
Midlands | St Katharines House | 275 | 375 | 242 | 207 | 441 | 361.75 | 338.75 | 427.25 | 394 | 461 | 452 | 529 | 462 | 466.5 | 561 | 604.25 | 648 | 725 | 673 | 724 | 756.5 | 846.4300000000001 | 803.9200000000001 | 761.0799999999999 | 682 | 802.5 | 803 | 836.75 | 836 | 659 | 617.5 | 694.25 | 768 | 858 | 711.5 | 822
Midlands | St Stephens Care Home | 125 | 159.5 | 137.5 | 132 | 115.5 | 137.5 | 110 | 125 | 198.25 | 148.5 | 274.5 | 225 | 224.5 | 310 | 407 | 247.5 | 466.25 | 235 | 494 | 338.5 | 316 | 474 | 401.5 | 403.5 | 372.32 | 615.75 | 595.5 | 522.5 | 576 | 494.75 | 557.25 | 440.5 | 401.5 | 429 | 460.5 | 483.5
South | Sycamore Court |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 | 229.25 | 193 | 396.75 | 346.5 | 473.25 | 574.5 | 632 | 579 | 409.5 | 431.25 | 372.58 | 547.5 | 541.75 | 383.75 | 520.5 | 606.75 | 289.75 | 562.25 | 583.25 | 659
Midlands | The Tudors | 198 | 275 | 297 | 286 | 165 | 165 | 220 | 232 | 196 | 273 | 242 | 300 | 382 | 419.5 | 405 | 412 | 483 | 408 | 316 | 348 | 414.5 | 553 | 454 | 333 | 403 | 288.5 | 340 | 335 | 461 | 379 | 397 | 347 | 371 | 431 | 513 | 372
South | Willowmead | 339 | 418.75 | 340.88 | 340.5 | 365.5 | 428.74 | 494.38 | 453 | 514.02 | 524.75 | 697.75 | 492.75 | 578 | 560.53 | 491.25 | 559.5 | 632.72 | 606.25 | 546.77 | 544.75 | 526.48 | 681.25 | 645 | 647.25 | 731.75 | 692.5 | 605 | 585.5 | 638 | 569.75 | 472 | 625.5 | 715 | 625.5 | 715 | 752
 | Grand Total | 4786 | 5935.25 | 5832.46 | 6154.5 | 5672.25 | 6046.49 | 6165.88 | 7348 | 8018.27 | 8681 | 8831 | 8225.5 | 7905 | 9226.53 | 9155.25 | 10285.5 | 11275.47 | 10181.75 | 9605.77 | 9145.92 | 9585.73 | 9894.96 | 9653.92 | 10226.83 | 9791.82 | 9868.75 | 9084.08 | 8969.25 | 9012.5 | 8263.5 | 7995.5 | 8504
 | Minus [NAME]