Spreadsheet: 737227d1624287717-how-to-get-a-cell-to-return-a-value-from-a-list-below-the-table-kpi-data-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Picking | Putaway | Receipt | Relocate | Replen
 | USER_ID | SHIFT | CLIENT_ID | CODE PICK | DSTAMP | TOTAL CASES | TASK QTY | FULL PALLET | EACH QTY |  | Hours Per Day | Hours Per Day | Hours Per Day | Hours Per Day | Hours Per Day | AVG cases per hour | AVG pallets per hour
1 | Person 1 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 1980 | 19 | 11 | 628 | 9 |  |  |  |  | 0.3
2 | Person 2 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 1011 | 42 | 1 | 941 | 9
3 | Person 3 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 1472 | 11 | 11 | 0 | 9
4 | Person 4 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 553 | 24 | 1 | 403 | 9
5 | Person 5 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 2636 | 29 | 6 | 1077 | 9 |  |  |  | 1.1
6 | Person 6 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 3085 | 46 | 9 | 1505 | 9
7 | Person 7 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 3023 | 70 | 16 | 567 | 9
8 | Person 8 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 2129 | 26 | 8 | 909 | 9
9 | Person 9 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 6054 | 39 | 26 | 1674 | 9
10 | Person 10 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 4300 | 28 | 14 | 1066 | 9
11 | Person 11 | S/BOURNE | WESSAN | Pick | 19/06/2021 | 288 | 3 | 0 | 288 | 9
12
 |  |  |  |  | Totals:
 | USER_ID | SHIFT | CLIENT_ID | CODE PUTAWAY | DSTAMP | TOTAL CASES | TASK QTY | FULL PALLET | EACH QTY |  | Hours Per Day | AVG cases per hour | AVG pallets per hour
1 | Person 8 | S/BOURNE | WESSAN | Putaway | 19/06/2021 | 920 | 6 | 6 | 0 | 9
2 | Person 9 | S/BOURNE | WESSAN | Putaway | 19/06/2021 | 3492 | 20 | 20 | 0 | 9
3 | Person 10 | S/BOURNE | WESSAN | Putaway | 19/06/2021 | 4512 | 27 | 27 | 0 | 9
4
5
6
7
8
9
10
 | USER_ID | SHIFT | CLIENT_ID | CODE RECEIPT | DSTAMP | TOTAL CASES | TASK QTY | FULL PALLET | EACH QTY |  | Hours Per Day | AVG cases per hour | AVG pallets per hour
1 | Person 13 | S/BOURNE | WESSAN | Receipt | 19/06/2021 | 8197 | 52 | 52 | 0 | 9
2 |  |  |  |  |  |  |  |  |  | 9
3 |  |  |  |  |  |  |  |  |  | 9
4 |  |  |  |  |  |  |  |  |  | 9
5 |  |  |  |  |  |  |  |  |  | 9
6 |  |  |  |  |  |  |  |  |  | 9
7 |  |  |  |  |  |  |  |  |  | 9
8 |  |  |  |  |  |  |  |  |  | 9
9 |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  | 9
 | USER_ID | SHIFT | CLIENT_ID | CODE RELOCATE | DSTAMP | TOTAL CASES | TASK QTY | FULL PALLET | EACH QTY |  | Hours Per Day | AVG cases per hour | AVG pallets per hour
1 | Person 5 | S/BOURNE | WESSAN | Relocate | 19/06/2021 | 901 | 13 | 13 | 0 | 9
2 | Person 7 | S/BOURNE | WESSAN | Relocate | 19/06/2021 | 140 | 1 | 1 | 0 | 9
3 | Person 10 | S/BOURNE | WESSAN | Relocate | 19/06/2021 | 2 | 1 | 1 | 0 | 9
4
5
6
7
8
9
10
 | USER_ID | SHIFT | CLIENT_ID | CODE REPLENISH | DSTAMP | TOTAL CASES | TASK QTY | FULL PALLET | EACH QTY |  | Hours Per Day | AVG cases per hour | AVG pallets per hour
1 | Person 1 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 630 | 3 | 3 | 0 | 9
2 | Person 2 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 381 | 3 | 3 | 0 | 9
3 | Person 4 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 198 | 2 | 2 | 0 | 9
4 | Person 5 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 430 | 3 | 3 | 0 | 9
5 | Person 12 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 1517 | 8 | 8 | 0 | 9
6 | Person 7 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 989 | 9 | 9 | 0 | 9
7 | Person 8 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 578 | 5 | 5 | 0 | 9
8 | Person 9 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 809 | 1 | 1 | 0 | 9
9 | Person 10 | S/BOURNE | WESSAN | Replenish | 19/06/2021 | 560 | 2 | 2 | 0 | 9
10