White Paper Discuss: Karthik's 2005 Championship Scouting Database

[Karthik]

Thread created automatically to discuss a document in the White Papers.

Karthik\'s 2005 Championship Scouting Database (http://www.chiefdelphi.com/forums/papers.php?&action=single&paperid=487) by Karthik

[Beth Sweet]

This thing is so cool guys! Seriously, Karthik let me play test dummy and this thing has stats on every team going to Championship! Check it out it's a great resource!

[Jeff Rodriguez]

Great job, Karthik.

[Karthik]

In response to this thread (http://www.chiefdelphi.com/forums/showthread.php?t=36816) started by Dr. Joe, I decided to compile all the information that was being looked for. It was no small effort, as accurate results have been hard to come by this year. But after some long hours and a few Red Bulls, here it is.

There is some missing data, if anyone can help fill in these gaps, please send me a PM or an email. The list of what is missing can be found on the "notes" tab of the spreadsheet. The most important missing data is from the elimination rounds of the St. Louis and Long Island regionals.

Also, I am missing a whole bunch of the team nicknames. If anyone is up to the task of finding them, send me a list, and I'll make an update.

The division info is obviously missing, I'll post an update on Monday as soon as it comes out.

Thanks to everyone who helped me out with this project.

If you have any questions, comments, suggestions or corrections, please let me know via PM or this thread.

Enjoy,

[Joe Johnson]

Very nice. Thank you. I hope you will update it with the divisions when they are out. From here, I will typically pull together a pocket excel version of each division that lets me see whos done what with only my iPAQ in hand.

Great work. Thanks again.

Joe J.

[BandChick]

Wow, Karthik, this is...incredible. I'm emailing it to my head of scouting, well, I will after its latest update. If you'd like to add, as well, Team 1089's nickname is "Team Mercury." If not, hey, that's chill too. :)

Awesome job, seriously. Can't wait for Atlanta!

[Karthik]

I'll have an update tonight before I go to bed, with all the additions that people have sent in to me today.

Thanks to Andy Baker and Jess Jankowitsch, I now have all the team nick name data!

[richardp]

Such a great job! This is an amazing resource to have available!

[Mark McLeod]

Here's what I remember offhand from the Long Island Regional. I can fill in some more of the holes later.

[Karthik]

I'll have an update tonight before I go to bed, with all the additions that people have sent in to me today.

Thanks to Andy Baker and Jess Jankowitsch, I now have all the team nick name data!

I've uploaded the latest version of the spreadsheet, just waiting to have it approved my a moderator. A few bugs have been worked out, a few blanks have been filled, and the team nickname data has been added.

I'll get working on the data for the last 8 teams to register.

[Lost_Era]

Karthik,

Thanks for the great spreadsheet. Just wanted to let you know that FIRST now has full or partial match results posted for GLR, PIT, and MO. I downloaded the ones for GLR and PIT into a spreadsheet to determine the team records among other things. Let me know if you would like me to send you the spreadsheets or the records?

[Karthik]

Karthik,

Thanks for the great spreadsheet. Just wanted to let you know that FIRST now has full or partial match results posted for GLR, PIT, and MO. I downloaded the ones for GLR and PIT into a spreadsheet to determine the team records among other things. Let me know if you would like me to send you the spreadsheets or the records?

The more data the better. I know the reported data for Pittsburgh and St. Louis is incomplete, but the GLR qualification rounds look alright. If you've complied, please send it over. I just sent you a PM with my contact info (it's also in the spreadsheet).

[slickguy2007]

I don't have excel, anybody know of a way I can still view it? Thanxs.


GO 1403!!!

[mtaman02]

You the man! Rep Point for helping us scouting people out, This spreadsheet holds alot of information containing the teams competing record for the 2005 season. This must have taken some time I bet =)

[Yan Wang]

I don't have excel, anybody know of a way I can still view it? Thanxs.


GO 1403!!!

http://www.openoffice.org/

[Al Skierkiewicz]

Nice going, I am impressed. Thanks for compiling all the data.

[Karthik]

Here's the latest version...

http://www.chiefdelphi.com/forums/papers.php?action=single&paperid=486

I'll be publishing an update on Monday once the divisions come out.

Thanks to everyone who has sent me updates. Keep them coming.

[Joe Johnson]

The more data the better. I know the reported data for Pittsburgh and St. Louis is incomplete, but the GLR qualification rounds look alright. If you've complied, please send it over. I just sent you a PM with my contact info (it's also in the spreadsheet).

Please double check -- make sure team #1 is ranked #1 with the data as reported. I THINK I recall that the GLR data was reported with the scores backwards or upside down or inside out or something. I am not sure, but I think my brain has a tingly feeling. For what it's worth.

Joe J.

[thoughtful]

WOW, comprehensive data. Scouting at the nationals is never easy with a handfull of people. This will be a great resource for all of us. Does anyone know how Karthik has soo much time on his hands? :confused: :rolleyes:

[Karthik]

Please double check -- make sure team #1 is ranked #1 with the data as reported. I THINK I recall that the GLR data was reported with the scores backwards or upside down or inside out or something. I am not sure, but I think my brain has a tingly feeling. For what it's worth.

Joe J.

Joe,

I have yet to use the data from the FIRST website regarding the GLR qualification rounds. You're right, something seems fishy about it. If I stay in tonight, I'll try and figure it out.

[Bill_Hancoc]

Great Job first off (no pun intended) and the format is amazingliny simple to use!

[Tytus Gerrish]

cool

[ellenchisa]

Last time I checked the issue with the great lakes data was that red/blue scores were flipped.

It seems to be right, when I check now, though...


Oh and that's incredibly useful. Thanks so much...

[dubious elise]

Karthik, you are my hero! Consider this post a "digital hug" from me to you.

[PatrickN]

wow, nice job Karthik.

I feel kind of bad that you're only missing info from a couple of regionals and two of them are pittsburgh and southern california, must be the crazy Canadians screwing up the scoring systems down south. Anyways, I'll see what I can dig up from 188's scouting (some things unfortunately get tossed when you do everything with paper and pencil :rolleyes: ).

-Got pittsburgh stats done, it was like a puzzle since we had bits and pieces and they just needed to be put together and have the blanks filled in, don't worry everything worked out mathematically (i think). Now for the tougher job of socal...

[Joshua May]

Wow Karthik, this is amazing. Excellent work.

[Karthik]

The latest version, with all the divisions...

http://www.chiefdelphi.com/forums/papers.php?action=single&paperid=487

[petek]

The latest version, with all the divisions...

http://www.chiefdelphi.com/forums/papers.php?action=single&paperid=487
Thanks for getting this out so quickly! FIRST doesn't go alphabetically for the division names, though, so Galileo and Newton are switched. That is, they went A, C, N, G where yours go A, C, G, N.

[Mark McLeod]

It's correct in Karthik's "Raw Data", so the queries return the correct division.
It's only the titles on the "Division" worksheet that are switched.

[Karthik]

It's correct in Karthik's "Raw Data", so the queries return the correct division.
It's only the titles on the "Division" worksheet that are switched.

Thanks to both Peter and Mark for noticing that.

I made the "Division" sheet up as a quick reference. Note to self: Don't do things quickly...

As Mark said, the "Raw Data" sheet is correct, so all data which is fetched through the "Interface" sheet will be correct.

[the_short1]

awsome stuff!! this is a good GUIDELINE for scouting, .. scouting teams should still do scouting reports but at least they can already have some idea on each of them.. . some teams must also be judged on other things besides scores etc. but still awsome resource and thank you very much

the fianls at GLR.. well i can help verify that.. .... i dont see a problem at least for the matches team1596 played in.. they are all correct.. maybe they fixed it ?

shrue blame the canadians eh ? .. pff.. :p


-kevin
scouting team of team1596

[petek]

Never one to leave well enough alone, and with apologies to Karthik, I added worksheet tabs for each division, with the basic team statistics for each regional, to his beautiful database and posted it as a whitepaper (http://www.chiefdelphi.com/forums/papers.php?s=&action=single&paperid=490).

[edit]: updated link to corrected whitepaper file.

[Karthik]

Never one to leave well enough alone, and with apologies to Karthik, I added worksheet tabs for each division, with the basic team statistics for each regional, to his beautiful database and posted it as a whitepaper (http://www.chiefdelphi.com/forums/papers.php?s=&action=single&paperid=488).

Peter,

Great work. That saves me some work. :) With your permission, I'll be using this version for any further updates.

[petek]

Peter,

Great work. That saves me some work. :) With your permission, I'll be using this version for any further updates.
Hey, it's a collaboration!

You're welcome to it, but I just found a couple of formatting errors (on my part) where team records of 2-10-0 are displayed as 21-0-0. Now, I'm sure the affected teams won't mind the inflation, but do you know if there is a way to replace the whitepaper's linked file?

[Edit]: I just posted a corrected file to the whitepapers and will correct the link above when the new whitepaper gets its stamp of approval.