The OPR/CCWM numbers have been posted, please see
http://www.chiefdelphi.com/media/papers/2174
There are a number of points I would like to make:
1) All week 1 events are included.
2) If the negative numbers at some of the events mean surrogate teams, I still included them in the calculations. This is because I am calculating World OPR. It would not be fair to teams attending that event to not have their OPRs included in the calculation because some matches have surrogate teams. Hopefully we will not have too many surrogate teams this season.
3) I checked my component OPRs against Ether's. I am 99% confident my numbers are correct.
4) World OPR is published. Since there is no interaction of teams in different events, the numbers should be the same as the OPR numbers at their event.
5) CCWM is meaningless this year. I am including it because the program automatically calculates and report it.
6) This spreadsheet is all set up to run update of week 2 to week 7 events. During the events, you just have to do Cntr-Shft-P in each tab and it will update everything for you. However, because of changes FIRST made to their website, it may take up to a minute to update each event instead of seconds. I also avoid updating Playoff Rounds so it will not take as long each time during Qualification Matches. You will need to modify the macro to turn that back on.
7) Because of problem with data in week one, Cntr-Shft-P does not calculate OPR/CCWM after updating data. You need to do Cntr-Shft-O to calculate OPR/CCWM
8) I am now able to get the alliance selection directly from the FIRST website. There is no need to update that Google doc.
If you find any error or have any questions, please let me know.