Author Topic: Simple Formula  (Read 759 times)

fperes

  • Newbie
  • *
  • Posts: 7
    • View Profile
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.

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 ?