This 2016/2017 UEFA Champions League will enter the 62nd season as Europe’s premier club soccer tournament. Its format has been changed several times, and 2016/2017 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 25th August 2015 has yielded groups with club participants as follows :
Group A – Paris Saint-Germain, Arsenal, Basel, Ludogorets Razgrad
Group B – Benfica, Napoli, Dynamo Kyiv, Besiktas
Group C – Barcelona, Manchester City, Borussia Moenchengladbach, Celtic
Group D – Bayern Munich, Atletico Madrid, PSV, Rostov
Group E – CSKA Moscow, Bayer Leverkusen, Tottenham Hotspur, Monaco
Group F – Real Madrid, Borussia Dortmund, Sporting CP, Legia Warsaw
Group G – Leicester City, Porto, Club Brugge, Copenhagen
Group H – Juventus, Sevilla, Lyon, Dinamo Zagreb
I have created this 2016/2017 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 12th December 2015.
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 2016/2017 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 2016/2017 Champions League Fixtures and Scoresheet