Determining placement of text based on a number or percentage
Posted on 2011-03-21
Ok.. The title is horrible but I couldn't figure out how to phrase what I'm looking for.
Let me explain what I'm trying to do.
I'm trying to put together a spreadsheet for a baseball season ticket draft that I have coming up. Currently we have 5 people though this could change in the draft. There are 83 games, this could fluctuate up and down also. I need a way to determine where to put people in the drat order.
Still confused? I am. Here is what I'm currently doing by hand.
Josh - 30 games - One pick every 2.7 turns
Jim - 20 Games - 4.15
Mike - 18 Games - 4.61
Bill - 10 Games - 8.3
Frank - 5 Games - 16.6
What I would like to do is have a list of people in the league in a column and the number of games in the next.
I would like the spreadsheet to go down and place the people where they should pick. One Caveat, Mike ALWAYS picks first.
Does that make sense at all? Am I trying to do too much?