Author Topic: Help with Points formula  (Read 745 times)

biiiinkk

  • Newbie
  • *
  • Posts: 1
    • View Profile
Help with Points formula
« on: December 19, 2010, 04:22:53 PM »
Hello All

We do something unique for our points

If there are 10 or less players, we pay out 3 players.  1st get 6 extra points, 2nd gets 4 extra points and 3rd gets 2 extra points.  Also, no one can get less than 3 points, so if there were 10 players the points would look like this:

1 = 16
2 = 13
3 = 10
4 = 7
5 = 6
6 = 5
7 = 4
8 = 3
9 = 3
10 = 3

8 players would look like this

1 = 14
2 = 11
3 = 8
4 = 5
5 = 4
6 = 3
7 = 3
8 = 3

If we have 11+ players the top 4 are paid.  1st gets 8, 2nd gets 6, 3rd gets 4, and 4th gets 2
Everything else works the same
Example:
1 = 20
2 = 17
3 = 14
4 = 11
5 = 8
6 = 7
7 = 6
8 = 5
9 = 4
10 = 3
11 = 3
12 = 3


Is there any way to make a formula for this?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Help with Points formula
« Reply #1 on: December 20, 2010, 11:17:49 AM »
max(3, n - r + 1) + if(n < 11, switch(r, 1, 6, 2, 4, 3, 2), switch(r, 1, 8, 2, 6, 3, 4, 4, 2))

or

max(3, n - r + 1) + max(0, (if(n < 11, 4, 5) - r) * 2)