1

**Help Me / Simple Formula**

« **on:**January 28, 2012, 12:39:53 AM »

Hello to everybody...

I did my formula, and it worked... but, I want to know, if there is another way to simple that...

The last one receive one point , sum one more for each position until 11º place. If(r >=11, n-r+1)

10º - Sum the points before, + 2% of the pot /1000.

9º - Sum the points before, + 3% of the pot /1000.

8º - Sum the points before, + 4% of the pot /1000.

7º - Sum the points before, + 5% of the pot /1000.

6º - Sum the points before, + 6% of the pot /1000.

5º - Sum the points before, + 8% of the pot /1000.

4º - Sum the points before, + 10% of the pot /1000.

3º - Sum the points before, + 20% of the pot /1000.

2º - Sum the points before, + 30% of the pot /1000.

1º - Sum the points before, + 50% of the pot /1000.

assign("p1", 50*pot/1000)

assign("p2", 30*pot/1000)

assign("p3", 20*pot/1000)

assign("p4", 10*pot/1000)

assign("p5", 8*pot/1000)

assign("p6", 6*pot/1000)

assign("p7", 5*pot/1000)

assign("p8", 4*pot/1000)

assign("p9", 3*pot/1000)

assign("p10", 2*pot/1000)

assign("total", sum(p1+p2+p3+p4+p5+p6+p7+p8+p9+p10+n)-10)

switch(r,1,total,2,total-p1,3,total-(p1+p2),4,total-(p1+p2+p3),5,total-(p1+p2+p3+p4),6,total-(p1+p2+p3+p4+p5),7,total-(p1+p2+p3+p4+p5+p6),8,total-(p1+p2+p3+p4+p5+p6+p7),9,total-(p1+p2+p3+p4+p5+p6+p7+p8),10,total-(p1+p2+p3+p4+p5+p6+p7+p8+p9))+if(r >= 11, n-r+1)

So... Could you help me ?

I did my formula, and it worked... but, I want to know, if there is another way to simple that...

The last one receive one point , sum one more for each position until 11º place. If(r >=11, n-r+1)

10º - Sum the points before, + 2% of the pot /1000.

9º - Sum the points before, + 3% of the pot /1000.

8º - Sum the points before, + 4% of the pot /1000.

7º - Sum the points before, + 5% of the pot /1000.

6º - Sum the points before, + 6% of the pot /1000.

5º - Sum the points before, + 8% of the pot /1000.

4º - Sum the points before, + 10% of the pot /1000.

3º - Sum the points before, + 20% of the pot /1000.

2º - Sum the points before, + 30% of the pot /1000.

1º - Sum the points before, + 50% of the pot /1000.

**Formula**assign("p1", 50*pot/1000)

assign("p2", 30*pot/1000)

assign("p3", 20*pot/1000)

assign("p4", 10*pot/1000)

assign("p5", 8*pot/1000)

assign("p6", 6*pot/1000)

assign("p7", 5*pot/1000)

assign("p8", 4*pot/1000)

assign("p9", 3*pot/1000)

assign("p10", 2*pot/1000)

assign("total", sum(p1+p2+p3+p4+p5+p6+p7+p8+p9+p10+n)-10)

switch(r,1,total,2,total-p1,3,total-(p1+p2),4,total-(p1+p2+p3),5,total-(p1+p2+p3+p4),6,total-(p1+p2+p3+p4+p5),7,total-(p1+p2+p3+p4+p5+p6),8,total-(p1+p2+p3+p4+p5+p6+p7),9,total-(p1+p2+p3+p4+p5+p6+p7+p8),10,total-(p1+p2+p3+p4+p5+p6+p7+p8+p9))+if(r >= 11, n-r+1)

So... Could you help me ?