Track your favorite team in this new format of UEFA Euro 2020 Football Championship tournament using this Excel template. See your team schedule, put their actual score results and see your team position in their respective groups.
24 teams will compete to become a champion on this 4-yearly event. After successful first tournament with 24 teams in 2016, UEFA decide to keep the number of teams to compete for the Euro trophy again. But, this time it will be hosted in 12 countries. And, that is the first time. By spreading the hosts, UEFA try to get as much viewers as possible from all around European countries. 7 hosts already have their representative in this tournament, those are Denmark, Netherlands, England, Germany, Italy, Russia and Spain. There are possibilities of 4 more hosts that will join them through playoff matches. Those 4 are Republic of Ireland, Romania, Scotland and Hungary. Their destiny will be determined in March.
Portugal, the reigning champion, don’t have a privilege as one of those hosts. And their path to defend its title will be harder since they are placed in Group F with France (2016 finalist) and Germany (2016 semifinalist). But, don’t worry. Even if Portugal falls to the 3rd place, they still can advance to the knock out round by becoming 1 of 4 3rd-best place team. There are 16 spots available in the knock out rounds.
It will be tough to calculate group rank manually due to complicated tie-breaker regulation. That’s why this Euro 2020 Schedule and Match Scoresheet will help you solving those headache by just typing scores in respective matches.
There are formulas work in the background that will adjust group ranks automatically. They will also place teams in knock out bracket automatically. Then you can continue to fill the scores until the final round.
Also, there are conditional formatting formula that will colorize highlighted matches, teams and knock out brackets. It should be useful to track performance of teams from particular groups. Furthermore, it should ease you to spot your team in this Excel template.
We have created several versions of Euro 2020 spreadsheets. The first version only has score fields to update the scores. Other has stats and goal scorers fields to accommodate you who want to track your favorite team in more detail. Details and records should be taken into accounts while predicting their matches. Also, head-to-head records should give you additional consideration on predicting the winner. Don’t forget to try our partner pool spreadsheet that you can use to play prediction game among your friends and relative during this tournament.