2017 MI Event & Team Stats

Still loading...

	A	B	C	D	E	F	H	I	J	K	L
1	Updated: Jan. 1 1:02pm		Registered	Open	Reserve	Total

2	Week 1	Lakeview	40	0	0	40	454	2017 MI All Teams Total		Nov-21	Payment deadline
3	Week 1	Kettering 1	40	0	0	40	392	2017 MI Veteran Teams		Jan-3	Today
4	Week 1	Southfield	40	0	0	40	61	2017 MI Rookie Teams		-43	Days until deadline
5	Week 2	Ann Arbor Pioneer	40	0	0	40	0	2017 MI Resurected Vets	<-- I have to remember how to do conditional formatting for duplicate values in google sheets and/or calculate somehow
6	Week 2	Center Line	40	0	0	40	1	2017 MI New Vets	<-- I have to remember how to do conditional formatting for duplicate values in google sheets and/or calculate somehow
7	Week 2	Kettering 2	41	0	-1	40
8	Week 2	St. Joseph	40	0	0	40	411	2016 MI All Teams Total
9	Week 3	Escanaba	37	0	3	40	19	Missing Teams (played in 2016, not registered for 2017)
10	Week 3	Gaylord	39	0	1	40	95.38%	2016 to 2017 Overall retention rate
11	Week 3	Gull Lake	40	0	0	40	10.46%	2016 to 2017 Net growth
12	Week 3	Waterford	40	0	0	40
13	Week 4	West Michigan	40	0	0	40	2	Missing 2nd year teams (2016 rookies)
14	Week 4	Woodhaven	40	0	0	40	97.18%	2nd Year Team Retention Rate (from 2016-2017)
15	Week 4	Lansing	40	0	0	40	7	Missing 3rd year teams (2015 rookies)
16	Week 4	Midland	40	1	-1	40	90.91%	3rd Year Team Retention Rate (from 2016-2017)
17	Week 5	Howell	40	0	0	40	8	Missing 4th year teams (2014 rookies)
18	Week 5	East Kentwood	39	0	1	40	89.47%	4th Year Team Retention Rate (from 2016-2017)
19	Week 5	Lake Superior State	36	2	0	40	2	Missing 5th+ Year teams (2013 & earlier rookies)
20	Week 5	Troy	40	0	3	40	98.93%	5th+ Year Team Retention Rate (from 2016-2017)
21	Week 6	Livonia	40	0	0	40
22	Week 6	Marysville	37	0	3	40	3363	2017 total teams worldwide
23	Week 6	Shepherd	31	0	9	40	13.5%	% of Teams from Michigan
24	Week 6	Traverse City	40	0	0	40	79	MI Projected Champs Spots	<-- Unfortunately allocation isn't related to total teams worldwide anymore :/ (if it were MI would have 100+ spots)
25
26							460	Total FiM Team Capacity	<-- Red indicates an additional event is needed to accommodate team capacity
27							920	Total FiM Event Spots
28							900	FiM Event Spots Claimed
29							20	FiM Event Spots Remaining (open & reserve)
30							8	# of teams without a second event (ish)
31							0	Additional events needed to accommodate registered teams
32
33
34
35		Link to Alternate Event List
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