The OPR/CCWM week 1 numbers have been updated. Please go to
http://www.chiefdelphi.com/media/papers/2174
There are a number of points I would like to make:
1) Team Standings for Centerline is not posted on FIRST website. I posted what the FTA gave me but I am not certain the subscores are in the right columns. There were only two columns in the FTA report and I guess they are for Autonomous points and Teleop points. I will update them once the Team Standings are posted on the FIRST website.
2) Team Standings for Greater Toronto West has incomplete data. I did not include these data in Query.
3) I added the Adjusted OPR in column AE for each event, which removes the Foul Points from the total score before computing OPR. The foul points came from Twitter data. I did not use the match score from Twitter data because they are not 100% accurate. For events without twitter data, no Adjusted OPR is computed.
4) World ranking is computed using OPR because some events do not have twitter data to calculate Adjusted OPR.
5) I added a tab called Adjusted OPR Results. Events without twitter will show 0 for Adjusted OPR.
If you find any error or have any questions, please let me know.