Carlton Board Phantom Draft - Expressions of Interest

Discussion in 'Carlton' started by Blue and Silver, Oct 2, 2017.

Put it out there
  1. ShanDog

    ShanDog Spec Moderator

    Carlton
    Other teams:
    Joined:
    Aug 12
    Posts:
    12,343
    Location:
    sv_cheats 1
    If you need participants let me know, but fair warning - I shall make selections based purely off funny names, haircut styles and "dartboard analysis".

    I rate my chances of nailing selection as much an anyone :)
     
    Arr0w and ferrisb like this.

    (Log in to remove this ad.)

  2. Jeremias

    Jeremias Daddy Pow

    Carlton
    Other teams:
    MUFC, LAL, PSG
    Joined:
    Sep 04
    Posts:
    32,049
    Happy to participate if you need numbers.
     
  3. Jimmae

    Jimmae Norm Smith Medallist

    Carlton
    Other teams:
    Tennessee Titans, Tottenham Hotspur
    Joined:
    Nov 03
    Posts:
    9,235
    Location:
    Earth, near Carlton.
    Ok, so far:

    1. B&S
    2. HARKER
    3. SoapyV
    4. Blugazi
    5. gandaal
    6. SkyhorseTamer
    7. esoteric
    8. Neadsy83
    9. BlueTongue
    10. Jimmae
    11. Wickzki
    12. TerryWallet
    13. Coona Blues
    14. Foucault1989
    15. ShanDog
    16. Jeremias

    2 more spots
     
  4. Blue and Silver

    Blue and Silver Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    Sep 09
    Posts:
    9,740
    Location:
    Brunswick
    Thanks Jimmae. Got caught up with work

    Sent from my SM-G920I using Tapatalk
     
    Jimmae likes this.
  5. ScottoP

    ScottoP Debutant

    Other teams:
    Joined:
    Sep 17
    Posts:
    51
    Yeah put me down if spots available.

    Good first post.................... :cool:
     
  6. Blue and Silver

    Blue and Silver Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    Sep 09
    Posts:
    9,740
    Location:
    Brunswick
    OK last chance call on snake draft I am drawing the order tomorrow night
     
  7. ferrisb

    ferrisb Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    May 11
    Posts:
    9,018
    Location:
    Melbourne
    Hey peeps. I have had a play around a built a PHANTOM DRAFT TRACKER

    It's a work in progress; it's functional, but probably isn't bulletproof. I thought it might be a good time for the nerds (and non-nerds) to start playing around with it.

    A few features:
    • It's a google doc, so everyone can use the same file at the same time. As one person enters their selection, everyone else's spreadsheets update a second later
    • Players are listed in drop downs; so you can find your players from an A-Z list or type in any part of their name (first or surname) to find them
    • If you select a player that has already been selected, it will warn you
    • If you enter in a team in cell B1, it will tell you that's teams pick #s and who they have selected so far
    Notes:
    • I've listed players invited to national and state combines. You can still add a player outside of this manually
    • I've pre-filled in the top 30 based on a BF phantom draft from earlier this year
    • I've got a few other features/functionality I'd like to build in, but for now I'll let this out into the world for testing/feedback (I have a habit of sitting on a project until it's perfect, but then never actually launching anything because I'm never finished)
    • Being an open spreadsheet is awesome, but also dangerous. Anyone could kill a formula accidentally etc. I have a backup copy of this, so you can go nuts. Maybe the final version needs to be protected and/or administered by Blue and Silver or Jimmae or me or someone else.
    • If I can B F'd (see what I did there), I'll have the front page also list every pick/selection by team, build in a academy/FS bidding process and more
     
    Mr_Plow, BlueGum, gandaal and 3 others like this.
  8. ferrisb

    ferrisb Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    May 11
    Posts:
    9,018
    Location:
    Melbourne
    Player names:
    • In a list of 202 players there are:
      • 0 players named John, Michael or Richard
      • 4 Aidan/Aidens
      • 5 x Brandon/Braydon/Brendon
      • 4 x Callan/Callum
      • 3 x Harrison (WTF?)
      • 4 x Oscar/Oskar
      • 7 x Tom
     
    Jabba73, BlueGum, gandaal and 2 others like this.
  9. Arr0w

    Arr0w Premiership Player

    Carlton
    Other teams:
    Joined:
    Nov 15
    Posts:
    3,807
    Location:
    In Transit
    Am in if there is a spare spot
     
    Jimmae likes this.
  10. Jimmae

    Jimmae Norm Smith Medallist

    Carlton
    Other teams:
    Tennessee Titans, Tottenham Hotspur
    Joined:
    Nov 03
    Posts:
    9,235
    Location:
    Earth, near Carlton.
    Lucky last!

    ping Blue and Silver

    Yeah this was my worry with a coded sheet: a lot can go wrong. You've definitely made it fairly straight forward for entry, but the point of having the pool in there would be to offer a reference. I'm a perfectionist like yourself so I'd have added layer after layer of feature sets before pushing it out. :p

    The big thing missing here is the points system, and how that can impact a change in selections. I'm not familiar enough with excel or sheets code to know if a complete solution could be implemented there, but it definitely could math out the points cost.
     
  11. Arr0w

    Arr0w Premiership Player

    Carlton
    Other teams:
    Joined:
    Nov 15
    Posts:
    3,807
    Location:
    In Transit
    Jimmae ferrisb Happy to help with the debugging of the said spreadsheet
     
    ferrisb likes this.

    (Log in to remove this ad.)

  12. Blue and Silver

    Blue and Silver Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    Sep 09
    Posts:
    9,740
    Location:
    Brunswick
    Alright. I am going to go check out ferris's spreadsheet etc.

    Once I got an idea about what's up, I will notify everyone.
     
  13. Blue and Silver

    Blue and Silver Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    Sep 09
    Posts:
    9,740
    Location:
    Brunswick
    Ok

    For the Snake Draft I have drafted an order it is...

    1.B&S
    2. Neadsy83
    3. Blue Tongue
    4. Terry Wallet
    5. Coona Blues
    6. Blugazi
    7. Gandaal
    8. ShanDog
    9. Jeremias
    10. Jimmae
    11. ScottoP
    12. SoapyV
    13. Foucault1989
    14. Skyhorse Tamer
    15. Wickzki
    16. Harker
    17. Esoteric
    18. Arrow

    A reminder the order then reverses. Which means Arrow also has 19, and I get 36...

    So Pick 1 isn't quite the gem it seems.

    I am going to start a new thread in the Blue Room and tag all players, include a full 5 round list in the OP etc.

    So bear with me for an hour or so.
     
    Jimmae likes this.
  14. ferrisb

    ferrisb Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    May 11
    Posts:
    9,018
    Location:
    Melbourne
    Hey peeps, waddaya reckon?

     
    Arr0w and gandaal like this.
  15. TerryWallet

    TerryWallet Norm Smith Medallist

    Carlton
    Other teams:
    Joined:
    Jan 08
    Posts:
    9,405
    Location:
    Melbourne
    Some dodgy picks all round there but shit, Shane Rogers has Jeremias covered.