Author Topic: Staggered Point System  (Read 2713 times)

AFroats13

  • Newbie
  • *
  • Posts: 17
    • View Profile
Staggered Point System
« on: September 18, 2006, 02:42:48 PM »
I have a points system that is based off of number of players and finishing place.  Last place is awarded one point.  Each place better earns one point more up to the money.  If I pay out the top 3, the 2nd and 3rd place finishers earn 2 more points than the place before, with the winner receiving 3 points more than 2nd.  For example –
o   Eight seat tournament
 
   1st  – 12 pts
   2nd – 9 pts
   3rd – 7 pts
   4th – 5 pts
   5th – 4 pts
   6th – 3 pts
   7th – 2 pts
   8th  – 1 pt

Is there a formula that will do this?  ??? Keep in mind, if I have more players, I may want to pay out 4 places, then 4th, 3rd, and 2nd would get 2 more points than previous, and 1st 3 more than 2nd.  Thanks!
 

AFroats13

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Staggered Point System
« Reply #1 on: September 19, 2006, 02:00:10 PM »
Does the points formula allow IF statements?  Is it programable just like excel?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Staggered Point System
« Reply #2 on: September 19, 2006, 04:28:02 PM »
The formula does support "if" statements of the format if(condition, then, else).  So, if(r<6, 2*(6-r), 0) would give points to those who rank 5th or better, 0 otherwise.  2 points to 5th place, 4 to 4th, 6 to 3rd, 8 to 2nd, and 10 to 1st.  The user guide gives a more detailed explanation.

AFroats13

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Staggered Point System
« Reply #3 on: September 20, 2006, 09:25:32 AM »
Does the formula field accept nested if formulas?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Staggered Point System
« Reply #4 on: September 20, 2006, 11:27:05 AM »
Yes.

AFroats13

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Staggered Point System
« Reply #5 on: September 28, 2006, 02:44:57 PM »
Does the implementation of the "inthemoney" formula entry help out with simplifying my nested if formulae?  This is what I have so far:

=IF(r=1,(n-r)+7,IF(r=2,(n-r)+5,IF(r=3,(n-r)+4,IF(r=4,(n-r)+3,IF(r=5,(n-r)+2,(n-r)+1))))), where the top 5 are in the money.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Staggered Point System
« Reply #6 on: September 29, 2006, 10:30:30 AM »
If you really want to make it simpler, I believe this will do, so long as you have prizes for the top 5 ranks:

n-r+1 + if(m, 6-r, 0) + if(r=1, 1, 0)