OPR after Week Three Events

[quad]

Originally Posted by Ed Law

Does anybody know the score of qualification match 72 at New York? It affects teams' OPR because I temporarily put in 0-0 to do the calculations.

The twitter feed says 119 for red and 46 for blue

[ahartnet]

Ed,

First off, this is an impressive collection of VBA scripts!

Second - when I try to run the refresh data script, I get an error, something about runtime error ' 13' Type mismatch.

I opened v3.0, go to the Dallas page, as thats the one I'm interested in, and make sure that I enable macros and a data connection. When I hit ctrl-shift-P it starts doing a lot of stuff but then stops at that error. When I run the step into the command and do it line by line, it seems it's because it's going through the teams list (which is blank at the time) until it hits the word "match" in C353.

Any tips? Am I missing a step? I don't see anything else suggested in the instructions page.

Thanks!
Andrew

[Ed Law]

Originally Posted by ahartnet

Ed,

First off, this is an impressive collection of VBA scripts!

Second - when I try to run the refresh data script, I get an error, something about runtime error ' 13' Type mismatch.

I opened v3.0, go to the Dallas page, as thats the one I'm interested in, and make sure that I enable macros and a data connection. When I hit ctrl-shift-P it starts doing a lot of stuff but then stops at that error. When I run the step into the command and do it line by line, it seems it's because it's going through the teams list (which is blank at the time) until it hits the word "match" in C353.

Any tips? Am I missing a step? I don't see anything else suggested in the instructions page.

Thanks!
Andrew

I am not sure what you are trying to do. While this can be used as a predictive tool in terms of match results, projected ranking at the end of qualifying round etc., it needs data to start. It is not that good a predictive tool when the match schedule has not come out yet. Try to run the macro again after each team has at least played 3 matches. Otherwise you may get an error saying insufficient data or something like that due to the ill condition of the matrix. For the OPR numbers to be meaningful, you need at least 4 to 5 matches completed for each team. I think some people have done that study so others please chime in.

[Ed Law]

Originally Posted by quad

The twitter feed says 119 for red and 46 for blue

Thanks. Do you know why the match score was not shown? Did they replay that match?

[prismiko]

Originally Posted by Ed Law

Thanks. Do you know why the match score was not shown? Did they replay that match?

Nope - match 72 was not replayed. The recording is here - http://www.ustream.tv/recorded/29852971

[Racer26]

Heh. OPR After week 4 events, *all of waterloo shoots to the top*

[~Cory~]

Originally Posted by Racer26

Heh. OPR After week 4 events, *all of waterloo shoots to the top*

Have you seen whats happening at Wisconsin?

[Tristan Lall]

Originally Posted by ~Cory~

Have you seen whats happening at Wisconsin?

As of now, Waterloo's mean winning score (109) is 35 points higher than Wisconsin's, and the median winning score (96) is 23 points higher. The losing scores are also slightly higher.

[Racer26]

Furthermore, Wisconsin's highest OPR is approximately 50% of waterloos top 2 oprs.

I see nothing terribly notable about Wisconsin. Waterloo is having possibly the deepest FRC event that's ever happened outside of MSC or IRI.

[snowmobiler9]

My buddy wasn't comparing waterloo to wisconsin. He was just asking about wisconsin's data.

Originally Posted by Racer26

Waterloo is having possibly the deepest FRC event that's ever happened outside of MSC or IRI.

But one thing I would refrain from would be to say that waterloo is the "deepest" regional. Out of all the matches that broke 100 points, 2/3's of them had one of the top three seeded teams on it: 1114, 610, or 2056.

Also, with such a low number of teams, the top three teams inflate the average OPR data.

[Racer26]

They're actually not artificially inflating the OPR of the other teams as they normally would be, thanks to the 277 point match.

Can any other event say that it has 14 teams, or nearly half the teams there with OPR > 20. Yes, the 3 strongest account for most of the biggest scores, but you would expect that. With 64 matches and 32 teams, 1 of the 3 will be in about 50% of the matches. Just because the deepest end of the pool is really deep, doesn't make the remainder any less deep. Any of Waterloo's top 10 would have been a top 3 at Montreal last week.

[scottandme]

Originally Posted by Racer26

They're actually not artificially inflating the OPR of the other teams as they normally would be, thanks to the 277 point match.

Can any other event say that it has 14 teams, or nearly half the teams there with OPR > 20. Yes, the 3 strongest account for most of the biggest scores, but you would expect that. With 64 matches and 32 teams, 1 of the 3 will be in about 50% of the matches. Just because the deepest end of the pool is really deep, doesn't make the remainder any less deep. Any of Waterloo's top 10 would have been a top 3 at Montreal last week.

By that metric (OPR >20), the West Michigan District even is stronger than Waterloo (23/40 teams) and Grand Blanc is about the same (17/40). Not to take anything away from Waterloo of course, but most District events have been in the same neighborhood by that comparison.

[Jonathan Norris]

Originally Posted by snowmobiler9

But one thing I would refrain from would be to say that waterloo is the "deepest" regional. Out of all the matches that broke 100 points, 2/3's of them had one of the top three seeded teams on it: 1114, 610, or 2056.

Also, with such a low number of teams, the top three teams inflate the average OPR data.

Tell that to: 1310, 1334, 4039, 1241, 772, 2702, 2852, 3683, 3161, and others...

This was the highest quality FRC Regional i've ever seen, all of those teams listed would do well on a field at championship. The field of 32 teams at Waterloo was historically deep, we got a robot that could do 3+ cycles a match with the 23rd pick, 1114/2056 got a long range shooter with the 24th pick, I call that depth.

At most regionals during qualifications the event can get a little monotonus with a couple poor matches in a row. At Waterloo there was rarely any slow matches during qualifications, everyone in the stands were engaged, I even saw arena staff and regular Waterloo students getting into the games during qualifications.

[efoote868]

Originally Posted by Jonathan Norris

Tell that to: 1310, 1334, 4039, 1241, 772, 2702, 2852, 3683, 3161, and others...

This was the highest quality FRC Regional i've ever seen, all of those teams listed would do well on a field at championship. The field of 32 teams at Waterloo was historically deep, we got a robot that could do 3+ cycles a match with the 23rd pick, 1114/2056 got a long range shooter with the 24th pick, I call that depth.

At most regionals during qualifications the event can get a little monotonus with a couple poor matches in a row. At Waterloo there was rarely any slow matches during qualifications, everyone in the stands were engaged, I even saw arena staff and regular Waterloo students getting into the games during qualifications.

I don't think Waterloo's matches "rarely being slow" has anything to do with depth of field. When there are only 32 teams, and about 20% of the robots at the event are on the field at the same time, chances are there will be at least one good robot.

Ignoring the scores of 1114, 2056, and 4069 during elimination, the average elimination score at Waterloo was 101 (121 if you included them).
Compare that to Boilermaker which had an average elimination of 97 (or 88 if you removed 359, 868, and 1747), I'd say that's similar, but I wouldn't say that BMR had that much depth.

My guess is that you'd find similar results for other regional competitions.

[Ed Law]

Originally Posted by prismiko

Nope - match 72 was not replayed. The recording is here - http://www.ustream.tv/recorded/29852971

Thanks I will enter the data and rerun the OPR with the Week 4 results. It will make quite a difference for those 3 teams with 119 points instead of 0 that I entered.