Spreadsheet: 216712d1361861768-calculating-time-worked-per-transaction-per-user-user-per-day-and-qty-of-lines-picked-pick-efficiency-26
Sheet: Nov 12

 |  |  |  | 01:00:00 |  |  |  |  | 01:00:00
 | Nov 12 Week 1 |  |  |  |  | Nov 12 Week 1
 | Total Morning 09:30 - 12:00 | Total weekly lines | Average time per line | Average lines per hour |  | Total Afternoon 14:00 - Finish | Total weekly lines | Average time per line | Average lines per hour
Dailies GSA Picker - Isaac Maja | 04:31:16 | 95 |  |  |  | 10:56:22 | 226
Dailies Capactity Picker 1 - JIMMYM | 05:36:28 | 152 |  |  |  | 16:18:45 | 468
Dailies Capactity Picker 2 - JONNYW | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 3 - KHANYIS (Temp) | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 4 - ROBERTR | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 5 - TAKALANI | 06:03:35 | 163 |  |  |  | 15:41:42 | 367
Other department Bulk picker 1 - SAMUELM | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:01:29 | 39 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 03:08:19 | 96 |  |  |  | 01:27:53 | 54
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:33:01 | 31
Other department Bulk picker 5 - MANDISIM | 01:05:19 | 28 |  |  |  | 00:44:04 | 31
Other department Bulk picker [NAME] | 01:49:42 | 55 |  |  |  | 00:48:33 | 24
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:48:35 | 79
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:11:54 | 31
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:56:58 | 74
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
 | Nov 12 Week 2 |  |  |  |  | Nov 12 Week 2
 | Total Morning 09:30 - 12:00 | Total weekly lines | Average time per line | Average lines per hour |  | Total Afternoon 14:00 - Finish | Total weekly lines | Average time per line | Average lines per hour
Dailies GSA Picker - Isaac Maja | 06:25:21 | 151 |  |  |  | 13:56:49 | 342
Dailies Capactity Picker 1 - JIMMYM | 07:36:32 | 189 |  |  |  | 18:52:08 | 473
Dailies Capactity Picker 2 - JONNYW | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 3 - KHANYIS (Temp) | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 4 - ROBERTR | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 5 - TAKALANI | 06:03:32 | 165 |  |  |  | 18:40:56 | 461
Other department Bulk picker 1 - SAMUELM | 02:30:10 | 79 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 03:54:45 | 77 |  |  |  | 00:28:04 | 21
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:21:43 | 24
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:05:07 | 20
Other department Bulk picker [NAME] | 03:24:22 | 87 |  |  |  | 02:14:39 | 43
Other department Bulk picker [NAME] | 00:45:55 | 15 |  |  |  | 02:26:05 | 69
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:03:19 | 18
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:18:51 | 37
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:56:06 | 26
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:30:59 | 32
 | Nov 12 Week 3 |  |  |  |  | Nov 12 Week 3
 | Total Morning 09:30 - 12:00 | Total weekly lines | Average time per line | Average lines per hour |  | Total Afternoon 14:00 - Finish | Total weekly lines | Average time per line | Average lines per hour
Dailies GSA Picker - Isaac Maja | 08:38:18 | 175 |  |  |  | 13:58:16 | 325
Dailies Capactity Picker 1 - JIMMYM | 07:03:11 | 188 |  |  |  | 18:46:27 | 577
Dailies Capactity Picker 2 - JONNYW | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 3 - KHANYIS (Temp) | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 4 - ROBERTR | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 5 - TAKALANI | 07:20:44 | 170 |  |  |  | 17:46:27 | 496
Other department Bulk picker 1 - SAMUELM | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 02:44:30 | 50 |  |  |  | 00:47:56 | 15
Other department Bulk picker [NAME] | 03:01:19 | 117 |  |  |  | 01:29:22 | 68
Other department Bulk picker 5 - MANDISIM | 01:58:11 | 75 |  |  |  | 00:26:08 | 11
Other department Bulk picker [NAME] | 02:33:16 | 68 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 1 - VELAPHI |  |  | 00:00:00 | 0 |  | 00:10:00 | 18
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 04:27:01 | 121
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:39:22 | 23
 | Nov 12 Week 4 |  |  |  |  | Nov 12 Week 4
 | Total Morning 09:30 - 12:00 | Total weekly lines | Average time per line | Average lines per hour |  | Total Afternoon 14:00 - Finish | Total weekly lines | Average time per line | Average lines per hour
Dailies GSA Picker - Isaac Maja | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 1 - JIMMYM | 07:38:58 | 186 |  |  |  | 17:59:41 | 553
Dailies Capactity Picker 2 - JONNYW | 02:21:20 | 43 |  |  |  | 04:51:07 | 78
Dailies Capactity Picker 3 - KHANYIS (Temp) | 02:13:52 | 46 |  |  |  | 04:48:49 | 79
Dailies Capactity Picker 4 - ROBERTR | 00:57:49 | 27 |  |  |  | 04:48:19 | 86
Dailies Capactity Picker 5 - TAKALANI | 07:12:57 | 200 |  |  |  | 19:28:48 | 514
Other department Bulk picker 1 - SAMUELM | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:35:06 | 45
Other department Bulk picker [NAME] | 01:03:23 | 54 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 02:57:22 | 75 |  |  |  | 02:04:30 | 41
Other department Bulk picker [NAME] | 02:41:14 | 75 |  |  |  | 00:35:03 | 39
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 06:11:45 | 182
Other department Bulk picker [NAME] | 02:32:58 | 63 |  |  |  | 02:43:57 | 94
Other department Bulk picker [NAME] | 01:15:54 | 31 |  |  |  | 02:41:40 | 69
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:07:13 | 20
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:53:28 | 26
 | Nov 12 Week 5 |  |  |  |  | Nov 12 Week 5
 | Total Morning 09:30 - 12:00 | Total weekly lines | Average time per line | Average lines per hour |  | Total Afternoon 14:00 - Finish | Total weekly lines | Average time per line | Average lines per hour
Dailies GSA Picker - Isaac Maja | 02:08:43 | 62 |  |  |  | 04:08:27 | 91
Dailies Capactity Picker 1 - JIMMYM | 01:27:30 | 61 |  |  |  | 05:02:41 | 149
Dailies Capactity Picker 2 - JONNYW | 00:59:55 | 28 |  |  |  | 02:25:40 | 41
Dailies Capactity Picker 3 - KHANYIS | 02:22:25 | 44 |  |  |  | 05:19:46 | 89
Dailies Capactity Picker 4 - ROBERTR | 02:02:44 | 47 |  |  |  | 05:12:30 | 109
Dailies Capactity Picker 5 - TAKALANI | 02:23:43 | 57 |  |  |  | 05:03:07 | 121
Other department Bulk picker 1 - SAMUELM | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:21:01 | 35 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:00:08 | 28
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:49:29 | 21
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:39:18 | 30