Dynasty Ranking Tool

[HailState89]

I know this is probably the wrong page to post this but I feel like this is the most active. I made my league a ranking system that ranks everyone's WR1, WR2, RB1, RB, etc, using ADP then assigning a weighted average score. Then it assigned a score to each team, all as a formula. It works out so that the "average team" is 100. Here is a screenshot of what the end result looks like:



There have been multiple trades the last couple days (2-3 blockbuster) as a result because the worse teams can see just how bad they are and the middle teams can see how close they are to the top.

It's a pretty simple file where all you do is enter everyone's team and it looks up the players ADP and ranks each player by itself.

Here is link to file: https://dl.dropboxusercontent.com/u/244 ... ystem.xlsx

[derekhiny]

Seems interesting. I'll check it out. I'll send you a pm with my email.

[Whatevs6]

Sounds very interesting. The screenshot didn't work though.

[bot]

Seems cool. I'd like to check it out. I'll send you a PM with my email also. Thanks for sharing

[HailState89]

Sent to yall who PMed me

[Never Veto1]

Sounds Interesting, I'd like to check it out

[sugbear65]

I thought by the title of the thread, we were talking about Bcoogan23!

(Sorry Bcoogan, I actually appreciate a lot all the work u put into your rookie reviews and forum contributions. Just, low hanging fruit and all that, plus u seem like you could take the joke.)

[derekhiny]

I thought by the title of the thread, we were talking about Bcoogan23!

(Sorry Bcoogan, I actually appreciate a lot all the work u put into your rookie reviews and forum contributions. Just, low hanging fruit and all that, plus u seem like you could take the joke.)

Holy bleep, that just made me laugh. I also appreciate your posts and all you do for the forums, Coog. But funny is funny.

[DrNoish]

I thought by the title of the thread, we were talking about Bcoogan23!

(Sorry Bcoogan, I actually appreciate a lot all the work u put into your rookie reviews and forum contributions. Just, low hanging fruit and all that, plus u seem like you could take the joke.)

Sorry Coog, that's just funny

[JJDubya]

I thought by the title of the thread, we were talking about Bcoogan23!

(Sorry Bcoogan, I actually appreciate a lot all the work u put into your rookie reviews and forum contributions. Just, low hanging fruit and all that, plus u seem like you could take the joke.)

[skip]

At first blush there seems to be a component missing but I am not certain. Are you weighting their ADP? i.e. the difference between the player at 1.01 and 3.01 is far greater than the difference between the player at 9.01 and 11.01, for example...

[HailState89]

The positions are weighted. Having the best WR1 weighs more than having the best Flex1, etc.

[Parker8]

what are you using as a general theory for weighting their score?

[Whatevs6]

I thought by the title of the thread, we were talking about Bcoogan23!

(Sorry Bcoogan, I actually appreciate a lot all the work u put into your rookie reviews and forum contributions. Just, low hanging fruit and all that, plus u seem like you could take the joke.)

LMAO

[DrNoish]

Received the e-mail. It's pretty interesting so far

And thanks for sending it so quick!