Author Topic: Formula help please. Thank you in advance.  (Read 1055 times)

Mesnik44

  • Jr. Member
  • **
  • Posts: 73
    • View Profile
Formula help please. Thank you in advance.
« on: January 04, 2016, 08:38:58 PM »
Hi Formula Gurus,

I'm looking for a formula that counts 5 points per placing up to 5th. Zero for last place. At 4th place, there is a point difference of 10points from 5th place, and 5 points again from 4th to 1st.
SO....if there are 10 players in the tournament, last gets 0, 9th = 5, 8th = 10, 7th = 15, 6th = 20, 5th = 25, 4th = 35, 3rd = 40, 2nd = 45, 1st = 50.
The amount of players will vary from 6 - 20. The 10 point difference always will happen between 4th and 5th places.


Also, 5 points are given for buy in. 10 points are given for early buy in ( cut off 15 mins before game ), 5 points are given for hits.

Anyway to do this?

Thanks,
John

shushs

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
Re: Formula help please. Thank you in advance.
« Reply #1 on: January 05, 2016, 09:59:47 AM »
For 20 players, would first get 100?

Can you create a quick chart for what you expect with 10 players, 20 players, and 6 players?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula help please. Thank you in advance.
« Reply #2 on: January 05, 2016, 02:43:16 PM »
position * 5 + if(r < 5, 5) + (nh * 5)

The formula handles the 5 points for buy-in, plus the points for each rank, plus the points for hits.  For the extra 5 points given for early buy-in, I would create a second buy-in profile, identical to the main buy-in profile, but set Points to 5.  Use that profile for buying players in until the "early" time runs out and switch to using the main buy-in profile.

Mesnik44

  • Jr. Member
  • **
  • Posts: 73
    • View Profile
Re: Formula help please. Thank you in advance.
« Reply #3 on: January 05, 2016, 07:03:29 PM »
Thanks a ton.....AGAIN Corey!

John