Author Topic: Another request for points formula  (Read 1622 times)

Rickochez

  • Newbie
  • *
  • Posts: 3
    • View Profile
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

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
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.
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
    • View Profile
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

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
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...
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
    • View Profile
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)

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
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)
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
    • View Profile
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.