paper: 2014 MI State Championship Pre-Event Data

CD-Media: Papers
, , ,
1

Thread created automatically to discuss a document in CD-Media.

2014 MI State Championship Pre-Event Data
by: stingray27

Data for the Michigan State Championship regarding past event data, predicted match scores and breakouts based on the event schedule, and predicted rankings based on predicted scores.

Here is a bunch of data regarding predicted results of the 2014 Michigan State Championship.

All data is based on my Week 6 2014 OPR data paper

As stated in the summary, this excel sheet has a breakout of each match for this weekends tournament and uses the predicted match results to predict the final rankings

In addition, it can act as a scout sheet for drivers because it has a sheet where you can input a team number and look at the matches that team plays in.

2014micmp.xlsx (119 KB)

The match schedule is out for 2014 Michigan State Championship this weekend. This paper has a bunch of data regarding the tournament and the weight of the match schedule, etc.

2

It looks like you used best event OPR? Here is what I get using World OPR.

Rank	Team	Wins	Losses	Ties	Matches	QP	Auto	Teleop	Truss	Assist
1	3539	11	1	0	12	22	692	681	353	804
2	1718	11	1	0	12	22	632	920	424	623
3	67	10	2	0	12	20	590	849	341	706
4	2959	10	2	0	12	20	512	697	329	649
5	1918	9	3	0	12	18	574	646	356	714
6	548	9	3	0	12	18	593	533	338	674
7	469	9	3	0	12	18	634	546	355	641
8	862	9	3	0	12	18	596	685	278	483
9	70	8	3	1	12	17	506	610	396	681
10	1023	8	4	0	12	16	591	604	336	812
11	33	8	4	0	12	16	568	635	312	725
12	3688	8	4	0	12	16	555	546	343	723
13	27	8	4	0	12	16	596	658	369	705
14	5162	8	4	0	12	16	513	577	381	654
15	314	8	4	0	12	16	536	476	335	618
16	4819	8	4	0	12	16	456	544	235	601
17	4362	8	4	0	12	16	540	626	376	588
18	2960	8	4	0	12	16	557	659	324	568
19	2137	7	5	0	12	14	596	549	369	754
20	68	7	5	0	12	14	583	410	292	697
21	51	7	5	0	12	14	473	761	250	643
22	494	7	5	0	12	14	578	375	379	623
23	2834	7	5	0	12	14	511	501	280	618
24	3618	7	5	0	12	14	456	475	291	611
25	107	7	5	0	12	14	436	694	351	604
26	857	7	5	0	12	14	587	495	366	595
27	910	7	5	0	12	14	629	409	272	591
28	4003	7	5	0	12	14	499	614	325	588
29	2771	7	5	0	12	14	571	660	285	577
30	74	7	5	0	12	14	461	631	352	575
31	3620	6	5	1	12	13	603	589	238	562
32	4967	6	6	0	12	12	552	443	247	673
33	3534	6	6	0	12	12	554	530	334	626
34	2619	6	6	0	12	12	444	468	288	601
35	453	6	6	0	12	12	404	636	358	580
36	3641	6	6	0	12	12	476	528	343	576
37	2337	6	6	0	12	12	779	493	183	573
38	3098	6	6	0	12	12	465	743	312	573
39	1506	6	6	0	12	12	396	450	213	568
40	308	6	6	0	12	12	557	572	300	553
41	2054	6	6	0	12	12	496	674	314	533
42	1189	5	7	0	12	10	406	408	283	620
43	245	5	7	0	12	10	604	623	338	608
44	3602	5	7	0	12	10	396	508	303	587
45	503	5	7	0	12	10	502	413	306	549
46	1250	5	7	0	12	10	497	387	299	467
47	3175	4	7	1	12	9	508	546	283	565
48	815	4	7	1	12	9	485	488	259	535
49	4956	4	7	1	12	9	407	518	207	489
50	4391	4	8	0	12	8	472	397	312	653
51	3322	4	8	0	12	8	664	438	311	583
52	3667	4	8	0	12	8	316	354	236	535
53	3604	3	9	0	12	6	413	427	261	547
54	573	3	9	0	12	6	444	605	337	505
55	4988	3	9	0	12	6	477	343	251	499
56	2851	3	9	0	12	6	391	501	240	497
57	5193	3	9	0	12	6	419	456	188	475
58	2474	2	9	1	12	5	347	473	249	576
59	1711	2	10	0	12	4	558	498	259	542
60	4779	2	10	0	12	4	362	505	240	483
61	3548	2	10	0	12	4	459	435	266	444
62	280	1	11	0	12	2	376	461	211	471
63	5053	0	12	0	12	0	399	388	178	470
64	2604	0	12	0	12	0	259	340	212	417


Match	Red 1	Red 2	Red 3	Blue 1	Blue 2	Blue 3	Rscore	Bscore
1	70	2960	74	51	67	2851	206	204
2	3534	3620	2619	2137	5162	453	159	191
3	1711	2604	1918	548	4391	910	118	160
4	3548	27	503	494	68	314	170	178
5	573	3539	857	245	107	4956	209	156
6	2474	4003	3667	1189	33	3604	99	165
7	3618	280	2959	2054	4779	815	142	117
8	2337	4819	3641	1506	308	4988	168	94
9	469	4362	3098	1023	3688	2771	210	199
10	3322	2834	5053	1250	5193	4967	126	127
11	3175	3602	107	1718	862	314	163	222
12	453	1918	2054	1189	3667	4956	185	71
13	3618	2337	815	2604	573	74	161	118
14	3098	27	4779	67	4819	3539	188	231
15	3604	4967	3688	1711	857	3641	172	143
16	548	2960	1718	4003	3548	4988	221	122
17	3322	308	3620	2959	2834	1023	174	190
18	5162	469	3175	5193	68	280	192	104
19	2619	2137	494	2851	4391	1506	194	94
20	503	910	1250	70	33	3602	144	205
21	5053	2771	245	862	2474	51	127	158
22	4362	2054	1718	3534	3618	3604	231	154
23	1711	4988	5162	3322	3667	314	131	142
24	3620	74	1918	4779	2619	3641	200	121
25	1023	3539	815	1250	2851	494	199	135
26	2834	1506	910	4956	51	280	124	113
27	4003	27	2959	68	2137	107	223	216
28	4362	503	3602	2474	2604	4819	145	64
29	2771	70	857	3548	5193	453	195	104
30	245	67	3534	33	548	469	214	215
31	573	4391	4967	862	308	2960	161	169
32	1189	3098	3688	3175	5053	2337	176	138
33	4988	3667	503	74	2959	4956	91	152
34	68	2604	3602	1506	857	494	93	136
35	3641	2771	2834	4819	33	2619	156	168
36	70	4391	280	3618	453	314	146	152
37	5162	815	3604	308	245	3688	138	178
38	548	27	3175	573	2054	2474	195	143
39	862	3548	3322	51	469	3539	159	249
40	3534	107	1918	5193	2337	2960	216	172
41	2137	1718	1023	4779	5053	4967	263	94
42	3620	4003	4362	2851	1711	3098	179	138
43	1250	67	308	910	1189	857	181	154
44	314	2474	2959	3641	494	51	154	192
45	2337	68	548	453	70	3539	185	220
46	3688	4391	74	33	1718	4956	177	212
47	2960	4779	2137	1711	503	3322	173	149
48	2619	1189	4988	245	469	910	111	199
49	107	3548	280	1023	3098	67	126	238
50	3534	3602	2771	815	4967	27	152	182
51	1918	5162	4819	5053	2054	2851	185	105
52	3604	3667	5193	1506	3620	1250	89	109
53	4003	2604	3618	862	3175	2834	113	155
54	4362	67	3641	573	245	453	211	157
55	2474	2337	70	1711	1023	469	185	184
56	1918	2959	3539	3602	5162	1718	250	208
57	2771	308	1189	280	4988	494	141	114
58	314	5193	4779	3098	2054	4003	114	191
59	3667	74	107	5053	3548	4391	152	88
60	4362	2619	857	3322	3175	815	163	149
61	2851	862	3620	3534	503	33	148	189
62	573	51	2137	2604	1250	3604	216	81
63	1506	3688	548	27	2960	2834	137	203
64	4956	4967	910	3618	68	4819	141	146
65	4003	5193	2619	280	2337	3602	134	133
66	494	4779	4391	3175	70	3534	136	190
67	3548	469	815	503	3641	1918	139	179
68	862	4988	3539	2474	1189	2137	186	146
69	2960	3667	453	4819	1718	245	119	204
70	107	2851	2604	3688	4956	3322	110	159
71	51	308	3618	67	3620	1711	176	188
72	5053	33	910	548	4362	2959	158	186
73	314	27	1023	3604	857	2834	223	146
74	1250	573	68	2771	2054	74	148	180
75	1506	3098	453	5162	4967	503	126	169
76	4956	70	815	3620	2474	3175	132	132
77	33	3548	2604	3618	1189	2960	119	152
78	4362	245	494	280	2834	1918	188	147
79	3322	4391	1023	2054	67	3602	187	195
80	3098	2959	5053	469	4003	857	151	192
81	51	3604	4779	68	3688	4988	143	156
82	3539	1506	3667	573	2771	910	127	175
83	1718	2851	74	5193	308	27	200	172
84	4967	2137	4819	314	107	548	182	186
85	5162	1250	862	2337	1711	2619	160	157
86	3641	4988	70	3534	2604	5053	165	69
87	68	3539	3620	4362	280	2960	209	144
88	469	453	494	4003	3604	74	183	163
89	3602	4779	4956	308	548	2137	82	185
90	2054	3618	503	2619	51	107	160	195
91	857	27	862	3641	3667	5162	207	132
92	3534	1189	1023	573	314	1506	166	129
93	1711	3175	1250	2959	3548	4819	122	141
94	67	3688	5193	2474	4967	1918	197	166
95	2851	910	815	3098	4391	2834	125	163
96	33	2337	245	2771	1718	3322	224	232
97	2137	2054	862	70	4362	308	205	193
98	280	74	4819	857	3534	2959	117	185
99	2619	5053	314	3539	3688	2960	112	230
100	4988	3098	3618	1918	27	1250	154	212
101	33	453	1711	815	494	107	162	171
102	2474	245	2851	4779	2337	3548	118	135
103	4967	1718	1506	2604	469	3620	180	135
104	3175	5193	3641	1023	3667	910	133	149
105	2771	4956	503	4003	67	5162	122	220
106	51	2834	68	3602	1189	4391	177	119
107	548	573	3548	3604	3322	2619	140	156
108	4967	2054	1711	3539	74	245	156	218
109	3667	469	4819	2604	815	2137	130	116
110	67	1506	107	3175	4988	4362	187	144
111	51	910	3602	453	3688	3534	174	169
112	4391	2337	314	27	3620	5053	182	160
113	1189	494	3322	3641	1718	3098	170	228
114	2834	33	5162	70	4779	573	198	163
115	1250	280	857	2851	548	503	111	130
116	1023	308	2474	1918	68	4003	145	196
117	2960	3604	4956	2771	2959	862	126	186
118	5193	4819	4988	3618	4391	3539	100	196
119	3548	2054	494	910	3620	2337	159	197
120	1711	3688	1718	573	503	280	211	119
121	51	1189	815	4967	548	1023	141	183
122	469	4956	314	4779	1250	4362	155	125
123	3641	3604	5053	2851	3618	3602	105	123
124	308	3534	68	3667	2619	3098	161	129
125	67	2959	453	2604	5193	862	208	90
126	74	2474	2834	2960	5162	107	133	204
127	2137	3175	857	2771	33	1918	191	225
128	245	4003	3322	70	27	1506	188	190
3

Yes, I used the best event OPR for a given team. The sub-OPRs are based on that individual event for the team as well.

Is your data with or without penalties?

4

With penalties.

5