This 2015/2016 UEFA Champions League will enter the 61st season as Europe’s premier club soccer tournament. Its format has been changed several times, and 2015/2016 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. Compared with last year, there is a change on assigning first seeded in each group. It is not based on UEFA coefficient anymore. It will be based on last season Champions League winner (Barcelona) plus Football League Winners from 7 UEFA countries. And the draw that held in Monaco on 27th August 2015 has yielded groups with club participants as follows :
Group A – Paris Saint-Germain, Real Madrid, Shakhtar Donetsk, Malmo FF
Group B – PSV Eindhoven, Manchester United, CSKA Moscow, Wolfsburg
Group C – Benfica, Atletico Madrid, Galatasaray, Astana
Group D – Juventus, Manchester City, Sevilla, Borussia Monchengladbach
Group E – Barcelona, Bayer Leverkusen, AS Roma, BATE Borisov
Group F – Bayern Munich, Arsenal, Olympiacos, Dinamo Zagreb
Group G – Chelsea, Porto, Dynamo Kyiv, Maccabi
Group H – Zenith St. Petersburg, Valencia, Lyon, Gent
As you can see, there are 5 Spanish clubs in Group Stages this season. What an achievement.
I have created this 2015/2016 Champions League Fixtures and Scoresheet to simulate this tournament. 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 14th 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 2015/2016 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 2015/2016 Champions League Fixtures and Scoresheet