Quote:
Originally Posted by yclee31
Location of Team 2429 is totally wrong 
but how did you get the database for all the teams and locations?
|
https://my.usfirst.org/frc/scoring/i...?page=teamlist
Filter it with Excel by:
1. Paste Special -> Unicode Text
2. Find the columns you want, delete the others
3. Sort by how you want to see teams.
4. Depending on what you want to do, you can also separate things that are comma delimited, like states from their cities, and put those in their own columns.
Edit: To find FLL stuff, you'll probably have to dive into FIRST region sites. KCFIRST has locations at
http://www.kcfirst.org/FLL-Tournament_Results.html for example, but not every region does this.