Author Topic: Formula help please.  (Read 960 times)

Whiterhino

  • Newbie
  • *
  • Posts: 47
    • View Profile
Formula help please.
« on: October 31, 2009, 04:02:12 AM »
I have inputted data in an effort to run a fault finding and experimental league to pre-empt any issues for my forthcoming league season and I have encountered a problem.

I want to run my league over 13 weeks and award players points for each time that they play using the points for playing formula, which seems to work fine.

I then want to award a score based on those points and I cannot get the tournament or overall score formulae to recognise the “points” variable.

When I can establish a score based on those points I then want to manipulate that into a best 10 from 13 format whereby the equation takes the best 10 results over the season and averages them out, but for those players who have not played 10 games, their score will also be divided by 10 thus rewarding the more loyal players.

Thank you in anticipation


Whiterhino

  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Formula help please.
« Reply #1 on: October 31, 2009, 04:41:02 AM »
Hmm I think I may have solved this.... erm is this the easy answer ?

sum(top(10, scores))/10

Can I really be that stupid ?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5429
    • View Profile
Re: Formula help please.
« Reply #2 on: November 02, 2009, 09:47:05 AM »
This is probably the easy answer.  But you need to understand what happens when computing your Stats.

The "Tournament Scores" formula is a place for you to create a value for a player, for a particular tournament.  So you can come up with your own method of creating some kind of scoring value (exactly in the same way the Points for Playing works).

The "Overall Scores" formula(s) are a way for you to combine the Tournament Scores values you created into a final value.

If you just want to average a player's points, there's no need for you to create a Tournament Scores formula.  However, since the Overall Scores formula is only for combining the Tournament Scores values, you DO need to create values for Tournament Scores.  You do this by simply assigning a player's points to the Tournament Scores value.  Thus, your Tournament Scores formula would simply be:

points

Or, if it makes it clearer if it looks like a formula or expression:

points + 0

In the Overall Scores formula, you can access the Tournament Scores values by using the "scores" variable.  Your formula should work:

sum(top(10, scores))/10

Or you can use the average function:

average(top(10, scores))