2014 World Cup Round Robin Pool Tool

Every two years when the Euro Championships or World Cup roll around my company, like many, sets up an office pool to facilitate some friendly competition between colleagues. This year I was entrusted with setting up the whole thing.

I started by looking online for an easy-to-use Excel tool that didn't require participants to predict the score of each game but couldn't find one that was relatively simplistic. So I decided to build one and share it.

Overview: Participants predict the outcome of each of the 48 World Cup Group Stage games in their own Excel-workbook. The World Cup Pool Aggregation tool then automatically and quickly aggregates the entries and provides an automatically generated leaderboard that can be refreshed at any time when new results are entered.

Location: http://tinyurl.com/oxphy5a

Max Entries: 90 (if you intend to use the tool for more participants, let me know)

How to use the 2014 World Cup Pool Tool:

1. Send a copy of the World Cup Predictions Template workbook to all pool participants. Have them complete their picks for all 48 round robin games (note: copy and distribute the Predictions Template; it doesn't matter what the workbooks are named)
2. Create a folder (i.e. on your desktop) to store all of the files. Make note of the folder's URL
3. Within the World Cup Pool Aggregation workbook, open and edit the 'Refresh_Standings' macro (this can be done through the Developer tab in Excel)
4. Change the FilePath$ and ChDrive values to reflect the location of the folder where you intend to store all of the entries (the macro will run on network drives provided the appropriate permissions are in place)
5. Place all Predictions workbooks and the Aggregation workbook into the same folder specified in the FilePath$ link (do not place any other types of files in this folder)
6. On the Results sheet of the World Cup Pool Aggregation workbook, enter the results of the World Cup games as they happen
7. On the Leaderboard sheet of the World Cup Pool Aggregation workbook, click the refresh button on the top-right of the chart to refresh your pool's standings.

You'll notice that as you input the results of the actual games that the leaderboard will change.

If you have any questions, comments or feedback, please leave a message below.

Thanks and enjoy!