Go to Post "The purpose of computation is insight, not numbers." - Tom Ore [more]
Home
Go Back   Chief Delphi > Competition > Rules/Strategy > Scouting
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rate Thread Display Modes
  #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
  #17   Spotlight this post!  
Unread 30-01-2017, 15:45
tr6scott's Avatar
tr6scott tr6scott is online now
Um, I smell Motor!
AKA: Scott McBride
FRC #2137 (TORC)
Team Role: Mentor
 
Join Date: Dec 2007
Rookie Year: 2005
Location: Oxford, MI
Posts: 540
tr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond repute
Re: Scouting using Excel, please help

If you are learning, try to learn MATCH, and INDEX, as opposed to VLOOKUP.

There are times when you may need to look left to the key value, MATCH and INDEX allow you that flexibility. Also if you are building the data into a list your are going to "filter" by team number for review, you need to learn SUBTOTAL function too.

(match and index are non-volatile functions, so they process faster and force less re-calcs)


https://fiveminutelessons.com/learn-...nstead-vlookup
__________________
The sooner we get behind schedule, the more time we have to catch up.

Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 13:57.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi