Formula help please

[theeatbob]

I need help with my formula. Thank you.

Points:

1st----------1500
2nd---------1300
3rd----------1100
4th----------1000
5th------------800
6th------------700
7th------------600
8th------------500
9th------------400
10th----------300
less than 20 players
11th-19th---100
20 or more players
11-16---------200
rest of field-100

These point totals are then multiplied by the number of players divided by ten.  In other words 34 players would multiply the points by 3.4.

The points are based on a 10 dollar buy in tournament. Every dollar over 10 will increase the points by another 5% on top of the the extra player increase. In other words a $25 buy in would increase points by 1.75 ($25-$10=15*5%=.75)

Bounty: Eliminating the bounty will be equal to 10th place points for the tournament.

So First place in a $25 tournament with 34 players would be 1500*3.4*1.75=8925

I also like everything to be rounded up to the nearest 5. So 11,12,13,14 would be rounded up to 15 and 16,17,18,19 would be rounded up to 20. If this is possible to add to the equation that wouls be great, but I can handle the rounding on my own if it can't be done.

Thanks for any help you can give me. It's greatly appreciated

[Phaze]

Code: [Select]

(100 + switch( r, 1, 1400, 2, 1200, 3, 1000, 4, 900, 5, 700, 6, 600, 7, 500, 8, 400, 9, 300, 10, 200) + if(n > 19, if(r > 10 && r < 17,100))) * (n / 10) * ((bc - 10) * .05 +1)
This formula should work for ya, but I didn't put the bounty part in. I think you may have to manually add points for the bounty because it sounds like you have one person as the bounty. Also, there may be a way to round to the 5 but in the help on formulas it only shows how to round to the nearest integer, so someone else might be able to help with that one

Just try testing this formula it out, it works with your example but I'm late for work and can't do any more testing .... good luck

[Corey Cooper]

I'll add a "round to nearest N" function to formulas.

[Phaze]

Hey Cory, whattabout the bounty thing? I think what he is saying is that they put a bounty on a specific person and if you take that person out you get points... any way to do that? You see that kinda bounty when you have celebs playing poker, and sometimes when you have the winner of the previous tournament.

[Corey Cooper]

Create a bounty prize, set the points in the prize.

[Phaze]

yeah, I was thinking about that but wasn't completely sure thats how it worked... thanks

[macacan]

Works well, I use the points on a bounty all the time.
In the league games there is a bounty of 200 points on
the previous winners head.


 

[theeatbob]

Corey can u add a round to the nearest 5 into this formula please?

Keith

[theeatbob]

Or actually if you could round up to the nearest 5 that would be great. But either way works. Thanks.

Keith

[Corey Cooper]

assign("val", (100 + switch( r, 1, 1400, 2, 1200, 3, 1000, 4, 900, 5, 700, 6, 600, 7, 500, 8, 400, 9, 300, 10, 200) + if(n > 19, if(r > 10 && r < 17,100))) * (n / 10) * ((bc - 10) * .05 +1))
if((val % 5) > 0, val - (val % 5) + 5, val)

[theeatbob]

Thank you very much