04-14-2006 05:36 PM

Karthik

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

A few people have been asking about it, so here it is. The Annual Niagara FIRST Championship Scouting Database. If there are any comments or concerns please let me know. If there are any major errors I'll try and post and update. Feel free to cannibalize this in any way you want.

Cheers and Good Luck.

04-14-2006 06:28 PM

Tom Bottiglieri

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Yet another great scouting tool from Karthik.. Good job!

Where did you find the UTC qual data? I'm still scouring for it.

04-14-2006 06:37 PM

Joe Ross

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Thanks Karthik

The champions and finalists for the SoCal regional are reversed. 330 was a finalist while 968, 1138, and 4 were champions.

Also, can you check the BAE Draft positions? I think 138 should be 2 and not 3, 296 should be 3 and not AC2, 1547 should be 14 and not 15, and 155 should be 15 and not 14. Either that, or the data FIRST currently has posted is wrong.

04-14-2006 09:35 PM

Richard Wallace

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Great job (again), Karthik.

There is some data missing for the eight teams that were at STL:

16 (The Bomb Squad)
71 (Team Hammond)
537 (Charger Robotics)
547 (F.E.A.R.)
650 (Hella's Angels)
967 (Mean Machine)
1625 (Winnovation)
1723 (FBI).

All these teams are listed as "Did Not Make Eliminations" for that regional, but all actually did.

16 was a finalist. 71, 537, amd 547 were the regional winning alliance. 650, 967, 1625, and 1723 were all either quarterfinalists or semifinalists -- I don't have notes from the STL eliminations, and the FIRST records have not been posted yet.

04-16-2006 12:51 AM

Sugar_Bunny

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

If I remember right...650 and their alliance were semifinalists and 1625 and their alliance were quarterfinalists.

04-16-2006 06:35 PM

Daisy

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

On behalf on 173, Thank you, thank you, thank you. You save me a lot of time, and energy.

Daisy

04-18-2006 06:58 PM

Lil' Lavery

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Great job again. I have some other incorrect data though:

1261
1414
1057
Regional WINNERs at Peachtree, not Finalists.
http://www2.usfirst.org/2006comp/Events/GA/awards.html

04-19-2006 11:37 AM

Peter Matteson

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Thanks Karthik,

I had just asked the kids to do this while on school vaction and they pointed me straight here.
Pete

04-19-2006 11:42 AM

Joe Matt

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Could you explain the divisions some more, what's AC4 mean? Sorry, I'm kinda stupid when it comes to that.

04-19-2006 11:46 AM

Peter Matteson

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

AC4 = Alliance #4 captain.

04-19-2006 02:54 PM

X-Istence

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Could this please also be posted in an csv so I don't have to go find a Windows machine with Excel?

Plain text works as well.

04-19-2006 02:59 PM

chaoticprout

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Very awesome, good job, one thing I saw,

1138, 4, and 968 were so cal regional winners, not finalists.

04-19-2006 06:16 PM

Lil' Lavery

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

The way it works is you imput a team number, and if they're going to Atlanta, the data from their regional events will appear in a chart. A plain text file of the "raw data" page will be alot harder to use quickly and effectively.

04-20-2006 08:10 AM

Peter Matteson

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Karthik,
Another mentor and I were trying to figure out how you calculate the value for seed %. We weren't able to quite figure it out. Can you explain that one?
Pete

04-20-2006 09:31 AM

Tim Delles

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Well from what I have seen the seed percentage is saying how much percentage of the competition you seeded higher than. Take for example 229. We seeded 6th at FLR.

Since there were 30 teams at FLR:

100% - (4(seed) / 30 (# of teams) * 100) = ~83%

the iner part gives you a the percentage of teams that did better than you. so just subtract that number from 100 and you get the number of teams you did better then.

04-20-2006 03:56 PM

Karthik

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Pete,

Let t = number of teams at the regional
Let s = the team's seed

Seed % = (t - s + 1)/t
= 1 - ((s-1)/t)

As Tim mentioned, this calculation produces the percentage of teams a given team was seeded higher than.

04-20-2006 07:26 PM

Beth Sweet

Re: paper: 2006 Niagara FIRST Public Championship Scouting Database

Ok, this post embodies the reason that Karthik has a degree in math and the rest of us don't...