MAR Rankings - 2016 - Google Sheets

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1			Google Doc created and edited by Ryan Hall. Please message						me here	of any errors. Credit to the design and formulas used in this Google Doc goes to Jack Greenbaum. Credit also given to previous work by Antonio Papa and Scott Meredith.
2	Rank	Team	First Event	Quals	Alliance Selection	Playoffs	Awards	First Event Total	Second Event	Quals	Alliance Selection	Playoffs	Awards	Second Event Total	Age Bonus	Total Points	MAR Awards	Regional or Third District (Week)?	Comments	MAR Champs	World Champs

3	1	225	SCH	21	16	30	5	72	WT	22	16	30	5	73	0	145				Registered
4	2	2590	HH	12	13	30	5	60	SEN	22	16	30	8	76	0	136	EI (SEN)	South Florida (5)	Wildcard - South Florida	Registered	Registered
5	3	1676	MO	15	7	30	10	62	BR	16	10	30	8	64	0	126	EI (BR)	Buckeye (3)	Chairman's - Buckeye	Registered	Registered
6	4	1257	MO	16	10	30	0	56	BR	22	16	20	5	63	0	119				Registered
7	5	5624	MO	15	10	30	5	60	BR	13	10	30	0	53	5	118				Registered
8	6	365	SEN	21	16	30	5	72	WT	19	15	10	0	44	0	116			HOF	Registered	Registered
9	7	1218	HH	19	13	30	8	70	SCH	16	14	10	5	45	0	115	EI (HH), CA (WT)	Westtown (5)		Registered
10	8	11	MO	19	15	0	5	39	SCH	22	16	30	8	76	0	115	EI (SCH)	South Florida (5)	Chairman's - South Florida	Registered	Registered
11	9	25	HH	22	16	10	5	53	BR	21	16	20	5	62	0	115				Registered
12	10	5895	BR	16	12	0	8	36	MG	18	12	30	5	65	10	111	RAS (BR)			Registered
13	11	56	MO	22	16	0	0	38	MG	16	12	30	5	63	0	101				Registered
14	12	193	MO	18	12	20	5	55	SCH	18	13	10	5	46	0	101		Bridgewater (5)		Registered
15	13	708	HH	16	14	0	10	40	SCH	17	15	20	5	57	0	97	CA (HH)	Westown (5)		Registered
16	14	1640	HH	10	11	10	5	36	SEN	20	15	20	5	60	0	96		Westtown (5)		Registered
17	15	834	HH	21	15	20	5	61	BR	20	15	0	0	35	0	96				Registered
18	16	341	HH	19	16	10	5	50	WT	8	11	20	5	44	0	94			HOF	Registered	Registered
19	17	4573	MO	12	5	20	0	37	SEN	16	15	20	5	56	0	93				Registered
20	18	303	MO	13	9	10	8	40	MG	22	16	10	5	53	0	93	EI (MO)	Buckeye (3)	World Champs - Waitlist	Registered	Registered
21	19	222	MO	17	11	10	5	43	MG	15	14	20	0	49	0	92				Registered
22	20	3637	MO	20	16	0	5	41	MG	21	15	10	5	51	0	92			World Champs - Waitlist	Registered	Registered
23	21	41	MO	14	12	20	0	46	MG	10	5	30	0	45	0	91				Registered
24	22	1391	HH	18	12	0	5	35	SCH	20	15	20	0	55	0	90		Westtown (5)		Registered
25	23	5404	SCH	19	14	10	5	48	WT	16	14	0	5	35	5	88			World Champs - Waitlist	Registered	Registered
26	24	6203	SEN	13	2	20	8	43	MG	5	3	20	5	33	10	86				Registered
27	25	3314	BR	15	13	10	0	38	MG	16	16	10	5	47	0	85		Buckeye (3)	Waterbury (NE, 1)	Registered
28	26	1403	MO	11	11	10	5	37	BR	17	14	10	5	46	0	83	CA (MG)	Montgomery (5)		Registered
29	27	869	SEN	14	14	10	5	43	BR	15	15	0	10	40	0	83	CA (BR)	Montgomery (6)		Registered
30	28	4454	HH	17	11	10	0	38	SCH	16	13	10	0	39	0	77				Registered
31	29	1089	SEN	19	13	10	5	47	MG	15	10	0	5	30	0	77				Registered
32	30	5407	HH	11	4	30	0	45	WT	16	10	0	0	26	5	76				Registered
33	31	1626	SEN	10	1	30	0	41	BR	18	12	0	5	35	0	76				Registered
34	32	6226	HH	20	14	0	5	39	SEN	15	11	0	0	26	10	75				Declined
35	33	5684	SEN	19	14	10	0	43	MG	17	9	0	0	26	5	74				Registered
36	34	2607	HH	15	15	20	5	55	WT	5	8	0	5	18	0	73				Registered
37	35	2016	HH	17	10	0	5	32	SEN	18	12	0	10	40	0	72		Queen City (5)		Registered
38	36	1811	MO	15	13	0	0	28	BR	19	14	10	0	43	0	71				Registered
39	37	75	MO	16	9	10	5	40	BR	14	11	0	5	30	0	70				Registered
40	38	1923	MO	21	15	0	10	46	MG	12	6	0	5	23	0	69	CA (MO)			Registered
41	39	102	SEN	17	13	10	0	40	MG	15	11	0	0	26	0	66				Registered
42	40	223	MO	13	3	0	0	16	BR	12	7	30	0	49	0	65				Registered
43	41	4954	SEN	11	7	0	0	18	WT	16	11	20	0	47	0	65				Registered
44	42	484	SCH	10	3	10	0	23	WT	13	6	20	0	39	0	62				Registered
45	43	2559	HH	15	2	20	0	37	WT	13	2	10	0	25	0	62				Registered
46	44	2234	HH	14	8	0	0	22	SCH	13	2	20	5	40	0	62		Windsor-Essex (6)		Declined
47	45	4342	SCH	14	9	0	0	23	WT	17	12	10	0	39	0	62				Registered
48	46	4653	MO	17	14	0	0	31	WT	18	13	0	0	31	0	62				Registered
49	49	5666	SEN	12	3	10	5	30	MG	9	1	10	5	25	5	60				Registered
50	48	4750	SEN	14	4	10	0	28	MG	19	13	0	0	32	0	60				Registered
51	47	5113	HH	14	12	0	5	31	SEN	17	12	0	0	29	0	60				Registered
52	50	1143	MO	13	6	10	0	29	WT	17	13	0	0	30	0	59				Registered
53	51	1647	HH	13	10	0	0	23	SEN	16	10	0	10	36	0	59				Registered
54	52	272	SCH	15	11	0	5	31	WT	9	9	0	8	26	0	57	EI (WT)	Montgomery (6)		Registered
55	53	6016	MO	14	0	0	8	22	BR	6	3	10	5	24	10	56	RAS (MO)			Registered
56	54	423	SCH	12	1	30	0	43	WT	12	0	0	0	12	0	55		Montgomery (6)	World Champs - Waitlist	Registered	Registered
57	55	5938	HH	12	0	0	8	20	SEN	12	8	0	5	25	10	55	RAS (HH)			Registered
58	56	2095	HH	16	9	0	0	25	SCH	17	12	0	0	29	0	54				Declined
59	57	1989	BR	16	9	0	0	25	MG	17	11	0	0	28	0	53				Registered
60	58	219	MO	19	14	0	0	33	SCH	9	9	0	0	18	0	51		Bridgewater (5)		Declined
61	59	5457	HH	14	9	0	0	23	SEN	14	9	0	0	23	5	51				Declined
62	60	5401	HH	12	0	0	0	12	WT	19	14	0	0	33	5	50				Registered
63	61	1712	SCH	10	7	0	5	22	WT	12	5	10	0	27	0	49				Registered
64	62	4575	SEN	10	5	0	5	20	MG	14	7	0	8	29	0	49	EI (MG)	South Florida (5)		Registered
65	63	4637	SCH	14	10	0	0	24	WT	15	9	0	0	24	0	48				Registered
66	64	1279	MO	11	8	10	0	29	SEN	11	6	0	0	17	0	46		Bridgewater (5)		Registered
67	65	3974	SCH	14	12	0	0	26	WT	10	10	0	0	20	0	46
68	66	203	HH	9	0	0	5	14	SCH	15	11	0	5	31	0	45
69	67	103	SCH	12	10	0	5	27	WT	13	0	0	5	18	0	45		Montgomery (6)	HOF		Registered
70	68	3142	MO	8	2	0	5	15	BR	10	9	0	10	29	0	44
71	69	3340	MO	12	0	0	0	12	BR	13	1	15	0	29	0	41
72	70	2191	HH	13	6	10	0	29	SEN	12	0	0	0	12	0	41
73	71	433	SCH	8	4	10	0	22	WT	14	0	0	5	19	0	41		Montgomery (6)	World Champs - Waitlist		Registered
74	72	2554	MO	18	13	0	0	31	MG	9	0	0	0	9	0	40
75	73	204	SEN	11	0	0	0	11	MG	17	10	0	0	27	0	38
76	74	5420	SEN	15	10	0	0	25	WT	6	0	0	0	6	5	36
77	75	2600	MO	12	0	0	0	12	SEN	15	9	0	0	24	0	36
78	76	5181	HH	13	0	0	0	13	WT	14	4	0	5	23	0	36
79	77	293	SCH	11	6	0	0	17	BR	12	6	0	0	18	0	35
80	78	5992	BR	9	0	0	0	9	MG	8	0	0	8	16	10	35	RAS (MG)
81	79	3929	SCH	8	8	0	0	16	WT	11	7	0	0	18	0	34
82	80	6015	MO	11	0	0	5	16	BR	8	0	0	0	8	10	34
83	81	87	HH	5	0	0	0	5	SEN	17	11	0	0	28	0	33		South Florida (5)
84	82	4361	MO	14	4	0	0	18	MG	11	4	0	0	15	0	33
85	83	486	HH	11	7	0	0	18	WT	15	0	0	0	15	0	33
86	84	2539	HH	16	5	0	0	21	WT	12	0	0	0	12	0	33
87	85	321	SCH	11	0	0	10	21	WT	8	3	0	0	11	0	32	CA (SCH)			Registered
88	86	1807	HH	9	1	10	0	20	MG	11	0	0	0	11	0	31
89	87	224	MO	10	0	0	5	15	BR	14	2	0	0	16	0	31
90	88	5438	SEN	13	0	0	0	13	MG	13	0	0	0	13	5	31
91	89	555	BR	14	0	5	0	19	MG	8	0	0	0	8	0	27
92	90	613	MO	10	1	0	0	11	BR	11	5	0	0	16	0	27
93	91	4373	SCH	6	0	0	5	11	WT	10	0	0	5	15	0	26
94	92	2729	HH	7	0	0	5	12	SEN	8	0	0	5	13	0	25
95	93	709	HH	6	0	0	0	6	SCH	13	5	0	0	18	0	24
96	94	316	SEN	9	0	0	0	9	WT	14	0	0	0	14	0	23
97	95	3515	MO	10	0	0	0	10	BR	13	0	0	0	13	0	23
98	96	714	BR	10	0	0	5	15	MG	8	0	0	0	8	0	23
99	97	5490	HH	6	0	0	0	6	WT	11	0	0	0	11	5	22
100	98	1168	SCH	11	0	0	0	11	WT	9	0	0	0	9	0	20