Re: 2009 Regional Registration Progress
 

"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.

Re: 2009 Regional Registration Progress
 

You guys say the nicest things.:)

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

Re: 2009 Regional Registration Progress
 

Okay, maybe I'll post sooner...

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

FRC: 3105

Re: 2009 Regional Registration Progress
 

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

Re: 2009 Regional Registration Progress
 

hehe, good catch.

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

Re: 2009 Regional Registration Progress
 

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.

Re: 2009 Regional Registration Progress
 

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.



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.

Re: 2009 Regional Registration Progress
 

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.

Re: 2009 Regional Registration Progress
 

And then there were 1677 teams...

Re: 2009 Regional Registration Progress
 

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"

Re: 2009 Regional Registration Progress
 

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

Re: 2009 Regional Registration Progress
 

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.