drneau.com Forum Index drneau.com
A discussion board for drneau.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Payout schedule formulas in Excel

 
Post new topic   Reply to topic    drneau.com Forum Index -> Payout Schedules, Chops & Side Bets
View previous topic :: View next topic  
Author Message
Muley05
"A Set of Mop Squeezers"


Joined: 14 Jan 2009
Posts: 53

PostPosted: Wed Feb 04, 2009 10:49 am    Post subject: Payout schedule formulas in Excel Reply with quote

Is there a way to replicate the payout calculations below in Excel? I would think that there would be, but I have no idea what formulas to use...

I am using a payout schedule that pays out 25% of the buy ins with a 50% spread and 30% decay. I would like to be able to replicate this in Excel so that I can make tweaks.

drneau wrote:
While you can use tiered payout structures...just like any good tool supports...why not use a simple formula to dictate how many places are paid and how the payouts are distributed?

We use the same formula for every tournament:
- Pay 25% of the buy-ins
- Use the "Automatic (Accelerating) distribution with a rate of 30%.

"Rate" means that each finisher gets 30% more than the previous finisher. "Decay" means that the difference will decrease for each additional payout.

What's the result?
A 10-player tournament paying 25% with a rate of 30% and a decay of 0%:
- 1: 58.82%
- 2: 41.18%
A 20-player tournament paying 25% with a rate of 30% and a decay of 0%:
- 1: 36.06%
- 2: 25.24%
- 3: 17.67%
- 4: 12.37%
- 5: 8.66%
A 20-player tournament payting 25% with a rate of 30% and a decay of 30%:
- 1: 31.77%
- 2: 22.24%
- 3: 17.57%
- 4: 14.98%
- 5: 13.44%


It makes things a lot easier.
Back to top
View user's profile Send private message
drneau
Site Admin


Joined: 13 Feb 2005
Posts: 2385
Location: Woodbury, MN

PostPosted: Wed Feb 04, 2009 1:08 pm    Post subject: Reply with quote

http://drneau.com/tools/ExpontentialPayoutWorksheet.xls
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Muley05
"A Set of Mop Squeezers"


Joined: 14 Jan 2009
Posts: 53

PostPosted: Wed Feb 04, 2009 1:15 pm    Post subject: Reply with quote

Excellent. Thank you very much.

Also, is there a way to tell the payout schedules in TM to round up or round down? For example, if I want to pay out 25% of buy ins, and I have 19 buy ins, the payout schedule defaults to pay 4 places, even though 25% of 19 is 4.75. Is there a way for me to choose for it to round up, so that if I had 19 players, 5 spots would be paid?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    drneau.com Forum Index -> Payout Schedules, Chops & Side Bets All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group