Author Topic: formula needed for yesterday ;D  (Read 61 times)

suchy_wiUr

  • Newbie
  • *
  • Posts: 4
    • View Profile
formula needed for yesterday ;D
« on: February 06, 2020, 03:17:29 PM »
Hello,
our club has 10 players. If everyone plays the scoring looks like this:
1. = 100 points
2. = 90 points
3. = 80 points
4. = 70 points
5. = 60 points
6. = 50 points
7. = 40 points
8. = 30 points
9. = 20 points
10 = 10 points

If 9 people play, the scoring looks like this:
1 = 90pkt
2 = 80pkt
3 = 70pkt
e.t.c

Everyone who eliminates an opponent gets 1 extra point.
A player who has been eliminated can buy again.
Rebuys - only up to lv7.

Can anyone help me create this formula???
thank you in advance

suchy_wiUr

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: formula needed for yesterday ;D
« Reply #1 on: February 06, 2020, 05:10:12 PM »

I read the User Guide and did something like that

if(rank <= 10, (11 - rank)*10+ numberOfHits, 0)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5869
    • View Profile
Re: formula needed for yesterday ;D
« Reply #2 on: February 06, 2020, 10:10:03 PM »
Your formula is close, but not quite (based on your description).  Your formula always awards 100 points for 1st place, but your description says 1st place gets 90 points if only 9 players enter.  Here's a formula that adjusts based on entries:

(n - r + 1) * 10 + numberOfHits

or

position * 10 + numberOfHits

The above formulas will also award points to players beyond 10th place.  If you want to limit points to the top 10 (which your formula does), wrap it in the if() function, like you did:

if(rank <= 10, position * 10 + numberOfHits)


suchy_wiUr

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: formula needed for yesterday ;D
« Reply #3 on: February 07, 2020, 02:13:05 AM »
Thank you very much for help. I'm just starting work with this program.
I regret that only now I found him.
Best regards and have a nice day.
suchy_wiUr

suchy_wiUr

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: formula needed for yesterday ;D
« Reply #4 on: February 10, 2020, 12:25:26 PM »
Hello,
I tested the formula ((n - r + 1) * 10 + numberOfHits) at the last tournament. Here are the results:

1.210
2.182
3.160
4. 142
5. 124
6. 100
7. 80
8. 60
9. 40
10.20

Is there a chance that I marked something wrong in the settings ???

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5869
    • View Profile
Re: formula needed for yesterday ;D
« Reply #5 on: February 10, 2020, 06:26:04 PM »
Possibly.  How many players participated?  Did you fill any of the other "Points" inputs, such as "Points for hit" or the "Points" fields in the Buy-in/Rebuy/Add-on profiles?  The formula should take care of all the points, so if you filled those in, you're giving additional points.