Spreadsheet: 841198d1693418729-count-and-sum-same-items-gp12-report
Sheet: Data

ID | Start time | Completion time | [NAME] | Name | Operator Name | Part Number | Label Serial Number | Label Date | [NAME] | Defects Found? | a. Defect Reason Code | a. Pcs Rejected per bin | a. Additional Reason Codes | b. Defect Reason Code | b. Pcs Rejected per bin | b. Additional Reason Codes | c. Defect Reason Code | c. Pcs Rejected per bin | c. Additional Reason Codes | d. Defect Reason Code | d. Pcs Rejected per bin | d. Additional Reason Codes | e. Defect Reason Code | e. Pcs Rejected per bin | FGI Label Serial Number
23 | 2023-07-31 08:33:10 | 2023-07-31 08:34:41 | anonymous |  | anonymous | GP401301F | 64706332 | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 1 | Yes | 2150 - Hole Missing | 1 | No |  |  |  |  |  |  |  |  | 63716358
24 | 2023-07-31 08:34:43 | 2023-07-31 08:35:41 | anonymous |  | anonymous | GP401301F | 1234567 | 2023-07-31 00:00:00 | 15 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234567
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 | anonymous |  | anonymous | 12345 | 1235567 | 2023-07-31 00:00:00 | 20 | Yes | 2100 - Split | 1 | Yes | 2160 - Extra Hole | 2 | Yes | 2140 - Burr (Out of Tolerance) | 2 | Yes | 2170 - Hole Pulled | 1 | Yes | 2100 - Split | 3 | 1234567
26 | 2023-07-31 08:54:33 | 2023-07-31 08:55:13 | anonymous |  | anonymous | 12345 | 1234567 | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | No |  |  |  |  |  |  |  |  |  |  |  | 1234567
27 | 2023-07-31 08:55:27 | 2023-07-31 08:56:12 | anonymous |  | anonymous | 12356 | 123566 | 2023-07-31 00:00:00 | 15 | Yes | 2110 - Form Dimensional/Bent | 2 | No |  |  |  |  |  |  |  |  |  |  |  | 1234567
28 | 2023-07-31 09:01:05 | 2023-07-31 09:02:00 | anonymous |  | anonymous | 12345 | 1234556 | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | Yes | 2120 - Trim Dimensional | 3 | No |  |  |  |  |  |  |  |  | 1234567
29 | 2023-07-31 09:07:00 | 2023-07-31 09:07:42 | anonymous |  | anonymous | 12345 | 1234567 | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | No |  |  |  |  |  |  |  |  |  |  |  | 12345566
30 | 2023-07-31 10:06:36 | 2023-07-31 10:07:34 | anonymous |  | anonymous | 12345 | 1234567 | 2023-07-31 00:00:00 | 30 | Yes | 2100 - Split | 4 | Yes | 2140 - Burr (Out of Tolerance) | 1 | No |  |  |  |  |  |  |  |  | 1235566
31 | 2023-07-31 12:43:38 | 2023-07-31 12:44:12 | anonymous |  | anonymous | 23123 | 12312 | 2023-07-21 00:00:00 | 33 | Yes | 2110 - Form Dimensional/Bent | 23 | Yes | 2120 - Trim Dimensional | 2313 | No |  |  |  |  |  |  |  |  | 4564
32 | 2023-07-31 12:44:28 | 2023-07-31 12:44:57 | anonymous |  | anonymous | 233 | 123 | 2023-06-30 00:00:00 | 44 | Yes | 2120 - Trim Dimensional | 34 | Yes | 2170 - Hole Pulled | 23 | No |  |  |  |  |  |  |  |  | 234
33 | 2023-07-31 12:39:21 | 2023-07-31 12:45:09 | anonymous |  | anonymous | 12345 | 123456 | 2023-07-31 00:00:00 | 20 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123456
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 | anonymous |  | anonymous | 2342 | 2342 | 2023-07-27 00:00:00 | 234 | Yes | 2150 - Hole Missing | 234 | Yes | 2160 - Extra Hole | 453 | Yes | 2100 - Split | 345 | Yes | 2160 - Extra Hole | 3453 | Yes | 2100 - Split | 234 | 234
35 | 2023-07-31 13:10:10 | 2023-07-31 13:10:57 | anonymous |  | anonymous | 401403 | 23537978 | 2023-07-24 00:00:00 | 50 | Yes | 2150 - Hole Missing | 2 | No |  |  |  |  |  |  |  |  |  |  |  | 876756464
36 | 2023-07-31 13:26:32 | 2023-07-31 13:27:14 | anonymous |  | anonymous | 43566 | 2343536 | 2023-07-25 00:00:00 | 10 | Yes | 2100 - Split | 3 | No |  |  |  |  |  |  |  |  |  |  |  | 935938759
37 | 2023-08-01 10:54:11 | 2023-08-01 10:55:27 | anonymous |  | anonymous | GP401301F | 1234567 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 2 | Yes | 2140 - Burr (Out of Tolerance) | 2 | No |  |  |  |  |  |  |  |  | 1234567
38 | 2023-08-01 11:06:28 | 2023-08-01 11:07:24 | anonymous |  | anonymous | 1234567 | 1234567 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | Yes | 2150 - Hole Missing | 6 | No |  |  |  |  |  |  |  |  | 1234567
39 | 2023-08-01 11:10:37 | 2023-08-01 11:11:28 | anonymous |  | anonymous | 565656 | 46464 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 5 | Yes | 2150 - Hole Missing | 3 | No |  |  |  |  |  |  |  |  | 56547
40 | 2023-08-01 11:13:26 | 2023-08-01 11:14:19 | anonymous |  | anonymous | 5656565 | 65656 | 2023-08-01 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | Yes | 2160 - Extra Hole | 4 | No |  |  |  |  |  |  |  |  | 56678
41 | 2023-08-01 11:25:13 | 2023-08-01 11:26:07 | anonymous |  | anonymous | 354345 | 3454535 | 2023-08-01 00:00:00 | 100 | Yes | 2120 - Trim Dimensional | 3 | Yes | 2150 - Hole Missing | 5 | No |  |  |  |  |  |  |  |  | 345435
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 | anonymous |  | anonymous | 64646 | 893745957 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 6 | Yes | 2100 - Split | 7 | Yes | 2120 - Trim Dimensional | 5 | Yes | 2100 - Split | 7 | No |  |  | 77697979
43 | 2023-08-01 11:31:40 | 2023-08-01 11:32:15 | anonymous |  | anonymous | 7859375 | 875943875 | 2023-08-01 00:00:00 | 100 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98735937
44 | 2023-08-01 11:32:18 | 2023-08-01 11:32:59 | anonymous |  | anonymous | 97845973 | 9347593 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | No |  |  |  |  |  |  |  |  |  |  |  | 793475
45 | 2023-08-01 11:33:03 | 2023-08-01 11:34:11 | anonymous |  | anonymous | 656565 | 647484575 | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | Yes | 2140 - Burr (Out of Tolerance) | 3 | Yes | 2170 - Hole Pulled | 4 | No |  |  |  |  |  | 875973
46 | 2023-08-02 11:38:38 | 2023-08-02 11:39:58 | anonymous |  | anonymous | 793475932 | 873583262 | 2023-08-01 00:00:00 | 100 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 987467265
47 | 2023-08-03 12:14:17 | 2023-08-03 12:16:03 | anonymous |  | anonymous | 76548765 | 6546546 | 2023-08-03 00:00:00 | 100 | Yes | 2100 - Split | 4 | No |  |  |  |  |  |  |  |  |  |  |  | 743593746
48 | 2023-08-03 12:21:07 | 2023-08-03 12:21:40 | anonymous |  | anonymous | 756576 | 576576 | 2023-08-03 00:00:00 | 100 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46457
49 | 2023-08-17 09:24:23 | 2023-08-17 09:25:31 | anonymous |  | anonymous | GP401301F | 63706332 | 2023-08-17 00:00:00 | 100 | Yes | 2100 - Split | 5 | No |  |  |  |  |  |  |  |  |  |  |  | 12345678
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 | anonymous |  | anonymous | 12345 | 123456789 | 2023-08-18 00:00:00 | 100 | Yes | 2100 - Split | 2 | Yes | 2110 - Form Dimensional/Bent | 2 | Yes | 2120 - Trim Dimensional | 2 | Yes | 2140 - Burr (Out of Tolerance) | 2 | Yes | 2150 - Hole Missing | 2 | 123456789
51 | 2023-08-18 10:15:04 | 2023-08-18 10:16:01 | anonymous |  | anonymous | 12345 | 123456789 | 2023-08-18 00:00:00 | 100 | Yes | 2100 - Split | 2 | Yes | 2110 - Form Dimensional/Bent | 2 | Yes | 2160 - Extra Hole | 2 | Yes | 2140 - Burr (Out of Tolerance) | 2 | No |  |  | 123456789
52 | 2023-08-18 10:16:25 | 2023-08-18 10:17:06 | anonymous |  | anonymous | 23456 | 1234567 | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 2 | Yes | 2120 - Trim Dimensional | 2 | Yes | 2110 - Form Dimensional/Bent | 3 | No |  |  |  |  |  | 1234567
53 | 2023-08-18 10:17:29 | 2023-08-18 10:18:16 | anonymous |  | anonymous | 34567 | 234567 | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | Yes | 2140 - Burr (Out of Tolerance) | 2 | No |  |  |  |  |  |  |  |  | 25436568
54 | 2023-08-18 10:18:37 | 2023-08-18 10:19:05 | anonymous |  | anonymous | 354657 | 345456657 | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | No |  |  |  |  |  |  |  |  |  |  |  | 34645798
55 | 2023-08-18 10:19:23 | 2023-08-18 10:19:48 | anonymous |  | anonymous | 34543645 | 46456568 | 2023-08-18 00:00:00 | 200 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3454657