Quote:
Originally Posted by Christian2443
Hi my team has been trying to constantly to improve our way of scouting for the last couple of years. Our current method of scouting was having a binder where we have our pit scouting information stored. Besides this binder we match scout by having 6 members fill out a match sheet for each team when they play. Once the match is finished we have someone on a labtop input this data into excel.
This year we are hoping to go all electronic.
Goals for 2014 Scouting:
1. Database where all the pit and match scouting information for all the teams will be located. (Currently we are learning how to use microsoft access 2007 and we are novice using it.)
2. Use 6 labtops,tablets, or smartphones to fill out a match scouting form for each robot in a match, then get that data sent over to a main labtop which all the information will be stored into a database.
3. Take the data and place it into tableau to analyze.
4. Get this data on to a tablet for our members in the pit area to have it. Also these team member are able to access the data to strategize for matches and alliance selection.
|
I agree with Kims Robot. We always used wired connection at competitions and we never lost connection or got in trouble.
If you want to collect data using the computers, I would strongly recommend using a combination of MySQL and Access. Last year we set it up so that data collected on several laptops would all sync to the same database in live time. Then, we would connect to the MySQL sever with Tableau. MySQL is free and can be connected to with a standard OBDC connection in Access. This is a tutorial I found:
http://forums.mysql.com/read.php?65,148441,148441
In addition, if you have any questions about Tableau or connecting it to any datasource, feel free to PM me. I am trying to find some common problems so I can make another video.
04-02-2014, 19:23
Hybrid Mode
