Spreadsheet: 120720d1315483342-worksheet-name-ranges-and-how-to-make-them-reference-cells-in-a-worksheet-eg2
Sheet: BAR2

 |  |  | 2011-07-02 00:00:00
 |  | DATE |  | STOCK SHEET / DAILY RETURNS
 |  | BAR 2
 | PRICE | CATEGORY | ITEM | OPENING | STORE ISSUE |  | OFFICE ISSUE |  | TRANSFER |  | TOTAL | CLOSE | SALE | KSH | CLOSING CORRECTIONS
 | 180 | BEER | CASTLE BTL | 0
1 |  | BEER | GUINNESS | 83 | 10 |  |  |  |  |  |  | 70
2 |  | BEER | HEINEKEN | 18 |  |  |  |  |  |  |  | 18
3 |  | BEER | KINGFISHER | 10 | 24 |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4000
4 |  | BEER | PILSNER | 129 | 25 |  |  |  |  |  |  | 128 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
5 |  | BEER | REDDS | 14 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3000
6 |  | BEER | SMIRNOFF ICE | 73 | 40 |  |  |  |  |  |  | 88 |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 7000
7 |  | BEER | TUSKER | 91 | 75 |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7000
8 |  | BEER | TUSKER MALT | 61 |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  | 3600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 10000
9 |  | BEER | WHITE CAP | 37 | 25 |  |  |  |  |  |  | 51 |  |  |  |  |  |  |  |  |  |  | 700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7000
10 |  | CIG | DUNHILL GREEN | 7 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | 140
11 |  | CIG | DUNHILL LIGHT | 9 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 140
12 |  | CIG | DUNHILL RED | 13 |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  | 140
13 |  | CIG | EMBASSY KINGS | 14 |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  | 140
14 |  | CIG | EMBASSY MILD | 31 |  |  |  |  |  |  |  | 31
15 |  | CIG | MATCHES | 24 |  |  |  |  |  |  |  | 20
16 |  | CIG | SM | 17 |  |  |  |  |  |  |  | 17
17 |  | CIG | SPORTS MAN | 17 |  |  |  |  |  |  |  | 16
18 |  | MEDS | ACTAL | 26 |  |  |  |  |  |  |  | 26
19 |  | MEDS | PANADOL | 22 |  |  |  |  |  |  |  | 22
21 |  | SOFT | ALVARO | 31 |  |  |  |  |  |  |  | 25
22 |  | SOFT | LIME CORDIAL | 8 |  |  |  |  |  |  |  | 8
23 |  | SOFT | MINERAL H2O | 88 |  |  |  |  |  |  |  | 72
24 | 90 | SOFT | NOVIDA | 13 |  |  |  |  |  |  |  | 12
25 |  | SOFT | PICANA | 14 |  |  |  |  |  |  |  | 14
26 |  | SOFT | REDBULL | 20 | 24 |  |  |  |  |  |  | 37
 |  | SOFT | SHARK | 15 |  |  |  |  |  |  |  | 15
27 |  | SOFT | SODA BITTER LEMON | 37 |  |  |  |  |  |  |  | 31
28 |  | SOFT | SODA COKE | 52 |  |  |  |  |  |  |  | 46
29 |  | SOFT | SODA FANTA | 34 |  |  |  |  |  |  |  | 31
30 |  | SOFT | SODA GINGER ALE | 28 |  |  |  |  |  |  |  | 23
31 |  | SOFT | SODA SCHWEPPES | 72 |  |  |  |  |  |  |  | 70
32 |  | SOFT | SODA SPRITE | 37 |  |  |  |  |  |  |  | 34
33 |  | SOFT | SODA STONEY | 13 |  |  |  |  |  |  |  | 13
34 |  | SOFT | TINNED MANGO | 11 |  |  |  |  |  |  |  | 4
35 |  | SOFT | TINNED ORANGE | 6 |  |  |  |  |  |  |  | 5
36 |  | SOFT | TINNED PINEAPPLE | 5 |  |  |  |  |  |  |  | 5
37 |  | SPIRIT | [NAME] | 8 |  |  |  |  |  |  |  | 8
38 |  | SPIRIT | [NAME] | 17 |  |  |  |  |  |  |  | 17
39 |  | SPIRIT | BAILEYS | 33 |  |  |  |  |  |  |  | 33
43 |  | SPIRIT | CAMPARI | 12 |  |  |  |  |  |  |  | 12
44 |  | SPIRIT | CAN CLUB | 13 |  |  |  |  |  |  |  | 13
45 |  | SPIRIT | CAPTAIN MORGAN
47 |  | SPIRIT | CHIVAS | 22 |  |  |  |  |  |  |  | 22
48 |  | SPIRIT | CINZANO | 14 |  |  |  |  |  |  |  | 14
49 |  | SPIRIT | COINTREAU | 5 |  |  |  |  |  |  |  | 5
51 |  | SPIRIT | DIMPLE | 15 |  |  |  |  |  |  |  | 15
53 |  | SPIRIT | FAMOUS GROUSE | 28 |  |  |  |  |  |  |  | 28
54 |  | SPIRIT | FOUR ROSES BOURBON | 25 |  |  |  |  |  |  |  | 25
57 |  | SPIRIT | GIN GILBEYS | 36 |  |  |  |  |  |  |  | 36
58 |  | SPIRIT | GRANTS | 31 |  |  |  |  |  |  |  | 31
59 |  | SPIRIT | [NAME] | 5 |  |  |  |  |  |  |  | 5
60 |  | SPIRIT | HENNESSY VSOP | 22 |  |  |  |  |  |  |  | 22
62 |  | SPIRIT | IW HARPER BOURBON | 21 |  |  |  |  |  |  |  | 21
63 |  | SPIRIT | J & B WHISKY | 30 |  |  |  |  |  |  |  | 30
64 |  | SPIRIT | JACK DANIEL | 16 |  |  |  |  |  |  |  | 16
65 |  | SPIRIT | JAMESON | 7 |  |  |  |  |  |  |  | 7
66 |  | SPIRIT | JIM BEAM | 14 |  |  |  |  |  |  |  | 14
67 |  | SPIRIT | JOHNNY WALKER BLACK | 21 |  |  |  |  |  |  |  | 21
68 |  | SPIRIT | JOHNNY WALKER RED | 18 |  |  |  |  |  |  |  | 18
69 |  | SPIRIT | KENYA CANE | 30 |  |  |  |  |  |  |  | 30
70 |  | SPIRIT | KENYA GOLD
71 |  | SPIRIT | MALIBU | 14 |  |  |  |  |  |  |  | 14
72 |  | SPIRIT | MARTELL BRANDY | 6 |  |  |  |  |  |  |  | 6
73 |  | SPIRIT | MARTINI BIANCO | 26 |  |  |  |  |  |  |  | 26
74 |  | SPIRIT | MARTINI DRY
75 |  | SPIRIT | MARTINI ROSSO | 9 |  |  |  |  |  |  |  | 9
77 |  | SPIRIT | [NAME] | 24 |  |  |  |  |  |  |  | 24
78 |  | SPIRIT | NAVY RUM | 37 |  |  |  |  |  |  |  | 37
79 |  | SPIRIT | REMY MARTIN | 23 |  |  |  |  |  |  |  | 23
80 |  | SPIRIT | [NAME] | 25 |  |  |  |  |  |  |  | 25
81 |  | SPIRIT | SAMBUCA CLEAR | 6 |  |  |  |  |  |  |  | 6
82 |  | SPIRIT | SAMBUCA GREEN | 25 |  |  |  |  |  |  |  | 25
83 |  | SPIRIT | SAMBUCA RED | 10 |  |  |  |  |  |  |  | 10
84 |  | SPIRIT | [NAME] | 12 |  |  |  |  |  |  |  | 12
87 |  | SPIRIT | TEACHERS | 14 |  |  |  |  |  |  |  | 14
88 |  | SPIRIT | [NAME] | 4 |  |  |  |  |  |  |  | 4
89 |  | SPIRIT | TIA MARIA | 15 |  |  |  |  |  |  |  | 15
100 | 100 | SPIRIT | VICEROY | 20 | 50 |  |  |  |  |  |  | 44
91 | 120 | SPIRIT | VODKA SMIRNOFF | 46 |  |  |  |  |  |  |  | 46
92 | 120 | SPIRIT | VODKA STOLICHNAYA | 25 |  |  |  |  |  |  |  | 25
93 |  | SPIRIT | WELLINGTON BRANDY | 6 |  |  |  |  |  |  |  | 6
94 | 600 | SPIRIT | REMY MARTIN
95
96
97
 |  |  |  |  |  |  |  |  |  |  | TOTAL SALES
 |  | TOTAL ISSUE/TRANSFER:
 |  |  |  | SIGN