Excel Templates | Excel Spreadsheets | Champions League Fixtures 2009/2010


Free Excel Templates

Champions League Fixtures 2009/2010

Posted on August 29, 2009
Filed Under Soccer | 85 Comments



Share

Finally, the UEFA Champions League 2009/2010 participant teams are completed. And all teams already grouped based on the drawing yesterday. It will be interesting to see how AC Milan will handle their former star, Kaka, who are in opponent side, Real Madrid. And it will be exciting to see how Ibrahimovic and Samuel Eto’o who switch team in this season duel in home and away matches between Barcelona, the reigning champion, and Internazionale.

There are plenty surprising transfer moves in this year, and involving many teams that participating in this Champions League. So, watching this season Champions League matches will be very exciting.

Champions League Fixtures

I made this Champions League fixtures template because of the tie breaking rules that applied in group phase is much more complex than Euro 2008 tie rules (it is a tempting challenge for me actually), where all teams will play against the same teams twice in home and away matches where away goals are important when teams are sharing the same points.

After finishing the group phases, all teams will be drawed again to find its opponent in the first round knock out phase. There is a rule where every group winner and runner up cannot meet in this round and also teams from the same country also cannot meet in this round.

And after all first round matches are completed and eight winners are revealed, all teams will be drawed again to find its opponent in quarter finals. And drawing for semi finals will be also done here. So, in this time each teams will know clearly who are their opponent in the path to become the champion.

I tried to make this worksheet can be used for one season without affected by drawing period. I put  all consideration regarding rules and drawing time in the spreadsheet, so you can adjust this spreadsheet based on matches and drawing time.

The other reason I made this spreadsheet is also to prepare the template for World Cup 2010 that will have the same number of teams and groups.

Ok. Enough for the explanation. Now, let’s go to see how this spreadsheet works.

This spreadsheet consists of three worksheets, Team Setup worksheet, Group Qualification worksheet and Knock Out Phase worksheet, which explanation as follows :

Team Setup
This is just a plain worksheet where there is no formula inside. I put all teams information here, including their home stadium and countries and you can modify based on your language. I don’t put any language and time selection as I put in Euro 2008 because of time limitation, but I will put it in my next Worldcup 2010 template. You can see all teams in eight groups based on the drawing results.

Champions League Teams




You can read and download my other templates below :

Tags: , , , , ,

Comments

85 Responses to “Champions League Fixtures 2009/2010”

  1. ojeg on August 29th, 2009 4:54 pm

    MANY THANKS IT’S REALLY REALLY HELP

  2. mohammed on August 30th, 2009 1:10 am

    thanks sooooo much

  3. fou on August 30th, 2009 4:20 am

    thank you!

  4. antonis on August 30th, 2009 5:21 am

    Thank you. Very good

  5. Mohammad on August 30th, 2009 7:09 am

    Thankssssssssssssss
    you are the champion

  6. Mohammad on August 30th, 2009 11:46 am

    THANK YOU WE WATING FOR Premier League2009-2010
    BECOUSE I LOOKING FOR IT SOOOO MUCH AND I FIND NOTHING

  7. Geo on August 30th, 2009 12:53 pm

    Can we have the Premier League 2009/2010 season template soon please? Cheers.

  8. António on August 30th, 2009 3:48 pm

    Thanks, This is great. Now I still hoping to find premier leage 2009/2010 templete here. Congratulations.

  9. Tony on August 30th, 2009 7:00 pm

    Where is Premier League fixture 2009/2010?

  10. Saleh on August 30th, 2009 11:15 pm

    Greate job mate , we were all waiting for that
    cheeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeers

  11. geegy on August 31st, 2009 6:39 am

    It’s cool!!!

  12. Ashraf on August 31st, 2009 8:35 am

    Great work my friend, but how can i download it ?

  13. brahtoo on August 31st, 2009 8:46 am

    great work

  14. Jim on August 31st, 2009 10:18 am

    Yes, but where is the download button??

  15. Jim on August 31st, 2009 10:25 am

    OK – found it now. Many thanks.

  16. mohammad hafi on August 31st, 2009 11:25 am

    FORZA MiLAN
    thanks

  17. almohlhl1664 on August 31st, 2009 1:05 pm

    Thank you for every thing you do.but how i can download

  18. admin on August 31st, 2009 1:41 pm

    For all of you who are looking for the premiership fixtures, I would like to inform you again that I cannot make that fixtures due to license issue. Thank you for understanding.

    Regards

  19. asli on August 31st, 2009 7:56 pm

    license issue wot the hell license from who just do it and upload it this is open source world baby

  20. giangvh on September 1st, 2009 8:09 am

    Thank but i don’t see link?

  21. austenite on September 1st, 2009 10:58 am

    Thanks bro…

  22. Tony on September 1st, 2009 10:58 am

    Click on Page 3, there are a button HERE . You can download the spreadsheet HERE.

  23. raul godinez on September 1st, 2009 5:39 pm

    esta muy bien la plantilla aunque le faltan escudos de los equipos y mas colorido.

  24. mnalturab on September 1st, 2009 10:35 pm

    Sorry but I can’t find the download button.
    Can any one help me ?

  25. mnalturab on September 1st, 2009 10:38 pm

    Thank you Tony I can see it now

  26. Mohammad on September 2nd, 2009 10:00 am

    THANK YOU WE WATING FOR Premier League2009-2010
    BECOUSE I LOOKING FOR IT SOOOO MUCH AND I don’t FIND ANYTHING

  27. hassan on September 2nd, 2009 11:19 am

    merci bcp

  28. hassan on September 2nd, 2009 11:32 am

    thnx

  29. ulin on September 2nd, 2009 12:25 pm

    WE WATING FOR Premier League2009-2010

  30. Niyaz on September 3rd, 2009 9:52 am

    can the spreadsheet be modified to 6 teams in a group instead of 4 teams

    g8 spreadsheet

  31. Martinjr on September 7th, 2009 7:48 pm

    This looks great and exactly what Ineed but whre can I find the download, pl?

  32. kusay on September 9th, 2009 7:11 pm

    thank you for your work

  33. baghar on September 12th, 2009 12:10 am

    thank you for this job

  34. paplo on September 13th, 2009 1:32 am

    Thankssssssssssssss
    you are the champion

  35. bluesman on September 15th, 2009 4:51 am

    Thanks bro…I wait for Premier League2009-2010.

  36. ahmed on September 16th, 2009 4:42 am

    hello
    where how to download

  37. oliveira on September 17th, 2009 12:37 pm

    nao consigo baixar o programa.
    da erro.

    como devo fazer?

  38. Ibrahim Muhammad Muhabub on September 17th, 2009 6:24 pm

    Hello!
    Am waiting for 2009\2010 champions league final with Real Madrid. the world biggest team

  39. Oke on September 21st, 2009 6:03 pm

    The 2 teams to play in the 2009/2010 chiampions league final are…MANCHESTER UNITED & any other team…ha..ha.

  40. Oke on September 21st, 2009 6:08 pm

    Up MAN UNITED….

  41. KLUNZ on September 23rd, 2009 1:35 pm

    Please, I want to password

    I want to design one to Libyan League

    xklunzx@gmail.com

  42. osama on September 24th, 2009 1:01 pm

    wow it is very good

  43. Hisham on September 24th, 2009 1:54 pm

    Thanks mate, great job

  44. Moe on September 25th, 2009 7:51 am

    Thanx a Lot

  45. M Bashar on September 27th, 2009 8:48 am

    Thanks mate, great job

  46. skalli on October 2nd, 2009 9:44 am

    hello
    Please how to download the spreadsheet

  47. MoSTaR on October 19th, 2009 7:56 am

    Please, I want to password…

  48. ..Juve.. on November 10th, 2009 5:49 am

    Is there an updated one.. So I dont need to fill it from scratch ?

  49. Wasim on December 5th, 2009 2:49 pm

    hey mate… I know it’s only been a day but any World Cup templates yet??

  50. Faisal on December 21st, 2009 3:00 pm

    Waiting for Worldcup 2010 schedule

  51. niros on December 26th, 2009 7:25 pm

    hy mate.you’ve done a great job with these spreadsheets.i’m a huge hockey and tennis fan.btw…your tennis template is wonderful, but i was wondering if is any chance for a hockey spreadsheet in the future. tx for your work..and sorry for my english:D.happy hollydays.

  52. Bevy on January 6th, 2010 11:39 am

    I need champions league fixture

  53. Cecil on February 5th, 2010 1:15 pm

    How can i get the latest fixture for champion league?.
    thanks

  54. Cecil tawa on February 5th, 2010 1:17 pm

    i need champions league fixture and table

  55. moron on February 18th, 2010 11:51 pm

    fixture

  56. godrick on February 19th, 2010 6:38 pm

    winner of chanpions league

  57. Simos on February 22nd, 2010 2:06 pm

    thanx

  58. cristiano ronaldo dos santos averio on March 6th, 2010 3:33 pm

    en el 2008 a mi me nombraron como el mejor jugador del mundo

  59. getachew on March 19th, 2010 11:07 am

    I wish MAN.UNITED wins the Champions leage.

    I think ROONEY is the best player of the year.

    I am sory for Madrids defeat by lyon.unexpected event!!!

  60. Gezahegn on March 19th, 2010 8:49 pm

    I happy with the fixture of the chapmions league. I wish Man Utd to be the champion.

  61. Kev on March 19th, 2010 11:54 pm

    Hello mate, Can you please send me the pass to edit team names..im searching the web for a spreadseet like this..as i have organised a champions league tournament between friends on the playstation..so this spreadsheet will be of real help.

    Cheers!
    Kev

  62. Kev on March 19th, 2010 11:55 pm

    pls email me the pass on justmailme_2005@yahoo.co.in

  63. Kev on March 19th, 2010 11:55 pm

    Man United all the way !! WooHoo

  64. Ali on March 22nd, 2010 3:10 am

    I HOPE MANCHESTER UNITED WILL BE THE OWNER OF CHAMPIONS LEAUGE TROFFY. THIS TROFFY IS ONLY FOR MANCHESTER UNITED SPECIALLY FOR ROOONEY,VANDERSAR,VIDIC,CARRICK,NANI,EVRA,PARK,GIGS,BERBATOV,OSHEA,ANDERSON,FERDINAND,OWEN,RAFAEL,SCHOLS AND SO ON……….ETC

    WE LOVE U SIR ALEX FERGUSON
    WE LOVE U SIR ALEX FERGUSON
    WE LOVE U SIR ALEX FERGUSON

  65. ge0rge on March 22nd, 2010 9:06 pm

    alianza lima tlv ganam0z la libertad0res i esperam0z a los de la chamspions i ganam0z mej0res en t000 i n0 ba acer…. jejeje

    pveblo AL -gr0ne en valencia
    viva el perv desde españa sentimient0 gr0ne

  66. parry on March 24th, 2010 6:33 pm

    i love wayne rooney,i think he is the best for now

  67. Rayis on March 25th, 2010 12:24 pm

    Thank You

  68. yvesdaniel on April 1st, 2010 8:20 pm

    I LOVE MILITO AND ETOO.I THINK THEY ARE THE BEST FOR NOW.I WISH INTER MILAN SHOULD WIN THE CHIAMPIONS LEAGUE FINALS.

  69. Philip on April 14th, 2010 1:38 pm

    efffffffffffffffffffff ffffffffffffffffffffffff gggggggggggggggggggg

  70. Richard on August 26th, 2010 9:14 am

    Excellent work!

    Could you create a spreadsheet for the Europa League too?

  71. Nick Blake on August 26th, 2010 5:50 pm

    hey there is there a spreadsheet for 2010/2011 champions league?? if so how can i download it and whats the password so i can then edit it to re use it year after year and for home ps3 fifa contests with mates.

    ps fantastic work on all the spreadsheets.

  72. tr on September 1st, 2010 1:16 pm

    yes

  73. ato on September 6th, 2010 7:52 am

    Hi guys, can’t find the spreadsheet for 2010/2011 champions league.

    and the Europa league ?????

  74. noeca on September 9th, 2010 1:49 pm

    A spreadsheet for Champions League 2010/11 would be highly appreciated! Anyone know where to find one…?

  75. king on September 15th, 2010 7:50 am

    how do i dowmload the table

  76. king on September 15th, 2010 7:51 am

    Hi guys, can’t find the spreadsheet for 2010/2011 champions league.

  77. Marcel on September 15th, 2010 9:46 am

    Hi guys, can’t find the spreadsheet for 2010/2011 champions league

  78. ato on September 18th, 2010 6:58 am

    hi Tr on 1st sept in response to Nick Blake u indicated there was the spreadsheet for 2010/2011 champions league. thanks to pls, pls revert

  79. Anwar Al-Ballam on September 18th, 2010 12:07 pm

    what about 2010*2011

  80. UEFA Champions League 2010/2011 Schedule | Excel Templates on September 18th, 2010 5:03 pm

    [...] and using this template, you can read the guidance to use this spreadsheet in my previous Champions League 2009/2010 [...]

  81. K.U. Fain on September 19th, 2010 10:04 pm

    Dear Sir

    I have downloaded the worksheet Champions League 2010-2011

    I have used the worksheet for the Europe Leaque 2010-2011 and expanded it with 4 poules.
    Now I have a problem with finding the ‘dummy table’.

    Can You tell me where I can find this?

    With kind regards,

    K.U. Fain

    Middenmeer

    The Netherlands

  82. ato on September 30th, 2010 8:01 pm

    Just as above msg. formula does not work for expanded tables from I – L of the Europa League League cause of cannot locate the “dummy table”.

    Pls revert

  83. ato on October 18th, 2010 3:10 pm

    Adapting the worksheet Champions League 2010-2011
    for the Europe League 2010-2011 and expanding for group I to group K can some guys help with fix for the dummy table to work.

    Thank you.

  84. Michaelsylvanus on December 28th, 2010 6:14 pm

    Ronaldo iz de best player ever

  85. … Templates | Excel Spreadsheets | Champions League Fixtures 2009/2010 « Champions League on October 21st, 2011 10:52 pm

    [...] reading here: … Templates | Excel Spreadsheets | Champions League Fixtures 2009/2010 Related Posts:Title: Champions League Final 2009 – FC Barcelona vs Manchester United [...]

Leave a Reply