[FF]: Draft Organization Stuff To Do

[BrennanB]

Originally Posted by EricH

If hidden sheets can be done, it might be a good idea to have a "list input" sheet that will dump to a hidden sheet, if that can also be done.

I was considering having each FF team having their own hidden sheet so that they could make edits after without confusing the draft runner.

Originally Posted by EricH

With an online component, shouldn't be too hard to rig one Gdoc to scrape another--bet I could do it with Excel, too, in terms of picking up data and dropping it off in a sheet.

Yeah, I will look at scraping from on g-doc to another and if that is possible.

EDIT

So it seems hidden sheets are a no-go. However I did end up getting scraping working, so each team can have their own submission sheet. Currently I can pull from one sheet to another, and it updates pretty quickly, have a look.

Sample submission sheet #1
Sample submission sheet #2
Autodraft Testing

EDIT 2

I have it automatically removing already picked teams from the list for each team's first picks. It's not pretty work, but it's functional