2015 MI FRC Events (and Team Stats)

Still loading...

	A	B	C	D	E	F	H	I	J	K
1			Registered	Open	Reserve	Total	349	2015 Current Total Teams

2	Week 1	Howell	38	0	2	40	269	2015 Vets	(Counts veteran teams that competed in 2014)
3	Week 1	Southfield	40	0	0	40	78	2015 Rookies	(Counts rookie teams for 2015)
4	Week 1	Standish	34	1	5	40	1	2015 Resurrected Vets	(Counts veteran teams that did not compete in 2014)
5	Week 2	Kettering	40	0	0	40	1	2015 New Vets	(Counts veteran teams that resulted from one team splitting into two teams)
6	Week 2	Kentwood	36	0	4	40
7	Week 2	Waterford	39	1	0	40	8	Missing 2014 Teams (Vets + Rookies)	(Unknown combination of waitlisted, slow to register, and not planning on returning teams)
8	Week 3	Woodhaven	33	0	7	40	97.1%	Retention 2014 to 2015	(Teams retained from 2014, does not count missing teams)
9	Week 3	Gull Lake	40	0	0	40	26.0%	Overall Growth Rate	(Overall growth rate in # of teams, does not count missing teams)
10	Week 3	Traverse City	40	0	0	40	72	Net Growth in # of Teams	(# of teams in 2015 compared to # of teams in 2014)
11	Week 4	West Michigan	40	0	0	40
12	Week 4	Great Lakes Bay	40	0	0	40	2	Missing 2014 Rookie Teams	(Rookie teams from 2014 that are missing, team numbers 4900-5399)
13	Week 4	St. Joseph	36	0	4	40	97.6%	2014 Rookie Retention	(Rookie teams retained from 2014, does not count missing teams)
14	Week 5	Center Line	40	0	0	40
15	Week 5	Escanaba	30	0	10	40	9	MI 2015 Pre-Rookies in Queue	(Potential 2015 MI rookies, not included in registration counts, pre-rookie numbers from usfirst team search)	Also, In the seven or so days I was lazy and didn't update this number jumped super high. Not sure if accurate (i.e. actual pre-rookies, or just test teams for some reason)?
16	Week 5	Livonia	40	0	0	40	370	Total 2015 Rookies	(Counts all registered 2015 rookie teams from all areas, does not count pre-rookies)
17	Week 6	Lansing	32	0	8	40	21.1%	% of Rookies from Michigan	(Percent of all 2015 rookies that are from Michigan)
18	Week 6	Bedford	10	3	27	40
19	Week 6	Troy	36	0	4	40	2919	2015 Total Teams	(All FRC teams worldwide)
20							12.0%	% of Teams from Michigan	(% of all teams worldwide from MI)
21	Accurate as of 1:50pm EST on Dec. 15		Missing Teams (never registered this year)				68.2	MI Projected Champs Spots	(Projected # of champs spots for MI teams assuming 570 total available spots, does not count 5 pre-qualified MI teams)
22			2153	3415	3509	4838
23			5197	5220			360	Team Capacity	(Based on 18 existing events)
24			Disappeared Teams (registered then dropped out)				720	Total Event Spots	(Based on 18 existing events)
25			5693	5757	5707	5609	644	Spots Claimed	(Sum of registered teams (column C) at all existing district events)
26			4382	3639			54	Spots Waitlisted	(Estimate of the # of teams on a waitlist, assuming each team is registered and/or waitlisted for two events)
27							22	Spots Open/Unclaimed	(Spots currently not claimed)
28			Numbers in blue text are those I need to update when I update the sheet. H1:H13 I copy/paste from an excel sheet that compares to 2014 teams. All other cells calculate based on those numbers.
29							366	Current Maximum Teams	(If all missing teams (cell h7) and all pre-rookies (cell h15) register)
30							-12	3rd Event Spots, Low estimate	(If all missing teams (cell h7) and all pre-rookies (cell h15) register, this assumes 18th event will exist)
31							22	3rd Event Spots, High Estimate	(If zero missing teams (cell h7) or pre-rookies (cell h15) register, this assumes 18th event will exist)
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100