This 2017/2018 UEFA Champions League will enter the 63nd season as Europe’s premier club soccer tournament. Its format has been changed several times, and 2017/2018 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 24th August 2017 has yielded groups with club participants as follows :
Group A – Basel, Benfica, CSKA Moscow, Manchester United
Group B – Paris Saint-Germain, Bayern Munich, Anderlecht, Celtic
Group C – Atletico Madrid, Chelsea, Qarabag, AS Roma
Group D – Sporting CP, Barcelona, Juventus, Olympiacos
Group E – Sevilla, Maribor, Spartak Moscow, Liverpool
Group F – Napoli, Feyenoord, Manchester City, Shakhtar Donetsk
Group G – Besiktas, RB Leipzig, Monaco, Porto
Group H – Borussia Dortmund, Real Madrid, APOEL, Tottenham Hotspur
I have created this 2017/2018 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 11th December 2017.
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.
If you want to customize this 2017/2018 UEFA Champions League spreadsheet, or if you want to put your own business logo inside it, you can buy the unprotected version. You can learn all the formulas that form this spreadsheet and tweak it to meet your own needs.
Get Fully Editable 2017/2018 Champions League Fixtures and Scoresheet