The Tournament Director Forums

Main => Help Me => Topic started by: craigt78 on December 09, 2019, 12:27:56 PM

Title: Overall Score help
Post by: craigt78 on December 09, 2019, 12:27:56 PM
I am trying to use the overall score value to determine the final points for my end of year free-roll.

My point formula is sqrt(((n * bc) * (bc / tc))) / (r + 1.0) and it works just fine. 

What I want to adjust is the same point value, but only for the top 9 tournaments displayed in the overall score value.

The way I adjust starting stack for the free roll is on best performance at the minimum number of games attended by a qualifying player, this year it's 9.

Can I do this in TD, or do I need to default to my old way of doing it in excel?

I am on the most current version of Beta.
Title: Re: Overall Score help
Post by: efdenny on December 09, 2019, 06:58:58 PM
To count only the top 9, you'll need to set the Tournament Scoring formula to "points" and then set the Overall Formula to this:

sum(top(9, scores))
Title: Re: Overall Score help
Post by: craigt78 on December 09, 2019, 08:49:17 PM
Perfect!!  That is exactly what I was looking for.  Thank you!