[Basel A]

Originally Posted by Jaxom

So you basically did what I started; darn. Mine failed on step 1; the search for Missouri teams did NOT include every one. Team SCREAM from Sedalia (Rookie All Star in GKC) didn't show up on the list returned by my search; since we know them the omission was obvious. I was able to find them by using Sedalia's ZIP code in the FRC Teams search but I'm not going to spend the time to do 50-mile circles across the entire state to make sure I get them all.

Made a spreadsheet that should help you (possibly Joe and/or others). Shows the events all teams are attending with location filtering. http://www.chiefdelphi.com/media/papers/2798

I have no experience with web scraping so here's the automatic approach I thought of first: Because 2834 scouting databases include event results, you could grab qual W-L-T records automatically. But differentiating 1st pick from 2nd pick is problematic to do automatically in any fashion. Awards seems impossible to do automatically without scraping, but I can't imagine it'd be complicated. The awards are always in the same order and the tables are formatted pretty regularly.