User Pass
Home Sign Up Contact Log In
Forum > USA AA Leagues > USA AA #2 > Eastern Conference Power Rankings Week 8
Page:
 
kikdadog
offline
Link
 
would be a good game, I hope so to
 
octones
offline
Link
 
OK, went through and cleaned up some of my formulas and I think this is a much better representation now. The power ranking standings didn't change much but the "strength of schedule" did. I would try to explain what I am doing but that would take too long. If anyone would like to take a serious look at my spreadsheet to help improve it, let me know.

I hope these are enjoyable for people. They likely are not perfect but it is all done for fun and to generate some more discussion.

You will still see a team higher than a team they lost to (Stalkers higher than Bisons for example) due to the calculated strength of schedule. A lot of that can be attributed to one common game between them, the Vultures. The Stalkers won 44-7 and the Bisons won 33-21. Same with the games against the Mountaineers. The rankings take in to account points scored against the rank of that team against the points allowed against the rank of that team, in short. So, even though the Bisons beat the Stalkers by 3, the Stalkers are 205-55 against common opponents while the Bisons are 176-86. So they end up close in the power rankings but the results against common oppenents favors the Stalkers. (I only checked that out due to me being on the Stalkers I am sure there are other similar situations)

Enjoy! Will likely make a new thread with the new rankings tomorrow morning for week 9.
 
cwcapper
offline
Link
 
Originally posted by octones
OK, went through and cleaned up some of my formulas and I think this is a much better representation now. The power ranking standings didn't change much but the "strength of schedule" did. I would try to explain what I am doing but that would take too long. If anyone would like to take a serious look at my spreadsheet to help improve it, let me know.

I hope these are enjoyable for people. They likely are not perfect but it is all done for fun and to generate some more discussion.

You will still see a team higher than a team they lost to (Stalkers higher than Bisons for example) due to the calculated strength of schedule. A lot of that can be attributed to one common game between them, the Vultures. The Stalkers won 44-7 and the Bisons won 33-21. Same with the games against the Mountaineers. The rankings take in to account points scored against the rank of that team against the points allowed against the rank of that team, in short. So, even though the Bisons beat the Stalkers by 3, the Stalkers are 205-55 against common opponents while the Bisons are 176-86. So they end up close in the power rankings but the results against common oppenents favors the Stalkers. (I only checked that out due to me being on the Stalkers I am sure there are other similar situations)

Enjoy! Will likely make a new thread with the new rankings tomorrow morning for week 9.


Nobody here will question your bias in your own power rankings. No need to explain yourself.
P.S. Thanks for doing this. Its always fun to have power rankings to look at.
 
octones
offline
Link
 
There is no bias, it is purely stats.
 
cwcapper
offline
Link
 
Originally posted by octones
There is no bias, it is purely stats.


Come on dude. You have to factor in head to head games. If you put that in the formula, I think that Buffalo leapfrogs your team in the standings. Margin of victory clearly isn't an indicator of who is better or strength.
 
octones
offline
Link
 
Originally posted by cwcapper
Originally posted by octones

There is no bias, it is purely stats.


Come on dude. You have to factor in head to head games. If you put that in the formula, I think that Buffalo leapfrogs your team in the standings. Margin of victory clearly isn't an indicator of who is better or strength.


And I understand that but I haven't been able to work that in to my formula yet. That is the hardest part to incorporate, IMO. I've stated like 10 times that these aren't perfect, but everyone can be assured I am not leaving things out to try to make my team look better. I have no bias, it is a game I have fun with.

Whenever I figure out a way to better incorporate head to head matchups, I will do so.
 
cwcapper
offline
Link
 
Fair enough. Thanks again.
 
octones
offline
Link
 
Updated once again, hopefully my formula incorporates everything now.
 
cwcapper
offline
Link
 
Very nice.
 
Page:
 


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