User Pass
Home Sign Up Contact Log In
Page:
 
mcallero
offline
Link
 
Iguazu_Cn has a great formula for running power rankings. Mineras has been using his spread sheet to run them in another league I am in, and I really like them. So, I asked Iguazu to do them for our league, and he was cool enough to oblige.

The Rankings Summary for the ALPHA conference:

Rank Team - Rating (Change from last week)
1 København Hühnerfalken - 13.451 (--)
2 Stockholm Black Death - 13.191 (--)
3 Torpedo Cowthorpe - 12.659 (--)
4 iue5 acolytes - 12.456 (--)
5 Passion Fruits - 12.443 (+2)
6 Natural Born Killers - 12.115 (--)
7 Vatican City Fighting Popes - 12.065 (+1)
8 Ingolstadt Htossers - 11.963 (-3)
9 East Cairo Argonauts - 11.427 (--)
10 Cambridge Chieftains - 10.432 (--)
11 Warfield Hellbringers - 9.437 (--)
12 Heidelberg Hitmen - 9.073 (--)
13 Red River Ruminants - 9.034 (--)
14 Tilburg Dream - 8.130 (--)
15 Amsterdam Dragon's - 7.686 (--)
16 Nikopolis Stoic Hedonists - 5.681 (--)


The Rankings Summary for the ZETA conference:

Rank Team - Rating (Change from last week)
1 Philadelphia Ground and Pound - 13.996 (+1)
2 Liverpool Legend Killers - 13.853 (-1)
3 Italian Stallions - 13.576 (--)
4 The Evil Empire - 13.401 (--)
5 Salzburg Hornets - 12.836 (--)
6 Prague Defenestrators - 12.207 (--)
7 Amsterdam Chronic Crusaders - 11.379 (--)
8 London Rippers - 10.696 (--)
9 Manchester Divided - 9.877 (--)
10 Starcraft DarK Archons - 9.126 (--)
11 Borum Hill Treble - 8.637 (--)
12 Lisbon Crusaders - 7.401 (--)
13 October Wildfire - 6.871 (--)
14 Reykjavík Polar Bears - 6.394 (--)
15 Matterhorn Marmots - 5.442 (--)
16 Phi Kappa Leesburg - 4.079 (--)

Once again, I would like to thank Iguazu_Cn for doing this for us. I will post it with a spread sheet later, which will explain the formula he uses.
 
mcgovern10
offline
Link
 
Awesome work, mc. Whatever the formula he uses I like the end result a lot better than the Wikipedia deal as it seems a bit more straightforward.
 
mcallero
offline
Link
 
Yeah, he will be sending me the spread sheet later, which explains all of the parts of the equation. He does them in Africa AA1 and I really liked them. Your team would be a great deal higher if you didn't drop some of those early games.
 
ig
offline
Link
 
Here's the summary of the results, with a tab that explains how the rankings are calculated (not particularly straight forward).

http://spreadsheets.google.com/pub?key=pOUigrsS32wKtQMaHx2_PIw

FYI: I can give anyone access to the real spreadsheet that calculates the formula, but because of all the data that it uses and generates, the macros it has, the MANY formulas and cross-references, etc. it's over 2 MB and Google Docs can't handle it, so it's easier to access it through my FTP site.
Last edited Dec 7, 2008 20:51:54
 
merenoise
offline
Link
 
Very nice.
 
ig
offline
Link
 
For anyone that cares, here is what my rankings sheet gives after week 14. http://spreadsheets.google.com/pub?key=pOUigrsS32wKtQMaHx2_PIw

Here's also the summary in case you don't want to look at the spreadsheet:

The Rankings Summary for the ALPHA conference:

Rank Team - Rating (Change from last week)
1 København Hühnerfalken - 13.619 (--)
2 Stockholm Black Death - 13.296 (--)
3 Torpedo Cowthorpe - 12.844 (--)
4 Passion Fruits - 12.620 (+1)
5 iue5 acolytes - 12.548 (-1)
6 Natural Born Killers - 12.281 (--)
7 Vatican City Fighting Popes - 11.734 (--)
8 Ingolstadt Hat Tossers - 11.722 (--)
9 East Cairo Argonauts - 11.149 (--)
10 Cambridge Chieftains - 10.136 (--)
11 Warfield Hellbringers - 9.204 (--)
12 Red River Ruminants - 9.028 (+1)
13 Heidelberg Hitmen - 8.963 (-1)
14 Tilburg Dream - 8.623 (--)
15 Amsterdam Dragon's - 8.043 (--)
16 Nikopolis Stoic Hedonists - 5.614 (--)


The Rankings Summary for the ZETA conference:

Rank Team - Rating (Change from last week)
1 Philadelphia Ground and Pound - 14.080 (--)
2 Liverpool Legend Killers - 13.825 (--)
3 Italian Stallions - 13.738 (--)
4 The Evil Empire - 13.575 (--)
5 Salzburg Hornets - 12.492 (--)
6 Prague Defenestrators - 11.943 (--)
7 Amsterdam Chronic Crusaders - 11.683 (--)
8 London Rippers - 11.055 (--)
9 Manchester Divided - 9.568 (--)
10 Starcraft DarK Archons - 9.097 (--)
11 Borum Hill Treble - 9.025 (--)
12 Lisbon Crusaders - 8.022 (--)
13 October Wildfire - 6.777 (--)
14 Reykjavík Polar Bears - 6.313 (--)
15 Matterhorn Marmots - 5.479 (--)
16 Phi Kappa Leesburg - 4.196 (--)
 
davidwest
offline
Link
 
Sweet a solid 12th place! Won two more games than I expected this year, it was a successful season.
 
Balls Models
offline
Link
 
thanks! i think these are very accurate.
 
ig
offline
Link
 
Updated after week 15. http://spreadsheets.google.com/pub?key=pOUigrsS32wKtQMaHx2_PIw
 
proaxis
offline
Link
 
im starting to buy the fact that the better top tier is in zeta.
 
H0wie Dewum
offline
Link
 
Originally posted by proaxis
im starting to buy the fact that the better top tier is in zeta.


yezzir
 
proaxis
offline
Link
 
Originally posted by H0wie Dewum
Originally posted by proaxis

im starting to buy the fact that the better top tier is in zeta.


yezzir


of course, if the falken were beating up on the dog meat you have over there we might look good too.
 
H0wie Dewum
offline
Link
 
of course, you'll get bit by the dog if you come over here. That might make the falken look real bad...

Hypocracy disgusts me - especially if it's used to bolster your own ego. Weak sauce dude.
Last edited Dec 10, 2008 19:12:15
 
Flame
offline
Link
 
Originally posted by H0wie Dewum
of course, you'll get bit by the dog if you come over here. That might make the falken look real bad...

Hypocracy disgusts me - especially if it's used to bolster your own ego. Weak sauce dude.


Now now, we'll settle this in the finals...
 
H0wie Dewum
offline
Link
 
ohhh okay... If I have to...
Last edited Dec 10, 2008 20:50:41
 
Page:
 


You are not logged in. Please log in if you want to post a reply.