Spreadsheet: 775888d1649362455-using-a-location-reference-combine-information-from-two-tabs-into-a-consolidated-list-test-worksheet
Sheet: Data

Location | Mon | Thurs | Total | Tuesday | Friday | Total 2 | Grand Total | percent
0015 | 12 |  |  | 4 | 4
0020 |  |  |  | 1 | 2
0031 | 3 | 4 |  | 1
0034 | 3 | 3 |  | 1 | 1
0038 |  | 2 |  | 4 | 2
0049 |  |  |  | 4 | 4
0057 | 1 | 1 |  | 3 | 3
0063 | 1 |  |  | 3 | 4
0077 | 3 | 4 |  | 1
0088 | 4 | 3 |  |  | 1
0094 | 1 | 2 |  | 3 | 2
0107 |  |  |  | 4 | 4
0113 | 4 | 4
0114 | 3 | 4 |  | 1
0117 |  |  |  | 4 | 4
0128 | 1 |  |  | 3 | 4
0138 | 1 | 1 |  | 3 | 3
0139 | 1 | 1 |  | 3 | 3
0140 | 3 | 4
0145 | 4 | 4
0149 | 4 | 4
0151 |  |  |  | 4 | 4
0167 | 4 | 3 |  |  | 1
0168 |  |  |  | 4 | 4
0179 | 4 | 4
0186 |  |  |  | 4 | 4
0198 | 4 | 4
0204 |  |  |  | 2 | 3
0220 | 3 |  |  | 1 | 4
0225 | 4 | 4
0226 |  |  |  | 4 | 4
0230 | 4 | 4
0234 | 4 | 3 |  |  | 1
0237 | 4 | 4
0243 | 4 | 4
0244 | 2 | 2 |  | 2 | 2
0249 | 4 | 4
0251 |  |  |  | 2 | 2
0255 | 4 | 4
0276 |  | 1 |  | 4 | 3
0281 | 3 | 4 |  | 1
0285 | 4 |  |  |  | 4
0287 |  |  |  | 4 | 4
0292 |  |  |  | 4 | 4
0293 |  | 1 |  | 4 | 3
0312 |  |  |  | 4 | 4
0314 | 2 | 2 |  | 2 | 2
0315 | 2 | 3 |  | 2 | 1
0316 | 4 | 4
0319 | 1 | 1 |  | 3 | 3
0331 | 3 | 2 |  | 1 | 2
0337 | 2 | 2 |  |  | 1
0347 | 2 | 2 |  | 1 | 2
0352 | 2 | 1 |  | 2 | 3
0353 |  |  |  | 4 | 4
0368 | 3 | 2 |  | 1 | 2
0369 | 4 | 3 |  |  | 1
0372 |  |  |  | 4 | 4
0374 | 2 | 2 |  | 2 | 2
0381 |  |  |  | 4 | 4
0385 | 3 | 2 |  | 1 | 2
0387 | 4 | 4
0397 | 2 | 2 |  | 2 | 2
0408 | 4 |  |  |  | 4
0409 | 4 |  |  |  | 4
0411 | 1 | 1 |  | 3 | 3
0418 | 2 | 4 |  | 2
0426 | 4 | 2 |  |  | 2
0431 |  | 1 |  | 4 | 3
0437 | 4 | 4
0441 |  |  |  | 4 | 4
0447 |  |  |  | 4 | 4
0450 | 2 | 2 |  | 2 | 2
0455 | 4 | 4
0466 |  |  |  | 4 | 4
0467 | 2 | 1 |  | 2 | 3
0468 | 1 | 1 |  | 3 | 3
0473 |  |  |  | 4 | 4
0488 |  |  |  | 2 | 2
0491 | 3 | 4 |  | 1
0497 | 4 | 4
0570 | 4 | 4
0685 | 2 | 1 |  |  | 1
1002 | 1 |  |  | 3 | 4
1006 | 3 | 4 |  | 1
1008 | 4 | 4
1012 | 3 | 2 |  | 1 | 2
1018 | 1 |  |  |  | 1
1019 | 4 | 4
1021 | 3 | 3 |  | 1 | 1
1025 | 4 | 3 |  |  | 1
1027 | 4 | 3 |  |  | 1
1037 | 4 | 4
1040 | 4 | 3 |  |  | 1
1049 | 2 | 3 |  | 2 | 1
1051 | 2 | 2 |  | 2 | 2
1053 | 3 | 4 |  | 1
1056 | 1 |  |  | 3 | 4
1064 | 4 | 4
1067 |  |  |  | 4 | 4
1077 |  |  |  | 4 | 4
1096 | 4 | 4
1098 | 4 | 3 |  |  | 1
1105 | 3 |  |  | 1 | 4
1107 | 4 | 3 |  |  | 1
1110 | 2 | 1 |  | 2 | 3
1115 | 2 | 2 |  | 2 | 2
1125 | 4 | 4
1131 | 4 | 4
1134 |  |  |  | 4 | 4
1137 |  |  |  | 4 | 4
1142 | 1 |  |  | 3 | 4
1149 | 4 | 4
1164 |  | 2 |  | 4 | 2
1167 | 4 | 1 |  |  | 3
1168 | 2 | 4 |  | 2
1174 | 4 | 4
1177 | 3 | 4 |  | 1
1179 |  |  |  | 2 | 1
1180 | 3 | 3 |  | 1 | 1
1181 | 3 | 4 |  | 1
1191 | 2 | 1 |  | 2 | 3
1203 | 4 |  |  |  | 4
1204 | 4 | 4
1207 |  |  |  | 4 | 4
1211 | 2 | 1 |  | 2 | 3
1215 |  | 3 |  | 4 | 1
1219 | 4 | 4
1233 | 4 | 4
1236 |  |  |  | 4 | 4
1239 | 4 | 4
1240 |  |  |  | 4 | 4
1251 | 3 |  |  | 1 | 4
1254 | 1 | 2 |  | 3 | 2
1256 | 4 | 4
1262 | 3 | 3 |  | 1 | 1
1265 | 2 | 2 |  | 2 | 2
1267 | 1 |  |  | 3 | 4
1268 |  | 2 |  | 4 | 2
1271 | 3 | 1 |  | 1 | 3
1276 |  |  |  | 4 | 4
1277 | 4 | 3
1292 |  | 2 |  | 4 | 2
1299 | 3 | 3 |  | 1 | 1
1304 | 3 | 2 |  | 1 | 2
1307 | 2 | 2 |  | 2 | 2
1313 | 2 | 3 |  | 2 | 1
1314 |  |  |  | 4 | 4
1318 | 4 | 4
1319 | 4 | 4
1320 | 1 | 1 |  | 2 | 2
1324 |  | 1 |  | 4 | 3
1329 | 4 | 1 |  |  | 3
1333 | 1 | 4 |  | 3
1334 | 3 | 3 |  | 1 | 1
1345 | 4 | 4
1354 | 4 | 4
1357 | 4 | 4
1358 | 4 | 2 |  |  | 2
1361 | 2 | 4 |  | 2
1379 |  |  |  | 4 | 4
1411 | 2 | 2 |  | 2 | 2
1416 | 4 | 4
1422 | 4 | 4
1426 | 4 | 3 |  |  | 1
1431 | 4 | 4
1434 |  |  |  | 3 | 4
1441 | 1 | 1 |  | 3 | 3
1446 | 4 | 1 |  |  | 3
1451 | 1 | 1 |  | 3 | 3
1455 |  |  |  | 4 | 4
1461 | 1 | 1
1462 | 1 |  |  | 3 | 4
1466 | 4 | 4
1467 | 3 | 2 |  | 1 | 2
1489 | 2 | 1 |  | 2 | 3
1492 | 4 | 1 |  |  | 3
1500 | 2 |  |  | 2 | 4
1502 | 4 | 3 |  |  | 1
1516 |  |  |  | 4 | 4
1518 | 1 | 1 |  | 3 | 3
1521 |  |  |  | 4 | 4
1525 | 4 | 3 |  |  | 1
1529 | 4 | 4
1531 |  |  |  | 4 | 3
1535 | 4 | 4
1536 |  |  |  | 4 | 4
1558 |  | 2 |  | 4 | 2
1564 | 2 | 2 |  | 2 | 2
1572 | 3 | 4 |  | 1
1575 | 4 | 2 |  |  | 2
1581 | 2 | 4 |  | 2
1584 |  | 1 |  | 4 | 3
1585 |  |  |  | 4 | 4
1592 | 4 | 4
1593 |  |  |  | 4 | 4
1602 |  |  |  | 2 | 3
1609 | 4 | 4
1614 | 4 | 4
1617 |  |  |  | 4 | 4
1629 | 2 | 3
1633 | 4 | 3 |  |  | 1
1634 | 3 | 3 |  | 1 | 1
1636 |  |  |  | 4 | 4
1637 |  |  |  | 4 | 3
1639 |  | 1 |  | 3 | 3
1646 | 3 | 2 |  | 1 | 2
1648 | 2 | 4 |  | 2
1656 | 3 | 2 |  | 1 | 2
1659 | 1 | 1 |  | 3 | 3
1663 | 4 | 4
1665 | 1 | 1 |  | 3 | 3
1667 |  |  |  | 4 | 4
1668 | 3 | 1 |  | 1 | 3
1669 |  | 1 |  | 4 | 3
1670 | 4 | 4
1672 | 4 | 4
1674 | 3 | 4
1682 | 4 | 1 |  |  | 3
1684 |  |  |  | 4 | 4
1689 | 4 | 3 |  |  | 1
1691 |  |  |  | 4 | 4
1692 | 4 | 3 |  |  | 1
1693 | 2 | 2 |  | 2 | 2
1701 | 3 |  |  | 1 | 4
1703 |  |  |  | 3 | 3
1706 |  | 1 |  | 4 | 3
1710 | 3 | 3 |  | 1 | 1
1717 | 3 | 1 |  | 1 | 3
1725 |  |  |  | 4 | 4
1734 | 4 | 2 |  |  | 2
1735 | 3 | 4 |  | 1
1739
1740 |  | 1 |  | 2 | 1
1742 | 1 |  |  | 3 | 4
1745 |  |  |  | 4 | 4
1747 | 3 | 4 |  | 1
1749 |  |  |  | 4 | 4
1751 | 4 | 3 |  |  | 1
1754 | 1 |  |  | 3 | 4
1758 | 4 | 3 |  |  | 1
1759 | 1 |  |  | 3 | 4
1768 | 1 | 3 |  | 3 | 1
1775 | 4 | 4
1778 |  |  |  | 4 | 4
1782 | 1 |  |  | 3 | 4
1784 | 3 | 2 |  | 1 | 2
1789 |  | 1 |  | 4 | 3
1791 | 4 | 4
1792 |  |  |  | 4 | 4
1797 | 4 | 4
1804 | 2 | 3
1812 | 4 | 4
1822 | 1 |  |  | 3 | 4
1826 |  |  |  | 4 | 4
1830 | 1 | 3 |  | 2 | 1
1835 | 4 |  |  |  | 4
1836 | 2 |  |  |  | 1
1837 | 3 | 3
1838 | 4 | 3 |  |  | 1
1839 | 4 | 4
1840 | 4 | 3 |  |  | 1
1848 |  |  |  | 4 | 4
1854 |  |  |  | 4 | 4
1864 |  |  |  | 4 | 4
1867 | 3 | 4 |  | 1
1869 | 4 | 4
1870 |  |  |  | 4 | 4
1872 | 4 | 3 |  |  | 1
1873 | 1 | 1 |  | 3 | 3
1874 | 3 |  |  | 1 | 3
1877 | 2 | 3 |  | 2 | 1
1882 | 4 | 3 |  |  | 1
1884 | 4 | 3 |  |  | 1
1886 |  |  |  | 4 | 4
1888 |  |  |  | 4 | 4
1893 |  |  |  | 4 | 4
1900 | 3 |  |  | 1 | 4
1912 |  |  |  | 4 | 4
1914 | 4 | 4
1917 | 1 |  |  | 3 | 4
1923 |  |  |  | 4 | 4
1927 |  |  |  |  | 1
1929 | 3 | 3 |  | 1 | 1
1934 |  |  |  | 3 | 4
1935 | 4 | 3 |  |  | 1
1946 | 3 | 3 |  |  | 1
1952 | 4 | 3 |  |  | 1
1962 | 2 |  |  |  | 2
1965 |  |  |  | 4 | 4
1966 | 4 | 2 |  |  | 1
1971 | 1 | 4 |  | 3
1973 | 1 |  |  | 3 | 4
1974 |  | 4 |  | 4
1975 | 4 | 3 |  |  | 1
1976 | 1 |  |  | 3 | 4
1978 | 4 | 2 |  |  | 2
1982 | 3 |  |  | 1 | 4
1984 | 1 | 3 |  | 3 | 1
1985 |  |  |  | 4 | 4
1988 | 2 | 2 |  | 2 | 2
1992 | 3 | 2 |  | 1 | 2
1993 | 4 | 4
1997 | 3 | 4 |  | 1
2002 | 3 | 3 |  | 1 | 1
2009 | 4 | 4
2012 |  |  |  | 4 | 4
2013 | 3 | 4 |  | 1
2017 |  |  |  | 2 | 2
2018 |  |  |  | 1 | 2
2022 |  |  |  |  | 1
2027 | 4 | 4
2030 | 1 | 1
4035 | 4 | 1 |  |  | 3
4037 | 2 | 1 |  | 2 | 3