After a long day of dealing with Excel formulas, pivot tables, and hidden Ribbon commands, you might be ready for an evening cocktail. Or six!
Newspaper Study
I found a link to this Canadian drinking study in the Toronto paper today, and it looks like we’re a nation of teetotalers. Is your country the same?
Apparently most Canadians don’t work with Excel, or perhaps they vent their frustrations on the hockey or curling rink at the end of the day.
The Excel Drink Calculator
To spare you the agony of checking your results in a hard-to-read green pie chart, I created an Excel version of the online drink calculator.
Use the Drink Calculator
In cells C3 to C9, enter your estimated number of drinks per day.
- The SUM Function in cell C10 calculates your total for the week.
Then, select Men or Women from the drop down list in cell C12.
- The VLOOKUP formula in cell C15 will compare your results to the rest of the men or women in Canada.
Hmmm…more than 85% – that can’t be good.
Time to move, I think. 😉 What country would you recommend?
Download the Excel Drink Calculator
If you’re brave enough to test your own results, you can download the Excel Drink Calculator. It’s in Excel 2007 format, with no macros.
Please do not operate heavy machinery, or leave a comment, if you have been drinking.
______
Don’t think so Deb, Nanaimo is famous for it’s bars!
It would be interesting to see an excel chart of life expectancy and alcohol consumption for a number of countries.
Well we all know the study that found that couples that drank a bottle of red wine each evening with dinner lived longer. Of course, the fact that people who cam afford a bottle of red wine with dinner are likely to be middle class,a nd the middle classes live longer because of better ;life-styles might have something to do with it.
Sure Ken, you know that now! 😉
Oscar/Bob, here’s a chart that shows Life Expectancy vs. Alcohol Consumption by Country in 2003.
And you can download an Excel file with the data.
Well, I wasn’t in a Nanaimo bar last night… It was a Victoria bar. Just trying to do my share!