Resource - AFL Player Contracts & Statistics - Live Spreadsheet | BigFooty

Resource AFL Player Contracts & Statistics - Live Spreadsheet

Discussion in 'Drafts, Trading & Free Agency' started by Lore, Oct 15, 2018.

  1. Lore

    Lore Moderator

    Essendon
    Joined:
    Dec 15
    Posts:
    11,745
    Tayl0r and I have been working on this for a while now; a user-friendly, auto-updating contract and stats spreadsheet.

    In the first tab you will find a list of all players who are out of contract this year and next year, along with their free agency status.

    The next four tabs are graphical displays of league-wide contract length, career games, and player age and height data. Who is the tallest player in the league? Who has the longest contract? The answers to these types of questions are in these tabs.

    The last tab is a look up table of collated source data.

     

    (Log in to remove this ad.)

  2. Tayl0r

    Tayl0r Moderator

    Fremantle
    Joined:
    Jul 09
    Posts:
    33,197
    Location:
    Perth
    This information is also broken down into individual team sheets for each board to use to track their player contracts.

    As an example:

     
  3. exile

    exile Moderator

    Gold Coast
    Joined:
    Jul 10
    Posts:
    6,145
    Location:
    Gold Coast
    great stuff! out of curiosity, how have you sourced the contract length info?

    could we get a tab for player weight so we can see who the biggest units are in the league? :$
     
    Lore likes this.
  4. Lore

    Lore Moderator

    Essendon
    Joined:
    Dec 15
    Posts:
    11,745
    Footywire. And we probably could add a weight tab, assuming the spreadsheet doesn't break again <_<
     
    exile likes this.
  5. Orange Agent

    Orange Agent Premiership Player

    GWS
    Joined:
    Oct 16
    Posts:
    3,012
    Footywire is not 100% accurate. For example Heath Shaw is contracted till end of 2019.
     
  6. Lore

    Lore Moderator

    Essendon
    Joined:
    Dec 15
    Posts:
    11,745
    Yep. I think they’ve taken Barlow(?) off the books as well when he’s actually playing on.

    If there’s a better source for the data that will work into a spreadsheet I’m happy to try something else, but if it becomes labour intensive we'll just stick with what we have.
     
  7. inbetween

    inbetween All Australian

    West Coast
    Joined:
    Aug 10
    Posts:
    973
    Other Teams:
    Vikings
    Cool work. One thing I don't understand is the Free Agency Status column.
    Take the Freo team contract sheet for example. How can Nat Fyfe possibly be considered a Free Agent when he's contracted up until 2023. or Michael Walters for that matter.

    There's a whole bunch of players who have Free agency Status listed for 2020 and beyond when that's technically impossible if they are contracted.
     
  8. Lore

    Lore Moderator

    Essendon
    Joined:
    Dec 15
    Posts:
    11,745
    The status column is what their free agency status will be when they’re next out of contract.

    If you’re viewing on a mobile make sure you scroll to the right
     
  9. RussellEbertHandball

    RussellEbertHandball Premium Platinum

    Port Adelaide
    Joined:
    Nov 04
    Posts:
    51,297
    Location:
    SE Oz
    Other Teams:
    The Mighty Blacks
    Great stuff Lore and Tayl0r . I hope you guys can write programs that dump info direct from sites like afltables.com rather than manually have to type up everything.
     
  10. Tayl0r

    Tayl0r Moderator

    Fremantle
    Joined:
    Jul 09
    Posts:
    33,197
    Location:
    Perth
    Lore is a wizz at that stuff. She is an underappreciated asset to bigfooty.
     
    RussellEbertHandball likes this.
  11. Suma Magic

    Suma Magic Brownlow Medallist

    West Coast
    Joined:
    Aug 09
    Posts:
    20,926
    Hi Lore and Tayl0r

    I was thinking it would be interesting to work out the points values of all lists. But it could be time consuming as some players aren't straight forward. I was thinking of just basing it on:
    - where you are taken in the draft
    - the net draft pick given up for a player in a trade
    - the point at which the player was bid on in the draft

    I'd be happy to do West Coast if others were willing to do other clubs. In addition to the total points some graphs of the points spread of all lists could be interesting.
     

    (Log in to remove this ad.)

  12. Tayl0r

    Tayl0r Moderator

    Fremantle
    Joined:
    Jul 09
    Posts:
    33,197
    Location:
    Perth
    I've thought about that before, charting the average draft pick of the team across years.

    Working towards a hypothesis that lower pick average could rest in higher performance, but it gets tricky because rookie picks would need to be on the number taken in the entire draft, not including skips. Or at least a uniform standard.

    When I thought of this it was also to see how clubs were at pumping games into their picks, to see how each has gone with their selections (probably broken down into half round segments). Once the draft pick is in the database it's a world of opportunity, especially when I can also add in the games played year on year.

    Having historical data on all draft picks likely to play, success rate, what determines success etc would be handy but I'd need a slightly higher pay rate to commit to it.

    I think the data is out there though.

    I dream of being able to click a team, see their players and where they were taken, see which are performing above or below average for that team on games played or another stat metric we could use, and then compared against the league averages.

    Ultimately it would be nice to see how successful teams chart over years prior to their success and if there is a correlation between successful teams in terms of chart shape.

    It would be a handy tipping tool.
     
  13. Tayl0r

    Tayl0r Moderator

    Fremantle
    Joined:
    Jul 09
    Posts:
    33,197
    Location:
    Perth
    Even broken down into player heights, height by weight, even things like beep test results etc

    See if there are correlations to success off that data.

    Perhaps to the point where you could say:
    Player A, 186cm, 80kg, averaging x possessions and y contested possessions in competition Z and a beep test result of N means you are likely to get 100 games out of him. Etc

    I actually think the endurance tests are not going to be as relevant for the middle range talent but would be more indicative of being able to play games early.

    It's more about tall skinny guys playing lots of games etc
     
  14. Suma Magic

    Suma Magic Brownlow Medallist

    West Coast
    Joined:
    Aug 09
    Posts:
    20,926
    It would be pretty interesting to have original draft position and trade value for each player as a strarting point. I suppose it would just require people doing a team each as it would have to be manual for it to be accurate. I'd be happy to do West Coast and provide the template, which would be pretty simple, just a link to points values etc.
     
  15. Tayl0r

    Tayl0r Moderator

    Fremantle
    Joined:
    Jul 09
    Posts:
    33,197
    Location:
    Perth
    I wouldn't link it to the value of points without showing the working - just in case the points value changes down the road and makes the entire data batch invalid.
     
  16. Suma Magic

    Suma Magic Brownlow Medallist

    West Coast
    Joined:
    Aug 09
    Posts:
    20,926
    Yeah I was just thinking columns for pick used (or picks in/out for trades) with a vlookup to the points system.
     
Back To Top

Share This Page