If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
I have them all spreadsheeted - what do you want to crunch, what order?
It still looks to me that there are few substitutes that work.
Perhaps someone should tell Horse that substitutes don't work. Don't use them yourself and make sure you use the opposition's substitute to your advantage.
I have them all spreadsheeted - what do you want to crunch, what order?
Well I guess the most obvious (and therefore first) is to average out TOG to allow an easy examination of subs across clubs, accounting for outliers in TOG when it is outside, say, the Interquartile Range. Then measuring the effect each team is having with the sub player, broken down to round by round as neccessary to check for errors and abnormal values, and to run a similar measurement against the club OPPOSITE that the sub is playing for (ie is there a club that other teams are killing with the sub?).
As I said though, I'm more than willing and able to do my own dirty work when I'm a) sober (celebratory drinks: whahey!) and b) got time on my hands (which is over the next week, give or take).
The TOG figures, whilst extracted from Champion Data are not the most reliable. Between substitute and substituted, they are often greater than 100%.
I am still trying to source a more reliable TOG.
Also happy to share the spreadsheet. PM me your email address. (and let me know if you want 2003 or 2007 format)
Comment