What can FIRST do to increase FRC team sustainability?

[jgerstein]

Originally Posted by Ian Curtis

What years are FRC teams most likely to fail? I would guess something like years 2 & 5, but I'd love to know the actual answer. Can someone generate those numbers real quick?

I was curious about this too, so I pulled some data from TBA. A few teams show up a year or two before their rookie year because of off-seasons, but not enough to have a major effect on the numbers.

The last two tabs are the raw data I pulled from TBA and an expanded table showing which years each team was active in.

Team Survival

Sheet 1 (% of active teams by rookie year): Each row represents a rookie year (there were no 1993 rookies, so I left 1993 out). Each column is a year from 1992 through 2016. Each cell contains the percent of teams from that rookie year that were active in the given year. For example: Cell V12 indicates that in 2011, 45% of the teams that were founded in 2004 were still active.

Sheet 2 (# of active teams by rookie year): Each row represents a rookie year (there were no 1993 rookies, so I left 1993 out). Each column is a year from 1992 through 2016. Each cell contains the number of teams from that rookie year that were active in the given year. For example: Cell V12 indicates that in 2011, 75 of the 403 teams that were founded in 2004 were still active.

The other sheets are not particularly useful for looking at directly.