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 Apr 21st 15:20 vs Cat (@MCG) in 2 days.

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.

"Cheat Sheet" Thu Dec 19th, 2024.

- ! = Reset the database (all games).
- Crunch Grouping; 10G, 10G/T, 10G/VS, 10G/Ha
- Crunch Direction; D-, D+, M-, M+, C-, C+
- General; 2024, R5, Mon:, Jul:, 19:40, 25k, <0m4, W, L, D, H, A
- Venue; @mcg, @VIC, @IS
- Shortcut; FINALS, !COVID (2020-1)
- 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

Ladder Columns;
- use curly brackets to reset columns; eg. { T P W L D }
- use + to add a column eg. { +DS }
- traditional; T, P, W, F, A, %, PP
- W%, L%, D%, WR, P%
- C, OF, VN, Y,
- S (Streak), WLD (win-loss-draw), L5 (last 5)
- DS, GS, YS (units since)

- modifiers; + (max), - (min), ! (avg), = (total). eg. C+ for maximum crowd

- column selectors; eg.

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

List of Venues

''ACT''; Manuka
"IS" (Interstate) - venues outside of Victoria.
''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, Barossa Park, 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'' (Overseas); 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:

Welcome to the Hawk Haven