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



Champions League Fixtures 2009/2010

Posted on August 29, 2009
Filed Under Soccer |



Group Qualification
This is the worksheet that you will work on until all group matches have been played, until December 2009. This worksheet will have blank scoreboxes, but I put some samples that you can see in the first picture (you can enlarge it by clicking the picture). If you want to adjust the order of matches, for example based on time instead of the group order, you can change it manually.

Once you settled the match fixtures, you can start filling the score result in blue boxes where the color will turn into white after you fill the score.

I have put tie breaking regulation formula from the beginning, so you can monitor your favourite team progress based on the official tie breaking regulation. And in the picture you can see how the formula working when some groups have several tie possibilities. For example in group A, there is a tie position between Bayern Munich, Juventus and Bordeaux to get the first, second and third position. And you see that Bayern Munich and Juventus are qualified to knock out phase because of better head-to-head matches with Bordeaux and Bayern Munich topped the group eventhough the goals difference are worse than Juventus.

In group B, CSKA Moscow had a better head-to-head matches result with Wolfsburg which made CSKA qualify for the knock out phase. You can see also how the tie breaking formula works on Group C and group D tie position.

You can try to put your score just to test the formula, just in case, I missed something which cause some rule are not applied correctly.

After all group matches are played, you can go to the drawing box below the group table. There is automatic formulas that will position all group winners and runner ups in corresponding rows. Here, you have to put the next matches based on the Champions League quarter final drawing that plan to be held on 18 December 2009.  All you have to do just put quarter final match number next to group winner and runner up teams that is revealed from the drawing. After you finished filling all matches, you can go to the next worksheet.

Champions League First Round Knock Out Draw

  1. Page 1
  3. Page 3

You can read and download my other templates below :

Tags: , , , , ,

Comments

69 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

Leave a Reply