Need formula and setup help for my league structure.

[Comitatus]

Hey guys/gals, hopefully someone can help me out here. I'm looking to use a formula for a small league that is starting up soon. I also need a bit of help in where to use it in the software.

Payouts will be based on how many players are in each tourney. Example, 7 and fewer will pay top 2 places (70%/30%). 8 and over will pay top 3 places (50%/30%/10%). Over 16 will pay top 4 places, etc...

Points will also be given to players for each tournament based on finishing position. For example, if 10 players buy in then first place would receive 10 points, second place 9 points, etc.
Additional points will be given for the players that finish in the money. For example, if the top 3 players are paid, first place receives an additional 3 points, 2nd receives 2 points and third receives 1 point. Points will be adjusted based upon the number of players.

Example point breakdown for a 10 player tourney:

1st   13 points
2nd  11 points
3rd   9 points
4th   7 points
5th   6 points
6th   5 points
7th   4 points
8th   3 points
9th   2 points
10th 1 point

The total points earned from a player's best 5 results (lowest score dropped) will be used to determine their chip stack for the Main Event. The player that has the highest total points will be crowned "Player of the Year".


We are playing 6 tourney, but as above, will only count the best 5 results for each player.

What formula would be good for this, and how would I set up the software to use it?
Thanks in advance for the replies and help....

 

[Magic_fubu]

The total points earned from a player's best 5 results (lowest score dropped) will be used to determine their chip stack for the Main Event. The player that has the highest total points will be crowned "Player of the Year".


We are playing 6 tourney, but as above, will only count the best 5 results for each player.

This would be accomplished by setting a filter to encompass the dates for the six tournaments. Overall score = sum(top(5, scores))

Payouts will be based on how many players are in each tourney. Example, 7 and fewer will pay top 2 places (70%/30%). 8 and over will pay top 3 places (50%/30%/10%). Over 16 will pay top 4 places, etc...

Points will also be given to players for each tournament based on finishing position. For example, if 10 players buy in then first place would receive 10 points, second place 9 points, etc.
Additional points will be given for the players that finish in the money. For example, if the top 3 players are paid, first place receives an additional 3 points, 2nd receives 2 points and third receives 1 point. Points will be adjusted based upon the number of players.

Example point breakdown for a 10 player tourney:

1st   13 points
2nd  11 points
3rd   9 points
4th   7 points
5th   6 points
6th   5 points
7th   4 points
8th   3 points
9th   2 points
10th 1 point

That seems to be a bit over my head (could be from lack of sleep last night), but seems to be based upon the traditional "n-r+1" formula.

From what I'm gathering, you're looking to pay out the top 25% for bonus points?

[Comitatus]

The total points earned from a player's best 5 results (lowest score dropped) will be used to determine their chip stack for the Main Event. The player that has the highest total points will be crowned "Player of the Year".


We are playing 6 tourney, but as above, will only count the best 5 results for each player.

This would be accomplished by setting a filter to encompass the dates for the six tournaments. Overall score = sum(top(5, scores))

Payouts will be based on how many players are in each tourney. Example, 7 and fewer will pay top 2 places (70%/30%). 8 and over will pay top 3 places (50%/30%/10%). Over 16 will pay top 4 places, etc...

Points will also be given to players for each tournament based on finishing position. For example, if 10 players buy in then first place would receive 10 points, second place 9 points, etc.
Additional points will be given for the players that finish in the money. For example, if the top 3 players are paid, first place receives an additional 3 points, 2nd receives 2 points and third receives 1 point. Points will be adjusted based upon the number of players.

Example point breakdown for a 10 player tourney:

1st   13 points
2nd  11 points
3rd   9 points
4th   7 points
5th   6 points
6th   5 points
7th   4 points
8th   3 points
9th   2 points
10th 1 point

That seems to be a bit over my head (could be from lack of sleep last night), but seems to be based upon the traditional "n-r+1" formula.

From what I'm gathering, you're looking to pay out the top 25% for bonus points?

Awesome, thanks! So where does the formula for each tournament go?


Sorry if I wasn't very clear. It looks like the "n-r+1" formula will probably work for the main portion of it. On top of that, I'm looking to award additional points for those that finish in the money.

Example, in a 10 player tournament, I'm paying out top 3 spots, so 3 players will finish in the money. So I want to award 1st an additional 3 points, 2nd - additional 2 points, and 3rd - additional 1 point.

If I was paying out top 2 spots, then I'd award 1st an additional 2 points, and 2nd - additional 1 point.

Whenever the money spots change, the formula would need to take that into consideration for the additional points being awarded.

Does that help or make any more sense?
Thanks again!

[Corey Cooper]

Points for Playing (Game tab):

(n - r + 1) + max(0, inTheMoneyRank - r + 1)

Tournament Scoring (Filter on Stats tab):

points

Overall Scoring (Filter on Stats tab):

sum(top(5, scores))

[Comitatus]

Points for Playing (Game tab):

(n - r + 1) + max(0, inTheMoneyRank - r + 1)

Tournament Scoring (Filter on Stats tab):

points

Overall Scoring (Filter on Stats tab):

sum(top(5, scores))

Awesome Corey! I'll give it a go...

Thanks again for this awesome software.