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

 |  |  | category | item | F2 | bar 2 | bar 3 | att | bar6 | bar 6 wine | triple | barbarella | pango | pango wine
 |  |  | BEER | GUINNESS | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BEER | HEINEKEN | 240 | 240 | 240 | 240 | 240 |  |  | 240 | 250
 |  |  | BEER | KINGFISHER | 200 | 200 | 200 | 200 |  |  |  | 200 | 220
 |  |  | BEER | PILSNER | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BEER | REDDS | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BEER | SMIRNOFF ICE | 200 | 200 | 200 | 160 | 200 |  |  | 200 | 200
 |  |  | BEER | TUSKER | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BEER | TUSKER MALT | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BEER | WHITE CAP | 180 | 180 | 180 | 160 | 180 |  |  | 180 | 200
 |  |  | BOTTLE | 1/2 BAILEYS | 1600 |  |  | 1600
 |  |  | BOTTLE | 1/2 BOND 7 | 900 |  |  | 900
 |  |  | BOTTLE | 1/2 GIN | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 HUNTERS | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 KENYA CANE | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 RICHOT | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 VICEROY | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 VODKA | 900 |  |  | 900 |  |  | 900 | 900
 |  |  | BOTTLE | 1/2 WELLINGTON | 900 |  |  | 900 |  |  | 900
 |  |  | BOTTLE | 1/4 BOND 7 | 500 |  |  | 500
 |  |  | BOTTLE | 1/4 GIN | 500 |  |  | 500 |  |  | 500 | 500
 |  |  | BOTTLE | 1/4 HUNTERS | 500 |  |  | 500 |  |  | 500 | 500
 |  |  | BOTTLE | 1/4 KENYA CANE | 500 |  |  | 500 |  |  | 500 | 500
 |  |  | BOTTLE | 1/4 RICHOT | 500 |  |  | 500 |  |  | 500 | 500
 |  |  | BOTTLE | 1/4 VICEROY | 600 |  |  | 600 |  |  | 600 | 600
 |  |  | BOTTLE | 1/4 VODKA | 500 |  |  | 500 |  |  | 500 | 500
 |  |  | BOTTLE | 1/4 WELLINGTON | 500 |  |  | 500 |  |  | 500
 |  |  | BOTTLE | GIN FULL | 1800 |  |  | 1800
 |  |  | BOTTLE | HUNTERS FULL | 1800 |  |  |  |  |  |  | 1800
 |  |  | BOTTLE | KENYA CANE FULL | 1800 |  |  |  |  |  |  | 1800
 |  |  | BOTTLE | VICEROY FULL | 1800 |  |  | 1800 |  |  |  | 1800
 |  |  | BOTTLE | VODKA SMIRNOFF FULL | 1800 |  |  | 1800
 |  |  | CIG | DUNHILL GREEN | 170 | 170 | 170 | 170 |  |  |  |  | 170
 |  |  | CIG | DUNHILL LIGHT | 170 | 170 | 170 | 170 |  |  |  |  | 170
 |  |  | CIG | DUNHILL RED | 170 | 170 | 170 | 170 |  |  |  |  | 170
 |  |  | CIG | EMBASSY KINGS | 150 | 150 | 150 | 150 |  |  |  |  | 170
 |  |  | CIG | EMBASSY MILD | 150 | 150 | 150 | 150 |  |  |  |  | 170
 |  |  | CIG | MATCHES | 10 | 10 | 10 | 10 |  |  |  |  | 10
 |  |  | CIG | PALLMAN BLUE | 170 |  |  |  |  |  |  |  | 170
 |  |  | CIG | SM | 120 | 120 | 120 | 120 |  |  |  |  | 120
 |  |  | CIG | SPORTS MAN | 120 | 120 | 120 | 120 |  |  |  |  | 120
 |  |  | JUICE | FRESH JUICE | 100 |  |  | 100
 |  |  | MEDS | ACTAL | 10 | 10 | 10 | 10 |  |  |  |  | 10
 |  |  | MEDS | PANADOL | 10 | 10 | 10 | 10 |  |  |  |  | 10
 |  |  | SOFT | ALVARO | 90 | 90 | 90 | 90 | 90 |  |  |  | 100
 |  |  | SOFT | GRENADINE | 50 |  |  |  | 50 |  |  |  | 50
 |  |  | SOFT | LIME CORDIAL | 40 | 40 | 40 | 40 | 40 |  |  | 40 | 50
 |  |  | SOFT | MINERAL H2O | 80 | 80 | 80 | 80 | 80 |  |  | 80 | 100
 |  |  | SOFT | NOVIDA | 90 | 90 | 90 | 90 | 90 |  |  |  | 100
 |  |  | SOFT | PEANUTS | 40 |  |  |  | 40 |  |  |  | 50
 |  |  | SOFT | PICANA | 70 | 70 | 70 | 70 | 70 |  |  |  | 80
 |  |  | SOFT | REDBULL | 200 | 200 | 200 | 200 |  |  | 200 | 200 | 220
 |  |  | SOFT | SHARK | 200 | 200 | 200 | 200 |  |  | 200 | 200 | 220
 |  |  | SOFT | SODA 500 ml | 70 |  |  | 70
 |  |  | SOFT | SODA BITTER LEMON | 70 | 70 | 70 | 70 | 70 |  |  | 70 | 80
 |  |  | SOFT | SODA COKE | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | SODA FANTA | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | SODA GINGER ALE | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | SODA SCHWEPPES | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | SODA SPRITE | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | SODA STONEY | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 80
 |  |  | SOFT | TINNED MANGO | 100 | 100 | 100 |  | 100 |  |  |  | 100
 |  |  | SOFT | TINNED ORANGE | 100 | 100 | 100 |  | 100 |  |  |  | 100
 |  |  | SOFT | TINNED PINEAPPLE | 100 | 100 | 100 |  | 100 |  |  |  | 100
 |  |  | SPIRIT | AMARO MONTENEGRO | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | [NAME] | 180 | 180 | 180 | 180 | 180 |  |  | 180 | 180
 |  |  | SPIRIT | ARCHERS PEACH | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | [NAME] | 170 | 170 | 170 | 170 | 10 |  |  | 170 | 200
 |  |  | SPIRIT | BACARDI LIGHT | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | BAILEYS | 180 | 180 | 180 |  | 180 |  |  | 180 | 180
 |  |  | SPIRIT | BALLANTINE FINEST | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | BALLANTINE GOLD SEAL | 300 |  |  |  |  |  |  |  | 300
 |  |  | SPIRIT | BALLENTINE | 200 | 200 | 200
 |  |  | SPIRIT | BENEDICTINE | 240 | 240 | 240
 |  |  | SPIRIT | BOLS CREAM DE BANANS | 180 |  |  |  |  |  |  |  | 180
 |  |  | SPIRIT | CACHACA | 160 |  | 160 |  |  |  |  |  | 200
 |  |  | SPIRIT | CAMPARI | 120 | 120 | 120 |  | 120 |  |  |  | 150
 |  |  | SPIRIT | CAN CLUB | 170 | 170 | 170 |  |  |  |  |  | 220
 |  |  | SPIRIT | CAPTAIN MORGAN | 140 | 140 | 140 |  | 140 |  |  |  | 180
 |  |  | SPIRIT | CHILLI VODKA | 200 |  |  |  | 200
 |  |  | SPIRIT | CHIVAS | 400 | 400 | 400 | 400 | 400 |  |  | 400 | 500
 |  |  | SPIRIT | CINZANO | 100 | 100 | 100
 |  |  | SPIRIT | CLUBMAN | 170 |  |  |  | 170
 |  |  | SPIRIT | COINTREAU | 220 | 220 | 220 |  | 250 |  |  |  | 300
 |  |  | SPIRIT | CRÈME DE MENTHE | 160 |  |  | 160 |  |  |  |  | 160
 |  |  | SPIRIT | CURACAO | 170 |  |  |  | 170
 |  |  | SPIRIT | DE BANANA | 160 |  |  | 160
 |  |  | SPIRIT | [NAME] | 180 |  |  |  |  |  |  |  | 180
 |  |  | SPIRIT | DIMPLE | 500 | 500 | 500
 |  |  | SPIRIT | [NAME] | 300 |  |  |  | 300 |  |  |  | 300
 |  |  | SPIRIT | DRAMBUIE | 220 |  | 220 |  | 220 |  |  |  | 220
 |  |  | SPIRIT | DUBONNET | 220 |  |  |  |  |  |  |  | 220
 |  |  | SPIRIT | FAMOUS GROUSE | 200 | 200 | 200 | 200 | 200 |  |  | 200 | 200
 |  |  | SPIRIT | FERNET BRANCA | 250 |  | 250 | 250 |  |  |  |  | 250
 |  |  | SPIRIT | FOUR ROSES BOURBON | 170 | 170 | 170 |  |  |  |  |  | 200
 |  |  | SPIRIT | GIN BOMBAY SAPPHIRE | 180 |  |  |  |  |  |  |  | 180
 |  |  | SPIRIT | GIN GILBEYS | 120 | 120 | 120 | 120 | 120 |  |  | 100 | 130
 |  |  | SPIRIT | GIN GORDONS | 150 |  |  |  |  |  |  |  | 150
 |  |  | SPIRIT | GLENDFIDDICH | 280 |  | 280 |  |  |  |  |  | 170
 |  |  | SPIRIT | GRAND MARNIER | 300 |  | 300 |  |  |  |  |  | 300
 |  |  | SPIRIT | GRANTS | 200 | 170 | 200 |  |  |  |  |  | 200
 |  |  | SPIRIT | GRAPPA [NAME] | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | GRAPPA NINO | 300 |  |  |  | 300
 |  |  | SPIRIT | GRAPPA TOMASI | 300 |  |  |  | 300
 |  |  | SPIRIT | [NAME] | 200 | 200
 |  |  | SPIRIT | [NAME] | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | HENNESSY VSOP | 400 | 400 | 400 |  | 400 |  |  | 400 | 400
 |  |  | SPIRIT | HENNESSY XO | 1000 |  |  |  |  |  |  |  | 1000
 |  |  | SPIRIT | HUNTERS | 160 |  | 160 | 160 | 200 |  |  | 160 | 150
 |  |  | SPIRIT | IW HARPER BOURBON | 170 | 170 |  |  |  |  |  |  | 180
 |  |  | SPIRIT | J & B WHISKY | 200 | 160 | 200 |  | 200 |  |  | 200 | 200
 |  |  | SPIRIT | JACK DANIEL | 220 | 220 | 220 |  | 220 |  |  | 220 | 300
 |  |  | SPIRIT | JAMESON | 220 | 220 | 220 |  | 220 |  |  | 220 | 220
 |  |  | SPIRIT | JIM BEAM | 170 | 170 | 170 |  | 170 |  |  | 170 | 200
 |  |  | SPIRIT | JOHNNY WALKER BLACK | 430 | 430 | 430 |  | 430 |  |  | 430 | 350
 |  |  | SPIRIT | JOHNNY WALKER RED | 200 | 200 | 200 | 200 | 200 |  |  | 200 | 200
 |  |  | SPIRIT | KENYA CANE | 120 | 120 | 120 | 120 | 120 |  |  | 120
 |  |  | SPIRIT | KENYA GOLD | 140 | 140 | 140 |  |  |  |  |  | 140
 |  |  | SPIRIT | KHALUA | 180 |  |  |  |  |  |  |  | 180
 |  |  | SPIRIT | [NAME] | 180 |  |  |  |  |  |  |  | 180
 |  |  | SPIRIT | MAKERS MARK | 300 |  |  |  |  |  |  |  | 300
 |  |  | SPIRIT | MALIBU | 120 | 120 | 120 | 120 | 120 |  |  | 120 | 150
 |  |  | SPIRIT | MARTELL BRANDY | 400 | 400 | 400 |  | 400 |  |  |  | 400
 |  |  | SPIRIT | MARTINI BIANCO | 100 | 100 | 100 | 100 | 100 |  |  |  | 100
 |  |  | SPIRIT | MARTINI BITTER | 100 |  |  |  |  |  |  |  | 100
 |  |  | SPIRIT | MARTINI DRY | 100 | 100 | 100 | 100 | 100 |  |  |  | 100
 |  |  | SPIRIT | MARTINI ROSSO | 100 | 100 | 100 |  | 100 |  |  |  | 100
 |  |  | SPIRIT | [NAME] | 220 | 220 | 220 |  | 220 |  |  |  | 180
 |  |  | SPIRIT | NARDINI RISERVA | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | NARDINI WHITE | 200 |  |  |  |  |  |  |  | 200
 |  |  | SPIRIT | NAVY RUM | 140 | 140 | 140 |  | 140 |  |  |  | 180
 |  |  | SPIRIT | PERNOD | 170 |  | 170 |  |  |  |  |  | 170
 |  |  | SPIRIT | REMY MARTIN | 600 | 600 | 600 |  |  |  |  |  | 600
 |  |  | SPIRIT | RICARD FRANCE | 600 |  |  |  |  |  |  |  | 120
 |  |  | SPIRIT | [NAME] RUM | 120 |  |  |  | 200
 |  |  | SPIRIT | [NAME] | 150 | 150 | 150 | 150 | 150 |  |  | 150 | 160
 |  |  | SPIRIT | SAMBUCA CLEAR | 150 | 150 | 150 | 150 | 150 |  |  | 150 | 160
 |  |  | SPIRIT | SAMBUCA GREEN | 150 | 150 | 150 | 150 | 150 |  |  | 150 | 160
 |  |  | SPIRIT | SAMBUCA RED | 150 | 150 | 150 | 150 | 150 |  |  | 150 | 160
 |  |  | SPIRIT | [NAME] | 120 | 120 | 120 | 120 | 120 |  |  | 120 | 150
 |  |  | SPIRIT | TEACHERS | 200 | 200 | 200 |  |  |  |  |  | 220
 |  |  | SPIRIT | [NAME] | 260 | 260 | 260 |  | 260 |  |  | 260 | 260
 |  |  | SPIRIT | [NAME] | 260 |  | 200 | 260 | 260 |  |  |  | 260
 |  |  | SPIRIT | [NAME] | 260 |  | 200 |  | 260 |  |  |  | 260
 |  |  | SPIRIT | THRILLER | 150 |  |  |  | 150
 |  |  | SPIRIT | TIA MARIA | 250 | 250 | 250 |  |  |  |  |  | 250
 |  |  | SPIRIT | VANDER HUM
 |  |  | SPIRIT | VICEROY | 100 | 100 | 100 | 100 | 100 |  |  | 90 | 200
 |  |  | SPIRIT | VODKA ABSOLUTE | 250 |  |  |  | 250 |  |  |  | 150
 |  |  | SPIRIT | VODKA BRANNVIN | 130 |  |  |  |  |  |  |  | 130
 |  |  | SPIRIT | VODKA MM APPLE | 120 |  |  | 120
 |  |  | SPIRIT | VODKA MM CHOCOLATE | 120 |  |  | 120
 |  |  | SPIRIT | VODKA MM LEMON | 120 |  |  | 120
 |  |  | SPIRIT | VODKA MM LEMON GRASS | 120 |  |  | 120
 |  |  | SPIRIT | VODKA MM ORANGE | 120 |  |  | 120
 |  |  | SPIRIT | VODKA NORDIC ICE | 250 |  |  |  | 250 |  |  |  | 150
 |  |  | SPIRIT | VODKA SMIRNOFF | 120 | 120 | 120 | 120 | 120 |  |  | 100 | 130
 |  |  | SPIRIT | VODKA STOLICHNAYA | 120 | 120 | 120 |  |  |  |  |  | 120
 |  |  | SPIRIT | WELLINGTON BRANDY | 140 | 140
 |  |  | SPIRIT | [NAME] BOURBON | 300 |  |  |  |  |  |  |  | 300
 |  |  | WINE | BARON  RED | 150 |  |  | 150
 |  |  | WINE | BARON WHITE | 150 |  |  | 150
 |  |  | WINE | MOUSSEUX | 150 |  |  | 150
 |  |  | WINE | NEDERBURG | 1300 |  |  | 1300
 |  |  | WINE | VERSUS RED | 150 |  |  | 150
 |  |  | WINE | VERSUS WHITE | 150 |  |  | 150
 |  |  | WINE CHAMPAGNE | [NAME] | 9900 |  |  |  |  | 9900 |  |  |  | 9500
 |  |  | WINE CHAMPAGNE | DOM PERIGNON | 24000 |  |  |  |  | 24000 |  |  |  | 24000
 |  |  | WINE CHAMPAGNE | MOET ET CHANDON | 9900 |  |  |  |  | 9900 |  |  |  | 9500
 |  |  | WINE GLASS RED | CASK RED DRY | 150 |  |  | 150 |  | 150 |  |  |  | 200
 |  |  | WINE GLASS RED | CASK RED SWEET | 150 |  |  | 150 |  | 150 |  |  |  | 200
 |  |  | WINE GLASS SPARKLING | [NAME] | 150 |  |  | 150 |  | 150
 |  |  | WINE GLASS WHITE | CASK WHITE | 150 |  |  | 150 |  | 150 |  |  |  | 200
 |  |  | WINE GLASS WHITE | [NAME] SWEET | 150 |  |  | 150 |  | 150
 |  |  | WINE RED | BARON RED BTL | 800 |  |  |  |  | 800 |  |  |  | 800
 |  |  | WINE RED | CELLAR CASK BTL RED | 1300 |  |  |  |  | 1300
 |  |  | WINE RED | CLARO CHIANTI | 1500 |  |  |  |  | 1500 |  |  |  | 1600
 |  |  | WINE RED | COLLIO MERLOT | 1800 |  |  |  |  |  |  |  |  | 1800
 |  |  | WINE RED | FORMENTINI COLLIO | 1800 |  |  |  |  |  |  |  |  | 1800
 |  |  | WINE RED | GATO NEGRO | 1500 |  |  |  |  | 1500 |  |  |  | 1500
 |  |  | WINE RED | [NAME] | 4500 |  |  |  |  |  |  |  |  | 4500
 |  |  | WINE RED | LAMBRUSCO RED | 1300 |  |  |  |  | 1300 |  |  |  | 1000
 |  |  | WINE RED | MEDDERSHEIMER
 |  |  | WINE RED | NEDERBURG | 1300 |  |  |  |  | 1300
 |  |  | WINE RED | ROCAMAR  RED | 1000 |  |  |  |  | 1000
 |  |  | WINE RED | TOMASSI RIPASSO | 3000 |  |  |  |  |  |  |  |  | 3000
 |  |  | WINE RED | TOMASSI VALPOLICELLA | 1000 |  |  |  |  |  |  |  |  | 1000
 |  |  | WINE RED | VALPOLICELLA | 1300 |  |  |  |  | 1300
 |  |  | WINE RED | VERSUS RED BTL | 1500 |  |  |  |  | 1500
 |  |  | WINE RED | VIPRA ROSSA | 1300 |  |  |  |  | 1300 |  |  |  | 1300
 |  |  | WINE ROSE | MATEUS ROSE | 1500 |  |  |  |  | 1500 |  |  |  | 2000
 |  |  | WINE SPARKLING | ASTI MARTIN | 2400 |  |  |  |  | 2400
 |  |  | WINE SPARKLING | FERRARI | 7500 |  |  |  |  |  |  |  |  | 7500
 |  |  | WINE SPARKLING | [NAME] | 2400 |  |  |  |  | 2400 |  |  |  | 2400
 |  |  | WINE SPARKLING | [NAME] | 1000 |  |  |  |  | 1000 |  |  |  | 1000
 |  |  | WINE WHITE | ARTHUR METZ RIESLING | 1900 |  |  |  |  |  |  |  |  | 1900
 |  |  | WINE WHITE | BARON WHITE BTL | 800 |  |  |  |  | 800 |  |  |  | 800
 |  |  | WINE WHITE | BLACK TOWER | 1500 |  |  |  |  | 1500
 |  |  | WINE WHITE | BLANC DE BLANC | 1200 |  |  |  |  | 1200
 |  |  | WINE WHITE | BLU DI BLU | 1800 |  |  |  |  |  |  |  |  | 1800
 |  |  | WINE WHITE | BOTTEGA | 1500 |  |  |  |  | 1500
 |  |  | WINE WHITE | CHATEAU LE GARRY | 2200 |  |  |  |  |  |  |  |  | 2200
 |  |  | WINE WHITE | CHATEAU MAUVIN | 2200 |  |  |  |  |  |  |  |  | 2200
 |  |  | WINE WHITE | CHATEAU T BORDEAUX | 2200 |  |  |  |  |  |  |  |  | 2200
 |  |  | WINE WHITE | CHINESE 12 K | 1600 |  |  |  |  |  |  |  |  | 1600
 |  |  | WINE WHITE | FONTANA FRASCATI | 1300 |  |  |  |  | 1300 |  |  |  | 1300
 |  |  | WINE WHITE | LABRUSCO WHITE | 1300 |  |  |  |  | 1300
 |  |  | WINE WHITE | PAPAYA | 800 |  |  |  |  | 800
 |  |  | WINE WHITE | ROCAMAR  WHITE | 1000 |  |  |  |  | 1000
 |  |  | WINE WHITE | VERSUS WHITE BTL | 1500 |  |  |  |  | 1500
 |  |  |  | CON FAMILY LQR | 1600 |  |  |  |  |  |  |  |  | 1600
 |  |  |  | ISSASI MELIN | 1600 |  |  |  |  |  |  |  |  | 1600
 |  |  |  | LAMBERTI | 1600 |  |  |  |  |  |  |  |  | 1600
 |  |  |  | [NAME] | 1000 |  |  |  |  |  |  |  |  | 1000
 |  |  | WINE GLASS WHITE | VERSUS WHITE GLASS | 150 |  |  | 150
 |  |  | WINE GLASS RED | VERSUS RED GLASS | 150 |  |  | 150
 |  |  | WINE GLASS RED | BARON RED GLASS | 150 |  |  | 150
 |  |  | WINE GLASS WHITE | BARON WHITE GLASS | 150 |  |  | 150