Author Topic: Help with Tournament/League formula  (Read 878 times)

sirdon

  • Newbie
  • *
  • Posts: 3
    • View Profile
Help with Tournament/League formula
« on: May 11, 2010, 11:55:09 AM »
Hi all,

Just want to say i used this program for the first time last and it was great. Everyone really appreciated it.

I am still struggling with the formula side of things.

I am trying to organise a 12 week tournament. Points are added to the player each week to give him/her an overall score.

In the Overall Score column i don't seem to be able to calculate the points scored for that player...it just seems to add up how many players were in the tournament and that's it.

This is what i am trying to set up:

I want to allocate 5 points for buying in (i did this in the 'game' tab under 'general')

I want to allocate 1 point for a re-buy (i did this in the 'game' tab under 'rebuys')

I want to allocate 1 point for add-ons (i did this in the 'game' tab under 'add-ons')

In the 'games' tab under 'points for playing' i have my formula as nr+na+n

In the 'prizes' tab i have awarded points for placing in the tournament.

1st = 100
2nd = 75
3rd = 50
4th = 40
5th = 35
6th = 30
7th = 25
8th = 20
9th = 15
10th = 15
11th = 10
12th = 10
13th = 5
14th = 5
15th = 5
16th = 5
17th = 2
18th = 2
19th = 2
20th = 2
21st = 1
22nd = 1
23rd = 1
24th = 1
25 and onwards = 0

Then in the 'stats' tab under 'filter', under 'tournament scoring' i have the formula nr+na+n

Then in the 'stats' tab under 'filter', under 'overall scoring' i have the formula sum(scores)

Am i doing this all wrong.

I would appreciate any help given.

Thanks in advance

Sirdon
« Last Edit: May 12, 2010, 10:27:22 AM by sirdon »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5594
    • View Profile
Re: Help with Tournament/League formula
« Reply #1 on: May 12, 2010, 12:00:04 PM »
I want to allocate 5 points for buying in (i did this in the 'game' tab under 'general')

I want to allocate 1 point for a re-buy (i did this in the 'game' tab under 'rebuys')

I want to allocate 1 point for add-ons (i did this in the 'game' tab under 'add-ons')

In the 'games' tab under 'points for playing' i have my formula as nr+na+n

Based on this description, you're awarding some points twice.  The formula is awarding each player points for the number of rebuys and add-ons they've purchased, plus points for each player in the tournament.  But you're also awarding 1 point for each rebuy and for each add-on by setting 1 in the "Points for rebuy" and "Points for add-on" fields.  Think of those fields as the "Simple" setup option, while the formula is the "Advanced" setup option.  You really should use one or the other, but they all combine (are added together) to determine the points a player receives.

In the 'prizes' tab i have awarded points for placing in the tournament.

1st = 100
2nd = 75
3rd = 50
4th = 40
5th = 35
6th = 30
7th = 25
8th = 20
9th = 15
10th = 15
11th = 10
12th = 10
13th = 5
14th = 5
15th = 5
16th = 5
17th = 2
18th = 2
19th = 2
20th = 2
21st = 1
22nd = 1
23rd = 1
24th = 1
25 and onwards = 0

Whew - that sounds like it took a long time to set up.  This is actually what the formula is best for: not having to create a bunch of prizes in order to award points to players.

Then in the 'stats' tab under 'filter', under 'tournament scoring' i have the formula nr+na+n

Then in the 'stats' tab under 'filter', under 'overall scoring' i have the formula sum(scores)

This is actually mostly correct, but I would do it differently.  So let's start from the beginning.  Since you've got a pretty definitive need for a formula, let's just use the formula.  So first, clear the values in "Points for rebuy", "Points for add-on", and any other places you're awarding points.  Let's build a formula:

Five points for buying into the tournament:

5

Add 1 point for each rebuy the player purchased:

5 + nr

Add 1 point for each add-on the player purchased:

5 + nr + na

Add points for the rank the player achieved:

5 + nr + na + switch(1,100,2,75,3,50,4,40,5,35,6,30,7,25,8,20,9,15,10,15,11,10,12,10,13,5,14,5,15,5,16,5,17,2,18,2,19,2,20,2,21,1,22,1,23,1,24,1)

So that's your complete formula:

5 + nr + na + switch(1,100,2,75,3,50,4,40,5,35,6,30,7,25,8,20,9,15,10,15,11,10,12,10,13,5,14,5,15,5,16,5,17,2,18,2,19,2,20,2,21,1,22,1,23,1,24,1)

Set this in the Points for Playing field.  Remove all of those prizes that award points from the Prizes tab.

On your Filter on the Stats tab, change the Tournament Scoring formula to:

points

This just sets the player's Score value, when computing stats, to the same as the Points they received.  You could just insert the same formula as we created above, but if you then decided to change it, you'd have to change it in two places (on the Game tab and on the Stats Filter).

Your Overall Scoring formula is already correct:

sum(scores)

sirdon

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Help with Tournament/League formula
« Reply #2 on: May 13, 2010, 03:26:38 AM »
wow....i really was all over the place. I understand what you mean now.

So i placed all the formulas like you told me to and deleted the stuff like you told me to.

But i still seem to get a problem with the points and overall scores. I have attached pictures to show you what i have done.

I forgot to mention that i want to allocate 60 to 1st place, 30 to 2nd place and 10 to 3rd place.


Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5594
    • View Profile
Re: Help with Tournament/League formula
« Reply #3 on: May 13, 2010, 10:15:27 AM »
Oops, my bad.

switch(1,100,2,75,3,50,4,40,5,35,6,30,7,25,8,20,9,15,10,15,11,10,12,10,13,5,14,5,15,5,16,5,17,2,18,2,19,2,20,2,21,1,22,1,23,1,24,1)

should be:

switch(r,1,100,2,75,3,50,4,40,5,35,6,30,7,25,8,20,9,15,10,15,11,10,12,10,13,5,14,5,15,5,16,5,17,2,18,2,19,2,20,2,21,1,22,1,23,1,24,1)

Sorry.  The switch statement is a faster, simpler series of "if ... then ... else" statements.  The first parameter, "r" (which represents the player's "rank", and which I accidentally omitted) is the "test" value.  If r is 1, then the value of the switch statement is 100; if r is 2, the value is 75; if r is 3, the value is 50; etc, etc.  If r doesn't match any of the given parameters, the value will be 0.

To allocate prize money, you will create prizes on the Prizes tab.  Let me know if you need help with that.   It should be fairly straightforward.

sirdon

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Help with Tournament/League formula
« Reply #4 on: May 13, 2010, 10:27:29 AM »
bloody sensational mate...thanks heaps for that. Much appreciated. I am someone who can read codes/data, but i cant write it myself. So i understand what you have done.

Again thanks heaps.

When i do my second week i will let you know if i have any more issues.

I did the money for the prizes...i thought that was the case, but i just wanted to make sure it was done in there not the formula. So thanks for that