Real time FRC Analytics - Excel

FIRST General Forum
1

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!

Realtime FRC Analytics R1.xlsx (53.3 KB)


Realtime FRC Analytics R1.xlsx (53.3 KB)

2

This is really cool, thank you for sharing!

It’s interesting how close the average scores are for Alliances considering that so few matches have played so far.

3

Ridiculously cool.

Adding that to my list of references immediately.