The Tournament Director Forums
Main => Help Me => Topic started by: dniezby on August 31, 2013, 12:02:26 PM
-
Corry,
This is the formula that you helped me with a while back. It assigns points based on the number of players in the game and when they make it into the top 30% of the field.
round(if(r - (n * 0.3) < 0.51, 20 * (sqrt(sqrt(n) * n / r)) + 20, 20))
I was thinking of adding an extra bonus for top 16 players. Was thinking a 30point bonus for making it to the final two tables. Here is the kicker though; if the attendance is less than 30 players, there is no bonus for the top 16.
Is this something I could even add to this formula or did I just make this too complicated?
-Dave
-
You should be able to do this without too much complication. after your formula, just put "+ if n => 30, 30, 0"
-
No, that doesn't work. It' says, "formula has an error"
-
Okay, I figured out how to do it.
Although, I didn't figure out how to award it to players ONLY when there are >30 players...At least automatically.
I created Prizes in addition to my Points for Playing formula.
On the prizes page, I just made up a 30point prize for 1 - 16 which I will have to load when there are 30 plus players.
Simple but effective.
-
Corry,
This is the formula that you helped me with a while back. It assigns points based on the number of players in the game and when they make it into the top 30% of the field.
round(if(r - (n * 0.3) < 0.51, 20 * (sqrt(sqrt(n) * n / r)) + 20, 20))
I was thinking of adding an extra bonus for top 16 players. Was thinking a 30point bonus for making it to the final two tables. Here is the kicker though; if the attendance is less than 30 players, there is no bonus for the top 16.
Is this something I could even add to this formula or did I just make this too complicated?
-Dave
round(if(r - (n * 0.3) < 0.51, 20 * (sqrt(sqrt(n) * n / r)) + 20, 20)) + if((n >= 30) and (r <= 16), 30)
-
I bow to your formula knowledge.
I have NO IDEA HOW you do it. I guess, as the creator of the application you'd have to know how to make these formulas work.
It worked! I guess I just don't have the logic to think this way.
Thank you - Again...
-Dave