Go to Post I put the encrypted manual file onto a 5-1/4" floppy disk, so I'll have it with me when I go to the kickoff event and pick up the kit. - MrForbes [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



2008 Team 1114 Championship Database

By: Karthik
New: 04-09-2008 02:42 PM
Updated: 04-09-2008 02:42 PM
Total downloads: 4801 times


The 5th annual Team 1114 Championship Database. Attached in both Excel 2003 and 2007

See associated thread.

Attached Files

  • lsx 2008 Team 1114 Championship Database - Excel 2007

    2000 Team 1114 Championship Database (Excel 2007).xlsx

    downloaddownload file

    uploaded: 04-09-2008 02:42 PM
    filetype: lsx
    filesize: 1.82MB
    downloads: 1231


  • xls 2008 Team 1114 Championship Database - Excel 2003

    2008 Team 1114 Championship Database.xls

    downloaddownload file

    uploaded: 04-09-2008 02:42 PM
    filetype: xls
    filesize: 4.46MB
    downloads: 3568



Recent Downloaders

  • Guest

Discussion

view entire thread

Reply

04-09-2008 02:50 PM

Jonathan Norris


Unread 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!



04-09-2008 02:50 PM

Karthik


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



04-09-2008 02:54 PM

Pat Fairbank


Unread Re: paper: 2008 Team 1114 Championship Database

Awesome, thank you Roberto!



04-09-2008 03:04 PM

Adam Freeman


Unread Re: paper: 2008 Team 1114 Championship Database

Thanks SIMBOTS.

You are making this to easy on us.



04-09-2008 03:07 PM

Elgin Clock


Unread 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!



04-09-2008 03:09 PM

Karthik


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Elgin Clock View Post
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.
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.



04-09-2008 03:26 PM

smurfgirl


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



04-09-2008 03:48 PM

Billfred


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



04-09-2008 03:51 PM

T3_1565


Unread 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

I just learnt what RS was at Toronto this year

Thanks



04-09-2008 04:00 PM

Karthik


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



04-09-2008 04:07 PM

Graham Donaldson


Unread 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!



04-09-2008 04:08 PM

T3_1565


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Karthik View Post
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.
ok thanks Karthik! I figured O score meant offensive score, but its never a bad thing to ask



04-09-2008 04:10 PM

J Flex 188


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



04-09-2008 05:20 PM

GBilletdeaux930


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Karthik View Post
There may be some errors, but I'm confident the data is 98.1114% accurate.
Nice way to slide your team number in there lol

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



04-09-2008 05:23 PM

Andy Baker


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



04-09-2008 06:17 PM

Tristan Lall


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Andy Baker View Post
can you re-post this in an Excel format that is 1997-2003?
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.



04-09-2008 06:30 PM

s_forbes


Unread 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).



04-09-2008 06:43 PM

emoss_5


Unread 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!!



04-09-2008 06:53 PM

Karthik


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Andy Baker View Post
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.
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.



04-09-2008 07:03 PM

Joe Ross


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by s_forbes View Post
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).
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



04-09-2008 07:06 PM

Guy Davidson


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



04-10-2008 10:10 AM

Rich Kressly


Unread Re: paper: 2008 Team 1114 Championship Database

crap....holy crap .... amazing tool



04-10-2008 10:59 AM

Cynette


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Rich Kressly View Post
crap....holy crap .... amazing tool
And I love the interface! Talk about user friendly! You all rock! Great job!



04-10-2008 11:45 AM

Joe Ross


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



04-10-2008 12:05 PM

Barry Bonzack


Unread Re: paper: 2008 Team 1114 Championship Database

I <3 statistics.



04-10-2008 06:06 PM

Andy Grady


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



04-10-2008 07:34 PM

fluffy


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



04-12-2008 04:48 PM

Chris Herold


Unread 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



04-12-2008 05:02 PM

Akash Rastogi


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Chris Herold View Post
Still, I think you should be careful with the conclusions from the database about the teams.
I am just saying that our team is a good example of the disadvantages for these kinds of statistics

Chris
Team 1983 - The Skunkworks
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.



04-12-2008 08:43 PM

Derek Bessette


Unread Re: paper: 2008 Team 1114 Championship Database

Quote:
Originally Posted by Chris Herold View Post
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
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.



04-14-2008 07:55 PM

Dasistmeinmoped


Unread 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



view entire thread

Reply

Tags

loading ...



All times are GMT -5. The time now is 02:20 AM.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi