Author Topic: Need someone who writes me a formula...Please.  (Read 876 times)

felix

  • Newbie
  • *
  • Posts: 6
    • View Profile
Need someone who writes me a formula...Please.
« on: November 29, 2007, 09:35:49 AM »
Hi...
I have just started using the tournament director. In our earlier tournaments i used excel and i had a formula, where each player got the following points: 10*(number of participants - players finishing rank)
Also the first 3 places got a bonus of:
1st: 3*number of participants
2nd: 2*number of participants
3rd: 1*number of participants

Can anybody of you guys write a formula for me that i can put into TD, that assigns the points as i mentioned in the above.

I would be really happy if you can help me with this.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5450
    • View Profile
Re: Need someone who writes me a formula...Please.
« Reply #1 on: November 29, 2007, 10:23:29 AM »
10 * (n - r) + if(r < 4, (4-r) * n)

felix

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Need someone who writes me a formula...Please.
« Reply #2 on: December 10, 2007, 06:36:17 AM »
thank you very much for the quick help!
I have been away for a while so I wasnt able to reply.
The last days i hosted the first tournament using the TD and your formula worked really great!
Everything i had to type in excel by hand was done automatically and directly exported to Homepokertour.com.
I am really happy with the program.
So again, thank you!!!