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

October 12 | October 12 Morning monthly orders 09:30 - 12:00 |  |  | October 12 Afternoon monthly orders 14:00 - Finish
Dailies | Average time per line | Average lines per hour |  | Average time per line | Average lines per hour
Dailies GSA Picker 1 - Isaac Maja (GSA Current) | 00:03:50.875000 | 10.10138398099307 |  | 00:02:25.564000 | 15.97943098984284
Dailies Capactity Picker 2 - JIMMYM (Capacity Current) | 00:02:13.134000 | 17.70687970526673 |  | 00:01:58.006000 | 19.82274934907455
Dailies Capactity Picker 3 - JONNYW (Capacity Current) | 00:00:00 | 0 |  | 00:00:00 | 0
Dailies Capactity Picker [NAME] (Temp Contract Ended) | 00:00:00 | 0 |  | 00:00:00 | 0
Dailies Capactity Picker 5 - ROBERTR (Capacity Current) | 00:00:00 | 0 |  | 00:00:00 | 0
Dailies Capactity Picker 6 - TAKALANI (Capacity. Contract Ended) | 00:02:24.966000 | 16.30362270241026 |  | 00:01:57.091000 | 19.68062514010951
Other department - Bulk pickers
Other department Bulk picker 1 - SAMUELM (GSA) | 00:00:41.524000 | 16.75561932089909 |  | 00:00:15.577000 | 9.244314013206164
Other department Bulk picker [NAME] (GSA) | 00:00:32.633000 | 17.88210119485991 |  | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS (GSA) | 00:01:38.068000 | 13.28375550552679 |  | 00:01:23.504000 | 17.03972400978881
Other department Bulk picker [NAME] (GSA) | 00:01:06.798000 | 10.13051688561164 |  | 00:01:05.892000 | 19.72512589592358
Other department Bulk picker 5 - MANDISIM (Capacity) | 00:23:02.697000 | 15.374025707872 |  | 00:31:12.771000 | 12.49160644128711
Other department Bulk picker [NAME] (Capacity. Contract Ended) | 00:01:51.051000 | 20.78521982913423 |  | 00:01:26.846000 | 40.95402574035916
Other department Bulk picker [NAME] (GSA) | 00:01:08.872000 | 20.04698021231254 |  | 00:01:01.957000 | 9.513746709564199
Other department - Receiving pickers
Other department Receiving picker 1 - VELAPHI (Capacity Current) | 00:00:00 | 0 |  | 00:00:23.099000 | 6.234076433121019
Other department Receiving picker 2 - KNKOLISA (Capacity Current) | 00:00:00 | 0 |  | 00:00:37.840000 | 15.59328461751919
Other department Receiving picker 3 - RASTA (Capacity Current) | 00:00:00 | 0 |  | 00:00:00 | 0
Other department Receiving picker [NAME] (Capacity Current) | 00:00:00 | 0 |  | 00:01:11.729000 | 22.1033422081842
November 12 | Nov 12 Morning monthly orders 09:30 - 12:00 |  |  | Nov 12 Afternoon monthly orders 14:00 - Finish
Dailies | Average time per line | Average lines per hour |  | Average time per line | Average lines per hour
Dailies GSA Picker 1 - Isaac Maja (GSA Current) | 00:02:05.343000 | 18.73657027825045 |  | 00:02:07.927000 | 18.08384491100069
Dailies Capactity Picker 2 - JIMMYM (Capacity Current) | 00:02:09.385000 | 28.94875138835131 |  | 00:02:05.052000 | 28.95162927014612
Dailies Capactity Picker 3 - JONNYW (Capacity Current) | 00:01:05.120000 | 9.258731991497617 |  | 00:01:27.421000 | 6.592780187392272
Dailies Capactity Picker [NAME] (Temp Contract Ended) | 00:01:13.763000 | 7.830937222438507 |  | 00:01:26.985000 | 6.622294420841579
Dailies Capactity Picker 5 - ROBERTR (Capacity Current) | 00:00:57.032000 | 10.19924906391349 |  | 00:01:14.634000 | 7.764997653043528
Dailies Capactity Picker 6 - TAKALANI (Capacity. Contract Ended) | 00:02:20.549000 | 25.75770673513701 |  | 00:02:23.119000 | 25.26039752732922
Other department - Bulk pickers
Other department Bulk picker 1 - SAMUELM (GSA) | 00:00:22.810000 | 6.312985571587125 |  | 00:00:25.360000 | 5.678233438485804
Other department Bulk picker [NAME] (GSA) | 00:00:33.003000 | 17.83532667815074 |  | 00:00:00 | 0
Other department Bulk picker 3 - GEORGESS (GSA) | 00:02:07.983000 | 18.77510833449309 |  | 00:01:50.353000 | 24.05905685398057
Other department Bulk picker [NAME] (GSA) | 00:00:44.394000 | 13.32533106147056 |  | 00:00:50.194000 | 47.01201568896507
Other department Bulk picker 5 - MANDISIM (Capacity) | 00:00:46.902000 | 12.75945641447749 |  | 00:01:49.148000 | 23.05338361015581
Other department Bulk picker [NAME] (Capacity. Contract Ended) | 00:02:16.084000 | 26.57529920831718 |  | 00:01:22.782000 | 16.64433266757299
Other department Bulk picker [NAME] (GSA) | 00:01:06.114000 | 8.821330961313597 |  | 00:01:19.129000 | 16.41297888834886
Other department - Receiving pickers
Other department Receiving picker 1 - VELAPHI (Capacity Current) | 00:00:00 | 0 |  | 00:01:14.649000 | 30.59900720752165
Other department Receiving picker 2 - KNKOLISA (Capacity Current) | 00:00:00 | 0 |  | 00:02:47.952000 | 22.47257753192022
Other department Receiving picker 3 - RASTA (Capacity Current) | 00:00:00 | 0 |  | 00:00:54.590000 | 10.57939146822618
Other department Receiving picker [NAME] (Capacity Current) | 00:00:00 | 0 |  | 00:01:35.055000 | 26.22727765036824
December 12 | Dec 12 Morning monthly orders 09:30 - 12:00 |  |  | Dec 12 Afternoon monthly orders 14:00 - Finish
Dailies | Average time per line | Average lines per hour |  | Average time per line | Average lines per hour
Dailies GSA Picker 1 - Isaac Maja (GSA Current) | 00:02:32.120000 | 15.85519241836144 |  | 00:02:27.923000 | 17.14166869137307
Dailies Capactity Picker 2 - JIMMYM (Capacity Current) | 00:01:58.750000 | 32.29240507773593 |  | 00:01:38.622000 | 23.48823776176473
Dailies Capactity Picker 3 - JONNYW (Capacity Current) | 00:02:34.270000 | 23.53516970736331 |  | 00:02:50.883000 | 21.2257063031668
Dailies Capactity Picker [NAME] (Temp Contract Ended) | 00:02:54.240000 | 21.19667982017957 |  | 00:02:20.168000 | 16.47024017254938
Dailies Capactity Picker 5 - ROBERTR (Capacity Current) | 00:02:30.363000 | 25.0439869453015 |  | 00:02:04.566000 | 18.55275465088822
Dailies Capactity Picker 6 - TAKALANI (Capacity. Contract Ended) | 00:02:31.435000 | 25.56194603104692 |  | 00:02:15.359000 | 26.93592752910404
Other department - Bulk pickers
Other department Bulk picker 1 - SAMUELM (GSA) | 00:00:36.571000 | 16.2 |  | 00:00:00 | 0
Other department Bulk picker [NAME] (GSA) | 00:01:00.897000 | 21.64281787461663 |  | 00:00:37.276000 | 15.47434834415995
Other department Bulk picker 3 - GEORGESS (GSA) | 00:08:21.196000 | 16.52978370140434 |  | 00:00:00 | 0
Other department Bulk picker [NAME] (GSA) | 00:00:52.946000 | 24.64560997789506 |  | 00:06:02.129000 | 11.03761645026234
Other department Bulk picker 5 - MANDISIM (Capacity) | 00:00:20.153000 | 7.145165012693283 |  | 00:01:45.811000 | 22.18738431511687
Other department Bulk picker [NAME] (Capacity. Contract Ended) | 00:01:45.007000 | 22.04472729538387 |  | 00:01:27.848000 | 15.23974589505833
Other department Bulk picker [NAME] (GSA) | 00:01:17.500000 | 17.32024347724052 |  | 00:00:47.645000 | 12.13620700449349
Other department - Receiving pickers
Other department Receiving picker 1 - VELAPHI (Capacity Current) | 00:00:28.937000 | 4.976355038195707 |  | 00:01:04.590000 | 20.50575006313049
Other department Receiving picker 2 - KNKOLISA (Capacity Current) | 00:00:00 | 0 |  | 00:02:05.316000 | 19.13870284922896
Other department Receiving picker 3 - RASTA (Capacity Current) | 00:00:00 | 0 |  | 00:00:26.504000 | 5.433070866141732
Other department Receiving picker [NAME] (Capacity Current) | 00:00:00 | 0 |  | 00:01:42.041000 | 24.04502891578775