The Tournament Director Forums
Main => Help Me => Topic started by: JBjr on February 02, 2014, 01:25:43 AM
-
Hey all, I'm taking over a bar league and they already have a set point system in place that I don't want to mess with. I'd prefer to use my own formula but don't want to step on any toes and piss anyone off. I want to enter them in the 'prizes' tab but as rankings get lower the point value is the same. Example, 20-30th get 500 points, 31st-40th get 300, etc. Is there a way of entering 20th-30th in the rank field of the prizes tab to give each of those players that point value or do i have to enter every individual rank, 30, 31, 32....... Seems like I should be able to enter 21;30 and have it set that point value for all of those ranks?
-
You should use the Points for Playing formula to accomplish this. What's the points distribution?
-
I'm not sure of all the values and am still waiting for the info from the bar owner.
Let's just say for example it's as follows
1-2500
2-2000
3-1600
4-1300
5-1100
6-1000
7-900
8-800
9-15-700
16-20-600
21-30=500
31-40=400
41-50=300
what would the formula look like for that? Thanks for the help Cory
-
switch(r, 1, 2500, 2, 2000, 3, 1600, 4, 1300, 5, 1100, 6, 1000, 7, 900, 8, 800) + if(r > 8 and r < 16, 700) + if(r > 15 and r < 21, 600) + if(r > 20 and r < 31, 500) + if(r > 30 and r < 41, 400) + if(r > 40 and r < 51, 300)
-
Awesome! Thanks Cory.