[ Picture 1 – Enlarge ]
Following the European football biggest event this year, I made a match schedule and scoresheet template from excel that can be used as your reference for match schedule and scoresheet. This template equipped with formula that will automatically calculate the group standings of each team, based on Euro 2008 match regulation, everytime the score is filled in group matches.
When all group matches have been played, the template will automatically put each group winner and runner up in the template and you just simply put the score in the correct score cells. The formula will continue to work until the champion is revealed.
[ Picture 2 – Enlarge ]
There is a list of city time, so you can pick your city time as your match reference. And also there is several country name in other language for you to ease your country name preference which participate in this event.
More detailed about this template and how to use it are as follows :
Open the file and you will see the appearance as picture 1. If you want to change your country name, put your cursor on the country name preference cell and the dropdown list will appear for you to choose, as you see in picture 3. The default of country name is in English language and not all language available here.
[ Picture 3 – Enlarge ]
If you want to change your city time, put your cursor on city date and timepreference and the dropdown list will appear for you to choose, as you see in picture 4. The default of time is Vienna, Austria time.
[ Picture 4 – Enlarge ]
When the result of each matches is revealed, you can put the score in the score cells in the template, where the cells are in the light turqouise colour when it is empty as seen in picture 5. The standings at each group will be adjusted automatically when the score cells is filled correctly.
[ Picture 5 – Enlarge ]
The picture 6 will show you the group standings sample when all teams have played all their group matches. You can see when several teams are tied in points, the standings is adjusted according UEFA Euro regulation.
The regulation for teams which have the same points based on article 7.07 of UEFA as follows :
If two or more teams are equal on points on completion of all the matches in their group, the following criteria will be used to determine the rankings in the order given :
a. number of points obtained in the matches among the teams in question;
b. goal difference in the matches among the teams in question;
c. number of goals scored in the matched among the teams in question (if more than two teams finish equal on points);
d. goal difference in all the group matches;
e. number of goals scored in all the group matches;
f. coefficient from the qualifying competitions for the 2006 FIFA World Cup and 2006/08 UEFA European football Championship (points obtained divided by the number of matches played);
g. fair play conduct of the teams (final tournament);
h. drawing the lots
[ Picture 6 – Enlarge ]
When all the group matches is finished, the teams which will meet in quarter final will revealed in quarter finals area. Different from the group matches when ‘draw’ is allowed as a match result, in quarter finals, it has to be a winner, which can be decided from normal time period, extra time period or penalty shoot out. Just fill the score on the correct cells and the formula will calculate the result for you. You can see the sample from picture 7
[ Picture 7 – Enlarge ]
The process will be the same for semifinal and final. All you can do just fill the score in the correct score cells, and when all the score cells is filled, the champion will be revealed as the sample you see in picture 8.
[ Picture 8 – Enlarge ]
By the way, I am not a fan of Portugal eventhough the sample shows Portugal as Euro 2008 Champion. I just put all the number in random. You can do this as I do.
You can download the excel template here.
Let me know if there is any bugs.
Have fun !
After each team played twice in within their group, there is one match between Turkey and Czech Republic that will be end up in penalty shoot out if their match result is draw, based on a new Euro 2008 regulation. Just in case, if it happened that way, I prepared the new excel sheet to facilitate that match. I just made the simple function to accomodate this, because it is only one match.You can download it here.