I think I have a pretty good idea on a suggestion for you. As I am a fellow fantasy player and do run various spreadsheets. My problem is that I have cumbersome solutions. For example, I would add a row offset from your data that marks each player 1 through 250+. In the next column, I would have the following formula.
=ROUNDUP(X2/12,0)
Where X2 is the first player in your rankings. This would output the round that your player list would be selected.
In the next column, I would put the following formula.
=RANK(X2,$X$2:$X$13,1)
This be able to number the pick in within the round. The catch with my way is that you would have to set the range for each round. I'm sure there is an easier way, but this still works.
Lastly, I would put the following formula in the third column.
=Y2&"."&Z2
This would put the round and pick together. For example, the result is 1.1. I would then hide the round and draft position columns so it looks a little more presentable. You don't need to have extra data when trying to make quick decisions within that minute and a half.
As soon as I figure out how to do it, I will attach my personal draft sheet with other things that I have done to show exactly what I mean. These columns that I described above are highlighted in light blue.
Let me know if there are any questions.
Good luck in fantasy!!
Brian
Bookmarks