World Cup 2010 Schedule and Scoresheet - Page 1 - Description

It is not easy to write again after three months I didn’t write and post any templates. And, I am really sorry for not replying many comments due to my time limitation to monitor this site. But…, I am back now with my newest sport template, World Cup 2010 Schedule and Scoresheet Template. This template is the first version, because I plan to add analysis worksheet which can help you (and me of course :-)) analyzing your favourite teams before they play their matches.
This template is based on my previous Euro 2008 template. Because World Cup 2010 tournament consists of 32 teams, compare with Euro 2008 tournament which only consists of 16 teams, I made lay out modification to make the sheet fit nicely and properly if it is printed within one page A4 or letter paper size.


I am also adjusting the excel formula for deciding and ranking the teams that qualify to the next round after they played all their group matches, if two or more teams have same points, based on World Cup tournament tie regulation where the tie regulation is slightly different with Euro 2008 tie regulation.
I maintain the language and timezone conversion, so you can use or print this template based on your language and time zone. I would like to thanks to Google which provide a very good translation tool which translate my words in this template in seconds. But, I still need a better human translation to make it fully comply with your language. You can help me refining that translation, or add new language translation, by downloading the language file and send it back to me. I will put your name as credit in this site. There 34 different languages and 139 cities timezone available in this version. Just select your language and timezone from the dropdown list in the upper left side of the worksheet to change the appearance of the worksheet into your local language and timezone.
I add a new excel formula to dynamically manage the appearance of team or country flags in Group Standings Table. In the beginning, I plan to put that formula next to every teams in every matches. But, it makes the excel run very slow every time you change cells or fill the scores. So, I decided to drop the formula in any team matches and apply the formula in Group standing table only.
Now, let’s go to the detail on how to use this spreadsheet as your scoresheet. If you ever had download my sport templates, you will be familiar with my sport style template where there are score boxes with blue color which ready to be filled with your estimation score or real score results.And you don’t have to read this instruction. Just use it. For you that download this spreadsheet for the first time, you can read this explanation below carefully to understand how this spreadsheet works.

1. Page 1 - Description
2. Page 2 - Group Stages
3. Page 3 - Knock Out Stages and File Download