Author Topic: Formula Help  (Read 7983 times)

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Formula Help
« on: December 21, 2007, 11:30:03 AM »
Hi, I'm trying to work out a new points structure for our league and I wondered if this was possible to do

Quote
Average points doubled, must play 7 games or more to qualify, 0.5 points added every time you play

current point system is

Code: [Select]
switch(r, 1, n,
  2, if(n >= 4, n-2*r, 0),
  3, if(n >= 6, n-2*r, 0),
  4, if(n >= 8, n-2*r, 0),
  5, if(n >= 10, n-2*r, 0),
  6, if(n >= 12, n-2*r, 0),
  7, if(n >= 14, n-2*r, 0),
  8, if(n >= 16, n-2*r, 0),
  9, if(n >= 18, n-2*r, 0),
  10, if(n >= 20, n-2*r, 0))

(so is based on number of players)

Would it be possible to do this, I have been thinking about it for a while and without writing it out by hand Im not sure how to acheive it

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #1 on: December 21, 2007, 11:35:38 AM »
just figured prob have to do this by overall score function?

tandemrx

  • Sr. Member
  • ****
  • Posts: 347
    • View Profile
Re: Formula Help
« Reply #2 on: December 21, 2007, 12:12:07 PM »
Yes,

In the stats filter tab put "points" in the tournament scoring and I think:

if(n >= 7, average(scores) + 0.5*n, 0)

will work for an overall score.

That is assuming you want to add the half-point after they have been averaged (?)

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #3 on: December 26, 2007, 12:13:58 PM »
yeah the half point is to be added after they are averaged....

is TD able to sort out a decent way for Hits... in that we are planning on awarding £5 every time someone knocked out someone, but no points, can TD keep this registered?

MattBurlew

  • Jr. Member
  • **
  • Posts: 78
    • View Profile
Re: Formula Help
« Reply #4 on: December 26, 2007, 05:00:45 PM »
yeah the half point is to be added after they are averaged....

is TD able to sort out a decent way for Hits... in that we are planning on awarding £5 every time someone knocked out someone, but no points, can TD keep this registered?

Have you tried bounty chips?

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #5 on: January 07, 2008, 03:39:09 AM »
bounty chips?

tandemrx

  • Sr. Member
  • ****
  • Posts: 347
    • View Profile
Re: Formula Help
« Reply #6 on: January 07, 2008, 08:29:33 AM »
check out section 8.1.1 of the help tab that describes bounties.

Bounties are simply a fee paid to a person who knocks out another player (so for each hit you would give somebody 5pnds and that is considered a bounty).  Or you can assign a bounty for a specific person (say the previous tourney winner).

Some people give each player a bounty chip .. . a non tourney chip that simply represents the bounty amount and the person who knocks out a player gets their bounty chip (sometimes I use bounty bracelets, those silicone bracelets like the Livestrong bracelet instead of a bounty chip).

the help section above descrives how to include a bounty in your tourney structure

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #7 on: January 22, 2008, 09:22:55 AM »
Just noticed the formula works on scores not points... if i change the word to points will it recognise it as all i get at the moment is Formula Error

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula Help
« Reply #8 on: January 22, 2008, 10:54:41 AM »
Ignore it.  It's a bug in 2.4.3 that the "points" variable isn't recognized, but it's only in the dialog.  It will still work in the formula itself.

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #9 on: January 23, 2008, 12:47:20 PM »
Cheer's Corey... loving the system by the way =) does make everything look more professional and sleek and alot easier to run...

next step Layouts and learning them!

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #10 on: January 23, 2008, 02:11:37 PM »
jsut trying the formula (we have played one game) with 1 instead of 7 games, and it gives the error which I ignoredbut then all the Overall scores show as 0 even people with points

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula Help
« Reply #11 on: January 24, 2008, 04:48:21 PM »
Not sure what to tell you.  I just tried this with version 2.4.3 and it works just fine.  If your Overall Score formula is as you posted earlier:

if(n >= 7, average(scores) + 0.5*n, 0)

... then that will give 0 points to everyone unless there are at least 7 tournaments being filtered.

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #12 on: January 24, 2008, 07:41:25 PM »
i changed it to five so will wait until five games have been played to tell you cheers for the help

Morphius

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: Formula Help
« Reply #13 on: February 06, 2008, 01:16:38 PM »

if(n >= 5, average(points) + 0.5*n, 0)

doesn't seem to give anything but zero even after 5 games =/

tandemrx

  • Sr. Member
  • ****
  • Posts: 347
    • View Profile
Re: Formula Help
« Reply #14 on: February 06, 2008, 01:24:34 PM »
I think, but am not sure that you need to use "scores" rather than "points"