Topics

1

Help Me / points formula help needed..please

« on: October 11, 2006, 02:58:05 AM »

 hi all,
this is all new to me so please fogive my ignorance. i am trying to write a formula(first attempt ever) with limited success the end goal is for the total number of points to be awarded as a percentage of the total # of entrants +
the total # of rebuys.
 hope i can express this clearly

24 players in tournament with 16 rebuys

 1st place would receive 100% of points = 40 points
2nd place 80% = 32 points
3rd place 70% = 28 points
4th place 60% = 24 points
5th place 50% = 20 points
6th place 40% = 16points
7th place 30% = 12 points
8th place 20% = 8 points
9th - 24th 5% = 2 points

hope that made sense to someone. the amount of players per tournament varies so it would be 9th place to last place always getting 5%
here's my closest effort to getting this to work after butchering one of coreys formulas but i can't get it quite right.

if(r == 1, 1.0, if(r == 2, .80, if(r == 3, .70, if(r == 4, .60, if(r == 5, .50, if(r == 6, .40, if(r == 7, .30, if(r == 8, .2, if(r == 9, .05, if(r == 10, .05, 0)))))))))) * 40 + (if(n > 10, (n-10)*.02, 0) * 40)

if anyone can help i've tried for about 8 hours with no luck so any input would be greatly appreciated.
thanks chris