I have created an Excel spreadsheet to compare like for like games in the current season with those from last season. It is very simple, but I have a business where I create custom Excel spreadsheets for small businesses, and I would like to give this Charlton spreadsheet away as a freebie. I would just like to see if people are interested in getting hold of it before I upload it and have it available for download. Is this something that you guys would like, or is there already one doing the rounds? I moved to SE London a few years ago from Cape Town, South Africa and I grew up as a Man United fan (my dad was born in Manchester). I have decided to support Charlton (I live between Charlton and Crystal Palace, but who wants to support Palace?). Glad to be an Addick.
4
Comments
Has it got graphs, I love a pie chart?
Loving your name too.
Any chance of you buying us a striker ?
:-)
Would you like to join CHARLIES? Its a sub group called CHARlton LIfe Enjoys Spreadsheets.
I'll try and get this done and get it uploaded by the weekend. I'll put the link up here when done.
I thought I was a nerd with this love for spreadsheets, but I guess I'm in good company here :-)
Also you seem to be able to select the same fixture twice. I would have thought that if you build spreadsheets for professional clients (and having your logo on the graph would suggest that this is an indication of what you would offer, professionally) you would ensure that you cannot allow this user error.
It is informative but, personally, I find it a little loud and the formatting isn't to my taste, but I may well be in a very small minority thinking that. An unprotected version would be useful, especially if the historical data could be entered then a comparison from previous seasons would be possible.
I hope this doesn't come across as overly critical but I don't think it's too unfair or unreasonable a critique bearing in mind one could suggest that there are more adverts on it that are strictly necessary for a fan built football spreadsheet. It has also not gone unnoticed that the spreadsheet with adverts for and links to your business was shared the day after you joined CL. There is, clearly, nothing wrong with that and if you were eleven and doing a school project then I would have been very gushing, but a taster of what you offer professionally probably needs to be flawless.
Just my opinion.
I'm sure it's something you feel strongly about but for me personally it is a big negative.
As for your first comment, the teams that were in the Championship last season and not in it now, will not show up. As it states on the spreadsheet, they are compared to the teams that were promoted/relegated in their place.
As for the second point, point taken, I could change it to do this. When I have some time I'll take a look at that.
I'm hesitant to put an unlocked version up as I have all sorts of hidden data which I do not want to be disturbed. I understand about the 'loud formatting'.
I understand your last comment. I actually didn't intend to put this (and the Man Utd) one up originally, I just did them for my own use and thought that others could get some enjoyment from them too, so I thought that I would share them. The logos were an afterthought really. Maybe it is best if I just removed them. The last thing I wanted to do was upset anyone or put them off my business. I just wanted to share them.
Yes, there are hidden pages with last season's results in, as well as hidden columns with data and the data for the chart is hidden. There is also conditional formatting.
And you can't unprotect those because....
I can unprotect them, I'm just hesitant to because the spreadsheet will not work if they are disturbed. Not everyone using it is as competent as you.
There goes our Sugar Daddy.
Nice while it lasted, RR
There's a little Club playing in blue just down the road who would be DELIGHTED to see their season's stats !