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

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.

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: