Quote:
Originally Posted by Killraine
After updating the spreadsheet, I tried to Query team 330 and nothing came up in that window. It would be nice to be able to still use the Query function while you are at an in-progress competition (Situation: At the regional, we are paired up with team #### and team #### in our next qualification match. We don't have much information on them yet and this is their first regional this year, but we want a general idea what our strategy will be. A quick look-up in the spreadsheet shows us there records and a vague idea what their OPR/CCWM are)
|
Again the original plan was transfer the data only after a regional is completed, I transfer the data from the sheet from that regional to sheets "WM data" and "OPR data" for use by the Query sheet. If we want to transfer during a regional also, I need to reprogram that part. Right now it only allow one transfer per regional. If you transfer more than one time, it will think that it is a new regional because it looks for blank space and dump the data there.
For now, you have to refer to the sheet for your current regional and find the data there for the teams which is not that hard. Actually I think it is more convenient to have all the teams you are competing with at your regional all on one page than to have to query one team at a time. The Query was meant to be printed out before you get to the regional or to be printed out after your scouts take pictures of all the robots on Thursdays.
Thanks for the suggestions.
Ed Law