European football major league competition are closing to reveal its champions. By the time I posted this Euro 2012 Football Tournament Match Schedule and Scoresheet template, in Italy, AC Milan was trailing Juventus by one point, in Spain, Barcelona was trailing Real Madrid by 4 points, in England, Manchester United was leading Manchester City by 5 points which could endanger Roberto Mancini position as City head coach.
Soon after all leagues finished their competition, all players where their countries are participating in Euro 2012 football tournament, which will be held in Poland and Ukraine between 8 June and 1 July 2012, will have to prepare theirselves for the tournament. There are 16 countries that will fight to become the best team in Europe this year.
Twelve of those sixteen finalists are participated at the previous tournament in 2008. The last participation of two team, England and Denmark, were in 2004. Republic of Ireland is return after an absence of 24 years. Ukraine make their debut as an independent nation, having previously participated as part of the Soviet Union.
The complete sixteen finalists are: Croatia,Czech Republic, Denmark, England, France, Germany, Greece, Italy, Netherlands, Poland(Co-host), Portugal, Republic of Ireland, Russia, Spain(Defending Champion), Sweden, Ukraine (Co-host)
All team are divided into 4 groups where each countries will meet once and the winner and runner up of each groups will advance into knock out phase.
There is a tie-breaker rule will be applied when team are sharing the same points after all group matches are completed.
The rule is based on paragraph 8.07 and 8.08 of UEFA policy document, which quoted as follows :
If two or more teams are equal on points on completion of the group matches, the following criteria are applied, in the order given; to determine the rankings:
a) higher number of points obtained in the matches among the teams in question;
b) superior goal difference in the matches among the teams in question (if more
than two teams finish equal on points);
c) higher number of goals scored in the matches among the teams in question (if
more than two teams finish equal on points);
d) superior goal difference in all the group matches;
e) higher number of goals scored in all the group matches;
f) position in the UEFA national team coefficient ranking system (see Annex I, paragraph 1.2.2);
(1) Spain 43,116
(2) Netherlands 40,860
(3) Germany 40,446
(4) Italy 34,357
(5) England 33,563
(6) Russia 33,212
(7) Croatia 32,723
(8) Greece 32,455
(9) Sweden 31,675
(10) Denmark 31,205
(11) Portugal 31,202
(12) France 30,508
(13) Republic of Ireland 28,203
(14) Ukraine 28,029
(15) Czech Republic 27,982
(16) Poland 23,806
g) fair play conduct of the teams (final tournament);
h) drawing of lots.
If two teams which have the same number of points, the same number of goals scored and conceded play their last group match against each other and are still equal at the end of that match, the ranking of the two teams in question is determined by kicks from the penalty mark (Article 16), provided no other teams within the group have the same number of points on completion of all group matches. Should more than two teams have the same number of points, the criteria listed under paragraph 8.07 apply.
It looked like that the tie breaker rule for this tournament will stop at point f), because there are no countries that are sharing same coefficient.
There are 4 type of spreadsheets available to be downloaded, and I will add more model next month. The flag images I used in these spreadsheets are taken from nordicfactory.com.
How to use this spreadsheet :
Change Language :
Click the drop down box at cell H2 and select your prefered language. There are 41 languages available to be chosen.
Those are: Afrikaans, Albanian, Arabic, Bulgarian, Catalan, Chinese (Simplified), Chinese (Traditional), Croatian, Danish, Dutch, English, Finnish, French, Georgian, German, Greek, Hebrew, Hungarian, Indonesian, Icelandic, Italian, Japanese, Korean, Lithuanian, Macedonian, Malay, Maldives, Maltese, Mongolian, Norway, Persian, Polish, Portuguese (Brazil), Portuguese (Portugal), Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Spanish (Argentine), Swedish, Thai, Turkish, Ukrainian, Vietnamese.
Most of them are based on translation of World Cup 2010 tournament spreadsheet. I used Google Translation service to translate some words that I couldn’t find from that World Cup spreadsheet. I would be pleased if you can send me some corrections if you found improper translation.
Change Timezone :
Click the drop down box at cell H4 and select your prefered timezone. If your city is not available in the list, just select the timezone which represent best your city timezone.
Group Phase :
Fill the score in score boxes and let the formula works.
Knock Out Phase :
When all group matches are finished, all group winners and runner ups will automatically be placed in corresponding boxes. Fill the “Normal Time” score boxes, followed by “Extra Time” score boxes if the matches is going into extra time, followed by “Penalty Shoot Out” score boxes if the matches has to be decided by penalty kicks. Do this until the 2012 champion is revealed.
You can download those files below :
UEFA EURO 2012 Schedule and Scoresheet with Flag V3.13 (Excel 2007/2010) (436.9 KiB, 33,180 hits)
UEFA EURO 2012 Schedule and Scoresheet with Flag V3.13 (Excel 97/2003) (312.7 KiB, 15,058 hits)
UEFA EURO 2012 Schedule and Scoresheet without Flag V3.13 (Excel 97/2003) (162.4 KiB, 4,918 hits)
UEFA EURO 2012 Schedule and Scoresheet without Flag V3.13 (Excel 2007/2010) (180.0 KiB, 8,061 hits)
Let me know if you found some errors or bugs, so I can correct it before the tournament is begun.
If you like my templates, you can donate me 8 bucks and in return I will send you the unlocked template where you can see and learn how the tie breaker formula works as well as other excel formulas that form this template. And I believe that you will respect my creation that you will use for your own purpose and won’t distribute this unlocked template to anybody without my permission or claim it as yours.