Spreadsheet: 743093d1628207085-weekly-summary-of-values-changed-between-same-day-divided-into-zones-ongoing-weekly-task-summary-revised03-ans1-1
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 | Barcode # | Names | Client | Box # | Completion | Time | Zone | Tasks |  |  | Example of "IF ANY BARCODE # (AB) has 2 mentions (or more ) on the same date (AG) THEN calculate difference in value of Completion (AF) for that BARCODE # and insert result into the correct ZONE (AH), TASK (AI) and DATE (AG) in the weekly schedule table": |  |  |  |  |  |  |  |  |  |  | Week # | 2021-06-24 00:00:00
distributed among the respective zones that has done the tasks. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1517 | [NAME] |  | LCC | 95 | 0 | 2021-06-21 09:53:45 | Zone C | SC |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | FM | SC | LP | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1516 | LCC46 |  | LCC | 46 | 0 | 2021-06-21 10:52:34 | Zone C | QC |  |  | (Column AB) Barcode # | (Column AF) Completion | (Column AG) Date | (Column AH) Zone | (Column AI) Tasks |  |  |  |  |  |  | Zone A
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. In order to retrieve accurate amount completed per day I would have to retrieve the difference between the percentages completed (Completion column) on each barcode that has two entries (or more) per day. Then add amounts together and display in the summary table. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1586 | LCC108 |  | LCC | 108 | 25 | 2021-06-21 10:52:34 | Zone D | FM |  |  | ABC04 | 25 | 2021-06-24 08:52:34 | Zone C | QC |  |  |  |  |  |  | Zone B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1308 | ACMED05 |  | ACME | 5 | 0 | 2021-06-21 10:52:34 | Zone E | QC |  |  | ABC04 | 0 | 2021-06-24 09:03:16 | Zone C | QC |  |  |  |  |  |  | Zone C |  | 1.25 | 0.25 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1527 | [NAME] |  | LCC | 95 | 100 | 2021-06-21 11:50:47 | Zone C | SC |  |  | CBA01 | 75 | 2021-06-24 09:03:16 | Zone C | SC |  |  |  |  |  |  | Zone D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1604 | ACMED14 |  | ACME | 14 | 50 | 2021-06-21 11:53:45 | Zone D | SC |  |  | ABC03 | 100 | 2021-06-24 09:03:16 | Zone C | SC |  |  |  |  |  |  | Zone E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1620 | ACMED14 |  | ACME | 14 | 100 | 2021-06-21 11:59:47 | Zone D | SC |  |  | ABC02 | 25 | 2021-06-24 09:16:55 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1530 | LCC46 |  | LCC | 46 | 25 | 2021-06-21 12:01:41 | Zone C | QC |  |  | CBA01 | 0 | 2021-06-24 09:16:55 | Zone C | SC
 | IF ANY BARCODE # (AB) has 2 mentions (or more ) on the same date (AG) THEN calculate difference in value of Completion (AF) for that BARCODE # and insert result into the correct ZONE (AH), TASK (AI) and DATE (AG) in the weekly schedule table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1638 | LCC108 |  | LCC | 108 | 75 | 2021-06-21 12:01:41 | Zone D | FM |  |  | ABC03 | 50 | 2021-06-24 09:16:55 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1379 | CCA001 |  | CCA | 1 | 25 | 2021-06-21 12:01:41 | Zone E | FM |  |  | ABC04 | 100 | 2021-06-24 10:52:34 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1534 | [NAME] |  | LCC | 95 | 0 | 2021-06-21 12:55:50 | Zone C | LP |  |  | ABC04 | 75 | 2021-06-24 14:08:47 | Zone C | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1645 | LCC130 |  | LCC | 130 | 25 | 2021-06-21 12:55:50 | Zone D | QC |  |  | ABC07 | 50 | 2021-06-24 09:16:55 | Zone C | SC
 | If | Barcode # | x 2 | = | DATE | THEN | ∆ Completion | of | Barcode # | Þ | Weekly table | DATE | Zone | Task |  |  |  |  |  |  |  |  |  |  |  | 1554 | [NAME] |  | LCC | 95 | 50 | 2021-06-21 14:25:23 | Zone C | LP |  |  | Note that ABC04 comes twice in one day but with different tasks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1646 | LCC130 |  | LCC | 130 | 75 | 2021-06-21 14:25:23 | Zone D | QC
 | IF Barcode # does not appear x2 on one date, do not count that row. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1427 | CCA001 |  | CCA | 1 | 100 | 2021-06-21 14:25:23 | Zone E | FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1356 | ACMED05 |  | ACME | 5 | 50 | 2021-06-21 09:53:45 | Zone E | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1588 | LCC89 |  | LCC | 89 | 50 | 2021-06-22 12:49:39 | Zone C | SC
 | 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 |  |  |  |  |  |  |  | 1647 | ACMED17 |  | ACME | 17 | 0 | 2021-06-22 12:49:39 | Zone D | LP
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC |  |  |  |  | 1456 | CCA014 |  | CCA | 14 | 75 | 2021-06-22 12:49:39 | Zone E | QC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1590 | LCC89 |  | LCC | 89 | 100 | 2021-06-22 12:55:45 | Zone C | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1660 | ACMES01 |  | ACME | 1 | 100 | 2021-06-22 12:55:45 | Zone D | LP
 | Zone C |  |  |  |  |  | 1 | 0.5 | 0.25 |  | 0.5 | 1 |  | 0.5 |  |  | 0.75 |  | 1 | 1 |  |  |  |  |  | 1487 | CCA014 |  | CCA | 14 | 100 | 2021-06-22 12:55:45 | Zone E | QC
 | Zone D |  |  |  |  | 0.5 |  | 0.25 | 0.5 |  |  | 2 |  |  | 0.75 | 0.25 |  | 0.5 | 0.5 |  | 1 |  |  |  |  | 1600 | LCC124 |  | LCC | 124 | 0 | 2021-06-22 14:29:48 | Zone C | LP
 | Zone E |  |  |  |  | 0.75 |  |  | 0.5 |  |  |  | 0.25 |  | 1 | 0.75 |  |  | 1.5 |  |  |  |  |  |  | 1667 | ACMED17 |  | ACME | 17 | 0 | 2021-06-22 14:29:48 | Zone D | LP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1610 | LCC124 |  | LCC | 124 | 100 | 2021-06-22 16:25:39 | Zone C | LP
 | Legend: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1679 | ACMES01 |  | ACME | 1 | 100 | 2021-06-22 16:25:39 | Zone D | LP
 | FM = File Management (removal of staples etc from documents) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1519 | LCC87 |  | LCC | 87 | 0 | 2021-06-23 09:30:31 | Zone E | SC
 | SC = Scanning (Scan all A4 and A3 documents to pdf) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1662 | LCC135 |  | LCC | 135 | 25 | 2021-06-23 09:46:20 | Zone C | QC
 | LP = Large Plan (Scan all paper > A3 to pdf) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1689 | ACMED03 |  | ACME | 3 | 50 | 2021-06-23 09:46:20 | Zone D | LP
 | QC = Quality Control (check all pdf documents against physical documents) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | Header: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1686 | ACMED09 |  | ACME | 9 | 25 | 2021-06-23 14:30:31 | Zone D | SC
 | Entry = Database assigned a number per entry scanned |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1664 | LCC135 |  | LCC | 135 | 100 | 2021-06-23 15:26:50 | Zone C | QC
 | Barcode # = the unique name each box of documents have that is used as the identifier when barcode scanning into this document. . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1695 | ACMED09 |  | ACME | 9 | 75 | 2021-06-23 15:26:50 | Zone D | LP
 | Names = Taken away for this purpose |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1688 | LCC134 |  | LCC | 134 | 100 | 2021-06-23 16:01:25 | Zone C | FM
 | Client = the original owner of the documents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1665 | LCC134 |  | LCC | 134 | 50 | 2021-06-23 16:01:25 | Zone C | FM
 | Box # [NAME] identifies and displays to users which box it is. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1696 | ACMED03 |  | ACME | 3 | 100 | 2021-06-23 16:01:25 | Zone D | SC
 | 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%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1550 | CCA009 |  | CCA | 9 | 100 | 2021-06-23 16:01:25 | Zone E | LP
 | Time = date and time registered when barcode is scanned on a box. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1540 | LCC87 |  | LCC | 87 | 100 | 2021-06-23 21:46:20 | Zone E | SC
 | Zone = several zones work on different contracts but needs to record amount of work done each day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1747 | ACMED16 |  | ACME | 16 | 25 | 2021-06-24 08:52:34 | Zone D | FM
 | Tasks = Autopopulated - show which task has been worked on that specific time of barcode scanned. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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