Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Lucky last!Am in if there is a spare spot
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.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:
Notes:
- 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
- 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
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.
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.