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

2011-07-02 00:00:00 |  | BAR 2 |  |  |  | BAR 3
CATEGORY | item | BAR STOCK | [NAME] | CURRENT LEVEL | ISSUE | BAR STOCK | Bar3 Base | CURRENT LEVEL | ISSUE
BITTERS | CAMPARI |  | 15 |  |  |  | 15
BITTERS | FERNET BRANCA |  | 0 |  |  |  | 15
BITTERS | MARTINI BITTERS
[NAME] | BAILEYS 1/2
[NAME] | BOND 7 1/2
[NAME] | BOND 7 1/4
[NAME] | GILBEYS 1/2
[NAME] | GILBEYS 1/4
[NAME] | HUNTERS 1/2
[NAME] | HUNTERS 1/4
[NAME] | JW BLACK 1/2
[NAME] | JW RED 1/2
[NAME] | KENYA CANE 1/2
[NAME] | KENYA CANE 1/4
[NAME] | RICHOT 1/2
[NAME] | RICHOT 1/4
[NAME] | SMIRNOFF RED 1/2
[NAME] | SMIRNOFF RED 1/4
[NAME] | VICEROY 1/2
[NAME] | VICEROY 1/4
[NAME] | WELLINGTON BRANDY 1/2
[NAME] | WELLINGTON BRANDY 1/4
BOURBON | CANADIAN CLUB |  | 15 |  |  |  | 15
BOURBON | FOUR ROSES BOURBON |  | 15 |  |  |  | 15
BOURBON | IW HARPER BOURBON |  | 0 |  |  |  | 0
BOURBON | JACK DANIEL |  | 23 |  |  |  | 23
BOURBON | JIM BEAM |  | 15 |  |  |  | 15
BOURBON | MAKERS MARK
BRANDY | VICEROY |  | 50 |  |  |  | 50
BRANDY | WELLINGTON BRANDY |  | 0 |  |  |  | 0
CIGARETTES | DUNHILL GREEN |  | 10 |  |  |  | 10
CIGARETTES | DUNHILL LIGHT |  | 10 |  |  |  | 10
CIGARETTES | DUNHILL RED |  | 10 |  |  |  | 10
CIGARETTES | EMBASSY KINGS |  | 10 |  |  |  | 10
CIGARETTES | EMBASSY MILD |  | 10 |  |  |  | 10
CIGARETTES | MARLBORO LIGHTS |  | 5 |  |  |  | 5
CIGARETTES | MARLBORO RED |  | 5 |  |  |  | 5
CIGARETTES | MATCHES |  | 20 |  |  |  | 20
CIGARETTES | SM |  | 5 |  |  |  | 5
CIGARETTES | SPORTS MAN |  | 5 |  |  |  | 5
COGNAC | CHIVAS |  | 25 |  |  |  | 25
COGNAC | HENNESSY VSOP |  | 15 |  |  |  | 15
COGNAC | HENNESSY XO |  | 0 |  |  |  | 0
COGNAC | MARTELL BRANDY |  | 15 |  |  |  | 15
COGNAC | REMY MARTIN |  | 15 |  |  |  | 15
GIN | GIN GILBEYS |  | 50 |  |  |  | 50
GIN | GIN GORDONS |  | 0 |  |  |  | 0
LIQUEUR | AMARO MONTENEGRO
LIQUEUR | [NAME] |  | 25 |  |  |  | 25
LIQUEUR | ARCHERS PEACH
LIQUEUR | BAILEYS |  | 25 |  |  |  | 25
LIQUEUR | BALLANTINE FINEST
LIQUEUR | BALLANTINE GOLD SEAL
LIQUEUR | BOLS CREAM DE BANANS
LIQUEUR | BUTLERS BANANA |  | 0 |  |  |  | 0
LIQUEUR | BUTLERS CHERRY |  | 0 |  |  |  | 0
LIQUEUR | BUTLERS CURACAO |  | 0 |  |  |  | 0
LIQUEUR | CACHACA |  | 0 |  |  |  | 0
LIQUEUR | COINTREAU |  | 15 |  |  |  | 15
LIQUEUR | CRÈME DE MENTHE |  | 0 |  |  |  | 0
LIQUEUR | [NAME]
LIQUEUR | [NAME]
LIQUEUR | DRAMBUIE
LIQUEUR | DUBONNET
LIQUEUR | GRAND MARNIER
LIQUEUR | GRAPPA [NAME]
LIQUEUR | GRENADINE
LIQUEUR | JAGERMEISTER |  | 0 |  |  |  | 0
LIQUEUR | KENYA GOLD |  | 15 |  |  |  | 15
LIQUEUR | KHALUA
LIQUEUR | [NAME]
LIQUEUR | MALIBU |  | 25 |  |  |  | 25
LIQUEUR | NARDINI RISERVA
LIQUEUR | NARDINI WHITE
LIQUEUR | NORDIC ICE BUTTERSCOTCH |  | 0 |  |  |  | 0
LIQUEUR | NORDIC ICE MELON |  | 0 |  |  |  | 0
LIQUEUR | NORDIC ICE MINT |  | 0 |  |  |  | 0
LIQUEUR | NORDIC ICE STRAWBERRY |  | 0 |  |  |  | 0
LIQUEUR | PERNOD
LIQUEUR | RICARD FRANCE
LIQUEUR | SAMBUCA BLACK |  | 0 |  |  |  | 0
LIQUEUR | [NAME] |  | 25 |  |  |  | 25
LIQUEUR | SAMBUCA CLEAR |  | 25 |  |  |  | 25
LIQUEUR | SAMBUCA GREEN |  | 25 |  |  |  | 25
LIQUEUR | SAMBUCA RED |  | 25 |  |  |  | 25
LIQUEUR | [NAME] |  | 25 |  |  |  | 25
LIQUEUR | TANGO APPLE SOUR |  | 0 |  |  |  | 0
LIQUEUR | TIA MARIA |  | 15 |  |  |  | 15
MEDS | ACTAL |  | 20 |  |  |  | 20
MEDS | PANADOL |  | 20 |  |  |  | 20
RUM | [NAME] |  | 25 |  |  |  | 25
RUM | CAPTAIN MORGAN |  | 25 |  |  |  | 25
RUM | [NAME] |  | 0 |  |  |  | 0
RUM | KENYA CANE |  | 50 |  |  |  | 50
RUM | [NAME] |  | 25 |  |  |  | 25
RUM | NAVY RUM |  | 25 |  |  |  | 25
SOFT | LIME CORDIAL |  | 23 |  |  |  | 23
SOFT | MINERAL H2O |  | 48 |  |  |  | 48
SOFT | REDBULL |  | 48 |  |  |  | 48
SOFT | SHARK |  | 0 |  |  |  | 0
SOFT | TINNED MANGO |  | 12 |  |  |  | 12
SOFT | TINNED ORANGE |  | 12 |  |  |  | 12
SOFT | TINNED PINEAPPLE |  | 12 |  |  |  | 12
TEQUILA | CAMINO REAL |  | 25 |  |  |  | 25
TEQUILA | [NAME] |  | 0 |  |  |  | 0
TEQUILA | [NAME] |  | 0 |  |  |  | 0
VERMOUTH | CINZANO |  | 15 |  |  |  | 15
VERMOUTH | MARTINI BIANCO |  | 25 |  |  |  | 25
VERMOUTH | MARTINI DRY |  | 25 |  |  |  | 25
VERMOUTH | MARTINI ROSSO |  | 25 |  |  |  | 25
VODKA | MM APPLE |  | 0 |  |  |  | 0
VODKA | MM CHOCOLATE |  | 0 |  |  |  | 0
VODKA | MM LEMON |  | 0 |  |  |  | 0
VODKA | MM ORANGE |  | 0 |  |  |  | 0
VODKA | MM RASPBERRY |  | 0 |  |  |  | 0
VODKA | MM LEMONGRASS |  | 0 |  |  |  | 0
VODKA | SMIRNOFF RED 1L |  | 66 |  |  |  | 66
VODKA | SMIRNOFF RED 750 |  | 0 |  |  |  | 0
VODKA | STOLICHNAYA |  | 25 |  |  |  | 25
WHISKY | DIMPLE |  | 15 |  |  |  | 15
WHISKY | FAMOUS GROUSE |  | 25 |  |  |  | 25
WHISKY | GLENFIDDICH |  | 15 |  |  |  | 15
WHISKY | GRANTS |  | 25 |  |  |  | 25
WHISKY | [NAME] |  | 15 |  |  |  | 15
WHISKY | HUNTERS |  | 15 |  |  |  | 15
WHISKY | J & B WHISKY |  | 25 |  |  |  | 25
WHISKY | JAMESON |  | 25 |  |  |  | 25
WHISKY | JW BLACK |  | 25 |  |  |  | 25
WHISKY | JW RED |  | 25 |  |  |  | 25
WHISKY | TEACHERS |  | 15 |  |  |  | 15
WINE RED | BARON RED
WINE WHITE | BARON WHITE
WINE | ISSASI MELIN
WINE | [NAME]
WINE CASK | CASK RED DRY
WINE CASK | CASK RED SWEET
WINE CASK | CASK WHITE
WINE CASK | [NAME] SWEET
WINE CHAMPAGNE | [NAME]
WINE CHAMPAGNE | DOM PERIGNON
WINE CHAMPAGNE | MOET ET CHANDON
WINE RED | CLARO CHIANTI
WINE RED | COLLIO MERLOT
WINE RED | CON FAMILY LQR
WINE RED | GATO NEGRO
WINE RED | [NAME]
WINE RED | LAMBERTI
WINE RED | LAMBRUSCO RED
WINE RED | MEDDERSHEIMER
WINE RED | NEDERBURG
WINE RED | ROCAMAR  RED
WINE RED | TOMASSI RIPASSO
WINE RED | TOMASSI VALPOLICELLA
WINE RED | VALPOLICELLA
WINE RED | VERSUS RED
WINE RED | VIPRA ROSSA
WINE ROSE | MATEUS ROSE
WINE SPARKLING | ARTHUR METZ RIESLING
WINE SPARKLING | ASTI MARTIN
WINE SPARKLING | FERRARI
WINE SPARKLING | [NAME]
WINE SPARKLING | MOUSSEUX
WINE WHITE | BLACK TOWER
WINE WHITE | BLANC DE BLANC
WINE WHITE | BLU DI BLU
WINE WHITE | BOTTEGA
WINE WHITE | CHATEAU LE GARRY
WINE WHITE | CHATEAU MAUVIN
WINE WHITE | CHATEAU T BORDEAUX
WINE WHITE | CHINESE 12 K
WINE WHITE | FONTANA FRASCATI
WINE WHITE | FORMENTINI COLLIO
WINE WHITE | LABRUSCO WHITE
WINE WHITE | PAPAYA
WINE WHITE | ROCAMAR  WHITE
WINE WHITE | VERSUS WHITE
WINE SPARKLING | MOUSSEUX