Fantasy Football Draft Day Player Rankings Formula

Jbeaucaire,

Thanks for the response. I've attached the spreadsheet to give you a better idea of what I am trying to accomplish. Column A is the overall rank but is not important in what I am trying to accomplish. Column B is the player, and Column C is the ADP.

The ADP is just an overall number, and I want to know which round this ADP would correlate to in a 12 man league. The ADP doesn't take into account how many members are in a particular league, so I want to convert the data to how it would apply in my league. This data will help me forecast when I need to pick whom and where to target a certain player.

This would mean that each round is 12 picks. So... since the ADP come with decimals, pick 14.79 would equate to between the 2nd and 3rd pick in round two (round 1 = 1-12; round 2 = 13-24 and so on and so on). That's why I was thinking that the output could be "Rd. 1 - 1st 1/2" or "Rd. 2 - 2nd 1/2", or even X.X, (first x being the round, second x being the particular pick).

It's not that hard to do in your head at 0-24, but when you get up to 147.65.... well... the math gets a little confusing (especially considering I will be drinking

Thanks!