paper: 2010 Team 1114 Championship Scouting Database

[Karthik]

Thread created automatically to discuss a document in CD-Media.

2010 Team 1114 Championship Scouting Database by Team 1114

[Karthik]

Greetings all,

Attached is the 2010 Team 1114 Championship Database. This year's database includes full results for every team who competed in the 2010 season as well. We've based this version on the current divisions posted at usfirst.org. If these change we will update accordingly. (However if it's just a couple of additions, we may not release a new version)

The database includes:
- An interface allow you pull an individual team's record
- Full listing of awards, record & finish
- Team scoring averages
- "Calculated Contribution" which is the same calculation being refered to as OPR on these forums. This calculation usings linear alegbra to determine what a team's average input to their alliance was at each regional. (Only using qualifying match results)
- A master sheet for a sortable comparison of all FIRST teams
- Master sheets for each division and full divisional assigments

The data we have was all mined from the FIRST website. There may be some errors, but I'm confident the data is 97.1114% accurate. That being said, there were some gaps in the standings for WOR and IL. These regionals will have some funky results, as we pulled the standings straight from usfirst.org, but the alliance selection results from actual observation.

We'll upload a version for older Excel shortly. It's a much larger file.

Prior to 2008 we never released any of our regression analysis (Calculated Contribution) that we had been doing since 2004. Since people have become more knowledgeable on the subject we decided to make the change. Please do not take a poor score as a slight or an insult. We simply used the actual scores from matches to perform a calculation. We feel that this tool is the best available metric if you are unable to watch the actual matches. Since none of us can attend every regional, it should be a valuable tool. Regression analysis is much more effective for Breakaway than it was for Lunacy, but still not as good as it was for Overdrive. If you want more details on this, come check out my seminar in Atlanta.

Thanks to Geoff Allan, Ben Bennett and Roberto Rotolo of Team 1114 Stats and Research for creating this year's database.

If you have any questions, please ask.

[bobrenjc93]

Very impressive. Thanks a lot!

[Akash Rastogi]

Thanks Karthik, amazingly useful as always.

[Racer26]

*cringe* Well, that makes us look like crap. At least our hanger is significantly better now, and we should be hanging every match in Atlanta.

[Chris is me]

I love how this mathematically demonstrates 1124's dramatic improvement.

Thanks 1114! If you guys are in need of the last few WPI matches, I can get the data for them.

[waialua359]

According to the divisions breakdown summary, Archimedes is the most stacked division, including the most Chairman's Award winners.
My bet is that the CA winning team this year comes out from that division.

[TKM.368]

Originally Posted by Karthik

We'll upload a version for older Excel shortly. It's a much larger file.

Or teams can download the Compatibility Pack to be able to open in an older version.

Thanks 1114!

[Tom Bottiglieri]

Originally Posted by Chris is me

I love how this mathematically demonstrates 1124's dramatic improvement.

It is interesting to look at how some teams improved over the season.

What's better? A team who was good but didn't improve much from event to event? Or a team who was not so good at their first event but was much better at their second?

For the latter, do you think the slope can stay steep? Or is this one of those tortoise/hare situations?

[kjolana1124]

Originally Posted by Tom Bottiglieri

What's better? A team who was good but didn't improve much from event to event? Or a team who was not so good at their first event but was much better at their second?

For the latter, do you think the slope can stay steep? Or is this one of those tortoise/hare situations?

I see it almost like an exponential curve. Teams that tend to do better over the course of a few events have a habit of leveling off. Whether it be from getting too sure of yourself, falling into a pattern, or just reaching your peak a little too soon, they eventually begin to stabilize. Either that, or in the effort to keep improving they end up becoming weaker.

Continuous improvement =/= continuous work. Sometimes all a team needs is a better mindset between competitions, not a better robot.

[PaW]

Annual thanks to you and your team, Karthik! Nice work, as always.

[Justin Montois]

wow. They scout like they build robots. Talk about a powerhouse.

[J Flex 188]

I simply can't fathom how Roberto Rotolo keeps pumping this stuff out year after year with such a high degree of quality too! He's definitely the backbone to that skilled group of individuals, its nuts, every year!

[Zach O]

Wow! What a database! Very impressive. Thank you for posting it.

[dsmoker]

For a team like ours, that just qualified for the Championship last weekend and is just barely able to send a skeleton crew (7 kids, 4 mentors) down to Atlanta, this data base is an invaluable resource. Plus, we look pretty good!! Thank you for sharing this information with the FIRST community.