Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Scouting (http://www.chiefdelphi.com/forums/forumdisplay.php?f=36)
-   -   Converting team number to team nickname (http://www.chiefdelphi.com/forums/showthread.php?t=94767)

Bill_B 23-04-2011 00:46
Converting team number to team nickname
 
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 23-04-2011 01:01
Re: Converting team number to team nickname
 
Is this what you are looking for?
Code:
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 23-04-2011 09:10
Re: Converting team number to team nickname
 
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 23-04-2011 09:25
Re: Converting team number to team nickname
 
*ahem*

That list clearly isn't complete.

*ahem*

Vikesrock 23-04-2011 09:37
Re: Converting team number to team nickname
 
Quote:
Originally Posted by pfreivald (Post 1055800)
*ahem*

That list clearly isn't complete.

*ahem*
It is a complete list of teams registered for Champs.

pfreivald 23-04-2011 10:00
Re: Converting team number to team nickname
 
Quote:
Originally Posted by Vikesrock (Post 1055805)
It is a complete list of teams registered for Champs.
Ah.

:sad:

;)

The Lucas 23-04-2011 10:19
Re: Converting team number to team nickname
 
Quote:
Originally Posted by Bill_B (Post 1055797)
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 23-04-2011 12:28
Re: Converting team number to team nickname
 
Quote:
Originally Posted by The Lucas (Post 1055811)
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 23-04-2011 13:10
Re: Converting team number to team nickname
 
Quote:
Originally Posted by Fletch1373 (Post 1055840)
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 :confused: 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 24-04-2011 22:04
Re: Converting team number to team nickname
 
Quote:
Originally Posted by The Lucas (Post 1055850)
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 :confused: 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 24-04-2011 22:17
Re: Converting team number to team nickname
 
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 24-04-2011 22:47
Re: Converting team number to team nickname
 
Quote:
Originally Posted by Ed Law (Post 1056218)
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.


All times are GMT -5. The time now is 17:19.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi