Excel Templates | Excel Spreadsheets | UEFA Champions League Fixtures 2011/2012



UEFA Champions League Fixtures 2011/2012

Posted on August 28, 2011
Filed Under Sports | 27 Comments

Pin It

UEFA have made the draw for the group stages of 2011/2012 Champions Leagues on Thursday, 25 August 2011 in Monaco. Barcelona, the former champions, will try to defend its title at their home by playing against AC Milan on 14 September. Both of teams are looked like will go through the next round if they don’t underestimate the other two clubs in group H, Viktoria Plzen and Bate Borisov.

The other top seededs are looked like will also advance from their groups, if they don’t underestimate their opponents, as you can see the group division below.
-  Group A: Bayern Munich, Villarreal, Manchester City and Napoli.
-  Group B: Inter Milan, CSKA Moscow, Lille Metropole and Trabzonspor.
-  Group C: Manchester United, Benfica, Basel and Otelul Galati.
-  Group D: Real Madrid, Olympique Lyonnais, Ajax Amsterdam and Dinamo Zagreb.
-  Group E: Chelsea, Valencia, Bayer 04 Leverkusen and Genk.
-  Group F: Arsenal, Olympique de Marseille, Olympiacos and Borussia Dortmund.
-  Group G: Porto, Shakhtar Donetsk, Zenit St Petersburg and Apoel.
-  Group H: Barcelona, AC Milan, Bate Borisov and Viktoria Plzen.

All group matches will start from 14 September and will end at 8 December 2011. Below is the full schedule of drawing and matches until the final at 19 May at Allianz Arena, Munich, Germany.
- Group matches, 14 Sep – 8 Dec 2011
- Round of 16 drawing, 9 December 2011
- Round of 16 matches, first leg, 14 – 15 December 2012 or 21 – 22 February 2012
- Round of 16 matches, second leg, 6 – 7 March 2012 or 13 – 14 March 2012
- Quarter-finals drawing, : 16 March 2012
- Quarter-finals matches , first leg, 27 – 28 March 2012
- Quarter-finals matches, second leg, 3 – 4 April 2012
- Semi-finals matches, first leg , 17 – 18 April 2012
- Semi-finals matches, second leg, 24 – 25 April 2012
- Final matches, 19 May 2012

This 2011/2012 UEFA Champions League Fixtures and Scoresheet is the same with the previous season template. I plan to make additional calendar worksheet so you can see the whole schedule in one worksheet but I don’t have enough time to do it now due I will be out of town for a week. Perhaps later I will add it.

For you who never use this template before, below is a short guidance to use this Champions League 2011/2012 schedule template :

-  Put result scores in score boxes in ‘Group Qualification’ worksheet. The standing table next to it will be adjusted automatically.
-  When all group matches are played, you will see the top two teams that qualify for round of 16 shown up in the drawing rows below group standing table. Watch the round of 16 drawings at 9 December (or you can just read from newspaper or internet at the next day :) ), and fill the box beside those teams with the drawing numbers. Drawing numbers are corelated with matches numbers. For example put matches #1 in cell next to Barcelona in group winner box and in cell next to Villareal in group runner up box. There are several rules applied when UEFA draws these matches, for example, round of 16 cannot have matches between teams from the same countries or the same groups.
-  Go to ‘Knock Out Phase’ worksheet. Since some entries are based on drawings, I cannot make it all entry automatic. You should fill it manually. The blue boxes at the left and right side of these matches are applied to home teams. Start filling the date and time of first and second legs in corresponding boxes.
-  Fill the result scores of round of 16 matches
-  When all round of 16 matches are finished, UEFA will do the drawing once again. You should do the pairing matches manually. All round of 16 winners will be shown in cell H99-H106 (with words ‘Winner of First round #’ next to it. There are selection boxes on top of it. Do the pairing matches by select the teams manually. You will see that there are another pairing matches for semi-finals. You will do this pairing later.
-  In the quarter-finals box, fill again the date and time of the first and second leg matches.
-  Fill the result scores of quarter-finals matches
-  When all quarter-finals matches are finished, go once again to the semifinal box inside the drawing box, and you can see information about winner of quarter-finals matches. Since which teams that will become a home team at the first leg is not yet known in the beginning, you have to enter the team manually once again from selection boxes.
-  Again, do filling the date and time for first and second leg in semifinal boxes.
-  Fill the result scores of semifinal matches
-  Fill the result scores of final match.

You can make two copies of this scoresheet, where you can use one copy to play with your prediction and one copy for the real results.

Ok guys. You can download the file here. If you found some minor errors, for example group names, or dates, you can manually correct it inside the box. Or, if you want to display it by group instead of by matches date, you can manually change it. If you found major error, which usually related with the excel formula, let me know. It could be unnoticeable error eventhough this template is already being used to the 3rd season.

  UEFA Champions League Fixtures 2011/2012 V1.43 (100.1 KiB, 10,249 hits)



Tags: , , , ,

Comments

27 Responses to “UEFA Champions League Fixtures 2011/2012”

  1. ginmetal on August 28th, 2011 7:32 pm

    I waiting for English Premier League 11/12 excel file…

  2. Paul on August 29th, 2011 8:38 am

    Many thanks 4 this !!!

  3. Paul on August 29th, 2011 8:42 am

    Date’s are wrong, there is no champions league on thursday

  4. Tal on August 29th, 2011 9:39 am

    hello R. Musadya,

    i couldn’t find your email on the website.
    there is some questions i would like to ask you so it will be nice if you’ll send me your mail.

    thank you for your time.

    Tal

  5. Cannon11 on August 29th, 2011 12:40 pm

    Pleasee i waiting for English Pre League 2011/2011

  6. leonardo on August 30th, 2011 8:51 am

    it’s great… many thanks for you brother!

  7. jayank2000 on August 31st, 2011 1:45 am

    How to enter the teams in the knockout stages. Can you please explain it. Thanks

  8. Jens on September 8th, 2011 9:34 am

    Thank you for this! Is there a file the europa league to? I would love to have this to :)
    Thank you!!

  9. Mick on September 12th, 2011 12:23 pm

    Do you do a group/league set-up for the Rugby World Cup??? It would be great to have one for that!

  10. Saul on September 13th, 2011 8:49 pm

    Date’s are wrong mate !! firts group start’s on September 13, 2011 … Thank You

  11. Les Barrett on September 14th, 2011 11:36 am

    Hi hope you are keeping well
    I run one of the biggest girls football leagues in England

    every four months we run our cup competitions
    based on uefa group format

    your spread sheet is ideal and just what we need
    the only problem is that we have groups up to ten teams per group

    could i be cheeky and ask you for the unprotec pasword in the dummy tables
    so that i could enlarge the groups
    this would save me many hours work
    Best wishes
    Les Barrett
    General League Secretary
    Central Warwickshire Girls League
    07957433154

  12. fabian on September 15th, 2011 3:27 am

    it would be more excellent if you put the team logo on the group standings
    but thanx a lot

  13. alex on September 15th, 2011 6:16 pm

    They can’t put an EPL file because of some copyright rules… if you look the last one was in 2008 or 2009… nothing since then…

  14. Laurence on September 19th, 2011 11:25 am

    Is there a UEFA Europa League Version???

    Great template – thanks

  15. Paul on September 22nd, 2011 5:09 pm

    Is there going to be a EPL file as there was one last season

  16. asdf on October 1st, 2011 9:22 am

    s there a UEFA Europa League Version???

    Great template – thanks

  17. dave gugkl on October 11th, 2011 4:13 pm

    hi i just thought what about just doing a 24 team in the same format so we can modify it to do the championship/div1/div2, with the same pages, the team fixtures and results page also, with the green grid. thanks and please reply soon.

  18. jadwal UCL season 2011-2012 « ~expand your mind~ on October 18th, 2011 3:17 am

    [...] Yoo UCL musim 2011-2012 udah mulai, skarang ini masih dalam babak kualifikasi grup tepatnya di matchday ke-3. UCL musim ini gak seperti musim lalu dimana ada 1 grup neraka yg notabene kumpulan klub-klub peraih trofi terbanyak. Nah kalo musim ini gak ada grup neraka, jadi babak kualifikasi grup bakal berlangsung gak gitu menarik, nah pas di babak 16 besar baru klub-klub besar bakal ketemu. Langsung aja, berikut hasil draw klub dan jadwal lengkap UCL 2011-2012 mulai fase grup sampai ke fase knock-out. FYI, file ini didapat dari exceltemplate. [...]

  19. lastings on November 5th, 2011 4:43 am

    this is effing brilliant. Thank You!

  20. Emanuele on November 19th, 2011 12:09 pm

    I made a template for basketball based on your work. Can I send it to you?
    greetings

  21. Ramin on November 30th, 2011 9:30 am

    I run one of the girls football leagues in Azerbaijan
    Can you help me make such table for our league ?
    Best wishes
    Ramin

  22. Wouter on December 16th, 2011 5:05 pm

    Hey man
    I filled in the group matches with my own imagination but the group winners and runner ups are not correct.. What about that?
    x

  23. Anwar on December 28th, 2011 12:44 am

    tolong dong dibuatkan jadwal piala eropa beserta scoresheetx

  24. AL on May 18th, 2012 4:10 pm

    is possible to personalize this template? i play to subbuteo and this template is good.

  25. http://www.sampledonationrequestletter.org on August 2nd, 2012 7:21 am

    We had problems determining precisely how to prepare a good quality contribution request letter. The moment you get started you realise it is a great deal more challenging than you actually assumed. I had been performing the fund raising for my local rotary club.

  26. Hey, just coming by your cool stuff .. hope you can check out my blog too! on September 9th, 2012 5:22 pm

    You know thus significantly when it comes to this subject, produced me in my opinion believe it from a lot of varied angles. Its like women and men aren’t fascinated except it’s something to accomplish with Girl gaga! Your individual stuffs great. At all times handle it up!

  27. soccer ball pics on May 3rd, 2013 2:28 am

    Nice weblog right here! Additionally your website a
    lot up very fast! What host are you the usage of?

    Can I get your affiliate hyperlink to your host? I want my site loaded up as fast as yours lol

Leave a Reply