I guess my challenge is similar to clbg571's ("League Formula Help"), but I do have a couple of other stuff to consider.
I'm now running a 15 tournaments series where the 9 best guys of the first 14 tourneys qualify for the "final". However - only the 10 best tourneys of the first 14 will count before the final tourney is "manned". It's also important that players with only 9 tourneys are not deducted 4 tourneys automatically (if you see what I mean- rusty English here)...
So this is how I tried to set this up:
In every game the "Points for playing" is set like this (final table of 7 players):
if(rank =1, 2+6+n+1-r) +
if(rank =2, 2+4+n+1-r) +
if(rank =3, 2+2+n+1-r) +
if(rank =4, 2+n+1-r) +
if(rank =5, 2+n+1-r) +
if(rank =6, 2+n+1-r) +
if(rank =7, 2+n+1-r) +
if(rank > 7, n+1-r)
The "Tournament Scoring" is just set to "points" (literally, just written in that open field)...?
And the "Overall score formula" is set to: "sum (top (count(scores)-4, scores))"
Is this really correct? I seem to get some strange results...?
And also - the 15th round with the 9 best players... The end result here will divide the 9 top ranks - but if I add this game to the series-filter, it will surely look different.
Does anyone have a good idea on how to set up this series - or do you think this might be the best way?
By the way: there are no money involved in our games (Norway - not legal) - so I always get the warning that says "there are no prizes defined" :-)
Thanx to anyone interested in helping out!