Formula for Playing Time

[gilehmerd]

Hello All:

Does anyone know how I write a formula to award 10 points for every hour each player plays in a tournament? The formula should not award points for anything else but "playing Time".

Regards,
gilehmerd

[badbeat]

(playingTime/3600)*10

This will give 10 points per hour including increments. (eg. 10 mins gives 1.67 points)

I hope this is what you want.

[Corey Cooper]

Building on that: to round to the nearest number of hours:

round(playingTime / 3600) * 10

Replace round with ceil to round up, or floor to round down.

[gilehmerd]

Thank you, it works perfectly..

[senorcj]

Hi, I would like to know how to make formula depending the number of player and the rank they lost
example  the 1st: 30% depending number of player . if 100 players the 1st will have 130 points
the second: 20% so 120 points, the 3dr : 15%, the 4 : 10%, the 5 :8%, the 6: 7%, the 7 :6% , the 8 : 5% and the 9 : 4% all the others take the place they were burst out
ex : if 100 players and the players y was burst out in 30 position I want to give him 70 points ( 100 -30), other example y is burst out 54 he will have 46 points ( 100 - 54 )
in my opinion the formula starts in the number of player
Someone could help me to find the formula.
tkx a lot

[Phaze]

Hola senorcj

I think this formula will do what you request:

Code:

switch(r, 1, (n * 1.3), 2, (n * 1.2), 3, (n * 1.15), 4, (n * 1.1), 5, (n * 1.07), 6, (n * 1.07), 7, (n * 1.06), 8, (n * 1.05), 9, (n * 1.04)) + IF(r > 9, (n - r))

[senorcj]

Great,great,great you re great. The only pb i ve is to do the global score.. Formula doesn t add all the scor and the number of participations stays 0.
Thanks