Cory...HELP!!!! Combining # of players+ # of rebuys to determine points

[ccarpol]

Hi Cory,

I'm in a league and here is the point system:

1st place  - total number of players + number of rebuys
2nd place - 80% of 1st place points
3rd place - 70% of 1st place points
4th place - 60% of 1st place points
5th place - 50% of 1st place points
6th place - 40% of 1st place points
7th place - 30% of 1st place points
8th place - 20% of 1st place points
All other players - 5% of 1st place points for participation

Here's the problem

The formula below awards points  as follows: # of players plus the # of rebuys for the individual player.  I need a formula that will add the number of players plus the number of rebuys for all players.

For example:
33 players in a tournament and 17 total rebuys.

1st place=50 pts.
2nd place=40 pts.
3rd place=35 pts.
4th place=30 pts.
5th place=25 pts.
6th place=20 pts.
7th place=15 pts.
8th place=10 pts.
All other players receive 3 pts.(2.5 rounded)

round(if(r==1, n+nr, if(r==2, .80*(n+nr), if(r==3, .70*(n+nr), if(r==4, .60*(n+nr), if(r==5, .50*(n+nr), if(r==6, .40*(n+nr), if(r==7, .30*(n+nr), if(r==8, .20*(n+nr), if(r>8, .05*(n+nr)))))))))))

Thanks for your help, I'm almost there!

[Corey Cooper]

Well, seems like my guess was correct in your other post.  Right now, the "total number of rebuys for all players" is not available in the formula variables, but it's not difficult to include so I'll add it to the to-do list. 

[RTBrandy]

I've been trying to figure this out too...

has this been enabled yet?

[Corey Cooper]

Not yet, but it should make it into the next version.