Spreadsheet: 807105d1669742526-lookup-formulas-potential-assembly-dashboard-view-better
Sheet: Sheet1

WEEK NUMBER | 50
WEEK BEGINNING | 2022-12-12 00:00:00 |  |  |  |  | TEAM 1 - STATION 1 |  |  |  |  | TEAM 2 - STATION 2 |  |  |  |  | TEAM 3 - STATION 1
Part Number | Weekly Demand | Weekly Planned | Weekly Actuals |  |  | Part Number | Target Quantity | Actual Quantity |  |  | Part Number | Target Quantity | Actual Quantity |  |  | Part Number | Target Quantity | Actual Quantity
AMZ125-032AT2 |  |  |  |  | 2022-12-12 00:00:00 | AMZ125-032U2 | 50 |  |  | 2022-12-12 00:00:00 | AMZ655-032U2 | 50 |  |  | 2022-12-12 00:00:00 | AMZ755-032A3A | 50
AMZ125-032U2 | 200 | 200 | 200 |  | 2022-12-13 00:00:00 | AMZ125-032U2 | 50 |  |  | 2022-12-13 00:00:00 | AMZ755-032A3B | 50 |  |  | 2022-12-13 00:00:00 | AMZ755-032A3B | 50
AMZ135-032AT2 |  |  |  |  | 2022-12-14 00:00:00 | AMZ755-032A3B | 50 |  |  | 2022-12-14 00:00:00 | AMZ755-032U3 | 50 |  |  | 2022-12-14 00:00:00 | AMZ755-032U3 | 50
AMZ135-032U2 | 50 | 50 | 50 |  | 2022-12-15 00:00:00 | AMZ755-032U3 | 50 |  |  | 2022-12-15 00:00:00 | AMZ135-032U2 | 50 |  |  | 2022-12-15 00:00:00 | AMZ755-032U3 | 50
AMZ135-032U3 |  |  |  |  | 2022-12-16 00:00:00 |  |  |  |  | 2022-12-16 00:00:00 |  |  |  |  | 2022-12-16 00:00:00
AMZ645-032U2
AMZ655-032U2 | 100 | 100 | 100 |  |  | TEAM 1 - STATION 2 |  |  |  |  | TEAM 2 - STATION 2 |  |  |  |  | TEAM 3 - STATION 2
AMZ655-032U3
AMZ755-032A3A | 100 | 100 | 100 |  |  | Part Number | Target Quantity | Actual Quantity |  |  | Part Number | Target Quantity | Actual Quantity |  |  | Part Number | Target Quantity | Actual Quantity
AMZ755-032A3B | 300 | 300 | 300 |  | 2022-12-12 00:00:00 | AMZ125-032U2 | 50 |  |  | 2022-12-12 00:00:00 | AMZ655-032U2 | 50 |  |  | 2022-12-12 00:00:00 | AMZ755-032A3A | 50
AMZ755-032U2 |  |  |  |  | 2022-12-13 00:00:00 | AMZ125-032U2 | 50 |  |  | 2022-12-13 00:00:00 | AMZ755-032A3B | 50 |  |  | 2022-12-13 00:00:00 | AMZ755-032A3B | 50
AMZ755-032U3 | 300 | 300 | 300 |  | 2022-12-14 00:00:00 | AMZ755-032A3B | 50 |  |  | 2022-12-14 00:00:00 | AMZ755-032U3 | 50 |  |  | 2022-12-14 00:00:00 | AMZ755-032U3 | 50
TOTALS |  |  |  |  | 2022-12-15 00:00:00 |  |  |  |  | 2022-12-15 00:00:00 |  |  |  |  | 2022-12-15 00:00:00
 |  |  |  |  | 2022-12-16 00:00:00 |  |  |  |  | 2022-12-16 00:00:00 |  |  |  |  | 2022-12-16 00:00:00
 |  |  |  |  |  |  | TARGET QTY | ACTUAL QTY |  |  |  | TARGET QTY | ACTUAL QTY |  |  |  | TARGET QTY | ACTUAL QTY
 |  |  |  |  |  | TEAM 1 TOTALS |  |  |  |  | TEAM 2 TOTALS |  |  |  |  | TEAM 1 TOTALS
Team | Station | Date | Part No | Target | Actual
1 | 1 | 2022-12-12 00:00:00 | AMZ125-032U2 | 50
1 | 1 | 2022-12-13 00:00:00 | AMZ125-032U2 | 50
1 | 1 | 2022-12-14 00:00:00 | AMZ755-032A3B | 50
1 | 1 | 2022-12-15 00:00:00 | AMZ755-032U3 | 50
1 | 1 | 2022-12-16 00:00:00
1 | 2 | 2022-12-12 00:00:00 | AMZ125-032U2 | 50
1 | 2 | 2022-12-13 00:00:00 | AMZ125-032U2 | 50
1 | 2 | 2022-12-14 00:00:00 | AMZ755-032A3B | 50
2 | 1 | 2022-12-12 00:00:00 | AMZ655-032U2 | 50
2 | 1 | 2022-12-13 00:00:00 | AMZ755-032A3B | 50
2 | 1 | 2022-12-14 00:00:00 | AMZ755-032U3 | 50
2 | 1 | 2022-12-15 00:00:00 | AMZ135-032U2 | 50
2 | 2 | 44907 | AMZ655-032U2 | 50
2 | 2 | 44908 | AMZ755-032A3B | 50
2 | 2 | 44909 | AMZ755-032U3 | 50
3 | 1 | 2022-12-12 00:00:00 | AMZ755-032A3A | 50
3 | 1 | 2022-12-13 00:00:00 | AMZ755-032A3B | 50
3 | 1 | 2022-12-14 00:00:00 | AMZ755-032U3 | 50
3 | 1 | 2022-12-15 00:00:00 | AMZ755-032U3 | 50
3 | 2 | 2022-12-12 00:00:00 | AMZ755-032A3A | 50
3 | 2 | 2022-12-13 00:00:00 | AMZ755-032A3B | 50
3 | 2 | 2022-12-14 00:00:00 | AMZ755-032U3 | 50