paper: New Scouting Database from Team 2834

[Ed Law]

Jacob,

I have seen studies done with several years of data that shows the average OPR increasing as time goes on so I would be careful in saying one regional/district is stronger than another if they are not in the same week.

Take our team as an example. Our week 1 event OPR was 5.9 because the robot was not working properly. Our week 2 event OPR was 32.5 because the robot was working and we also got the minibot to work half way through the event.

For teams that do not have a practice robot to practice after ship date, their OPR usually improves as drivers get more experience. There can be many other reasons teams improve their OPR from one event to the next. Most teams plateau out after their 3rd event. Of course some teams' OPR goes down as their robot wore out and start to break down.

One difference between powerhouse teams and teams like ours is they start their season with very high OPR probably because they have less things to "debug". For us we still have a lot of things to learn. We have a lot of "first" this year. First time using banebot motor, first time using gyro, first time using potentiometer, first time using Mecanum wheels and programming it, first time programming a field oriented drive, first time designing and building a 4 bar link arm, first time trying a magnetic encoder, first time trying a compass sensor. We are very lucky to have Team 33 helping us but when you are doing so many things for the first time, bad things are going to happen.

[Jacob Plicque]

Ed,
I agree that my method does not reflect improvement from Regional to Regional. However, 69.5% of the teams only attend one regional, 28.9% of the teams attend two regionals, and 1.6% attend three or more regionals. The quick and dirty list does show dominate regionals that are ~3 times stronger than others. The use of the world rank data would probably produce a fairly accurate strength estimate. While the correlation is unproven, I'll bet the the winners of stronger regionals are dominating in the FIRST Championships.

[bobosalad]

can you email me at tomasicenogle@gmail.com with the definitions of every part? EX: RS OPR ect... can i just get a list of everything? Thank you.

[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.