Author Topic: Formula for points... Please help?  (Read 735 times)

thomamon

  • Newbie
  • *
  • Posts: 40
    • View Profile
Formula for points... Please help?
« on: July 12, 2015, 05:54:16 PM »
We are doing a 10 person league for a seat to the WSOP and want to use the below point system, can anyone tell me how it would work?

100
75
63
55
50
45
40
35
30
25

TIMMER

  • Hero Member
  • *****
  • Posts: 557
    • View Profile
Re: Formula for points... Please help?
« Reply #1 on: July 12, 2015, 09:22:54 PM »
I believe it's.....but I've been wrong before

switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25,)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5422
    • View Profile
Re: Formula for points... Please help?
« Reply #2 on: July 13, 2015, 04:48:09 PM »
Looks good to me, but for those not too familiar with the formula system, that last comma will cause an error:

switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25,)

So just remove it:

switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25)

thomamon

  • Newbie
  • *
  • Posts: 40
    • View Profile
Re: Formula for points... Please help?
« Reply #3 on: July 21, 2015, 03:42:54 PM »
Looks good to me, but for those not too familiar with the formula system, that last comma will cause an error:

switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25,)

So just remove it:

switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25)
Is there a way to have it remove the lowest score when do the standings?  We are playing 11 tournaments with only the top 10 results counting in the standings.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5422
    • View Profile
Re: Formula for points... Please help?
« Reply #4 on: July 21, 2015, 04:46:57 PM »
In your Stats Profile, you'll want to set an Overall Formula to:

sum(top(10, listPoints))

Or, if you don't know how many tournaments you'll play but still only drop the lowest 1:

sum(top(n - 1, listPoints))