Another Points Formula Calculation

[Poiso]

Hello, I currently manage a points basesd poker league that runs 6 nights per week and averages 55 players a night.  I am hoping that someone could help me figure out a formula for my league.  I have posted a brief description below, as well as our points chart.

My points structure is simple.  Top 16 always finish in points; any tournament with 32 players or less is a base of 1500 points.  Any tournament with 41 or more is entitled to bonus points.  They are calculated at a total of 10 additional points per player, and split up according to the percentages on the side.  (EX: 44 total enterants would equate to 1940 total points.) 

I think the tricky part is between 33 and 40 players, if you need some data on the how many points are allocated for this section, please advise and I will post the data.



Place   Percent   Points Example           
   Players -->   32
                  (or less)   40            48     56       64
1st   30.00%   450.00   570.00   594.00   618.00   642.00
2nd   20.00%   300.00   380.00   396.00   412.00   428.00
3rd   12.00%   180.00   228.00   237.60   247.20   256.80
4th   8.00%   120.00   152.00   158.40   164.80   171.20
5th   7.00%   105.00   133.00   138.60   144.20   149.80
6th   6.00%   90.00   114.00   118.80   123.60   128.40
7th   5.00%   75.00   95.00   99.00   103.00   107.00
8th   4.00%   60.00   76.00   79.20   82.40   85.60
9-16th   1.00%   15.00   19.00   19.80   20.60   21.40
TOTAL POINTS   1500   1900   1980   2060   2140

Thanks

Greg

[Corey Cooper]

A couple of things:

(1) If only tournaments with 41 players or more are entitled to the bonus points, why does your chart start awarding bonus points starting at tournaments with 40 players?

(2) It doesn't sound like, according to your description, that tournaments with 33 to 40 players should receive any additional points (i.e., they should still divide a 1500 point pool).  But you say that 33 to 40 players is the tricky part.  Do you in fact award additional points for tournaments of those sizes, or am I just misinterpreting this?

Assuming bonus points actually start at 40 players, here is the formula:

(1500 + if(n >= 40, n * 10)) * switch(r, 1, 0.30, 2, 0.20, 3, 0.12, 4, 0.08, 5, 0.07, 6, 0.06, 7, 0.05, 8, 0.04, 9, 0.01, 10, 0.01, 11, 0.01, 12, 0.01, 13, 0.01, 14, 0.01, 15, 0.01, 16, 0.01)

Change the 40 in the above formula to the appropriate number of players to start the bonus points.  Obviously this answer is also dependent on the answer to (2) above.

[Poiso]

(1500 + if(n >= 40, n * 10)) * switch(r, 1, 0.30, 2, 0.20, 3, 0.12, 4, 0.08, 5, 0.07, 6, 0.06, 7, 0.05, 8, 0.04, 9, 0.01, 10, 0.01, 11, 0.01, 12, 0.01, 13, 0.01, 14, 0.01, 15, 0.01, 16, 0.01)

Hi Corey,

I guess I over complicated the calculation.  Your formula works perfectly, I just had to change the 40 to 32 and it calculates and awards all points and positions properly.
One question not related to the formula.  Now that I have the formula, and enterred the prizes under the prizes tab.  When I am running the tournament, it displays at seen below.

I was hoping that the points would display, not the cash value.

Greg

[Magic_fubu]

What you're seeing is the results of the program looking at the prizes tab, and seeing nothing configured there. As of right now, I don't believe it can configure the points as you're looking it to do, but I do know you can export it afterwards how you want it from the Game tab... But Corey would know if it can show the points to be awarded via formula more so than I would.

[Corey Cooper]

On the Layout tab, double-click the Prizes cell.  In the HTML box you should see:

<prizes orient="horizontal">

Highlight some (any part) of the text and press the Insert Token button.  The Insert Token dialog should open with the prizes token already selected (and options already selected).  Check the box next to showAmounts and set it to false.  Check the box next to showPoints and set it to true.  Press the OK button on the Insert Token dialog, then press the OK button on the Cell Properties dialog.

Save the layout if you want to use it again without modifying that cell.

[Poiso]

Perfect.

Everything is displaying properly.  Thanks all for your help!