ORFFA Team Lists

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

  1. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    Probably 48 hours away if waiting on me, I'm working on it but it's slow unf
    Not sure if anyone has tracked the pick trades but if so I'd appreciate the cliff notes so when I am done with the 2025 lists I can cruise through that bit.
    Not having the site updated is a serious PITA
    At some point we may need to discuss a small fee to enable us to move to an app like Keeper, whilst retaining ts for dialogue..
     
    • Like Like x 4
  2. chris88

    chris88 1000 Monkeys at 1000 Typewriters Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,431
    Likes Received:
    1,815
    Thanks Len.
     
  3. anthak

    anthak Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,489
    Likes Received:
    5,293
    If it hasn’t been done yet, I should be able to tally up the pick trades later tonight
     
    • Like Like x 1
  4. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    That would be awesome mate, thanks
     
    • Like Like x 1
  5. anthak

    anthak Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,489
    Likes Received:
    5,293
    Here you go mate:


    2024 mid season
    1* Nuffers trade our 2025 PSD third round pick for the Spelunkers first round pick in the current MSD.

    2* Gariwerd Cockatoos receive Cradle Mountain’s 2025 PSD 1st round pick and Jake Bowey.
    Cradle Mountain receive Rory Laird and Gariwerd Cockatoos' 2025 PSD 4th round pick.

    2025 pre season
    3* Dunsborough Dung Beetles trade Jake Rogers to the Gundagai Grass Hoppers for Marcus Windhager.
    Dungbeetles also send their 4th Round pick to Gundagai in exchange for their 5th.

    4* The Spelunkers are sending their first round PSD pick (I think it is 14) and their 3rd round PSD pick to @Fitzy (http://tooserious.net/forum/members/20619/) in exchange for J
    esse Hogan and Venus Bay's 3rd round PSD pick

    5* The Spelunkers send Trent Rivers and their fourth round PSD pick (62?) to the Cows for Brad Close and their third round PSD pick (43?).


    So overall so far:
    Nuffers
    Out: R3 to COP.
    In: none

    Spelunkers
    Out: R1 to VBV; R3 to VBV; R4 to WKI.
    In: NUFF R3; VBV R3; WKI R3.

    Incorrigibles
    Out: R3 to COP.
    In: COP R4.

    Vultures
    Out: R3 to COP.
    In: COP R1; COP R3.

    Cockies
    Out: R4 to CMD.
    In: CMD R1.

    Devils
    Out: R1 to GWC.
    In: GWC R4.

    Dungbeetles
    Out: R4 to GGH.
    In: GGH R5.

    Grasshoppers
    Out: R5 to DDB.
    In: DDB R4.
     
    • Like Like x 3
  6. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    Thank you very very much :)
    I'll come back and update lists and draft order, but have now uploaded to the OP here what I hope is a correct starting point for 2025, pre trade impacts.
     
    • Like Like x 1
  7. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    Ok, I believe I have all the trades updated in the sheet in the OP on this thread, If you've made a change please check.
    Also, I've used the ladder prior to finals as normal, but if someone could double check I have the initial draft order right that would also be appreciated :)
     
    • Like Like x 2
  8. anthak

    anthak Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,489
    Likes Received:
    5,293
    hey mate, Im sorry, I just want to make sure you know I only worried about draft picks. Do you have a list of player trades, or will it help for me to compile them too?
     
    • Like Like x 1
  9. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    I think we have them, I didn't see a trade for players that did not involve a pick, but I've asked everyone to check, if they don't it's their problem, appreciate the assist :)
     
    • Like Like x 1
  10. That KI Guy

    That KI Guy Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    2,905
    Likes Received:
    4,672
    Fwiw
    Bandit and I did a non pick trade.
    COP receives Connor MacDonald
    LLL receives Nick Bryan and Phoenix Gothard
     
    • Like Like x 3
  11. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,698
    Likes Received:
    3,508
    legendary effort @anthak & @Len
     
  12. chris88

    chris88 1000 Monkeys at 1000 Typewriters Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,431
    Likes Received:
    1,815
    Great stuff!
     
  13. anthak

    anthak Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,489
    Likes Received:
    5,293
    I hear the site has been rolled over now!
    I havent checked but wanted to let you know asap to help with your prep work
     
    • Like Like x 2
  14. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,698
    Likes Received:
    3,508
    you assume we do prep work LOL
     
    • Like Like x 2
  15. anthak

    anthak Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,489
    Likes Received:
    5,293
    I meant Len preparing the draft and lists etc
     
    • Like Like x 1
  16. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    8,049
    Likes Received:
    6,983
    @Bandit i have downloaded and checked the spready in the OP of this thread - you have 448 listed players and across the whole playing pool there are a couple with blue shaded ID's and a couple with yellow shaded id's - i am still none the wise what the different id's relates to unless you can be very clear with a couple of examples that show an id changing between 2024 and 2025 and wrecking your files
     
    • Like Like x 3
  17. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,698
    Likes Received:
    3,508
    it's @Len 's spreadsheet TTH, so I am just as blind as you are when it comes to where the number came from.... however in the ORFFA lists tab vs 2025 players the numebrs are different, and in the past they have not been.

    two examples... of many I can provide

    Callum Ah Chee - 6597 in the ORFFA lists tab vs 2579 in the 2025 players tab
    Taylor Adams 5614 vs 2074

    those two examples highlight the issue across the 400 odd players. I need to pull current positions from the latest data... but I need to pull what ORFFA side they are from the Team lists tab

    so until the number (whatever the number is and its correlation) lines up we are in the mess.
     
    • Like Like x 2
  18. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    8,049
    Likes Received:
    6,983
    Thanks mate

    it looks like the spreadsheet is showing incorrect numbers and needs a rejig.

    for example Angus Sheldrick is #6678 in the system (correct) and #2083 in the spreadsheet (incorrect) as he is a recent player (pick 18, 2021 draft) and the 20XX series is the 2012 new player's range
    http://tooserious.net/forum/player_career.php?id=6678&pcid=102673&name=Angus Sheldrick

    I would suggest taking the current player list offline, and replacing any player Id's with the correct TS ones, per the attached file (sorted by player firstnames A-Z) to iron out the issues.

    Cheers.
     

    Attached Files:

    • Like Like x 1
  19. Bandit

    Bandit Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,698
    Likes Received:
    3,508
    so right back to the very start... I do not have the time to do that.... so we don't do SOO this year
     
  20. Len

    Len Junee Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,819
    Likes Received:
    6,251
    I normally fix the many many ID number changes pre draft, but site was slow rolling and I was off to Italy, so this year just used names.
    Happens every year, new "unique" numbers assigned to players, PITA.
    I'm about to setup MSD, but given the draft went fine without me doing a butt load of crosschecking and correcting in Excel, I won't be doing it anymore.
    All my sheets will work off player names (which also change every bloody year but are easier to correct)
     

Share This Page