As I mentioned in
this post, I think some of the programming for future organization/draft running/scoring stuff should be done collectively. This is intended to be the organization thread. There's quite a few tasks to be done, improvements to be made, and all that good stuff.
So, there are two main categories. There's the Draft Assistant project, mainly in Excel macros (Visual Basic and the like), which is a big one but easily breakable into smaller chunks, and there's several smaller projects that one or more people can take on. If you want to work on something, put your name down on that so we know what still needs to be covered.
Draft Assistant V3 (EricH, coordinator)
-Rewrite original macros for speed/optimization. (EricH--I'll be modifying the code to set and use certain variables throughout the program, rather than having to reset 'em all, as the key part of the process)
-Rewrite for dynamic placement of team list. (Note: This ought to be pretty straightforward, so I might get to it when I do the other rewrite. Right now, it'd be a pain in the behind.)
-Add a 4th-round option, as that might be useful in the future. (There's an existing macro or two that can be modified to make this easier.)
-Incorporate list picks.
-Incorporate random picks.
-Incorporate error-checking.
-Automate format changes and error-checking.
-See if the various macros etc. work in Google Docs, or can be rewritten for same.
General Organization
--Work out single scoring sheet with alliances/scores--location, layout, automation level, all the gory details.
--Automatic team list pulling from FRC site.
--Automatic scoring (by team or by player)--I think there's an existing method, but IIRC it didn't work properly when I checked it for this year.
--Automatic waiver processing--if anybody wants to be so bold.
The plan on the Draft Assistant is: If someone wants to get a jump on it, there's a copy in CD-Media; I'll point you to it if you've forgotten (or you could search for me as the uploader).
I'll use the development version, which is slightly different and do the above-mentioned rewrite there, then publish that (and I'll make sure to comment a lot within the macros). At which point, y'all see the list, y'all have some fun, and if you complete a section that seems to work, drop it on over to me and I'll republish the whole sheet.