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 20th 19:30 vs Blu (@MCG) in 1 day.

Haven Crunch (Myrtle v3.01)

"Update" Fri Jan 17th, 2025.

Lots of bug fixes. Still too many to list. But generally the crunches seem to be working.

Crunches (v0.65);
- added ladder columns; L5, S, and %2 (SA percentages).
- option for simple add column. eg. ''{+DS}'' to add 'Days Since'.
- can now add opponents and venues to column list. eg. Haw/C.

Myrtle GUI (v3.01);
- fixed sorting of null column values.
- hold alt button and click a column for simple bar graph.
- added option to save current screen as .png.
- finally worked out to hide the offscreen canvas!

To Do List;
- column headers need to be constrained inside max column width.
- fix save and load button.
- general aesthetics of tables and graphs.
- add description of column data to make tables more readable.
- add user colour options.
- more column selectors (only have team and venues at the moment).
- fix margin parameters (not working properly).
- column sorting for non-number (text) data.

"User Guide v0.72" Thu Dec 19th, 2024.

- ! = Reset the database (all games).
- Click a column to resort it. Click again to reverse the order.
- Click a team to get more details of the games involved.

1. Crunch Grouping (default is all games)

- 10G = 10 games for any team vs any opponent.
- 10G/T = 10 games for each team vs any opponent.
- 10G/VS = 10 games for each team vs each opponent.
- 10G/HA = 10 home and 10 away games for each team vs each opponent.
- D- = by Date backwards (default). D+ = by Date forwards.
- M- = by Margin backwards. M+ = by Margin forwards.
- C- = by Crowd backwards. C+ = by Crowd forwards.

2. General Parameters

- Season; eg. 2024, 2000-2001, <2010
- Rounds; eg. R5, R1-10, R<20
- Days of week (must have colon ':'); Mon: Fri:Tue
- Months of year (must have colon ':'); Jul:, Mar:May (must have colon ':')
- Game Time (must have colon ':'); eg. 19:30, 15:30-16:30, <14:00
- Crowd; eg. 10k, 20-40k, >80k
- Margins (margin-'m'-quarter); eg. 0m1, -1m2, -6-6m3, >50m4
- Result; eg. W, L, D
- H/A; eg. H, A
- Venue; eg. @mcg, @VIC, @IS (interstate), @OS (overseas)
- Shortcuts; !COVID (not 2020-21), FINALS, !FINALS

3. VS Parameters (separated by 'vs' into team and opponents);

- Teams vs Opponents; eg. Haw vs VIC
- Ladder finish; eg. 1-8th vs >8th
- Breaks; eg. 6d vs >7d
- HS (home state) / IS (interstate); eg. IS vs HS

4.1 Ladder Columns;

- you can add a column to the existing table; eg. '{ +DS }'
- or completely reset the columns; eg. '{ T P W L D }'

- T = team
- P = played
- W = won, L = lost, D = drawn
- PF, PA = point for or against.
- % = percentage (PF/FA * 100)
- PP = premiership points.

- C = crowd
- OF = opposition ladder finish
- WR = win ratio (takes into account draws)
- S = streak. eg. W3, L2
- WLD = wins-losses-draws
- L5 = result of last five games (can be any number); eg. W-W-L-D-W

- VN = venue
- Y = year

- DS = days since
- GS = games since
- YS = years since

4.2 Ladder modifiers (doesn't work on all columns);

eg. 'C' = default value (for crowds this is the average)
eg. 'C+' = maximum crowd
eg. 'C-' = minimum crowd
eg. 'C=' = total crowd
eg. 'C%' = average crowd
eg. 'C!' = % of played (not relevant for crowds).

4.3 Ladder Selectors;

You can narrow the selection for each column;

eg. '{ + vs Haw / C }' = average crowd for games vs Hawthorn
eg. '{ + <15k / W }' = number of wins when crowds below 15,000.

5. List of Venues

- Venues are listed by the first three letters of the venue's name.
- Shortcuts; ''ACT'', ''NSW'', ''NT'', ''QLD'', ''SA'', ''TAS'', ''VIC'', ''WA'', ''IS'' (interstate), and ''OS'' (overseas)

''ACT''; Manuka
''NSW''; Blacktown Oval, SCG, Stadium Australia, Sydney Showgrounds
'''NT''; Mararra Oval (Darwin), Traeger Park (Aice Springs)
''QLD''; Carrara (Gold Coast), Cazalys Stadium (Cairns), The Gabba, Riverside Oval (Townsville)
''SA''; Adelaide Oval, Football Park, MtBarker, Norwood Oval
''TAS''; Bellerive Oval (Hobart), York Park (Launceston)
''VIC''; Docklands, Eureka Stadium (Ballarat), Kardinia Park (Geelong), MCG, Princes Park
''WA''; Perth Stadium, Subiaco, The WACA
''OS''; Jiangth Stadium (China), Wellington (NZ)

"Database API" Tue Dec 10th, 2024.

Working on the AJAX interface so that we can Crunch the Database on the fly.

"Getting There" Fri Dec 6th, 2024.

Database going well. Just ironing out some kinks.

Started on the GUI. Converting the JAVA to Javascript. Which is a bigger task than I was expecting!

"And We're Back." Mon Dec 2nd, 2024.

To do list;
- Re-build the database into MariaDB. Starting with 2000-2024.
- Rewrite the GUI from Android Java to HTML Canvas / Javascript.
- Make an AJAX interface.

Menu:

Crunches:

Contact:

Links: