The Tournament Director Forums
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
The Tournament Director Forums
»
Main
»
Help Me
»
help point formula
« previous
next »
Print
Pages: [
1
]
Author
Topic: help point formula (Read 866 times)
earlybird57
Newbie
Posts: 9
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?
Logged
efdenny
Full Member
Posts: 166
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)
Logged
earlybird57
Newbie
Posts: 9
Re: help point formula
«
Reply #2 on:
February 03, 2019, 06:13:52 PM »
worked
Thank you
Logged
Print
Pages: [
1
]
« previous
next »
The Tournament Director Forums
»
Main
»
Help Me
»
help point formula