Author Topic: point formula help  (Read 1174 times)

rtp756

  • Newbie
  • *
  • Posts: 3
    • View Profile
point formula help
« on: January 06, 2011, 07:40:37 PM »
I'm starting a league for 2011. I've been working on a formula for a while. I've got the buy-in points and hit points all set. Here's my dilemma. We will have between 20-25 players each month with 18 full time league players. I want to give points for ranking but only to the league players. I would like the highest league player to get 18 points, the next 17 etc until the lowest league player gets 1 point. Everything I've done so far still gives points to the non-league players for ranking.

Please post a formula that will help and let me know what other settings I must enter as well.

Thanks

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: point formula help
« Reply #1 on: January 06, 2011, 08:00:08 PM »
if(inLeague, max(0, 18 - r), 0)

rtp756

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: point formula help
« Reply #2 on: January 06, 2011, 08:07:11 PM »
Thanks for the quick reply.
I tried the formula and here's what's happening.

When a non-league player places 1st and 2nd in the tourney, and the highest league player finishes 3rd, the league player is only getting 16 points, instead of 18.

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: point formula help
« Reply #3 on: January 06, 2011, 09:18:30 PM »
might need to manually adjust, which i know would be a pain... Not sure if it'll be able to auto adjust with anything...
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!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: point formula help
« Reply #4 on: January 06, 2011, 09:25:01 PM »
Sorry about that.  Here's the correct formula:

if(inLeague, max(0, 18 - leagueRank), 0)

rtp756

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: point formula help
« Reply #5 on: January 06, 2011, 09:49:01 PM »
works great..thanks for your input.

We really like the software and our friends think it great too!