Author Topic: Help with formula  (Read 1274 times)

dniezby

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
Help with formula
« on: June 06, 2010, 09:27:58 AM »
I need some help with a formula.

I want each player that plays to have a value of 50 points.  So, the point pool changes based on the number of participants.

For example, if 10 players play, the total points pool is 500.  If 50 players play then it's 2500. 
Then I want to pay out the top 40% of the field.

Is this even possible?

To make things even more complicated, I want to give anyone that brings a guest 25 points. Though, I think the easy thing here is to just give points as an add-on.

Any help here would be greatly appreciated.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Help with formula
« Reply #1 on: June 07, 2010, 10:48:26 AM »
Sounds possible to me.  How would you pay out the top 40% of the field?  For example, if you had 100 players, and you wanted to award the points evenly to the top 40%, then each player from 1st place to 40th place would get 125 points (100 players X 50 points = 5,000 points divided by 40 players (40% of 100) = 125 points):

assign("c", floor(n * .4))
if(r <= c, (n * 50) / c)


You could add 25 points (for players bringing a guest) by manually adjusting the player's points (by editing the player on the Players tab).  Or you could perform an add-on for the player, where the fee, rake, and chips received were $0 and the points received was 25.  I probably wouldn't have thought of that but it seems like it would work just fine.

dniezby

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
Re: Help with formula
« Reply #2 on: June 07, 2010, 04:32:14 PM »
I've given it some thought and I might just set some different criteria. Otherwise if we have too many players it will actually hurt players points 'cause the field  will also increase.

What about this.

<24 players then we payout top 8 players. After that we pay out 16. After 50 players we lock it in at 25 payouts.

Using that idea, how do I make the formula recognize each player as having an inherent value of 50 points to contribute to a points pool then assign the points to meet that criteria?

Unless anyone else has a better idea?

I'll tell you that my goal is to encourage players to spread the word and participate in it's growth. More players the more points.
 

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Help with formula
« Reply #3 on: June 07, 2010, 08:37:40 PM »
DN:

to accomidate the 50 points, thre should be a field on the initial screen that states "point for buyin" - enter you should be able to enter in the fifty points there.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Help with formula
« Reply #4 on: June 08, 2010, 11:13:56 AM »
How would you payout those spots?  Here's a formula that pays out the spots evenly:

if(n < 24,
  if(r < 9, (n * 50) / 8 ),
if(n < 50,
  if(r < 17, (n * 50) / 16),
  if(r < 51, (n * 50) / 25)
))


For example, if the tournament has 20 players, there will be 1,000 points (50 * 20) to divide amongst the top 8 players, so each player will get 125 points.  If the tournament has 25 players, there will be 1,250 points to divide amongst the top 16 players, so each player will get 78.125 points.

dniezby

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
Re: Help with formula
« Reply #5 on: June 13, 2010, 06:56:25 PM »
I don't know why I keep making things so difficult.

Here is what I've come down to each player is going to have an innate value of 50 points.

We are going to pay out points to the top 16 only.

1% of the total points pool for 9th thru 16th.
4% 8th
5% 7th
6% 6th
7% 5th
8% 4th
12% 3rd
20% 2nd
30% 1st

I'm giving individual players 25 points for add-ons and 10 points just for showing up.

I think the problem is that these points, shouldn't be calculated into the points pool.

How do I get it to give out the 50 points per player prize pool and only give those "points for playing" and "Points for add-on" to the individual player? 

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Help with formula
« Reply #6 on: June 14, 2010, 11:18:04 AM »
assign("v", n * 50)
switch(r, 1, v * .3, 2, v * .2, 3, v * .12, 4, v * .08, 5, v * .07, 6, v * .06, 7, v * .05, 8, v * .04, if(r < 17, v * .01, 0)) + (na * 25) + 10

dniezby

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
Re: Help with formula
« Reply #7 on: June 14, 2010, 04:14:57 PM »
Lol holly crap. Our formula was way off.

So, using this formula, do we not put values in the points for buy in and the points for add—on? Or should I still put tons values in?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Help with formula
« Reply #8 on: June 14, 2010, 05:08:39 PM »
assign("v", n * 50)
switch(r, 1, v * .3, 2, v * .2, 3, v * .12, 4, v * .08, 5, v * .07, 6, v * .06, 7, v * .05, 8, v * .04, if(r < 17, v * .01, 0)) + (na * 25) + 10

The part in red is the "points for buy in" requirement.

assign("v", n * 50)
switch(r, 1, v * .3, 2, v * .2, 3, v * .12, 4, v * .08, 5, v * .07, 6, v * .06, 7, v * .05, 8, v * .04, if(r < 17, v * .01, 0)) + (na * 25) + 10


The part in red is the "points for add-on" requirement.

So the answer is leave those values out; they are already accounted for in the formula.