2015 World Cup Rugby Office Pools Spreadsheet

2015 World Cup Rugby Office Pools Spreadsheet

We have just released the Rugby Office Pools Spreadsheet for the upcoming World Cup. Much like the one we created for the 2014 Soccer World Cup, it allows you to organize a sweepstakes in your office covering the group and knock out stages.

NEW- Coming soon, 2018 World Cup Spreadsheet

Overview on how to use it

  • Download it from the store
  • Send the input sheet to all the people who want to play
    • Ask them to complete it
    • Send it back to you
  • Copy and Paste the predictions into the master file
  • DONE
  • Now every time you open the file during the tournament it will automatically update the latest match scores and results and update the sweepstake scores

You can watch a brief video clip of how it works below

Key feature of the spreadsheet  is that once it is set up it will automatically pull the scores from the web and update itself. No unnecessary capturing by the organizer.

In terms of the method of scoring points the following is the default but you can change points allocated

Rugby World Cup Group Stages Sweepstakes scoring

    • Getting the right result irrelevant of the score (i.e. win, loss, draw)- 3 points
    • Getting team 1’s correct number of tries (e.g. you predicted 1-1 and the try count was 1-0)- 1 point
    • Getting team 2’s correct number of tries (e.g. you predicted 3-2 and the try count was 2-2)- 1 point
    • Correctly predicting a bonus point( or not) for team A tries (e.g. Team A scores 5 tries and you predicted 4 or more)- 2 points
    • Correctly predicting a bonus point( or not) for team B tries (e.g. Team B scores 2 tries and you predicted 4 or less)- 2 points
    • Predicting that the score was within 7 points and the correct losing team will get a bonus point- 2 points

Rugby World Cup Knock-out Stages Sweepstakes scoring

    • Each correct team in the Quarter Finals- 4 points
    • Each correct team in the Semi Finals- 5 points
    • Each Correct Team in the Finals- 6 points
    • Correct winner of the 3rd/ 4th playoff- 10 points
    • Correct Winner- 15 points

Enjoy.

Also be aware that we can offer on site Excel based training in any of the playing nations. Send an email to Adrian@AuditExcel.co.za if you want more information