Exceltemplates.org – 2020 Euro Cup Predictor Game template is a tool to organize prediction game with your friends during 2020 Euro Cup tournament that will be held in June-July 2021. The tournament is postponed to year 2021 because of pandemic situation but tournament name is kept similar.
You know, it is really fun to compete with your friends on predicting the outcome of particular world cup matches. With plenty of game options, you pick your type of game and organize it easily.
Start using this template by going to the setup worksheet to prepare your game.
These are game scenario you can set in this Euro 2020 predictor game template
- One time entry prediction game. This option will allow you to request your players to submit their scores once, from the first group matches until final match. Each players will get their own group standing table. It could yield different knock out teams for each players. This is a new feature that should very helpful for group of players that don’t have much time to watch every matches and give prediction before it.
- Knock Out round match winner bonus points. In knock out round, there are possibilities of draw after Full Time period which lead to penalty shoot out. Since the comparison only apply on Full Time boxes, if the scores are draw, then there are no winners for those matches. Match winner bonus points will be given to players who predict correctly who win the match regardless of the length of time period. For example, your player predict one team win 2-1 in FT period while the actual result is that team win 5-3 by penalty kicks. The players won’t get points from particular match but they will get points for predicting the winner correctly. You can disable this bonus points by zeroing it in bonus point table if you don’t want this rule to be implemented in your game.
- Best player and top scorer bonus points. These ones are new. Your player can predict best player and top scorer and get bonus points for their correct prediction.
In this version, the excel formulas will rank players as follows :
1. Total match and bonus points
2. Total correct prediction
3. Total match points
4. Player’s registration
Complete all setup parameters and put player names in player scoreboard worksheet. Then, you can go to All Players Board to fill your player’s prediction scores. If you pick player’s prediction matches as your type of knock out round game, you can type the score from the first match until the end. You can see that each group standings might have different outcome. It depends on group prediction scores from each players. To activate points calculation, you can type actual results in tournament actual results table in this All Players Board worksheet. Do this every time particular matches are completed. Furthermore, track your player’s progress in Player Leaderboard worksheet.
You can check with its author website on further scenario. Since there are plenty options you can set, you might think different ideas on implementing it with your groups. You may ask for customization.
You can download the free version of 2020/2021 Euro Cup Predictor Game template below. Not all features are available in this spreadsheet. But, there are full features version available to purchase.Download
Using Microsoft Excel to simplify your spreadsheet tasks is not as difficult as you think. I learned how to use it in less than 24 hours and rely on internet to find the solution if I got stuck. I am not an Excel expert, but here are all useful spreadsheets I have collected and created.