Quote:
Originally Posted by Ether
What is the format of the data?
Attached is a simple-to-use tool which accepts data in the following format:
RED1 RED2 RED3 BLUE1 BLUE2 BLUE3 RED_SCORE BLUE_SCORE
... and calculates all sorts of stats, including OPR, and outputs the results to a CSV file which can be opened directly in Excel.
Tell me what format your data is in and maybe I can make a few simple changes so it can process the whole batch for you.
|
Although I asked for better machine readable data, I was told this is the best it gets:
http://www.hightechkids.org/sites/de...%20Results.pdf
There are four other similar pages for the other tournaments.
I did enter one tournament into Excel with columns:
Tourney#, Match #, Color, Score, Team#
(total of four rows per match)
This format can be easily adjusted, of course.
I also just realized I can copy/paste into a text file and get this:
Q-1 117-161 B
7972 8034
7661 2887
Q-2 11-82 B
6707 7000
4140 8005
That's:
Q-Match# RedScore-BlueScore WinningColor(R/B)
Red1 Red2
Blue1 Blue2
It gets a little messed up at page breaks in the PDF but that's trivial to fix.