I was a little bored tonight, so I wrote a small script that finds the way that each team attending the St. Louis Event qualified. The results are in Google Sheets, here. I’m not 100% clear on how District allocations work since I’ve never been a part of one, so please let me know if I did anything wrong there so I can fix it (though the absolute worst that would happen is a team or two would show waitlist instead of district points or vice versa).
Hope this is helpful/interesting to at least a few teams scouting! I attached the raw CSV as well in case someone wants that for whatever reason. Only thing is it runs a bit slow, but not too much I could do there besides a little more optimization with so many API calls.
After taking a quick look, it looks like you’re close with the district qualifications. There’s an odd corner case that occurs when district teams receive waitlist spots prior to their DCMP (which happens fairly often as far as I can tell). Basically, if a team receives a waitlist spot, they are guaranteed a spot to championships, which means that they are removed from the allocated pool of teams that can qualify through the DCMP (via both awards/winning and points). When this happens, if a waitlist team happens to win the competition, win Chairman’s, EI, or RAS, or have enough district points to qualify otherwise, their spot is handed down to the next available team.
In Indiana this year, 3494’s EI win after getting a waitlist spot earlier allowed another points slot to open up which allowed 4272, the next highest ranked team, to get a spot to worlds. Your script, however, is listing 4272 as a waitlist team which isn’t quite true. Still, fantastic work!
That seems fairly probable. That’s why I think there seems to be no erroneous (as far as I can tell) Chesapeake district qualifiers (week 6), but quite a few FIM (week 7). I don’t think there’s any way for me to collect this data though, but I’m going to try a sorta hacky way of fixing it.
I just took the next 5-10 ranked teams in a district and said that they might be district qualifiers if they’re in the Championship. Hopefully this minimizes errors, thought admittedly it might make some new ones arise where waitlisted teams are put down as district qualifiers. Not really sure of a way to completely eliminate the errors though, so for now I guess I’ll leave it this way and fix any errors people bring up manually.
Perhaps it would useful to simply show district rank as another column for district teams? Especially with the qualifying awards, which seem to take precedent over district ranking. Qualifying awards often don’t speak much to robot effectiveness.
I suppose it depends on your use case for this document. I know teams that have used this sort of thing in the past as a quick pre-match scouting document, just to get an idea of robot performance based on qualifying method.