Registration 2013

[feverittm]

Mark,

Do you have an up-to-date spreadsheet with all the teams registered this year and the regional(s) they are registered to attend?

How would you compile this list? (easily, computer assisted)

Thanks

[Mark McLeod]

I have an up-to-date event team list, but not with me.
Ed Law usually publishes his, but he's probably waiting for Bedford to settle out: http://www.chiefdelphi.com/media/papers/2731

You can get the team list and other info. on an event basis if you have the event IDs. Then you can setup a macro to collect them all in Excel or another tool. I have to go looking for the Event IDs.
P.S. Event IDs:
https://my.usfirst.org/frc/scoring/index.lasso?page=eventlist

For example, here is the Long Island list:

https://my.usfirst.org/frc/scoring/index.lasso?page=event_teamlist&ID_event=9011

[Mark McLeod]

Championship just lost another of the pre-qualified teams (548)

Do you still need teamlists by event, Floyd?
I mailed the latest to myself.

[Racer26]

Iiiiiinteresting about 548.

another place to see the event codes: frclinks.com

frclinks.com/e/<event code> gets you to the team list for each event.

[bduddy]

Originally Posted by Mark McLeod

China is trying again this year at the Spokane Regional

Team Number: 4813
Team Name: shen zhen da da le le
Team Location: Shen zhen, GD China (shares a border with Hong Kong)
Rookie Season: 2013
Team Nickname: R2
Year - Event : 2013 Spokane Regional

4813 is no longer registered (indeed, TBA now lists their team name as "NOT PAY FOR THIS TEAM", which is hardly a winning attitude). But two new Chinese teams have appeared, both registered for Hawaii - 4830 and 4831. 4830 possibly is the same thing as 4813, as they both list "Shen zhen da da le le" in their team name - maybe they made a mistake when registering (they didn't initially realize there was a regional in Hawaii? )

[Mark McLeod]

The team list dropped about 15 teams over the weekend.
There are now 2324 teams playing this season.

Correction, the new Beta Team list shows 2324 teams, but the FIRST database still has 2339 teams listed. I think I'll go with the database and take a look at what teams aren't showning up on the new Beta.
P.S. the Beta site seems to be built from older team/event lists. There are teams listed on it who aren't playing, and teams who are playing who aren't listed.

FIRST has a new Beta Teams & Events page
Positives:

• Lists team nicknames
• Searches for teams within x miles of a zipcode

Negatives:

• Does not list the team name any longer
• Now limited to listing 25 teams per page
• Team count seems 15 teams short

[jawebste]

Originally Posted by lynca

This is amazing ! Everytime I think about FRC statistics, I always go to the source and verify with Mark McLeod's stats !

ditto

[Mark McLeod]

Watch out for my typos though.

There are 2539 teams, although the new Beta Team list only shows 2324 (it's actually 215 teams off).

[Gary Dillard]

Originally Posted by Mark McLeod

[strike] the Beta site seems to be built from older team/event lists. There are teams listed on it who aren't playing, and teams who are playing who aren't listed.

I think it's taken from some other database, not an earlier list (unless it was last year's list). We show up as registered for Smoky Mountain - we were waitlisted there but cleared Bayou first so we never showed up as attending (TIMS still has a line item for SMR for us, dropped and unpaid).

[Wetzel]

When I looked two days ago, DC showed a Turkish, an Israeli, and two Brazilian teams attending. Today it shows one Israeli and one Brazilian. It is a Beta.

Wetzel

[Mark McLeod]

2536 teams now registered.
We lost a few more.

The qualifiers from this past weekend of events have started to register for Championship.
There are now 39 teams registered.

[Mark McLeod]

2534 teams registered.

128 now registered for Championships.
12.5% of them are rookie teams.

[Mark McLeod]

A few more dropped out

2531 teams now.

187 registered for the Championship.

[brrian27]

What is the max number of teams that the championship event can hold?

[Wetzel]

Originally Posted by brrian27

What is the max number of teams that the championship event can hold?

400