UEFA Euro 2020 Sweepstake


UEFA EURO 2020 Sweepstake or office pool spreadsheet is your choice of spreadsheet if you want to play prediction game with your friends and relatives.

It should be fun if you can play a prediction game with your friends, colleagues and relatives in this year Euro 2020 football final tournament. And this spreadsheet should be helpful because there are plenty of setting options available in this spreadsheet where you and your friends just predict the scores and let the spreadsheet formulas do all the calculation.

UEFA EURO 2020 Predictor Game Spreadsheet

This Euro 2020 Office Pool has additional features compared with the previous Pool spreadsheet for Euro 2016 football final tournament, or even Euro 2012, if you have ever used them previously. This new version has a capability to map knock out bracket pairing matches based on player’s prediction. And there are extra points will be awarded for group standings correct prediction.

You can start download Euro 2020 predictor game spreadsheet to play around with all features inside. There are 4 main worksheets you might use frequently during the game.

UEFA EURO 2020 Sweepstake Spreadsheet

1. Setup

Set all parameters for your game in this worksheet. There are point value fields where you can set your own points for group and knock out stages as well as points for bonuses. Here, you can choose whether your knock out teams will be paired based on your player’s predictions or based on real results.

Euro 2020 Sweepstakes - Setup

2. Player Scoreboard

This is a worksheet where you have to type all of your prediction game’s players. Remember to differentiate player names if you have players with similar names. Also, do not type player names in other worksheets. Player names in other worksheets will pull them from player scoreboard worksheet.

CHECK THIS TEMPLATE >  Home Affordability Calculator

Euro 2020 Sweepstakes - Set Player

3. Game Board

Fill actual matches and player’s prediction scores in this worksheet.

a. Player Prediction Table

Put all of your player’s score prediction in the table at the right side. You can put them in respective player table. Player names are set on top of each table. Collect your player’s scores using Euro 2020 Schedule and Scoresheet template or Prediction Sheet if you purchase the Pro version. If you set the option to “player’s prediction”, you can type player’s score from the beginning match until final match. You won’t have difficulties on typing score in knock out stages because qualified teams will be placed automatically based their prediction. If you set the knock out stages to “actual matches”, you must wait until actual group matches are finished to see actual teams placed in correct bracket.

Euro 2020 Sweepstakes - Fill Prediction Scores

Do not forget to pick your team that you predict to become the Champion in this Euro 2020 Office Pool spreadsheet . It will give you extra points if you pick it correctly.

b. Actual Matches Table

Every time actual match is completed, you must update the score in this table. Players will earn points after you update it automatically.

Euro 2020 Sweepstakes - Fill Actual Scores

4. Player Leaderboard

You can track your player’s rank in this worksheet. It will be based on :

  1. Higher total points (match + bonus points)
  2. Higher number of correct predictions
  3. Higher total match points
  4. Entry order in Player Scoreboard worksheet

This free version can accommodate up to 10 players. You can purchase the Pro version if you plan to play with up to 100 players. There are Googlesheets version as well.

CHECK THIS TEMPLATE >  Euro 2020/2021 Schedule and Scoresheet

This spreadsheet requires a minimum Microsoft Excel 2007 for Windows and Microsoft Excel 2008 for Mac.

  Euro 2020 Predictor Game V3.43 - Free Version (1.4 MiB, 6,453 hits)



Spread the love
Close Menu