World Cup Soccer Prediction Instructions

If you have come to this page, you already have the files to run your Qatar 2022 World Cup Sweepstakes / Office Pool (if not see more here).

Knock Out Phase Points

Note that the points for the Knock Out phase of the Qatar 2022 World Cup will only update once all the group matches are finished.

Mac’s and the Knockout stage

If you are using an Apple Mac and have needed to disable the automatic updates (see below), then for the knockout phase you will need to continue to update the ‘KnockOutWeb’ sheet manually. The team names with rank are quite important to the spreadsheet so we recommend you look at how we do it on the webpage (Knock Out part of Qatar 2022 World Cup). Note that points for the knockout phase will only update once all group matches are finished.

Updates as at 21 Nov 2022

Note- due to the change in order of matches (Qatar playing before Netherlands) the Overall Points Chart won’t be showing until the Netherlands match is entered. You can test it by manually entering a score for that match.

Remove unused player scores

If you have not used all the player sheets, especially if there are lots of 0-0 draws in the matches, player sheets that are unused may appear in the rankings. To stop this (once you are sure that you won’t need any more players sheets as this has no undo), you can go to the Overall Pnts sheets and delete the contents ONLY of unused cells in column N ONLY as shown below

Disable Auto Updates for Macs

If you are using a Mac the automatic updates may not be working (some users are saying that Mac OS Monterey is working but we cannot confirm this). If you have already filled the players in, you can switch off the automatic update of scores (you will need to do it manually from now on) by performing the following steps (save as a new version and keep the original just in case).

Go to the sheet ‘ActualsResultsWeb’, right click on Qatar, and choose the ‘Data Range Properties’ as shown below

Untick the ‘Save Query definition’ option

You will need to do the same thing with the KnockOutWeb sheet.

World Cup Sweepstakes- Who this is for

This page is for the players in a sweepstakes to be able to update there team rankings to affect the chances of any team progressing in the World Cup when using the auto predict feature of the sweepstakes spreadsheet.

To see how to capture your predictions for the World Cup Sweepstakes watch the Video Clip lower down the page.

Updated World Cup Team Ranking and Suggested Adjustments

Below the list of teams and their ranking points that you will see in your player spreadsheet. We have shown the adjustments we would recommend you make to have a better chance of your spreadsheet correctly predicting the outcomes of the 2022 World Cup as we don’t think the official rankings reflect the actual chances of the teams (form, player retirements etc)

Ranking with suggested adjustments and Adj 1- type them into your spreadsheet and then run the auto predict feature (see more below).

TEAMOriginal PntsAdj 1Adj 2Adj 3New Points
Brazil1 8330001 833
Belgium1 827(168)001 659
France1 79037001 827
Argentina1 765(3)001 762
England1 76228001 790
Spain1 70956001 765
Portugal1 675(16)001 659
Mexico1 659(71)001 588
Netherlands1 65916001 675
Denmark1 6540001 654
Germany1 65159001 709
Uruguay1 63615001 651
Switzerland1 635(2)001 634
USA1 634(50)001 584
Croatia1 62115001 636
Wales1 588(41)001 548
Senegal1 58451001 635
Iran1 564(120)001 445
Australia1 562(63)001 500
Japan1 553(2)001 552
Morocco1 5522001 553
Serbia1 54874001 621
Poland1 54420001 564
South Korea1 520(16)001 503
Costa Rica1 503(116)001 387
Tunisia1 500(47)001 453
Cameroon1 48064001 544
Canada1 4790001 479
Ecuador1 453110001 562
Saudi Arabia1 445(3)001 441
Qatar1 44139001 480
Ghana1 387132001 520

YouTube How to make your Qatar 2022 predictions

Sweepstakes instructions for the player (text and screenshots)

When the players receive their spreadsheets they need to make their predictions. On the ‘Player’ sheet (shown below)

Qatar 2022 World Cup Sweepstakes / Office Pool

They must:

  • (1) Enter their name in cell A1 (if the group has similarly named people use a unique name)
  • (2) & (3) Enter their predictions of the scores in the blue cells (column G and I)
  • (4) As they enter their scores the group standings in column O will be updated so that they can see who is going to progress to the next round (top 2 of each group).
  • (5) New feature allowing players to let Excel, using the teams rankings, predict the match outcomes. More of this later.
  • Note: per the competition rules, teams on the same number of points will be separated by (in order) comparing their net goals,  goals scored, then head to head results (unlike the recent Euro’s) . The spreadsheet will take this into account.
  • Note: Because of the complex rules to decide who progresses, we suggest players look at the resultant knockout matches and make sure they are happy with the teams progressing. If it is not what they want, they should change some of the scores.
  • Once they have completed predicting the group stages, the knockout bracket stage of the tournament will auto populate and they must predict the scores in these matches.
  • Note: at the knockout bracket stage of the tournament they only get points for who progresses. Predict a winner in each match (even just a 1-0) instead of a draw and penalties.
Qatar 2022 World Cup Sweepstakes / Office Pool
  • The player must complete the knockout bracket stage of the tournament until they get to a winner.
  • They must then save the file and send it back to the organizer.

Auto Predict Qatar 2022 World Cup Results

A new feature this year, for players you don’t want to have to fill in all the match results, is an auto predict button.

Key to using this is to enable the macros when the player opens the spreadsheet. As shown below it will look something like the below (1). If you want to use the buttons (2), the macros will need to be enabled.

Qatar 2022 World Cup Sweepstakes / Office Pool

The buttons available are:

  • Random Full prediction- auto fills results in the group AND knockout phases and predicts a winner
  • Random Predict Group Stages only- auto fills the group stages only. The player will then need to fill in the scores for the knockout phase all the way up to the winner.

The player can push the buttons as often as they want and each push will generate a random set of results, but based on the teams rankings.

Changing the chances of a team win with Auto Predict

As per the below image, on the ‘Rankings’ sheet in the Players spreadsheet we have included the teams and their points per the official rankings. This is what is used to forecast match results.

The bigger the difference in points between 2 teams (1 below), the more likely that the better side will win (but there is always a chance of a reverse result).

We have allowed you to change these odds by adding/ subtracting points for whatever reason (2).

For example, in red text (3) we have highlighted the teams that have previously won a World Cup, as these teams always seem to be in the mix. You may want to add some points for them.

Teams that seem to always come up short, like Belgium or Netherlands, you may want to deduct some points.

If you have a favorite team and want them to win it, add 1000 points to them and they will almost always win.

You can then go back to the ‘Player’ sheet and now when you use one of the Auto Predict buttons, it will use your new rankings.

We will update some views on what the rankings should be on a regular basis which you can copy to your spreadsheet, on 2022 World Cup Sweepstakes Predictions page.

Qatar 2022 World Cup Sweepstakes / Office Pool

2022 World Cup Sweepstakes Spreadsheet- run your own office pool for Qatar 2022