View Single Post
  #16   Spotlight this post!  
Unread 30-01-2017, 13:59
Skyehawk's Avatar
Skyehawk Skyehawk is offline
Nuts N' Bolts
AKA: Skye Leake
FRC #0876 (Thunder Robotics)
Team Role: Mentor
 
Join Date: Nov 2012
Rookie Year: 2011
Location: Northwood, ND
Posts: 275
Skyehawk is a name known to allSkyehawk is a name known to allSkyehawk is a name known to allSkyehawk is a name known to allSkyehawk is a name known to allSkyehawk is a name known to all
Re: Scouting using Excel, please help

Quote:
Originally Posted by jaredhk View Post
In 2015 we scouted using tablets (with a custom app) and Excel. It was a messy system and not ideal but it is very easy to set up:

The app saved data to CSV files which were then placed on microSD cards in the tablets. Every hour or so we would copy the CSV data from each tablet into the Excel doc. From that point, you can do whatever you want to access the data. Just make sure that the app records the data to the CSV in the same order as your column headers in Excel.

Again, not the world's best system but it is very simple to setup and use. I can get you the code for the 2015 app, if you'd like.
I remember (back in the days of 2011/2012) that there was a great ISO app called iSort, it generated .csv and interfaced with excel easily. It was, as you described, a messy approach. We have since moved on to greener pastures, but it did work. There are all types of "database apps" that can get you rolling.
__________________
My time in FIRST has made me a better person, frankly I don't know where I'd be without it.



2011 Lake Superior Regional Champs (Thanks 2512 & 3747)
2015 Central Illinois Regional Engineering Inspiration Award recipients
2016 Central Illinois Regional Champs (Thanks 2481 & 2220)
Reply With Quote