The Tournament Director Forums

Main => Help Me => Topic started by: dniezby on August 31, 2013, 12:02:26 PM

Title: Help modifying my formula
Post 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.

Code: [Select]
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
Title: Re: Help modifying my formula
Post by: Magic_fubu on August 31, 2013, 06:36:03 PM
You should be able to do this without too much complication. after your formula, just put "+ if n => 30, 30, 0"
Title: Re: Help modifying my formula
Post by: dniezby on August 31, 2013, 08:29:16 PM
No, that doesn't work.  It' says, "formula has an error"
Title: Re: Help modifying my formula
Post by: dniezby on September 01, 2013, 02:07:27 PM
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.
Title: Re: Help modifying my formula
Post by: Corey Cooper on September 03, 2013, 11:49:19 AM
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.

Code: [Select]
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)
Title: Re: Help modifying my formula
Post by: dniezby on September 03, 2013, 12:09:06 PM
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