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
»
Total points formula
« previous
next »
Print
Pages: [
1
]
Author
Topic: Total points formula (Read 1900 times)
Gordon260871
Newbie
Posts: 13
Total points formula
«
on:
October 01, 2012, 12:18:22 PM »
Hi could anybody tell me the formula for the below i want give the same points available every week even though the number of players will be different
1st 20 points
2nd 15 points
3rd 12 points
4th 10 points
5th 8 points
6th 7 points
7th 7 points
8th 5 points
we also give 3 points for playing and 1 point for hits
my league points all work just want to show the points on layout during the game for the players that have gone out or at the end of game
Thanks for any help you could give
Logged
Gordon260871
Newbie
Posts: 13
Re: Total points formula
«
Reply #1 on:
October 01, 2012, 12:19:42 PM »
sorry but 7th should read 6 points
Thanks for any help
Logged
Corey Cooper
Administrator
Hero Member
Posts: 6220
Re: Total points formula
«
Reply #2 on:
October 01, 2012, 09:27:29 PM »
switch(r, 1, 20, 2, 15, 3, 12, 4, 10, 5, 8, 6, 7, 7, 6, 8, 5) + 3 + nh
Logged
Gordon260871
Newbie
Posts: 13
Re: Total points formula
«
Reply #3 on:
October 02, 2012, 04:22:27 AM »
Hi Corey i am using this formula on the template that Stuart Murray made with the Forth road Bridge on it the formula works except it does not add on the points for a hit
I entered the formula into the points for playing on the game page and have added 1 point in the hits box
Thanks
Logged
Corey Cooper
Administrator
Hero Member
Posts: 6220
Re: Total points formula
«
Reply #4 on:
October 02, 2012, 06:24:07 PM »
The formula above should add 1 point for each hit. That's the "+ nh" part (nh is a formula variable meaning "number of hits"). You don't need to enter anything in the "Points for hit" box on the Game tab. If you do, the formula AND the "Points for hit" setting will both add 1 point for each hit, meaning each player will get 2 points for each hit.
Logged
Gordon260871
Newbie
Posts: 13
Re: Total points formula
«
Reply #5 on:
October 03, 2012, 05:04:40 AM »
Hi Corey this is what i get when i enter the formula it adds the point for Rank and for Playing but still not for any hits
Sorry i am new to this but does it not need to know how many points for each hit to give
I have attached a copy of main screen and the game screen
I may be missing something very simple
Thanks
Logged
Corey Cooper
Administrator
Hero Member
Posts: 6220
Re: Total points formula
«
Reply #6 on:
October 03, 2012, 09:53:23 AM »
As I said in the previous post, if you've got a "1" in the "Points for hit" box (which you do), and use the formula I gave which has the "+ nh" part (which you are), then you will be giving double (2) points for each hit. Set "Points for hit" to "0" or remove the "+ nh" from the Points for Playing formula.
How do you know it is not awarding points for hits? (You didn't include a screenshot of the Players tab showing ranks and points for each player, so I can't tell.) When you bust players out of the tournament, are you specifying a hitman? If you don't, then obviously "hits" cannot be computed and thus no points for hits will be awarded.
Logged
Gordon260871
Newbie
Posts: 13
Re: Total points formula
«
Reply #7 on:
October 03, 2012, 12:16:00 PM »
Hi Corey i have made the changes you said the points add up correctly at the end it is just that i would like to be able to see them added on to the total on the main screen would i have to change the cell contents
i Have added a screen shot of what it is at the moment
Thanks
Logged
Print
Pages: [
1
]
« previous
next »
The Tournament Director Forums
»
Main
»
Help Me
»
Total points formula