Thread: Input to the system
View Single Post
  #3   Spotlight this post!  
Unread 28-01-2013, 22:35
RoboScout RoboScout is offline
Registered User
AKA: Ken St.
FRC #1073 (The Force Team)
Team Role: Mentor
  
Join Date: Nov 2011
Rookie Year: 2011
Location: Hollis, NH
Posts: 13
RoboScout is an unknown quantity at this point
Re: Input to the system
The central data processing application that our team uses is written in python and recently I found a very nice python module that lets you read Excel spreadsheet files. It's called xlrd, and I believe that there is an associated writer utility out there, too. It sure beats having to convert the Excel files into CSV or some other export format in order to read it in.

Perhaps you could have all the Excel data files from each of the scouters transferred to a central laptop and then processed by the python application that will read the spreadsheet files, compile the data and write out a consolidated sheet for you.

Just a thought...

KenSt
Mentor FIRST Team 1073