Wellington Phoenix Men

2011/12 A-League Spreadsheet

11 replies · 398 views
over 14 years ago · edited over 13 years ago
2011/12 A-League Spreadsheet
Permalink Permalink
over 14 years ago · edited over 13 years ago
Given the later start to the season, the sheet is relatively early this season, but it is now available at http://www.michaelwray.co.nz/sheets.html
A couple of new features for this season:
- a pedigree chart (select the team and see their finishing history since season 1)
- records page (select the team and see their records for best win, longest winning streaks, performances by venue)
 
And the usual features:
- Fixtures and tables using methodology relevant, including the head-to-head tie-breaker logic
- Playoffs
- Colour-coded results and fixture grids
- Chart of points accumulation during season
- Chart of league positions during season
- Club statistics on season results
- Division statistics on season results
- Strength of opposition table for both remaining games and played games
- Points deductions (hopefully not needed)
- Prediction engine, dynamically calculated from current form and past meetings between clubs
- The ability to enter your own predictions and see resulting table 
- Head-to-head league results for all-time
Help yourselves.
 
And thank Piney for getting me pick up the A-League in the first place!
Permalink Permalink
over 14 years ago · edited over 13 years ago
Bravo. Magnificent as always.
Permalink Permalink
over 14 years ago · edited over 13 years ago
Thanks! Your sheet last season was very useful!

Yellow Fever - Misery loves company

Permalink Permalink
over 14 years ago · edited over 13 years ago
Gutted that you can't offer these anymore, I hadn't downloaded this seasons spreadsheet yet
Permalink Permalink
over 14 years ago · edited over 13 years ago
No problem Patrick.
 
At this point, it's the English League sheets that DataCo have served notice against for containing fixtures. DataCo also act as agents for UEFA, so I was half expecting the Champions League and Euro Champs sheets to pick up a notice - although, I don't know if UEFA are one of bodies to copyright the dates of unplayed matches.
 
The emails I've received contain tales of DataCo shutting down discussion forum because a user posted a team's fixtures. It's a crazy world when it is illegal to quote fixtures without buying a licence first.
 
I'm going to look into workaround options, but the notice has come at a very busy time so I had to play it safe and suspend all sheets until I get this worked out.
Permalink Permalink
over 14 years ago · edited over 13 years ago
Thanks
S.O.N2011-10-25 19:31:52
Permalink Permalink
over 14 years ago · edited over 13 years ago
The Gold Coast - Adelaide games this season have changed since the A-League sheet went up, with Adelaide having two home games instead of one (Gold Coast vice versa). Due to the way I have so far handled the multiple meeting, the sheet needed updating in order to recognise the change. Must look at making that changeable by the user next season. For now, I've updated the version on-line so you're not frustrated by having the current season sheet not be right: http://www.michaelwray.co.nz/A-League-1112.zip
 
I haven't yet taken the site out of its semi-slumbered state (due to not having had time to look at the sheet design to comply with DataCo's requirements). Hopefully, I can spend some time on that when work shuts down for the holidays.
Permalink Permalink
over 14 years ago · edited over 13 years ago
SiNZ wrote:


The Gold Coast - Adelaide games this season have changed since the A-League sheet went up, with Adelaide having two home games instead of one (Gold Coast vice versa). Due to the way I have so far handled the multiple meeting, the sheet needed updating in order to recognise the change. Must look at making that changeable by the user next season. For now, I've updated the version on-line so you're not frustrated by having the current season sheet not be right: http://www.michaelwray.co.nz/A-League-1112.zip
�
I haven't yet taken the site out of its semi-slumbered state (due to not having had time to look at the sheet design to comply with DataCo's requirements). Hopefully, I can spend some time on that when work shuts down for the holidays.


Thanks for that, hoping you can update it again when a date for the postponed Sydney Perth game is set

Yellow Fever - Misery loves company

Permalink Permalink
over 14 years ago · edited over 13 years ago
Patrick, you can change match dates yourself (see the button on the Enter Result tab) without any version update needed. The Adelaide-GCU scenario was a second home match that wasn't defined to accept a date as the original fixtures had GCU hosting twice.
Permalink Permalink