Tiered Tournament Payout Calculator

afuente858

New Member
Joined
May 27, 2015
Messages
3
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.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

rpaulson

Well-known Member
Joined
Oct 4, 2007
Messages
1,226
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
ABCDEFGHI
1EntriesBuy in 50/50Totalwinnnersamount perTotal
280$ 8$ 200$ 840 8-0 5$ 115.50$ 577.50
37-15$ 38.50$ 192.50
46-27$ 10.00$70
5$ 840
68-0 ratio over 7-13
Sheet5
Cell Formulas
RangeFormula
D2D2=SUM(A2*B2+C2)
H2H2=(D2-I4)/(G2*F6+G3)*F6
H3H3=H2/F6
I2:I4I2=G2*H2
I5I5=SUM(I2:I4)
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,110
Messages
5,768,150
Members
425,458
Latest member
Jaspal1996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top