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
»
Easy point formula help
« previous
next »
Print
Pages: [
1
]
Author
Topic: Easy point formula help (Read 1041 times)
theeatbob
Newbie
Posts: 12
Easy point formula help
«
on:
April 26, 2018, 12:08:39 PM »
I don't know the first thing about setting up a points formula. I just need a formula that will give
21-24 = 0 pts
17-20 = 1 pt
13-16 = 3 pts
9-12 = 5 pts
5-8 = 7 pts
1-4 = 10 pts
Thanks for any help
Keith
Logged
efdenny
Full Member
Posts: 166
Re: Easy point formula help
«
Reply #1 on:
April 26, 2018, 01:51:53 PM »
I'll take an attempt at this one:
if((r >= 17) and (r <= 20), 1) + if((r >= 13) and (r <= 16), 3) + if((r >= 9) and (r <= 12), 5) if((r >= 5) and (r <= 8 ), 7) + if((r >= 1) and (r <= 4), 10)
I'm sure there's an easier/cleaner way, but this should do the trick.
Logged
theeatbob
Newbie
Posts: 12
Re: Easy point formula help
«
Reply #2 on:
April 26, 2018, 02:33:01 PM »
That formula came up with errors.
Logged
theeatbob
Newbie
Posts: 12
Re: Easy point formula help
«
Reply #3 on:
April 26, 2018, 02:35:20 PM »
How can ido something like:
24th=0
23=0
22=0
21=0
20=1
19=1
18=1
etc.
I don't mind having to put in the value 24 times. I just don't know how to make a rank equal a certain point total. I'm sure it's easy I just don't know how.
Keith
Logged
efdenny
Full Member
Posts: 166
Re: Easy point formula help
«
Reply #4 on:
April 26, 2018, 03:49:10 PM »
Quote from: theeatbob on April 26, 2018, 02:33:01 PM
That formula came up with errors.
Sorry, typo... here's the corrected formula.
if((r >= 17) and (r <= 20), 1) + if((r >= 13) and (r <= 16), 3) + if((r >= 9) and (r <= 12), 5) + if((r >= 5) and (r <= 8 ), 7) + if((r >= 1) and (r <= 4), 10)
Logged
efdenny
Full Member
Posts: 166
Re: Easy point formula help
«
Reply #5 on:
April 26, 2018, 03:52:05 PM »
for specifying which rank gets which points, use "switch". No need to specify "0" points. As per your example:
switch(r,18,1,19,1,20,1)
But, in this instance, I think my previous post is easier.
Logged
theeatbob
Newbie
Posts: 12
Re: Easy point formula help
«
Reply #6 on:
April 26, 2018, 05:22:01 PM »
Thank you very much.
Keith
Logged
Print
Pages: [
1
]
« previous
next »
The Tournament Director Forums
»
Main
»
Help Me
»
Easy point formula help