Author Topic: help point formula  (Read 866 times)

earlybird57

  • Newbie
  • *
  • Posts: 9
    • View Profile
help point formula
« on: February 03, 2019, 07:08:18 AM »
we have a point system used on excel and would like to use this on the TD.
we have 2 rules.
1.  numbers of players minus place plus 1. ( this gives 1 point to the last finisher, 2 points for the next and so on.
2. the winner will get same points as number of players, second place will get half as many points as numbers of players, third place will get a quarter of points as the numbers of players.....and so on

we then  combine  1 and 2

this would give 15 players a result like this:

1.     30
2.     21,5
3      16,8
4.     13,9
5.     11,9
6.     10,5
7.     9,2
8.     8,1
9.     7,1
10.   6
11.   5
12.   4
13.   3
14.   2
15.   1

is there a way to do this in TD?

efdenny

  • Full Member
  • ***
  • Posts: 166
    • View Profile
Re: help point formula
« Reply #1 on: February 03, 2019, 12:36:08 PM »
I'll give it a shot... this should get you what you're looking for:

(n-r+1) + switch(r,1,n,2,n/2,3,n/4,4,n/8,5,n/16,6,n/32,7,n/64,8,n/128,9,n/256)

earlybird57

  • Newbie
  • *
  • Posts: 9
    • View Profile
Re: help point formula
« Reply #2 on: February 03, 2019, 06:13:52 PM »
worked
Thank you :)