Chief Delphi - Scouting using Excel, please help

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)

- Scouting (http://www.chiefdelphi.com/forums/forumdisplay.php?f=36)

- - Scouting using Excel, please help (http://www.chiefdelphi.com/forums/showthread.php?t=153830)

Re: Scouting using Excel, please help

Quote:

Originally Posted by jaredhk (Post 1638178)

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.

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