A brand new MS Excel spreadsheet has been developed so you can keep track of Chelsea’s 2008-09 season. Fill in the matches as the season progresses, and you can find out a whole array of various statistics in both tabular and graphical form.
Examples of the statistics calculated, on both the players and team as a whole, include player appearances, goals and assists, time spent on the pitch, number of games won, drawn and lost and much, much more.
Click here to download a copy. Unfortunately, due to the formatting and functionality involved, only an Excel 2007 version is available.
Note: the spreadsheet uses macros, which need to be enabled for full functionality to be utilised.
Edit: click here for a partly filled out spreadsheet, covering matches up to and including the home Champions’ League match versus AS Roma.
Entries (RSS)
August 10th, 2008 at 1:06 pm
Cheers Chris! Top notch as usual!
August 11th, 2008 at 2:36 pm
your the best chris. you never manage to dissapoint me.
August 12th, 2008 at 10:10 am
Cool!
August 25th, 2008 at 9:09 pm
Whats the password to unprotect this?
August 25th, 2008 at 9:22 pm
Neil: it is not supposed to be unprotected.
August 26th, 2008 at 5:35 pm
HI Everyone! Firstly I want to apologize for my English because I’m from Poland and my English is not so well…. but I have a question about yellow & red cards… ‘cuz in the tab ‘Player Stats’ is note saying: ‘To mark a player as receiving a yellow or red card, use yellow or red text formatting (from the standard colour pallette) on the player’s name in the appropriate match in the ‘Matches’ tab.’….and is it mean sth like that? http://img377.imageshack.us/img377/1820/beztytuukz5.jpg (on yellow it’s ‘Terry’ ‘cuz quality is not good)
Because if it’s did good (like i did) why i the tab ‘Player Stats’ nothing is changing? So maybe it’s because of my Excel language? Maybe Polish version of Excel don’t know what is yellow or red in English? is this problem or it’s my fault?
cheers!
August 26th, 2008 at 5:56 pm
Zico: The way you have formatted the name to signify a yellow card appears to be correct. However, from your screendump picture you will notice there is a security warning bar above the formula bar. This security warning tells you that macros have not been enabled. As I mentioned above:
“Note: the spreadsheet uses macros, which need to be enabled for full functionality to be utilised.”
In order to calculate all the values which currently has “###” in them (including the number of yellows/reds), macros need to be enabled. This can be done via the button on the security bar mentioned.
August 26th, 2008 at 6:51 pm
Thank you so much!!! Sorry for problem because i’ve never heard anything about that macros. By the way, THANK U FOR THAT Spreadsheet!!! It’s great thing!!
You are the best! cheers!
August 26th, 2008 at 6:54 pm
of course “a problem” and “a great”
sorry
August 31st, 2008 at 11:17 am
Ok, How do i add Deco to it?
August 31st, 2008 at 11:31 am
Neil: The player list can be updated via the Player Stats sheet. On the left is the list of players in the squad next to their squad number. This list defines the selection of players that can be made throughout the rest of the workbook.
As an aside, Deco is already in there, under Anderson Luis De Souza, which is his real name.
August 31st, 2008 at 11:44 am
Ah, Thank you! That was a real blond moment..