File Notes

***

World Cup Group H – Important Note

Group+H

***

Ranking of teams in Group stage

This World cup template applies the full Fifa rules per below
(extracted from wikipedia  https://en.wikipedia.org/wiki/2018_FIFA_World_Cup#Tiebreakers)
“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 (Smartcoder247 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.