2015 Champs Pre-Scouting Spreadsheet and Form

[Rachel Lim]

As there have been a few teams that have submitted the form multiple times, or submitted the form after filling out the spreadsheet previously, I just wanted to clarify how I'll be dealing with new / different data:

If the form is filled out completely with new / different data, I'll replace that team's row with the newest one form submission.
If the form has just one or two fields filled out with new / different data, I'll manually copy the cell(s) over to the existing row.
If the form has most fields filled out, I'll replace that team's row with the new one, and if I see old data that was lost, manually enter back in the old data.


Therefore, if you'd like to correct your team's data and will be changing all but a few fields, it'd be really nice if you could answer all the questions (even those that are still correct) so I won't have to make sure to keep the old one. If you'd like that cell to be blank, please note it in the "Additional notes" box.

Also, since there are now multiple ways to enter data, this is how I'll be choosing which one to put in: PMed data/corrections > form/resubmitted form > comments.

Let me know if you have any suggestions to this process or to the form--I'll be happy to hear them!