Author Topic: Formule, 5 rounds on 8 possible...  (Read 1966 times)

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Formule, 5 rounds on 8 possible...
« 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

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #1 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.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #2 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?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #3 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))

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #4 on: March 29, 2013, 05:07:53 PM »
Can you make some screen shot, please ?

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #5 on: March 30, 2013, 11:25:35 AM »
This is ok ?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #6 on: March 30, 2013, 12:18:07 PM »
That should do it.

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #7 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). ..

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #8 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.

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #9 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 ... :)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #10 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.

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #11 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)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #12 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.

Tonyo1977

  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #13 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 ?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5420
    • View Profile
Re: Formule, 5 rounds on 8 possible...
« Reply #14 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.