Author Topic: League Points System - Help  (Read 307 times)

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
League Points System - Help
« on: February 11, 2019, 06:06:20 PM »
Good Day,

I am going to be starting a Poker League

  • It will run for 15 Weeks
  • Max 18 Players

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.

  • Based on where you rank out of at you get X points
  • And then depending on how many people played in the tournament there is a multiplier

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

Is there a way to duplicate this in TD?

Thanks in advance
« Last Edit: February 11, 2019, 06:10:54 PM by SVTF »

efdenny

  • Full Member
  • ***
  • Posts: 141
    • View Profile
Re: League Points System - Help
« Reply #1 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 ))
« Last Edit: February 11, 2019, 07:34:07 PM by efdenny »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5708
    • View Profile
Re: League Points System - Help
« Reply #2 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)

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #3 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

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5708
    • View Profile
Re: League Points System - Help
« Reply #4 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.

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #5 on: February 12, 2019, 07:42:58 PM »
Thanks will run through a few games in a mock league to test it tomorrow.

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #6 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?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5708
    • View Profile
Re: League Points System - Help
« Reply #7 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.

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #8 on: February 13, 2019, 04:10:31 PM »
Awesome... Will give that a try.

Thanks

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #9 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.
« Last Edit: February 13, 2019, 08:09:05 PM by SVTF »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5708
    • View Profile
Re: League Points System - Help
« Reply #10 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 ... :-)

SVTF

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: League Points System - Help
« Reply #11 on: February 14, 2019, 11:22:20 AM »
BINGO - Thanks Corey!!