2009 Regional Registration Progress

[Andy Baker]

"You must spread some Reputation around before giving it to Mark McLeod again."

This is great stuff, Mark. Thank you for putting in the work for the rest of us.

Andy B.

[Mark McLeod]

You guys say the nicest things.

I guess I'll post some more later when registration finally settles down around March...

[Mark McLeod]

Okay, maybe I'll post sooner...

The Phillipines just added a team yesterday.
They'll be attending Hawai'i.

FRC: 3105

[ATannahill]

Can anyone see something wrong with team 3116? Maybe that their rookie year is 2008?

[Akash Rastogi]

Originally Posted by rtfgnow

Can anyone see something wrong with team 3116? Maybe that their rookie year is 2008?

hehe, good catch.

Are these put in by people? or is it some database error?

[ATannahill]

They are not entered as having attended a 2008 event, there was another team, number unknown, that was put as rookie in 2006 but didn't attend a 2006 event.

[Mark McLeod]

1679 teams are now registered.
Net gain of 178 teams or 11.9%
(My projection halfway through registration was off by 9 teams, which only demonstrates how predicable this all is if you collect data.)

Lost 163 teams or 10.86%
but gained
322 new teams, 319 of them are considered rookies. (Teams 216, 1729, and 3116 are not rookies by FIRST's definition and got fake starting years based not on when the team first played, but when their member's first played on other teams).
The rookie team numbers for this year are 2702 to 3122.

The registration chart for 1992 through 2009 is posted in the CD gallery.

With events starting registration is still settling down though. One team just dropped out. These are the final random statistics.

Location            # Missing  # new teams  Net gain/(loss) Total
CA                   18          17             (1)                  145
MI                     7           19             12                  133
NY                    6           16             10                  122
TX                     4           50             46                   91
MN                   4           31              27                  81
NJ                     6           3               (3)                  61
VA                    5           5               0                    59
Canada-ON        8           6               (2)                  57
MO                   5           8               3                    52
MA                   6           5               (1)                  52
WA                   0              24             24                  49
PA                    5           2              (3)                  49
IS                     8           17             9                    47
OK                   5           13             8                    47
IL                     1           13             12                  46
FL                    6           4                   (2)                  42
OH                   1           6               5                    41
AZ                    6           5               (1)                  37
CO                   1           5               4                    33
CT                    2           4               2                    33
IN                     0           3               3                    30
WI                    2           4               2                    29
OR                   1           6               5                    28
GA                   3           6               3                    28
NH                   2           1               (1)                  27
MD                   5           3               (2)                  26
HI                     5           4               (1)                  24
SC                    1           2               1                    23
KS                    1           0               (1)                  21
LA                    4           3               (1)                  16
DC                    1           9               8                    15
NV                    3           1               (2)                  14
MS                   3           2                   (1)                  11
NC                    1           0               (1)                  11
ID                     2           3               1                    9
TN                    0              4               4                    7
AL                    0           3               3                    7
ME                   0           1               1                    7
PR                    6           2               (4)                  6
Brazil                9           1               (8)                  6
UT                    0           2               2                    5
ND                    0           0               0                    5
KY                    0              3               3                    4
NM                   1           1               0                    4
WV                   1           1               0                    4
AK                    0           0               0                    3
Canada-QC        1           1               0                    3
IA                     0           0               0                    3
VT                    0           0               0                    3
MT                    1           0                   (1)                  3
United Kingdom  2           0               (2)                  3
DE                    0           0                   0                    2
Mexico              0           0               0                    2
RI                     0           0               0                    2
WY                   0           0               0                    2
Canada-BC        1           0               (1)                  2
Germany           0           1               1                    1
Turkey               0              1               1                    1
Philippines         0           1               1                    1
AR                    0           0               0                    1
Chile                 0           0               0                    1
Netherlands       0           0               0                    1
AB                    1           0               (1)                  1
NE                    1           0               (1)                  0
SD                    1           0               (1)                  0

21 Resurrected teams

• (10) sat out one year
• (9) sat out two years
• (1) sat out three years
• (1) sat out four years

FRC is represented by 11 countries:

• USA
• Canada
• Brazil
• Israel
• Chile
• Mexico
• United Kingdom
• Turkey
• Germany
• Netherlands
• Philippines

FRC has no teams in Nebraska or South Dakota this year.

[Mark McLeod]

I suppose it never ends.
Team registration lost a rookie, and then there were 1678 teams.

Here's that registration chart:


It's also buried in the CD photos: http://www.chiefdelphi.com/media/photos/33124

I'll post the spreadsheet as a white paper when I get time.

[Mark McLeod]

And then there were 1677 teams...

[Chris Fultz]

Mark,

Is the spreadsheet that supports the plot available somewhere, and would you be willing to share it?

My team is presenting at the CHP forums on team continuity planning, and this data would help them. Maybe just data for the last few years of -

"Starting Number" "New Teams" "Lost Teams" "Net Gain"

[Mark McLeod]

Is this the kind of summary data you're looking for?
The original spreadsheet(s) are too large to upload here.
If you need data further back or different just let me know and I'll get you what I've got.

"New teams" include both rookies and those that FIRST doesn't consider rookies, but are newly formed teams none the less.

P.S.
See if this summary that DarkJedi613 produced last year is of any use.
It's a page with # of rookies for each year and retention rates. The row is the year you're looking at (i.e. the row 2006 refers to the 2006 season). Then each column is the number of teams (out of the original # of teams) that participated in that season. So for row 2006, column 2000: then 271 of the 372 teams from the 2000 season also participated in the 2006 season for a rentention rate of 72.849%.
http://www.team358.org/files/team_lo..._teams.php.htm

[Mark McLeod]

I made a pass going through and cleaning up this summary data from how many teams drop out, how many come back, etc.
I liked Chris's approach to charting that data, so I've done the same with some variation.

I correlated team lists from 1992 onwards (early years from the Team 45 TechnoKats history project) and treated the teams as returned if the same high school or equivalent was involved. There are cases of teams splitting off into different team numbers that I haven't decided how to account for, so right now a new team number is treated as a new team, even for those few teams that just had their number changed for unknown reasons from one year to the next, e.g., Bay Shore HS in 1998, and 1999.
I also haven't walked the early teams all the way up to the present to catch those that returned 10 years later.


I'm hopeful we'll soon have the full spreadsheets posted on our website for others (all eight of you ) to play with, use, and improve upon.

P.S.
You'll see that the total teams for several years are one or two off from FIRST's published totals. I decided to use totals supported by corresponding team lists to avoid counting teams that dropped out before actually competing. Some of FIRST's team totals appear to be propagated from tally's taken before team registration settled out, e.g., for 2009 FIRST listed 1686 teams because the count was from early January, but only 1677 teams were around for actual competition.

I also plan to update the pre-1998 team rookie year's. The current one's listed for the early year's are incomplete, possibly because FIRST had different early rules that defined when a team was "new." I'm just going to go by if the same educational institution (or equivalent) was involved. Originally FIRST identified teams and team continuity by the corporation or business that sponsored them, so my approach will yield different results for the 1990's.