[juyrett]

Thought I might clog up the pages here with some stats I've been gathering and putting up over at BigFooty.

Since 1898, there have been 290 WAFL matches which have been decided by 100 points or more. The first of these was in Round 16 of 1899, when West Perth defeated Perth 15.11 (101) to 0.1 (1), while the most recent was in Round 19 of 2011, when East Fremantle defeated Swan Districts 27.13 (175) to 11.7 (73).

Of the 290 100+ margins, here's the breakdown by team:

Code:

Code

TEAM    WINS   LOSSES   BEST  WORST CL      35      24      194    147 EF      37      14      201    178 EP      32      24      256    169 MJ      0        9      N/A    153 NF      4        1      164    107 P       25      34      153    173 PT      0       42      N/A    195 S       40      52      160    192 SD      31      35      162    164 SF      47      38      195    256 WP      39      17      210    180  Teams: CL - Claremont, EF - East Fremantle, EP - East Perth,  MJ - Midland Junction, NF - North Fremantle, P - Perth,  PT - Peel Thunder, S - Subiaco, SD - Swan Districts, SF - South  Fremantle, WP - West Perth

And here's the decade-by-decade breakdown:

Code:

Code

DECADE  # 1890s   1 1900s   11 1910s   11 1920s   3 1930s   10 1940s   31 1950s   26 1960s   16 1970s   28 1980s   54 1990s   42 2000s   44 2010s   13

And here's the 10 seasons with the most 100-point victories in them:

Code:

Code

YEAR    # 1981    13 1997    13 2010    12 1944    11 2007    9 1979    8 1980    8 2003    8 2005    8 1977    7 1991    7

Here's the highest amount of times each team has won by 100+ points in a season:

Code:

Code

TEAM  #    YEAR C     4    1981, 2010 EF    2    1985, 1986, 2007, 2010 EP    3    1944 NF    2    1905 P     3    1968, 1977 S     5    2007 SD    6    1981 SF    4    1952 WP    3    1941

And here's the same table for losses:

Code:

Code

TEAM  #    YEAR C     5    1958 EF    4    1981 EP    4    1987 MJ    3    1916, 1917 NF    1    1915 P     4    1981 PT    10   1997 S     5    1979 SD    4    1952 SF    9    1944 WP    3    1981

[LeaderBiz]

Other margin facts from WAFL competition (1898-2012):

1) Starting at 1 point, the first margin which has not been achieved in a WAFL match is 137 points.

2) If my Excel skills are up to scratch, the most common margin in WAFL matches is 3 points, which has occurred 197 times.

3) The most common margin over 50 points is 56 points (81 times).

4) There have been 16 instances of exactly 100-point margins. This is the equal-most common margin of 100 points or more. There have also been 16 101-point margins.

5) When the margin gets to 150 points or more, the most common margin is 153 points, which has occurred 4 times.

6) The highest margin which has occurred more than once is 164 points.

[gypearteday]

Here's the 10 lowest scores to win by 100+ or more:

Code:

Code

YEAR    ROUND   TEAM   OPP  G     B      T    MARGIN 1899    16       WP    P    15    11    101    100 1908    11       EF    S    15    23    113    101 1904    5        P     S    15    25    115    107 1909    9        EF    MJ   16    21    117    109 1918    2        EP    S    17    15    117    111 1944    8        EP    SF   17    16    118    103 1905    5        NF    MJ   18    10    118    107 1905    8        NF    S    17    17    119    102 1903    5        NF    S    17    18    120    103 1907    2        WP    S    16    24    120    112

And here's the 10 highest scores to lose by 100+ or more:

Code:

Code

YEAR    ROUND   TEAM   OPP  G     B      T    MARGIN 1979    19       S     SD   20    7     127    -124 1984    10       P     S    15    12    102    -102 1979    21       P     C    14    15    99     -119 1981    13       EF    C    14    11    95     -102 1979    18       EF    EP   13    15    93     -103 1985    7        EP    SF   15    3     93     -129 1991    19       SF    C    14    8     92     -102 1980    13       S     C    12    16    88     -106 1981    2        P     SD   13    9     87     -162 1991    14       SF    S    13    9     87     -101

And here's the 10 matches with the highest margins in WAFL history:

Code:

Code

YEAR    Rd   TEAM   OPP   G     B     T    MARGIN 1944    1     EP    SF    41    30    276    256 1944    1     SF    EP    3     2     20  1987    10    WP    SF    37    17    239    210 1987    10    SF    WP    4     5     29  1944    17    EF    SF    33    23    221    201 1944    17    SF    EF    2     8     20  1999    3     SF    PT    33    21    219    195 1999    3     PT    SF    3     6     24  2010    10    C     PT    38    12    240    194 2010    10    PT    C     7     4     46  1953    16    SF    S     35    18    228    192 1953    16    S     SF    5     6     36  1981    21    SF    WP    40    18    258    180 1981    21    WP    SF    12    6     78  1981    10    WP    EF    37    17    239    178 1981    10    EF    WP    9     7     61  2003    17    C     PT    30    17    197    177 2003    17    PT     C    3     2     20  1981    17    C     P     39    20    254    173 1981    17    P     C     12    9     81

[TornadoPD]

As a fellow statistician, may I commend you on your great analysis of WAFL records, UpForGrabs.
I have an (almost) up-to-date Excel spreadsheet on East Perth's WAFL history, including records versus each opposing team, but it's not in the same league (excuse the pun) as your research.

[Qeiafib]

Fitzy, you have a rival

good work UFG....

[viagra-kaufen]

Great stuff UFG

[brorwargy]

great work UFG would have thought swans would have more 100pt losses over the years but only 35 in 78 years equates to just over one every 2 years however you could probably add our forrunner Midland junction 9 into the 35 loses

[addifttiest]

One thing I found is that despite all their wooden spoons, Swan Districts have only had 9 games out of their 1629 (to date) where they've scored below 30 points, and they've never scored below 20 in a game.

[Luisabens]

As a fellow statistician, may I commend you on your great analysis of WAFL records, UpForGrabs.
I have an (almost) up-to-date Excel spreadsheet on East Perth's WAFL history, including records versus each opposing team, but it's not in the same league (excuse the pun) as your research.

It's a damn time consuming job, isn't it!

Shoot me a PM if there's anything you think I could help you with. If I've got it handy, it's yours... Although I suspect there won't be anything I have that you don't in relation to the mighty Royals!

[cokLoolioli]

Fitzy, you have a rival

good work UFG....

I think UFG has my stats well and truly covered, Gas.
I can thank WAFL statistician Steve Davies for forwarding me an Excel file of all EP games 8-9 years ago.
I'd hate to type in our 2156 games (1167 wins 973 losses 16 draws) manually.

[Auzuigcx]

It's a damn time consuming job, isn't it!

Shoot me a PM if there's anything you think I could help you with. If I've got it handy, it's yours... Although I suspect there won't be anything I have that you don't in relation to the mighty Royals!

Very time consuming, UFG, particularly at the snail-like speed I type.
Thanks for your kind offer of help.
I'd love to get quarter-by-quarter scores and goalkickers, but doubt that data is available for all WAFL games.
Send me a PM if you want a copy of my EP file (only updated to the end of 2010 at present).

[Eunatis]

Very time consuming, UFG, particularly at the snail-like speed I type.
Thanks for your kind offer of help.
I'd love to get quarter-by-quarter scores and goalkickers, but doubt that data is available for all WAFL games.
Send me a PM if you want a copy of my EP file (only updated to the end of 2010 at present).

I guess I'm lucky that I'm a fast typist.

I started a spreadsheet a while back which had home team scores followed by away team scores in the same row before I realised that one row for each team was the best way to go, the only thing is that I'm no excel expert so I had to re-type everything again.

Painful.

[Klavalala]

UFG is it possible to tell me how many wooden spoons have each club has won?

[FsQGF1Mp]

UFG is it possible to tell me how many wooden spoons have each club has won?

.........NO!!!

[yazetaw]

UFG is it possible to tell me how many wooden spoons have each club has won?

Sure thing. Here's each club with the amount of wooden spoons they've 'won', the year of their first, and the year of their most recent (from 1898 to the present):

Code:

Code

TEAM    W/S   1st     LAST   CL      14    1926    1975 EF       3    1898    2006 EP       7    1911    2008 MJ       3    1909    1917 NF       2    1914    1915 P       15    1899    2010 PT       7    1997    2011 S       22    1901    1996 SD      19    1940    2002 SF      12    1904    1987  WP      10    1918    1992

And here's the same table for Minor Premierships:

Code:

Code

TEAM    M/P   1st     LAST   CL      17    1937    2011 EF      33    1900    1998 EP      19    1918    2002 F        1    1898    1898 MJ       0     N/A     N/A NF       0     N/A     N/A P        7    1949    1978 PT       0     N/A     N/A S       12    1912    2008 SD       4    1962    1984 SF      12    1906    2009  WP       9    1899    1993

Most wooden spoons won in a row is four by Subiaco (1905-08) and Claremont (1931-34)

Most minor premierships won in a row is seven by East Fremantle (1928-34)

[gtyruzzel]

Well done UFG, brilliant.

[Cabinanteerip]

thanks UFG was just going through records on this site & countng by pen. I was amazed by how little East Freo had visited the bottom of the table but not only that they had won 26 premierships as well in 114 years; bottom of table once every every 38 years isn't bad when you compare that ratio with swans just over 1 in 4yrs or subiaco 1 in 5 & swans have well & truly been around the bottom of the table more times then i would like to think. I don't count Peel's ratio yet as they have yet to have a chance to build a history. East Perth & West Perth haven't been to shabby in staying away from the bottom either.

[AlexBolduin]

As much as I'd hate to admit it, East Freo's record of 106 years between wooden spoons (1898-2004) is pretty damn remarkable.

[OEMCHEAPSOFTDOWNLOAD]

10 highest margins in WAFL finals history

Code:

Code

YEAR         TEAM   G     B     T     MARGIN 1959    1SF   S     26    23    179    129               P     7     8     50 1978    PF    EP    27    15    177    112               SF    9     11    65 1975    GF    WP    23    17    155    104               SF    7     9     51 2007    PF    S     25    14    164    95               SF    10    9     69 1992    QF    SF    22    19    151    92               SD    8     11    59 1928    1SF   EP    20    18    138    88               SF    8     2     50 1991    1SF   SD    23    13    151    88               P     9     9     63 1957    2SF   EP    20    16    136    86               P     7     8     50 2006    1SF   C     21    18    144    86               WP    8     10    58 1992    EF    EP    24    13    157    85               S     10    12    72 2011    1SF   S     24    18    162    85               SF    12    5     77 2011    2SF   C     23    13    151    85               WP    10    6     66

[WertyNtont]

Sure thing. Here's each club with the amount of wooden spoons they've 'won', the year of their first, and the year of their most recent (from 1898 to the present):

Code:

Code

TEAM    W/S   1st     LAST   CL      14    1926    1975 EF       3    1898    2006 EP       7    1911    2008 MJ       3    1909    1917 NF       2    1914    1915 P       15    1899    2010 PT       7    1997    2011 S       22    1901    1996 SD      19    1940    2002 SF      12    1904    1987  WP      10    1918    1992

And here's the same table for Minor Premierships:

Code:

Code

TEAM    M/P   1st     LAST   CL      17    1937    2011 EF      33    1900    1998 EP      19    1918    2002 F        1    1898    1898 MJ       0     N/A     N/A NF       0     N/A     N/A P        7    1949    1978 PT       0     N/A     N/A S       12    1912    2008 SD       4    1962    1984 SF      12    1906    2009  WP       9    1899    1993

Most wooden spoons won in a row is four by Subiaco (1905-08) and Claremont (1931-34)

Most minor premierships won in a row is seven by East Fremantle (1928-34)

You just had to go & do it didnt you