Poker Tournament Payout Spreadsheet

[Justinian]

Does anyone have any good spreadsheets to calculate poker payouts?

We have a $35 buy with a mandatory $75 house take off the top. So if twenty people play, the payout is $625. How can I calculate the payouts to descend from 1st place so that no two payouts are the same and everyone in the pool gets a cash prize? 1st place should get a majority of the prize and 2nd should be a little less, same with third on down to twenty.

 

[sergioMabres]

Hi Justinian
Nice exercise, just an idea, you should know that there are multiple answers for you problem:
Libro1.olx

*	A	B	C
Num of Players	Change to your need
Buy	Change to your need
House	*
Payout	Do not change
Slope	Change to a value where Aux2 is small but positive, star with 1
Aux1	Do not change
Aux2	Do not change
*	*	*

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]20[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]35[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]75[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]625[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]190[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]2,75[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]Player[/TD]
[TD="align: center"]Payouts[/TD]
[TD="align: center"]Over[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]59,75[/TD]
[TD="align: center"]19[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]56,75[/TD]
[TD="align: center"]18[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]53,75[/TD]
[TD="align: center"]17[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]50,75[/TD]
[TD="align: center"]16[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B4 =B1*B2-B3 B6 =SUM(C10:C113) B7 =(B4-(B6*B5))/B1 B10 =IF(B4>0;IF(A10<>"";$B$7+$B$5*C10;"");0) C10 =IF(A10<>"";COUNT(A11:$A$113);"") A11 =IF(IF(A10="";9999;A10)+1>$B$1;"";A10+1) B11 =IF(B5>0;IF(A11<>"";$B$7+$B$5*C11;"");0) C11 =IF(A11<>"";COUNT(A12:$A$113);"") A12 =IF(IF(A11="";9999;A11)+1>$B$1;"";A11+1) B12 =IF(B6>0;IF(A12<>"";$B$7+$B$5*C12;"");0) C12 =IF(A12<>"";COUNT(A13:$A$113);"") A13 =IF(IF(A12="";9999;A12)+1>$B$1;"";A12+1) B13 =IF(B9>0;IF(A13<>"";$B$7+$B$5*C13;"");0) C13 =IF(A13<>"";COUNT(A14:$A$113);"") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4



You can see a test sheet at https://onedrive.live.com/redir?res...776&authkey=!AG7XnrlrOLwoIKQ&ithint=file,xlsx

 

[Justinian]

Ok, now we are talking but what is the "Over" column supposed to do and what if I need a greater disparity between 1st and 2nd place, 2nd and 3rd place, etc?

Also, what are the slope and aux numbers?

 

[sergioMabres]

Over i use to calculate the Payout is the amount of ppl under the position, this pos should get a básic Pay plus x times the slope
If you want to spread further 1st and 2nd increase slope but beware of negativos for ppl at the botton
This sheet is an exercice and is only one solution, for instance distribution is LINEAR you can create other distribution like exponencial or geometrical where money is at the top an little to the botton, but that sort of distribution require different formulas
Cheers
Sergio

 

[Justinian]

Thank you!