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



Champions League Fixtures 2009/2010

Posted on August 29, 2009
Filed Under Soccer |



Knock Out Phase
If you go to this worksheet before all group matches is completed and before all matches are revealed, you will find empty worksheet without any teams in team boxes. But, you can make them appeared by making dummy scores and drawing results in group qualification worksheet, like what I do for the explanation.

Champions League Quarter Final Matches

Say that all group matches are completed and drawing has been made, you will see all teams are revealed in this worksheet where runner up teams will play as host in the first leg. Make sure that you only enter your score in the blue boxes. Don’t enter score results in white boxes because it contains formula that will calculate the winner based on the regulation. You can complete the date and time information inside the home team boxes or you can put your TV show information in these two rows, but don’t change the information in matches row (number 1 to 8). It will affect the excel formula.

In the example, as you can see in the picture for the first match, AC Milan win 1 - 0 againts Bayern Munich at home and lost 1 - 2 while visiting Bayern Munich. But AC Milan advances because of away goals rule. And there is formula to calculate that, so you don’t have manually calculate it. And there will be no impact that will affect the result if you fill the extra time and penalty box.

After all first round matches is completed, you can go to the drawing table below the first round table. There is a table that is filled with all the first round winner and an empty quarter final matches table. Here, you have to fill it manually based on the drawing that is planned to be held on 19 March 2010. This is an open drawing where any teams can meet each other without same country consideration.

Champions League Quarter Final Draw

And semifinal matches also being drawn here. Since there is no teams name available, the drawing will be based on the quarter final winner number 1 to number 4. You can select the number based on the drawing result. The formula will do the rest for you.

Now, you can start to fill the score box for quarter final matches. And you can go to the semi final matches where the team who meet will be revealed automatically, and continue to fill the box score.

Before filling the correct results, you can try to fill dummy results and play with many possibilities to reveal your predicted champion. In this sample worksheet, Chelsea will win the Champion League by beating Real Madrid in the final match which held in Santiago Bernabeu, Madrid… No offense, this is just a sample. You can do the same to make your team become the champion, at least in this spreadsheet first :-).

Champions League Final

Ok guys, you can download the spreadsheet HERE. If you like this spreadsheet, don’t forget to buy me a ticket for the Champions League final if your team play in the final :-). Let me know if you found some bugs inside the spreadsheet.

  1. Page 1
  2. Page 2



You can read and download my other templates below :

Tags: , , , , ,

Comments

75 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. Tim on August 23rd, 2010 3:03 pm

    Your are great I looking a long time for this stuff thank you.

    My English is not so good

    im for holland

    Thanks

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

    Excellent work!

    Could you create a spreadsheet for the Europa League too?

  72. 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.

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

    yes

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

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

    and the Europa league ?????

  75. 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…?

Leave a Reply