Champions League 2021-2022 Scoresheet
We present to our English users the spreadsheet “Excel Champions League Pool Template”. The past years we have published spanish version of National Teams competitions such as: Excel World Cup template, Excel Euro pool template or America Cup template (in spanish). And we continue this season with the Champions League 2021-2022 in excel. Last year we was surprised for the success of this template.
The template has different ways of use: you can use as an Excel fixture of the Champions League for your own use, or you can use the files as a pool, sweepstake champions, excel Champions schedule with your friends, your workmates, with the bar clients or whoever you want to play.
As always I want to thank SandruskDesign for helping us with some aspects of the template design. What an artist she is!
Once the standings draw has been celebrated on we’ll publish the Excel template of Champions League.
We are great fans of the Champions but we’ve never playe a pool of this tournament, and this season is the first time we’re going to play the pool with our friends.
This Excel Champions League sweepstake is a bit different from other national teams tournaments. The National team tournaments, such as the Euro or the World cup, are played during a few weeks and the draws are closed before the start, however the Champions is played along the whole soccer season. Also there are some draws during the tournament: for the group standings, the round of 16 and the round o quarterfinals. So you have to be aware not to miss any game. But there are also advantages, because if you don’t hit results in the first rounds, you can have the same new opportunities in the following rounds.
In the Champions you have 1st and 2nd leg in all the rounds except in the final, that is a unique game. This excel is adapted the Champions rules. This file is only based in formulas, ther aren’t any macros.
How to use Excel Champions League 2021-2022
It’s very easy to use this template and when you download the template you can see also the instructions. In the group stage you only have to fill in the grey cells with your results predicition. You can fill in all at one time or you can go round by round. The group standings will be based on your predictions. In case of equality you can choose the order of the drawings clubs.
When the groups stage has finished, there will be the Round of 16 draw. When you open the file after the draw, you should allow to refresh content, but if don’t ask you will have to refresh data (press F9) and you will see the Round of 16 matches-up.
Then you can fill in your predictions of every game, and in case of draw at the end of the 2nd leg 2 extra grey cells will open to undo the draw.
For the next rounds: quarterfinals, semifinals and final you have to repeat te following steps in each round: update data in excel to see de Draw matches-up, fill in your predictions and send it to the pool administrator
Download Excel file Champions League 2021-2022
Some comments to Excel Champions League:
- Last update: 27th August 2021
- This file can be used as fixture or for player prediction for the Champions sweeptake. It also contains a PDF file with the instructions
- Spanish version here
Also, for those who want to admin an Sweepstake of the Champions League 2020-2021, you can download at the bottom the file to manage the pool with the instructions.
Download ADMINISTRATOR file for Excel Champions League Sweepstake
Some comments to Administrator file
- Last update: 30th August 2021
- There are several versions depending on the number of participants you need. The version of this post includes up to 5 players. If you need a version for more than 5 participants click on the image to access different options.
- The downloadable file has several files: the excel file to manage the game and a PDF file with the instructions on how to organize the pool (Champions 2021-22 sweepstake) with your mates, friends and family.
As always, if you find some bugs, or you want to leave a comment, they are welcome. You can explain to us your pool rules, so other users can be able to get ideas of how to manage. You can also tell us were are you from, how many people play… Thank you very much in advance.
If it has been of your interest you can collaborate with a small donation.