Author Topic: Another points issue, set points to zero on rebuy  (Read 2176 times)

famous58

  • Newbie
  • *
  • Posts: 19
    • View Profile
Another points issue, set points to zero on rebuy
« on: May 05, 2008, 04:11:39 PM »
Hello all.

I'm running a tournament with 8 players.  I have two questions.

1) I want the top 4 players to receive extra points for finishing.  I was able to create a formula that works, but it seems like there is a better way to do it.  See below.

2) If a player rebuys I want their points for that game to reflect the place they went out before the rebuy.  Even if they win I only want them to receive points for what happened before the rebuy.  However, I still want to know who won each tourney.

Current Formula:

if(rank =1, n-r+5) + if(rank =2, n-r+4) + if(rank =3, n-r+3) +  if(rank =4, n-r+2) + if(rank >4, n-r+1)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Another points issue, set points to zero on rebuy
« Reply #1 on: May 05, 2008, 04:53:30 PM »
if(rank < 5, n + 6 - 2 * rank, n - rank + 1)

You can't incorporate the second one.  There's no formula variable indicating a player's rank after their first bust-out.

famous58

  • Newbie
  • *
  • Posts: 19
    • View Profile
Re: Another points issue, set points to zero on rebuy
« Reply #2 on: May 07, 2008, 05:26:08 PM »
if(rank < 5, n + 6 - 2 * rank, n - rank + 1)

You can't incorporate the second one.  There's no formula variable indicating a player's rank after their first bust-out.


Thanks Corey.

What about something along the lines that says if they've re-bought subtract the number of points they receive in the place they finish?  So if they go out first, rebuy and finish 1st, it subtracts 12 points, if they finish 2nd it subtracts 10 points etc.?

famous58

  • Newbie
  • *
  • Posts: 19
    • View Profile
Re: Another points issue, set points to zero on rebuy
« Reply #3 on: May 07, 2008, 05:31:33 PM »
Or is there a way to subtract 6 points for if they rebuy but keep them > 0?

Gruffse

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: Another points issue, set points to zero on rebuy
« Reply #4 on: May 08, 2008, 01:34:19 AM »
Or is there a way to subtract 6 points for if they rebuy but keep them > 0?

if(nr>0,If((if(rank < 5, n + 6 - 2 * rank, n - rank + 1)-6)<1,1,if(rank < 5, n + 6 - 2 * rank, n - rank + 1)-6),if(rank < 5, n + 6 - 2 * rank, n - rank + 1))

This formula subtracts 6 points if the player rebuys one or more times.
If the "rebuy subtraction" gives 0 or less points, the player gets 1 point. (No player gets less than 1 point)

Example 1: (No rebys, 12 enries)
1st: 16.00
2nd: 14.00
3rd: 12.00
4th: 10.00
5th: 8.00
6th: 7.00
7th: 6.00
8th: 5.00
9th: 4.00
10th: 3.00
11th: 2.00
12th: 1.00

Example 2: (everyone rebuys, 12 entries)
1st: 10.00
2nd: 8.00
3rd: 6.00
4th: 4.00
5th: 2.00
6th: 1.00
7th: 1.00
8th: 1.00
9th: 1.00
10th: 1.00
11th: 1.00
12th: 1.00

Example 2: (12 entries, 1st, 4th and 10th rebuys)
1st: 10.00
2nd: 14.00
3rd: 12.00
4th: 4.00
5th: 8.00
6th: 7.00
7th: 6.00
8th: 5.00
9th: 4.00
10th: 1.00
11th: 2.00
12th: 1.00

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Another points issue, set points to zero on rebuy
« Reply #5 on: May 08, 2008, 02:31:12 PM »
Ok, famous58, I'm not exactly sure what you're trying to do, but if you are trying to nullify any points that a player is awarded if they rebuy, then the easiest thing to do is check to see if they've rebought then award them 0 points.

if(nr > 0, 0, if(rank < 5, n + 6 - 2 * rank, n - rank + 1))

If you just want to subtract 6 points from a player who rebuys, but always award them at least 1 point:

max(if(rank < 5, n + 6 - 2 * rank, n - rank + 1) - if(nr > 0, 6), 1)