Spreadsheet: 742825d1628073130-weekly-summary-of-values-changed-between-same-day-divided-into-zones-weekly-summary-of-values-changed-between-same-day-divided-into-zones
Sheet: Sheet2

This is extracted from a 6 month database, and the intention is to summarise the "Tasks" into numbers in a weekly table, |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Entry | Entry2 | Names | Client | Box # | Completion | Time | Zone | Tasks | Date | Week |  | Week | 52
distributed among the respective zones that has done the tasks. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1517 | [NAME] |  | LCC | 95 | 0 | 2021-06-21 09:53:45 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1516 | LCC46 |  | LCC | 46 | 0 | 2021-06-21 10:52:34 | Zone C | QC |  |  |  | Status | Date | Tasks
I'd wish to create a automated weekly table as below, but in a separate sheet, where work performed for each task of the day is  summarised per zone. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1586 | LCC108 |  | LCC | 108 | 25 | 2021-06-21 10:52:34 | Zone D | FM |  |  |  |  | 2021-06-21 00:00:00 |  |  |  | 2021-06-22 00:00:00 |  |  |  | 2021-06-23 00:00:00 |  |  |  | 2021-06-24 00:00:00
Ideally a new table is generated above it for the next week and the previous weeks table are still available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1308 | ACMED05 |  | ACME | 5 | 0 | 2021-06-21 10:52:34 | Zone E | QC |  |  |  | Zone | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC
 | Week # | 2021-06-20 00:00:00 |  |  |  | 2021-06-21 00:00:00 |  |  |  | 2021-06-22 00:00:00 |  |  |  | 2021-06-23 00:00:00 |  |  |  | 2021-06-24 00:00:00 |  |  |  |  |  |  |  | 1527 | [NAME] |  | LCC | 95 | 100 | 2021-06-21 11:50:47 | Zone C | SC |  |  |  | Zone A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC |  |  |  |  | 1604 | ACMED14 |  | ACME | 14 | 50 | 2021-06-21 11:53:45 | Zone D | SC |  |  |  | Zone B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1620 | ACMED14 |  | ACME | 14 | 100 | 2021-06-21 11:59:47 | Zone D | SC |  |  |  | Zone C | 0 | 1 | 0.5 | 0.25 | 0 | 1.5 | 1 | 0 | 1.5 | 0 | 1 | 1.25 | 0 | 1.5 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1530 | LCC46 |  | LCC | 46 | 25 | 2021-06-21 12:01:41 | Zone C | QC |  |  |  | Zone D | 1 | 1.5 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 1.25 | 1.25 | 0 | 1 | 1.5 | 0 | 1
 | Zone C |  |  |  |  |  | 1 | 0.5 | 0.25 |  | 0.5 | 1 |  | 0.5 |  |  | 0.75 |  | 1 | 1 |  |  |  |  |  | 1638 | LCC108 |  | LCC | 108 | 75 | 2021-06-21 12:01:41 | Zone D | FM |  |  |  | Zone E | 1.25 | 0 | 0 | 0.5 | 0 | 0 | 0 | 1.75 | 0 | 1 | 1.25 | 0 | 0 | 4 | 0 | 0
 | Zone D |  |  |  |  | 0.5 |  | 0.25 | 0.5 |  |  | 2 |  |  | 0.75 | 0.25 |  | 0.5 | 0.5 |  | 1 |  |  |  |  | 1379 | CCA001 |  | CCA | 1 | 25 | 2021-06-21 12:01:41 | Zone E | FM
 | Zone E |  |  |  |  | 0.75 |  |  | 0.5 |  |  |  | 0.25 |  | 1 | 0.75 |  |  | 1.5 |  |  |  |  |  |  | 1534 | [NAME] |  | LCC | 95 | 0 | 2021-06-21 12:55:50 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1645 | LCC130 |  | LCC | 130 | 25 | 2021-06-21 12:55:50 | Zone D | QC |  |  |  | [NAME]
 | Legend: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1554 | [NAME] |  | LCC | 95 | 50 | 2021-06-21 14:25:23 | Zone C | LP
 | FM = File Management (removal of staples etc from documents) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1646 | LCC130 |  | LCC | 130 | 75 | 2021-06-21 14:25:23 | Zone D | QC
 | SC = Scanning (Scan all A4 and A3 documents to pdf) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1427 | CCA001 |  | CCA | 1 | 100 | 2021-06-21 14:25:23 | Zone E | FM
 | LP = Large Plan (Scan all paper > A3 to pdf) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1356 | ACMED05 |  | ACME | 5 | 50 | 2021-06-21 09:53:45 | Zone E | QC
 | QC = Quality Control (check all pdf documents against physical documents) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1588 | LCC89 |  | LCC | 89 | 50 | 2021-06-22 12:49:39 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1647 | ACMED17 |  | ACME | 17 | 0 | 2021-06-22 12:49:39 | Zone D | LP
 | Header: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1456 | CCA014 |  | CCA | 14 | 75 | 2021-06-22 12:49:39 | Zone E | QC
 | Entry = Database assigned a number per entry scanned |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1590 | LCC89 |  | LCC | 89 | 100 | 2021-06-22 12:55:45 | Zone C | SC
 | Barcode # = the unique name each box of documents have that is used as the identifier when barcode scanning into this document. . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1660 | ACMES01 |  | ACME | 1 | 100 | 2021-06-22 12:55:45 | Zone D | LP
 | Names = Taken away for this purpose |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1487 | CCA014 |  | CCA | 14 | 100 | 2021-06-22 12:55:45 | Zone E | QC
 | Client = the original owner of the documents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600 | LCC124 |  | LCC | 124 | 0 | 2021-06-22 14:29:48 | Zone C | LP
 | Box # [NAME] identifies and displays to users which box it is. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1667 | ACMED17 |  | ACME | 17 | 0 | 2021-06-22 14:29:48 | Zone D | LP
 | Completion = manual input register to say how much of a box is done at the start/end of the day (0%, 25%, 50%, 75%, 100%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1610 | LCC124 |  | LCC | 124 | 100 | 2021-06-22 16:25:39 | Zone C | LP
 | Time = date and time registered when barcode is scanned on a box. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1679 | ACMES01 |  | ACME | 1 | 100 | 2021-06-22 16:25:39 | Zone D | LP
 | Zone = several zones work on different contracts but needs to record amount of work done each day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1519 | LCC87 |  | LCC | 87 | 0 | 2021-06-23 09:30:31 | Zone E | SC
 | Tasks = Autopopulated - show which task has been worked on that specific time of barcode scanned. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1662 | LCC135 |  | LCC | 135 | 25 | 2021-06-23 09:46:20 | Zone C | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1689 | ACMED03 |  | ACME | 3 | 50 | 2021-06-23 09:46:20 | Zone D | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1549 | CCA009 |  | CCA | 9 | 25 | 2021-06-23 14:01:25 | Zone E | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1656 | LCC79 |  | LCC | 79 | 100 | 2021-06-23 14:30:31 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1686 | ACMED09 |  | ACME | 9 | 25 | 2021-06-23 14:30:31 | Zone D | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1664 | LCC135 |  | LCC | 135 | 100 | 2021-06-23 15:26:50 | Zone C | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1695 | ACMED09 |  | ACME | 9 | 75 | 2021-06-23 15:26:50 | Zone D | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1688 | LCC134 |  | LCC | 134 | 100 | 2021-06-23 16:01:25 | Zone C | FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1665 | LCC134 |  | LCC | 134 | 50 | 2021-06-23 16:01:25 | Zone C | FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1696 | ACMED03 |  | ACME | 3 | 100 | 2021-06-23 16:01:25 | Zone D | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1550 | CCA009 |  | CCA | 9 | 100 | 2021-06-23 16:01:25 | Zone E | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1540 | LCC87 |  | LCC | 87 | 100 | 2021-06-23 21:46:20 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1747 | ACMED16 |  | ACME | 16 | 25 | 2021-06-24 08:52:34 | Zone D | FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1691 | ACMED23 |  | ACME | 93 | 0 | 2021-06-24 09:03:16 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1728 | ACMES14 |  | ACME | 2 | 0 | 2021-06-24 09:03:16 | Zone D | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1603 | LCC103 |  | LCC | 103 | 50 | 2021-06-24 09:03:16 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1712 | LCC112 |  | LCC | 112 | 0 | 2021-06-24 09:16:55 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1750 | ACMED16 |  | ACME | 16 | 75 | 2021-06-24 09:16:55 | Zone D | FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1704 | LCC150 |  | LCC | 150 | 75 | 2021-06-24 09:16:55 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1143 | ACMED23 |  | ACME | 23 | 75 | 2021-06-24 09:57:26 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1731 | ACMES14 |  | ACME | 2 | 100 | 2021-06-24 09:57:26 | Zone D | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1624 | LCC103 |  | LCC | 103 | 75 | 2021-06-24 09:57:26 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700 | LCC111 |  | LCC | 111 | 25 | 2021-06-24 10:52:34 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1655 | LCC114 |  | LCC | 114 | 0 | 2021-06-24 10:52:34 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1711 | LCC111 |  | LCC | 111 | 50 | 2021-06-24 14:08:47 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1749 | ACMED18 |  | ACME | 18 | 50 | 2021-06-24 14:08:47 | Zone D | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1663 | LCC114 |  | LCC | 114 | 100 | 2021-06-24 14:08:47 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1714 | LCC112 |  | LCC | 112 | 100 | 2021-06-24 14:30:43 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1751 | ACMED18 |  | ACME | 18 | 100 | 2021-06-24 14:30:43 | Zone D | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1734 | LCC150 |  | LCC | 150 | 100 | 2021-06-24 14:30:43 | Zone E | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-24 14:30:43 | Zone A | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-24 14:30:43 | Zone B | SC