EURO 2024 EXCEL schedule

Website last updated: May 13th, 2022

The new EURO 2024 schedule is here!

Free of charge - no annoying advertising - created with attention to detail

Last Update: 2022-05-12 (Vers. 1.0) Download

New after suggestions from users:

Tables of direct comparisons, time zone selectable, completely multilingual, note "a.e.t." possible, in the knockout phase input fields for the match result after 120 minutes and the penalty shoot-out, coloured underlay of qualified teams.

hinweispfeil Click to view full picture

More screenshots: Fair play scores Language selection Assignment of the 3rd-placed teams Time zone selection Direct comparisons

For

Microsoft Excel (all versions from Office 2007)
OpenOffice
WPS Office on Android Tablets
Free Office for the web (formerly Office Online)
EXCEL on Apple MAC

Just enter game results - everything else is automatic!

★ NO EXCEL SKILLS REQUIRED ★ smiley

With the help of "Office for the web" it is possible for several people to share a game schedule. One uploads it to OneDrive and sends the other a "Share" link. Anyone with the link can use this link to view the game schedule in their web browser and make entries.

Here is an example of such a shared game schedule: hinweispfeil

To the schedule

If you click on "Show" in the menu bar above and select "Edit", you can make (permanent) entries.

With the help of this Excel file you can investigate the question "What if ..." or experiment with it.
In the group stage you can see immediately after each entry of a game result what effect it has on the group table and the pairings in the round of 16.

Functions of the Excel spreadsheet

Automatic calculation of the group tables
taking into account all UEFA rules including the
fair play ranking and the
UEFA overall European Qualifiers ranking
Automatic determination of qualified third parties
Automatic placement of the qualified teams in the round of 16, semi-finals and finals (group thirds according to the UEFA assignment table)
Tables of the direct comparisons
Choice of national language and possibility to add the own language
Time zone selection
A colored background indicates games that have already taken place but the match result is missing.
Groups in which the order is not clear due to the results of the matches and in which the fair play rating or the overall European Qualifiers rankings are taken into account are marked with a red dot •
Possibility to enter the fair play ratings
Coloured marking of the teams that have qualified for the round of 16
Special case "Penalty shoot-out in the last group match":
If there is a draw in the last group match and the two teams are ranked equally, a penalty shoot-out will decide the ranking.

If you are interested:
The fully completed EURO 2020/2021 schedule can be downloaded here:
hinweispfeil EURO 2020/2021 schedule

Usage instructions

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.

Updates

The macro version is no longer being further developed. If you are still interested in the VBA code, you can download it hinweispfeil here.

Version	Date	Comment
1.0	12.05.2022	First version of the EURO 2024 Excel schedule with date and venue of the matches; kick-off times and team names (A1, A2, A3, ...) are provisional.

Information about EURO 2024

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 qualifying groups will take place on October 9, 2022 in the Festhalle in Frankfurt.

The draw for the group stage of the European Championship will take place in December 2023 in Hamburg's Elbphilharmonie. 6 groups of 4 teams each are formed again.

hinweispfeil Official UEFA EURO 2024 schedule in PDF format

Rules for qualifying for the round of 16

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 note arrow 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 note arrow UEFA regulations:

higher number of points obtained in all group matches
higher number of points obtained in the direct encounters
higher goal difference resulting from the direct encounters
higher number of goals scored resulting from the direct encounters
repeated application of the criteria 2 - 4 only on the teams that were indistinguishable in the 1st run
higher goal difference resulting from all group matches
higher number of goals scored resulting from all group matches
higher number of wins in all group matches
lower number of disciplinary points total in all group matches (red card = 3 points, yellow card = 1 point, expulsion after two yellow cards in a game = 3 points)
position in the UEFA overall European Qualifiers rankings

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.
note arrow View allocation table

* * *

All of these UEFA criteria and regulations are automatically carried out in this Excel schedule.

Have fun with the Excel schedule!

For questions and suggestions:
mail@hermann-baum.de