# Tiered Tournament Payout Calculator

#### afuente858

##### New Member
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

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

Example 2-
\$8 buy in x 60 players = \$420

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

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

#### rpaulson

##### Well-known Member
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
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:

Replies
3
Views
186
Replies
3
Views
496
Replies
1
Views
148
Replies
55
Views
928
Replies
3
Views
135

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.

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.

### Which adblocker are you using?

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

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