California Rankings

[Joe Ross]

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.

Interesting, I just searched Missouri, and they showed up (team 4522, right?). I did notice when I did it for CA that the order was somewhat weird. It was nominally based on team number, but there were a few teams that were not in order. I had the opposite problem, there were 3 teams that showed up that are not registered for an event in 2013. No one's complained yet of not being included, but maybe I'll find out later...

Originally Posted by Jaxom

Did you build a spreadsheet with lookup tables for the points, or did you calculate manually? If the former, care to share?

Manual. At this point, I'm not sure that it would be much faster to put in lookup tables, as the slow part would be getting the data from the different sources and putting it in the format the lookup tables expect. I'm not sure what FiM does, it's either manual, or it's done in another spreadsheet and then only the values are posted.