Tiered Tournament Payout Calculator

[afuente858]

I have a pool tournament that plays 8 rounds. Each round is one game. After each round a random draw takes place to pair up the next match. There could be 20-60 players any tournament.

At the end of the tournament there will be players that won all the games to end up 8-0, maybe lost a game and ended up 7-1, or lost two games and ended up 6-2.

We want tp pay out all the 8, 7 and 6 wins. 6's get $10 and the rest is proportionally split across the 7's and again across the 8's.

The challenge I have is we want the make sure the 8's get a good amount more than the 7's and the 6's get $10. if there are 3-8's, 5-7's, and 3-6's. how can you calculate payout to allow the 7's to make more than the 6's and the 8's to make more than the 7's and 6's?

Example 1-
$8 buy in x 30 players = $240
50/50 money may added $100

With 30 players you have:
$240+$100=$340

Example 2-
$8 buy in x 60 players = $420
50/50 money may added $200

With 60 players you have:
$420+200=$620

I tried many variations in excel but cannot get to the desired result. Any help is greatly appreciated.

 

[rpaulson]

change the values in green as needed.

the Value in F6 is how many times the amount of money the 8-0 win over the 7-1 (Play around this this number to get the desired value you want.

Book1
	A	B	C	D	E	F	G	H	I
1	Entries	Buy in	50/50	Total			winnners	amount per	Total
2	80	$ 8	$ 200	$ 840		8-0	5	$ 115.50	$ 577.50
3						7-1	5	$ 38.50	$ 192.50
4						6-2	7	$ 10.00	$70
5									$ 840
6					8-0 ratio over 7-1	3
Sheet5

Cell Formulas
Range	Formula
D2	D2	=SUM(A2*B2+C2)
H2	H2	=(D2-I4)/(G2*F6+G3)*F6
H3	H3	=H2/F6
I2:I4	I2	=G2*H2
I5	I5	=SUM(I2:I4)