View Single Post
  #5   Spotlight this post!  
Unread 15-02-2012, 15:39
1986titans's Avatar
1986titans 1986titans is offline
1986: It's a team #, not a year.
AKA: Paul Shackelford
FRC #1986 (Team Titanium)
Team Role: Alumni
 
Join Date: Feb 2009
Rookie Year: 2009
Location: Manhattan, KS / LSMO
Posts: 228
1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future1986titans has a brilliant future
Re: Where In The World Is FIRST?

Quote:
Originally Posted by yclee31 View Post
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.
__________________
Paul Shackelford - http://www.archkc.com/
Kansas State University - Electrical Engineering '15
Team Titanium - Lee's Summit West HS - FRC 1986 - Student [2009-2011] - Captain [2011] - College Mentor [2012]


Last edited by 1986titans : 15-02-2012 at 15:44.
Reply With Quote