Eurovision 2015 Scoring Spreadsheet

Eurovision 2015

Saturday night brings with it the annual European celebration of all things glittery. With David Cameron and Nigel Farage set to pull us out of the EU could this be our final year in the competition? Almost certainly not… Regardless the show is sure to be a mixture of bizarre and fantastical performances and something best watched with a group of friends voting on the countries they think have performed the best.

To help you enjoy yourselves I have once again put together a spreadsheet to help you recreate the Eurovision voting process in your own home. This is so that your party can better handle the mathematical part of the evening once all the songs have been sung and booze has been drunk. Two years ago we had that year’s version of this spreadsheet projected onto the wall and had a whale of a time. Without the spreadsheet how would we have known how to have fun?

Before you turn on BBC One at 8:00PM give everyone who will be voting some paper so they can make notes on each song against whatever metric they think is important to the Eurovision contest. For some it is singing talent that matters, for me it is all about being flamboyant. It is up to everyone to come up with their own top ten ranking out of all the performances.

xlsm-1758Once all songs have been performed everyone then makes sure they are happy with their personal ranking and perhaps hilariously messes up their neighbour’s notes/scraps of paper before apologising and blaming the drink. After this it is time to collate the votes. To the spreadsheet!! Click on the Excel symbol to the right and within moments you will have your very own Mild Concern Eurovision 2015 Party Score Collation Spreadsheet for Maximum Fun and Mathematical AccuracyTM.

It is all pretty self-explanatory, I hope, but here’s a quick guide. When you first open the spreadsheet make sure you have macros enabled. If you see a warning like this…
Macros…deal with it.

The first thing you see with be an empty white box. Type in the first voter’s name and hit Enter, then continue until you can see everyone’s name in the list. If someone goes to the loo at this point and is pretty forgettable they may be in trouble. Once you’re done click on the grey button.

Name Form

Now you are at the heart of the spreadsheet. The table to the left will show you which country is winning based on your party’s votes and the table on the right is where everyone enters their scores. When prompted each person should list their top ten countries to the group, preferably with reasons and a generic European accent, while the Spreadsheet MasterTM uses the drop-down lists to put these countries into the table. Once all ten are entered the voter should verify the list, salute the Spreadsheet MasterTM (optional), and they will hit the “Submit Scores” button which will… submit the scores (I told you it was self-explanatory).

Score Form

Once everyone has voted you will have your winner! What mathematically accurate fun we’ve all had in replicating the voting process of the Eurovision Song Contest. If only all parties had spreadsheets…

The Only Song from Eurovision You Need to Watch

Swedish Smörgåsbord

I hope you all enjoyed a fun and mathematically accurate Eurovision on Saturday night. As the spreadsheet proved popular with the internets it will be back with a vengeance next year. The show as a whole was a mixed bag with a few too many ballads for my taste and Bonnie Tyler… well she was clearly drunk. If only she’d been singing Holding Out for a Hero then maybe the UK would have fared better. I think we all know which song should have won above Denmark (Finland forever!!).

The real highlight of the night was not any of the entered songs or the riveting voting section but the bit in between. As people across the globe tried to choose their winner Sweden put on an extraordinary show; allow me to present to you the Swedish Smörgåsbord. It is a fantastically tongue in cheek song from Sweden than outshines all the “proper” songs sung on Saturday night. It has everything: Meatballs! Ikea! Recycling!

Enjoy:

Eurovision 2013 Spreadsheet

Eurovision-2013

It’s Eurovision day! Time to gather a group of friends, buy a box of vodkas, and crowd round the TV to watch the bizarre and the bland compete for the title of Très Bon Chanteur Spectaculaire or whatever the title is. Political voting will be even more fun to watch what with the EU bailouts and whatnot but what is more important is whether anyone can top Russia’s baking grannies from last year.

To help you enjoy yourselves I have put together a plan to help you recreate the Eurovision voting process in your own home so that your party can better handle the voting part of the evening once all the songs have been sung and vodkas have been drunk. I’ve even made you a spreadsheet because a party without a spreadsheet is like a boat without a rubber duck; clearly not an essential but why not eh?

So. Before you turn on BBC One at 8:00PM give everyone who will be voting 26 small pieces of card or paper. You can either allow each person to write the names of the countries themselves or print off one of the BBC’s scoring sheets and cut out each country. Then when the show is on each voter or “party-goer” can place the countries in order from best to worst based on whatever metric they like. Last year we tried to rank as a group as we went along which lead to arguments over whether a song should be “good” or simply be “Eurovision”. I personally don’t care what you sing if you’ve got a man operating a unicycle on stilts in the background.

xlsm-1758Once all songs have been performed everyone then makes sure they are happy with their personal ranking and perhaps hilariously messes up their neighbour’s notes/scraps of paper before apologising and blaming the drink. After this it is time to collate the votes. To the spreadsheet!! Click on the Excel symbol to the right and within moments you will have your very own Mild Concern Eurovision 2013 Party Score Collation Spreadsheet for Maximum Fun and Mathematical AccuracyTM.

It is all pretty self-explanatory, I hope, but here’s a quick guide. When you first open the spreadhseet make sure you have macros enabled. If you see a warning like this…
Macros…deal with it.

The first thing you see with be an empty white box. Type in the first voter’s name and hit Enter, then continue until you can see everyone’s name in the list. If someone goes to the loo at this point and is pretty forgettable they may be in trouble. Once you’re done click on the grey button.

Name Form

Now you are at the heart of the spreadsheet. The table to the left will show you which country is winning based on your party’s votes and the table on the right is where everyone enters their scores. When prompted each person should list their top ten countries to the group, preferably with reasons and some slurring, while the Spreadsheet MasterTM uses the drop-down lists to put these countries into the table Once all ten are entered the voter should verify the list, salute the Spreadsheet MasterTM (optional), and they will hit the “Submit Scores” button which will…. submit the scores (I told you it was self-explanatory).

Score Form

Once everyone has voted you will have your winner! What mathematically accurate fun we’ve all had in replicating the voting process of the Eurovision Song Contest. If only all parties had spreadsheets…