How to calculate points for a ranking?

[henriquebs]

Hi, it is my first topic here, and I would like to know if there is a formula to calculate the points that players earn for the position that they stay. But these points depend on how many people are playing.
Giving an example. If there are 20 players the first place earns 1450 points. But if there are 24 players, the 1st. places earns 1740 points.
Thank you for the help.

[Magic_fubu]

There definitely are formulas that you can enter. Most may be found in the 'help me' section. To come up with a formula, there are many things to consider. How much space do you want between places (evenly spaced, more space at the top while leveling out towards the bottom)? How many spots get points (all, some, top 3, and so on)?   Along the lines of spacing between places, how important is it to avoid ties? How long of a season do you plan on having as far as number of tournaments go? Do you want to award points just for playing and/or knocking out players? Do you want to penalize those who rebuy/addon?

If you have an idea of how you want to award the points, then we would be able to help more. If you need help with how you want the points to be set up for your league, let us know - we'll help you with that too.  Ultimately, it's up to you and how you want it set up.

[henriquebs]

Thanks for the answer.
In fact we have already a sheet with the points calculated by number of players in each game, by position. We have a sheet that we actualize it, but I would like that with the formulas, as soons as a player is busted out of a tournament, the points that he earned already appear in TD. I put above some lines of this points, with the ranking in the column and the number of players in the lines: Example, with 11 players, the 1st players earns 735 points, the 2nd. 548, etc.

   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27
6   435   274   148   30   20   10                                                               
7   445   284   158   40   30   20   10                                                            
8   580   406   276   154   40   30   20   10                                                         
9   590   416   286   164   50   40   30   20   10                                                      
10   725   538   404   278   160   50   40   30   20   10                                                   
11   735   548   414   288   170   60   50   40   30   20   10                                                
12   870   670   532   402   280   170   60   50   40   30   20   10                                             
13   880   680   542   412   290   180   70   60   50   40   30   20   10                                          
14   1015   802   660   526   400   290   180   70   60   50   40   30   20   10                                       
15   1025   812   670   536   410   300   190   80   70   60   50   40   30   20   10                                    
16   1160   934   788   650   520   410   300   190   80   70   60   50   40   30   20   10                                 
17   1170   944   798   660   530   420   310   200   90   80   70   60   50   40   30   20   10                              
18   1305   1066   916   774   640   530   420   310   200   90   80   70   60   50   40   30   20   10                           
19   1315   1076   926   784   650   540   430   320   210   100   90   80   70   60   50   40   30   20   10                        
20   1450   1198   1044   898   760   650   540   430   320   210   100   90   80   70   60   50   40   30   20   10                     
21   1460   1208   1054   908   770   660   550   440   330   220   110   100   90   80   70   60   50   40   30   20   10                  
22   1595   1330   1172   1022   880   770   660   550   440   330   220   110   100   90   80   70   60   50   40   30   20   10               
23   1605   1340   1182   1032   890   780   670   560   450   340   230   120   110   100   90   80   70   60   50   40   30   20   10            
24   1740   1462   1300   1146   1000   890   780   670   560   450   340   230   120   110   100   90   80   70   60   50   40   30   20   10         
25   1750   1472   1310   1156   1010   900   790   680   570   460   350   240   130   120   110   100   90   80   70   60   50   40   30   20   10      
26   1885   1594   1428   1270   1120   1010   900   790   680   570   460   350   240   130   120   110   100   90   80   70   60   50   40   30   20   10   
27   1895   1604   1438   1280   1130   1020   910   800   690   580   470   360   250   140   130   120   110   100   90   80   70   60   50   40   30   20   10

[Corey Cooper]

I think you missed a few crucial lines (1st through 5th places?).  Or am I reading it wrong?

[Magic_fubu]

I think so, Corey. With henriquebs stating that with 11 players, 1st earns 735, I looked down the first column to 11, went over one to see the 735... still throwing me for a loop (sure there's some math/trig function at work here)

[henriquebs]

I only noted now that the numbers are a mess, but as Magic _fubu noted the numbers are correct, for example, in a tournament with 6 people (line above), the points stays like this:
1st- 435
2nd - 274
3rd. - 148
4th. - 30
5th - 20
6th - 10.

I created the formula above that gives me the correctly points (I did with 22 to 26 players) and it is working. Do you agree with that? is there an easier way?
Thanks all for the answers.


if(n=26, switch(r, 1, 1885, 2, 1594, 3, 1428, 4, 1270, 5, 1120, 6, 1010, 7, 900, 8, 790, 9, 680, 10, 570, 11, 460, 12, 350, 13, 240, 14, 130, 15, 120, 16, 110, 17, 100,18, 90,19, 80,20, 70,21, 60,22, 50,23, 40,24, 30,25, 20, 26,10)) +
if (n=25, switch(r, 1, 1750, 2, 1472, 3, 1310, 4, 1156, 5, 1010, 6, 900, 7, 790, 8, 680, 9, 570, 10, 460, 11, 350, 12, 240, 13, 130, 14, 120, 15, 110, 16, 100, 17,90,18,80,19,70,20,60,21,50,22,40,23,30,24,20,25,10)) +
if(n=24, switch(r, 1, 1740, 2, 1462, 3, 1300, 4, 1146, 5, 1000, 6, 890, 7, 780, 8, 670, 9, 560, 10, 450, 11, 340, 12, 230, 13, 120, 14, 110, 15, 100,16,90,17,80,18,70,19,60,20,50,21,40,22,30,23,20,24,10)) +
if(n=23, switch(r, 1, 1605, 2, 1340, 3, 1182, 4, 1032, 5, 890, 6, 780, 7, 670, 8, 560, 9, 450, 10, 340, 11, 230, 12, 120, 13, 110, 14, 100, 15, 90 , 16, 80, 17, 70, 18, 60, 19, 50, 20, 40, 21, 30, 22, 20, 23 , 10)) +
if(n=22, switch(r, 1, 1595, 2, 1330, 3, 1172, 4, 1022, 5, 880, 6, 770, 7, 660, 8, 550, 9, 440, 10, 330, 11, 220, 12, 110, 13, 100, 14, 90, 15, 80, 16, 70, 17, 60, 18, 50, 19, 40, 20, 30, 21, 20, 22, 10))

[Corey Cooper]

Sorry, I was looking at it wrong.  But there still is some potentially missing data, unless you will definitely never have tournaments with less than 6 players (which is reasonable).

Your approach will work.  I would call it the "brute force" method.  There might be a better way if one can spot the patterns in the data.

[Magic_fubu]

My question (hopefully to help those like Corey who can easily do formulas) is this: Is the spreadsheet that's been created just created, or was there a formula used? If you post the formula here, we should be able to knock down Goliath a bit and make it more manageable.

[dedam]

I'm trying to work it out in a formula. Some of the logic I already have covered in it but not all.

What I have noticed at a quick glance is the following:

• if r>(0.5*n) they get 10 points per interval in r resulting in ((n+1)-r)*10
• if n is even then the interval in points for 1st rank is 135 compared to 1st in previous n (n-1)
• if n is odd then the interval in points for 1st rank is 10 compared to 1st in previous n (n-1)
• there is a same kind of logic for other rankings where the interval between r and r-1 is decreasing

I fail to see the logic in why in even cases the interval is 135 and in odd cases it's 10 even though there is a logic there

So looking solely at the 1st ranking it would result in the following formula:

(floor(r/2)*135)+(ceiling(r/2)*10)

Now I only need to work out the logic behind the intervals for every r

[dedam]

Ok, so basically it works out in 3 formulas to calculate the points for ranking.

1st formula is 10 points per rank for every participant:

Code: [Select]

( ( n + 1 ) - r ) * 10
2nd formula is an additional 100 points per rank for the top 50% participants:

Code: [Select]

((n + 1) - r - ceil(0.5 * n)) * 100 + 1st formula
3rd formula is an additional reward for the top 4 participants based on a different interval per rank and on an odd or even number of total participants:

Code: [Select]

assign("interval",  switch ( r, 1, 25, 2, 12, 3, 8, 4, 4 ))
((( floor( 0.5 * n ) - r ) + 1 ) * interval ) + 1st formula + 2nd formula

Now combine these 3 formulas with the necesarry conditional test to calculate the points for the rank and it would result in this formula:

Code: [Select]

assign("interval",  switch(r, 1, 25, 2, 12, 3, 8, 4, 4))
assign("basepoints", ((n + 1) - r ) * 10)
assign("tophalfpoints", if(r <= (0.5 * n), ((n + 1) - r - ceil(0.5 * n)) * 100, 0))
assign("topfourpoints", if(r <= 4, ((floor(0.5 * n) - r) + 1) * interval, 0))
basepoints + tophalfpoints + topfourpoints

This will (no correction: DOES) work in TD, but perhaps there is somebody else who will be able to normalise this formula even further

[henriquebs]

Amazing, unbeliveable!!!!
The formula are simply perfect.
Thank you all for the answers and help.

[Seitz333]

Here is a formula I use.

10*(SQRT(n)/(r)) - 5 + (numberOfHits*1.25) - (rebuys*5)
A. Gives a base of 5 points for last place no matter how many players (assuming they do not rebuy).
B. The more players the more the points your get for your place of finish.
C. Players get 1.25 points for each bounty earned.
D. Players are given -5 points for each rebuy.

Chuck