I'm developing a spreadsheet to emulate the tournament 'wallchart' you get for football tournaments. The regulations governing the ranking of teams (Article 19.04 found here) states the following:
On completion of the final tournament group stage, final group standings are compiled based on the number of points obtained by each team in the group.[...]
Article 20.01 goes further and details how to sort teams on completion of the final tournament group stage (i.e. by using head-to-head records).
Initially, I would try to sort teams as the games were played (i.e. if they were level on points, I would try to use Article 20.01). However, this would create some unusual rankings:
Teams that have not played each other yet cannot be ranked using head-to-head (in this example, Switzerland have not yet played either Italy or Turkey).
Question: I have changed the sorting to use Overall Pts, Overall GD then Overall F to sort teams at the moment. When the final group game scores have been entered then, and only then, do head-to-head tiebreakers get used. Is this approach correct?
Or should we try to apply the head-to-head rules as games are played? If so, how should teams be ranked if they have not played each other yet? See another example below: