How to make a payout table

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.

--�

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Chris Barnes AOL IM: CNBarnes
[email protected] (also MSN IM) Yahoo IM: chrisnbarnes

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

ajbazinet <[email protected]> wrote:
> If you set up a buy-in input and use the MROUND function you should be
> able to accomplish this.

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).
--

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Chris Barnes AOL IM: CNBarnes
[email protected] Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: [email protected]
Department of Physics ph: 979-845-7801
Texas A&M University fax: 979-845-2590

Chris Barnes <[email protected]> wrote:
> ajbazinet <[email protected]> wrote:
>> If you set up a buy-in input and use the MROUND function you should
>> be able to accomplish this.
>
> 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
[email protected] Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: [email protected]
Department of Physics ph: 979-845-7801
Texas A&M University fax: 979-845-2590

Chris Barnes <[email protected]> wrote:
> Chris Barnes <[email protected]> wrote:
>> ajbazinet <[email protected]> wrote:
>>> If you set up a buy-in input and use the MROUND function you should
>>> be able to accomplish this.
>>
>> 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?


No ideas, huh?

--

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Chris Barnes AOL IM: CNBarnes
[email protected] Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: [email protected]
Department of Physics ph: 979-845-7801
Texas A&M University fax: 979-845-2590