F
FISH
I play tournament poker and run into situations from time to time where I
need to figure some calculations quickly. A situation comes up in tournament
poker when players left at the end of a tournament start to talk about
splitting up the remaining prize money.
The players with more chips should get more of the prize money as their chip
stack has more equity then a player with a smaller chip stack. I'd like to
create a spreadsheet that will calculate what each person should make in a
perfectly even split based on the equity they hold in their stacks.
The standard deal calculation is to look out how much money is still at
stake -- in other words, assign everyone left in the field the lowest
remaining prize and see what's left over -- and then distribute the
remaining funds proportionately according to the chip stacks.
For example:
Let's say three players are left that will be involved in the potential deal
with stacks of 200k for Player 1, 170k for Player 2, and 130k for Player 3
(500k total). The prize money is $1000 for 1st, $700 for 2nd, $500 for 3rd.
Each player gets at least $500 at this point (as they have already
guaranteed 3rd place money), so there's only $700 remaining in play
(1000+700+500-3*500). So the deal amounts based completely on the equity
each player has in his chip stack would be:
Player 1: 200k/500k = 40%, so $500 + 40% * $700 = $780
Player 2: 170k/500k = 34%, so $500 + 34% * $700 = $738
Player 3: 130k/500k = 26%, so $500 + 26% * $700 = $682
The amount of players involved in the "deal" could be anywhere from 2-9. I
want to set up the spreadsheet to where all I need to enter is the remaining
players chip count and the prize money breakdown. The spreadsheet would then
need to calculate from the remaining prize money, how much is left for each
player to play for and what % of that amount each player deserves based on
their chip stacks (their chip stack / total chips in play).
So, is there an easy way to make a spreadsheet that will allow me to figure
these calculations?
THANKS in advance for any help !!!
need to figure some calculations quickly. A situation comes up in tournament
poker when players left at the end of a tournament start to talk about
splitting up the remaining prize money.
The players with more chips should get more of the prize money as their chip
stack has more equity then a player with a smaller chip stack. I'd like to
create a spreadsheet that will calculate what each person should make in a
perfectly even split based on the equity they hold in their stacks.
The standard deal calculation is to look out how much money is still at
stake -- in other words, assign everyone left in the field the lowest
remaining prize and see what's left over -- and then distribute the
remaining funds proportionately according to the chip stacks.
For example:
Let's say three players are left that will be involved in the potential deal
with stacks of 200k for Player 1, 170k for Player 2, and 130k for Player 3
(500k total). The prize money is $1000 for 1st, $700 for 2nd, $500 for 3rd.
Each player gets at least $500 at this point (as they have already
guaranteed 3rd place money), so there's only $700 remaining in play
(1000+700+500-3*500). So the deal amounts based completely on the equity
each player has in his chip stack would be:
Player 1: 200k/500k = 40%, so $500 + 40% * $700 = $780
Player 2: 170k/500k = 34%, so $500 + 34% * $700 = $738
Player 3: 130k/500k = 26%, so $500 + 26% * $700 = $682
The amount of players involved in the "deal" could be anywhere from 2-9. I
want to set up the spreadsheet to where all I need to enter is the remaining
players chip count and the prize money breakdown. The spreadsheet would then
need to calculate from the remaining prize money, how much is left for each
player to play for and what % of that amount each player deserves based on
their chip stacks (their chip stack / total chips in play).
So, is there an easy way to make a spreadsheet that will allow me to figure
these calculations?
THANKS in advance for any help !!!