ORFFA Team Lists

Discussion in 'ORFFA' started by Len, Aug 12, 2017.

  1. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Lists below accurate to end of season 2021

     
    Last edited: Sep 24, 2021
    • Like Like x 3
  2. graeme

    graeme Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    4,046
    Likes Received:
    2,802
    g'day Len,
    Openly admit not a techie. Is there a way that I can sort the player list by club other than exporting to excel and manipulating?
     
  3. That KI Guy

    That KI Guy Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    2,704
    Likes Received:
    4,356
    Hey mate, i'm no tech head either but it seems reasonably easy to play with from a PC.
    If you want to sort by ORFFA club go to the top cell in column "C" you'll find a drop down menu on the RHS. Click on sort sheet A-Z.
    If sorting by AFL club then same applies for column "F".
     
    • Like Like x 1
  4. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    You, JC and CR have edit privileges and so those actions are available to you, unfortunately I can't open it to everyone as it quickly becomes a dog's breakfast..
    Please be aware that any action, sorting, filtering or editing changes the view for all users not just yourself.

    @graeme best way to play with it is to download it, or copy and paste it into an open spreadsheet that you control, this is what I do when I want to dig into or add to the data for personal research
     
    • Like Like x 2
  5. graeme

    graeme Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    4,046
    Likes Received:
    2,802
    Thanks Jelly Guy and Len. I had seen the list sorted by teams and it all makes sense now.
     
    • Like Like x 1
  6. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Lists now correct to date, draftees included.
    I've left the culled players on bottom of the list until I am confident there are no errors.
     
    • Like Like x 1
  7. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    When will the new recruits be added with their UID numbers oh draft master ;)

    Shout out if you need a hand, I'm happy to assist as it means my all singing and dancing draft spreadsheet comes together faster :)
     
    Last edited: Feb 1, 2018
  8. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    I'll get it done tonight mate, I have to do the other one anyway :)
     
    • Like Like x 1
  9. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Now updated, all players should also now have correct 2018 positions listed
     
    • Like Like x 4
  10. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    Thanks boss
     
  11. ChiefRussell

    ChiefRussell Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    788
    Likes Received:
    855
    Hey mate, just thought I would let you know that according to your list, the trade of Liam Shiels and PSD pick 43 (between the Devils and the Chooks) is not reflected in the team lists and draft picks tabs. I know you will get around to this, sir.
     
    • Like Like x 2
  12. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Cheers mate will fix it now, guys if you notice I haven't "liked" your trade post within 24 hours or so hit me up, I missed this one in the whole mega trade chat somehow :)

    Just to add, I don't actually like all the trades, I use the "like" button as my way of knowing I've seen it :p
     
    • Like Like x 4
  13. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    [​IMG]
     
    • Like Like x 3
  14. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    Need to boot Jarrod Pickett out of my team in the list above mate :)
     
  15. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Can you link me? I can't find a post other than in your thread?
     
  16. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    MY bad, thought I had him in the delistments... added
     
  17. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    dude is SO cut ;)
     
    • Like Like x 1
  18. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,495
    Likes Received:
    3,193
    He’s outta here!
     
    • Like Like x 1
  19. graeme

    graeme Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    4,046
    Likes Received:
    2,802
    Huge job tracking all the trades Len. Fitzy's get of Dan Menzel is recorded but his out of pick 53 in the PSD to me is noted but not recorded. oty
     
    • Like Like x 1
  20. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,563
    Likes Received:
    5,985
    Definitely there mate
     
    • Like Like x 1

Share This Page