The Tournament Director Forums

Main => Help Me => Topic started by: Tonyo1977 on March 28, 2013, 11:39:28 AM

Title: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on March 28, 2013, 11:39:28 AM
Hello,

I created a poker tournament with friends.
We will play 8 rounds, but only five rounds are best recognized ...
How can I do?

if (r <= 8, n-r +1, 0)
top (5, scores)?? because this does not top 5 rounds ... : (

Thank you in advance
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Magic_fubu on March 28, 2013, 06:13:32 PM
Are you looking for points to be awarded for just the top five finishers? If so, you would want to modify your IF statement by replacing the 8 with a 5. If you're looking for the top five tournaments to be scored for each player, then the top(5, scores) would be correct. However, there is more that you would need to do than just that. You would need to go to the stats tab, and create a new profile. From there, put in the criteria that you need, then click save. Each time you run the stats, regardless of the number of tournaments run, it will show the best five tournaments for each participant. If you need more help with it, or if I'm misunderstanding what you're looking to do, please reply here and I'll give you more help.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on March 29, 2013, 03:33:26 PM
Hello!
To this day, we played six tournaments.
I want to keep the top 5 results for each player overall.

At what point do I write the formula "top (5 scores)?"

Can you make screenshots, please?
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on March 29, 2013, 04:01:54 PM
In the "Overall Scores" section.  There you have the option of up to 5 formulas.  Pick any one.  Use the formula:

sum(top(5, scores))
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on March 29, 2013, 05:07:53 PM
Can you make some screen shot, please ?
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on March 30, 2013, 11:25:35 AM
This is ok ?
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on March 30, 2013, 12:18:07 PM
That should do it.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on March 30, 2013, 12:40:02 PM
I think there is an error in the formula.
As for the player "Fred", the "overall score" should be 125 points (the last round played on 6, he scored only 1 point ... and should have 126-1 = 125 points). ..
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on March 30, 2013, 03:29:09 PM
Points are not the same things as Scores.

Points are earned in a tournament.  The Points column on the Stats tab sums those points automatically for you.  We don't know what you've put for your Points formula because we can't see each individual tournament.

But I can see your Tournament Score formula: if ( r<=8, n-r+1, 0)
And your Overall Score formula: sum(top(5, scores))

Your Overall Score formula is correct for counting only the top 5 scores for each player.  Your Tournament Score formula is a valid formula.  Whether or not it is "correct" depends on what you're trying to do.

To see each Score, on the Stats tab press the "View" button and select "Single field mode", then select the "Score" column.  There you can see each score for play "Fred".  That should make it easy to determine if things are right or not.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on April 01, 2013, 09:27:08 AM
Ok!
This is the image :



The player "Fred" should have 125 points (126 - 1) for its top 5 rounds ...
How do I change it?

Thank you in advance for your answers and those already given ... :)
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on April 01, 2013, 10:39:30 AM
To see each Score, on the Stats tab press the "View" button and select "Single field mode", then select the Score column.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on April 01, 2013, 11:23:52 AM
ok!
Here is the picture ...

but I want it to be the points of the best 5 rounds that count ...
(so I want "fred" is a total of 125 points)
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on April 01, 2013, 11:56:43 AM
The Overall Score formula is sum(top(5, scores)).  So it is summing (adding) the top 5 Score values.  Your Tournament Score formula is if ( r<=8, n-r+1, 0).  This gives Fred the Scores 13, 13, 14, 16, 12, and 0.  Those simply don't add up to 126.  They add up to 68, which the "Overall Score" column is displaying.

So, the issue is that your Overall Score formula is summing SCORES, not POINTS.  Change your Tournament Score formula to:

points

This will make each player's Score value the same as their Points value.  Then the Overall Score formula, which adds up Scores, will be adding up the correct values.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on April 02, 2013, 08:56:45 AM
Hello again!

I change the formula, see image!
But it's the same problem... always 126 points for Fred...

How can i do, please ?
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on April 02, 2013, 09:45:48 AM
Change your Tournament Score formula to:

points

This will make each player's Score value the same as their Points value.  Then the Overall Score formula, which adds up Scores, will be adding up the correct values.

Put your Overall Score formula back the way it was.  Make the change I specified above.
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on April 02, 2013, 10:17:01 AM
Hello,

Still the same problem
Please, make screenshots, it will go faster because, I do not understand ...
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Corey Cooper on April 02, 2013, 12:10:00 PM
There's no screenshots necessary.  You've now got it set up correctly.  At least the Stats Profile part.

If you've got your Points for Playing formula correct in each tournament, which should make the Stats single-field view mode (viewing "Scores") look like it does in the screenshot you posted here:

http://www.thetournamentdirector.net/forums/index.php?topic=4328.msg18695#msg18695

Then it should work.  What are you seeing for Fred's Overall Score?
Title: Re: Formule, 5 rounds on 8 possible...
Post by: Tonyo1977 on April 02, 2013, 12:53:29 PM
Thank you very much, it is good!
Sorry for the inconvenience (and my bad english...)