Author Topic: Help me formula!!!  (Read 1586 times)

emafurfo

  • Newbie
  • *
  • Posts: 5
    • View Profile
Help me formula!!!
« on: May 15, 2013, 04:18:42 AM »
Buongiorno io sono italiano.
I have a problem with a formula.
I need to create a formula.
n players * 7 for the 1°
n players * 5 for the 2°
n players * 4,5 for the 3°
n players * 4 for the 4°
n players * 3,5 for the 5°
n players * 3 for the 6°
n players * 2,5 for the 7°
n players * 2 for the 8°
n players * 1,5 for the 9
n players * 1 for the 10°
for all players 10 point.

help help help !!!! :o :o :o

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Help me formula!!!
« Reply #1 on: May 15, 2013, 11:10:24 AM »
if(r < 11, (((12 - r) / 2) + if(r = 1, 1.5)) * n, 10)

emafurfo

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Help me formula!!!
« Reply #2 on: May 16, 2013, 03:24:22 AM »
The formula does not work. Returns only 100,000 or 99.9955 to all participants. Or I need to set something else?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Help me formula!!!
« Reply #3 on: May 16, 2013, 08:28:28 AM »
Works fine for me.  Here's the results for 25 players:


 1: 175.00
 2: 125.00
 3: 112.50
 4: 100.00
 5: 87.50
 6: 75.00
 7: 62.50
 8: 50.00
 9: 37.50
10: 25.00
11: 10.00
12: 10.00
13: 10.00
14: 10.00
15: 10.00
16: 10.00
17: 10.00
18: 10.00
19: 10.00
20: 10.00
21: 10.00
22: 10.00
23: 10.00
24: 10.00
25: 10.00


How are you testing it?

emafurfo

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Help me formula!!!
« Reply #4 on: May 21, 2013, 08:00:22 AM »
not for me.
I set this options

1-----> edit profile
2-----> Source->I select the folder who I saved my file's tournament
          Filter ->1 ->I select my league
                     2 ->I select my season
                     3 ->I select my league
3-----> Scoring -> your formula
4-----> overall Score -> exist formula.

whit this setting, the results are: points 0.00 and overall Score all 100.000 or 99.9955.
that is the problem???


If this setting is ok, the are some thing wrong in my league\season...

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Help me formula!!!
« Reply #5 on: May 21, 2013, 10:16:51 AM »
Players earn points in tournaments.  If you want to create points, use the formula I provided in the "Points for Playing" field on the Game tab.  You'll have to do this for each tournament (that is, load each saved tournament, set the Points for Playing formula, and save the tournament) and going forward you'll need to make sure to set the formula in the Points for Playing field each time.

When you set the formula in the Tournament Score formula field of the Stats Profile, the formula is creating a "Score" value for each player for each tournament.  So, on the Stats tab, it won't affect the "Points" field.  The Points field is the sum of the points the player earned in each tournament that was found when you press "Refresh Stats".

You never said what you wanted to do with the values over a series of tournaments.  The Overall Score formula can sum, average, or otherwise manipulate the Scores to arrive at an overall value for each player.  To make the Overall Score value a sum of the Scores, set the Overall Score formula to:

sum(scores)