The Tournament Director Forums

Main => Help Me => Topic started by: AFroats13 on September 18, 2006, 02:42:48 PM

Title: Staggered Point System
Post by: AFroats13 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!
 
Title: Re: Staggered Point System
Post by: AFroats13 on September 19, 2006, 02:00:10 PM
Does the points formula allow IF statements?  Is it programable just like excel?
Title: Re: Staggered Point System
Post by: Corey Cooper 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.
Title: Re: Staggered Point System
Post by: AFroats13 on September 20, 2006, 09:25:32 AM
Does the formula field accept nested if formulas?
Title: Re: Staggered Point System
Post by: Corey Cooper on September 20, 2006, 11:27:05 AM
Yes.
Title: Re: Staggered Point System
Post by: AFroats13 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.
Title: Re: Staggered Point System
Post by: Corey Cooper 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)