Italian Serie A competition has just started by the time I release this Italian Serie A 2012/2013 Fixtures and Scoresheet template for excel. For the past three months, AC Milan and Juventus have become teams which being talked by most of people around the world. This is because AC Milan has lost majority of their main players while Juventus has lost its coach, Antonio Conte, which led Juventus to become Serie A Champion last year. AC Milan has lost Zlatan Ibrahimovic, Thiago Silva, and the latest one is Antonio Cassano who moved to Internazionale. And you won’t see Inzaghi, Nesta, Seedorf, Zambrotta, Gattuso, van Bommel as part of Milan squad also. Eventhough Milan coach, Allegri, believe that his team is still competitive to fight for Serie A title, it is hard to believe this new team will capable enough to take over serie A crown from Juventus. And it looks like that the race for Serie A champion will be wide open, considering that almost all Serie A teams are maintaining the 2011/2012 squad.
To follow all progress of Serie A team in this 2012/2013 season, I have made a new Serie A 2012/2013 fixtures and scoresheet for excel which totally different from the previous years. It took some time to finish this new one, because I tried to make the general template which can be used to create and map all soccer league competition around the world with ease. You will see the words “Powered by Excelindo Soccer League Creator” at the bottom of several worksheets inside this template. That is the main program, in excel, to create this fixtures.
There are several features I have added in this new template, several of those are:
1. Italian Serie A Tie-Breaker Policy
I have adapted the Serie A tie-breaker policy where the final position for Serie A competition will be ranked based on rules as follows:
– 1 > All Matches – Highest Point
– 2 > Team Concerned Matches – Highest Point
– 3 > Team Concerned Matches – Better Goal Difference
– 4 > All Matches – Better Goal Difference
– 5 > All Matches – Better Goals Scored
– 6 > All Matches – Better Away Goals Scored
– 7 > Team Concerned Matches – Better Goals Scored
– 8 > Manual Re-Rank
2. New Dashboard Design
I made some improvement in Dashboard design which will ease you to track Serie A progress
3. Last 5 Matches Results
Now, you can see your team performance in their last 5 matches
4. Team Fixtures with Calendar View
I made a major modification in team individual information worksheet where you can see a few stats of your favorite teams and also all matches in one year calendar view. And there is an explanation of marking dates colors below the calendar.
There are other features that you might explore after you downloaded the file. By the way, this template cannot be used with Excel 97/2003, because of some formulas and conditional formatting which need at least Excel 2007 to make it running well. But, I still prepared the old one, just in case you haven’t upgrade to Excel 2007/2010, but still want to follow Serie A 2o12/2013 matches. But, I suggest you to upgrade it to the upper version, if you want to feel the new features :).
There are plenty of information about the features which I think I haven’t explained, but you can leave your questions in comments box below. Please send me some feedback if you found any errors so I can fix it quickly.
Italian Serie A 2012/2013 Fixtures and Scoresheet - Update 1(Excel 2007/2010) (2.6 MiB, 7,447 hits)
Italian Serie A 2012/2013 Fixtures and Scoresheet (Excel 97/2003) (578.4 KiB, 3,281 hits)