Hello Forum,
A little over a month ago the Indiana EP’s received a message that warned that due to an increase in events and decrease in teams that many events may not meet the standard 16 teams it takes to be a qualifying tournament. This caused stress for many EP’s and has started conversations about price’s of tournaments and vex’s registration fees. I wanted more data before I take a position on this and without knowing how many Indiana teams there are and when they signed up any sort of conclusion can not be proved. I know there is some sort of Update system on the Discord that reports when new teams sign up, if any of the mods over there know how to pull that data I’d be pretty grateful, as i’d rather not scroll through the thread and manually extract it.
I started tracking sign-ups in our state on every weekday around 9am each day on September 21st. Robot events will only display a capacity if the events has exceeded or met the event’s half capacity or the date is one month from the event’s date. This means I have only been able to track capacity at events that have reported their current open spots to robot events. If anyone knows away to glean the hidden information I would be interested to learn how.
Any way, its been over a month so I thought it was a good time to release the data for my local EPs and for any other data nerds out there. I have attached the excel sheet with my raw data for anyone that is interested. out side of just being interesting data, it will be nice to know after a few years of collection when the peak sign-up times are.
Graph #1
Indiana as of right now is at about half capacity for all our events, including a scrimmage (which is dragging our numbers way down). I know for a fact that we are above the 50% mark because two of the unreported events are mine and they are nearing their half way marks, Based on some minor interpolation of the data I’d guess we are closer to 60%, but I can’t know for sure without EPs telling me what the unreported events are actually at.
Graph #2
This graph shows the amount of signups we have had in our state since 9/21.
There are a few major spikes, the one earlier this week was the result of 59+ teams signing up. Since many events hit their half way mark well before the month before, I had to take that into account when those events went from reporting 60 open spots one day and 29 the next. In that case i would report the ▲spots as 1, not 31. It made the data look a little less crazy. This does mean that the data isn’t 100% representative of how teams sign up.
Graph #3
This is basically the inverse of the last graph, this shows the capacity of the whole state dropping as teams sign up.
A note on these graphs and the data I am attaching, I am fairly certain the times where the number of open spots slips into the negative is where EP’s expanded the size of their tournaments, could also be teams dropping out, but I have noticed Park Tudor’s capacity has grown since august, they may not be the only event to do that.
@Powerbelly , @BottomNotch , @Robo_Eng_13
you may find this data interesting.
-TheColdedge
Related Threads:
Average Cost of Tournamentss
Active Teams by Region
00DATA.xlsx (40 KB)