Tuesday, 18 January 2011

Traffic Lights


Not content with stealing blogging ideas from the exchange forums, I have lowered myself even further by enhancing my ratings spreadsheet with a 'traffic light' feature that I saw on some obscure blog out there. I like the idea, because it shows at a glance whether teams are currently meeting expectations, or whether they are over or under performing. From a ratings perspective, I would like to see mostly yellow - as these are results that were close to expected. Over the last six games, Tottenham Hotspur are the consistent team in the EPL, with their last five games finishing as expected, whereas Arsenal and Stoke City are the unpredictables. Spurs are also the only team without a single red (under-performing) rating, while Chelsea, Manchester United and WBA are the only three who have failed to exceed expectations at least once.

In the Championship, my top rated team is currently Reading, although they are currently outside the play-off spots. Reading and Watford do not have a red between them, but Portsmouth, Coventry City and Preston North End do not have a green between them.

League One sees the only team with all green - rather surprisingly Notts County currently languishing in 16th place in the league but apparently destined to place higher. Peterborough United and Rochdale are the most consistent teams.

In League Two, strugglers Hereford United are the in-form team exceeding expectations in five, and meeting in one, of their last six matches. Gillingham and Crewe Alexandra are also red free, while Bury don't have a single green.

In the Conference, Eastbourne Borough and Rushden and Diamonds both lack a green, while Hayes and Yeading United don't have a red. I guess when expectations are low, it's easy to meet them. I must remember that for work.

Back to the top teams, and in Serie A Udinese are red free while Juventus and Catania have no green. In Spain, every team has under-performed at least once, with Real Madrid the only team that hasn't over-performed at least once. Sochaux are the most consistent team in France, performing as expected for the last five matches, and Wolfsburg are the same in Germany, although they and Stuttgart are the only two not to excel in six games.

How useful this new feature will be remains to be seen, (early thoughts are that it could at least be an extra filter), but it's kind of interesting. Well, to me.

Thanks to Mark for the idea.

4 comments:

Mark Iverson said...

That looks more like a magic eye pic to me :-)

http://tinyurl.com/6ea8her

The Betfair Trader said...

Hi,

I just discovered your blog and have added it to my bloglinks. If you find my blog interesting, I would be happy if you could return the favour!

Cheers,
Tore
http://www.betfairtradingpro.com

swearbox said...

Cassini something is troubling me. In your blogroll you have a link for Cubone's blog (I do in mine also). A few days ago I was looking through your post of the day and noticed that Cubone had submitted a new article (at the time it showed it was 4 minutes old) though I've forgotten what he named it. I clicked through from your blogroll to his site and found that the most current posting was entitled 'The Edge' (not the title showing in your link). I notice that today your link shows that the latest post is entitled "I wish I was 18 again" but when I visit his site I still get 'The Edge' as his most recent post. Can you shed any light ?

Rob

Cassini said...

Yes, that's a little odd Swearbox - looks like he deleted the post that my blog thinks is the latest, and now it is all confused! Maybe his post needed a little editing to make it readable...