The Tournament Director Forums

Main => Help Me => Topic started by: SVTF on February 11, 2019, 06:06:20 PM

Title: League Points System - Help
Post by: SVTF on February 11, 2019, 06:06:20 PM
Good Day,

I am going to be starting a Poker League


I have a formula already to go but it is in excel.

I wonder if there is away to write the same formula to work within TD so I don't plug all the info into excel after each game.

I have a attached a picture to give an example of the formula I want to use.


So Rank Points * Players Multiplier = Points Earned for that Game

Is there a way to duplicate this in TD?

Thanks in advance
Title: Re: League Points System - Help
Post by: efdenny on February 11, 2019, 07:30:20 PM
Well, Corey probably has a better way, but here's my brute force method:

switch(r,1,15,2,12,3,10,4,8,5,7,6,6,7,5,8,4,9,3,10,2,11,2,12,2,13,2,1) * (if(n <= 5,0.5) + if(n = 6,0.6) + if(n = 7,0.7) + if( n = 8,0.8 ) + if(n = 9,0.9) + if(n = 10,1.1) + if(n = 11,1.1) + if(n = 12,1.3) + if(n = 13,1.3) + if(n = 14,1.5) + if(n = 15,1.5) + if(n >= 16,1.8 ))
Title: Re: League Points System - Help
Post by: Corey Cooper on February 12, 2019, 12:01:31 PM
Not better necessarily, but you could use a switch for the second part:

if(n <= 5, 0.5, switch(n, 6, 0.6, 7, 0.7, 8, 0.8, 9, 0.9, 10, 1.1, 11, 1.1, 12, 1.3, 13, 1.3, 14, 1.5, 15, 1.5, 16, 1.8, 17, 1.8, 18, 1.8 ))

Making the whole formula:

switch(r,1,15,2,12,3,10,4,8,5,7,6,6,7,5,8,4,9,3,10,2,11,2,12,2,13,2,1) * if(n <= 5, 0.5, switch(n, 6, 0.6, 7, 0.7, 8, 0.8, 9, 0.9, 10, 1.1, 11, 1.1, 12, 1.3, 13, 1.3, 14, 1.5, 15, 1.5, 16, 1.8, 17, 1.8, 18, 1.8 ))

Functionally these are the same, so it doesn't matter which you use.

When I finally get back to feature enhancements, I plan to add a tool to create a formula from a table.  It's really simple and will make creating formulas from pre-defined values a lot easier.

I'm also adding the function lswitch right now, for linear switch.  Since most of the uses of the switch() function involve linear lists of values, it can be simplified by not specifying the index.  For example:

switch(rank, 1, 20, 2, 17, 3, 12, 4, 6, 5, 4, 3, 2, 2, 1, 0)

would become

lswitch(rank, 20, 17, 12, 6, 4, 2, 1, 0)
Title: Re: League Points System - Help
Post by: SVTF on February 12, 2019, 06:09:47 PM
Thank You to both of you will give the above a try.

 So this may be a dumb question...

Do I simply copy and paste the above into the formula box and it just works?

Anything extra I need to do?

#NewbieHere
Title: Re: League Points System - Help
Post by: Corey Cooper on February 12, 2019, 06:20:36 PM
Like they say, the only dumb question is the one you didn't ask.

Yes, you simply copy and paste the equation into the "Points for Playing" formula on the Game tab.

switch(r,1,15,2,12,3,10,4,8,5,7,6,6,7,5,8,4,9,3,10,2,11,2,12,2,13,2,1) * (if(n <= 5,0.5) + if(n = 6,0.6) + if(n = 7,0.7) + if( n = 8,0.8 ) + if(n = 9,0.9) + if(n = 10,1.1) + if(n = 11,1.1) + if(n = 12,1.3) + if(n = 13,1.3) + if(n = 14,1.5) + if(n = 15,1.5) + if(n >= 16,1.8 ))

The Points column on the Players tab will be populated with values one players bust out of the tournament.
Title: Re: League Points System - Help
Post by: SVTF on February 12, 2019, 07:42:58 PM
Thanks will run through a few games in a mock league to test it tomorrow.
Title: Re: League Points System - Help
Post by: SVTF on February 13, 2019, 03:02:51 PM
Worked like a charm - Thank You.

Question is it possible to add to the formula?

So that when you run the stats the SUM value is the sum of points for the best 9 finishes only vs the total sum of all points per player?
Title: Re: League Points System - Help
Post by: Corey Cooper on February 13, 2019, 03:51:31 PM
Yep.  On the Stats tab, press the "Edit Profiles" button.  Press the New button to create a new Profile.  Near the bottom click the Edit button next to "Create Overall Scores using formulas".  Change the formula to:

sum(top(9, points))

When you "Refresh Stats", make sure to select your new profile.  The sum of the top 9 points for each player will be in the "Overall Score" column.

If you want, you can rename columns by pressing the Preferences button.
Title: Re: League Points System - Help
Post by: SVTF on February 13, 2019, 04:10:31 PM
Awesome... Will give that a try.

Thanks
Title: Re: League Points System - Help
Post by: SVTF on February 13, 2019, 07:55:10 PM
Sorry to bother you.... Used the above formula as suggested.

However the total I am getting under overall score is the same as points.

Thoughts?  I am likely  doing something wrong.
Title: Re: League Points System - Help
Post by: Corey Cooper on February 13, 2019, 11:42:12 PM
You're not doing anything wrong.  I told you wrong.  Try this:

sum(top(9, listpoints))

If that doesn't work, I swear I'll actually try it out myself ... :-)
Title: Re: League Points System - Help
Post by: SVTF on February 14, 2019, 11:22:20 AM
BINGO - Thanks Corey!!