paper: New Scouting Database from Team 2834

[Ed Law]

QS and RS definition can be found in Section 5 of the manuals.

5.3.3 Qualification Score (QS)
Qualification points are awarded to each TEAM at the completion of each qualification match and are dependant on the final score:
 Each TEAM on the winning ALLIANCE will receive two (2) qualification points.
 Each TEAM on the losing ALLIANCE will receive zero (0) qualification points.
 In the event of a tied score, all six TEAMS will receive one (1) qualification point.
The total number of qualification points earned by a TEAM throughout their qualification matches will be their qualification score.

5.3.4 Ranking Score (RS)
Each TEAM on the winning ALLIANCE will receive a number of ranking points equal to the unpenalized score (the score without any assessed penalties) of the losing ALLIANCE.
Each TEAM on the losing ALLIANCE will receive a number of ranking points equal to their final score (with any assessed penalties).
In the case of a tie, all participating TEAMS will receive a number of ranking points equal to their ALLIANCE score (with any assessed penalties).
The total number of ranking points earned by a TEAM throughout their qualification matches, divided by the number of matches played (excluding any SURROGATE matches), then truncated to two decimal places, will be their ranking score.
Note: because your ranking score is derived directly from the match scores of the losing ALLIANCES in the matches you play, it is in your best interest to support your opponents and win by helping each ALLIANCE score as many points as possible.

OPR stands for Offensive Power Rating. CCWM stands for Calculated Contribution to Winning Margin. The explanation can be found in this white paper. http://www.chiefdelphi.com/media/papers/2174
Look for the file "Team 2834 Scouting Database Presentation 2010.pdf"

[shocker4256]

Is there any reason why I can't seem to populate the CT match list correctly? I get times and team numbers and scores for Qualifications but they seem random....

edit: It also seems like the Qualification data that it is pulling is going where the elimination data normally is

[Ed Law]

Originally Posted by shocker4256

Is there any reason why I can't seem to populate the CT match list correctly? I get times and team numbers and scores for Qualifications but they seem random....

edit: It also seems like the Qualification data that it is pulling is going where the elimination data normally is

The links for future events are still pointing to last year's events. I cannot setup the new links ahead of time when the web pages did not exist until Thursday or Friday. This was possible before in Excel 2003, but this does not seem to be possible with Excel 2007 and 2010. This will be my summer project if I have time to automate this as much as possible so I can set them up quickly. Doing it manually is quite tedious when there are so many events.

People who knows Excel well enough are able to change the links themselves to point to the current data.

[Ed Law]

Based on requests, I have set up the links for Connecticut, Smoky Mountain and Troy for people to use. It is in version 5b. Good luck at the competition this weekend.

Keep in mind that the OPR numbers will appear very low until more matches are completed. But you can kind of scale it up based on number of matches played.

[Ed Law]

Here is Version 5c that takes care of the low predicted OPR issue but it will require mroe matches played before it will work. Otherwise the matrix is ill conditioned and you will get an error message.

Edit: It works for all 3 locations now.

[Ed Law]

Week 5 results are out. It is in version 5e.

Caution: There are some discrepancies that has not been resolved in the data from usfirst.org website.

Silicon Valley finals match score not posted
North Star finals match results incomplete
Troy match 78 results not included in QS numbers

When resolved, they will be updated in future posting.

I will be busy at Michigan State Championship and will not be able to setup links for other regionals for Week 6. I will post results of Week 6 after this weekend.

[Vikesrock]

Originally Posted by Ed Law

North Star finals match results incomplete

Oddly enough they are. Match 2 was actually a 0 to 0 win for the Blue Alliance. Blue ended with a score of 0 after penalties, but Red had a DQ so they lost, forcing a third and deciding match.

[Ed Law]

Originally Posted by Vikesrock

Oddly enough they are. Match 2 was actually a 0 to 0 win for the Blue Alliance. Blue ended with a score of 0 after penalties, but Red had a DQ so they lost, forcing a third and deciding match.

Thanks for letting me know. That was strange. I can't tell and my spreadsheet can't tell who won that match when it is 0-0. I thought that was a tie and required a 4th match that was not posted. I knew the outcome from the Awards page.

[RMiller]

Originally Posted by Ed Law

Thanks for letting me know. That was strange. I can't tell and my spreadsheet can't tell who won that match when it is 0-0. I thought that was a tie and required a 4th match that was not posted. I knew the outcome from the Awards page.

Can you manually edit the spreadsheet to have something like 0.000001 as a score? I am not familiar with the spreadsheet and do not have Excel installed on this computer otherwise I would check.

[Ed Law]

Week 6 results are out. All previous missing and wrong data from FIRST have been corrected and incorporated in this version. Keep in mind that the True World Ranking is from the whole season's performance and not an indication of strength going into Championship. The latest OPR may be a better indication of that.

I will be posting another file once the division data is out. I will also add the web links to the divisions on Thursday so teams can update the OPR numbers during the competition.

Let me know if you have any questions.

[Travis Hoffman]

Originally Posted by Ed Law

Week 6 results are out. All previous missing and wrong data from FIRST have been corrected and incorporated in this version. Keep in mind that the True World Ranking is from the whole season's performance and not an indication of strength going into Championship. The latest OPR may be a better indication of that.

I will be posting another file once the division data is out. I will also add the web links to the divisions on Thursday so teams can update the OPR numbers during the competition.

Let me know if you have any questions.

Like! Ahead of Saturday, too.

[techvikesmom]

Where can I find your spreadsheet?? I have found in the previous weeks and I would love to find it today!! Thanks for the all the great input!!

[Vikesrock]

Originally Posted by techvikesmom

Where can I find your spreadsheet?? I have found in the previous weeks and I would love to find it today!! Thanks for the all the great input!!

If you go the very first post in this thread and click the link you will be brought to a page with a number of different versions of the database on it. The latest one is "Team 2834 2011_Scouting_Database week 6 "

Here is another copy of the link in the first post:
http://www.chiefdelphi.com/media/papers/2174?

Here is a direct download link for the latest version:
http://www.chiefdelphi.com/media/papers/download/3056