I wanted to see how the teams in the Texas District would stack up if they were placed as a group for the IR@H skills competition.
I simplified the actual computed scoring a little. It simply looks at the max and min scores in an event. The best score gets a computed value of 150. The worst score gets a value of 50. The rest of the scores are linearly distributed between the two. I took out the outlier adjustments so this is not totally official and the way the scores were computed per the manual. I did this for two reasons. 1st I didn’t like the way that some teams won three of their events and were still in second place. 2nd and probably more important is it was easier and I didn’t have to do any real programming and could do it on a spreadsheet. In this data set there were not any huge outliers that would cause one event to become too overweighed, so I think this approach gives a good indication on how teams stacked up. If anyone wants to go through the full algorithm in the manual feel free, but I suspect the results will be similar.
The full results can be seen here. Click on the Texas Tab.
The Top 25 with the computed scores are below:
|4||3310||Black Hawk Robotics||439.7880544|
|11||7121||Keller Fusion Robotics||399.7316246|
|12||1296||Full Metal Jackets||399.3341131|
|18||2714||?? BBQ ??||386.4438621|
|23||4192||Flower Mound Tech Club Jaguar Robotics||377.7270625|
When I initially posted I did not have my VLOOKUP set to absolute so if a team was not playing it went to the next team with the closest number. So there were some obvious errors. I think I have everything corrected now. If you see something that is off let me know.