tl;dr find out if your team is going to district championships before all the events are over!
I’ve been sitting on this project for quite some time and decided to finally get working on it, and I have it working up to a point where I feel comfortable releasing it for use.
Right now there arn’t too many teams locked in, but for an example of how it works check out Indiana, Israel, or Peachtree districts.
The idea stems from AGPapa’s ranking/lock in spreadsheet that he runs every year and wishing I could see it update in real time as the events progress. He also helped me out with the methods used to calculate which teams are locked in, so I’d like to thank him for that. Also a huge thank you to The Blue Alliance for their API, a logo will be added on the bottom of the page with the others linking to TBA eventually. <3
My end goal for this project is simply just a tool teams could use to easily access district rankings in one convenient place, as well as a live updating display of where teams stand in regards to a DCMP invitation while they compete. Perhaps seeing that they are currently below the cutoff while playing their last event could be the kick in the butt they need to make the extra push to the finish line.
The lock % column indicates how secure that team’s DCMP slot is. Once this value reaches 100%, the team is considered locked in and becomes highlighted in green. Teams not yet locked in but still have a chance to attend DCMP are highlighted in yellow. Teams who have played two district events and are below the cutoff are highlighted in red, as they are locked out of DCMP (without chairmans).
Lock % is calculated by comparing the points still up for grabs in a district with the points needed to knock a certain team out of DCMP. The lock % for all teams will change as events progress, regardless if that specific team is playing that weekend.
Still to do list:
Consider Chairman’s teams as a lock
Make lock calculations more accurate while events are in progress (in between events its accurate)
Add a cutoff line at district CMP capacity
Account for teams playing a 3rd district event
Clean up code/make it run faster (try loading FiM…make a cup of tea while you wait)
At some point way down the line, perhaps a version for World CMP locks for teams competing at DCMP events.
Sortable Columns
Remove out of district teams
Compress down to one script
Add debug feature
Estimated rank column
Link to team’s TBA page
Please feel free to make more suggestions!
Shout out to my friend Paul who generously donated space on his web server to me!
The main suggestion I would think to do would be to have a column indicating the “lock percentage” of a team that has attended one district event, assuming they (and everyone else) attends a second district where they score an equal number of points.
I was running the numbers a bit last year (calculating my own team’s chances of making it to DCMP, in fact and an interesting data point I found was that the average team in NE improves by about 20%.
In fact, it turns out that the average team in every district improves, though the percentage varies by region and by game.
Anyways, just an interesting tidbit. I was surprised, seeing as I thought district points were zero-sum in nature
Make sure that you have all teams that are competing this year on your list. Your Michigan list is for sure incomplete. The team that i mentor 5547 was not on the list and i didn’t see a few other teams on the list. :o
I was running the same math last night, but calculated a different way. Last year, an Indiana team got in on a 37 (albeit with the help of at least one declining team, else the number would be 43). The year before, it was a 42 (and no declines).
My reckoning is that 1-14 are safely in at this point, whether they’ve played their second event or not, because they’ll be no worse off than 50 points. I don’t see someone in the 50s sitting on the sidelines this year, even with some Bizarro World situation where the sub-15-point club rallies and becomes all six robots in the finals. What makes several of them less than a 50% lock going into Perry Meridian?
I 100% agree. It’s just too early to actually consider them 100% in mathematically with this method. There are still technically enough points out there to knock them out. There’s no reason they shouldn’t be in though. The reason their lock percentage is so low is because theres just too many unclaimed points still available at this point. I guess to help ease this a little I can assume a score of 4 points per event for teams with unplayed events. That should suck up a huge amount of points and raise the percentages.
As for teams that are in on declines, I can’t really predict that. They’ll just be shown as locked out. If you’re in ~top 5 locked out teams you should keep an eye out for an invitation anyway.
I’ll look into both of these. I hadn’t realized TBA’s data included out if district teams (…Why??)
and an interesting data point I found was that the average team in NE improves by about 20%.