paper: 2008 Team 1114 Championship Database
 

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

2008 Team 1114 Championship Database by Karthik

Re: paper: 2008 Team 1114 Championship Database
 

wow this is just amazing... anyone going to the champs take a look at this it will make your scouting a lot easier. This is a great resource.

edit: Thanks a bunch Roberto!

Re: paper: 2008 Team 1114 Championship Database
 

Greetings all,

Attached is the 2008 Team 1114 Championship Database. This year's database includes full results for every team who competed in the 2008 season as well:

- 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) We found an average correlation between R = 0.7 and 0.85 to observed emperical scouting data
- Master sheets for each division, and for all FIRST teams.

The data we have was all mined from the FIRST website. There may be some errors, but I'm confident the data is 98.1114% accurate. We will not be issuing any updates this year due to time constraints.

In the past we have never released any of our regression analysis (Calculated Contribution), this year since people have become more knowledgable 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.

Special thanks go out to everyone on Team 1114 who made this database possible, especially Geoff Allan and Roberto Rotolo.

If you have any questions, please ask.

Re: paper: 2008 Team 1114 Championship Database
 

Awesome, thank you Roberto!

Re: paper: 2008 Team 1114 Championship Database
 

Thanks SIMBOTS.

You are making this to easy on us. :yikes:

Re: paper: 2008 Team 1114 Championship Database
 

I know you're not updating this sheet, but it seems noteworthy for next year.

The Record field in the different division pages for a single team's info seems to be just taking into account the last regional the team attended, & not the season's rankings (for multi-regional) attending teams.

IE: We (237) have an overall Record this year of 12-7-0 & it's just taking into account our last regional (Phialdelphia) which was 8-3-0.

Don't know if this was done on purpose, but seems worthy of mentioning.

Good work none-the-less! Glad to see this, and so quickly I may add!
Very cool!

Re: paper: 2008 Team 1114 Championship Database
 

It was done on purpose, the division summary pages has a listing for each regional event a team attended. We found that for our scouting purposes it was more useful to look at each event separately, as opposed to amalgamating all the stats into one record. This way you can see how a team is trending from event to event.

Re: paper: 2008 Team 1114 Championship Database
 

Thank you 1114! This is a dream for our scouting team, whom I sent on a pre-Championship information collecting mission.

One suggestion: would you consider putting a team's rookie year somewhere in their entry? I know age isn't everything, but experience can make a difference, and it's an interesting factor to look at.

Re: paper: 2008 Team 1114 Championship Database
 

Even better is that 1114's gone and included information on every single team competing this season. This is great stuff, even for those of us who don't have a dog in this fight.

If you'll excuse me, I need to go make my "WE'RE NUMBER 1,466!" sign. ;)

Re: paper: 2008 Team 1114 Championship Database
 

Although this may sound dumb.. but can someone tell me what LS and O score are? I'm not much up on the letter lingo lol :P

I just learnt what RS was at Toronto this year:D

Thanks

Re: paper: 2008 Team 1114 Championship Database
 

LS is our abbreviation for Least Squares which means "Calculated Contribution". We used a Least Squares regression to get the data, hence the title. O Score, refers to average offensive score. A relic from when we used to calculate defensive averages and regressions.

Re: paper: 2008 Team 1114 Championship Database
 

AWESOME! Gotta love AP Statistics- I love how I actually know what you're talking about. Thanks a lot guys- we'll probably do some scouting of our own down there (even without our wireless network- :(), but I'll definitely use this.

Thanks again, Karthik, Roberto, and the rest of 1114!

Re: paper: 2008 Team 1114 Championship Database
 

ok thanks Karthik! I figured O score meant offensive score, but its never a bad thing to ask :D

Re: paper: 2008 Team 1114 Championship Database
 

Roberto strikes again!

He was also an integral part of the volunteer corps at the 2005 Wonderland Invitational. Gotta love him.

For all the FF people out there, this tool is a must-have.

Re: paper: 2008 Team 1114 Championship Database
 

Nice way to slide your team number in there :p lol

This is awsome even though were not goin to Championships its still just cool to check out... wow

Re: paper: 2008 Team 1114 Championship Database
 

Hey... a favor needed...

can you re-post this in an Excel format that is 1997-2003?

By the way, thanks for posting this.

Andy B.

Re: paper: 2008 Team 1114 Championship Database
 

Here's Microsoft's patch for Office 2000-2003 that will allow compatibility with Office 2007 formats. It will let you open and save files in the .xlsx format, but it will cause some of the fancier new features (mostly the themes, and some of the graphics tools) to lose their "magic" and become normal objects.

Re: paper: 2008 Team 1114 Championship Database
 

Awesome statistics! Out of curiosity, did you have similar scouting sheets for past years? It'd be great to see some data from the 06 and 07 years (and maybe earlier for some of the other teams).

Re: paper: 2008 Team 1114 Championship Database
 

wow
Thank you guys soooooooo much
you have saved me and the rest of the scouting team sooo much time
thxs so much u guys!!

Re: paper: 2008 Team 1114 Championship Database
 

Both the new (.xlsx) and old (.xls) formats are available here:

http://www.chiefdelphi.com/media/papers/2115?

That should cover the bulk of users.

Re: paper: 2008 Team 1114 Championship Database
 

2004: http://www.chiefdelphi.com/media/papers/1528
2005: http://www.chiefdelphi.com/media/papers/1671
2006: http://www.chiefdelphi.com/media/papers/1826
2007: http://www.chiefdelphi.com/media/papers/1975

Re: paper: 2008 Team 1114 Championship Database
 

This is pretty amazing. Thank you very much for releasing this information. I'll be sure to pass it on to our scouts, and take a thorough look at it myself. This is a wonderful tool.

Re: paper: 2008 Team 1114 Championship Database
 

crap....holy crap .... amazing tool :)

Re: paper: 2008 Team 1114 Championship Database
 

And I love the interface! Talk about user friendly! You all rock! Great job! :)

Re: paper: 2008 Team 1114 Championship Database
 

Thanks to 1114 for making this wonderful resource available once again!

In case anyone wants to make corrections to their local copy, 134 was champion at NH and 16th pick.

Re: paper: 2008 Team 1114 Championship Database
 

I <3 statistics.

Re: paper: 2008 Team 1114 Championship Database
 

Excelent job as always Karthik...

One bit of incorrect data I found though. Team 134 is listed in the database as not having made the eliminations at BAE. They actually won the regional with 121 and 40.

Extremely useful tool...I'll be using it heavily at championships.

Re: paper: 2008 Team 1114 Championship Database
 

FYI- Some of the teams going to the championship don't have championship rankings and percentages. I was looking through the teams and noticed that.

Re: paper: 2008 Team 1114 Championship Database
 

Well, those scores are really nice and the table and database have a great quality.
Still, I think you should be careful with the conclusions from the database about the teams.
If you have a look at our scores, for example. The scores for the Seattle Regional are lower for us than for the Portland Regional.
Even though, our team was 5-2-0 in the qualification rounds in Portland, we didn't play 3 of those matches due to technical issues!
In contrast, in Seattle, we were quite dominating, scoring a lot of points and ending up as an alliance-captain and finally as the winner of the regional. During the tournament we didn't break down. In the finals we had a large contribution and didn't lose any game.
We greatly improved between those two regionals (teams that saw both regionals will tell you that), but the database does not really reflect that.
This is again caused by the OPR that are not reflecting at all what percentage of scoring a team does and closer data about the team itself. I think our scouting system gives us more, and detailed information about the teams themself, even though it needs more time to be evaluated...

I am just saying that our team is a good example of the disadvantages for these kinds of statistics

Chris
Team 1983 - The Skunkworks

Re: paper: 2008 Team 1114 Championship Database
 

Agreed. But I'm sure that the top teams who will be selecting know how to scout well and not to rely just on past statistics like this.

The tool itself is awesome but should only supplement strategy and scouting meetings along with your own up-to-date data from scouting in your division.

Great job once again Karthik.:)

Re: paper: 2008 Team 1114 Championship Database
 

This is why, in the past, we have not posted these statistics. They are not perfect. But they are the best thing anyone has come up with to determine a teams contribution using only match scores. At championship, as we do at every regional, we'll be counting every point scored (or lost) by each robot. Nothing beats numbers.

These stats are definitely a better gauge of a teams performance than believing what a team says about there own performance. You said that in Portland you were scoring a lot of points in qualifying, yet your average alliance score was 30.5. Based on this information, I would say your statement was a little optimistic. I don't blame you for it, everyone does it. It's just an example of why we like to use numbers.

It is possible that I am wrong here and you put up 30+ points every match and your partners were taking penalties. If that is the case, I guarantee that our scouts and many others will take notice of you on Galileo. No matter what your OPR was on this spreadsheet.

Good luck. We'll see you on the field.

Re: paper: 2008 Team 1114 Championship Database
 

great stuff

wish i heard about it before i compiled mad data off blue alliance for my division..

o well.

anyone have any stats on penalties drawn by robots, or alliances?

not gonna lie, i learn more about a team by how many points they lose, then score