This year my team has taken a big step forward. We now have six netbooks that we distribute to scouts in the stands with a scouting form on each one as an excel spreadsheet. The scouts create a new spreadsheet for each team, saving it as one workbook.
In total, we want it to run like this:
Scout make workbook of scouting form spreadsheets -> Upload to FTP server laptop -> Server takes separate excel workbooks and compiles all the spreadsheets in each workbook into one single workbook -> Server laptop runs a macro to give us our rankings
We still have a few hurdles to overcome before our next district competition though, as the netbooks we use are school property, and therefore do not allow you to run batch scripts to do the FTP (
). Also, we do not have a way or auto-compiling multiple workbooks into one workbook at the moment.
Right now, were OK with having the scout manually run a program to upload the file to the FTP server, so thats not an issue.
Do you guys have any suggestions on how we could do these two things auto-magically?
Also, (and more importantly
) how does your team do scouting?