Play prediction game with your friends, colleagues and relatives using UEFA EURO 2024 Sweepstake or office pool spreadsheet. It is designed specifically for this football tournament event.
It should be fun if you can play a prediction game using a tool that can be personalized with your own game regulation. 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.
This Euro 2024 Office Pool has additional features compared with the previous Pool spreadsheet for Euro 2020 football final tournament, 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 2024 predictor game spreadsheet to play around with all features inside. There are 4 main worksheets you might use frequently during the game.
UEFA EURO 2024 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.
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.
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 2024 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.
Do not forget to pick your team that you predict to become the Champion in this Euro 2024 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.
4. Player Leaderboard
You can track your player’s rank in this worksheet. It will be based on :
- Higher total points (match + bonus points)
- Higher number of correct predictions
- Higher total match points
- 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.
This spreadsheet requires a minimum Microsoft Excel 2007 for Windows and Microsoft Excel 2008 for Mac.
All 24 teams are set now. Poland, Ukraine and Georgia are last participants that qualified by March 26, 2024. Here is Euro 2024 Office Pool and Prediction Game Spreadsheet that you can download and use for your game.
Euro 2024 Office Pool-Predictor Game V3.52 (Updated 6/27) (1.4 MiB, 1,677 hits)