Quick N' Dirty OPR Calculator

[evanperryg]

Hello, world of CD!

We all love OPR. It's an incredibly powerful metric. Yet, there aren't many people out there who have the time or programming skills to calculate OPR themselves, so the vast majority of us are stuck refreshing CD-Media every weekend, hoping one of our OPR-releasing overlords will give us the data we relish, but half the time the data doesn't come. I, for one, have always found that frustrating, so I've decided to take a step towards solving that problem.

Quick N' Dirty OPR is a brutally simple, stripped down tool for calculating OPRs. I've designed it so that, with relative ease, all you have to do is copy and paste information off of TBA into the spreadsheet to make it work.

Is this the most effective option? No.
Is it the most efficient option? Definitely not.
Is it easy to use, regardless of your understanding of the mathematics behind OPR? Absolutely.

This season's game is going to be tough to scout, as I'm sure you've all noticed already. We all know OPR, despite being far from perfect, is a surprisingly effective way to get a big-picture perspective of who is making the biggest contributions to their alliance. I hope this tool will make life easier for the countless teams out there who don't have the resources available to manage a scouting system, and will enable all of us data nerds to get the numbers we crave, in a format that can be easily copied into a scouting speadsheet.

Download the Quick N' Dirty OPR Calculator

In its current state, it is able to accurately calculate single-event OPRs using the matrices method described here. In the future, I hope to add the following features:
-A command-line based application that will return preformatted match data based on a user-inputted event code
-User-friendly interfacing with the FRC Events API in order to produce desired component OPRs
-Improved spreadsheet automation, so that you don't have to click 4 buttons when you really only need to click one
-Bypass unnecessary parts of the current calculation procedure (namely, the M Visual sheet, which is really only there so I could more easily check that things were working correctly)

Any advice, suggestions for new features, etc is greatly appreciated. Happy scouting!