pic: Michigan Team Growth 2009-2016

[ahartnet]

What did you use to create these graphs and the gif? I recently used Google sheets and the map marker for Texas, but didn't find it to be too user friendly.

[orangelight]

This is really cool. What did you use to make it?

[Rachel Lim]

Originally Posted by Liam Fay

Actually, though, if you started a blog dedicated to FRC data analysis, I would love it!

I'm trying to come up with something focused on CA competitions (specifically norcal since I'm not sure how much time I'll have), but I may expand it later on. Look out for something (hopefully) soon!

Originally Posted by ahartnet

What did you use to create these graphs and the gif? I recently used Google sheets and the map marker for Texas, but didn't find it to be too user friendly.

Originally Posted by orangelight

This is really cool. What did you use to make it?

Tableau for the graphs and Excel storing/formatting the data. I found it to be the most intuitive way to deal with any sort of location-type data. I haven't found a way to tell it which state cities are in though, so I have to link city data to zip codes and map that. Once that's done though, I really like it because I can give it a list of locations per year and create either multiple columns of maps, or pages that it can loop through (the gifs are screenshots of that).

If you'd like more details or have any other questions let me know--I'm happy to go into more specifics if you'd like.

[orangelight]

Originally Posted by Rachel Lim

If you'd like more details or have any other questions let me know--I'm happy to go into more specifics if you'd like.

Where did you get the data from?

[Rachel Lim]

Originally Posted by orangelight

Where did you get the data from?

Team lists: the "what events and teams are in my area?" searches (e.g. this is Michigan for 2016)
https://my.usfirst.org/myarea/index....16&area=mi-usa or http://frclinks.frclinks.com/t/mi-usa/2016

Event lists: TBA API, district events request
http://www.thebluealliance.com/apidocs

Zip codes: combined the two below
http://www.unitedstateszipcodes.org/mi/
http://www.zipcodestogo.com/Michigan/

I think there are ways to automate this further (certainly actually using the API as opposed to copy/pasting data out would help), but I've found this to be enough for what I need it for.