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.
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.
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.
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.