1

**Help Me / Best-outta-14-tourneys, 10-counting, reach-final-table-formula (Puh!)**

« **on:**August 19, 2009, 12:10:39 PM »

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!

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!