Blog

2023 Rugby World Cup Sweepstake is an Excel spreadsheet to play office pool game for this year tournament. It should be fun to play this game with your friends, and with leaderboard system applied in this spreadsheet you and your friends will see who is the most sharp predictor. It is a long tournament. It will start from 8th September and end in 28th October. It takes place in France.

If you ever use previous office pool for year 2015 and 2019, then you won’t have any difficulties on using this one. It is similar. Free version can accommodate up to 15 persons. It should be enough. If you need more persons, you can purchase the paid version.

How to Use 2023 Rugby World Cup Sweepstake

Group Stage

• Set your pool point system
• Set earning points for predicted match results in pool round stage. There are 4 available stages that you can reduce into 1 stage by set unused stages to 0 or same values.

Player Points

1. Point for correct match (win-draw-loss) and correct score result (maximum point)
2. Point for correct match result (win-loss) with correct score difference prediction or correct draw prediction only – You can set it as the second stage point. You can make second stage point with the other 3rd and 4th stage point to have 2 level point stage. You can omit this stage as well as other remaining stages to only have one stage point system
3. Point for correct match result (win-loss) prediction only and score difference margin is within certain value. You can set certain margin for match score differences to give your player additional points or you can make it similar or omit this by typing 0 (zero) value.
4. Point for correct match result (win-loss) prediction only. You can set this 4th stage point or make it similar with 2nd and 3rd stage points or just type 0 to abandon this stage

Bonus Points

There is an optional bonus point system you can implement by set correct Tries prediction value or you can set it to 0 to abandon this bonus point system. If you set it to 0 (zero), your players are not required to fill Tries score prediction in All Players Prediction worksheet.

Knock Out Stage

Define your point system and set player point for predicted match results in Knock Out round matches.

Point System

1. Set your Pool Prediction method by selecting Team in Knock Out round matches

• If you set “Based on Player’s Prediction Results”, all teams in knock out brackets will follow your pool standing prediction results. This selection is suitable for you who want to run “Set and Forget” type tournament where all players just give you one time prediction from the first until final match at once.
• If you set “Based on Tournament’s Actual Results”, all teams in knock out brackets will follow real pool standing results. This selection is suitable for you who want to follow tournament matches one by one and predict the score based on team who played in knock out round. This selection will give your players the same start again in knock out rounds.

2. Set matches period included in Earning Point Calculation

• If you set “Normal Time”, only normal time score result included in point calculation. If your player predicted the match result is draw, additional winner box will be shown and you must type the winner based on real result to place the winner on the next bracket.
• If you set “Full Time”, all score results will be included in point calculation

Player Points

How to set points in this stage is similar with setting points in Group stage.

Bonus Points

There are several bonus points can be awarded to your players based on scheme below :

1. Group Winner and Runner Up correct prediction
2. Group Winner correct prediction only
3. Group Runner Up correct prediction only
4. Qualified 2 teams (swapped group position)
5. Qualified 1 team only (incorrect group position)
6. Correct Knock Out Bracket Pairing Matches

You can apply different bonus point based on your own specific rule by typing directly in player bonus point boxes, but you have to clear all formula inside bonus point boxes so it won’t add points by accident. But remember that you have to review match result and compare it with your player prediction and then put those bonus point manually in every player boxes. All points in those boxes will be included automatically in player scoreboard.

After you finished setting up your pool, you can start typing your player score prediction in prediction boxes. You must type actual result in Tournament worksheet

If you are new to this 2019 Rugby World Cup Office Pool spreadsheet, you can download and play around with it. If you just want to have the schedule for this tournament with scoresheet included you can use the 2023 Rugby World Cup Schedule version.

  Rugby World Cup 2023 Pool V4 - 15 Players - Free (1.3 MiB, 1,476 hits)