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

 |  |  |  | 01:00:00 |  |  |  |  | 01:00:00
 | Oct 12 Week 1 |  |  |  |  | Oct 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 | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
Dailies Capactity Picker 1 - JIMMYM | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
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 | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:00:00 | 0 | 00:00:00 | 0
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] | 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
 | Oct 12 Week 2 |  |  |  |  | Oct 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 | 04:58:16 | 74 |  |  |  | 10:51:48 | 189
Dailies Capactity Picker 1 - JIMMYM | 07:04:44 | 147 |  |  |  | 16:10:55 | 423
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:22:58 | 111 |  |  |  | 15:45:54 | 391
Other department Bulk picker 1 - SAMUELM | 02:02:24 | 50 |  |  |  | 00:45:26 | 35
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 |  | 01:34:25 | 50
Other department Bulk picker 5 - MANDISIM | 1900-01-02 00:39:00 | 27 |  |  |  | 1900-01-02 10:19:00 | 23
Other department Bulk picker [NAME] | 03:04:43 | 76 |  |  |  | 01:35:47 | 33
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
 | Oct 12 Week 3 |  |  |  |  | Oct 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 | 07:15:09 | 93 |  |  |  | 15:26:43 | 349
Dailies Capactity Picker 1 - JIMMYM | 08:30:23 | 209 |  |  |  | 16:12:26 | 378
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:30:20 | 114 |  |  |  | 15:52:46 | 390
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:03:52 | 53 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 01:01:52 | 25 |  |  |  | 00:32:00 | 21
Other department Bulk picker [NAME] | 02:11:08 | 34 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 5 - MANDISIM | 01:54:51 | 44 |  |  |  | 00:18:49 | 11
Other department Bulk picker [NAME] | 01:04:47 | 30 |  |  |  | 00:13:50 | 28
Other department Bulk picker [NAME] | 00:59:11 | 30 |  |  |  | 00:52:36 | 24
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:38:02 | 34
 | Oct 12 Week 4 |  |  |  |  | Oct 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 | 06:54:39 | 80 |  |  |  | 13:14:55 | 276
Dailies Capactity Picker 1 - JIMMYM | 05:59:58 | 105 |  |  |  | 16:47:57 | 349
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 | 05:13:20 | 109 |  |  |  | 11:44:28 | 293
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:56:02 | 37 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS | 00:30:15 | 11 |  |  |  | 01:23:35 | 38
Other department Bulk picker [NAME] | 00:00:00 | 0 | 00:00:00 | 0 |  | 00:43:53 | 23
Other department Bulk picker 5 - MANDISIM | 01:07:00 | 29 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Bulk picker [NAME] | 02:57:33 | 76 |  |  |  | 01:45:43 | 58
Other department Bulk picker [NAME] | 01:01:00 | 25 |  |  |  | 01:44:00 | 35
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:13:20 | 10
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:13:56 | 9
 | Oct 12 Week 5 |  |  |  |  | Oct 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:45:45 | 31 |  |  |  | 04:05:24 | 78
Dailies Capactity Picker 1 - JIMMYM | 05:47:54 | 149 |  |  |  | 18:48:17 | 543
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 | 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:57:23 | 179 |  |  |  | 19:00:54 | 458
Other department Bulk picker 1 - SAMUELM | 00:27:20 | 27 |  |  |  | 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:11:36 | 65 |  |  |  | 00:55:00 | 17
Other department Bulk picker [NAME] | 02:37:17 | 92 |  |  |  | 02:29:08 | 88
Other department Bulk picker 5 - MANDISIM | 01:03:36 | 29 |  |  |  | 04:04:33 | 110
Other department Bulk picker [NAME] | 00:37:15 | 16 |  |  |  | 01:24:45 | 42
Other department Bulk picker [NAME] | 01:05:00 | 49 |  |  |  | 00:00:00 | 0 | 00:00:00 | 0
Other department Receiving picker 1 - VELAPHI | 00:00:00 | 0 | 00:00:00 | 0 |  | 02:47:28 | 87
Other department Receiving picker 2 - KNKOLISA | 00:00:00 | 0 | 00:00:00 | 0 |  | 03:00:11 | 99
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 |  | 07:17:00 | 132