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

 |  |  |  | 01:00:00 |  |  |  |  | 01:00:00
 | Dec 12 Week 1 |  |  |  |  | Dec 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 | 08:12:56 | 187 |  |  |  | 12:49:49 | 311
Dailies Capactity Picker 1 - JIMMYM | 08:26:42 | 238 |  |  |  | 14:52:04 | 469
Dailies Capactity Picker 2 - JONNYW | 04:27:24 | 104 |  |  |  | 11:33:42 | 232
Dailies Capactity Picker 3 - KHANYIS (Temp) | 02:00:00 | 43 |  |  |  | 12:57:57 | 265
Dailies Capactity Picker 4 - ROBERTR | 05:38:23 | 161 |  |  |  | 14:27:02 | 306
Dailies Capactity Picker 5 - TAKALANI | 03:51:21 | 158 |  |  |  | 09:44:46 | 323
Other department Bulk picker 1 - SAMUELM | 01:20:00 | 63 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:06:12 | 36 |  |  |  | 01:41:33 | 63
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 |  | 1900-01-02 13:58:08 | 128
Other department Bulk picker 5 - MANDISIM | 01:12:13 | 43 |  |  |  | 05:05:24 | 122
Other department Bulk picker [NAME] | 02:35:16 | 76 |  |  |  | 01:59:08 | 54
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 03:43:31 | 106
Other department Receiving picker 1 - VELAPHI | 00:45:49 | 19 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:17:51 | 27
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 |  | 01:02:42 | 46
 | Dec 12 Week 2 |  |  |  |  | Dec 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:30:50 | 139 |  |  |  | 13:41:25 | 340
Dailies Capactity Picker 1 - JIMMYM | 03:44:35 | 145 |  |  |  | 13:01:12 | 384
Dailies Capactity Picker 2 - JONNYW | 04:18:18 | 93 |  |  |  | 15:10:12 | 294
Dailies Capactity Picker 3 - KHANYIS (Temp) | 07:01:38 | 152 |  |  |  | 19:10:32 | 370
Dailies Capactity Picker 4 - ROBERTR | 07:09:14 | 200 |  |  |  | 18:36:03 | 445
Dailies Capactity Picker 5 - TAKALANI | 07:07:46 | 178 |  |  |  | 19:08:34 | 515
Other department Bulk picker 1 - SAMUELM | 01:20:00 | 45 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:16:48 | 55 |  |  |  | 00:26:54 | 18
Other department Bulk picker 3 - GEORGESS | 1900-01-02 09:46:26 | 99 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 02:10:37 | 100 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:26:13 | 44
Other department Bulk picker [NAME] | 01:35:02 | 39 |  |  |  | 02:34:11 | 50
Other department Bulk picker [NAME] | 01:14:06 | 27 |  |  |  | 02:14:03 | 72
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:28:01 | 61
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:03:01 | 25
Other department Receiving picker 3 - RASTA | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:41:36 | 46
Other department Receiving picker 4 - SIMON | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:49:32 | 71
 | Dec 12 Week 3 |  |  |  |  | Dec 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:52:17 | 193 |  |  |  | 12:37:30 | 311
Dailies Capactity Picker 1 - JIMMYM | 03:18:37 | 143 |  |  |  | 15:02:41 | 458
Dailies Capactity Picker 2 - JONNYW | 05:23:42 | 151 |  |  |  | 09:54:41 | 243
Dailies Capactity Picker 3 - KHANYIS (Temp) | 05:46:26 | 147 |  |  |  | 20:00:14 | 415
Dailies Capactity Picker 4 - ROBERTR | 06:25:55 | 161 |  |  |  | 20:27:15 | 501
Dailies Capactity Picker 5 - TAKALANI | 04:32:18 | 98 |  |  |  | 09:31:05 | 231
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:19:06 | 43 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 03:04:31 | 71 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 03:33:43 | 140 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:55:00 | 62
Other department Bulk picker [NAME] | 01:34:10 | 43 |  |  |  | 03:47:27 | 112
Other department Bulk picker [NAME] | 02:19:23 | 72 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 04:05:00 | 127
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 05:23:48 | 102
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 |  | 04:43:58 | 108
 | Dec 12 Week 4 |  |  |  |  | Dec 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 | 04:59:22 | 151 |  |  |  | 16:22:15 | 425
Dailies Capactity Picker 2 - JONNYW | 02:53:13 | 65 |  |  |  | 14:34:22 | 323
Dailies Capactity Picker 3 - KHANYIS (Temp) | 05:00:09 | 109 |  |  |  | 16:08:23 | 353
Dailies Capactity Picker 4 - ROBERTR | 03:31:50 | 97 |  |  |  | 16:36:57 | 385
Dailies Capactity Picker 5 - TAKALANI | 05:52:21 | 124 |  |  |  | 16:24:32 | 405
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 | 01:48:33 | 54 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:07:55 | 43 |  |  |  | 01:03:15 | 56
Other department Bulk picker 5 - MANDISIM | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:05:00 | 26
Other department Bulk picker [NAME] | 03:19:46 | 96 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 01:18:14 | 44 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 01:10:22 | 35
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:36:37 | 84
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 |  | 02:41:22 | 76
 | Dec 12 Week 5 |  |  |  |  | Dec 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:18:36 | 31 |  |  |  | 00:10:00 | 2
Dailies Capactity Picker 1 - JIMMYM | 00:54:05 | 19 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 2 - JONNYW | 02:14:56 | 50 |  |  |  | 00:21:00 | 7
Dailies Capactity Picker 3 - KHANYIS | 00:38:27 | 10 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 4 - ROBERTR | 01:25:08 | 23 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 5 - TAKALANI | 01:21:26 | 26 |  |  |  | 00:14:01 | 6
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:15:00 | 7 |  |  |  | 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] | 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 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 |  | 00:00:00 | 0 | 00:00:00 | 0
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:00:00 | 0 | 00:00:00 | 0