Formula help

[mrwolle]

Hi

I need some help for a new formula for our pokerclub.

1 point per hit
5 point for buyin

Bonus points for 1 to 8 place.

1st n*1
2nd n*0,75
3rd n*0,55

And so on,  please help me with the formula.

Jens

[Corey Cooper]

What are the rest of the places, 5th through 8th, supposed to get?  You say "And so on", but your first through third positions do not give any discernible pattern (at least not to me).

1st = n * 1
2nd = n * .75 (.25 less than 1st)
3rd = n * .55 (.45 less than 1st, or .2 less than 2nd)

What does 4th get?  n * .4?  5th? 6th? 7th? 8th?

[mrwolle]

Hi

Sorry, here comes the rest.

1st n*1
2nd n*0,75
3rd n*0,55
4th n*0,4
5th n*0,35
6th n*0,3
7th n*0,25
8th n*0,2

Jens

[mrwolle]

Hi

Found out that this formula works.

switch(r, 1, n*1, 2, n*75/100, 3, n*55/100, 4, n*40/100, 5, n*35/100, 6, n*30/100, 7, n*25/100, 8, n*20/100,0)

Jens

[tandemrx]

you would have to add +nh +5 to your formula to account for the number of hits and the buy-in points, unless you put those in the separate places of the game tab.

I have gotten to where i prefer to load all the points into the "points for playing" equation (as opposed to including points in other parts of the game tab.  Then I can try out different formula's in the stats filter tournament points section if I want to filter tournaments using a different points scheme (if nothing else, just to try out different formulas on a grouping of actual tourneys).

But either way will work.