This is a Euro 2012 sweepstake/pool template in excel. By using this spreadsheet, you can do a prediction game with your office colleagues, your relatives, your friends etc. It needs Microsoft Excel 2007/2010 to run it, and there is no macro which will ease you to use it. You can read the following short description below before using it.
It is consists of 5 big parts, those are Setup, Player Leaderboard, Player Scoreboard, Match Schedules and Individual Player worksheets.
You have to put your player name here, and once you entering your player’s name, this sweepstake spreadsheet is ready to use. There are score reference table that you can modify if you have other score preference. I define three rules for getting points in this pool game. In this rule, every player will get points if
– they predict correctly match and score result
– they predict correctly match and goal difference result
– they predict correctly match winner result only
There are default points inside the table that you can replace with your own points. In this system, there are different points value for knockout stages, where the point are doubled or tripled than group stages. With this point system, every player still have a chance to win the game eventhough they join in the middle of the game or they always predict incorrectly in group stages. You can start the game after this step.
There are several options to make it played easily.
First, you can print individual player worksheets and your friends or colleagues can write down their prediction in their sheets. You can appoint yourself or someone to collect all the prediction information and put it in the player worksheets. Or, you can just print a blank individual player worksheet, make 25 copies, and spread it to your friends.
Second, You can share this spreadsheet using the sharing menu in your microsoft excel program. But, it will only work if your computers are connected each other. You can go to find more detail about this from Microsoft Excel help menu.
There is a filename cell where you should rename if you change the excel filename to prevent any broken links.
This is a worksheet where you can see all player predicted scores and points, sorted by player number. You can switch between point view and predicted score view by clicking related tab on top of this worksheet. You can go to individual player part by clicking the “update score” link or Individual Player Scoreboard tab.
Individual Player Scoreboard
There are two big boxes in it. The left box is a prediction box where all players can put their score prediction. The right box is the real result box where the result will be appeared once you fill the result in Match Schedule worksheet. You can also see the point you or any players earned and also current rank on the top side of the right box. You can move between players by clicking the player # button on top of this worksheet.
You can see the rank of all players when the real match results are entered.
You should update the score in this worksheet everytime the matches are finished. Related points for every players will be calculated and you can see the new rank based on the points earned.
You can download the 25 players version below. You can visit the author site if you need a template that can accommodate more than 25 players.
UEFA EURO 2012 Pool V1.71 - 25 Players (610.2 KiB, 1,799 hits)