Just | ![]() ![]() ![]() |
days left |
Last Update: 2023-03-03 (Vers. 1.5.1) Download
★ NO EXCEL SKILLS REQUIRED ★
More screenshots: Fair play scores Language selection Assignment of the 3rd-placed teams Time zone selection Direct comparisons
For
If you're having fun betting on match results with family or friends and turning it into a little competition, you can show the hidden worksheets
'Predictions_1',
'Predictions_Ranking_1' and
'PrSettings'.
Further information is available here: ▸Betting match results.
If you are interested:
The fully completed EURO 2020/2021 schedule can be downloaded here:
EURO 2020/2021 schedule
The Excel schedule is not password protected. There are no restrictions on its use. It can be freely changed and adapted to your own wishes. All hidden tables can be shown and are thus freely visible and manipulable.
EURO 2024 will take place in Germany.
The opening game starts on 14. June 2024 at 9 p.m. in Munich.
The tournament ends with the final on 14. July 2024 at 9 p.m. in Berlin.
Venues are Berlin, Leipzig, Hamburg, Dortmund, Gelsenkirchen, Düsseldorf, Cologne, Frankfurt, Stuttgart and Munich.
The draw for the group stage of the European Championship will take place on December 2, 2023 in Hamburg's Elbphilharmonie. 6 groups of 4 teams each are formed again.
Official UEFA EURO 2024 schedule in PDF format
The draw for the qualifying groups took place on October 9, 2022 in the Festhalle in Frankfurt. Russia was excluded from the tournament. Germany is automatically qualified as the host country. The German team waived a guest role in the qualification.
Drawn groups
The rules for qualifying for the round of 16 are just as tricky as last time.
As usual, the first in the group, the second in the group and the four best third in the group qualify. The fair play rating (1 minus point for YELLOW, 3 minus points for YELLOW/RED and 3 minus points for RED) is also taken into account again.
The UEFA overall European Qualifiers rankings can also be used. A penalty shoot-out in the last group match is also possible in special cases. - See
Example penalty shoot-out
It should be noted that in the event of a tie, the direct comparison has priority over the goal difference and the number of goals scored in all group matches. So it can happen that a team is higher than another despite a worse goal difference! - See Example direct comparison
In summary, the criteria for determining the ranking within a group are according to Article 20 of the UEFA regulations:
Additional rule:
If two teams claim the same rank at the final whistle of the last group game based on criteria 1 - 7 and no other team in the group in question has achieved the same number of points, criteria 9 and 10 do not determine the final placement of these two teams, but a penalty shoot-out.
Note: So that the criteria 1 - 7 do not lead to a distinction for the two teams, the two teams have to play a draw in the last group game, because otherwise the direct comparison would decide on the better placement. The number of wins (criterion 8) is then inevitably the same.
Criteria 3, 4 and 5 are only relevant if more than two teams are tied on points at the end of the group stage. If, for example, three teams are tied on points, a direct comparison is carried out according to criteria 2 - 4. The points achieved, the goal difference and the number of goals scored solely from the direct encounters of this group of three now determine the ranking within the group of three. It can happen that two of the three teams cannot be distinguished from each other in this direct comparison. Criteria 2 - 4 will then be reapplied to these two teams (see point 5 above). If no differentiation of these two teams is possible, Criteria 6 - 10 are checked for the two teams.
To determine the four best group third, criteria 1 and 6 - 10 are applied to the six group third. Criteria 2 - 5 do not apply as there are no direct encounters.
The winners of groups B, C, E and F each meet a group third in the round of 16. Which of the four group thirds they get as opponents depends on which groups the thirds come from. There are 15 ways for this. For all 15 possibilities, UEFA has come up with a rule that ensures that the opponents in the round of 16 do not come from the same group.
View allocation table
* * *
All of these UEFA criteria and regulations are automatically carried out in this Excel schedule.
* * *
For questions and suggestions:
mail@hermann-baum.de
Excel functions SORT, SORTBY, FILTER and UNIQUE now also available for Excel 2007 - Excel 2019
Functions for Excel 2007 - Excel 2019
Detailed introduction to the world of array formulas
Tutorial "Array formulas"
This website does not store any personal data
and does not use cookies