Help for formula again...

[grosminet75]

Hi All,

I try to find a formula for the progress of points below.  This progress has to work also  for 25, 20, 15 players.

For 30 players

de +1 in +1 :

30éme > 1 pts
29éme > 2 pts
28éme > 3 pts
27éme > 4 pts
26éme > 5 pts
25éme > 6 pts
24éme > 7 pts
23éme > 8 pts
22éme > 9 pts
21éme > 10 pts

.........

de +2 in +2 :

20 éme > 12 pts
19 éme > 14 pts
18 éme > 16 pts
17 éme > 18 pts
16 éme > 20 pts

-------

de +3 in +3:

15 éme > 23 pts
14 éme > 26 pts
13 éme > 29 pts
12 éme > 32 pts
11 éme > 35 pts

--------
de +5 in +5 for the Final Table :

10 éme > 40 pts
09 éme > 45 pts
08 éme > 50 pts
07 éme > 55 pts
06 éme > 60 pts
05 éme > 65 pts
04 éme > 70 pts

Podium

03 éme > 85  +15 pts
02 éme > 110 +25 pts
01 éme > 160 +50 pts

Thank you for your help. 

Regards
Grosminet75

[grosminet75]

re-Hi all

the podium change

Podium

03 éme > 78  + 8 pts
02 éme > 93 +15 pts
01 éme > 118 +25 pts

Thank you for your help. 

Regards
Grosminet75

[grosminet75]

i found this below, but the progress points work only for 30 players. I would want that this formula work as well for 30 players as for 15 players


assign("add", switch(r, 1, 88, 2, 64, 3, 50, 4, 43, 5, 39, 6, 35, 7, 31, 8, 27, 9, 23, 10, 19, 11, 15, 12, 13, 13, 11, 14, 9, 15, 10, 15, 7, 16, 5, 17, 4, 18, 3, 19, 2, 20, 1))
assign("v", n-r+1)
v+add

Someone  any ideas !!!!! 
Thank for your Help 

Regards
Grosminet75

[Corey Cooper]

I'd help, but frankly I don't understand your post.  For example, I read this: "de +1 in +1" as "dee ee plus one in plus one", and I just don't know what that means.  Nor do I understand "30éme > 1 pts" (thirty éme(?) is greater than 1 points).  (Please don't take this as being critical - I just genuinely don't understand!)

[badbeat]

I think "30éme > 1 pts" is meant to mean 30th = 1 point, but have no idea about the de +1 part, except "de" is French for "of". 

[Phaze]

yeah I tried google translate and I couldn't figure it out either...


Grosminet, the problem you are going to have is that you want a variable formula but you have very specific numbers. It won't go into a variable formula. What you are asking us to do is spend an hour typing out a very long formula and we don't even know if its exactly what you want yet

[grosminet75]

OK, thank all for your answer,

In the first time, sorry for my english is't not very good. I go tried be understood !!!! 

I think my formule it's not easy but not impossible !!!!!  The progress of points which i want is not complicated as well as it.

The formula has to work for a tournament of 30 players to 10 players.

30th players in 21th players => The progress point is 1 by 1

30éme = 1 pts
29éme = 2 pts
28éme = 3 pts
27éme = 4 pts
26éme = 5 pts
25éme = 6 pts
24éme = 7 pts
23éme = 8 pts
22éme = 9 pts
21éme = 10 pts

20th players in 16th players => The progress point is 2 by 2 OK

20 éme = 12 pts
19 éme = 14 pts
18 éme = 16 pts
17 éme = 18 pts
16 éme = 20 pts

15th players in 11th players => The progress point is 3 by 3 OK

15 éme = 23 pts
14 éme = 26 pts
13 éme = 29 pts
12 éme = 32 pts
11 éme = 35 pts

For the Final Table (10 to 4 only)

10th players in 4th players => The progress point is 5 by 5 OK

10 éme = 40 pts
09 éme = 45 pts
08 éme = 50 pts
07 éme = 55 pts
06 éme = 60 pts
05 éme = 65 pts
04 éme = 70 pts

For the Podium

03 éme = 78 (3th only => The progress point is +8 more than the 4th
02 éme = 93 (2second only =>The progress point is +15 more than the 3th
01 éme = 118 (1st only => = The progress point is +25 more than the 2second

Do you understand now ? Perhaps someone speak french ? 

For finish if your try my first formula release, in my precedent post below, i think you understand de progress point that i want.

Sorry again for my english 


Regards
Grosminet75

[Phaze]

   
Grosminet, le problème que vous allez devoir est que vous souhaitez une formule variable mais vous avez très spécifiques numéros. Il ne vais pas entrer dans une formule variable. Ce que vous nous demandez de faire est de passer une heure à taper une formule très longue et nous ne savons même pas si ses exactement ce que vous voulez encore

[grosminet75]

Hi Phase,

I understand your last mail, that in english  but i don't understand why this formula is not possible ?

Do you understood the progress of points which I want in this formula ? Nevertheless there are formulas more complex, NO ?
Thank again for your help

Regards
Grosminet75

[Phaze]

you are asking us to make a variable formula when you manually give out points. This is easy, yes, but requires a lot of typing. Could you not just do a tried and tested formula and then add points for final table, and in the money?

[Corey Cooper]

Here you go:

switch(r, 1, 118, 2, 93, 3, 78) + if(r > 3 and r < 12, 30 + (12 - r) * 5) + if(r > 11 and r < 17, 17 + (17 - r) * 3) + if(r > 16 and r < 22, 8 + (22 - r) * 2) + if(r > 21, max(31 - r, 0))

[grosminet75]

Hi Corey

Great job !!!! Thank you for your help, but this formula keep the same progress.

For example what I would want for 10 players. The progress of points :


10 éme = 1 pts
09 éme = 2 pts
08 éme = 4 pts
07 éme = 6 pts
06 éme = 9 pts
05 éme = 12 pts
04 éme = 17 pts
03 éme = 25 (3th only => The progress point is  +8 more than the 4th
02 éme = 40 (2second only =>The progress point is +15 more than the 3th
01 éme = 65 (1st only => = The progress point is +25 more than the 2second

If this more complexe, stop your help. Thanks a lot again

I think use a different formula following the number of players. More Easy !!!

Regards
Frederic Roger

[Phaze]

yeah, the only way I could figure out doing this formula is re-writing the whole formula to compensate for the different number of players 
I hope cory can come up with the solution, but beyond me except to make it even 3 times longer than the one cory did... a lot of work, and if your tournament ever changes, it means another re-write

This could be better if it would be a variable formula

[Corey Cooper]

OK, I see that you would like it to work similarly for differing numbers of players.  I also see that the "progress" of points is the same for 10 players as it is for 30 players.  10th and 9th are a 1 point difference.  9th, 8th, and 7th are a 2 point difference.  7th, 6th, and 5th are a 3 point difference.  5th and 4th are a 5 point difference.  4th and 3rd are an 8 point difference, etc.  Same as for 30 players, except for 30 players the runs are spread out more.

But you don't specify how to "spread out" the point differences.  How does it work for 11 players?  For 12 players?  For 15 players?  For 20 players?  For 25 players?

Phaze has a point.