View Single Post
  Spotlight this post!  
Unread 21-11-2013, 00:21
Nemo's Avatar
Nemo Nemo is offline
Team 967 Mentor
AKA: Dan Niemitalo
FRC #0967 (Iron Lions)
Team Role: Coach
 
Join Date: Nov 2009
Rookie Year: 2009
Location: Iowa
Posts: 803
Nemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond repute
How do the 2014 Regionals and Districts stack up?

Here are some fun things that interest me:

Jim Zondag's history spreadsheets
Ed Law's scouting spreadsheets
Team 358's awards database
The new common district points system
"What's the Toughest Regional" threads
This graph, also from Jim Zondag

Drawing inspiration (and data) from the items above, I've crafted some giant spreadsheets in the past few years to combine the available performance data with the twin goals of 1) assigning a performance index score to each team, and 2) using those scores to figure out which events have the toughest competitive fields. The spreadsheets are too large to upload to ChiefDelphi, unfortunately (I've tried). Nevertheless, here are a couple of fun charts that I made using my latest incarnation.

2014 Competitions Comparison.pdf
2014 Competitions Comparison 2.pdf

These graphics attempt to describe all district / regional competitions in terms of strength of their top tier teams as well as the depth of teams further down their team lists. To clarify, "Performance Index of Teams 7-16" means the average calculated performance index of the teams at that event who rank 7th through 16th in terms of the calculated index.

This calculated performance index for each team is based on their competition results (wins, alliance selections, elimination rounds) and awards since 2008. The system is partly based on the new district points system, but it's not identical. It includes an OPR component (so shoot me). For the most part, the same teams end up on top no matter what system one uses.

Enjoy!

Edit: Here's an attempt at hosting the spreadsheet:
Spreadsheet Download (30+ MB)

Last edited by Nemo : 21-11-2013 at 14:16. Reason: Link