UEFA has just released the Group matches schedules of UEFA Champions League 2012/2013 based on drawing results on 30 August 2012. From all 8 groups, group D seems to become a group of death where Real Madrid, Manchester City, Borussia Dortmund and Ajax will fight each other to become the top two team in this Group D.
And following the release of those schedule, I have created the new version of UEFA Champions League 2012/2013 Fixtures and Scoresheet where I made a few modification. In this new template, I provide an Individual Team Information where you can see a brief stats of particular team and its schedule in calendar layout. Just select your team, and you will see :
- Its current standing in its group
- Its fixtures, from group until final, with conclusion after its stages (eliminated from Group Stages, lost because away goals etc), as you can see in the screenshot.
- Its history for the past five years (I haven’t finished it, perhaps you can complete it by typing in team history worksheet )
- Its fixtures in calendar view, and there is a color marker description below its calendar.
And there is highlight matches option in Group Matches worksheet where you can highlight matches based on your particular group or team selection.
I still want to improve it by adding language features and completed team history stats, but I want to finish my other project first before tidy this template up. Since there is no major modification on this template, you can follow the same guidance I have provided in previous Champions League template.
You can go to download it below. The 97/2003 version will have no highlight feature but still have the Individual Team version with fewer color marker since the maximum conditional formatting that can be supported by those version is three.
If you would like to see the formula to form this template or if you just want to thank me , you can send me 10 bucks from paypal button below and I will send you the unlocked template. I believe that you will respect my creation that you will use for your own purpose and won’t distribute this unlocked template to anybody without my permission or claim it as yours.
UEFA Champions League 2012/2013 Fixtures V1.54 (Excel 2007/2010) (180.7 KiB, 7,280 hits)
UEFA Champions League 2012/2013 Fixtures V1.54 (Excel 97/2003) (488.0 KiB, 3,826 hits)