Spreadsheet: 841185d1693413580-count-and-sum-same-items-kcadzow-gp-12-inspection-sample-sheet
Sheet: Redesigned Data

ID | Start time | Completion time | [NAME] | Name | Operator Name | Part Number | Label Serial Number | Label Date | [NAME] | Defects Found? | Defect Reason Code | Pcs Rejected per bin
23 | 2023-07-31 08:33:10 | 2023-07-31 08:34:41 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 1
23 | 2023-07-31 08:33:10 | 2023-07-31 08:34:41 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2150 - Hole Missing | 1
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
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 |  |  |  |  |  | 2023-07-31 00:00:00 | 20 | Yes | 2160 - Extra Hole | 2
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 |  |  |  |  |  | 2023-07-31 00:00:00 | 20 | Yes | 2140 - Burr (Out of Tolerance) | 2
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 |  |  |  |  |  | 2023-07-31 00:00:00 | 20 | Yes | 2170 - Hole Pulled | 1
25 | 2023-07-31 08:35:43 | 2023-07-31 08:37:57 |  |  |  |  |  | 2023-07-31 00:00:00 | 20 | 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
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
28 | 2023-07-31 09:01:05 | 2023-07-31 09:02:00 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2
28 | 2023-07-31 09:01:05 | 2023-07-31 09:02:00 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2120 - Trim Dimensional | 3
29 | 2023-07-31 09:07:00 | 2023-07-31 09:07:42 |  |  |  |  |  | 2023-07-31 00:00:00 | 15 | Yes | 2100 - Split | 2
30 | 2023-07-31 10:06:36 | 2023-07-31 10:07:34 |  |  |  |  |  | 2023-07-31 00:00:00 | 30 | Yes | 2100 - Split | 4
30 | 2023-07-31 10:06:36 | 2023-07-31 10:07:34 |  |  |  |  |  | 2023-07-31 00:00:00 | 30 | Yes | 2140 - Burr (Out of Tolerance) | 1
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
31 | 2023-07-31 12:43:38 | 2023-07-31 12:44:12 |  |  |  |  |  | 2023-07-21 00:00:00 | 33 | Yes | 2120 - Trim Dimensional | 2313
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
32 | 2023-07-31 12:44:28 | 2023-07-31 12:44:57 |  |  |  |  |  | 2023-06-30 00:00:00 | 44 | Yes | 2170 - Hole Pulled | 23
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
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 |  |  |  |  |  | 2023-07-27 00:00:00 | 234 | Yes | 2160 - Extra Hole | 453
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 |  |  |  |  |  | 2023-07-27 00:00:00 | 234 | Yes | 2100 - Split | 345
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 |  |  |  |  |  | 2023-07-27 00:00:00 | 234 | Yes | 2160 - Extra Hole | 3453
34 | 2023-07-31 12:47:53 | 2023-07-31 12:48:39 |  |  |  |  |  | 2023-07-27 00:00:00 | 234 | 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
36 | 2023-07-31 13:26:32 | 2023-07-31 13:27:14 |  |  |  |  |  | 2023-07-25 00:00:00 | 10 | Yes | 2100 - Split | 3
37 | 2023-08-01 10:54:11 | 2023-08-01 10:55:27 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 2
37 | 2023-08-01 10:54:11 | 2023-08-01 10:55:27 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2140 - Burr (Out of Tolerance) | 2
38 | 2023-08-01 11:06:28 | 2023-08-01 11:07:24 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4
38 | 2023-08-01 11:06:28 | 2023-08-01 11:07:24 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2150 - Hole Missing | 6
39 | 2023-08-01 11:10:37 | 2023-08-01 11:11:28 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 5
39 | 2023-08-01 11:10:37 | 2023-08-01 11:11:28 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2150 - Hole Missing | 3
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
40 | 2023-08-01 11:13:26 | 2023-08-01 11:14:19 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2160 - Extra Hole | 4
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
41 | 2023-08-01 11:25:13 | 2023-08-01 11:26:07 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2150 - Hole Missing | 5
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 6
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 7
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2120 - Trim Dimensional | 5
42 | 2023-08-01 11:27:34 | 2023-08-01 11:28:58 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 7
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
45 | 2023-08-01 11:33:03 | 2023-08-01 11:34:11 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2100 - Split | 4
45 | 2023-08-01 11:33:03 | 2023-08-01 11:34:11 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2140 - Burr (Out of Tolerance) | 3
45 | 2023-08-01 11:33:03 | 2023-08-01 11:34:11 |  |  |  |  |  | 2023-08-01 00:00:00 | 100 | Yes | 2170 - Hole Pulled | 4
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
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
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2100 - Split | 2
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2110 - Form Dimensional/Bent | 2
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2120 - Trim Dimensional | 2
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2140 - Burr (Out of Tolerance) | 2
50 | 2023-08-18 10:13:14 | 2023-08-18 10:14:25 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | 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
51 | 2023-08-18 10:15:04 | 2023-08-18 10:16:01 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2110 - Form Dimensional/Bent | 2
51 | 2023-08-18 10:15:04 | 2023-08-18 10:16:01 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2160 - Extra Hole | 2
51 | 2023-08-18 10:15:04 | 2023-08-18 10:16:01 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2140 - Burr (Out of Tolerance) | 2
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
52 | 2023-08-18 10:16:25 | 2023-08-18 10:17:06 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2120 - Trim Dimensional | 2
52 | 2023-08-18 10:16:25 | 2023-08-18 10:17:06 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2110 - Form Dimensional/Bent | 3
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
53 | 2023-08-18 10:17:29 | 2023-08-18 10:18:16 |  |  |  |  |  | 2023-08-18 00:00:00 | 100 | Yes | 2140 - Burr (Out of Tolerance) | 2
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
55 | 2023-08-18 10:19:23 | 2023-08-18 10:19:48 |  |  |  |  |  | 2023-08-18 00:00:00 | 200 | No