FIFA World Cup 2018 Sweepstake

World Cup 2018 Sweepstake - ExcelFIFA World Cup 2018 Sweepstake is an excel template to compete with your friends on predicting score results in this year World Cup in Russia. It should be convenient to play prediction games with your friends or relatives during World Cup 2018. Playing this game should reveal who is the sharp predictor among your friend neighborhood.

This template is the most famous prediction spreadsheet since Euro 2008. It evolved to a more complete prediction game that can accommodate many game setting variation. In the beginning, people uses it for score prediction only where they have to follow any matches, predict the score and track their standings. The latest one, released for this World Cup, give people more choices of their game type. They can set it as one prediction game where people predicts once and see their standings after every matches. What is the meaning of predicting once? It means, people predict score for all group matches, see their own group standings, and then continue to fill the scores for their own knock out teams. Also, there are point bonuses that they can get for particular cases, like number of qualified teams, correct champion prediction etc.

You can download FIFA World Cup 2018 Sweepstake at the bottom. These are all the worksheets that you will work with.

1. Game Setup

Comparing with previous World Cup 2014 sweepstake spreadsheet, there many features have been added. Important feature is you can set this spreadsheet to get scores once. It should fit people who doesn’t have much time to spare their time to organize it regularly during World Cup 2018 event. You can set it in Knock Out round part by selecting “Player Prediction Matches” in Knock Out Countries Bracket Pairing row.

You can adjust points for those score prediction parts either in group stage or knock out stage. There are three level of points where you can play around with those points to simulate your level of point rewards. You can set it to have two level of points or even one level only.

There are bonus points table. You can apply this bonus points by typing your own points or ignoring it by typing zero. There are 15 bonus points criteria you can use in your sweepstake game.

2. Player Scoreboard

You must type your player names in this worksheet. Do not type similar names or the formulas will give you error message. You can differentiate it by adding number or typing it in different way.

There is a big table that will show prediction summary from all players for all 64 matches where you can switch its view to score prediction view and points view.

3. Team Setup

This is a worksheet where you can translate team names. Just replace the name in Country Name table with your own translation. But, only country names that can be changed here. If you want to change titles and other terms, you can type it directly in respective table headers.

There is a Fair Play points table you can use to put fair play points if you standings have to go through that tie breaker.

4. Best Player and Top Scorer

As part of new features, you can predict best player and top scorer and get points for correct prediction. You can write best player and top scorer after you receiving prediction from your players. This table will act as a dropdown table reference to avoid any miscalculation because incorrect player names for similar player. It should add more fun to your pool game. Since it is not just predicting scores.

5. All Players Board

This is the area where you can write all of your players score prediction as well as its actual tournament result. No separate tournament worksheet as before. You can see all player match and bonus points in this worksheet. You can see qualified teams for each players as well as other parts that should give them bonus like best player and top scorer.

6. Player Leaderboard

Use player leaderboard worksheet to track and monitor your players. You can see their progress here. They will be ranked by :
1. Points earned on all matches (Group and Knock Out Rounds) + Bonus Points
2. Number of Correct Score Prediction Matches (Group and Knock Out Rounds)
3. Points earned on all matches (Group and Knock Out Rounds) only
4. Player’s Entry Order in Player Scoreboard

This free spreadsheet below can accommodate until 15 players with limited features. All worksheets are protected. You can purchase the paid version to accommodate up until 100 players and use all available features.

In this year Tournament, Japan and Senegal fate has to be decided by Fair Play points. To accommodate it, go to Team Setup worksheet and type 4 for Japan and 6 for Senegal (without minus sign) in their respective rows.

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

Full Tournament Sweepstake

  World Cup 2018 Sweepstake (1.3 MiB, 5,221 hits)

Knock Out Rounds Only Sweepstake

  World Cup 2018 Sweepstake - KO Rounds Only (354.4 KiB, 382 hits)

Previous post:

Next post: