UEFA Champions League Fixtures and Scoresheet 2019/2020

• Version
• 73'275 Downloads
• 415 KB File Size
• November 19, 2019 Updated
• 11 Number of comments
• ★★★★★

  ★★★★★
  Rating

This 2019/2020 UEFA Champions League will enter the 65th season as Europe's premier club soccer tournament. Its format has been changed several times, and 2019/2020 format will remain the same with last year format, where 32 teams will be distributed into 8 groups and the top two in each groups will advance to the knock out round. And the draw that held in Monaco on 29th August 2019 has yielded groups with club participants as follows :

Group A - Paris Saint-Germain, Real Madrid, Club Brugge, Galatasaray
Group B - Bayern Munich, Tottenham, Crvena Zvezda, Olympiacos
Group C - Manchester City, Shakhtar Donetsk, Dinamo Zagreb, Atalanta BC
Group D - Juventus, Atlético Madrid, Lokomotiv Moscow, Bayer Leverkusen
Group E - Liverpool, Napoli, Salzburg, KRC Genk
Group F - FC Barcelona, Borussia Dortmund, FC Milano, Slavia Praha
Group G - Leipzig, Olympique Lyonnais, FC Zenit, SL Benfica
Group H - Ajax, Chelsea, Valencia, LOSC Lille

It should be interesting to see how far Real Madrid can go this year after losing Cristiano Ronaldo and Zinedine Zidane. Real Madrid are the defending champions, having won the title for three successive seasons in 2015–16, 2016–17 and 2017–18. Also, with Cristiano Ronaldo switch side to Juventus, we will see how far he could bring his new team.

I have created this 2019/2020 Champions League Fixtures and Scoresheet to simulate this tournament. The format is similar with previous year template. All clubs are already placed in match fixtures and all formulas has been adapted to rank the clubs in each group based on their match results. All you have to do just typing the score in score boxes. when all group matches are completed, you can pairing group winners and runner ups by typing their match number based on round of 16 drawing result which should be taken on 17th December 2018.

I made some changes in knock out round worksheet. I moved extra-time and penalty shoot out boxes from the middle of knock out bracket to the second leg bracket. With this new box position, you will be aware where the extra time and penalty shoot out take place where away goal double value is still considered in extra time period even though it is not considered in penalty shoot out.

In this modified worksheet, you don't have to type anything in the middle. It will show you the aggregation of both leg matches automatically. There are 2 drawing table in the middle of this worksheet. The left one is a quarterfinal drawing table that can be used after all round of 16 matches are completed, the right one is a semifinal drawing table that can be used after all quarterfinal matches are completed.

I think all of you already know how to use this spreadsheet. Just in case you are new to this template, you can watch my simple guide below.

And here is the file that you can download. Let me know if you found error in that template.

You can customize this UEFA Champions League spreadsheet, you can put your own text or business logo inside, you can see all the formulas and tweak it to meet your own needs.

There is also a version for Europa League that I have created since 2017/2018 season that you can download as well.