Divisions 2012

[jwfoss]

Originally Posted by Tom Ore

Divisions sorted by OPR from Ed Law's database.

Any chance you can post that in a format I can work with in excel?

[Tom Ore]

Originally Posted by jwfoss

Any chance you can post that in a format I can work with in excel?

Sure - the columns actually look correct in edit mode, but the tabs don't work in display mode

[EricH]

Originally Posted by Tom Ore

Sure - the columns actually look correct in edit mode, but the tabs don't work in display mode

Use the [code] tags.

[jwfoss]

Here are some interesting plots I put together really quickly. The first one is of all the teams going to St. Louis, the second is the top 50 from each division.

Newton appears to be the strongest overall division...

Data is directly from Ed Law, as posted above.

[big1boom]

Based on average OPR.

Arch	Curie	Galileo		Newton			
12.691	12.601	12.61919192	14.18080808

Looks like Newton wins for OPR

Still definitely looking forward to Archimedes. (Might have something to do with competing in it)

[GCentola]

Originally Posted by jwfoss

Newton appears to be the strongest overall division...

I don't have a bunch of data of my own, but I would defintiely agree with you there. Newton will definitely put up a great show (and 1126 is lucky enough to be a part of such a great division, especially with some of our local friends).

A 469-1717 combo could be deadly, although there are many more that would prove frightening. I can't really say anything bad about any of the divisions, it is Championships after all. Everyone is playing at such a high level and there are so many great teams (398 so far!)

[stundt1]

Archimedes is my predicted to win.

they have 67 1114 2056 359 1218 973 and even more......

It seems like the toughest division to win. The 1114 and 2056 powerhouse couple seems like it could get broken up again this year.

[Nate Laverdure]

Originally Posted by jwfoss

Any chance you can post that in a format I can work with in excel?

For Excel 2007:

• Copy data
• Paste into Excel
• Data tab > Text to Column button
• Select Delimited > Click Next
• Select Space > Click Next
• Click Finish
• Enjoy!

[jwfoss]

Originally Posted by Nate Laverdure

For Excel 2007:

• Copy data
• Paste into Excel
• Data tab > Text to Column button
• Select Delimited > Click Next
• Select Space > Click Next
• Click Finish
• Enjoy!

Thanks, I forgot how to use excel for a bit there. I got it to work just before your post.

[alectronic]

if anyone else would like it:

http://www.2shared.com/file/cQGkZxN8/opr.html