UEFA Euro 2008 Football Match Template
Posted on April 27, 2008
Filed Under Soccer, Sports |
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.
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.
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.
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.
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 :
Article 7.07
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
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
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.
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.
———————————————————————————-
You can read and download my other templates below :
- Euro 2008 Scoresheet for PDA
- World Cup 2010 Wall Chart
- Champions League Fixtures 2009/2010
- Printable Tournament Bracket
- World Cup 2010 Schedule and Scoresheet
- 2010 FIFA World Cup Office Pool
- UEFA Euro 2008 Football Match Schedule
- Bowling Score Sheet
Comments
41 Responses to “UEFA Euro 2008 Football Match Template”
Leave a Reply
Hello, i like your file. I was thinking about using it for a pool. Can you provide me the protection password so I can modify it for a pool? Please…
Thanks,
Darek
Hello
First of all, thanks for the template, it is clear and usefull.
My problem is that I have tried to play with a group a situation: every match has the result 2-1 and Russia won against Greece and they have the same points but in the end Greece comes to top of the group. So the Article 7.07 doesn’t succeed here.
Spain 1 - 2 Russia
Greece 2 - 1 Sweden
Sweden 1 - 2 Spain
Greece 1 - 2 Russia
Greece 2 - 1 Spain
Russia 1 - 2 Sweden
Group D P W D L F - A Pt
Greece 3 2 0 1 5 - 4 6
Russia 3 2 0 1 5 - 4 6
Sweden 3 1 0 2 4 - 5 3
Spain 3 1 0 2 4 - 5 3
Sorry for my poor english.
Thank you for your correction. The bug is already fixed. You can download the newest excel spreadsheet.
Hi! Is it possible to add Swedish as Country Name Preference??
Thanks
Perhaps one could add a box where one can fill in the actual result and one where one can fill in the points.
My previous comment is in reference to if you want to make it a score prediction game…
wen i select an indian city the time is not correct..the time difference between india and switzerland/austria is 3hrs and 30 mins..but it gives 3hrs and 50mins difference..
Is it possible to have the password in order to change some things on the page
Very nice and useful excel document.
I found a small problem, when playing with different results :
Group A : (partial results)
==========================
Switzerland 4-3 Czech Republic
Czech Republic 2-5 Portugal
Switzerland 1-5 Turkey
Turkey 0-1 Czech Republic
will go to the following partial standings (see error in formula : standings for
Switzerland not displayed)
Group A P W D L F - A Pt
=====================================
Portugal 1 1 0 0 5 - 2 3
Turkey 2 1 0 1 5 - 2 3
#N/A 0 0 0 0 0 - 0 0
Czech Republic 3 1 0 2 6 - 9 3
Note :
Practically end-user is forced to fill in informations(match results) in correct order.
Probably this error is not happening if all the results match are filled in correct order.
Hi again,
seems is not releated to order of filling :
Switzerland 3-0 Czech Republic
Portugal 2-0 Turkey
Czech Republic 3-2 Portugal
Switzerland 1-3 Turkey
Rank Country P W D L F - A Pt
1 Turkey 2 1 0 1 3 - 3 3
2 Switzerland 2 1 0 1 4 - 3 3
3 #N/A 0 0 0 0 0 - 0 0
4 Portugal 2 1 0 1 4 - 3 3
and problem is the same even when all group results match are filled in.
Rank Country P W D L F - A Pt
1 Turkey 3 1 1 1 4 - 4 4
2 Switzerland 3 1 1 1 7 - 6 4
3 #N/A 0 0 0 0 0 - 0 0
4 Portugal 3 1 1 1 7 - 6 4
Switzerland 3-0 Czech Republic
Portugal 2-0 Turkey
Czech Republic 3-2 Portugal
Switzerland 1-3 Turkey
Switzerland 3-3 Portugal
Turkey 1-1 Czech Republic
Good day!
Great thing, thank You!!!
I got a little problem, … tried to copy template on my MDA II compact, but couldn’t do it because file is protected and activesync can’t convert it to .pxl. Help please!
Thank You in advance.
Hi. Firstly, thanks for your template.
I came from Jakarta, Indonesia. I think your time preference especially for Jakarta is a hour faster. For example, the opening match should begin at 00.00 (my area time) instead of 23.00 (as in template).
Hi Eduard,
Thank you for your correction. The problem is already fixed. You can download the latest excel file here.
Hi Dzaba,
I will make pxl file for PDA, and release it in a few days.
Cheers
Hi Rik,
My friend are working on that kind of prediction game. Probably he will release within a week.
Peace
Hi Eaddie,
Basically, there is a GMT changing time for European Country from late March until late October, that’s the reason when you see the live TV of european soccer within one season, the time schedule within that months is shifted by one hour.
But, after I checked your local time, your preference on Euro 2008 in Jakarta is right, because I followed the different European timezone. It already fixed in the latest version of Excel. You can download it again.
Thanks.
Hi there! this is a great worksheet. To use your sheet in my pool i need to edit few things like formating and other stuffs but not any formula! can you please give me the unprotecting password? you may email to me as well
thanks once again!
Hi - Like others I think the template is great but am using it in a pool so want to put peoples names by the teams, can I have the password to do the required editing?
Looking forward to pxl file!!!
Thanks
bola gila
suka sama cewek, bola, makanan,italia.
fifa italia
suka liga bola inggris
Hi again,
thanks for your quick feedback. Still problem in implementing article 7.07 of UEFA . See below.
Switzerland 1 - 0 Czech Republic
Portugal 1 - 2 Turkey
Czech Republic 2 - 0 Portugal
Switzerland 1 - 0 Turkey
Switzerland 0 - 4 Portugal
Turkey 3 - 0 Czech Republic
Group A P W D L F - A Pt
Switzerland 3 2 0 1 2 - 4 6
Turkey 3 2 0 1 5 - 2 6
Portugal 3 1 0 2 5 - 4 3
Czech Republic 3 1 0 2 2 - 4 3
Wrong : Portugal must be on last place because lose dirrect match with Czech Republic.
Hi…my friend’s can i change that your match template because it’s in protected, can you give me that password ?
This is excellent.
How do you do this.
Can I view the formulas so that I can learn how to do this as well.
Thanks,
Nad
Hello, i like your file. I was thinking about using it for a pool. Can you provide me the protection password so I can modify it for a pool? Please…
Thanks,
Brocko
Hi Eduard,
Basically, I am already aware about that issue, but there is no need to do some adjustment on third and fourth ranks in group phases because it doesn’t count to anything. Article 7.07 of UEFA is tend to regulate which country deserved to go to the next round when their points are equal after completing all their group matches.
Dear Darek, Josmith, Lirar, Neil, Alvin, Ned and Brocko
About the password, I already gave it to my friend who also try to develop some euro 2008 game. He said he will post his excel within two days, and his excel will be without password, so you can modify the excel sheet for your needs.
I cannot spread my password because it is my main password for all my application. And I cannot just made my spreadsheet open without password, because it would be better when the excel sheet is in use, all cells are protected well to prevent misstyping that can break the formula.
Peace
thanks for this good excel template euro 2008 schedule, but the problem is like the other else is the password. and as your answer before, we will wait for the new excel template within 2 days. now is the 2nd day
My friends finally finished his Euro 2008 prediction game sheet based on my template. You can download his excel file at his website, http://www.excelspreadsheet.net. And you can modify his excel too.
dude you totally ruined all your work by adding a password. I wont even download it now.
Hi,
You can find the unprotected excel file at my friend site at http://www.excelspreadsheet.net.
Cheers
Hi,
Use OpenOffice(http://www.openoffice.org/) and edit anything you want. No password you need.
Have fun
Hello, i like your file. I was thinking about using it for a pool. Can you provide me the protection password so I can modify it for a pool? Please…
Thanks,
Vince
I will appreciate if you fix the third and fourth placing as well.
Hi,
Any change I can have PW for full sheet? Curious to learn how you did this, that’s all. Won’t take credit away, I promise! Thanks
Hello, i like your file. I was thinking about using it for a pool. Can you provide me the protection password so I can modify it for a pool? Please
I really like this spread sheet and I would like to use it for a neighborhood tournament. Would this be OK with you and could you please provide the password?
Thanks in advance.
Any chance you will have a template ready for the 2010 football World Cup matches ?
I would be interested in a template for UEFA 2010 world cup as well thanks
Hi. Firstly, thanks for your template.
I have one question.
Is it impossiple to have 5 grupps with 5 teams?
Is there any template with that?
Wow,can you please send the spreadsheet so that i can learned this one, with the password. i guess my boss saw this one because he told me to do the same with our files, and thinking what the F***** he’s trying to tell me until i saw this today.