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



Champions League Fixtures 2009/2010

Posted on August 29, 2009
Filed Under Soccer |



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

  2. Page 2
  3. Page 3

You can read and download my other templates below :

Tags: , , , , ,

Comments

58 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

Leave a Reply