Quote:
Originally Posted by stingray27
Hey guys,
I took what all of you have contributed (great post by the way, very helpful) and constructed an excel file to do RUSH's post-competition analysis, or other competition scouting for states and nationals. So i wrote a macro (not very efficient at those, sorry) and it creates webquery files, obtains the data, and organizes it for however many teams are in the tournament. The only problem I am having is the OPR calculations. Can someone look at my macro and see what they can do about adding an OPR calculation formula or something? Or give me some feedback on how i can improve it cause I really am not too good at these. Thanks.
|
Hi,
Nice work. If you want your spreadsheet to calculate OPR from the results that you get from the web query, you are welcome to copy any of the macros that I published. I did not put protection on them to allow other teams to use them and customize for their own use. However if that is all you are going to do, I don't see the purpose of it except as a learning process since I publish OPR/CCWM results of every regional and district after each week of competition and I have been doing it for the last 4 years. Please refer to the following white paper.
http://www.chiefdelphi.com/media/papers/2174
You will not see the weekly published spreadsheets from prior years since I delete them at the end of the season and only keep the last one.