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))