Excel Templates | Excel Spreadsheets | Men’s Olympic Football Tournament 2012 Schedule



Men’s Olympic Football Tournament 2012 Schedule

Posted on July 14, 2012
Filed Under Soccer, Sports | 13 Comments


While I was preparing the new excel template for European League Fixtures, there were some requests of providing the Men’s Olympic¬† Football Tournament 2012 Schedule which held in London, England. So, I learned the schedule and the tie-breaker regulation for that tournament, and the tournament has the same number of teams (16), almost the same group tie-breaker regulation, and has one match more, compare with Euro 2012 tournament. That one match is a match to fight for bronze medal, or third position of the tournament.

Olympic Football Tournament 2012 Schedule Men with Flag V3.21 786x1024 Mens Olympic Football Tournament 2012 Schedule

Based on those facts, I decided to create Men’s Olympic Football 2012 Match Schedule and Scoresheet based on my Euro 2012 template. There are not much works I put on this spreadsheet. I have just changed the country names, the flag images, and adjusted some translations. I have added new boxes for group drawing lots, third position match and Olympic medal result. There is only one box I prepared for drawing lots with assumption that the possibility of getting the group rank decided by this method is rare. But, I will provide more boxes if it is needed, later. And based on some feedback on language translation, I provide custom language translation table where you can fill your own language.

As I mention before, I modified the group tie-breaker formula based on FIFA document on Olympic Football Tournament, chapter VII, article 25, clause 5. This tie-breaker will be used to reveal the first and second position of each group if there are more than one team are sharing the same position. I pasted the regulation below :

The ranking of the teams in each group shall be determined as follows:
a) greatest number of points obtained in all group matches;
b) goal difference in all group matches;
c) greatest number of goals scored in all group matches
If two or more teams are equal on the basis of the above three criteria, their ranking shall be determined as follows:
d) greatest number of points obtained in all group matches between the teams concerned;
e) goal difference resulting from all group matches between the teams concerned;
f) greatest number of goals scored in all group matches between the teams concerned;
g) drawing of lots by the FIFA Organising Committee.

You can follow the short guidance below to use this spreadsheet:

If all favorite teams in each group can top their groups and win their first knockout matches, it will be interested to see how Brazil, with Pato, Neymar and Ganso, duel with Great Britain which lead by Ryan Giggs, and how the Euro 2012 champion, Spain, try to cool Mexico off in the semifinals.

You can download the file below. Play with the score and send me feedback if you found any errors so I can fix it before the tournament begun.

zip Mens Olympic Football Tournament 2012 Schedule  Olympic Football Tournament 2012 Schedule - Men - with Flag V3.25 - Excel 97/2003 (490.4 KiB, 2,632 hits)

zip Mens Olympic Football Tournament 2012 Schedule  Olympic Football Tournament 2012 Schedule - Men - with Flag V3.25 - Excel 2007/2010 (449.9 KiB, 2,234 hits)

zip Mens Olympic Football Tournament 2012 Schedule  Olympic Football Tournament 2012 Schedule - Men - without Flag V3.25 - Excel 97/2003 (277.6 KiB, 1,072 hits)

zip Mens Olympic Football Tournament 2012 Schedule  Olympic Football Tournament 2012 Schedule - Men - without Flag V3.25 - Excel 2007/2010 (144.2 KiB, 1,298 hits)

If you want to see all the formula to form this spreadsheet or you just want to thank me, you can paypal me 8 bucks and I will send you two spreadsheets. This Olympic 2012 spreadsheet and Euro 2012 spreadsheet. Both spreadsheets are created with the same approach. So, you can compare and see the modification applied to Olympic 2012 spreadsheet. And I believe that you will respect my creation that you will use for your own purpose and won’t distribute this unlocked template to anybody without my permission or claim it as yours.

Get Unlocked Men’s Olympic and Euro Football Tournament 2012
 Mens Olympic Football Tournament 2012 Schedule



Comments

13 Responses to “Men’s Olympic Football Tournament 2012 Schedule”

  1. Paul Uzzell on July 16th, 2012 1:19 pm

    Hi

    I have been using your brilliant speadsheets for a while.

    I have downloaded the men’s olympic spread sheet, thankyou.

    Is there any chance of the womens one as well, I realise this competition has a lot of differences and could take some time to create. I understand if you do not have the time.

    With many thanks

    Paul Uzzell

  2. Luis on July 20th, 2012 12:21 am

    Hi there Paul,

    You did again man! You did a good job creating another amazing template. Is there any chance of you creating a pool tornament? kinda like what you did for the EURO 2012? Me and my friends had a great time playing against each other, going back and forth of who was in first place and who was last. It was fun! Are you making one for the Olimpics? and for the near future… for the EUFA Champions League?

    Thank you in advance!

    Luis

  3. Faldot on July 27th, 2012 12:56 am

    hi..
    I think there is a mistake on Grup B,
    it should be Mexico, South Korea, Gabon and Switzerland, but u only put 2 nations which are Gabon and Switzerland..

    hopefully u can fix it

    regards

  4. Andy Jacobs on July 27th, 2012 8:20 am

    Hi,
    Thanks for the effort.
    There is an error with Group B.
    If any of the scores are a draw in Group B, the table states #N/A instead of the team name and it doesn’t update.
    Please could you let us know when it is fixed.

  5. steve on July 27th, 2012 8:43 am

    It looked like the error shown up in ‘without flag’ file. The ‘with flag’ file is working perfectly.

  6. Jack on July 27th, 2012 3:09 pm

    I see the error in both versions (with or without flags) of the 2007/2010 file. I see a problem in all Groups if all games within the group are a draw, with different scores (i.e. T1 v T2 0-0, T3 v T4 2-2)

  7. Joe on July 27th, 2012 3:33 pm

    I loved your Euro template so I had to come back to see if you had an olympic one. Thanks so much.

  8. Musadya on July 27th, 2012 10:43 pm

    Dear all,

    Thank you for your correction. I’ve checked and I found that I forgot to put exception codes inside dummy worksheet. It is fixed now. Let me know if you found other problem.

    Best regards

  9. Gheorghe on August 4th, 2012 2:53 pm

    Another brilliant spreadsheet.. What about one for the RLWC2013 :o )

  10. Compo on August 12th, 2012 6:18 pm

    Any sign of this seasons templates for the European leagues any time soon? Ligue 1 has already started

  11. Mak on August 19th, 2012 11:34 am

    Premiership too :)

  12. Prit on September 10th, 2012 3:43 pm

    Hey there… Thanks for all your spreadsheets.. Using them for a couple of years now…Any plans for the World Cup Qualifiers pleaseeeee…

  13. Al on October 15th, 2013 3:36 pm

    Hi, great work, ant chance you can give a hint about how to attach the flags to a comparative novice. office 2013

Leave a Reply