What's new
Fantasy Football - Footballguys Forums

Welcome to Our Forums. Once you've registered and logged in, you're primed to talk football, among other topics, with the sharpest and most experienced fantasy players on the internet.

Convert raw ADP into ADP by round in Excel (1 Viewer)

Any excel experts out there who know how to do this?  I have raw ADP info but want to have it listed in my spreadsheet by round.  I'm in a 12 team league.  For example, an ADP of 26 = 2.02

Any help would be appreciated.

 

CalBear

Footballguy
Any excel experts out there who know how to do this?  I have raw ADP info but want to have it listed in my spreadsheet by round.  I'm in a 12 team league.  For example, an ADP of 26 = 2.02

Any help would be appreciated.
Round is =ROUNDUP(12/<cell>,0). Pick is =MOD(<cell>,12). (For 12 teams).

 

ZWK

Footballguy
If the pick is in A1, a formula that would work is:

=CEILING(A1/12,1)+0.01*(A1-12*(CEILING(A1/12,1)-1))

 

Users who are viewing this thread

Top