team-event numbers

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Area	Teams in 2016	CMP alloc./600	2016 CMP teams	ratio	CMP alloc./800	Events Needed	2016 Events	2016 Spots	Spots/Team	Spots/Event	2017 Events	2017 Spots	Spots/Team	District	133	145
2	MI	411	78.79	86	1.09	105.05	20.55	21	845	2.056	40.238	21?	845	2.055961071	Regional	21
3	CA	258	49.46	54	1.09	65.94	12.90	7	384	1.488	54.857	8?	424	1.643410853	No Events	8
4	MN	208	39.87	24	0.60	53.16	10.40	4	246	1.183	61.500	4?	246	1.182692308		4
5	NE	182	34.89	44	1.26	46.52	9.10	10	380	2.088	38.000	10?	380	2.087912088		10
6	PNW	158	30.29	35	1.16	40.38	7.90	9	336	2.127	37.333	9?	336	2.126582278		9
7	NY	150	28.75	27	0.94	38.34	7.50	4	203	1.353	50.750	5?	233	1.553333333		5
8	TX	141	27.03	26	0.96	36.04	7.05	4	223	1.582	55.750	6?	323	2.290780142		6
9	Ontario	137	26.26	30	1.14	35.02	6.85	5	213	1.555	42.600	9?	360	2.627737226		9
10	Chesapeake	132	25.30	28	1.11	33.74	6.60	7	267	2.023	38.143	7?	267	2.022727273		7
11	MAR	121	23.19	30	1.29	30.93	6.05	7	260	2.149	37.143	7?	260	2.148760331		7
12	MO	73	13.99	20	1.43	18.66	3.65	2	108	1.479	54.000	2?	108	1.479452055		2
13	FL	70	13.42	15	1.12	17.89	3.50	2	123	1.757	61.500	2?	123	1.757142857		2
14	GA	65	12.46	13	1.04	16.61	3.25	4	139	2.138	34.750	4?	139	2.138461538		4
15	Israel	62	11.88	7	0.59	15.85	3.10	1	63	1.016	63.000	4?	160	2.580645161		4
16	OH	58	11.12	10	0.90	14.82	2.90	2	115	1.983	57.500	2?	115	1.982758621		2
17	IL	58	11.12	15	1.35	14.82	2.90	2	92	1.586	46.000	2?	92	1.586206897		2
18	Mexico	53	10.16	8	0.79	13.55	2.65	1	57	1.075	57.000	2?	100	1.886792453		2
19	NC	52	9.97	11	1.10	13.29	2.60	4	122	2.346	30.500	4?	122	2.346153846		4
20	OK	51	9.78	4	0.41	13.04	2.55	1	64	1.255	64.000	1?	64	1.254901961		1
21	AZ	50	9.58	11	1.15	12.78	2.50	2	103	2.060	51.500	2?	103	2.06		2
22	IN	49	9.39	11	1.17	12.52	2.45	3	110	2.245	36.667	3?	110	2.244897959		3
23	WI	48	9.20	9	0.98	12.27	2.40	1	60	1.250	60.000	2?	110	2.291666667		2
24	Quebec	45	8.63	7	0.81	11.50	2.25	1	50	1.111	50.000	1?	50	1.111111111		1
25	SC	43	8.24	3	0.36	10.99	2.15	1	64	1.488	64.000	1?	64	1.488372093		1
26	Australia	39	7.48	6	0.80	9.97	1.95	1	55	1.410	55.000	2?	100	2.564102564		2
27	CO	36	6.90	6	0.87	9.20	1.80	1	54	1.500	54.000	1?	54	1.5		1
28	China	34	6.52	3	0.46	8.69	1.70	0	0	0.000	---	1?	0	0		1
29	LA	34	6.52	3	0.46	8.69	1.70	1	57	1.676	57.000	1?	57	1.676470588		1
30	TN	34	6.52	7	1.07	8.69	1.70	1	50	1.471	50.000	1?	50	1.470588235		1
31	W PA	28	5.37	6	1.12	7.16	1.40	1	52	1.857	52.000	1?	52	1.857142857		1
32	HI	26	4.98	5	1.00	6.65	1.30	1	42	1.615	42.000	1?	42	1.615384615		1
33	KS	22	4.22	2	0.47	5.62	1.10	0	0	0.000	---	0?	0	0		0
34	UT	21	4.03	4	0.99	5.37	1.05	1	54	2.571	54.000	1?	54	2.571428571		1
35	Alberta	21	4.03	4	0.99	5.37	1.05	1	48	2.286	48.000	1?	48	2.285714286		1
36	Turkey	20	3.83	2	0.52	5.11	1.00	0	0	0.000	---	0?	0	0		0
37	AR	17	3.26	6	1.84	4.35	0.85	1	62	3.647	62.000	1?	62	3.647058824		1
38	ID	15	2.88	2	0.70	3.83	0.75	1	45	3.000	45.000	1?	45	3		1
39	KY	13	2.49	1	0.40	3.32	0.65	0	0	0.000	---	0?	0	0		0
40	AL	12	2.30	2	0.87	3.07	0.60	1	54	4.500	54.000	1?	54	4.5		1
41	IA	11	2.11	3	1.42	2.81	0.55	1	63	5.727	63.000	1?	63	5.727272727		1
42	MS	9	1.73	1	0.58	2.30	0.45	0	0	0.000	---	0?	0	0		0
43	NV	9	1.73	1	0.58	2.30	0.45	1	49	5.444	49.000	1?	49	5.444444444		1
44	Brazil	6	1.15	2	1.74	1.53	0.30	0	0	0.000	---	0?	0	0		0
45	NM	5	0.96	0	0.00	1.28	0.25	0	0	0.000	---	0?	0	0		0
46	WV	4	0.77	1	1.30	1.02	0.20	0	0	0.000	---	0?	0	0		0
47	WY	4	0.77	2	2.61	1.02	0.20	0	0	0.000	---	0?	0	0		0
48	United Kingdom	3	0.58	0	0.00	0.77	0.15	0	0	0.000	---	0?	0	0		0
49	ND	3	0.58	1	1.74	0.77	0.15	0	0	0.000	---	0?	0	0		0
50	Taiwan	3	0.58	1	1.74	0.77	0.15	0	0	0.000	---	0?	0	0		0
51	SD	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
52	Japan	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
53	Netherlands	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
54	Chile	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
55	Saskatchewan	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
56	Dominican Republic	2	0.38	0	0.00	0.51	0.10	0	0	0.000	---	0?	0	0		0
57	MT	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
58	NE	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
59	Singapore	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
60	Germany	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
61	Bosnia-Herzegovina	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
62	Ecuador	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
63	Colombia	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
64	PR	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
65	British Columbia	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
66	Denmark	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
67	France	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
68	India	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
69	Poland	1	0.19	0	0.00	0.26	0.05	0	0	0.000	---	0?	0	0		0
70	Czech Republic	1	0.19	1	5.22	0.26	0.05	0	0	0.000	---	0?	0	0		0
71
72
73
74
75	South	119	22.81	20	0.88	30.42	5.95	5	272	2.286	54.400	4?	272	2.285714286
76	Mountains	91	17.44	14	0.80	23.26	4.55	3	147	1.615	49.000	4?	147	1.615384615
77	Ohio River	90	17.25	23	1.33	23.00	4.50	3	144	1.600	48.000	3?	144	1.6
78	Plains	6	1.15	0	0.00	1.53	0.30	0	0	0.000	---	0?	0	0
79		97	18.59	14	0.75	24.79	4.85	3	147	1.515	49.000	4?	147	1.515463918
80	PNW
81	CA
82	AZ
83
84	TX
85	OK
86	KS
87
88	MN
89	IA
90	MO
91
92	WI
93	IL
94
95	MI
96	IN
97
98	FL
99	GA
100	SC