Registration Open - How are we doing?

[SarahB]

Originally posted by skyman9000
I'm pretty sure that as a veteran team you do not have to pay the deposit. Only rookies do.

You're right. I had assumed that everyone would need it because they were receiving part of the kit but closer reading reveals that's not true. There is one exception, however. Teams that didn't participate last year are getting the full EduBot kit so I would assume they have to pay the deposit as well.

[Dan 550]

We just registered for the J&J Mid-Atlantic in NJ. There's 12 spots left there (of 50).

[Joe Matt]

I'm betting that we hit 850 teams this year.

[Matt Leese]

Originally posted by JosephM
I'm betting that we hit 850 teams this year.

If FIRST's off-quoted growth continues (40% annually), we should hit 1120. I believe the goal for this year from FIRST was to hit 1000 teams. We may just be able to do it.

Matt

[Wetzel]

Up to 770 teams.
The first rookie team number this year appears to be 1238, or close to it. They hand out numbers in order, and 1232-1237 are not registered. Starting with 1238, the numbers are contiguous.


Wetzel
~~~~~~~~~~~
Next stop, 1100.

[Joe Ross]

according to this page: http://www.usfirst.org/robotics/2003/allteams.htm the last team last year was 1238.

[patrickrd]

The following teams were inactive last year, but are back for 2004:

350
410
546
601
995
996
1076
1080
1085

Welcome back!

- Patrick

[Andrew]

Registration has reached 868 teams!

Rookies are up to 1392-1239+1 = 154.

Teams at Championships has reach 53.

http://www.usfirst.org/frc/map/FMPro...-max=all&-find

[SarahB]

Originally posted by Andrew
Registration has reached 868 teams!

Rookies are up to 1392-1239+1 = 154.

Actually there are only 807 teams. The total on that pages includes all the teams registered for nationals twice.

[Andrew]

I thought the number of teams had jumped rather steeply. Thanks for catching the double count.

Looks like its going to get tough to track how many actual teams there are this year once second regional sign up opens in a few days.

[Karthik]

Originally posted by Andrew

Looks like its going to get tough to track how many actual teams there are this year once second regional sign up opens in a few days.

If you want to get a count minus the duplicates, copy the table into Excel and do the following.

1. Start in a new column, say E, and give E1 the value 1.
2. Give E2 the formula: IF(E2=E1,0,1)
This sets the value to 1 if it's different than what's above, and 0 if it's a duplicate.
3. Paste this formula for all valid cells in E
4. In another cell, take the entire sum of column E
5. This value should be the current number of teams signed up to at least one event.

I'm pretty sure this is not the most efficient way of doing this. If anyone is quite savvy with Excel, a more direct formula would be appreciated.

[Mike8519]

lol, they skipped over 1337. I wanted to see a team have that #

[Jeff Waegelin]

Originally posted by Mike8519
lol, they skipped over 1337. I wanted to see a team have that #

Yeah, I know... why did they do that?

[Joel J]

No need for Excel to eliminate the duplicates. FIRST does it for you.

Here is the live list for 2004:

http://www.usfirst.org/frc/map/FMPro...-max=all&-find

[Joe Matt]

Originally posted by Jeff Waegelin
Yeah, I know... why did they do that?

Same here. LETS COMPLAIN!!!