MSC Team Ranking Changes pre to post MSC 2014

[AndrewPospeshil]

That's another thing that really skewed the alliance results at MSC this year; the game. Roles were incredibly important as opposed to just how good a robot was; seeding didn't matter as much as capabilities. This was also visible at Archimedes this year; the number 12 seeded team didn't even move on to elims (sorry, 639 :/). Any teams that didn't make it very far this year but still felt they had a good robot shouldn't feel bad. A lot of good robots just simply didn't bring anything new to an alliance so they weren't picked.

[Iaquinto.Joe]

I'm interested in further analyzing this data for this past season in addition to previous years, however I am missing data for post week-6 rankings for 2010-2014. Does anyone happen to have these spreadsheets available or know who I can contact to get them?

[Basel A]

Originally Posted by Iaquinto.Joe

I'm interested in further analyzing this data for this past season in addition to previous years, however I am missing data for post week-6 rankings for 2010-2014. Does anyone happen to have these spreadsheets available or know who I can contact to get them?

As far as I'm aware, that data is not available in the format you're asking for it. However, you could tally the points for each team from the individual district sheets.

[Joe Ross]

Originally Posted by Basel A

As far as I'm aware, that data is not available in the format you're asking for it. However, you could tally the points for each team from the individual district sheets.

It's generally easier to subtract the championship points then add up district points.

[Basel A]

Originally Posted by Joe Ross

It's generally easier to subtract the championship points then add up district points.

Sure. Either way it'd take a bit more work to reconstruct the tiebreakers, but certainly it's all public data. For the future, it would be nice to have a separate sheet in the workbook with the pre-MSC rankings.

[Ed Law]

For Basel and anyone else who is interested, here are the spreadsheets for the 4 years I was doing the Michigan State Rankings. These files include ranking before state championship. I always keep a copy of the spreadsheet before State Championship just in case.