Converting team number to team nickname

[Bill_B]

Is there a fast and/or efficient method for turning a list of team numbers into their corresponding information, like team nickname? I compiled a championship team list spreadsheet but the "team name" field is impossibly wordy, despite its obvious worthiness. It reminds me of the difference between the Latin names and common names of flowers, for instance. Miss Daisy could more properly be called Miss Bellis perennis. For that, we truly would miss "daisy."

[Ed Law]

Is this what you are looking for?

11	MORT
16	Bomb Squad
20	The Rocketeers
25	Raider Robotix
27	Team RUSH
33	Killer Bees
40	Checkmate
45	TechnoKats Robotics Team
48	Delphi E.L.I.T.E.
51	Wings of Fire
57	Leopards
60	Bionic Bulldogs
63	The Red Barons
67	The HOT Team
70	More Martians
71	Team Hammond
74	Team C.H.A.O.S.
78	AIR Strike
79	Team Krunch
88	TJ(Squared)
93	N.E.W. Apple Corps Robotics
103	Cybersonics
108	SigmaCat
111	WildStang
118	Robonauts
120	Scarabian Knights
122	NASA Knights
126	Gael Force
131	C.H.A.O.S.
135	The Black Knights
141	WO-BOT
148	Robowranglers
151	Tough Techs
155	The Technonuts
159	Alpine Robotics
166	Chop Shop
167	Children of the Corn
173	R.A.G.E. (Robotics & Gadget Engineering)
175	Buzz Robotics
176	Aces High
177	Bobcat Robotics
179	The Children of the Swamp
180	S.P.A.M.
188	Blizzard
190	Gompei and the H.E.R.D.
191	X-CATS
195	Cyber Knights
203	One TUFF Team (Team United for FIRST)
217	ThunderChickens
228	Team "Gus"
229	Division By Zero
230	Gaelhawks
233	The Pink Team
234	Cyber Blue
236	Techno-Ticks
238	Cruisin Crusaders
245	Adambots
246	Overclocked
254	Cheesy Poofs
281	Entech 281
292	PantherTech
294	Beach Cities Robotics
295	Renevatio
302	The Dragons
303	Panther Robotics
316	LuNaTeCs
329	Raiders
330	Beach Bots
335	Skillz Tech Gear Botz
337	Hard Working Hard Hats
340	G.R.R. (Greater Rochester Robotics)
341	Miss Daisy
353	POBots
357	Royal Assault
359	Hawaiian Kids
360	The Revolution
364	Team Fusion
365	Miracle Workerz
368	Team Kika Mana
375	Robotic Plague
386	Team Voltage
395	2 TrainRobotics
399	Eagle Robotics
401	Hokie Guard
433	Firebirds
435	Robodogs
440	The Suspects
447	Team Roboto
469	Las Guerrillas
476	Wildcats
494	Martians
503	Frog Force
525	Swartdogs
537	Charger Robotics
548	Robostangs
573	Mech Warriors
597	Wolverines
599	Robodox
610	The Coyotes
624	CRyptonite
677	Murphy's Outlaws
687	The Nerd Herd
694	StuyPulse
701	RoboVikes
751	barn2robotics
766	M-A Bears
768	TechnoWarriors
771	SWAT
781	Kinetic Knights
811	Cardinals
836	RoboBees
842	Falcon Robotics
846	The Funky Monkeys
862	Lightning Robotics
876	Thunder Robotics
884	Mechanical Mules
930	Mukwonago B.E.A.R.s (Building Extremely Awesome Robots)
931	Perpetual Chaos
932	Circuit Chargers
935	RaileRobotics
967	Iron Lions
968	RAWC (Robotics Alliance Of West Covina)
973	Greybots
980	ThunderBots
987	HIGHROLLERS
999	C.R.A.S.H.        (Cheshire Robotics and Sikorsky Helicopters)
1000	Cybearcats
1014	Bad Robots
1023	Bedford Express
1024	Kil-A-Bytes
1056	Warrior Pride
1065	The Moose
1086	Blue Cheese
1094	Channel Cats
1098	Rockwood Robotics "Rock-Bots"
1099	Disco Techs
1100	The T-Hawks
1108	Panther Robotics
1114	Simbotics
1138	Eagle Engineering
1165	Team Paradise
1182	Patriots
1188	OAKTOWN CREWZ
1195	GH2
1197	TorBots
1212	Sentinels
1218	Vulcan Robotics
1241	Theory6_Team Hansen Experience of Robotic Youth
1266	The Devil Duckies
1270	Red Dragons
1288	RAVEN Robotics
1305	Ice Cubed
1323	MadTown Robotics
1334	OTHS Red Devils
1425	Error Code Xero
1429	TEAM KAOS
1444	The Lightning Lancers
1477	Texas Torque
1482	Ghosts
1502	Technical Difficulties
1503	Spartonics
1507	Warlocks
1510	Wildcats
1511	Rolling Thunder
1518	Raider Robotics
1519	Mechanical Mayhem
1522	DOTM - Defenders of the Multiverse
1535	Knights of Alloy
1538	The Holy Cows
1547	Where's Waldo?
1557	12 Volt Bolt
1559	Devil-Tech
1574	MisCar
1604	Mekheads
1622	Team Spyder
1625	Winnovation
1626	Falcon Robotics
1629	Garrett Coalition (GaCo)
1640	Sab-BOT-age
1646	Precision Guessworks
1675	The Ultimate Protection Squad
1676	The Pascack PI-oneers
1678	Citrus Circuits
1690	Orbit
1700	Gatorbotics
1706	Ratchet Rockers
1710	The Ravonics Revolution
1714	MORE Robotics
1717	D'Penguineers
1718	The Fighting Pi
1730	Team Driven
1731	Fresta Valley Robotics Club
1732	Hilltoppers
1739	Chicago Knights
1741	Red Alert
1764	Liberty Robotics
1771	North STARS
1801	The Dapper Dans
1811	FRESH
1816	"The Green Machine"
1829	Carbonauts
1836	MilkenKnights
1868	Space Cookies
1885	ILITE Robotics
1891	Bullbots
1899	Saints Robotics
1912	Team Combustion
1918	NC GEARS
1923	The MidKnight Inventors
1927	Tempest
1942	Tel-Nof
1983	Skunkworks Robotics
1984	Raider Revolution Robotics
1985	Robohawks
1986	Team Titanium
2016	Mighty Monkey Wrenches
2022	Titan Robotics
2039	Rockford Robotics
2040	D.E.R.T.
2046	Bear Metal
2054	TECH Vikes
2056	OP Robotics
2073	EagleForce
2080	Torbotics
2081	Icarus
2102	Team Paradox
2122	Team Tators
2137	T.O.R.C. - The Oxford RoboCats
2169	KING TeC
2175	The Fighting Calculators
2177	The Robettes
2197	Las Pumas
2199	Robo-Lions
2264	Inceptus
2283	Panteras
2337	EngiNERDs
2338	Gear It Forward
2342	Team Phoenix
2359	RoboLobos
2363	Triple Helix
2377	C Company
2415	WiredCats
2437	Lancer Robotics
2471	TEAM Mean Machine
2472	Centurions
2481	Roboteers
2486	CocoNuts
2500	Herobotics
2512	Duluth East Daredevils
2543	TitanBOT
2549	Millerbots
2556	RadioActive Roaches
2607	Fighting Robo-Vikings
2614	MARS
2655	Flying Platypi
2660	Pengbots
2662	Robo Krew
2702	REBotics
2751	SPARK Robotics
2761	Clovis North Robotics
2783	Engineers of Tomorrow
2797	Knight and Nerdy
2809	K-Botics
2815	Los Pollos Locos
2826	Wave Robotics
2848	The All Sparks
2949	pwnage
2972	RC Dawson
2974	WALT
2984	The Vikings
2990	Hotwire
2996	Cougars Gone Wired
3009	High Scalers
3010	The Red Plague
3017	Patriots
3037	Lobos
3098	The Captains
3103	Iron Plaid
3126	FlashPoint
3130	The East Ridge Robotic Ominous RaptorS - the ERRORS
3132	Thunder Down Under
3138	Innovators Robotics
3158	TECBOT
3160	FROG:  FIRST Robotics Organization of Grove
3172	SC Robotics
3239	NUAMES
3242	Wildcats
3256	WarriorBorgs
3278	QWERTY Robotics
3284	Camdenton 4H LASER Team
3322	Eagle Imperium
3337	Panthrobotics
3344	Robocopz
3351	Ratchet
3358	Y.T.P.T - J.E.T.S
3374	RoboBroncs
3393	Horns of Havoc
3397	Robo-Lions
3456	Livewire
3459	Team PyroTech
3462	FERVOT
3464	Sim-City
3466	VI  Kings Robotics
3467	The Windham Windup
3472	Buluk
3473	Team Sprocket
3477	Chaos Vortex
3478	CAMPUS SAN LUIS
3481	Brandeis Bronc Botz
3483	Cold Smoke
3487	The EarthQuakers
3492	ROBOGENS
3494	The Quadrangles
3504	girlsFIRST-Girls of Steel
3505	Fighting Z-Bots
3506	YETI
3507	Ubotics
3521	The Noble Nuts
3526	Blue ignition
3527	Tec Balam Esmeralda
3528	Up Next!
3536	Electro Eagles
3539	The Byting Bulldogs
3547	Virus
3553	South Philly Rambots
3574	HIGH-Tekerz
3588	the Talon
3596	Rocket Robotics
3612	GearHogs
3616	Team Phenomena
3622	Robocats
3624	ThunderColts
3630	The Stampede
3642	Huskies
3645	Runtime Error
3651	TRIBE
3685	Waianae Searider Robotics
3694	Warbotz
3704	Robosapiens
3711	Mustangs
3729	RaiderBots
3739	Oakbotics
3747	Chaotech
3748	Ragnarök
3750	Gators
3756	Ram-ferno
3766	ort
3784	Bit by Bit 4-H Robotics Team
3792	The Army Ants
3799	ND High School
3824	HVA RoHawktics
3880	Kealakehe Robo Riders

[Bill_B]

That's spectacular, Ed. How did you do that? I was looking for a method to do it, but I'll take your table as it stands with gratitude and worry about the process later. Thanks.

[pfreivald]

*ahem*

That list clearly isn't complete.

*ahem*

[Vikesrock]

Originally Posted by pfreivald

*ahem*

That list clearly isn't complete.

*ahem*

It is a complete list of teams registered for Champs.

[pfreivald]

Originally Posted by Vikesrock

It is a complete list of teams registered for Champs.

Ah.

:sad:

[The Lucas]

Originally Posted by Bill_B

That's spectacular, Ed. How did you do that? I was looking for a method to do it, but I'll take your table as it stands with gratitude and worry about the process later. Thanks.

The best place IMHO to get team data from FIRST in a nice tab delimited form (suitable for computers) is where FMS (a computer) gets its data. Here are all the teams (numbers, nicknames, hometowns, etc...) and there are pages for specific events.

[Fletch1373]

Originally Posted by The Lucas

The best place IMHO to get team data from FIRST in a nice tab delimited form (suitable for computers) is where FMS (a computer) gets its data. Here are all the teams (numbers, nicknames, hometowns, etc...) and there are pages for specific events.

HOW did I not know about that site?!?!?!

[The Lucas]

Originally Posted by Fletch1373

HOW did I not know about that site?!?!?!

How would you know about that site?
FIRST doesn't link to it, they link you to the page intended for humans to read. At a meeting, right after divisions were released, people were asking me to show them the division. I had the FMS page loaded but no Internet, so I showed them that and all I got was I told them that is just how I look at divisions. Both "pages" are really just differently formatted queries to the same TIMS database.

I see from your signature, you volunteer as an inspector (as do I). This is really knowledge that FTAs and scorekeepers acquire. If you know some, you can learn a lot from them about the FMS. If you don't know any, just listen to the ones on CD when they speak.

[Fletch1373]

Originally Posted by The Lucas

How would you know about that site?
FIRST doesn't link to it, they link you to the page intended for humans to read. At a meeting, right after divisions were released, people were asking me to show them the division. I had the FMS page loaded but no Internet, so I showed them that and all I got was I told them that is just how I look at divisions. Both "pages" are really just differently formatted queries to the same TIMS database.

I see from your signature, you volunteer as an inspector (as do I). This is really knowledge that FTAs and scorekeepers acquire. If you know some, you can learn a lot from them about the FMS. If you don't know any, just listen to the ones on CD when they speak.

fair enough. However, I have been working on team/event/match data retrieval projects from official sources for a few years now, so I'm surprised that site hasn't come up in my research. I know a few of the FTA's and Scorekeepers, and I know quite a bit about the system just from being around so long.

[Ed Law]

That is the site I got my data from. I learned it from Pat Fairbank. If you search it hard enough on CD, you would have found that post from last year.

[The Lucas]

Originally Posted by Ed Law

That is the site I got my data from. I learned it from Pat Fairbank. If you search it hard enough on CD, you would have found that post from last year.

You can't actually use Pat's links from last years division thread anymore. They were temporary frclinks.com using z and he deleted them.

I actually wish Pat would keep them around and expand them to all regionals. It is really useful for advance scouting regionals (I lookup who in webcast regionals is coming to my regional using simple unix commands on text files) and it is annoying looking up event IDs.