How to make a payout table

C

Chris Barnes

Ok, here is a fun exercise. I somehow got in charge of all the
technical stuff for my monthly office home poker night. Meaning I am
developing a payout table

It was pretty easy to come up with a schedule that made sense, but I now
want to make it more flexible - so that if we change the buy-in I don't
have to go through and redo everything.

Here is what we have:
players Payouts Breakdown
4-8 2 1st=70% 2nd=30%
9-15 3 1st=55% 2nd=33% 3rd=12%
16-21 4 1st=52.5% 2nd=29% 3rd=13% 4th=5.5%
22-29 5 1st=45% 2nd=26% 3rd=15% 4th=9% 5th=5%
30+ 6 1st=42.5% 2nd=25% 3rd=14.5% 4th=9% 5th=5% 6th=3.5%


Ok so far and pretty easy.

Here's where it gets "tricky". If the buyin is $20, we want the payouts
to be rounded to a multiple of $5. If the buyin is $50 (we only do that
once a year), we want to round the payouts to multiple of $10.

And of course, the total payout must exactly equal the total amount in
the kitty (# players * buyin).

I can send the spreadsheet with what I have so far if anyone wants to
look at it.
 
A

ajbazinet

If you set up a buy-in input and use the MROUND function you should be
able to accomplish this.
 
C

Chris Barnes

Chris Barnes said:
I did, but it either doesn't always have the total payouts equal to
the kitty. What's worse, sometimes it's more and sometimes it's less.

See the attached (2nd worksheet).

Anyone have an idea after looking at it over the weekend?


--

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Chris Barnes AOL IM: CNBarnes
(e-mail address removed) Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: (e-mail address removed)
Department of Physics ph: 979-845-7801
Texas A&M University fax: 979-845-2590
 
C

Chris Barnes

Chris Barnes said:
Anyone have an idea after looking at it over the weekend?


No ideas, huh?

--

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Chris Barnes AOL IM: CNBarnes
(e-mail address removed) Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: (e-mail address removed)
Department of Physics ph: 979-845-7801
Texas A&M University fax: 979-845-2590
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top