Spreadsheet: 737562d1624469119-trying-to-create-formula-to-give-me-picking-receiving-efficiency-in-warehouse-receiving-report-2021
Sheet: PRTRANR43

 |  |  | PRSTYL | [NAME] | PRCASN05 |  |  | To
Date | User | Item | COUNT | TOTAL | TOTAL | Type |  | Location
20210618 | Employee A | 001471 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 004514 | 1 | 18 | 3 | Receive Case
20210618 | Employee A | 006947 | 1 | 200 | 1 | Receive Case
20210618 | Employee A | 007826 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 007848 | 1 | 30 | 1 | Receive Case
20210618 | Employee A | 007863 | 1 | 40 | 1 | Receive Case
20210618 | Employee A | 009003 | 1 | 200 | 2 | Receive Case
20210618 | Employee A | 010095 | 1 | 10 | 1 | Receive Case
20210618 | Employee A | 013596 | 1 | 13 | 6 | Receive Case
20210618 | Employee A | 013861 | 1 | 4 | 1 | Receive Case
20210618 | Employee A | 101124 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 101125 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 123347 | 1 | 25 | 1 | Receive Case
20210618 | Employee A | 148057 | 1 | 10 | 1 | Receive Case
20210618 | Employee A | 148841 | 1 | 12 | 1 | Receive Case
20210618 | Employee A | 149090 | 1 | 15 | 1 | Receive Case
20210618 | Employee A | 218099 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 218818 | 1 | 200 | 1 | Receive Case
20210618 | Employee A | 219679 | 1 | 35 | 1 | Receive Case
20210618 | Employee A | 219681 | 1 | 10 | 1 | Receive Case
20210618 | Employee A | 220961 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 226176 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 228487 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 228490 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 229445 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 259753 | 1 | 25 | 3 | Receive Case
20210618 | Employee A | 259754 | 1 | 65 | 7 | Receive Case
20210618 | Employee A | 260393 | 1 | 18 | 1 | Receive Case
20210618 | Employee A | 261940 | 1 | 4 | 4 | Receive Case
20210618 | Employee A | 339522 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 351589 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 355474 | 1 | 120 | 2 | Receive Case
20210618 | Employee A | 355558 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 362302 | 1 | 4 | 4 | Receive Case
20210618 | Employee A | 363004 | 1 | 4 | 4 | Receive Case
20210618 | Employee A | 363005 | 1 | 8 | 8 | Receive Case
20210618 | Employee A | 363043 | 1 | 12 | 12 | Receive Case
20210618 | Employee A | 363462 | 1 | 3 | 3 | Receive Case
20210618 | Employee A | 364044 | 1 | 4 | 4 | Receive Case
20210618 | Employee A | 366799 | 1 | 4 | 4 | Receive Case
20210618 | Employee A | 367509 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 372804 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 381421 | 1 | 10 | 1 | Receive Case
20210618 | Employee A | 381422 | 1 | 20 | 1 | Receive Case
20210618 | Employee A | 381539 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 381540 | 1 | 12 | 12 | Receive Case
20210618 | Employee A | 381585 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 386216 | 1 | 30 | 1 | Receive Case
20210618 | Employee A | 397083 | 1 | 4 | 1 | Receive Case
20210618 | Employee A | 397085 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 505920 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 638960 | 1 | 25 | 1 | Receive Case
20210618 | Employee A | 672523 | 1 | 63 | 2 | Receive Case
20210618 | Employee A | 720907 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 722194 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 722280 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 739879 | 1 | 2 | 2 | Receive Case
20210618 | Employee A | 760996 | 1 | 3 | 1 | Receive Case
20210618 | Employee A | 763764 | 1 | 6 | 2 | Receive Case
20210618 | Employee A | 775709 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 782532 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 786941 | 1 | 1 | 1 | Receive Case
20210618 | Employee A | 790461 | 1 | 2 | 1 | Receive Case
20210618 | Employee A | 798296 | 1 | 1 | 1 | Receive Case
20210618 | Employee B | 362620 | 1 | 3 | 3 | Receive Case
20210618 | Employee C | 009997 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 021090 | 1 | 144 | 2 | Receive Case
20210618 | Employee C | 021092 | 1 | 144 | 2 | Receive Case
20210618 | Employee C | 145298 | 1 | 2 | 1 | Receive Case
20210618 | Employee C | 148610 | 1 | 2 | 2 | Receive Case
20210618 | Employee C | 149495 | 1 | 25 | 2 | Receive Case
20210618 | Employee C | 217032 | 1 | 3 | 3 | Receive Case
20210618 | Employee C | 359548 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 365159 | 1 | 7 | 1 | Receive Case
20210618 | Employee C | 365161 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 369846 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 398047 | 1 | 2 | 2 | Receive Case
20210618 | Employee C | 779649 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 785719 | 1 | 1 | 1 | Receive Case
20210618 | Employee C | 796701 | 1 | 1 | 1 | Receive Case
20210618 | Employee D | 009213 | 1 | 120 | 1 | Receive Case
20210618 | Employee E | 003384 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 004116 | 1 | 15 | 1 | Receive Case
20210618 | Employee E | 004578 | 1 | 9 | 1 | Receive Case
20210618 | Employee E | 006806 | 1 | 4 | 1 | Receive Case
20210618 | Employee E | 007956 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 009205 | 1 | 12 | 1 | Receive Case
20210618 | Employee E | 009490 | 1 | 5 | 1 | Receive Case
20210618 | Employee E | 009494 | 1 | 80 | 1 | Receive Case
20210618 | Employee E | 009499 | 1 | 50 | 1 | Receive Case
20210618 | Employee E | 009501 | 1 | 35 | 1 | Receive Case
20210618 | Employee E | 009508 | 1 | 70 | 2 | Receive Case
20210618 | Employee E | 009568 | 1 | 25 | 2 | Receive Case
20210618 | Employee E | 009572 | 1 | 20 | 4 | Receive Case
20210618 | Employee E | 009575 | 1 | 10 | 1 | Receive Case
20210618 | Employee E | 010884 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 011814 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 011970 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 012819 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 013400 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 013512 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 013556 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 014060 | 1 | 20 | 2 | Receive Case
20210618 | Employee E | 014135 | 1 | 2 | 1 | Receive Case
20210618 | Employee E | 014202 | 1 | 10 | 1 | Receive Case
20210618 | Employee E | 014234 | 1 | 50 | 1 | Receive Case
20210618 | Employee E | 019033 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 021639 | 1 | 5 | 1 | Receive Case
20210618 | Employee E | 024709 | 1 | 24 | 1 | Receive Case
20210618 | Employee E | 024728 | 1 | 1500 | 6 | Receive Case
20210618 | Employee E | 024908 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 024944 | 1 | 4 | 1 | Receive Case
20210618 | Employee E | 027551 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 028718 | 1 | 240 | 6 | Receive Case
20210618 | Employee E | 028721 | 1 | 10 | 2 | Receive Case
20210618 | Employee E | 028987 | 1 | 75 | 1 | Receive Case
20210618 | Employee E | 029059 | 1 | 20 | 2 | Receive Case
20210618 | Employee E | 029060 | 1 | 50 | 1 | Receive Case
20210618 | Employee E | 029138 | 1 | 25 | 3 | Receive Case
20210618 | Employee E | 029264 | 1 | 10 | 1 | Receive Case
20210618 | Employee E | 061984 | 1 | 55 | 1 | Receive Case
20210618 | Employee E | 104582 | 1 | 4 | 1 | Receive Case
20210618 | Employee E | 105115 | 1 | 200 | 2 | Receive Case
20210618 | Employee E | 106721 | 1 | 500 | 2 | Receive Case
20210618 | Employee E | 106725 | 1 | 200 | 1 | Receive Case
20210618 | Employee E | 106729 | 1 | 525 | 2 | Receive Case
20210618 | Employee E | 106730 | 1 | 125 | 1 | Receive Case
20210618 | Employee E | 106731 | 1 | 75 | 1 | Receive Case
20210618 | Employee E | 106732 | 1 | 100 | 1 | Receive Case
20210618 | Employee E | 106733 | 1 | 150 | 1 | Receive Case
20210618 | Employee E | 106734 | 1 | 100 | 1 | Receive Case
20210618 | Employee E | 106737 | 1 | 100 | 1 | Receive Case
20210618 | Employee E | 106740 | 1 | 600 | 1 | Receive Case
20210618 | Employee E | 106741 | 1 | 900 | 6 | Receive Case
20210618 | Employee E | 106888 | 1 | 25 | 1 | Receive Case
20210618 | Employee E | 106889 | 1 | 50 | 2 | Receive Case
20210618 | Employee E | 106891 | 1 | 75 | 1 | Receive Case
20210618 | Employee E | 106895 | 1 | 125 | 1 | Receive Case
20210618 | Employee E | 110119 | 1 | 60 | 1 | Receive Case
20210618 | Employee E | 110316 | 1 | 76 | 1 | Receive Case
20210618 | Employee E | 113324 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 114419 | 1 | 30 | 3 | Receive Case
20210618 | Employee E | 114693 | 1 | 60 | 1 | Receive Case
20210618 | Employee E | 122205 | 1 | 250 | 25 | Receive Case
20210618 | Employee E | 122206 | 1 | 25 | 1 | Receive Case
20210618 | Employee E | 130247 | 1 | 45 | 1 | Receive Case
20210618 | Employee E | 130248 | 1 | 45 | 1 | Receive Case
20210618 | Employee E | 133443 | 1 | 50 | 2 | Receive Case
20210618 | Employee E | 136558 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 141698 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 142990 | 1 | 6 | 1 | Receive Case
20210618 | Employee E | 147567 | 1 | 30 | 6 | Receive Case
20210618 | Employee E | 148610 | 1 | 3 | 1 | Receive Case
20210618 | Employee E | 148611 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 148841 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 148857 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 148861 | 1 | 2 | 1 | Receive Case
20210618 | Employee E | 214193 | 1 | 15 | 15 | Receive Case
20210618 | Employee E | 214195 | 1 | 10 | 10 | Receive Case
20210618 | Employee E | 215983 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 222229 | 1 | 10 | 1 | Receive Case
20210618 | Employee E | 224035 | 1 | 50 | 5 | Receive Case
20210618 | Employee E | 224039 | 1 | 20 | 2 | Receive Case
20210618 | Employee E | 224763 | 1 | 3 | 3 | Receive Case
20210618 | Employee E | 258011 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 258849 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 263268 | 1 | 6 | 1 | Receive Case
20210618 | Employee E | 264161 | 1 | 8 | 1 | Receive Case
20210618 | Employee E | 271724 | 1 | 53 | 6 | Receive Case
20210618 | Employee E | 271730 | 1 | 60 | 2 | Receive Case
20210618 | Employee E | 271731 | 1 | 50 | 16 | Receive Case
20210618 | Employee E | 272682 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 275830 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 276375 | 1 | 2 | 1 | Receive Case
20210618 | Employee E | 277387 | 1 | 11 | 11 | Receive Case
20210618 | Employee E | 354411 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 356101 | 1 | 10 | 10 | Receive Case
20210618 | Employee E | 357814 | 1 | 25 | 25 | Receive Case
20210618 | Employee E | 359861 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 360489 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 360491 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 361456 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 362799 | 1 | 180 | 1 | Receive Case
20210618 | Employee E | 364225 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 365159 | 1 | 7 | 1 | Receive Case
20210618 | Employee E | 365161 | 1 | 6 | 1 | Receive Case
20210618 | Employee E | 365289 | 1 | 50 | 1 | Receive Case
20210618 | Employee E | 371246 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 375389 | 1 | 6 | 1 | Receive Case
20210618 | Employee E | 380976 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 381483 | 1 | 3 | 3 | Receive Case
20210618 | Employee E | 384138 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 385137 | 1 | 2 | 1 | Receive Case
20210618 | Employee E | 385321 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 385346 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 391791 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 392697 | 1 | 160 | 9 | Receive Case
20210618 | Employee E | 399522 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 621551 | 1 | 27 | 4 | Receive Case
20210618 | Employee E | 735657 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 790270 | 1 | 2 | 2 | Receive Case
20210618 | Employee E | 794083 | 1 | 3 | 3 | Receive Case
20210618 | Employee E | 795115 | 1 | 1 | 1 | Receive Case
20210618 | Employee E | 798279 | 1 | 1 | 1 | Receive Case