Excel Templates | Excel Spreadsheets | Euro 2012 Pool



Euro 2012 Pool

Posted on May 29, 2012
Filed Under Sports | 44 Comments


Finally, I finished the Euro 2012 Office Pool Template. Comparing with my previous World Cup 2012 Office Pool, I modify this spreadsheet lay out. That’s the reason why it took so long to finish it, instead of just changing the words. The rule is remain the same, except it is applied only to 31 matches without 16 round matches.

Euro 2012 Pool Euro 2012 Pool

For you who are new to this template, please find below the short guidance of using this template. This spreadsheet is consists of 5 big parts. Those are Setup, Player Leaderboard, Player Scoreboard, Match Schedules and Individual Player Part. Each parts are formed with one or more worksheets which probably cannot be seen directly. There is no excel macros used in this spreadsheet.

Setup
This is the first part that you need to complete before starting this pool game. And like my previous template, it can accommodate until 25 players. By default, once you entering your player’s name, this excel pool 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 result only

You can see my default points in the table and you can change it. I also define different points value for group and knock out stages, where the point in knock out stages are doubled or tripled than group stages. This type of points will make 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. Put this spreadsheet in one computer or a server which strong enough to be accessed by 25 players at the same time.

I quoted how to share a workbook from microsoft excel 2010 help menu:
“On the Ribbon, click Review, Share Workbook, and then in the Share Workbook dialog box, on the Editing tab, select the Allow changes by more than one user at the same time. This also allows workbook merging check box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.”
You can go to find more detail about this from you Microsoft Excel help menu.

And there is a filename cell in this Setup part. If you want to rename the filename, make sure that you also change the filename in this setup part or some internal links will be broken.

Player Scoreboard
This is a player summary part 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, next to the player name or Individual Player Scoreboard tab which will bring you to the player number 1.

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.

Player Leaderboard
This is a main part where you can see the rank of all players when the match results are revealed.

Honestly, I still want to do several things with this spreadsheet, but I don’t think I have much time to do it before the tournament is begun.

Ok guys. Just download and give it a try to get used to it. I’ve test it and found no errors, but let me know if you found one, so I can fix it before the tournament is started. You can download the file here.

zip Euro 2012 Pool  Euro 2012 Pool Template - 25 Players (610.2 KiB, 6,101 hits)

If you want to learn all the formula to build this pool including euro 2012 schedule formula, or just want to thank me, or you want to add new formulas and personalize with your own rules, you can paypal me 11.99 bucks, and I will send you the unlocked one that can accommodate until 100 PLAYERS.

Get Unlocked Euro 2012 Pool for 100 Players
 Euro 2012 Pool



Comments

44 Responses to “Euro 2012 Pool”

  1. Torben Andersen on May 29th, 2012 6:39 pm

    Hi

    Is it possible to get these feature added to the uefa 2012 pool:
    Top Goal Scorer = 5000 points (or something)
    Also points for the corrects placement in the tournement.
    1st – 3000 points
    2nd – 2000 points
    3rd – 1000 points

    Maybe also an option if you choose a draw result – you will only get 80 points. Because it should be more exciting to go for the winner bet!.

    Hope to hear from you very soon.

    Br
    Torben

  2. Musadya on May 30th, 2012 2:04 pm

    Hi Torben,

    Technically, it is possible. The problem is, to find my spare time to implement it into existing spreadsheet :) . Perhaps, in the next World Cup 2014 or Euro 2016 tournament I can make a more rich-feature pool template. But, I will update you if I can catch the time to add more pool features before the tournament is begun.

    Thank you and best regards – Musadya

  3. daniel Lugo on May 30th, 2012 4:35 pm

    Hi.
    the file i downloaded is password protected…

  4. Dave on May 30th, 2012 6:48 pm

    Thanks for the spreadsheet. I run a small pool at work and will be using it!
    Question: concerning the knockout round, if someone thinks that the game will end in normal time, in the spreadsheet do I repeat that score in the extra time and shoot out rows? Or leave the extra time and shoot out rows blank?
    Thanks.

  5. daniel Lugo on May 30th, 2012 8:37 pm

    how does it works for knockout stages???

  6. Musadya on May 30th, 2012 10:43 pm

    @Daniel n @Dave: Tks for using my pool template. For the knockout stages, players predict the final score where the final score will be a total of goals, scored in normal time, extra time and penalty shoot out. In matches schedule worksheet, you need to fill the goals scored in normal time only, if the match ended in normal time. You don’t have to fill the extra time and penalty shoot out score boxes, because the formula won’t add those goals. The formula will add automatically the extra time and penalty shoot out goals if the matches are ended in draw in normal time. You can play around with those score boxes to get used to it.

  7. larry on May 31st, 2012 12:29 am

    under matches schedule what time zone is the “Time” column?

    The version I just downloaded is password protected also???

    Thanks for sharing this file is great!

  8. Musadya on May 31st, 2012 2:14 am

    @larry: Tks. You can select the timezone based on your preference. And sorry, I forgot to mention in my post that the matches schedule is the same with Euro 2012 schedule and scoresheet. So, you can follow the same step as written in that post. This Euro 2012 Pool for 25 players is a free version, so it is password protected.

  9. Idoia on May 31st, 2012 1:15 pm

    Hi!
    Your pool looks brilliant but it is more than 25 people at work to do it… Any chance to get add more players?
    The only disadvantage with your file is that to collect everyone results you cannot do that via tab set up, it would be easier to copy paste their results into different player 1, 2, 3… tabs.. Thanks.

  10. Juan on June 2nd, 2012 7:26 pm

    Hi
    Score predictions for the knock out stages are intended to be done also at the beginning? before knowing which teams are playing those games?
    Thanks. Great job.

  11. Rohan on June 4th, 2012 1:20 pm

    Really appreciate this, and have found nothing comparable elsewhere on the web, I would imagine you can expect a lot of hits over the coming days!
    Thank you very much for your generous efforts.

  12. Musadya on June 5th, 2012 12:23 am

    @ Idoia: Tks.
    @ Juan: Tks. When all group matches are finished, the team name in knock out stages will be shown up automatically.
    @ Rohan: Tks.

  13. Rakesh on June 5th, 2012 7:41 am

    Hi,

    can you add these rules in the templete for 100 players. Once done we will pay you and you can mail us the template

    The rules are simple and are as under:

    Stage 1 predictions

    ->Predict the winners of the initial Round Robin League with goal scored by either team
    ->Predicting the WINNER of each match in round Robin League will earn you 2 points
    ->Predicting the DRAW in each match – 4 points
    ->Predicting exact result i.e. goal scored correctly by both teams will earn bonus 1 point

    Stage 2 predictions

    ->Predict the winners of the Quarter Final, Semi Final and Final with goal scored by either team
    ->A one-time change to predictions will be allowed after the Round Robin league for participants to carry forward their Round Robin point to QF, SF and Final match prediction

    ->Prediction done for QF, SF and Finals cannot be changed till the final results are out
    ->For predicting the correct winners in quarter finals – 6 points.
    ->For predicting the correct winners in Semi finals – 8 points.
    ->For predicting the correct winner of Final – 10 points.
    ->Predicting exact result i.e. goal scored correctly by both teams will earn bonus 2 points

  14. Nam Xoi on June 5th, 2012 8:39 am

    Dear Musadya,

    According to your 3 rules, there is a case that hardly to judge. When a match has draw score, if we predict the score is draw and only correct the difference result, certainly we get 70 pts. No way to receive 50 pts. So, your statement: “Point for correct match winner/draw result only” is not exact in that case. How do you solve?

  15. Musadya on June 5th, 2012 3:36 pm

    @Rakesh: Thank you for your interest on using my service to modify the pool template. But, I don’t think I have enough time to modify it before the tournament is started due to my time limitation. I will note it for the next World Cup 2014.

  16. Musadya on June 5th, 2012 3:43 pm

    @Nam Xoi: Thanks for your feedback. That is a very good observation. Basically, the pool system is working that way. If the match is draw and the player has predicted it correctly, they will get at least 75 points in Group stages, because the goal difference always the same. I will correct the statement and add some notes in the next version.

  17. steve on June 6th, 2012 2:28 am

    what is the pass word

  18. Ali on June 6th, 2012 7:23 am

    Hi, I’ve been trying to download your hundred player version and Paypal tells me there is a problem with the sellers details and to contact you, how can I download your 100 player version?

  19. Musadya on June 6th, 2012 8:06 am

    @Ali: I have checked the paypal link, and everything looked normal. Probably there was a broken connection at that time. You can try it again. You can send a private email to info@exceltemplate.net if you still found any problem. Thanks.

  20. Olly on June 6th, 2012 1:45 pm

    Hi – may thanks for the ace spreadsheet. One query: when I add my predictions to the Individual Player Scoreboard, the group winners and quarter final matches etc. don’t update with team names (as they do on the Match Schdule tab) – they stay as ‘Group A Winner’ etc. How can I tell which teams will be in the knockout matches based on my predicted group stage results?

    Thanks

  21. Musadya on June 7th, 2012 12:17 am

    @Olly:Tks. I created this pool with a thought that the score will be predicted when the parties who involved in the matches are clear. When you predict all the group matches result, and your prediction results are different with the real results, you have to reset your prediction for knock out stages. In my opinion, there is no intention for people to predict the knock out stages results before it is clear who are the group winners and runner ups, except they have different thought of pool system. And from excel point of view, adding one automatic standing table to one individual player scoreboard will take many excel resources which could slow down the updating process.

    But, if you want to see group winners and runner ups based on your prediction, I suggest you to use a separate euro 2012 schedule spreadsheet to put your prediction. And you can make and save it to several copies to see the outcome of different prediction.

    Best Regards

  22. Ru on June 7th, 2012 2:00 am

    Hey Mate,

    Great template, thanks so much for it. Just a quick question, and I hope that this is not to much work. Is it possible to replace “Point for correct match winner/draw and correct score difference result” with “Point for correct math winner/draw and winners goals scored”?

    Best

  23. Pierre on June 7th, 2012 12:56 pm

    A brilliant Euro 2012 sweepstake in excel. Good job!

  24. NANDO on June 7th, 2012 5:53 pm

    can you send me the password to unlock the excel sheet in other to complete the scores after tomorrow….
    thanks…
    nando

  25. Faz on June 7th, 2012 6:01 pm

    The pool looks great, but I can not add players onto the spreadsheet without a password.

  26. Faz on June 7th, 2012 6:21 pm

    Please disregard my previous comment, I fugured out my mistake.

    Thanks for all the hard work

  27. Lina on June 9th, 2012 7:07 am

    Hey Musadya,

    Thanks a lot for the model! I’m planning to use it but I have an issue with knockout stages: if we’re not planning to change predictions in second stage ie fill sheet in total the first time then when the teams we chose are not the ones which qualify it still assumes that they are so it assumes everyone got it right…am I correct? Is there a way we can fix that? Or if I buy updated version? How else can I do it? Thanks!

  28. Susan on June 9th, 2012 3:25 pm

    What is the password?

  29. Stephen on June 18th, 2012 4:41 pm

    Hi, Great spreadsheet! looks like there is a problem with game 20/ Once I neter the score (denmark/germany) all the cells in the leader board to to #N/A! Help!

  30. Stephen on June 18th, 2012 8:26 pm

    igore that last comment. it’s working. Somone one had entered some bad data.

  31. Luis on June 19th, 2012 9:53 pm

    Before my question, I just want to say thank you for creating such an amazing pool/template… it’s amazing what you were able to do within Excel.

    Now, my question/scenario is the following: For the Quarter Finals, Am I suppost to guess the TOTAL of goals and winner (including extra time, and penalties, if applicable). For example: Spain vs France, let say they ended up 1-1 at normal time and they score 1 goal during over time, so the score is 2-2, right! And let’s say the penalty shots ended up 4-3. So, in order for someone to get a perfect prediction, they have to tell me that the score will be 6-5?

    Let me know as soon as you can, I would really appreciated! I have people asking me same question and I’m not sure what to tell them.

    Thank you in advance!

  32. Chris on June 20th, 2012 9:13 am

    Hi ya great spreadsheet. Thank you.

    I have a similar problem as Luis. I have got people to predict the scores after 90 mins. So if they predict 1-1 after 90 mins and this is the correct result they should get maximum points but once I’ve entered the extra time and penalties result the player that got the 90 min result correct scores 0 points. I could not fill in the extra time and penalty scores but the semi final matches will not update. Is there a way around this. Many thanks in advance.

  33. Musadya on June 20th, 2012 12:29 pm

    @Luis, @Chris : Sorry for my incomplete guidance. In knock out stages, every players should predict the outcome of the matches including penalty kick goals. There will be no draw prediction. In matches schedule worksheet, you should fill the normal time, extra time and penalty kick which will be shown automatically when there is a goal difference between two teams. This total scores will be compared with player prediction scores to reveal players points. So, Luis sample is correct, they have to fill 6-5 in prediction score boxes. Cheers..

  34. Luis on June 20th, 2012 3:26 pm

    Nice! Everything makes sense now! Thank you for clarifying this and again… good job! You did an AMAZING job. This pool tournament is fun! Keeps people entertain in a good way :)

  35. Adil on June 24th, 2012 10:07 pm

    Hi! Also from my side – Many many thanks for the spreadsheet.

    I do have an issue with the Germany – Greece match (26). I get N/A all over the ‘player leaderboard’

    Can you please advice on this issue?

    Thanks,

    Adil

  36. Dave on June 25th, 2012 10:31 am

    Thanks for the spreadsheet – good work! :)
    My only concern is the knock out stages – its not quite right.
    I think its a little unfair to total all the goals up including the penalties, in my opinion. I personally think points should be awarded for the correct 90 min prediction, and then points being awarded for predicting correctly the overall winner, should the game go into extra-time or penalties.
    The England and Germany games are perfect examples of the system not quite working.
    Had someone predicted the Germany-Greece game to finish goalless at full time and extra time and for Germany to win on penalties 4-2, because of the way the spreadsheet is set up, they would have been awarded full points, which is not how the game finished. Again, with the England game, had someone predicted the game to finish goalless with England winning on penalties, they would have scored no points, where technically they got the full-time score spot on.
    Maybe this could be looked at for the next tournament?

  37. Musadya on June 25th, 2012 2:27 pm

    @Adil: Check your player name. Those errors could come up because you have two players or more with same name. If it isn’t the case, email your file, so I can analyze it further.

  38. Musadya on June 25th, 2012 2:33 pm

    @Dave: Thank you for your feedback. I will consider it for the next tournament. I will put several policies to be chosen, so people can choose the most suitable one for their pool.

  39. Adil on June 26th, 2012 8:39 pm

    Hi Musadya, I have still have this issue.. What is your e-mail address to send the file to?

    Regards, Adil

  40. Andy on June 29th, 2012 5:53 pm

    Thanks for a great spreadsheet. Easy way to do knockout stage results was just 0-0, 0-0 and then the final score. My players were just asked to predict final score rather than break it down.
    Once again thanks

  41. Adil on July 1st, 2012 12:48 pm

    Musadya,

    I have tried to fill in the spreadsheet again and I am sure there is a error in the Germany – Greece game.

    Could you please advise as the final is today??

    Adil

  42. Steve on July 1st, 2012 11:41 pm

    Adil, There is nothing wrong with Musadya’s spreadsheet. Check again your player score input. You might mixed with text format up.

  43. Luis on July 2nd, 2012 4:01 pm

    Musadya,

    Once again… thank you! You did an amazing job! And now that the tournament is over, and got to be the go-to as far as pool tournament I created with some friends. I got understand it more! Everything worked great! The only thing I can advise, maybe reword the rules a bit different… in a way that is easier to understand… maybe add some scenarios/examples to better understand. Because before the tournament started, I was completely lost. Other then that, this pool works great! Are you going to make another one for the next Champions League? and for the La Liga season? I notice you made one for La Liga season, but it’s a pool/template… it was more to check the ranks and stuff.

    Let me know, and keep up the GREAT work!!!

  44. Stewart on September 15th, 2012 12:31 am

    Hi Mate

    Any chance of a predictions sheets for the UEFA Champions League ?

    Thanks

Leave a Reply