World Cup 2010 Schedule and Scoresheet - Group Stages

GROUP STAGES
This scoresheet consists of two big parts, the group stage part and the knock out round part. In the group stage part, you should fill the blue color boxes in all 48 group matches with the real score results or your score prediction. You will see the group standing table next to group matches table are changing automatically based on your input.
After all teams playing their group matches, the excel formula will place the team which quality in first and second position of the group based on group standing regulation. If their points are not the same, it is easy to place the team in first and second position. And the challenge in creating the spreadsheet is in this part, where I have to create the correct formula that will accommodate all possible condition based on FIFA tie regulation. I quoted the group ranking regulation from FIFA World Cup document :

The ranking of each team in each group will be determined as follows:
a) greatest number of points obtained in all group matches;
b) goal difference in all group matches;
c) greatest number of goals scored in all group matches.

If two or more teams are equal on the basis of the above three criteria, their rankings will be determined as follows:
d) greatest number of points obtained in the group matches between the teams concerned;
e) goal difference resulting from the group matches between the teams concerned;
f) greater number of goals scored in all group matches between the teams concerned;
g) drawing of lots by the FIFA Organising Committee.

At least, this tie regulation is much more simpler than Champions League Group tie regulation. I put some samples of the implementation of group ranking regulation as you can see in the pictures. I will explain the ranking regulation applied in each group to give you better understanding on this group ranking and tie regulation.
Group A (Rule a) and b) applied)
After all teams played their matches, France is qualified without question based on rule a) and South Africa is qualified based on rule b) because South Africa has a better goal difference compare with Uruguay.

Group B (Rule a) and c) applied)
In Group B, Argentina and South Korea are having the same point. Because both teams have the highest points compare with other teams in Group B, both teams are qualified. And based on rule b), South Korea will get the top position because South Korea scored more goals, 7 goals, compare with Argentina, 6 goals.

Group C (Rule a) and b) applied)
In Group C, England and Slovenia are having the same point, six. Eventhough England beat Slovenia in their meeting, Slovenia will top the group because Slovenia has a better goal difference.

Group D (Rule b) and tie rule d) applied)
There are three teams that are having the same points. Based on rule b), Serbia will top the group. And because Ghana and Germany are having the same goal difference and the same goal scored, tie rule d) will make Ghana deserve the runner up position because Ghana beat Germany in their meeting.

Group E (Rule c) applied)
This group also has three teams that are sharing the same points. They also has the same goal difference. But, Japan scored more goals than Netherlands, and Netherlands scored more goals than Denmark. So, Denmark is eliminated based on rule c).

Group F (Rule a) and c) applied)
In this group, Italy is topping its group and Slovakia take the runner up position based on rule a) and c).

Group G (Rule a) and tie rule d) applied)
In Group G, Brazil is qualified perfectly by beating all its opponents. But, the others are having the same points (3). Based on rule c), North Korea and Cote-d’Ivoire will go into tie regulation to decide which team will advance to the next round. And tie rule d) reveal North Korea as a runner up because they beat Cote-d’Ivoire in their meeting.

Group H (Rule a) and tie rule g) applied)
This group will use tie rule g) to decide whether Chile or Switzerland that will accompany Spain advance to the next round. Both teams are having the same points, goal difference, goals scored, and also they are sharing the same point in their meeting. So, FIFA will draw them, and in this example, Chile is lucky. But, I haven’t finished to create a drawing table that can be manually filled. In this spreadsheet version, this ranking is still based on FIFA rank, used for group drawing. I plan to reveal a drawing table when some teams are going to be drawn and can be filled manually in the later version.

As additional information, this is the FIFA team ranking used as group drawing lots reference . I took the information from Wiki.

1. South Africa (hosts)
2. Brazil
3. Spain
4. Netherlands
5. Italy
6. Germany
7. Argentina
8. England
9. France
10. Portugal
11. United States
12. Switzerland
13. Cameroon
14. Greece
15. Chile
16. Mexico
17. Côte d’Ivoire
18. Serbia
19. Paraguay
20. Australia
21. Uruguay
22. Denmark
23. Algeria
24. Nigeria
25. Slovakia
26. Honduras
27. Ghana
28. Japan
29. Korea Republic
30. Slovenia
31. New Zealand
32. Korea DPR

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