Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Extra Discussion (http://www.chiefdelphi.com/forums/forumdisplay.php?f=68)
-   -   paper: 2009 Team 1114 Championship Scouting Database (http://www.chiefdelphi.com/forums/showthread.php?t=76599)

Karthik 07-04-2009 21:38

paper: 2009 Team 1114 Championship Scouting Database
 
Thread created automatically to discuss a document in CD-Media.

2009 Team 1114 Championship Scouting Database by Karthik

Jared Russell 07-04-2009 21:43

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Just. Awesome.

Karthik 07-04-2009 21:44

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Greetings all,

Attached is the 2009 Team 1114 Championship Database. This year's database includes full results for every team who competed in the 2009 season as well. Version 1.0 does not have the divisional assignments. We will issue an updated version on the evening of the day the divisions are announced. This will be the final update of the database.


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) We found an average correlation between R = 0.7 and 0.85 to observed emperical scouting data
- A master sheet for a sortable comparison of all FIRST teams

Version 2.0 will include
- 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. If you notice any errors please respond to this thread, and we will correct them for Version 2.0.


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. That being said, because of the defensive nature of Lunacy, the regression analysis is not as valuable as it was in more offensive games such as Overdrive.

Thanks to Geoff Allan and Roberto Rotolo of Team 1114 for creating this year's database.

If you have any questions, please ask.

Edit: Version 2.0 is now up, with divisions.

wo-bot 141 07-04-2009 21:46

Re: paper: 2009 Team 1114 Championship Scouting Database
 
team 141 also won the Entrepreneurship Award at MI state even though we didn't go to state. it was not on our awards list.

We were picked 3rd at Wisconsin not 14th thanks.

Vikesrock 07-04-2009 21:46

Re: paper: 2009 Team 1114 Championship Scouting Database
 
As far as I can tell any team that competed at 10,000 Lakes or Northstar as their first regional is missing from the database.

Also 2970 was the second pick at Northstar and 2549 was 15th.

Ericgehrken 07-04-2009 21:52

Re: paper: 2009 Team 1114 Championship Scouting Database
 
This is awesome!! Thank you!
Where are the Connecticut Regional Teams?

smurfgirl 07-04-2009 21:53

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Thanks for sharing this resource! I make sure my team checks this out every year, at the least as a source of some raw numbers. What they choose to do with them is another story. (:

Akash Rastogi 07-04-2009 21:53

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Some of the data for us is off by a bit. Is there still data to be entered for teams?

Karthik 07-04-2009 21:55

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Quote:

Originally Posted by Vikesrock (Post 847228)
As far as I can tell any team that competed at 10,000 Lakes or Northstar as their first regional is missing from the database.

Also 2970 was the second pick at Northstar and 2549 was 15th.

Thanks for catching this. There'll be an update released to address this database error.

AcesPease 07-04-2009 22:00

Re: paper: 2009 Team 1114 Championship Scouting Database
 
I searched and found that 716 and 1124 are missing from the database.

IndySam 07-04-2009 22:01

Re: paper: 2009 Team 1114 Championship Scouting Database
 
The record for 829 at Boilermaker is incorrect.
We were 6-5, 16th seed and Semi-finalist.

GreerD 07-04-2009 22:10

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Wow. This is great. Thank you to 1114!

Karthik 07-04-2009 22:10

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Quote:

Originally Posted by AcesPease (Post 847239)
I searched and found that 716 and 1124 are missing from the database.

Yup. We received a bad dump of data, so there are about 136 missing teams. We will be releasing a new version very shortly.

Quote:

Originally Posted by IndySam
The record for 829 at Boilermaker is incorrect.
We were 6-5, 16th seed and Semi-finalist.

The elimination performance is being fixed. As for the record, according to the FIRST site we have you at 5-5.

http://www2.usfirst.org/2009comp/eve...chresults.html

If these standings are incorrect and someone has the correct version, please pass them along via PM.

Also, we are looking for complete alliance selection data from both Minnesota events. If anyone has the full draft order, it would be greatly appreciated. (FYI, The FIRST site lists the teams in random order for elimination matches, so mining this data is one of our tougher tasks)

Tom Schindler 07-04-2009 22:21

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Converter to read with office 2003:

http://www.microsoft.com/downloads/d...displaylang=en

Thanks Karthik, you guys are awesome for providing this!

Tom

Chris Fultz 07-04-2009 22:29

Re: paper: 2009 Team 1114 Championship Scouting Database
 
Thanks to everyone on 1114 who worked on this - exceptional work.
What an awesome database.


All times are GMT -5. The time now is 17:34.

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