How to make a payout table

  • Thread starter Thread starter Chris Barnes
  • Start date Start date
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.
 
If you set up a buy-in input and use the MROUND function you should be
able to accomplish this.
 
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
 
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
 
Back
Top