Menu:

Home Articles Custom Crunch
 

Crunches:

Utopia Ladder
 

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.

Next game Mar 7th 19:40 vs Swa (@SCG) in 84 days.

 "Placeholder"  Tue Dec 10th, 2024.
placed
 "Place Holder"  Fri Dec 6th, 2024.
Placing
 "Placeholder"  Mon Dec 2nd, 2024.
Placeholder
 "Placeholder"  Fri Nov 29th, 2024.
Placeholder
 "Utopia Crunch"  Wed Nov 27th, 2024.
I thought the first table I should put an effort into resurrecting was the "Utopia" Ladder.

It imagines a perfect season - where each team plays every other team twice; home and away. The crunch searches back through the last few seasons to find all the games it needs to construct the ladder.

Of course it's a dream - you can't have a 34 round season. But you can see what it would look like using the link in the menu to the left.

 "Updates"  Tue Nov 26th, 2024.
Version 1.05
- squashed a HUGE list of bugs.
- added %2 (SANFL type percentages).
- added margins eg. -6,6m3 for plus or minus a goal at 3QT.
- added selection of tables to custom crunches.
- added scope and modifiers to columns. eg. "/+".
- added reverse sorting to columns (click second time).
 "First Try"  Mon Nov 25th, 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
1Swa26197095.678.176122.4%9.1W-W-W-W-L
2Lio27188194.476.474123.6%9.2W-W-W-W-W
3Pow26179084.679.168106.9%9.9W-W-L-W-L
4Cat25169095.583.164114.9%9.6W-L-W-W-L
5Haw251510090.476.060119.0%9.5W-W-W-W-L
6Gia251510088.682.360107.7%8.5W-W-L-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
  24.043211.821311.82130.3684.11,514.384.71,524.348.0864101.31823.89.3166.8 
 
 "And We're Back"  Sun Nov 24th, 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.