I've been souping up the spreadsheet I started a few weeks ago to include a few more bits of data. I still haven't got any consideration for home and away performances, but I've added in records of disposal efficiency (a stat I'm prety sceptical at the best of times), tackles for and against and a simple win/loss summary of games played at 'home' (a loose term) or on the road. Coloured cells indicate whether the team won or lost the match.
I've found a few interesting things in it (they are to me anyway). Despite being sceptical of disposal efficiency in terms of what you can glean from it, well, as an absolute number, there's not much, but that won't come as any surprise. For example, Adelaide have a higher DE% than Geelong, but are on totally opposite ends of the ladder, which obviously makes no sense. What I did find interesting was there is some correlation so far this season between disposal efficiency and performance - that is, when a team's DE% is lower than their average percentage, they tend to lose. So it's not a stat you can totally disregard.
In the tackles sheet I've developed a weighted average, as best I can, to account for the amount of time spent in possession and out of possession. It's a bit clumsy I'll admit, but I've used average disposals for and against to come up with a loose way of determining this. If you look at the difference between the weighted averages it tells you some things you'd already know: Adelaide are ****, Richmond are twice as bad, and the Hawks and West Coast aren't far off being the worst sides at applying pressure either. Interestingly, Freo have a negative value as well, which could suggest that whatever they're doing that has them playing so well this season, it isn't pressure on the ball carrier. Ditto the Bulldogs. I think it provides food for thought on how these sides should be countered.
Still early days with only 5 rounds of info to go off, but I'm hoping this comes in handy at some point in the future.
If people like it I'll post updates week to week. (Note the figures on the first sheet do not include the last half of RD5 - left the updated version of it at home.)
'Copperfield,' said Mr. Micawber, 'farewell! Every happiness and prosperity! If, in the progress of revolving years, I could persuade myself that my blighted destiny had been a warning to you, I should feel that I had not occupied another man's place in existence altogether in vain.
- Wilkins Micawber