04-09-2008 03:50 PM

Jonathan Norris

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 03:50 PM

Karthik

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 03:54 PM

Pat Fairbank

Re: paper: 2008 Team 1114 Championship Database

Awesome, thank you Roberto!

04-09-2008 04:04 PM

Adam Freeman

Re: paper: 2008 Team 1114 Championship Database

Thanks SIMBOTS.

You are making this to easy on us.

04-09-2008 04:07 PM

Elgin Clock

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 04:09 PM

Karthik

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Elgin Clock 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.

04-09-2008 04:26 PM

smurfgirl

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 04:48 PM

Billfred

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 04:51 PM

T3_1565

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 05:00 PM

Karthik

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 05:07 PM

Graham Donaldson

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 05:08 PM

T3_1565

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Karthik 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 05:10 PM

J Flex 188

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 06:20 PM

GBilletdeaux930

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Karthik There may be some errors, but I'm confident the data is 98.1114% accurate.

04-09-2008 06:23 PM

Andy Baker

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 07:17 PM

Tristan Lall

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Andy Baker can you re-post this in an Excel format that is 1997-2003?

04-09-2008 07:30 PM

s_forbes

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 07:43 PM

emoss_5

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 07:53 PM

Karthik

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Andy Baker 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 08:03 PM

Joe Ross

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by s_forbes 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 08:06 PM

Guy Davidson

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 11:10 AM

Rich Kressly

Re: paper: 2008 Team 1114 Championship Database

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

04-10-2008 11:59 AM

Cynette

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Rich Kressly crap....holy crap .... amazing tool

04-10-2008 12:45 PM

Joe Ross

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 01:05 PM

Barry Bonzack

Re: paper: 2008 Team 1114 Championship Database

I <3 statistics.

04-10-2008 07:06 PM

Andy Grady

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 08:34 PM

fluffy

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 05:48 PM

Chris Herold

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 06:02 PM

Akash Rastogi

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Chris Herold 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

04-12-2008 09:43 PM

Derek Bessette

Re: paper: 2008 Team 1114 Championship Database

Quote:

Originally Posted by Chris Herold 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-14-2008 08:55 PM

Dasistmeinmoped

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