Spreadsheet: 874138d1720708979-combine-filter-with-multiple-sort-on-alphabetical-numercial-order-yeti2201-stock-overview-test-sheet
Sheet: All incoming goods

 | Lot | Cask number | Location | Supplier | Product | length | category | Original quantity | Current quantity | Category Ranking
 | 5082 | 10600686-060 | Wharehouse 2 | A | P.H. | 32/34 | 8+ | 150 | 0 |  |  | 0
 | 5630 | 19690363-049 | Wharehouse 2 | A | P.C. | 19/21 | 7-10 | 384 | 184 |  |  |  | Category Ranking
 | 5637 | 1924927-002 | Wharehouse 2 | A | P.H. | 43/46 | 8+ | 204 | 144 |  |  |  | 10+
 | 5694 | 35000080-024 | Wharehouse 2 | A | P.A. | 24/26 | 10+ | 372 | 228 |  |  |  | 8+
 | 5694 | 35000080-025 | Wharehouse 2 | A | P.A. | 24/26 | 10+ | 800 | 800 |  |  |  | 7-14
 | 5694 | 35000080-026 | Wharehouse 1 | A | P.A. | 24/26 | 10+ | 800 | 800 |  |  |  | 7-10
 | 5703 | 557528 | Wharehouse 2 | B | P.A. | 22/24 | 7-10 | 480 | 380
 | 5711 | 557597 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700
 | 5714 | 557649 | Wharehouse 2 | B | P.A. | 19/21 | 10+ | 700 | 500
 | 5714 | 557650 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700
 | 5714 | 557651 | Wharehouse 2 | B | P.A. | 20/22 | 7-10 | 376 | 0
 | 5716 | 557672 | Wharehouse 2 | B | P.A. | 21/23 | 7-10 | 528 | 200
 | 5716 | 557676 | Wharehouse 2 | B | P.A. | 22/24 | 10+ | 224 | 24
 | 5718 | 39690944-031 | Wharehouse 1 | A | P.C. | 19/21 | 7-10 | 500 | 500
 | 5719 | 557714 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 368 | 0
 | 5719 | 557721 | Wharehouse 2 | B | P.A. | 22/24 | 10+ | 700 | 700
 | 5721 | 557769 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700
 | 5721 | 557770 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700
 | 5722 | 80724-2 | Wharehouse 2 | B | P.C. | 20/22 | 7-10 | 700 | 0
 | 5726 | 1936392-003 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 159 | 0
 | 5726 | 1936392-009 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5726 | 1936392-010 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5726 | 1936392-011 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5726 | 1936392-012 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5726 | 1936392-013 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5726 | 1936392-014 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5730 | 557789 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 700 | 0
 | 5730 | 557791 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 0
 | 5730 | 557794 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 80 | 0
 | 5730 | 557795 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 0
 | 5730 | 557796 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700
 | 5730 | 557797 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700
 | 5731 | 81372-1 | Wharehouse 2 | B | P.C. | 20/22 | 7-10 | 700 | 700
 | 5731 | 81372-10 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 112 | 0
 | 5731 | 81372-2 | Wharehouse 1 | B | P.C. | 20/22 | 7-10 | 700 | 700
 | 5731 | 81372-9 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 0
 | 5732 | 45000209-001 | Wharehouse 2 | A | P.A. | 18/20 | 10+ | 900 | 0
 | 5732 | 45000209-002 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 5732 | 45000209-003 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 5732 | 45000209-007 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 408 | 0
 | 5732 | 45000209-016 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 5732 | 45000209-017 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 5733 | 557803 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 700 | 380
 | 5733 | 557804 | Wharehouse 2 | B | P.A. | 19/21 | 7-14 | 600 | 400
 | 5733 | 557805 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 0
 | 5733 | 557806 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 0
 | 5733 | 557807 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 368
 | 5733 | 557808 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 0
 | 5733 | 557809 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 0
 | 5734 | 1943307-001 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 0
 | 5734 | 1943307-002 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 0
 | 5734 | 1943307-004 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5734 | 1943307-005 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 51
 | 5734 | 1943307-006 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5734 | 1943307-007 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 0
 | 5734 | 1943307-008 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 0
 | 5734 | 1943307-009 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5734 | 1943307-010 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 0
 | 5734 | 1943307-011 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5734 | 1943307-012 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270
 | 5735 | 49690240-001 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-002 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-003 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-004 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-005 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-006 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 5735 | 49690240-007 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 0
 | 5735 | 49690240-008 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 0
 | 5735 | 49690240-009 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 200 | 0
 | 0001 | 45000315-001 | Wharehouse 2 | A | P.A. | 18/20 | 10+ | 900 | 900
 | 0001 | 45000315-002 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0001 | 45000315-003 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0001 | 45000315-004 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0001 | 45000315-005 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0001 | 45000315-006 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-007 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-008 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0001 | 45000315-009 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-010 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-011 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-012 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-013 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-014 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-015 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0001 | 45000315-016 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-017 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 580
 | 0001 | 45000315-018 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 0
 | 0001 | 45000315-019 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-020 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-021 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-022 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-023 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-024 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-026 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-027 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-028 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-029 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-030 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0001 | 45000315-031 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0002 | 557858 | Wharehouse 2 | B | P.A. | 20/22 | 7-10 | 700 | 700
 | 0002 | 557859 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0002 | 557860 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0002 | 557861 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0002 | 557862 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700
 | 0002 | 557863 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 0
 | 0002 | 557864 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 0
 | 0003 | 61301 | Wharehouse 2 | A | P.A. | 18/20 | 10+ | 900 | 900
 | 0003 | 61302 | Wharehouse 1 | A | P.A. | 18/20 | 10+ | 900 | 900
 | 0003 | 61303 | Wharehouse 1 | A | P.A. | 18/20 | 10+ | 900 | 900
 | 0003 | 61304 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0003 | 61305 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 0
 | 0003 | 61307 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61308 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61309 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61310 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61311 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61312 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61313 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61314 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900
 | 0003 | 61315 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61316 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61317 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61318 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61319 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61320 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61321 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61322 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61323 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61324 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61325 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61326 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61327 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61328 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0003 | 61329 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 0
 | 0004 | 61330 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 0004 | 61331 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 0004 | 61332 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 0004 | 61333 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 360
 | 0004 | 61334 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500
 | 0004 | 61335 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 0
 | 0004 | 61336 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500
 | 0004 | 61337 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500
 | 0004 | 61338 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 0
 | 0004 | 61339 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 500
 | 0004 | 61340 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 500
 | 0005 | 83984-1 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 0
 | 0005 | 83984-2 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 0
 | 0005 | 83984-3 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0005 | 83984-4 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 0
 | 0005 | 83984-5 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0005 | 83984-6 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 0
 | 0005 | 83984-7 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0005 | 83984-8 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0005 | 83984-9 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0005 | 83984-10 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700
 | 0006-1 | 557906 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 700 | 700
 | 0006-2 | 557907 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700
 | 0006-2 | 557908 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700
 | 0006-3 | 557909 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0006-3 | 557910 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0006-3 | 557911 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0006-3 | 557912 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700
 | 0006-4 | 557913 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 700
 | 0006-4 | 557914 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 700
 | 0006-4 | 557915 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700
 | 0006-4 | 557916 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700
 | 0007-1 | 66401 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900
 | 0007-1 | 66402 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900
 | 0007-1 | 66403 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900
 | 0007-1 | 66404 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900
 | 0007-2 | 66405 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-2 | 66406 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-2 | 66407 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-2 | 66408 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-2 | 66409 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-2 | 66410 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66411 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66412 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66413 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66414 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66415 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820
 | 0007-3 | 66416 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 400
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0