UEFA EURO 2024 Excel Schedule

Just enter game results - everything else is automatic!

★ NO EXCEL SKILLS REQUIRED ★    

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)
• LibreOffice
• WPS Office on Android Tablets
• Free Office for the web (formerly Office Online)
• EXCEL on Apple MAC

OpenOffice seems to get stuck when loading the match schedule. The formulas on the worksheets 'Predictions_1' and 'Predictions_2' are probably too complex for OpenOffice. If you still want to work with OpenOffice, you can download a stripped down version without the worksheets for the predictions:
EURO 2024 schedule for OpenOffice

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.

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
• Daily schedule for all tournament days
• 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.
• Printing out the match plan:
  The 'Print' sheet contains a copy of the match plan, which is optimized for printing on two A4 pages (landscape format).
  The 'Daily schedule' worksheet is also optimized for printing and can be printed out directly.

Betting match results

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_2',
'Predictions_Ranking_1',
'Predictions_Ranking_2' and
'PrSettings'.

Further information is available here: ▸Betting match results.

 

EURO schedule as PDF
After the group draw on December 2, 2023 and the play-offs in March 2024, all participants in the final round of the 2024 European Championship have now been determined.
EURO_2024_Schedule.pdf
EURO_2024_Schedule_A3.pdf

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.

Tutorial
Create this EURO schedule yourself with Excel
EURO_Tutorial_1.4_en.pdf
(Last updated: 2023-12-15)

 
Excel files for the tutorial
EURO_Tut_1.4_en.zip
(Last updated: 2023-03-03)
For the tutorial there are ten Excel files that represent the current status of the project after each of the ten chapters. So you can start at any point or skip chapters.

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

Hint:
There is also information and an EXCEL schedule for the Women's EURO 2025.
Looking for a high-quality tournament schedule for the next indoor tournament?   More

New European Champion: SPAIN

The EURO 2024 ended on July 14, 2024 with the final between Spain and England in Berlin's Olympic Stadium.

The new European champions are Spain. Spain defeated England 2-1 in the final.

Information about the qualification phase

Germany is automatically qualified as the host country.
Russia was excluded from the tournament.

The group matches in the qualifying phase took place from March 23rd to November 21st, 2023. In the play-offs on March 21 and 26, 2024, the last three participants were determined: Poland, Ukraine and Georgia.

The draw for the groups on December 2nd resulted in the following allocation of the qualified teams to the six groups:

More information on qualification

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 UEFA overall European Qualifiers rankings can also be used. Since the host country Germany is not represented in the European Qualifiers rankings, there may also be a drawing of lots if Germany and another country have a tie in all criteria including the fair play rating.
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:

1. higher number of points obtained in all group matches
2. higher number of points obtained in the direct encounters
3. higher goal difference resulting from the direct encounters
4. higher number of goals scored resulting from the direct encounters
5. repeated application of the criteria 2 - 4 only on the teams that were indistinguishable in the 1st run
6. higher goal difference resulting from all group matches
7. higher number of goals scored resulting from all group matches
8. higher number of wins in all group matches (only when comparing the third-placed teams)
9. 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)
10. 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: If criteria 1 - 7 do not lead to a distinction between two teams in the same group, then the number of wins from all group matches (criterion 8) is also necessarily the same. Therefore, this point is only applied when comparing the third-placed teams.

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

Further information

More Excel solutions

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"

Privacy

This website does not store any personal data
and does not use cookies

Imprint