2011 Stats

[laughingnome]

You're a wonder, Frog. I can't wait to crunch these numbers.

[Frog]

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.

[laughingnome]

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).

[Frog]

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)

[ScottH]

Rnd 8 Stats are done.

Mummy had 24 for HO with 50% to advantage.

[ugg]

Rnd 8 Stats are done.

Mummy had 24 for HO with 50% to advantage.

Cheers Scott. How was LRT's hitout to advantage?

[Frog]

Substitutes stats - Week 8

Selected S U B S T I T U T E S

Team	#	Name	K	H	P	Eff%	CM	TM	CP	UP	I50	Clr	Clg	HO	T	FF	FA	G	B	Ass	TOG%
Crows	33	B.Smith	3	1	4	50	0	1	1	4	0	0	1	0	0	0	1	0	0	0	73
Lions	26	R.Harwood	6	6	12	67	0	2	4	8	1	2	0	0	5	0	0	0	0	0	53
Blues		Bye
Magpies	33	B.Dick	1	2	3	67	2	2	2	1	0	0	1	0	0	0	1	0	1	0	44
Bombers	32	T.Colyer	5	2	7	57	0	1	1	6	1	0	0	0	1	0	0	0	2	0	28
Dockers	4	J.Pitt	3	1	4	75	0	0	0	4	1	0	0	0	1	0	0	0	0	0	61
Cats	28	A.Christensen	3	2	5	100	0	2	2	3	0	1	1	0	0	1	1	1	0	0	45
Suns	19	J.Daye	5	4	9	56	0	0	3	5	2	0	0	0	3	1	0	0	1	0	57
Hawks	47	L.Breust	11	2	13	38	1	4	5	8	4	0	3	0	2	2	1	2	2	1	85
Kangaroos	46	B.Speight	3	4	7	71	0	1	2	5	0	1	1	0	1	0	0	1	0	0	54
Demons	7	Jamie Bennell	3	4	7	57	0	2	5	3	1	2	1	0	4	1	0	0	0	0	75
Power	26	A.Moore	1	4	5	60	0	1	3	3	0	1	0	0	1	1	0	0	0	0	30
Tigers	22	B.Nason	6	4	10	80	0	4	3	7	1	0	0	0	1	1	0	1	1	0	56
Saints	35	J.Cripps	3	3	6	50	0	1	0	6	1	0	3	0	2	0	2	2	0	0	46
Swans	26	L.Parker	4	3	7	86	0	2	1	7	1	1	0	0	1	1	0	0	0	1	16
Eagles	3	A.Gaff	5	0	5	40	0	3	0	5	1	0	0	0	1	0	0	0	1	0	41
Dogs	44	B.Moles	4	4	8	75	0	1	0	7	1	0	1	0	1	0	1	1	2	1	47

Players S U B S T I T U T E D

Team	#	Name	K	H	P	Eff%	CM	TM	CP	UP	I50	Clr	Clg	HO	T	FF	FA	G	B	Ass	TOG%
Crows	46	C.Schmidt	5	10	15	87	0	3	5	10	2	1	0	0	2	0	0	0	0	0	75
Lions	31	J.Polkinghorne	0	0	0	0	0	0	0	0	1	0	1	0	0	0	1	0	0	0	77
Blues		Bye
Magpies	34	A.Toovey	6	5	11	73	0	2	5	5	1	1	1	0	1	0	0	0	0	0	78
Bombers	4	J.Watson	10	8	18	61	2	2	9	9	3	5	2	0	2	1	1	2	1	0	82
Dockers	34	N.Lower	5	5	10	50	1	5	4	6	2	0	4	0	1	0	1	0	1	0	71
Cats	45	C.Ling	7	5	12	67	0	2	6	6	3	1	4	0	2	1	1	0	0	0	79
Suns	43	L.Patrick	0	2	2	100	0	0	0	3	0	0	2	0	1	0	1	0	0	0	53
Hawks	27	S.Gilham	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	81
Kangaroos	7	J.Ziebell	10	9	19	63	0	5	7	12	2	2	1	0	8	0	1	0	1	1	63
Demons	20	Colin Garland	3	1	4	100	0	2	1	2	0	0	0	0	1	0	0	0	0	0	85
Power	43	D.Stewart	2	3	5	40	1	3	3	3	1	0	0	3	0	0	0	0	0	0	75
Tigers	10	S.Edwards	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	65
Saints	32	A.McQualter	1	3	4	100	0	0	3	1	0	0	1	0	1	2	1	0	0	0	56
Swans	45	N.Gordon	1	4	5	100	0	1	3	3	1	0	1	0	2	1	0	0	0	0	64
Eagles	35	P.McGinnity	8	5	13	69	0	4	4	9	1	1	0	0	3	1	0	0	0	0	81
Dogs	20	J.Hill	1	4	5	60	0	0	4	2	0	0	3	0	2	0	3	0	0	0	81

[Frog]

Swans Subs

Rnd	#	Name	K	H	P	Eff%	Con M	Tot M	C Pos	U Pos	I50	Clrncs	Clgrs	HO	T	FF	FA	G	B	Assists	TOG%
1	1	Mark Seaby	1	3	4	100	1	1	4	1	0	0	1	1	3	2	1	0	0	0	16
2	7	Brett Meredith	2	1	3	100	0	2	0	3	0	0	0	0	0	0	0	0	0	0	17
3	16	Gary Rohan	6	3	9	33	1	2	6	4	1	0	0	0	2	1	0	1	1	0	31
4	16	Gary Rohan	4	2	6	33	0	0	2	3	3	0	2	0	1	0	1	0	0	0	31
6	13	Andrejs Everitt	3	2	5	40	0	1	3	2	1	0	1	2	3	0	0	0	0	0	31
7	33	Jarred Moore	2	2	4	25	0	1	2	2	1	0	1	0	1	0	0	0	0	0	20
8	26	L.Parker	4	3	7	86	0	2	1	7	1	1	0	0	1	1	0	0	0	1	16

[ScottH]

Cheers Scott. How was LRT's hitout to advantage?

I'd be guessing, but I think it was in the high teens.
I'll check tonight.

[ugg]

Froggy, or anyone else for that matter, do you have the time during the quarter that they came on the ground? It would be interesting to see if the sub spends less time rotated on the bench than the other players.

[Frog]

Froggy, or anyone else for that matter, do you have the time during the quarter that they came on the ground? It would be interesting to see if the sub spends less time rotated on the bench than the other players.

I can find when the substitution occurred (at 3QT, during Q4, injury Q1) but not the exact time in that quarter (FanFooty Archives)
stats.rleague, footywire, AFL, Herald/Sun do not seem to list that info at this stage - I'm sure someone has it, just not yet ...

[ScottH]

Cheers Scott. How was LRT's hitout to advantage?

Mummy 24 @ 50% = 12
LRT: 13 @ 15% = 2

Bogan: 35 @ 17% = 6
Westhoff: 6 @ 33% = 2