Spreadsheet: 841185d1693413580-count-and-sum-same-items-kcadzow-gp-12-inspection-sample-sheet
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 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 1 | Yes | 2150 - Hole Missing | 1 | No
24 | 2023-07-31 08:34:43 | 2023-07-31 08:35:41 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | No
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 |  |  |  |  |  | 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
26 | 2023-07-31 08:54:33 | 2023-07-31 08:55:13 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | No
27 | 2023-07-31 08:55:27 | 2023-07-31 08:56:12 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2110 - Form Dimensional/Bent | 2 | No
28 | 2023-07-31 09:01:05 | 2023-07-31 09:02:00 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | Yes | 2120 - Trim Dimensional | 3 | No
29 | 2023-07-31 09:07:00 | 2023-07-31 09:07:42 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2 | No
30 | 2023-07-31 10:06:36 | 2023-07-31 10:07:34 |  |  |  |  |  | 2023-07-31 00:00:00 | 30 | Yes | 2100 - Split | 4 | Yes | 2140 - Burr (Out of Tolerance) | 1 | No
31 | 2023-07-31 12:43:38 | 2023-07-31 12:44:12 |  |  |  |  |  | 2023-07-21 00:00:00 | 33 | Yes | 2110 - Form Dimensional/Bent | 23 | Yes | 2120 - Trim Dimensional | 2313 | No
32 | 2023-07-31 12:44:28 | 2023-07-31 12:44:57 |  |  |  |  |  | 2023-06-30 00:00:00 | 44 | Yes | 2120 - Trim Dimensional | 34 | Yes | 2170 - Hole Pulled | 23 | No
33 | 2023-07-31 12:39:21 | 2023-07-31 12:45:09 |  |  |  |  |  | 2023-07-31 00:00:00 | 20 | No
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 |  |  |  |  |  | 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
35 | 2023-07-31 13:10:10 | 2023-07-31 13:10:57 |  |  |  |  |  | 2023-07-24 00:00:00 | 50 | Yes | 2150 - Hole Missing | 2 | No
36 | 2023-07-31 13:26:32 | 2023-07-31 13:27:14 |  |  |  |  |  | 2023-07-25 00:00:00 | 10 | Yes | 2100 - Split | 3 | No
37 | 2023-08-01 10:54:11 | 2023-08-01 10:55:27 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 2 | Yes | 2140 - Burr (Out of Tolerance) | 2 | No
38 | 2023-08-01 11:06:28 | 2023-08-01 11:07:24 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | Yes | 2150 - Hole Missing | 6 | No
39 | 2023-08-01 11:10:37 | 2023-08-01 11:11:28 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 5 | Yes | 2150 - Hole Missing | 3 | No
40 | 2023-08-01 11:13:26 | 2023-08-01 11:14:19 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | Yes | 2160 - Extra Hole | 4 | No
41 | 2023-08-01 11:25:13 | 2023-08-01 11:26:07 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2120 - Trim Dimensional | 3 | Yes | 2150 - Hole Missing | 5 | No
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 |  |  |  |  |  | 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
43 | 2023-08-01 11:31:40 | 2023-08-01 11:32:15 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | No
44 | 2023-08-01 11:32:18 | 2023-08-01 11:32:59 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | No
45 | 2023-08-01 11:33:03 | 2023-08-01 11:34:11 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4 | Yes | 2140 - Burr (Out of Tolerance) | 3 | Yes | 2170 - Hole Pulled | 4 | No
46 | 2023-08-02 11:38:38 | 2023-08-02 11:39:58 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | No
47 | 2023-08-03 12:14:17 | 2023-08-03 12:16:03 |  |  |  |  |  | 2023-08-03 00:00:00 | 100 | Yes | 2100 - Split | 4 | No
48 | 2023-08-03 12:21:07 | 2023-08-03 12:21:40 |  |  |  |  |  | 2023-08-03 00:00:00 | 100 | No
49 | 2023-08-17 09:24:23 | 2023-08-17 09:25:31 |  |  |  |  |  | 2023-08-17 00:00:00 | 100 | Yes | 2100 - Split | 5 | No
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 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
51 | 2023-08-18 10:15:04 | 2023-08-18 10:16:01 |  |  |  |  |  | 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
52 | 2023-08-18 10:16:25 | 2023-08-18 10:17:06 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 2 | Yes | 2120 - Trim Dimensional | 2 | Yes | 2110 - Form Dimensional/Bent | 3 | No
53 | 2023-08-18 10:17:29 | 2023-08-18 10:18:16 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | Yes | 2140 - Burr (Out of Tolerance) | 2 | No
54 | 2023-08-18 10:18:37 | 2023-08-18 10:19:05 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3 | No
55 | 2023-08-18 10:19:23 | 2023-08-18 10:19:48 |  |  |  |  |  | 2023-08-18 00:00:00 | 200 | No