UEFA Euro 2016 Sweepstake

UEFA Euro 2016 SweepstakeIt should be fun if you can play a prediction game with your friends, colleagues and relatives in this year Euro 2016 soccer tournament. And it should be helpful if you can find a spreadsheet that can accommodate it which will make you and your friends just predict the scores and let the spreadsheet do the rank calculation.

This Euro 2016 Office Pool has additional features compared with the previous Pool spreadsheet for Euro 2012 and World Cup 2014 football 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 the prediction game spreadsheet to play around with all features inside. There are 5 main worksheets you might use frequently during the game.

1. Setup
This is a worksheet where you have to set all parameters for your game. There are point value cells 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.

3. All Players
This is the place to put all of your player’s score prediction. You can collect your player’s scores using Euro 2016 Schedule and Scoresheet template. If you set the knock out stages to be based on 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 be based on real matches, you must wait until real group matches are finished to see real teams placed in correct bracket.

Do not forget to pick your team that you predict to become the Euro 2016 Champion. It will give you extra points if you pick it correctly.

4. Tournament
Every time real match is completed, you must update the score in this worksheet. This score update will be shown in All Players worksheet automatically.

5. Player Leaderboard
You can track your player’s rank in this worksheet. It will be based on :
– Higher points
– Higher correct prediction
– Player’s entry order

If your players are 15 and below, you can use this spreadsheet without any limitation. If you need more, and you want to customize its layout as well, you can purchase the unlocked version that can accommodate until 100 players.

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

  Euro 2016 Sweepstake Spreadsheet V2.76 (3.4 MiB, 18,675 hits)

Related Templates

Previous post:

Next post: