Euro 2012: The Super-Duper Interactive Retro Spreadsheet

By on May 23, 2012 in International Football, Latest | 4 comments

The finals of major football tournaments bring out the obsessive in many football supporters. Grown men can be seen in the queues in newsagents buying Panini stickers for sons and nephews that don’t exist, while it is entirely possible that the only wallpapering that will be done throughout the tournament will be of posters on walls, lovingly filled in by the hands of those that perhaps should be old enough to know better. In the twenty-first century, though, many of us will be spending much of our time during the tournament at the screen of a PC, a laptop or a tablet, and such manual updating is unfeasible. With this in mind, we are delighted to welcome Dave Boyle’s interactive spreadsheet to 200% for this summer’s jamboree. Here’s Dave to explain it to you himself:

So, after not being bothered last time due to fatherhood and England not being there, I’ve done a Euro 2012 spreadsheet to record results, predict pathways and work out who might win, to fill those spare hours before the tournament starts.

I say retro because the future is apps etc, but I’m a geek, not a proper programmer, so we can ditch that notion. You can use the sheet entitled ‘Customise’ to customise (clever, eh?) the time zone in which you are, which then puts the right kick off times in! And, if you’re a sweepstakes organiser, you can add in the names of the people who have drawn a certain team, so you can have them shown instead of, or at the same time as, the country name. Take that, smartphone app developers!

There are two versions of the spreadsheet, for use with different versions of Excel – the more recent version is here, whilst a version that will be compatible with older versions of Excel available here. If you wish to say thanks to Dave for going to the trouble to produce this for us, you can click on the pint glass on the spreadsheet to buy him a pint. It seems to us like a tiny price to pay for such a valuable resource!

You can follow Dave on Twitter by clicking here.

You can follow Twohundredpercent on Twitter by clicking here.

Share Button

    4 Comments

  1. What’s that noise Homer makes when he sees a donut?

    Mike Bayly

    May 23, 2012

  2. Neat spreadsheet. Unfortunately Goals For is calculated incorrectly for Greece, Denmark & Italy.

    Gareth

    June 14, 2012

  3. Future tip – protect the sheet to prevent accidents but don’t password it. It helps others learn if they can see your macros. Good spreadsheet though.

    Andy O

    June 19, 2012

Trackbacks/Pingbacks

  1. Euro Moments: Group A, day 1 | Twohundredpercent - [...] For more European Championship tomfoolery, you can read our Euro Stories here; or download and play with our retro …
  2. Euro 2012 News: David Villa Ruled Out of Spain’s Euro 2012 Squad Due to Injury | Fifa 12 Forums - [...] Euro 2012: The Super-Duper Interactive Retro Spreadsheet — Two Hundred Percent [...]
  3. Euro Moments: Group A, day 2 | Twohundredpercent - [...] Twitter: Dotmund / Twohundredpercent And don’t forget you can download Twohundredpercent’s retro interactive Euro 2012 spreadsheet here. [...]

Post a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>