Menu:

Home Articles Custom Crunch
 

Crunches:

History Of HawthornUser Guide
 

Contact:

Email Me
 

Links:

AFL Tables

Welcome to the Hawk Haven

The aim of the Haven is to keep you up to date on all things AFL / Hawthorn from a statistical perspective.

The SQL database has over 4,500 games, stretching all the way back to the 2000 season.

 "Update"  Thu Sep 12th, 2024.
Version 1.05
- added %2 (SANFL type percentages).
- added margins eg. -6,6m3 for plus or minus a goal at 3QT.
- fixed a HUGE list of bugs.
 "Stable Tables"  Wed Aug 28th, 2024.
It all seems a lot more stable now.

Text input for custom crunches seems to be working.

Added selection of tables;
- Fixture
- Finals
- Season
- Streaks
- Utopia Ladder

 "Bug Fixes"  Sun Aug 25th, 2024.
So many bugs squashed. Sigh.
 "Columns"  Fri Aug 23rd, 2024.
Tidied up how the columns work. Added scope and a modifier to the data.

The scope precedes the column and is separated by a forward slash.

The modifier (+, -, or =) comes after the column.

 "Some Progress"  Tue Aug 20th, 2024.
A lot of bug fixes!

Also added a text box input to allow custom database crunches. It's a little clunky - but should get better with time.

 "Our First Crunch"  Thu Aug 15th, 2024.
Testing everything out with our first table. Columns are sortable (click the heading) and you can bring up the last 25 games by clicking on any of the teams. At the bottom is the column averages (hover for totals).

Simple 2024 Ladder:
#TeamTeamPPlayedWGames WonLGames LostDGames DrawnPFAverage Points ForPAAverage Points AgainstPPPremiership Pts%PercentageOFAverage Opponent FinishL5Last 5 W/L
1Swa24186097.177.172125.9%9.5L-W-W-W-W
2Cat24168095.982.664116.1%9.8W-W-L-W-W
3Pow24168086.078.864109.3%10.4W-W-W-W-L
4Lio24158192.975.862122.6%10.0W-L-L-W-W
5Haw24159091.276.060119.9%9.8L-W-W-W-W
6Gia24159088.281.360108.4%8.7W-W-W-L-L
7Bul241410093.076.556121.7%9.2W-L-W-W-L
8Blu241311092.685.552108.3%9.2L-L-W-L-L
9Mag23129286.684.552102.5%9.0W-W-L-W-W
10Doc231210185.476.350111.9%9.5W-L-L-L-L
11Bom231111182.388.04693.5%9.8L-W-L-L-L
12Sai231112076.076.44499.4%9.3W-L-W-W-W
13Sun231112083.784.54499.1%10.0L-L-W-L-W
14Dem231112077.678.84498.5%8.9L-L-L-W-L
15Cro23814182.983.63499.1%8.0L-L-W-L-L
16Eag23518069.3101.72068.1%10.1L-W-W-L-L
17Kan23320070.4110.91263.5%9.0L-W-L-L-L
18Tig23221065.4102.8863.7%8.9L-L-L-L-L
  23.442211.620811.62080.3684.21,516.484.51,520.946.9844101.81831.69.4169.2 
 
 "We're back"  Sun Aug 11th, 2024.
Ok. It's taken a while - but I've copied the Database across to the new domain and repaired (most of) it. Getting my head around MariaDB - which seems pretty awesome. And converting the old code into PHP/Javascript.

At the moment the database only goes back to 2000.