Re: OPR after Week Three Events
 

The twitter feed says 119 for red and 46 for blue

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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

Re: OPR after Week Three Events
 

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

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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

Re: OPR after Week Three Events
 

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

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

Have you seen whats happening at Wisconsin?

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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

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.

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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.

Re: OPR after Week Three Events
 

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":

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

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