Messages

1

Help Me / Re: Filtering Unqualified League Points

« on: March 30, 2019, 10:45:37 AM »

Thanks Corey!

That's disappointing but understandable. Logically, it would seem that the array was built as the tournaments are imported (as either a stack or queue) based on the order in which they are imported. I don't have that many players to track, so it won't be hard to manually track their scores.

As a final thought, is there anyway to display the array (and the order of values) returned by the "listPoints" variable? In theory, I could reorder the files being called (by changing the file names) and affect the order of the array. I could then determine that logic to figure out which array value(s) should be used to calculate my scores.

Thanks again!
Rainier

2

Help Me / Re: Filtering Unqualified League Points

« on: March 28, 2019, 04:22:52 PM »

Thanks for the response, Corey. Unfortunately, many of the players that joined the league after the first tournament have extensive history with the league. By making duplicate copies of them in the database (for pre- and post-entry to the league) I would disassociate their history.

Is there a way to generate a list of string of values for the tournaments played (i.e if three games have been played return [12,8,14]) and then eliminate the first "x" number of values based on when the player joined? I could assign an unused field in the player's database profile (like the zip code) to the first qualified tournament that should be calculated. The resulting formula for LC Qualified Points would look something like:

if (zip>1, sum(last "x" number of tournaments from that string), sum(top(numberOfTournaments-1,listpoints)))

If something like that is possible, can you help me with the formula? I'm not seeing those tokens listed in the cheat sheet.

Thanks again for the help!
Rainier

3

General Discussion / Re: Creating a league

« on: March 28, 2019, 08:53:54 AM »

Hi Janpan,

You can keep a copy of your completed tournaments in a separate location. I've run a league for seven years and organize it like this:

Main League Folder
     Season # Folder
          Tournament 1 Folder
               Tournament 1.tdf
               Additional files (sign-in sheet, post-tournament results, etc.)
          Tournament 2, 3, 4 (etc.) Folder
          Completed Tournaments
               Tournament 1-Complete.tdf
               Tournament 2-Complete.tdf
               etc.

After each game, save a copy of the tournament into the "Completed Tournaments" folder. When you run your league stats, you can point it at this folder and maintain the integrity of the rest of your season.

Hope this helps,
Rainier

4

Help Me / Filtering Unqualified League Points

« on: March 27, 2019, 08:59:36 AM »

Hi Community,

I run a 20+ player league that holds five regular season games and a League Championship (LC) after the regular season. I'm having an issue automatically eliminating players' unqualified tournament scores.

League Synopsis
Players are awarded points based on their performance during each regular season game (first out - 1 point, second - 2 points, etc.) A players's best four scores are used to determine their league rank. To qualify for the LC, a player must finish in the top 14 of the regular season.

Current Formulas
I am using the following formula to calculate LC Qualified points:
sum(top(numberOfTournaments-1,listpoints))
The following is being used for showing the lowest score to be dropped:
if(numberOfTournaments>buyins,0,bottom(1,listpoints))

The Problem
I have a few players that participated in tournaments prior to joining the league. The scores for these games should not be used to calculate their LC Qualified points. Is there any way to set a variable for the first tournament eligible for calculation and then use that variable to tell TD not use unqualified scores? Or is there a different way (other than manually) of eliminating the first "x" number of scores for specific players?

Thanks for your help,
Rainier