Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Hades

Pages: [1]
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 :)

2
Help Me / Help on formula please !
« on: March 26, 2010, 01:11:50 PM »
Hello,

We organize a poker championship in 10 rounds. Each player gets points for each round with this formula :

switch(r, 1, 15, 2, 12, 3, 10, 4, 8, 5, 6, 6, 5, 7, 4, 8, 3, 9, 2, 10,1)

When someone is missing one game, he receives 0 points. If he misses a second game (and for each game missed after 1), he's got a penalty of 3 points.

Until now, I was using formula :

assign("c", count(scores))
sum(top(c-1, scores))

to calculate global score.
But because I m giving to some players -3 for a round (manually changing the daily formula), actually the formula adds him 3 points !!! Furthermore, if a players gets more than 1 penalty, the formula only counts 1.

Any idea to solve theses 2 problems ?

Thanks a lot

Pages: [1]