Easy to use Offensive Power Rankings (OPR) program for mid-regional scouting

[Zholl]

This is pretty cool. I'm debating whether or not to use this or the matrix system I spent the last couple weeks setting up. I guess depending on the delay, doing it by hand is probably faster though, even if it is a pain. Anyway, seems to work fine on my vista system, and I didn't have to compile it with the SDK or anything. One question, though. Is it supposed to close after you enter a command after it gives you the requested stats?

[engunneer]

yes

you're supposed to run it from a terminal, so the window doesn't close.

if you run it from a command line, then you can give it the parameters all at once as well.

[Bongle]

Originally Posted by Zholl

This is pretty cool. I'm debating whether or not to use this or the matrix system I spent the last couple weeks setting up. I guess depending on the delay, doing it by hand is probably faster though, even if it is a pain. Anyway, seems to work fine on my vista system, and I didn't have to compile it with the SDK or anything. One question, though. Is it supposed to close after you enter a command after it gives you the requested stats?

I wanted it to pause at the end if the user double-clicked on it. I couldn't remember the "press any key to continue" API call, so I did it in the poor man's way:
if(!fRunWithoutCommandLineParameters)
{
int a;
cin>>a;
}

[DMetalKong]

My friend and I were talking, and if you use the match points from the opposing alliance in the calculation, you can find the approximate number of points scored ON a robot during matches. Could be useful this year.

[Bongle]

Originally Posted by DMetalKong

My friend and I were talking, and if you use the match points from the opposing alliance in the calculation, you can find the approximate number of points scored ON a robot during matches. Could be useful this year.

That's the DPR calculation. It can be phrased as "DPR is the average number of points that a team's presence adds to its opponent's score." aka, DPR is the average number of points scored in a robots trailer. It should be lower for highly mobile robots, and very high for no-shows or robots whose strategies or drivetrain tend to get them scored on.

[Samuel H.]

Hello,

Using v3 worked for me earlier, but I now have a new problem. Running

OPRNet.exe kc 2009 opr

downloads the match data, but fails when parsing with the error:

Parsing!
No matches found. This regional may not have run yet, or may have HTML output that the parser does not recognize.
Failure to parse XML. Code: -2147467259

I've attached temp.tmp

Thank you,
- Sam

[Bongle]

Originally Posted by Samuel H.

Hello,

Using v3 worked for me earlier, but I now have a new problem. Running downloads the match data, but fails when parsing with the error:



I've attached temp.tmp

Thank you,
- Sam

Hmmm... the temp.tmp (which is simply the match results HTML page) simply doesn't have any match data. If you look at the KC results page, you can see that the qualifying matches are no longer up. This looks like a FIRST problem.

Thanks for the bug report though!

[billbo911]

I'm currently "evaluating" this app for it's effectiveness with some very positive findings. The one thing that I would really like to do is to "export" the output into an Excel spreadsheet for ease of viewing offline. If I am not mistaken, the results are only sent to the screen. Is there a way to have them go to a ".csv" file, or some other format that can easily be opened in Excel?

[Bongle]

Originally Posted by billbo911

I'm currently "evaluating" this app for it's effectiveness with some very positive findings. The one thing that I would really like to do is to "export" the output into an Excel spreadsheet for ease of viewing offline. If I am not mistaken, the results are only sent to the screen. Is there a way to have them go to a ".csv" file, or some other format that can easily be opened in Excel?

In a command line:

oprnet (regional code) (year) (stat) > blah.csv

This uses the DOS redirect operator to send it to a text file. The stats are are tab-seperated so that you should be able to copy/paste it into excel and have all the cells line up properly.

[billbo911]

Originally Posted by Bongle

In a command line:

oprnet (regional code) (year) (stat) > blah.csv

This uses the DOS redirect operator to send it to a text file. The stats are are tab-seperated so that you should be able to copy/paste it into excel and have all the cells line up properly.

Yep, that'll do it!! (Good ol' DOS, it still has some life left in it )

By the way. I am currently running this on a Vista x64, quad core system with 8GB of ram. It absolutely rips! No mods were needed what so ever to get this running. THX!!

[Bongle]

Originally Posted by billbo911

Yep, that'll do it!! (Good ol' DOS, it still has some life left in it )

By the way. I am currently running this on a Vista x64, quad core system with 8GB of ram. It absolutely rips! No mods were needed what so ever to get this running. THX!!

Well, it's only solving a TeamCount x TeamCount matrix. Crazier stuff I've done in the past was post-season analysis involving every single team (1300x1300 matrix, or so), and that ends up taking a long time.

Also, v4 is done.

Changes:
-DPR is now called SAA for 'scores against average' to make its name more line up with its values
-You can now choose to sort by team. Command-line looks like this:

oprnet il 2009 opr t

. If you don't want to sort by team, just put an 'r' there, or leave the parameter off entirely.
-Command-line users can now append a 'q' to completely suppress all non-error messages. For example, this:

oprnet il 2009 opr r q

will only print out the OPR values (or errors if there were any)
-Sorting for SAA/DPR is now reversed, so that the 'best' values come first.

[Vikesrock]

This just keeps getting better and better.

It looks like the SAA/DPR still sorts with the highest number on top (which ismost points scored against, right?)

[Michael Corsetto]

I'm running on a mac, is there any way that someone could run the app with the numbers from this week's regionals, export to Excel, and post the results on CD? I loved the OPR last year and it was very useful IMO. Thanks Bongle for making it even better this year!

[Vikesrock]

Originally Posted by Michael Corsetto

I'm running on a mac, is there any way that someone could run the app with the numbers from this week's regionals, export to Excel, and post the results on CD? I loved the OPR last year and it was very useful IMO. Thanks Bongle for making it even better this year!

Match results seem to have disappeared for a number of events. I'll try and remember to check over the next few days and do this when the results reappear.

[engunneer]

Here are OPR for the events that do have match results posted; a zip file of Team, OPR, SAA, and +/- (tab delimited for easy excel import).

each event is a separate text file.

I wrote a script that will generate these txt files on the fly in autohotkey. I can post (more or less uncommented) code if anyone wants.

This was made using v4 of OPRNet (yay for the new 'quiet' feature.)