Spreadsheet: 685739d1594163835-cell-formts-in-a-pivot-table-kitting-tracking-r2
Sheet: Data Entry

Finishing Reporting Data Sheet
 |  |  |  | SUPERVISOR INFORMATION |  |  |  | TEMP INFORMATION
Date | Customer | Job No. | Operation | [NAME] | Sup. Start Time | Sup. End Time | SUPERVISOR TOTAL HRS. | Temp Start Time | Temp End Time | Temp Hours | Number of Temps | TOTAL TEMP HOURS | TOTAL HRS. | Qty. Produced | Qty. Good | Qty. Bad | 1st Pass Yield
2020-06-05 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 05:00:00 | 10:00:00 |  | 05:00:00 | 10:00:00 |  | 4 |  |  | 5000 | 4995
2020-06-06 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 06:00:00 | 15:00:00 |  | 05:00:00 | 10:00:00 |  | 6.5 |  |  | 3000 | 2999
2020-06-07 00:00:00 | Smith Co | 123456 | Apply Labels | Evie |  |  |  | 07:00:00 | 10:00:00 |  | 4 |  |  | 3000 | 2950
2020-06-05 00:00:00 | Bobs Co | 456789 | Build Carton | [NAME] | 06:00:00 | 13:30:00 |  | 13:00:00 | 14:00:00 |  | 1 |  |  | 2500 | 2500
2020-06-06 00:00:00 | Bobs Co | 456789 | Build Kits | [NAME] | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00 |  | 6.5 |  |  | 2400 | 2400
2020-06-10 00:00:00 | [NAME] | 987654 | Count Stacks | Evie | 06:00:00 | 16:00:00 |  | 06:00:00 | 16:00:00 |  | 5 |  |  | 3000 | 3000
2020-06-11 00:00:00 | [NAME] | 987654 | Tape Application | Evie | 13:00:00 | 17:00:00 |  | 13:00:00 | 17:00:00 |  | 8 |  |  | 10000 | 7500
2020-06-12 00:00:00 | [NAME] | 987654 | Tape Application | [NAME] | 06:00:00 | 15:00:00 |  | 06:00:00 | 15:00:00 |  | 8.5 |  |  | 5000 | 4500
2020-06-13 00:00:00 | [NAME] | 987654 | Tape Application | [NAME] | 06:00:00 | 14:45:00 |  | 06:00:00 | 14:45:00 |  | 7.5 |  |  | 6000 | 5600
2020-06-14 00:00:00 | [NAME] | 987654 | Tape Application | Evie | 06:00:00 | 16:00:00 |  | 06:00:00 | 16:00:00 |  | 9.5 |  |  | 2500 | 2450
2020-06-15 00:00:00 | [NAME] | 987654 | Tape Application | Evie | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 7.5 |  |  | 2500 | 2500
2020-06-16 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 3 |  |  | 3500 | 3490
2020-06-17 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 4 |  |  | 500 | 500
2020-06-17 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 5 |  |  | 1200 | 1198
2020-06-18 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 4 |  |  | 1500 | 1495
2020-06-19 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 4 |  |  | 2000 | 1995
2020-06-20 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 3 |  |  | 1500 | 1499
2020-06-21 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 06:00:00 | 15:30:00 |  | 06:00:00 | 15:30:00 |  | 5 |  |  | 1200 | 1198
2020-06-22 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 6 |  |  | 1100 | 1100
2020-06-23 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00 |  | 4 |  |  | 1300 | 1300
2020-06-24 00:00:00 | Smith Co | 123456 | Apply Labels | Evie | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 5 |  |  | 900 | 880
2020-06-25 00:00:00 | Smith Co | 123456 | Apply Labels | [NAME] | 06:00:00 | 16:30:00 |  | 06:00:00 | 16:30:00 |  | 4 |  |  | 1600 | 1598