All Kinds of Model Trains Equipment

Arab Wine Production Set to Increase

 – decanter.com
February 27, 2008
Oliver Styles

The production of wine in Arab countries around the Mediterranean is on the increase, with Syria set to begin production within two years.

 

According to news agency AFP, wine production and quality in Algeria, Eygpt, Jordan, Lebanon, Morocco and Tunisia is experiencing a 'renaissance' and 'blooming' following years of civil war, nationalisation and religious opposition.

 

The countries produce 146m bottles of wine and the sector has a turnover of £170m (US$340m, €226m).

 

In Egypt, production has doubled since the millennium. The country produces 8.5m bottles of wine, three quarters of which are drunk by tourists.

 

Although its neighbour Lebanon is an established wine producer, Syria looks set to drastically increase its production within two years. This is due to 'vast' vineyard plantings near the mediterranean port of Latakia by Syrian businessman and shipping tycoon Johnny Saade.

 

Following recent civil unrest and Isreali military incursion in 2006, Lebanon has seen its wine production revived. Although most of its vineyards are found in the strategically important Bekka Valley, turnover in 2007 was up 10%.

 

In northwest Africa, Algeria, once the world's biggest wine exporter, falls in alongside Morocco and Tunisia in terms of production. According to AFP, the three countries produce the majority of Arab wine with 13m hectares under vine. Around 20% of the countries' wines are exported to Europe. According to Hugh Johnson, Morocco 'should have the best vineyards' of the three.

 

'It's important to battle against the prejudices that surround Arab wines,' said Jean-Pierre Dehut of Morocco's largest producer, Cellars of Meknes (pictured). 'Too many people still believe it's like in colonial days when tankers full of mixed wines sailed across the Mediterranean to top up European wines.'

 

Morocco has 14 appellations including Les Coteaux d'Atlas and Beni M'Tir.

 

Decanter.com

 

 

About the Author

Mediarelease

Set Atlas

Microsoft Excel 2007 - LOOKUP functions?

Senario:
i have a matrix set up to reference how many housekeepers are required for a set shift. Checkouts run horizontaly (1-32), stayers vertically (1-32) enabling you to look up the required rooms (ie 6 checkouts & 5 stayers) and see how long if should take to complete the shift. It is set up the same way some travel distance tables are in atlas's, where you select your two locations and run your fingers across and down & where your fingers meet is the approximate distance between the two.
Instead of me manually looking this up, I am after a way for excel to do this for me, using numbers from the shift report. (the shift report calculates the number of stayers and checkouts from manually entered data) as reference to what to look up.
I think the answer may lie in nested HLOOKUP and VLOOKUP funtions, however i'm not sure on how to apply them.. i'm lost!

if you need more info or an example of the table please email me at cara@carcar.org

- Let's say your calculated stayers are in A2, and checkouts in B2.
- Also let's say your matrix is in A4:AG36, with the number of checkouts along row 4, and stayers down column A.

You can have a VLOOKUP formula like this:
=VLOOKUP(A2, $A$4:$AG$36, B2+1, false)

This will find the row for the number of stayers (finding A2 in column A).
It will then look B2+1 columns to the right (i.e. if there is 1 checkout, it will look in column B).

If this doesn't work, pls. let me know.
.