1
Help Me / Re: Help on formula please !
« on: March 29, 2010, 04:34:43 PM »
Thanks for this help.
Actually, in our championship, we are playing 16 games of 10 players and 2 games of 20 (multi table). We are 20 players total.
It means your formula doesn't work in my case, but I just found what I needed.
Considering I m modifying each tournament with the formula : switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,1)
If someone is missing the tournament, he gets 0 (switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,0), and at second time -3 (switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,-3).
The following formula works perfectly :
assign("c", count(scores))
if(sum(top(c-1, scores))>sum(scores),sum(scores),sum(top(c-1, scores)))
I had to do this to avoid penalty counted as bonus.
Now it gives back the right result.
I hope this should help someone playing with penalties later
Actually, in our championship, we are playing 16 games of 10 players and 2 games of 20 (multi table). We are 20 players total.
It means your formula doesn't work in my case, but I just found what I needed.
Considering I m modifying each tournament with the formula : switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,1)
If someone is missing the tournament, he gets 0 (switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,0), and at second time -3 (switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,-3).
The following formula works perfectly :
assign("c", count(scores))
if(sum(top(c-1, scores))>sum(scores),sum(scores),sum(top(c-1, scores)))
I had to do this to avoid penalty counted as bonus.
Now it gives back the right result.
I hope this should help someone playing with penalties later