Jump to content
Sign in to follow this  

ADP adjustment

Recommended Posts

So in my keeper league, we have 23 players already slotted to draft picks. As a result, the ADP for the remaining players are a little skewed. Would I be able to manually adjust ADPs so I have more clear predictor when a player might go off the board or any other suggestion?

Share this post

Link to post
Share on other sites

I do find the numbers spit out by ADP a little odd sometimes, and therefore pay more attention to the order. Even on the offense tab I scan the lowest numbers of available players to see who I expect to go next.


I suppose what you could do is try adjusting the adp by converting the existing number - say Amari Cooper, 4.01 - to a single integer, and then adjust for the kept players.


4.01 would become 4 x 12 + (1 - 1) = pick 48. Then subtract 23 from that, bringing him down to 25. Covert back if you like...


=CONCATENATE(FLOOR(25/12),".",IF(25-(FLOOR(25/12)*12)+1<10,0,""),25-(FLOOR(25/12)*12)+1) ... this should work out to 2.01


Put your formulas in a blank column to the right on your offense tab (do not insert any columns), and then once calculated for all players you can copy the results, and paste special > as values, back into the ADP columns on your offense tab.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this