Spreadsheet: 41277d1239770285-find-value-from-multiple-tables-inventory-bar-v8
Sheet: Tracker

 | Name | 2009-03-24 00:00:00 |  | 2009-03-25 00:00:00 |  | 2009-03-26 00:00:00 |  | 2009-03-27 00:00:00 |  | 2009-03-30 00:00:00 |  | 2009-03-31 00:00:00 |  | 2009-04-01 00:00:00 |  | 2009-04-02 00:00:00 |  | 2009-04-03 00:00:00 |  | 2009-04-06 00:00:00 |  | 2009-04-07 00:00:00 |  | 2009-04-08 00:00:00 |  | 2009-04-09 00:00:00 |  | 2009-04-10 00:00:00 |  | 2009-04-11 00:00:00 |  | 2009-04-13 00:00:00 |  | 2009-04-14 00:00:00 |  | 2009-04-15 00:00:00
Beer
 | Stella
Total OZ |  | 1254.4 |  | 1724.8 |  | 1624 |  | 1556.8 |  | 1523.2 |  | 1254.4 |  | 1153.6 |  | 1859.2 |  | 1848 |  | 1568 |  | 1108.8 |  | 1108.8 |  | 1064 |  | 1332.8 |  | 1164.8 |  | 1120 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 1 | -2 | 1 | -2 | 1 | -2 | 1 |  | 1 |  | 1 | -5 | 1 | -6 | 1 | -6
Storage Area Unopened Cases |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 3 |  | 3 |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
Mini - Bar Bottles |  | 8 |  | 2 |  | 16 |  | 11 |  | 34 |  | 34 |  | 25 |  | 46 |  | 45 |  | 45 |  | 45 |  | 45 |  | 46 |  | 46 |  | 46 |  | 48
Cafe Bottles |  | 8 |  | 8 |  | 6 |  |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 2 |  | 3 |  | 3 |  | 3 |  | 7 |  | 8 |  | 8
Walk In Freezer Opened |  |  |  | 1 |  | 1 | -21 | 1 | -16 | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -9 | 1 | -9 | 1 | -19 | 1 | -21 | 1 | -21 | 1 | -21 | 1 |  | 1 | -16 | 1 | -4
Walk In [NAME] |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Hoegaarden
Total OZ |  | 1344 |  | 1523.2 |  | 1478.4 |  | 1702.4 |  | 1355.2 |  | 1400 |  | 1601.6 |  | 1612.8 |  | 1612.8 |  | 1624 |  | 1624 |  | 1624 |  | 1724.8 |  | 1624 |  | 1579.2 |  | 1299.2 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 |  | 1 | -9 | 1 | -9
Storage Area Unopened Cases |  | 4 |  | 4 |  | 3 |  | 3 | -21 | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
Mini - Bar Bottles |  | 24 |  | 40 |  | 37 |  | 33 |  | 16 |  | 32 |  | 32 |  | 36 |  | 36 |  | 36 |  | 35 |  | 35 |  | 36 |  | 36 |  | 35 |  | 35
Cafe Bottles |  |  |  |  |  | 7 |  | 7 |  | 5 |  | 5 |  | 5 |  | 6 |  | 6 |  | 6 |  | 7 |  | 7 |  | 7 |  | 7 |  | 6 |  | 7
Walk In Freezer Opened |  |  |  |  |  |  |  |  |  | 1 | -12 |  |  | 1 | -6 | 1 | -10 | 1 | -10 | 1 | -9 | 1 | -9 | 1 | -9 | 1 | -9 | 1 | -9 | 1 | -11 | 1 | -22
Walk In [NAME] |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Chimay
Total OZ |  | 1680 |  | 2060.8 |  | 2060.8 |  | 2060.8 |  | 2004.8 |  | 2004.8 |  | 2004.8 |  | 1691.2 |  | 1691.2 |  | 1545.6 |  | 1545.6 |  | 1556.8 |  | 1545.6 |  | 1545.6 |  | 1545.6 |  | 1545.6 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0
Storage Area Unopened Cases |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
Mini - Bar Bottles |  | 6 |  | 6 |  | 6 |  | 6 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
Cafe Bottles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
Walk In Freezer Opened |  |  |  | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -16 | 1 | -16 | 1 | -16 | 1 | -20 | 1 | -20 | 1 | -11 | 1 | -11 | 1 | -10 | 1 | -11 | 1 | -11 | 1 | -14 | 1 | -14
Walk In [NAME] |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | [NAME]
Total OZ |  | 1560 |  | 2400 |  | 2148 |  | 2052 |  | 2256 |  | 1992 |  | 1992 |  | 1788 |  | 1776 |  | 1764 |  | 1932 |  | 1836 |  | 1824 |  | 1800 |  | 1812 |  | 1812 |  | 0 |  | 0
Storage Area Opened Cases |  | 0
Storage Area Unopened Cases |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
Mini - Bar Bottles |  | 26 |  | 48 |  | 42 |  | 34 |  | 36 |  | 38 |  | 38 |  | 36 |  | 36 |  | 36 |  | 36 |  | 36 |  | 35 |  | 34 |  | 35 |  | 35
Cafe Bottles |  | 8 |  | 8 |  | 7 |  | 7 |  | 8 |  | 8 |  | 8 |  | 8 |  | 7 |  |  |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
Walk In Freezer Opened |  |  |  |  |  | 1 | -14 | 1 | -14 | 1 |  | 1 |  | 1 |  | 1 | -15 | 1 | -15 | 1 | -9 | 1 | -3 | 1 | -11 | 1 | -11 | 1 | -12 | 1 | -12 | 1 | -12
Walk In [NAME] |  |  |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | Amstel Light
Total OZ |  | 1584 |  | 3264 |  | 3228 |  | 3732 |  | 3348 |  | 3348 |  | 3348 |  | 3468 |  | 3468 |  | 2664 |  | 2748 |  | 2736 |  | 2928 |  | 2856 |  | 2652 |  | 2544 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -7 | 1 | -7
Storage Area Unopened Cases |  | 3 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 7 |  | 7 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
Mini - Bar Bottles |  | 52 |  | 72 |  | 70 |  | 71 |  | 72 |  | 72 |  | 72 |  | 80 |  | 79 |  | 82 |  | 82 |  | 82 |  | 80 |  | 77 |  | 77 |  | 77
Cafe Bottles |  | 8 |  | 8 |  | 7 |  |  |  | 9 |  | 9 |  | 8 |  | 7 |  | 8 |  |  |  | 7 |  | 6 |  | 5 |  | 8 |  | 7 |  | 7
Walk In Freezer Opened |  |  |  |  |  |  |  |  |  | 1 | -18 | 1 | -18 | 1 | -17 | 1 | -10 | 1 | -10 |  |  |  |  |  |  | 1 | -2 | 1 | -8 | 1 | -7 | 1 | -16
Walk In [NAME] |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1
 | [NAME]
Total OZ |  | 1176 |  | 1380 |  | 1476 |  | 1476 |  | 1056 |  | 720 |  | 756 |  | 756 |  | 876 |  | 252 |  | 1740 |  | 1740 |  | 1740 |  | 1716 |  | 1668 |  | 1548 |  | 0 |  | 0
Storage Area Opened Cases |  | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -21 | 1 | -24
Storage Area Unopened Cases |  | 2 |  | 2 |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
Mini - Bar Bottles |  | 16 |  | 19 |  | 22 |  | 22 |  | 28 |  | 24 |  | 32 |  | 36 |  | 23 |  | 9 |  | 9 |  | 9 |  | 9 |  | 8 |  | 7
Cafe Bottles |  | 7 |  | 7 |  | 8 |  | 8 |  | 7 |  | 7 |  | 4 |  | 8 |  | 7 |  | 9 |  | 9 |  | 9 |  | 9 |  | 8 |  | 9 |  | 9
Walk In Freezer Opened |  |  |  | 1 | -10 | 1 | -6 | 1 | -6 | 1 | -22 | 1 | -22 |  |  |  |  | 1 | -8 |  |  | 1 | -20 | 1 | -20 | 1 | -20 | 1 | -20
Walk In [NAME] |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | Fat Tire
Total OZ |  | 1920 |  | 2052 |  | 1788 |  | 1728 |  | 1296 |  | 1296 |  | 1308 |  | 1308 |  | 1308 |  | 1296 |  | 1284 |  | 1260 |  | 1356 |  | 1248 |  | 1200 |  | 1200 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -4
Storage Area Unopened Cases |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
Mini - Bar Bottles |  |  |  | 11 |  | 12 |  | 11 |  | 20 |  | 20 |  | 22 |  | 16 |  | 16 |  | 16 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 18
Cafe Bottles |  | 16 |  | 16 |  | 17 |  | 13 |  | 11 |  | 11 |  | 7 |  | 7 |  | 7 |  | 9 |  | 8 |  | 9 |  | 17 |  | 13 |  | 14 |  | 14
Walk In Freezer Opened |  | 1 |  | 1 |  |  |  |  |  | 1 | -19 | 1 | -19 | 1 | -16 | 1 | -4 | 1 | -10 | 1 | -13 | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -19
Walk In [NAME] |  | 1 | -18 | 1 | -18 | 1 | -20 | 1 | -20 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1
 | Honkers Ale
Total OZ |  | 1236 |  | 1512 |  | 1608 |  | 1536 |  | 1836 |  | 1848 |  | 1836 |  | 1788 |  | 1776 |  | 1788 |  | 1584 |  | 1872 |  | 1752 |  | 1848 |  | 1836 |  | 1824 |  | 0 |  | 0
Storage Area Opened Cases |  | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8
Storage Area Unopened Cases |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
Mini - Bar Bottles |  |  |  | 24 |  | 22 |  | 27 |  | 36 |  | 37 |  | 37 |  | 35 |  | 35 |  | 36 |  | 18 |  | 36 |  | 35 |  | 34 |  | 34 |  | 34
Cafe Bottles |  | 15 |  | 14 |  | 12 |  | 13 |  | 11 |  | 11 |  | 10 |  | 8 |  | 7 |  | 7 |  | 7 |  | 13 |  | 8 |  | 9 |  | 8 |  | 8
Walk In Freezer Opened |  |  |  |  |  | 1 | -12 |  |  | 1 | -6 | 1 | -6 | 1 | -6 | 1 | -6 | 1 | -6 | 1 | -6 | 1 | -5 | 1 | -5 | 1 | -9 | 1 | -1 | 1 | -1 | 1 | -2
Walk In [NAME]
 | 312
Total OZ |  | 1536 |  | 1884 |  | 1860 |  | 1764 |  | 1692 |  | 1692 |  | 5664 |  | 1728 |  | 1728 |  | 1728 |  | 1668 |  | 1668 |  | 1728 |  | 1272 |  | 1272 |  | 1584 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 1 | -18 | 1 | -18 | 1 | -18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | -3 | 1 | -3 | 1 | -3
Storage Area Unopened Cases |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 2 |  | 2 |  | 2
Mini - Bar Bottles |  | 16 |  | 16 |  | 16 |  | 11 |  | 27 |  | 27 |  |  |  | 34 |  | 34 |  | 36 |  | 32 |  | 32 |  | 36 |  | 35 |  | 35 |  | 35
Cafe Bottles |  | 16 |  | 30 |  | 28 |  | 25 |  | 12 |  | 12 |  | 8 |  | 8 |  | 8 |  | 8 |  | 7 |  | 7 |  | 10 |  | 2 |  | 2 |  | 8
Walk In Freezer Opened |  |  |  | 1 | -15 | 1 | -15 | 1 | -15 | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -17 | 1 | -18 | 1 | -20 | 1 | -20 | 1 | -20 | 1 | -22 |  |  |  |  | 1 | -4
Walk In [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | [NAME]
Total OZ |  | 4128 |  | 10704 |  | 9372 |  | 7716 |  | 6216 |  | 6216 |  | 5664 |  | 4236 |  | 4116 |  | 1944 |  | 1884 |  | 8496 |  | 8160 |  | 7080 |  | 6396 |  | 4860 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0
Storage Area Unopened Cases |  | 6 |  | 31 |  | 26 |  | 23 |  | 16 |  | 16 |  | 14 |  | 9 |  | 9 |  | 1 |  | 1 |  | 25 |  | 24 |  | 20 |  | 16 |  | 11
Mini - Bar Bottles |  | 80 |  | 52 |  | 62 |  | 82 |  | 88 |  | 88 |  | 88 |  | 101 |  | 88 |  | 98 |  | 98 |  | 96 |  | 96 |  | 75 |  | 92 |  | 93
Cafe Bottles |  |  |  |  |  | 23 |  | 9 |  | 27 |  | 27 |  | 29 |  | 22 |  | 25 |  | 30 |  | 30 |  | 7 |  | 8 |  | 22 |  | 37 |  | 32
Walk In Freezer Opened |  | 0 |  | 0 |  |  |  |  |  | 1 | -5 | 1 | -5 | 1 | -5 | 1 | -6 | 1 | -10 | 1 | -14 | 1 | -19 | 1 | -19 |  |  | 1 | -11 | 1 | -4 | 1 | -8
Walk In [NAME] |  | 5 |  | 4 |  | 3 |  |  |  | 3 |  | 3 |  | 5 |  | 5 |  | 4 |  | 3 |  | 3 |  | 3 |  | 4 |  | 3 |  | 3 |  | 5
 | [NAME] |  |  |  |  |  |  | 5
Total OZ |  | 2304 |  | 2280 |  | 2280 |  | 2280 |  | 2208 |  | 2232 |  | 2172 |  | 2052 |  | 2004 |  | 1980 |  | 1740 |  | 1896 |  | 1968 |  | 1884 |  | 1884 |  | 1776 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 1 | -2 | 1 | -2 | 1 | -2 | 1 | -2 | 1 | -2 | 1 | -2 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -13 | 1 | -13 | 1 | -14
Storage Area Unopened Cases |  | 7 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
Mini - Bar Bottles |  |  |  |  |  |  |  |  |  | 8 |  | 10 |  | 6 |  | 18 |  | 14 |  | 19 |  |  |  | 17 |  | 19 |  | 17 |  | 17 |  | 13
Cafe Bottles |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 5 |  | 9 |  | 9 |  | 5
Walk In Freezer Opened |  | 0 |  | 0 |  |  |  |  |  | 1 | -15 | 1 | -15 | 1 | -15 | 1 | -6 | 1 | -12 | 1 | -19 | 1 | -20
Walk In [NAME] |  | 1 |  | 1 |  | 1 |  | 1
 | [NAME]
Total OZ |  | 5136 |  | 4680 |  | 4992 |  | 4872 |  | 4668 |  | 4128 |  | 4140 |  | 3732 |  | 3696 |  | 2868 |  | 8892 |  | 8796 |  | 8796 |  | 8592 |  | 8352 |  | 7764 |  | 0 |  | 0
Storage Area Opened Cases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -6 | 1 | -4 | 1 | -6
Storage Area Unopened Cases |  | 10 |  | 10 |  | 10 |  | 10 |  | 9 |  | 9 |  | 9 |  | 8 |  | 8 |  | 5 |  | 25 |  | 25 |  | 25 |  | 24 |  | 23 |  | 21
Mini - Bar Bottles |  | 52 |  | 36 |  | 64 |  | 61 |  | 85 |  | 88 |  | 88 |  | 103 |  | 100 |  | 82 |  | 98 |  | 90 |  | 90 |  | 97 |  | 93 |  | 100
Cafe Bottles |  | 16 |  | 18 |  | 16 |  | 9 |  | 12 |  | 12 |  | 13 |  | 15 |  | 15 |  | 16 |  | 21 |  | 21 |  | 22 |  | 12 |  | 18 |  | 17
Walk In Freezer Opened |  |  |  |  |  |  |  |  |  | 2 | -20 | 2 | -20 | 2 | -20 | 1 | -15 | 1 | -23 | 1 | -3 | 1 | -2 | 1 | -2 | 1 | -3 | 1 | -11 | 1 | -11 | 1 | -16
Walk In [NAME] |  | 5 |  | 4 |  | 4 |  | 4 |  | 2 |  | 2 |  | 2 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | Corona
Total OZ |  | 2160 |  | 2160 |  | 2208 |  | 2376 |  | 2052 |  | 1764 |  | 1680 |  | 1656 |  | 1860 |  | 1404 |  | 1356 |  | 2976 |  | 2580 |  | 2484 |  | 2244 |  | 2244 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -5 | 1 | -5 | 1 | -5
Storage Area Unopened Cases |  | 6 |  | 6 |  | 5 |  | 5 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 2 |  | 2 |  | 7 |  | 6 |  | 5 |  | 4 |  | 4
Mini - Bar Bottles |  | 12 |  | 12 |  | 16 |  | 30 |  | 39 |  | 39 |  | 32 |  | 36 |  | 45 |  | 54 |  | 53 |  | 60 |  | 57 |  | 60 |  | 60 |  | 60
Cafe Bottles |  |  |  |  |  |  |  |  |  | 6 |  | 6 |  | 6 |  |  |  | 8 |  | 11 |  | 11 |  | 8 |  | 8 |  | 8 |  | 12 |  | 12
Walk In Freezer Opened |  | 0 |  | 0 |  |  |  |  |  | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -20 | 1 | -23 | 1 | -12 | 1 | -18
Walk In [NAME] |  | 1 |  | 1 |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 2 |  | 2 |  | 2 |  | 1 |  | 1 |  | 2 |  | 2 |  | 2
 | Heineken
Total OZ |  | 2664 |  | 2676 |  | 3060 |  | 2580 |  | 2124 |  | 1836 |  | 1896 |  | 2112 |  | 2328 |  | 1284 |  | 1296 |  | 2616 |  | 2616 |  | 2844 |  | 2664 |  | 1992 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -5
Storage Area Unopened Cases |  | 6 |  | 6 |  | 8 |  | 6 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 2 |  | 2 |  | 7 |  | 7 |  | 7 |  | 7 |  | 4
Mini - Bar Bottles |  | 6 |  | 8 |  |  |  | 10 |  | 37 |  | 37 |  | 37 |  | 40 |  | 35 |  | 48 |  | 52 |  | 42 |  | 42 |  | 39 |  | 42 |  | 41
Cafe Bottles |  | 24 |  | 23 |  | 15 |  | 13 |  |  |  |  |  | 4 |  | 7 |  | 6 |  | 7 |  | 8 |  | 8 |  | 8 |  | 8 |  | 7 |  | 7
Walk In Freezer Opened |  | 0 |  | 0 |  |  |  |  |  | 1 | -4 | 1 | -4 | 1 | -3 | 2 | -15 | 3 | -15 | 1 | -20 |  |  |  |  |  |  | 1 | -2 | 1 | -19 | 1 | -21
Walk In [NAME] |  | 2 |  | 2 |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 1
 | Blue Moon
Total OZ |  | 3348 |  | 3396 |  | 3096 |  | 3084 |  | 2604 |  | 2604 |  | 2604 |  | 2640 |  | 2640 |  | 2520 |  | 2808 |  | 2568 |  | 2592 |  | 2688 |  | 2676 |  | 2304 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -3 | 1 | -4 | 1 | -4
Storage Area Unopened Cases |  | 8 |  | 8 |  | 8 |  | 8 |  | 7 |  | 7 |  | 7 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
Mini - Bar Bottles |  | 24 |  | 27 |  | 26 |  | 28 |  | 32 |  | 32 |  | 32 |  | 36 |  | 36 |  | 36 |  | 56 |  | 36 |  | 36 |  | 35 |  | 35 |  | 34
Cafe Bottles |  | 15 |  | 16 |  | 16 |  | 13 |  | 11 |  | 11 |  | 11 |  | 12 |  | 12 |  | 8 |  | 13 |  | 13 |  | 15 |  | 9 |  | 9 |  | 12
Walk In Freezer Opened |  |  |  |  |  |  |  |  |  | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -17 | 1 | -17 | 1 | -23 |  |  |  |  |  |  | 1 | -8 | 1 | -9 | 1 | -22
Walk In [NAME] |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 1
 | [NAME]
Total OZ |  | 960 |  | 2088 |  | 2208 |  | 2256 |  | 2160 |  | 1872 |  | 1884 |  | 1824 |  | 1896 |  | 1896 |  | 2028 |  | 2052 |  | 2052 |  | 2016 |  | 1968 |  | 1824 |  | 0 |  | 0
Storage Area Opened Cases |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -5 | 1 | -5 | 1 | -5
Storage Area Unopened Cases |  | 1 |  | 5 |  | 6 |  | 6 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 4 |  | 4 |  | 4
Mini - Bar Bottles |  | 48 |  | 46 |  | 40 |  | 44 |  | 26 |  | 26 |  | 27 |  | 20 |  | 22 |  | 22 |  | 25 |  | 27 |  | 27 |  | 27 |  | 24 |  | 26
Cafe Bottles |  | 8 |  | 8 |  |  |  |  |  | 4 |  | 4 |  | 4 |  |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 11 |  | 10 |  | 11
Walk In Freezer Opened |  |  |  |  |  |  |  |  |  | 1 | -18 | 1 | -18 | 1 | -18 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -4 | 1 | -4 | 1 | -4 | 1 | -9 | 1 | -9
Walk In [NAME] |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | Guiness
Total # of Cases
Storage Area Bottles |  | 143 |  | 155 |  | 155 |  | 155 |  | 143 |  | 143 |  | 143 |  | 143 |  | 143 |  | 143 |  | 143 |  | 143 |  | 143 |  | 136 |  | 135 |  | 127
Mini - Bar Bottles |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  | 7 |  |  |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
Cafe Bottles |  | 2 |  | 2 |  |  |  | 3 |  | 3 |  | 3 |  | 3 |  | 1 |  | 1 |  | 1
Walk In Freezer Opened |  | 4 |  | 4 |  |  |  | 4 |  | 8 |  | 8 |  | 9 |  | 5 |  | 5 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
Water/Red Bull
 | Sugar Free Red Bull
Total # of Cases |  | 3486 |  | 3662.4 |  | 3838.8 |  | 3578.400000000001 |  | 3124.8 |  | 3091.2 |  | 3082.8 |  | 4998 |  | 4964.4 |  | 4645.200000000001 |  | 4712.400000000001 |  | 4670.400000000001 |  | 4611.6 |  | 4678.800000000001 |  | 4183.2 |  | 3973.2 |  | 0 |  | 0
Storage Area Opened |  | 0 |  | 0
Storage Area Unopened |  | 17 |  | 17 |  | 17 |  | 16 |  | 13 |  | 13 |  | 13 |  | 23 |  | 23 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 19 |  | 18
Mini - Bar Bottles |  | 7 |  |  |  | 7 |  | 6 |  | 18 |  | 18 |  | 16 |  | 19 |  | 22 |  | 17 |  | 25 |  | 22 |  | 18 |  | 17 |  | 19 |  | 19
Cafe Bottles |  |  |  |  |  | 14 |  | 10 |  |  |  | 20 |  | 21 |  | 18 |  | 11 |  | 13 |  | 13 |  | 12 |  | 12 |  | 17 |  | 16 |  | 15
Walk In Freezer Opened |  |  |  | 2 | -20 | 2 | -20 | 2 | -22 | 1 | -6 | 1 | -6 | 1 | -6 | 1 | -11 | 1 | -18 | 1 | -5 | 1 | -5 | 1 | -6 | 1 | -9 | 1 | -5 | 1 | -17 | 1 | -17
Walk In [NAME] |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 1 |  | 1
 | Regular Red Bull
Total # of Cases |  | 2352 |  | 2956.8 |  | 3074.4 |  | 2923.200000000001 |  | 2805.6 |  | 2797.2 |  | 2662.8 |  | 4678.8 |  | 4258.8 |  | 3914.4 |  | 3822 |  | 3788.4 |  | 3746.400000000001 |  | 3427.2 |  | 3309.6 |  | 2931.6 |  | 0 |  | 0
Storage Area Opened |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -5 | 1 | -7 | 1 | -9 | 1 | -9 | 1 | -10 | 1 | -10 | 1 | -10
Storage Area Unopened |  | 11 |  | 14 |  | 13 |  | 12 |  | 10 |  | 10 |  | 10 |  | 19 |  | 19 |  | 16 |  | 16 |  | 16 |  | 16 |  | 14 |  | 13 |  | 11
Mini - Bar Bottles |  | 16 |  | 16 |  | 16 |  | 12 |  | 36 |  | 35 |  | 18 |  | 34 |  | 37 |  | 33 |  | 24 |  | 22 |  | 34 |  | 36 |  | 35 |  | 38
Cafe Bottles |  |  |  |  |  |  |  |  |  | 35 |  | 35 |  | 36 |  | 19 |  | 14 |  | 16 |  | 16 |  | 16 |  | 12 |  | 17 |  | 16 |  | 22
Walk In Freezer Opened |  |  |  |  |  | 2 | -10 | 2 |  | 2 | -25 | 2 | -25 | 2 | -25 | 2 | -35 |  |  | 2 | -34 | 1 | -10 | 1 | -10 | 1 | -23 | 1 | -19 | 1 | -7 | 1 | -13
Walk In [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 2 |  | 1 |  | 2
 | Blue Hildon
Total # of Cases |  | 2880 |  | 2844 |  | 3048 |  | 3600 |  | 2976 |  | 2280 |  | 2544 |  | 2184 |  | 2388 |  | 1824 |  | 5988 |  | 5988 |  | 5928 |  | 5844 |  | 5676 |  | 5040 |  | 0 |  | 0
Storage Area Opened |  | 1 |  | 1 | -3 | 1 | -9 | 1 | -9 | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -14 | 1 | -15 | 1 | -15 | 1 | -13 | 1 | -14 | 1 | -14 | 1 | -2
Storage Area Unopened |  | 8 |  | 8 |  | 8 |  | 8 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 4 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 14
Mini - Bar Bottles |  |  |  |  |  |  |  | 46 |  | 46 |  | 36 |  | 45 |  | 18 |  | 28 |  | 14 |  | 47 |  | 47 |  | 39 |  | 35 |  | 23 |  | 35
Cafe Bottles |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 10 |  | 17 |  | 13 |  | 11 |  | 11 |  | 12 |  | 10 |  | 8 |  | 7
Walk In Freezer Opened |  | 1 |  | 1 |  | 1 | -1 | 1 | -1 | 1 |  |  |  |  |  |  |  |  |  | 1 | -5 |  |  |  |  |  |  |  |  |  |  | 1 | -4
Walk In [NAME] |  | 0 |  | 0 |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 1
 | White Hildon
Total # of Cases |  | 1728 |  | 1500 |  | 1404 |  | 1404 |  | 1584 |  | 1584 |  | 1500 |  | 1608 |  | 1608 |  | 1740 |  | 1788 |  | 1632 |  | 1812 |  | 1776 |  | 1680 |  | 1476 |  | 0 |  | 0
Storage Area Opened |  | 1 |  | 1 | -19 | 1 | -19 | 1 | -19 |  |  |  |  |  |  | 1 |  | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -4 | 1 | -4 | 1 | -4
Storage Area Unopened |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3
Mini - Bar Bottles |  |  |  |  |  |  |  |  |  | 13 |  | 13 |  | 16 |  | 14 |  | 14 |  | 14 |  | 11 |  | 12 |  | 14 |  | 13 |  | 13 |  | 16
Cafe Bottles |  |  |  |  |  |  |  |  |  | 7 |  | 7 |  | 13 |  | 8 |  | 8 |  |  |  | 13 |  | 12 |  | 12 |  | 6 |  | 11 |  | 15
Walk In Freezer Opened |  | 1 |  | 1 |  | 1 | -8 | 1 | -8 | 1 | -8 | 1 | -8 |  |  |  |  |  |  | 1 | -5 | 1 | -11 |  |  | 1 | -11 | 1 | -11
Walk In [NAME] |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  | 1
 | Evian
Total # of Cases |  | 1440 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1296 |  | 1248 |  | 1248 |  | 1248 |  | 0 |  | 0
Storage Area Opened |  | 1 |  | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -12 | 1 | -16 | 1 | -16 | 1 | -16
Storage Area Unopened |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
Mini - Bar Bottles
Cafe Bottles
Walk In Freezer Opened
Walk In [NAME]