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

[Ether]

Originally Posted by Chris Hibner

..."fudge file"...

Yet another option:

If you have 3 free buttons on the operator console, you can use them to adjust values in the fudge file. Use button1 to cycle through the available fudge values in the file to select the one you want to adjust. Use button2 to bump the selected value up. Button3 to bump the selected value down. No need to connect a development computer.

[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 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?

[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.

[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*

[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.

[~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.

[Ether]

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.

Ed,

For future reference in case you encounter this issue again, you have the following 2 recourses:

1) Twitter data for that match (for example, see here).

2) If there's only one match score missing, pick a team from each alliance that was in that match. Using the Qual Match Results data, add up the scores for the alliances that team was on. Subtract that from the sum of Auto+Climb+TeleOp for that team in the Team Standings data. That should be the alliance score for the missing match.

Example calculation, using Team 1660:

Here are Team 1660's alliances and scores at New York, with Match #72 set to a score of "0":

1340	1660	806	16
421	1660	1155	35
3059	1382	1660	45
1660	4640	514	30
1660	354	3204	71
237	3137	1660	49
4263	1660	810	0
2933	369	1660	70

			316

... and here is the Team Standings data for Team 1660 from the New York event:

26 	1660 	8.00 	142.00 	90.00 	203.00 	4-4-0 	0 	8

142.00 + 90.00 + 203.00 = 435; ..... 435 - 316 = 119