Author Topic: Another points calculation needed.  (Read 2268 times)

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Another points calculation needed.
« on: July 19, 2010, 09:27:50 AM »
I am trying to setup a league, and need the points to be as follows

For every person playing, there will be 200 points in the pot.

These will be distrubuted as follows

1. 30%
2. 20%
3. 13%
4 10%
5. 9%
6. 7%
7. 6%
8. 5%
Players positioned 9 onwards to recieve 80 points each.

Any help appreciated.. .Thanks in advance :)

I am thinking its something like this...

  if(r = 1, (n * 200) *.30),
  if(r = 2, (n * 200) *.20),
  if(r = 3, (n * 200) *.13),
  if(r = 4, (n * 200) *.10),
  if(r = 5, (n * 200) *.09),
  if(r = 6, (n * 200) *.07),
  if(r = 7, (n * 200) *.06),
  if(r = 8, (n * 200) *.05),
  if(r > 8, (1 * 80))

But this only assigns 80 points to the places 9 onwards.

It seems to ignore the 1st 8 places :-s
« Last Edit: July 19, 2010, 10:12:37 AM by MerseyRay »

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Another points calculation needed.
« Reply #1 on: July 19, 2010, 10:12:03 AM »
I am trying to setup a league, and need the points to be as follows

For every person playing, there will be 200 points in the pot.

These will be distrubuted as follows

1. 30%
2. 20%
3. 13%
4 10%
5. 9%
6. 7%
7. 6%
8. 5%
Players positioned 9 onwards to recieve 80 points each.

Any help appreciated.. .Thanks in advance :)

5% of 200 = 10, so my question is do you mean that 9th on get 8 points?
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #2 on: July 19, 2010, 10:21:33 AM »
Yes, only the 1st 8 positions share the points pot.
All players finishing 9th and onwards just recieve 80 points.

As you see, I am using the variable "r".
Is that the rank in this one game, or the whole tournament ?

Thanks

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Another points calculation needed.
« Reply #3 on: July 19, 2010, 10:23:34 AM »
The "r" variable, if you have it stored in the formula on the Game tab, would only be for that one tournament.  Based upon your points distribution, though, I would almost want to finish 9th, and get 80 points, versus only 10 for finishing 8th.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #4 on: July 19, 2010, 10:31:54 AM »
I have that formula in the "Points for playing" window on the games tab, is that where you are meaning ?

No, the points is 200 per person, so with only 10 people playing, that would make 2000 points shared for the top 8 places.

If I change that "Points for playing" window to only:

if( r = 1, (n * 200) *.30)

Then it does calculate position 1 correclty, but as soon as I add the 2nd line and change it to :

if( r = 1, (n * 200) *.30),
if( r = 2, (n * 200) *.20)

Then it only calculates position 2 (correctly) and gives no points to position 1.

Thanks

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Another points calculation needed.
« Reply #5 on: July 19, 2010, 10:46:13 AM »
Ah, gotcha.  Sorry for the misunderstanding! I know you're going to want a switch in there somehow... i think this may work (have not tested it out yet)

switch(r, 1, (n*200*.3), 2, (n*200*.2), 3, (n*200*.13), 4, (n*200*.1), 5, (n*200*.09), 6, (n*200*.07) 7, (n*200*.06) 8, (n*200*.05)

I think ending it with " 8, (n*200*.05), 80" would allow for everyone else ranked 9th or worse to get the 80 that you're looking for.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #6 on: July 19, 2010, 10:54:24 AM »
Ah I dont know about switches.. Its the 1st time ive used this.

That formula give a "Formula has an error"

Ive tried an extra bracket at the end too, coz it looks like one is missing, but still getting the error.

Thanks

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #7 on: July 19, 2010, 10:59:51 AM »
ahh I just found this on another thread....

assign("v", n * 50)
switch(r, 1, v * .3, 2, v * .2, 3, v * .12, 4, v * .08, 5, v * .07, 6, v * .06, 7, v * .05, 8, v * .04, if(r < 17, v * .01, 0))

this is very similar to what im after, ill try tweaking this and see if that solves it.

Thanks for helping.

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #8 on: July 19, 2010, 11:02:51 AM »
Yes Ive sorted it now...
This is what I ended up with

assign("v", n * 200)
switch(r, 1, v * .3, 2, v * .2, 3, v * .13, 4, v * .10, 5, v * .09, 6, v * .07, 7, v * .06, 8, v * .05, if(r > 8, 80, 0))

Many thanks for all your help. It was the point to the switch I think I needed   ;D

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Another points calculation needed.
« Reply #9 on: July 19, 2010, 11:06:17 AM »
You're welcome! Glad to have been able to assist you. That should work perfectly for you, including how you modified my (thought to be correct) ending. If it doesn't work, post back on here and we'll get something figured out for you.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

MerseyRay

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Another points calculation needed.
« Reply #10 on: July 19, 2010, 11:14:03 AM »
Do I need to enter any formula in the "Prizes" tab too ? I tried to but it just changes it to a number.

I have entered that formula in the "Game tab" "Points for playing" windows, and when I test it, it seems to be 100% correct.

So I just tried a quick test game with 14 people, then in the prizes tab, It gives the correct money to winners, but no points  ???

Thanks

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Another points calculation needed.
« Reply #11 on: July 19, 2010, 11:29:46 AM »
If you have a cash payout, then yes, use the Prizes to distribute. If you enter the formula in both places, you'll award double points to everyone.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!