View Single Post
  #1   Spotlight this post!  
Unread 01-03-2013, 12:09
Conor Ryan Conor Ryan is online now
I'm parking robot yacht club.
FRC #4571 (Robot Yacht Club)
Team Role: Mentor
 
Join Date: Nov 2004
Rookie Year: 2004
Location: Midtown, NYC
Posts: 1,893
Conor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond reputeConor Ryan has a reputation beyond repute
Real time FRC Analytics - Excel

Hey everyone, check this out!

I figured I would use the FRC Spy XML to create a self-updating real-time excel analytics file. Here is the very rough Rev1.0 that I made in about 5 minutes without a mouse.

Take a look at the introduction and then the Red and Blue tabs are interesting. If you know anything about excel and how to use Pivot Tables and Pivot Charts you can probably do pretty neato stuff on your own.

Let me know your thoughts and ideas! I'm developing a team picking algo off of this eventually. Take the humans out of the equation, I always say.

Enjoy!
Attached Files
File Type: xlsx Realtime FRC Analytics R1.xlsx (53.3 KB, 241 views)
Reply With Quote