Author Topic: Points formula, use of Ln()  (Read 892 times)

mcfrojd

  • Full Member
  • ***
  • Posts: 136
    • View Profile
Points formula, use of Ln()
« on: November 01, 2019, 06:40:16 AM »
Hi there.
I would like to use a formula that our Swedish online casino (Svenska Spel) is using for a POY ranking.

The formula looks like this.


And works like this when i put it into google sheets.


Is it possible to get this result into TD?

I cant find if the "Ln()" option works in TD?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6220
    • View Profile
Re: Points formula, use of Ln()
« Reply #1 on: November 01, 2019, 07:00:51 AM »
In the TD, log() is the natural logarithm function.  From the cheatsheet:

Quote
The natural logarithm of a number. If a single parameter is provided, then base E is assumed. If a second parameter is provided, it will be used as the base.

mcfrojd

  • Full Member
  • ***
  • Posts: 136
    • View Profile
Re: Points formula, use of Ln()
« Reply #2 on: November 01, 2019, 09:45:50 AM »
Thanx Corey, worked it out with your help.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6220
    • View Profile
Re: Points formula, use of Ln()
« Reply #3 on: November 01, 2019, 11:13:31 AM »
I added the function ln() as an alias to log() for the next version.