View Single Post
  #21   Spotlight this post!  
Unread 20-04-2013, 20:43
Rebellion2638 Rebellion2638 is offline
Registered User
FRC #2638
 
Join Date: Apr 2012
Location: United States
Posts: 9
Rebellion2638 is an unknown quantity at this point
Re: Team 862 scouting database

This is just a suggestion:

I have an idea on an way to input match data. I made an outline of how the excel sheet could look like. Since I do not know how to make macros I did not put them on the buttons. (File is in the attachment)

Description of how it could work:

(I am not sure how to do it but, I think it would work best if the data could be collected from multiple devices and then it gets inserted into the appropriate locations on the master database)

The user inserts the match number and then a drop-down list gives the user the choice of 1 of the 6 teams (this would give the macro a location to put the data). Then there could be a button the person presses after they put in the match and team numbers to confirm the team that they are scouting. After that it is pretty strait forward. The background button is shots missed and (for the climbing section) if they failed the climb (there can be another button if they didn't attempt the climb). Also you can add a button to time the robot's climb.

If you want to be creative you can make buttons transparent and put them pictures above a picture of the pyramid/goal (I think it would only work with the pyramid though).
Attached Files
File Type: xlsx scout buttons.xlsx (47.2 KB, 2 views)