Tuesday, 1 April 2014

Ranking of teams in Group stage

This World cup template applies the full Fifa rules per below

(extracted from wikipedia  http://en.wikipedia.org/wiki/2014_FIFA_World_Cup#Final_draw)

“The group winners and runners-up advance to the round of 16. The ranking of each team in each group will be determined as follows:
Levels

1. Points obtained in all group matches;

2. Goal difference in all group matches;

3. 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:

4. Points obtained in the group matches between the teams concerned;

5. Goal difference in the group matches between the teams concerned;

6. number of goals scored in the group matches between the teams concerned;”

(7) EXCEL (my own code at this level) – create lookup to a unique reference list (i.e use a simple sequence , Brazil 1, Mexico 2  etc, or FIFA ranking). This is to enable Excel to complete unique sort and trigger drawing Lots options field

“X. Drawing of lots by the FIFA Organising Committee.” – manually enter order of teams.

Ranking of teams in Group stage- smartcoder247

No comments:

Post a Comment