Looking for suggestions!

[timothyb89]

Wow, thanks for some awesome suggestions!

I'm working on standings data (coop. bonus, hanging points, seeding score, etc) right now (our crawler is running as I type this) so we should have that up in an hour or so. I'll also finish up the crawlers for elimination matches and awards so we'll have that data sometime tonight as well.

Awards data we currently have is just going off of the team info pages from FIRST's team finder. We pulled most of our initial data before the season started so most of what we've got doesn't include 2010 events (some data may have it from scans later in the season, though). With the new data we're pulling in tonight, we should be able to correct this.

With the fresh standings data, rankings, seeding scores, co-op. bonuses, and hanging points should also be made available and I'm adding that to our interface right now. As for final standings, I can't say for sure we can get that data as it isn't available from FIRST.

Great suggestions for the extra links as well- they should be added in soon. As for the statistics- great! I'll consult with our resident statistics expert and see what we can do about adding them in with the data we've got. And apologies for the general slowness- the database we're using is pretty slow; I'm planning on replacing it at some point in the near future.

Again, thanks for the suggestions, and keep 'em coming!

[Siri]

No problem, this is an awesome project! Great work by your team, and I look forward to seeing what you come up with next.

Originally Posted by timothyb89

...As for final standings, I can't say for sure we can get that data as it isn't available from FIRST.

Again, I'm not a programmer, but in a way it is. In the elimination match results section of each FIRST event page, the quarter-finalists are the teams that play in the QFs but nots the SFs, and the semifinalists are those that play in the SFs but not the finals. Of course, this gets complicated if there's a replacement bot. (I guess you'd need to look for alliance sets that share teams, rather than that are exactly the same. I have no idea how to do that.) Back before I discovered the wonder was is 1114's scouting, I used to to this by hand. It might be an interesting project if you're up for it, but I have no idea what it entails technically. Good work, regardless!

[EricH]

Final standings are typically available. However, you can't go to the team's page for it--go to the event pages and hit the "standings" link for the event you want.

For example, the San Diego standings are at http://www2.usfirst.org/2010comp/eve.../rankings.html

Also note that there are links on that page to match results, match schedules, and awards. These links just might become your new best friend... TBA scrapes these pages for their data, I believe.

[Chris is me]

I don't know what you do differently than TBA other than give me OPR averages, which aren't very accurate anyway. If you're going to do that, at least also list Highest OPR and Last Event OPR too.

[timothyb89]

Originally Posted by Siri

Again, I'm not a programmer, but in a way it is. In the elimination match results section of each FIRST event page, the quarter-finalists are the teams that play in the QFs but nots the SFs, and the semifinalists are those that play in the SFs but not the finals. Of course, this gets complicated if there's a replacement bot. (I guess you'd need to look for alliance sets that share teams, rather than that are exactly the same. I have no idea how to do that.) Back before I discovered the wonder was is 1114's scouting, I used to to this by hand. It might be an interesting project if you're up for it, but I have no idea what it entails technically. Good work, regardless!

Figuring that out should be an interesting project! I've heard 1114 does it by hand, but hopefully we won't have to resort to that (I'm no fan of manual data entry!). At the very least I'll make sure to add in a "farthest point" stat for teams (ie, "this team finished at the qualifications/quarterfinals/etc").

Originally Posted by EricH

Final standings are typically available. However, you can't go to the team's page for it--go to the event pages and hit the "standings" link for the event you want.

For example, the San Diego standings are at http://www2.usfirst.org/2010comp/eve.../rankings.html

Also note that there are links on that page to match results, match schedules, and awards. These links just might become your new best friend... TBA scrapes these pages for their data, I believe.

I just added that in last night- we have a clone of FIRST's pages with that data up now (such as this one). Now we're just looking for something interesting to do with that new data!
(Those pages are actually where we collect all of our data- a great resource put up by FIRST!)

Originally Posted by Chris is me

I don't know what you do differently than TBA other than give me OPR averages, which aren't very accurate anyway. If you're going to do that, at least also list Highest OPR and Last Event OPR too.

Just added in highest OPR. Not sure what you mean by 'Last Event OPR', though... could you clarify that?

We've got some things TBA doesn't have yet (mostly OPR/other stats and standings at this point), although admittedly not too much. But over the summer we'll be adding lots of new features to help justify the db's existence .

[Chris is me]

Originally Posted by timothyb89

Just added in highest OPR. Not sure what you mean by 'Last Event OPR', though... could you clarify that?

Nice adds. Last Event OPR is just the OPR of the last event that team attended. It helps show if they improved a lot compared to their average OPR.