Chief Delphi - 2013 IRI Standings Updates

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)

- Off-Season Events (http://www.chiefdelphi.com/forums/forumdisplay.php?f=20)

- - 2013 IRI Standings Updates (http://www.chiefdelphi.com/forums/showthread.php?t=117835)

Re: 2013 IRI Standings Updates

Anyone do OPR calcs yet?

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by IndySam (Post 1283600)

Anyone do OPR calcs yet?

Just did:

Code:

Team        OPR                APR                TPR                CPR

1114        101.9050397        20.6550076        48.0513343        32.54137688

118        93.38759198        20.55533833        69.30818128        3.450312731

2056        91.54054321        30.87648593        59.83839163        9.02753912

359        85.00038356        18.49508929        55.49370655        11.66388966

33        83.7233529        28.33297756        48.99602389        5.543553977

868        78.86526232        19.26972149        46.974338        9.702505813

1741        78.61490247        22.19148529        42.93706439        13.56227262

245        77.08740171        19.97899231        44.42365623        10.7148784

829        72.81617327        13.56095149        54.80786135        5.175035407

1241        72.79043797        10.4072918        44.6065987        10.03761134

1310        71.75736833        27.54036344        32.1717555        8.625160701

2338        71.5690446        16.60851286        44.00060567        13.50661275

469        68.35630605        26.74722554        41.10791433        1.791959704

67        66.58318258        14.98088031        37.21566682        15.75779776

1676        66.46668626        11.17514477        42.8934323        11.43194622

3467        65.92055554        13.11767298        32.50610755        19.13218144

11        62.61471149        13.67740635        40.72153424        10.00769244

1538        62.17722098        19.65013352        31.52247622        14.84853765

71        62.14041308        15.86183141        28.73304679        15.63404485

2252        62.12397505        11.12936346        41.71519322        10.44950079

2648        61.454905        18.59779725        34.45967593        9.218419302

1477        60.97135412        13.48638479        34.15936374        9.979878348

1503        60.91723565        19.49135248        36.49972944        6.357842626

4039        59.96553592        20.3221318        39.86837587        6.762052546

2590        59.62068033        18.62156504        34.78919599        8.16158036

987        59.06526355        9.775717452        42.14280477        8.225390748

1334        58.98082543        10.30715655        26.91815402        21.04635997

234        58.6881344        9.263318374        39.35853702        9.574622539

195        56.80348351        11.97425006        43.59739665        3.472353034

1625        56.18436916        21.89041852        30.5382551        5.689688666

111        56.17001666        21.25634346        30.81104412        7.415154603

624        55.69321463        20.55117038        30.57105158        6.059096609

3947        53.62085499        12.0453222        29.89749013        10.32966627

2826        53.40108589        15.0146621        22.77554145        14.72493132

4265        51.09854978        7.876212338        32.5970544        9.841836637

967        47.89847033        14.13350233        24.70655343        9.345902398

2468        47.83827139        19.21751139        22.52725237        3.482190975

1592        47.79159776        9.144162267        24.04949425        2.201683668

447        46.30946105        16.22982354        23.98952013        7.95681347

1640        45.92967546        15.02403114        21.42470952        10.63079105

2175        44.7409454        10.51292594        17.15443542        3.551675476

3928        44.01166146        19.38482893        19.11687328        2.029045965

1024        42.78039207        12.44617547        19.74739512        11.91062011

27        42.7763459        9.630564911        25.3142632        3.722854557

3641        42.70053267        13.57393347        20.71948236        6.282546494

148        42.60739375        9.766234538        24.72762616        10.94833843

3847        40.40111575        11.10790786        19.6666065        9.515854169

3476        40.09914983        15.96068367        16.01060642        8.753320301

1732        39.30247019        20.24363883        15.6933439        4.077560835

16        37.80008089        9.40826811        27.7334496        4.270814043

696        37.10659379        11.6678191        15.90695156        9.453664536

125        36.3728064        14.82608921        16.91470774        7.568318846

862        35.58285281        17.7144578        13.7456653        4.162472681

2451        32.43634829        11.31220735        14.8764954        9.055593197

4334        32.07868237        19.30858574        12.12145444        4.656006978

2474        31.07221252        18.78049775        11.3002069        2.744958229

3539        30.32973477        9.723239314        23.76244869        -0.766146208

303        28.82747029        17.83598159        6.024387966        2.34440332

461        27.40516282        14.83259903        8.715907484        4.800080944

48        26.303164        14.08510458        3.053275181        9.003182888

2337        24.05099835        8.443537686        13.75890002        6.684342564

4814        22.14286086        8.334935795        5.221870451        7.555477417

1902        20.52042253        1.824697497        7.593489065        8.170827387

68        19.76566451        14.86824134        9.398367495        9.817265641

20        15.65599773        3.477915122        6.061418201        2.726362961

45        15.51735339        14.75834482        -3.58400894        2.352782613

217        14.05420087        7.238589551        -2.240904164        3.270240128

116        10.32956488        7.890687234        3.586510063        3.264480001

51        7.135807968        -3.992070688        2.580446874        -1.974185313

Re: 2013 IRI Standings Updates

Match 98 video?
(Did your Mac crash again Colin?)

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by jwallace15 (Post 1283632)

Match 98 video?
(Did your Mac crash again Colin?)

I can't find match 98 on my computer, unfortunately. I must have missed it.

For the record, the reason why the match list is out of order is that some of the match videos were too long, so I cropped them manually (and thus had to postpone the upload).

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by IndySam (Post 1283600)

Anyone do OPR calcs yet?

Here are the OPR numbers I got. I don't know why Michael Ray's numbers are different. Also the sub-OPR is using the new method I proposed to take care of discrepancy due to surrogate matches, no shows and DQ'd matches.

Code:

Team #        OPR     OPR Auto OPR Climb OPR Teleop

1114        93.3        17.3        31.2        44.7

2056        92.9        28.6        8.6        55.7

118        92.8        20.4        3.2        69.2

33        86.3        29.2        6.4        50.8

359        84.7        18.2        11.4        55.0

245        78.2        20.7        11.3        46.2

1741        78.1        22.0        13.3        42.8

868        77.9        19.8        9.7        48.4

1241        74.7        12.0        11.9        50.8

829        72.1        13.2        4.8        54.0

1310        70.6        28.8        8.6        33.3

2338        70.5        15.8        12.7        42.0

1676        67.5        11.5        11.9        44.0

67        67.2        15.0        15.7        36.6

469        67.1        26.1        1.1        39.9

11        65.4        13.8        10.5        41.0

2648        64.1        18.9        10.1        35.1

1477        62.6        14.6        11.1        36.9

1503        62.2        19.3        6.6        36.3

2252        62.1        10.9        10.3        40.9

1334        62.1        10.9        22.4        28.7

71        61.5        16.2        15.9        29.3

987        60.5        10.0        8.6        41.8

1538        60.4        18.1        13.4        28.8

2590        59.2        17.9        7.7        33.5

234        58.3        9.2        9.5        39.6

4039        58.2        17.8        5.5        34.9

195        56.6        11.7        3.6        41.3

3947        55.6        12.8        11.2        31.6

111        55.4        19.9        6.7        28.7

624        54.3        19.7        5.5        29.1

1625        54.3        20.8        4.8        28.7

4265        53.7        8.7        10.9        34.1

3467        53.5        11.0        15.4        27.1

2826        53.0        15.2        14.8        23.0

967        50.5        14.6        10.1        25.8

2468        47.6        20.3        3.6        23.7

1592        47.4        12.2        2.5        32.6

3928        47.1        21.4        3.5        22.2

447        46.4        15.6        7.8        23.0

1640        45.9        14.7        10.3        20.9

2175        45.2        15.1        5.2        24.8

27        43.7        10.8        4.4        28.5

3641        43.7        14.5        7.0        22.2

1024        43.3        12.2        11.8        19.4

148        42.6        9.3        10.3        23.0

3847        40.7        11.2        9.6        19.9

3476        40.0        15.6        8.6        15.8

1732        38.6        19.7        3.8        15.1

16        38.2        8.7        4.0        25.5

862        36.9        18.1        4.5        14.3

696        35.9        11.4        9.1        15.4

125        35.2        13.5        6.6        15.1

2474        33.0        17.9        3.4        11.7

2451        32.0        10.3        8.2        13.5

3539        30.6        9.1        -0.5        22.0

461        30.1        14.7        5.6        9.8

303        29.8        19.9        2.9        7.1

48        28.9        14.5        9.8        4.6

2337        23.2        6.8        5.3        11.0

4814        22.7        8.9        8.2        5.7

4334        20.4        13.6        1.1        5.8

1902        20.3        2.1        9.4        8.7

68        18.8        8.3        5.4        5.1

20        16.2        4.6        3.7        7.9

45        15.7        15.7        2.8        -2.9

217        13.5        10.4        4.5        -1.4

116        8.6        4.9        1.8        1.9

51        8.0        0.8        0.3        6.8

Re: 2013 IRI Standings Updates

Here is the Excel file of the OPR numbers in the same format that I normally publish.

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by Ed Law (Post 1283711)

Here is the Excel file of the OPR numbers in the same format that I normally publish.

Ed thanks for putting this together. Is there something going on with the Win Margin columns? 45-69 are all the same.

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by Ed Law (Post 1283710)

I didn't remove surrogate matches and I had some issues parsing the file, so that may be the case. Also could be the method of actually solving the matrix.

Re: 2013 IRI Standings Updates

i included Michaels OPR data in the event summary i posted.

If there is a more accurate version, let me know and I will make the changes to the file.

Quote:

Originally Posted by Ed Law (Post 1283710)

Code:

Team #        OPR     OPR Auto OPR Climb OPR Teleop

1114        93.3        17.3        31.2        44.7

2056        92.9        28.6        8.6        55.7

118        92.8        20.4        3.2        69.2

33        86.3        29.2        6.4        50.8

359        84.7        18.2        11.4        55.0

245        78.2        20.7        11.3        46.2

1741        78.1        22.0        13.3        42.8

868        77.9        19.8        9.7        48.4

1241        74.7        12.0        11.9        50.8

829        72.1        13.2        4.8        54.0

1310        70.6        28.8        8.6        33.3

2338        70.5        15.8        12.7        42.0

It was an honor to get to play with and against the best teams in the world. I still can't believe we ranked 12th in OPR with so many great teams here.

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by AllenGregoryIV (Post 1283718)

Ed thanks for putting this together. Is there something going on with the Win Margin columns? 45-69 are all the same.

Thanks for catching that. The OPR numbers are correct. It turns out the spreadsheet I grabbed to do the calculations for IRI, I turned off calculating CCWM completely so those numbers were from some other events. I recalculated them and attached the new file.

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by Chris Fultz (Post 1283727)

i included Michaels OPR data in the event summary i posted.

If there is a more accurate version, let me know and I will make the changes to the file.

Chris, I am quite sure my OPR numbers are correct. The data I used was from Colin S of Team 2337. If those numbers are not correct, please send me the official result files from FMS.
I double checked my numbers using an older spreadsheet before I modified the macro to calculate the new sub-OPR numbers and they are the same, so I am even more confident now that my numbers are right. I also saw the "official" results you published on CD which is the same that I used.

Re: 2013 IRI Standings Updates

Quote:

Originally Posted by stingray27 (Post 1283726)

I didn't remove surrogate matches and I had some issues parsing the file, so that may be the case. Also could be the method of actually solving the matrix.

Michael, I think your numbers match mine before so it shouldn't be the way you solve the matrix. Also I did not change how the OPR numbers are calculated. I didn't remove surrogate matches either.

The only thing I change is how the auto OPR, teleop OPR and climb OPR are calculated. I don't know if you understand what I did based on my brief description in the other post http://www.chiefdelphi.com/forums/sh...24&postcount=4.

I will write a more detailed explanation when I have time so you can update your program to get the same results.

Re: 2013 IRI Standings Updates

Way to go Ontario!

4/8 teams in the Finals were Ontario teams, and 3 of the 4 winning teams!

Sure, two of them were the juggernauts of 1114 and 2056, but two of our second tier, 1310, and 1334 were there as well. Combined with our 2013 World Champion duo of 610/1241, and several Regional Winners on the road (1334 in ABCA, 610 in NHMA, 1075 in QCMO and more I can't think of at the moment)? Huge year for Ontario's second tier.

Re: 2013 IRI Standings Updates

I had a wonderful time at IRI, it was by far my favorite competition even though we did not win. It was a great learning experience and taught me exactly how to think about playing next years game "outside the box". I would never have gotten the opportunity if we did not get invite, it was the very first time my team was invited and we are grateful for that. I truly believe that we perform above expectations, and expect to perform a lot better in the next few years because of IRI. It was my last event as a student of Team 696, I had a blast and it was a great way to end my time as a student and begin being a mentor.