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
»
Another request for points formula
« previous
next »
Print
Pages: [
1
]
Author
Topic: Another request for points formula (Read 1622 times)
Rickochez
Newbie
Posts: 3
Another request for points formula
«
on:
October 08, 2010, 03:20:44 PM »
I have been looking all through the forum for an answer to this and will continue looking after this is posted to try and figure this out on my own.
Our season consists of 15 nights
2 games per night
Standard n - r +1 scoring for all games
Lowest two nights get tossed out
somehow I need to add both games from each night and then sum(top(15, scores))
We start our season tonight and this is the last piece of the puzzle (I THINK)
Thanks in advance for anybody who can assist me on this
Rick
Logged
Magic_fubu
Hero Member
Posts: 1035
Re: Another request for points formula
«
Reply #1 on:
October 08, 2010, 04:33:11 PM »
Two games a night = 30 games in the season. for each tournament, you'll want the n-r+1 formula. Create a season, name it whatever you want. You want lowest two nights (meaning 4 tournaments, not necessarily lowest four games), or lowest two tournaments? if only lowest two tournaments, then you'd want sum(top(28, scores)). If you're looking for the lowest two
nights,
, I'm pretty sure that would require something more along the lines of tracking players on an excel sheet or something of the like, and figuring it out that way, as I don't believe that TD can distinguish between nights, only tournaments.
Logged
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!
Rickochez
Newbie
Posts: 3
Re: Another request for points formula
«
Reply #2 on:
October 08, 2010, 04:40:59 PM »
You are 100% correct.
The bottom 2 nights of 15 to be dropped (not bottom 4 tournaments)
Thanks for your help though - I appreciate it
Logged
Magic_fubu
Hero Member
Posts: 1035
Re: Another request for points formula
«
Reply #3 on:
October 08, 2010, 05:29:45 PM »
Another Idea would be to somehow get both tournaments into one. Manually configure prizes to be the combined total of both tournaments, then you could do the sum(top(13, scores)) for the overall scoring, but that wouldn't be 100% practical for the situation, unless other users have ideas that I am missing...
Logged
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!
Rickochez
Newbie
Posts: 3
Re: Another request for points formula
«
Reply #4 on:
October 09, 2010, 03:00:05 PM »
I'm Thinking something along the lines of
T=Tournamnet
Sum(Top(13,(T1+T2),(T3+T4),(T5+T6),(T7+T8),(T9+T10),(T11+T12),(T13+T14),(T15+T16),(T17+T18),(T19+T20),(T21+T22),(T23+T24),(T25+T26),(T27+T28),(T29+T30)
Logged
Magic_fubu
Hero Member
Posts: 1035
Re: Another request for points formula
«
Reply #5 on:
October 09, 2010, 09:21:59 PM »
that would work, on the condition that TD is able to filter that way. Corey, is it possible? (he would be the authority on that)
Logged
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!
Corey Cooper
Administrator
Hero Member
Posts: 6220
Re: Another request for points formula
«
Reply #6 on:
October 09, 2010, 09:40:05 PM »
IIt looks like you are wanting to group each night's 2 tournaments into one, and then dropped the lowest combined score. The filter has no way to group the tournaments in this way.
Logged
Print
Pages: [
1
]
« previous
next »
The Tournament Director Forums
»
Main
»
Help Me
»
Another request for points formula