Spreadsheet: 120719d1315483342-worksheet-name-ranges-and-how-to-make-them-reference-cells-in-a-worksheet-eg1
Sheet: BAR3

 |  | DATE |  | STOCK SHEET / DAILY RETURNS
 |  | BAR 3
 | PRICE | CATEGORY | ITEM | OPENING | STORE ISSUE |  | OFFICE ISSUE |  | TRANSFER |  | TOTAL | CLOSE | SALE | KSH | CLOSING CORRECTIONS
1 |  | BEER | GUINNESS | 92 | 50 |  |  |  |  | -10 |  | 120
2 |  | BEER | HEINEKEN | 24 | 24 |  |  |  |  | -10 |  | 30
3 |  | BEER | KINGFISHER | 59 |  |  |  |  |  |  |  | 44
4 |  | BEER | PILSNER | 208 |  |  |  |  |  | -25 |  | 149
5 |  | BEER | REDDS | 10 | 24 |  |  |  |  | -6 |  | 15
6 |  | BEER | SMIRNOFF ICE | 131 | 25 |  |  |  |  | -10 |  | 130
7 |  | BEER | TUSKER | 112 | 125 |  |  |  |  | -25 |  | 130
8 |  | BEER | TUSKER MALT | 62 | 50 |  |  |  |  | -10 |  | 53
9 |  | BEER | WHITE CAP | 48 | 35 |  |  |  |  | -5 |  | 67
10 |  | CIG | DUNHILL GREEN | 8 |  |  |  |  |  |  |  | 8
11 |  | CIG | DUNHILL LIGHT | 4 |  |  |  |  |  |  |  | 1
12 |  | CIG | DUNHILL RED | 12 |  |  |  |  |  |  |  | 10
13 |  | CIG | EMBASSY KINGS | 20 |  |  |  |  |  |  |  | 20
14 |  | CIG | EMBASSY MILD | 45 |  |  |  |  |  |  |  | 38
15 |  | CIG | MATCHES | 36 |  |  |  |  |  |  |  | 30
16 |  | CIG | SM | 11 |  |  |  |  |  |  |  | 11
17 |  | CIG | SPORTS MAN | 26 |  |  |  |  |  |  |  | 24
18 |  | MEDS | ACTAL | 36 |  |  |  |  |  |  |  | 34
19 |  | MEDS | PANADOL | 40 |  |  |  |  |  |  |  | 36
20 |  | SOFT | ALVARO | 37 |  |  |  |  |  |  |  | 34
21 |  | SOFT | LIME CORDIAL | 13 |  |  |  |  |  |  |  | 12
22 |  | SOFT | MINERAL H2O | 80 |  |  |  |  |  |  |  | 47
23 | 90 | SOFT | NOVIDA | 12 | 24 |  |  |  |  |  |  | 35
24 |  | SOFT | PICANA | 9 | 24 |  |  |  |  |  |  | 32
 |  | SOFT | REDBULL | 71 |  |  |  |  |  |  |  | 56
25 |  | SOFT | SHARK | 6 |  |  |  |  |  |  |  | 2
26 |  | SOFT | SODA BITTER LEMON | 41 |  |  |  |  |  |  |  | 35
27 |  | SOFT | SODA COKE | 50 | 24 |  |  |  |  | -5 |  | 53
28 |  | SOFT | SODA FANTA | 22 |  |  |  |  |  |  |  | 21
29 |  | SOFT | SODA GINGER ALE | 33 |  |  |  |  |  | -3 |  | 30
30 |  | SOFT | SODA SCHWEPPES | 83 |  |  |  |  |  | -4 |  | 66
31 |  | SOFT | SODA SPRITE | 35 | 24 |  |  |  |  |  |  | 53
32 |  | SOFT | SODA STONEY | 34 |  |  |  |  |  |  |  | 33
33 |  | SOFT | TINNED MANGO | 1 | 12 |  |  |  |  |  |  | 11
34 |  | SOFT | TINNED ORANGE | 10 |  |  |  |  |  |  |  | 9
35 |  | SOFT | TINNED PINEAPPLE | 9 |  |  |  |  |  |  |  | 9
36 |  | SPIRIT | [NAME] | 19 |  |  |  |  |  |  |  | 16
37 |  | SPIRIT | [NAME] | 48 |  |  |  |  |  |  |  | 48
38 |  | SPIRIT | BAILEYS | 34 |  |  |  |  |  |  |  | 32
39 |  | SPIRIT | BALLENTINE | 12 |  |  |  |  |  |  |  | 12
40 |  | SPIRIT | BENEDICTINE | 12 |  |  |  |  |  |  |  | 12
41 |  | SPIRIT | CACHACA | 15 |  |  |  |  |  |  |  | 15
42 |  | SPIRIT | CAMPARI | 14 |  |  |  |  |  |  |  | 14
43 |  | SPIRIT | CAN CLUB | 9 |  |  |  |  |  |  |  | 9
44 |  | SPIRIT | CAPTAIN MORGAN | 22 |  |  |  |  |  |  |  | 22
45 |  | SPIRIT | CHIVAS | 13 |  |  |  |  |  |  |  | 13
46 |  | SPIRIT | CINZANO | 9 |  |  |  |  |  |  |  | 9
47 |  | SPIRIT | COINTREAU | 1 |  |  |  |  |  |  |  | 1
48 |  | SPIRIT | DIMPLE | 22 |  |  |  |  |  |  |  | 22
49 |  | SPIRIT | DRAMBUIE | 22 |  |  |  |  |  |  |  | 22
50 |  | SPIRIT | FAMOUS GROUSE | 33 |  |  |  |  |  |  |  | 33
51 |  | SPIRIT | FERNET BRANCA | 15 |  |  |  |  |  |  |  | 15
52 |  | SPIRIT | FOUR ROSES BOURBON | 23 |  |  |  |  |  |  |  | 23
53 |  | SPIRIT | GIN GILBEYS | 81 |  |  |  |  |  |  |  | 71
54 |  | SPIRIT | GLENDFIDDICH | 5 |  |  |  |  |  |  |  | 5
55 |  | SPIRIT | GRAND MARNIER | 6 |  |  |  |  |  |  |  | 6
56 |  | SPIRIT | GRANTS | 30 |  |  |  |  |  |  |  | 30
57 |  | SPIRIT | HENNESSY VSOP | 11 |  |  |  |  |  |  |  | 11
58 |  | SPIRIT | HUNTERS | 18 |  |  |  |  |  |  |  | 18
59 |  | SPIRIT | J & B WHISKY | 24 |  |  |  |  |  |  |  | 23
60 |  | SPIRIT | JACK DANIEL | 31 |  |  |  |  |  |  |  | 31
61 |  | SPIRIT | JAMESON | 23 |  |  |  |  |  |  |  | 23
62 |  | SPIRIT | JIM BEAM | 22 |  |  |  |  |  |  |  | 22
63 |  | SPIRIT | JOHNNY WALKER BLACK | 30 |  |  |  |  |  |  |  | 30
64 |  | SPIRIT | JOHNNY WALKER RED | 43 |  |  |  |  |  |  |  | 39
65 | 120 | SPIRIT | KENYA CANE | 41 |  |  |  |  |  |  |  | 37
66 |  | SPIRIT | KENYA GOLD
67 |  | SPIRIT | MALIBU | 11 |  |  |  |  |  |  |  | 11
68 |  | SPIRIT | MARTELL BRANDY | 27 |  |  |  |  |  |  |  | 27
69 |  | SPIRIT | MARTINI BIANCO | 22 |  |  |  |  |  |  |  | 18
70 |  | SPIRIT | MARTINI DRY | 11 |  |  |  |  |  |  |  | 11
71 |  | SPIRIT | MARTINI ROSSO | 24 |  |  |  |  |  |  |  | 24
72 |  | SPIRIT | [NAME] | 23 |  |  |  |  |  |  |  | 17
73 |  | SPIRIT | NAVY RUM | 41 |  |  |  |  |  |  |  | 41
74 |  | SPIRIT | PERNOD | 18 |  |  |  |  |  |  |  | 18
75 |  | SPIRIT | REMY MARTIN | 13 |  |  |  |  |  |  |  | 13
76 |  | SPIRIT | [NAME] | 26 |  |  |  |  |  |  |  | 26
77 |  | SPIRIT | SAMBUCA CLEAR | 29 |  |  |  |  |  |  |  | 27
78 |  | SPIRIT | SAMBUCA GREEN | 30 |  |  |  |  |  |  |  | 30
79 |  | SPIRIT | SAMBUCA RED | 16 |  |  |  |  |  |  |  | 16
80 |  | SPIRIT | [NAME] | 17 |  |  |  |  |  |  |  | 17
81 |  | SPIRIT | TEACHERS | 26 |  |  |  |  |  |  |  | 26
82 |  | SPIRIT | [NAME] | 27 |  |  |  |  |  |  |  | 24
83 |  | SPIRIT | [NAME] | 30 |  |  |  |  |  |  |  | 30
84 |  | SPIRIT | [NAME]
85 |  | SPIRIT | TIA MARIA | 18 |  |  |  |  |  |  |  | 18
86 | 100 | SPIRIT | VICEROY | 84 |  |  |  |  |  |  |  | 63
87 | 120 | SPIRIT | VODKA SMIRNOFF | 87 |  |  |  |  |  |  |  | 85
88 | 120 | SPIRIT | VODKA STOLICHNAYA | 46 |  |  |  |  |  |  |  | 46
89 | 200 |  | GUINNESS KUBWA |  | 25
90
91
92
93
94 |  |  |  |  |  |  |  |  |  |  | TOTAL SALES
95
96 |  | TOTAL ISSUE/TRANSFER:
97
98 |  |  |  | SIGN
99
100
101
102
103
104
105
106
107