KO formula

[FourAcesPoker]

my current formula for determining points is (n-r+1)*100.   my points per hit is in the box above that and it is 25. How can i incorporate hits into my basic formula to reward players for multiple hits?

[badbeat]

((n+1-r)*100) + (nh*25)

nh = number of hits

[Corey Cooper]

Don't forget to set the "Points for hit" input back to 0 so you don't award double points for hits.

[FourAcesPoker]

thanks...i think i might've left out one thing though...is there a solution for the following regarding hits: 1 hit is 25 points, the 2nd is worth 50, (not another 25) (so far total for 2 hits is 75), 3 hits is 25 for the hit + 75 more for the 3rd hit = 100 points, so on and so forth. And can you max it out at 5 hits?

1 hit = 25 points
2nd hit = 50 more points
3rd hit = 75 more points
4th Hit = 100 more points
5th hit and up = 125 more points


so if the player gets 3 hits in a game he receives 25 + 50 + 75 + 100 + 125 = 375 points...follow? hope it isn't confusing...trying to reward players for dominating a game.

[Corey Cooper]

Yikes, a recursive formula.  Can't do that.  But since it maxes out at 5th place, the following should work:

nh * 25 + max(0, (nh - 1) * 25) + max(0, (nh - 2) * 25) + max(0, (nh - 3) * 25) + max(0, (nh - 4) * 25)

By the way, in your example I think you meant "so if the players gets 5 hits in a game he receives ... 375 points"

[Phaze]

Its too bad you couldn't use loops in the formulas, especially now that you can assign variables... any chance that may happen? I've come across a couple of formula requests that I thought may be handled with loops

[FourAcesPoker]

ok, so to go with the 1st formula, it should look like this then:   

((n+1-r)*100) + nh * 25 + max(0, (nh - 1) * 25) + max(0, (nh - 2) * 25) + max(0, (nh - 3) * 25) + max(0, (nh - 4) * 25)

did i leave anything out?

[Corey Cooper]

FourAcesPoker: that looks right.

Phaze: Adding that kind of complexity adds a lot of processing time.  The formula is evaluated for every player every time anything significant within the tournament changes.  I don't think the cost/benefit ratio will pay off.

[Phaze]

understandable... to boot it will make the help me with formulas real wierd