California Rankings

[Jaxom]

Originally Posted by Joe Ross

I used the FIRST website team search to find all of the California teams. I then used Ed Law's 2013 Regionals/Districts Teams are Attending to figure out what events they were attending.

I use the FIRST rankings page for event the W/L/T points. I then use the 2013 Alliance selection thread for the elimination results. That is 24 different manual assignments for pick position, and 12 different manual assignments for elimination finish. Then I do the awards manually, which probably takes the longest, but isn't too bad. It's not more then half an hour per event.

Next week will be the hardest, 2 CA events and CA teams attending 3 regionals outside CA.

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.

Did you build a spreadsheet with lookup tables for the points, or did you calculate manually? If the former, care to share? I might try again now that I'm recovered (mostly) from the weekend. It'd be a great excuse not to start on our taxes....