Stats resources.

(Log in to remove this ad.)

Chrizzt

Norm Smith Medallist
Aug 17, 2009
7,329
13,991
AFL Club
Port Adelaide
Is there any way to view spread of goalkickers per game or per team, and even sort by how many players from team A kicked at least X goals in a game? Am interested primarily in looking at Port's spread of goalkickers in a game across the last few years.
 

*Paul*

Club Legend
Nov 8, 2000
1,221
337
Canberra
Other Teams
Canberra Raiders
If I'm reading you right, how many different goals kickers in a match? Here's a simple table, making the columns line up is no trivial task apparently.
Code:
2006      8  8  7  8  9  6  8  7  13  11  14  9  7  6  7  7  5  6  11  8  8  8
2007      10  8  7  7  9  6  10  8  7  7  9  9  9  9  10  10  9  5  10  8  7  7  9  11  4
2008      9  6  6  12  9  8  12  8  6  8  7  4  11  8  7  5  7  10  7  8  9  12
2009      8  6  13  8  4  7  11  8  7  9  11  6  7  11  10  9  7  9  8  6  8  6
2010      9  7  7  7  4  8  9  10  11  3  6  8  5  6  6  5  5  8  6  6  9  10
2011      6  9  5  8  10  6  9  7  10  8  5  11  9  6  6  8  6  2  5  8  7  10
2012      9  8  7  8  6  6  5  8  11  9  6  5  6  5  6  8  5  7  8  5  10  9
2013      11  11  8  6
 

SJ

Moderator
May 22, 2006
33,029
15,936
Melbourne
AFL Club
Geelong
If I'm reading you right, how many different goals kickers in a match? Here's a simple table, making the columns line up is no trivial task apparently.
Code:
2006      8  8  7  8  9  6  8  7  13  11  14  9  7  6  7  7  5  6  11  8  8  8
2007      10  8  7  7  9  6  10  8  7  7  9  9  9  9  10  10  9  5  10  8  7  7  9  11  4
2008      9  6  6  12  9  8  12  8  6  8  7  4  11  8  7  5  7  10  7  8  9  12
2009      8  6  13  8  4  7  11  8  7  9  11  6  7  11  10  9  7  9  8  6  8  6
2010      9  7  7  7  4  8  9  10  11  3  6  8  5  6  6  5  5  8  6  6  9  10
2011      6  9  5  8  10  6  9  7  10  8  5  11  9  6  6  8  6  2  5  8  7  10
2012      9  8  7  8  6  6  5  8  11  9  6  5  6  5  6  8  5  7  8  5  10  9
2013      11  11  8  6
I use the TABLE function these days, so much easier to get alignment because spaces are never needed.

Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
\ 2006 | 8 | 8 | 7 | 8 | 9 | 6 | 8 | 7 | 13 | 11 | 14 | 9 | 7 | 6 | 7 | 7 | 5 | 6 | 11 | 8 | 8 | 8 | | |
\ 2007 | 10 | 8 | 7 | 7 | 9 | 6 | 10 | 8 | 7 | 7 | 9 | 9 | 9 | 9 | 10 | 10 | 9 | 5 | 10 | 8 | 7 | 7 | 9 | 11 | 4
\ 2008 | 9 | 6 | 6 | 12 | 9 | 8 | 12 | 8 | 6 | 8 | 7 | 4 | 11 | 8 | 7 | 5 | 7 | 10 | 7 | 8 | 9 | 12 | | |
\ 2009 | 8 | 6 | 13 | 8 | 4 | 7 | 11 | 8 | 7 | 9 | 11 | 6 | 7 | 11 | 10 | 9 | 7 | 9 | 8 | 6 | 8 | 6 | | |
\ 2010 | 9 | 7 | 7 | 7 | 4 | 8 | 9 | 10 | 11 | 3 | 6 | 8 | 5 | 6 | 6 | 5 | 5 | 8 | 6 | 6 | 9 | 10 | | |
\ 2011 | 6 | 9 | 5 | 8 | 10 | 6 | 9 | 7 | 10 | 8 | 5 | 11 | 9 | 6 | 6 | 8 | 6 | 2 | 5 | 8 | 7 | 10 | | |
\ 2012 | 9 | 8 | 7 | 8 | 6 | 6 | 5 | 8 | 11 | 9 | 6 | 5 | 6 | 5 | 6 | 8 | 5 | 7 | 8 | 5 | 10 | 9 | | |
\ 2013 | 11 | 11 | 8 | 6 | | | | | | | | | | | | | | | | | | | | |
 

Chrizzt

Norm Smith Medallist
Aug 17, 2009
7,329
13,991
AFL Club
Port Adelaide
I use the TABLE function these days, so much easier to get alignment because spaces are never needed.
Awesome, thanks guys. Is there an easy way to get and filter this information. I.e. if I wanted information on how many players in each match kicked multiple goals, or if we've had matches where more than 1 person has kicked 5 goals?
 

Ron The Bear

Thank you Chief
Jul 4, 2006
28,703
26,226
Melbourne
AFL Club
Richmond
Port goalkickers

Season|Goals|R1|R2|R3|R4|R5|R6|R7|R8|R9|R10|R11|R12|R13|R14|R15|R16|R17|R18|R19|R20|R21|R22|R23|R24|EF|QF|SF|PF|GF
\2013|5|0|1|0|0|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\|4|1|0|1|1|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\|3|2|1|2|3|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\|2|1|2|2|1|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\|1|7|7|3|1|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\|0|11|11|14|16|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
\2012|7|0|0|0|0|0|0|0|1|0|0|0|0|-|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-
\|5|0|0|0|0|0|0|0|0|0|0|0|0|-|0|0|0|1|0|0|0|0|0|0|-|-|-|-|-|-
\|4|0|1|0|0|2|0|0|0|0|0|0|0|-|0|1|0|0|0|0|1|0|0|1|-|-|-|-|-|-
\|3|0|1|1|0|0|0|0|0|1|2|1|1|-|0|0|2|0|0|1|0|0|1|1|-|-|-|-|-|-
\|2|4|0|3|2|2|2|2|0|4|1|1|1|-|2|0|1|0|1|1|2|1|2|2|-|-|-|-|-|-
\|1|5|6|3|6|2|4|3|7|6|6|4|3|-|4|4|3|7|4|5|5|4|7|5|-|-|-|-|-|-
\|0|13|14|15|14|16|16|17|14|11|13|16|17|-|16|17|16|14|17|15|14|17|12|13|-|-|-|-|-|-
\2011|7|0|0|0|0|0|0|0|0|0|0|0|-|0|0|1|0|0|-|0|0|0|0|0|0|-|-|-|-|-
\|6|0|0|0|0|0|0|0|0|0|0|0|-|0|0|0|0|0|-|0|0|0|1|1|0|-|-|-|-|-
\|4|1|1|0|1|1|1|0|0|0|1|0|-|0|0|0|0|0|-|0|0|0|0|1|1|-|-|-|-|-
\|3|1|1|0|0|0|0|0|0|2|1|1|-|1|1|0|0|2|-|1|0|0|1|1|1|-|-|-|-|-
\|2|1|1|1|3|2|1|1|2|0|0|0|-|0|3|1|2|2|-|3|1|0|0|0|2|-|-|-|-|-
\|1|3|6|4|4|7|4|8|5|8|6|4|-|10|5|4|4|4|-|2|1|5|6|4|6|-|-|-|-|-
\|0|16|13|17|14|12|16|13|15|12|14|17|-|11|13|16|16|14|-|16|20|17|14|15|12|-|-|-|-|-
\2010|7|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|5|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|-|-|-|-|-|-|-
\|4|0|1|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|1|-|-|-|-|-|-|-
\|3|0|1|1|0|0|0|3|1|2|0|0|0|1|0|1|0|1|0|0|0|2|1|-|-|-|-|-|-|-
\|2|4|1|2|3|3|2|2|2|1|0|2|0|1|2|1|2|3|2|2|2|0|3|-|-|-|-|-|-|-
\|1|5|4|4|4|1|5|4|7|8|3|4|8|2|4|3|3|0|5|4|4|6|5|-|-|-|-|-|-|-
\|0|13|15|15|15|18|14|13|12|11|19|16|14|17|16|16|17|17|14|16|16|13|12|-|-|-|-|-|-|-
\2009|7|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|6|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|4|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|1|0|-|-|-|-|-|-|-
\|3|1|0|1|0|0|3|1|0|0|1|1|0|1|2|0|1|1|2|0|0|1|1|-|-|-|-|-|-|-
\|2|2|1|2|4|1|2|5|0|3|0|1|1|4|1|3|6|0|2|3|3|1|1|-|-|-|-|-|-|-
\|1|4|4|9|3|3|2|5|7|4|8|9|5|2|7|7|2|6|4|5|3|5|4|-|-|-|-|-|-|-
\|0|14|16|9|14|18|15|11|14|15|13|11|16|15|11|12|13|15|13|14|16|14|16|-|-|-|-|-|-|-
\2008|7|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|6|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|5|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|1|1|-|-|-|-|-|-|-
\|4|0|1|1|0|2|0|0|1|0|0|0|0|0|0|0|2|2|0|0|0|0|0|-|-|-|-|-|-|-
\|3|1|0|0|0|1|1|2|1|1|1|0|1|0|0|1|1|0|1|1|0|0|3|-|-|-|-|-|-|-
\|2|3|2|2|4|2|2|2|2|1|2|1|1|3|3|1|0|2|2|0|2|5|1|-|-|-|-|-|-|-
\|1|5|3|3|8|4|5|7|4|3|4|6|2|7|5|5|2|3|7|6|6|3|7|-|-|-|-|-|-|-
\|0|13|16|16|10|13|14|10|14|16|14|15|18|11|14|15|17|15|12|15|14|13|10|-|-|-|-|-|-|-
\2007|6|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|1|2|0|0|0|0|0|-|-|-|0|-|0|0
\|5|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|-|-|-|0|-|0|0
\|4|0|0|0|0|0|0|0|1|0|0|1|3|0|1|3|1|1|1|1|0|0|2|-|-|-|0|-|0|0
\|3|4|0|0|1|1|1|1|0|0|1|0|0|1|0|1|1|1|1|0|2|3|1|-|-|-|0|-|3|0
\|2|1|5|1|3|3|2|4|2|1|1|2|1|1|5|1|0|1|0|4|0|3|2|-|-|-|0|-|3|2
\|1|5|2|6|3|5|3|5|5|6|5|6|5|6|3|5|6|4|3|5|6|1|2|-|-|-|9|-|5|2
\|0|12|14|15|15|13|16|12|14|15|15|13|13|13|13|12|12|13|17|12|14|15|15|-|-|-|13|-|11|18
\2006|6|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|4|0|1|1|1|0|0|0|0|1|0|0|0|0|0|0|0|0|1|0|1|0|0|-|-|-|-|-|-|-
\|3|1|0|0|1|0|0|2|1|1|1|2|0|2|0|0|0|0|0|1|0|1|0|-|-|-|-|-|-|-
\|2|3|4|1|1|2|2|1|1|2|4|4|4|1|0|1|1|2|0|1|1|4|1|-|-|-|-|-|-|-
\|1|4|3|5|4|7|4|5|5|9|6|8|5|4|6|6|6|3|5|9|6|3|7|-|-|-|-|-|-|-
\|0|14|14|15|14|13|16|14|15|9|11|8|13|15|16|15|15|17|16|11|14|14|14|-|-|-|-|-|-|-
\2005|7|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|-|-|0|-|0|-|-
\|6|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|0|-|0|-|-
\|5|0|1|0|0|1|0|0|0|1|0|0|0|0|0|1|0|0|0|1|0|0|0|-|-|0|-|0|-|-
\|4|0|0|0|0|0|0|0|0|0|0|0|1|1|0|2|0|1|1|0|0|0|2|-|-|3|-|0|-|-
\|3|0|1|1|0|0|0|0|0|0|0|2|1|0|0|0|1|0|0|1|1|0|1|-|-|1|-|0|-|-
\|2|1|0|1|6|2|2|2|0|2|1|2|1|7|1|2|0|2|3|1|1|2|2|-|-|2|-|0|-|-
\|1|5|3|3|3|6|5|8|6|3|7|6|8|4|7|3|4|6|4|8|7|7|3|-|-|7|-|5|-|-
\|0|16|17|17|13|13|15|11|16|16|14|12|11|9|14|14|17|13|14|11|13|13|14|-|-|9|-|17|-|-
\2004|7|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|0|-|0|0
\|6|2|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|1|0|0|0|-|-|-|0|-|0|0
\|5|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|0|-|0|0
\|4|0|0|2|0|0|1|0|0|0|1|0|1|0|1|1|0|0|0|0|1|0|1|-|-|-|2|-|0|1
\|3|1|1|0|0|0|1|0|0|3|0|1|3|2|1|1|1|0|2|0|1|1|0|-|-|-|2|-|1|2
\|2|1|2|6|3|5|1|1|1|2|2|2|2|3|1|1|3|1|1|2|5|4|2|-|-|-|1|-|2|0
\|1|6|6|6|4|7|5|4|5|6|10|5|3|5|5|3|6|8|3|8|6|5|4|-|-|-|2|-|7|7
\|0|12|12|8|15|10|14|16|16|11|9|14|13|12|14|15|12|12|16|11|9|12|15|-|-|-|15|-|12|12
\2003|7|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|-|-|-|0|0|0|-
\|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|-|-|-|0|0|0|-
\|5|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|1|0|-|-|-|1|0|0|-
\|4|0|0|0|0|0|1|0|1|1|0|0|0|0|0|1|0|1|1|1|0|0|0|-|-|-|0|0|0|-
\|3|0|1|2|2|3|0|1|1|1|3|0|1|1|0|0|0|0|0|1|1|1|2|-|-|-|0|1|0|-
\|2|4|1|0|1|0|1|3|2|2|1|2|4|2|3|1|4|5|3|4|4|1|2|-|-|-|1|2|3|-
\|1|3|5|8|9|3|6|3|4|5|3|5|4|7|4|3|4|1|2|3|6|8|4|-|-|-|6|5|3|-
\|0|15|15|11|10|16|14|15|14|12|15|14|13|12|15|16|13|15|16|13|11|11|14|-|-|-|14|14|16|-
\2002|6|0|0|0|1|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|-|-|-|0|0|0|-
\|5|0|0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|0|-|-|-|0|0|0|-
\|4|0|0|1|0|0|0|0|2|1|0|1|2|0|0|0|0|0|0|0|0|1|0|-|-|-|0|0|1|-
\|3|0|0|2|3|1|2|1|0|0|2|0|0|2|0|0|1|2|1|0|0|0|0|-|-|-|2|1|0|-
\|2|3|2|2|3|2|2|1|2|1|3|0|6|2|4|4|1|3|4|2|3|3|4|-|-|-|1|3|2|-
\|1|5|7|6|2|7|5|6|8|8|5|6|3|4|3|6|5|5|5|3|6|4|5|-|-|-|6|2|4|-
\|0|14|13|11|13|12|12|14|10|12|12|14|11|12|13|12|15|12|12|17|13|14|13|-|-|-|13|16|15|-
\2001|6|0|1|1|0|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|-|-|-|0|0|-|-
\|5|0|0|0|0|1|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|-|-|-|0|0|-|-
\|4|0|1|0|2|1|0|1|1|0|0|0|0|0|1|1|0|1|0|2|0|1|0|-|-|-|0|0|-|-
\|3|2|1|2|1|0|4|2|0|3|3|0|1|0|0|0|1|0|2|1|1|3|3|-|-|-|1|0|-|-
\|2|1|0|2|1|2|1|3|2|0|2|2|1|2|4|3|0|3|4|2|3|3|3|-|-|-|1|2|-|-
\|1|6|3|7|4|4|6|1|3|4|4|6|5|6|7|4|5|5|2|4|5|3|4|-|-|-|3|6|-|-
\|0|13|16|10|14|13|11|15|15|15|13|14|15|14|9|14|16|13|14|13|13|12|11|-|-|-|17|14|-|-
\2000|5|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|-|-|-|-|-|-|-
\|4|0|0|1|0|0|0|0|0|0|0|0|0|0|1|1|0|0|1|0|0|0|2|-|-|-|-|-|-|-
\|3|0|1|0|1|1|2|0|1|0|1|1|2|2|1|0|0|1|1|1|1|2|2|-|-|-|-|-|-|-
\|2|1|2|2|6|1|1|2|2|2|1|0|0|1|1|4|2|0|3|0|1|1|2|-|-|-|-|-|-|-
\|1|6|5|6|3|5|4|9|5|7|5|5|2|4|7|3|3|5|5|4|7|4|2|-|-|-|-|-|-|-
\|0|15|14|13|11|15|15|11|14|13|15|16|18|15|12|14|17|16|11|17|13|15|14|-|-|-|-|-|-|-
\1999|5|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|0|-|-|-
\|4|0|0|0|0|0|0|1|0|0|1|0|0|0|0|0|0|0|0|0|0|1|0|-|-|-|1|-|-|-
\|3|2|2|1|0|1|2|0|1|0|0|0|1|1|0|1|0|2|1|1|0|0|3|-|-|-|0|-|-|-
\|2|0|3|3|1|0|1|1|3|0|3|0|2|0|3|1|4|2|2|3|2|1|0|-|-|-|1|-|-|-
\|1|6|5|6|8|6|4|4|10|7|3|4|4|5|6|9|2|4|2|3|4|7|2|-|-|-|2|-|-|-
\|0|13|12|12|13|15|15|16|8|15|14|18|15|16|13|11|16|14|17|15|16|13|17|-|-|-|18|-|-|-
\1998|8|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|7|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|-|-|-|-|-|-|-
\|5|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|4|2|1|0|0|0|0|0|0|0|0|0|1|0|0|1|0|0|1|0|0|0|0|-|-|-|-|-|-|-
\|3|0|0|1|0|0|0|3|0|0|0|1|1|2|1|1|0|2|0|1|1|1|1|-|-|-|-|-|-|-
\|2|2|1|1|2|0|3|3|0|1|2|1|2|1|3|1|2|3|2|1|1|2|3|-|-|-|-|-|-|-
\|1|5|4|5|7|6|7|2|5|4|5|2|7|3|4|3|8|6|2|5|5|6|3|-|-|-|-|-|-|-
\|0|13|15|15|13|16|12|13|17|16|15|18|11|16|14|16|12|11|17|15|15|12|15|-|-|-|-|-|-|-
\1997|7|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|-|-|-|-|-|-|-
\|5|0|0|1|0|1|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|-|-|-|-|-|-|-
\|4|0|0|1|1|0|1|0|1|1|0|0|0|0|1|0|1|1|0|0|1|0|0|-|-|-|-|-|-|-
\|3|0|0|0|0|0|1|1|0|1|0|1|1|1|1|2|0|0|1|1|0|1|0|-|-|-|-|-|-|-
\|2|4|0|2|2|2|5|1|3|0|4|0|2|2|1|0|4|2|1|2|3|2|4|-|-|-|-|-|-|-
\|1|5|8|5|3|1|2|3|5|3|6|1|2|3|4|3|5|3|6|2|3|1|4|-|-|-|-|-|-|-
\|0|12|13|12|15|17|12|16|12|16|11|19|15|15|14|16|11|14|13|16|14|17|13|-|-|-|-|-|-|-
 

Chrizzt

Norm Smith Medallist
Aug 17, 2009
7,329
13,991
AFL Club
Port Adelaide
I hadn't thought of arranging it the above way Ron. I've made a (rather convoluted) spreadsheet now where I can get info on multiple goalkickers, and info such as how many matches where at least X players kicked at least Y goals, as well as other basic stats of instances of min/max goalkicking efficiency etc. The spreadsheet is a bit over 11 Mb, so I won't upload unless someone particularly wants it. It's currently set up for Port Adelaide stats, but if you have worked with Excel a little before, it wouldn't be hard to convert to other teams.
Thanks for the initial help *Paul* and SJ.
 

Ron The Bear

Thank you Chief
Jul 4, 2006
28,703
26,226
Melbourne
AFL Club
Richmond
I hadn't thought of arranging it the above way Ron. I've made a (rather convoluted) spreadsheet now where I can get info on multiple goalkickers, and info such as how many matches where at least X players kicked at least Y goals, as well as other basic stats of instances of min/max goalkicking efficiency etc. The spreadsheet is a bit over 11 Mb, so I won't upload unless someone particularly wants it. It's currently set up for Port Adelaide stats, but if you have worked with Excel a little before, it wouldn't be hard to convert to other teams.
Thanks for the initial help *Paul* and SJ.
Yep it doesn't lend itself well to two dimensions and is probably suited to an Excel pivot table.
 

35Daicos

Premium Platinum
Mar 6, 2011
6,322
7,274
Adelaide
AFL Club
Collingwood
Other Teams
Collingwood (VFL), Man Utd.
Noticed AllTheStats is still down.

It was down late last week and was said to take 48-72 hours later.

Fast forward to tonight and it's still down for maintenance.
It's up and running again now, I see.
 

(Log in to remove this ad.)

SJ

Moderator
May 22, 2006
33,029
15,936
Melbourne
AFL Club
Geelong
*Paul*

Something's not quite right when sorting by DOB on the 'All time player list' pages. The years sort correctly but then the months are all over the place.
 

*Paul*

Club Legend
Nov 8, 2000
1,221
337
Canberra
Other Teams
Canberra Raiders
Heh, so they are. Didn't change anything, must've always been like that and no one noticed. Anyway, a bit of a tweak, and fingers crossed.

Might try and get the ages to sort properly as well, a bit trickier though.
 
  • Like
Reactions: SJ

The Passenger

Mr. Mojo Risin'
Mar 25, 2003
30,274
16,891
Hasa Diga Eebowai
AFL Club
West Coast
*Paul*

There is something weird on this page with the top 10 lists

http://stats.rleague.com/afl/stats/players/A/Aaron_Rogers.html

I hate being a pain on things like that cause that guy is pretty irrelevant but i also know how meticulous you guys are with your data. And if you're wondering how on earth I ended up on his page it's cause I played against him in juniors and was curious as to how many games he ended up playing
 

*Paul*

Club Legend
Nov 8, 2000
1,221
337
Canberra
Other Teams
Canberra Raiders
It is weird, as other one and two gamers are fine.. usually if something has screwed up it will muck about with everyone. Anyway, I will get on it when time permits.
 

copthat

Premiership Player
Jul 6, 2008
3,095
8,671
AFL Club
Richmond
Anyone know where you can find quarter by quarter stats for individual players?
 

leftboy710

Draftee
Sep 13, 2013
1
0
AFL Club
St Kilda
i saw them somewhere earlierr this year but can't 100% remember where. i think i was reading melbourne's herald sun, but why would they not have that stat on their web-site if they have it in their hard copy newspaper??
 

scotty13

Premiership Player
Feb 4, 2004
3,623
1,879
Melbourne
AFL Club
Port Adelaide
Other Teams
Tracy Vilage Razorbacks
Anyone know where you can get the stats for win% when kicking over 100points in a game.
 

Chrizzt

Norm Smith Medallist
Aug 17, 2009
7,329
13,991
AFL Club
Port Adelaide
Anyone know where you can get the stats for win% when kicking over 100points in a game.
I can't remember the exact number but the winning percentage for the first team to kick 100 points in a game was in the 90s.
This fact makes it all the more humorous that we won the second showdown last year when the Crows were the first to reach 100 :D
 

RogersResults

Premiership Player
May 7, 2009
3,090
1,198
Wagga Wagga
Anyone know where you can get the stats for win% when kicking over 100points in a game.
Here:

All matches 1897-2013: Teams scoring over 100 points (101 onwards) have won 84.6% of the matches.
Figures depend on levels of scoring in any era and percentage of really weak teams in a season - in 1982 they won 68.2% in 1952 they won 95.2%.

1956-1968: They won 93.9%
1982-1994: They won 77.66%
2001-2013: They won 87.5%
2012: They won 93.3%
2013: They won 87.6%
 
Top Bottom