FRC Blogged - Share your FIRST Story, and *Preliminary* Championship Match Schedules

[Koko Ed]

Originally Posted by MechEng83

Did the same for Newton. No Auton sorting.:

8-0 Record
1538
1741

7-1 Record
79
128
180
195
829
1676
1985
2054
2252
2439

6-2 Record
68
131
225
1569
1640
1730
2612
2826
3931
3997

1986 is nowhere to be found.
This is surprising.

[Tyler Olds]

Originally Posted by Koko Ed

1986 is nowhere to be found.
This is surprising.

Yeah something seems off (though I could be reading this wrong), with 1986's matches. It shows 1986's OPR of 33.3156661987305.

[Akash Rastogi]

http://www.usfirst.org/roboticsprogr...ip-we-hear-you

Another blog post.

[MechEng83]

Originally Posted by Koko Ed

1986 is nowhere to be found.
This is surprising.

They've got some solid wins, and a few losses to stacked alliances, plus the tossups. They ended up 5-3 using Max OPR, which we all know isn't a fool-proof predictor.

[Hallry]

Originally Posted by Akash Rastogi

http://www.usfirst.org/roboticsprogr...ip-we-hear-you

Another blog post.

Chief Delphi Thread for it: http://www.chiefdelphi.com/forums/sh....php?p=1266290

[IndySam]

Originally Posted by Koko Ed

1986 is nowhere to be found.
This is surprising.

They have a wicked schedule, I have them at 4-4 with OPR.

That being said, They are strong enough that OPR predictions mean a lot less than with other teams . They will most likely be at least 7-1, their 4th match will be tough.

[Nathan Streeter]

Originally Posted by Koko Ed

1986 is nowhere to be found.
This is surprising.

Same exact thought...

[SoccerTaco]

I'm also seeing problems in the spreadsheet with the OPR ratings being populated incorrectly via the look up function.

Our team (3824) is the very first team showing up on the Curie sheet, and it shows our OPR as -2.19 rather than 45.4. The 3 red teams for that first Curie match all show the exact same OPR. Looking at additional matches, a number of teams seem to have the same OPR ratings, like the -2.19.

[Patrick Flynn]

Originally Posted by SoccerTaco

I'm also seeing problems in the spreadsheet with the OPR ratings being populated incorrectly via the look up function.
Our team (3824) is the very first team showing up on the Curie sheet, and it shows our OPR as -2.19 rather than 45.4. The 3 red teams for that first Curie match all show the exact same OPR. Looking at additional matches, a number of teams seem to have the same OPR ratings, like the -2.19.

I'm not sure what would be causing this. I'll look at it as soon as I get out of class and update it.

[Hallry]

Originally Posted by Patrick Flynn

I'm not sure what would be causing this. I'll look at it as soon as I get out of class and update it.

Thanks Pat. It seems to be occurring for many teams.

[Joe Ross]

Originally Posted by Patrick Flynn

Any recommendations for how to total the points that each team would receive and tally these other than by hand?

Write a macro You can also take a look at the formulas that MechEng83 used here: http://www.chiefdelphi.com/forums/sh...&postcount=105

I posted predicted rankings that take into account each team's auto, teleop, and climb points in each of the individual division threads.

[NXTGeek]

Originally Posted by MechEng83

Did the same for Newton. No Auton sorting.:

8-0 Record
1538
1741

7-1 Record
79
128
180
195
829
1676
1985
2054
2252
2439

6-2 Record
68
131
225
1569
1640
1730
2612
2826
3931
3997

Autonomous scoring is a rather crucial variable.

[Travis Hoffman]

Originally Posted by Patrick Flynn

I'm not sure what would be causing this. I'll look at it as soon as I get out of class and update it.

Sort the OPR page by team number, lowest first. Should fix it.

VLOOKUP likes sorted search fields.

[RyanCahoon]

Using MechEng83's spreadsheet (with some expansion), max OPR data from Ed Law and autonomous OPR data from 1114, here's what I got for Curie:

rank     team #      # wins   auto score
--------------------------------------------
1        2056        8        466.85
2        1983        8        430.31
3        67          8        311.15
4        2145        8        231.01
5        1717        7        403.16
6        1678        7        332.88
7        2130        7        296.99
8        234         7        275.4
9        1310        6        351.29
10       1622        6        295.45
11       3414        6        275.83
12       3990        6        256.39
13       862         6        247.92
14       359         6        241.92
15       2996        6        229.27
16       2936        6        228.23
17       1918        6        217.85
18       1684        6        211.52
19       1706        6        205.46
20       2062        5        231.85
21       1540        5        231.6
22       435         5        224.44
23       293         5        211.14
24       4814        5        204.84
25       1541        5        204.79
26       3061        5        201.99
27       1708        5        199.69
28       193         5        199.3
29       1923        5        193.97
30       4564        5        193.52
31       148         5        189
32       135         5        179.45
33       16          5        174.61
34       4645        5        172.24
35       1262        5        171.34
36       3753        5        168.94
37       3489        5        162.47
38       1503        5        159.25
39       540         5        145.43
40       781         5        138.32
41       4523        5        124.51
42       3539        4        219.4
43       3410        4        180.2
44       4320        4        177.73
45       233         4        174.24
46       1559        4        174.23
47       4124        4        161.37
48       2489        4        160.98
49       2638        4        156.45
50       1138        4        152.75
51       1288        4        147.57
52       3387        4        141.08
53       2383        4        140.98
54       4063        4        126.32
55       4543        4        115.41
56       4646        4        109.27
57       1939        3        142.93
58       2187        3        139.29
59       3138        3        132.3
60       4761        3        132.11
61       230         3        126.28
62       4464        3        124.54
63       967         3        118.34
64       2910        3        117.43
65       4516        3        117.17
66       2039        3        115.52
67       4667        3        114.56
68       399         3        112.71
69       4159        3        107.6
70       103         3        102.14
71       1816        3        101.52
72       2168        3        98.33
73       1735        3        98.24
74       4080        3        97.51
75       1810        3        94.96
76       3374        3        82.85
77       1421        3        75.32
78       932         2        99.19
79       4716        2        98.77
80       4488        2        98.35
81       2220        2        83.21
82       3824        2        76.78
83       3354        2        76.24
84       3660        2        75.83
85       4125        2        70.77
86       620         2        69.36
87       968         2        68.6
88       1290        2        66.02
89       4781        2        65.78
90       2836        2        60.74
91       4576        2        59.93
92       1306        2        57.43
93       2914        2        53.56
94       4091        2        47.89
95       120         2        40.82
96       4122        1        34.25
97       3239        1        32.49
98       1577        1        31
99       3926        1        29.26
100      4610        1        14.67

EDIT: I used max auto OPR to mirror the use of max OPR to decide match outcomes. Joe Ross has another version here.

[Patrick Flynn]

Originally Posted by Travis Hoffman

Sort the OPR page by team number, lowest first. Should fix it.

VLOOKUP likes sorted search fields.

It should all be up to date, if anyone sees any issues point them out.
Thanks to Brian (TheLucas) for the help.
If anyone wants anything added send a suggestion my way and i'll see what I can do.