Spreadsheet: 725646d1616778070-return-each-occurrence-of-a-value-from-a-list-list-file-test
Sheet: WK1

# | Item No. | Item Description | Quantity | Status | [NAME] | Value | BatchNum | Warehouse Code | PrdDate | Admission Date | No of Cases | Case Weight | BBE | Admission | [NAME] | Weeks in storage | Storage cost | 2021-01-04 00:00:00
1 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101070 | home | 2020-10-16 00:00:00 | 2020-10-16 00:00:00 | 10 | 1 | 1999-12-31 00:00:00
2 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101071 | home | 2020-10-16 00:00:00 | 2020-10-16 00:00:00 | 10 | 1 | 36525
3 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101072 | away | 2020-10-16 00:00:00 | 2020-10-16 00:00:00 | 20 | 1 | 36525
4 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101073 | away | 2020-10-16 00:00:00 | 2020-10-16 00:00:00 | 70 | 1 | 36525
5 | APPLE001 | Diced [NAME] | 210 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101074 | away | 2020-10-16 00:00:00 | 2020-10-16 00:00:00 | 21 | 1 | 36525
6 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101079 | home | 2020-12-03 00:00:00 | 2020-03-12 00:00:00 | 10 | 1 | 36525
7 | APPLE001 | Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 10 | APPLE00101080 | home | 2020-12-03 00:00:00 | 2020-03-12 00:00:00 | 5 | 1 | 36525
27 | APPLE025 | 10mm Diced [NAME], 10 Kg | 700 | 0 | 1999-12-31 00:00:00 | 5 | APPLE02500145 | home | 2020-12-11 00:00:00 | 2020-11-12 00:00:00 | 3 | 1 | 36525
28 | APPLE025 | 10mm Diced [NAME], 10 Kg | 700 | 0 | 1999-12-31 00:00:00 | 5 | APPLE02500146 | home | 2020-12-11 00:00:00 | 2020-11-12 00:00:00 | 4 | 1 | 36525
29 | APPLE025 | 10mm Diced [NAME], 10 Kg | 240 | 0 | 1999-12-31 00:00:00 | 5 | APPLE02500167 | away | 2020-12-11 00:00:00 | 2020-11-12 00:00:00 | 24 | 1 | 36525
30 | APPLE033 | 20mm Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 7.5 | APPLE03300001 | away | 2020-07-10 00:00:00 | 2020-10-07 00:00:00 | 2 | 1 | 36525
31 | APPLE033 | 20mm Diced [NAME] | 700 | 0 | 1999-12-31 00:00:00 | 7.5 | APPLE03300003 | home | 2020-07-10 00:00:00 | 2020-10-07 00:00:00 | 4 | 1 | 36525
32 | APPLE033 | 20mm Diced [NAME] | 620 | 0 | 1999-12-31 00:00:00 | 7.5 | APPLE03300005 | home | 2020-07-10 00:00:00 | 2020-10-07 00:00:00 | 62 | 1 | 36525
33 | APPLE033 | 20mm Diced [NAME] | 210 | 0 | 1999-12-31 00:00:00 | 7.5 | APPLE03300008 | away | 2020-07-10 00:00:00 | 2020-10-07 00:00:00 | 21 | 1 | 36525
34 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000094 | away | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 20 | 1 | 36525
35 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000095 | home | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 20 | 1 | 36525
36 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000097 | home | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 15 | 1 | 36525
37 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000098 | home | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 3 | 1 | 36525
38 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000102 | home | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 6 | 1 | 36525
39 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000110 | home | 2020-04-02 00:00:00 | 2020-02-04 00:00:00 | 8 | 1 | 36525
53 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000150 | away | 2020-09-07 00:00:00 | 2020-07-09 00:00:00 | 7 | 1 | 36525
54 | APPLE940 | Sliced Italian Apple - | 540 | 0 | 1999-12-31 00:00:00 | 12 | APPLE94000151 | away | 2020-09-07 00:00:00 | 2020-07-09 00:00:00 | 1 | 1 | 36525