Author Topic: Entering Point values as prizes  (Read 781 times)

JBjr

  • Newbie
  • *
  • Posts: 12
    • View Profile
Entering Point values as prizes
« on: February 02, 2014, 01:25:43 AM »
Hey all, I'm taking over a bar league and they already have a set point system in place that I don't want to mess with.  I'd prefer to use my own formula but don't want to step on any toes and piss anyone off.  I want to enter them in the 'prizes' tab but as rankings get lower the point value is the same.  Example, 20-30th get 500 points, 31st-40th get 300, etc.  Is there a way of entering 20th-30th in the rank field of the prizes tab to give each of those players that point value or do i have to enter every individual rank, 30, 31, 32.......  Seems like I should be able to enter 21;30 and have it set that point value for all of those ranks? 

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5380
    • View Profile
Re: Entering Point values as prizes
« Reply #1 on: February 02, 2014, 01:31:13 AM »
You should use the Points for Playing formula to accomplish this.  What's the points distribution?

JBjr

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Entering Point values as prizes
« Reply #2 on: February 03, 2014, 06:47:08 PM »
I'm not sure of all the values and am still waiting for the info from the bar owner. 
Let's just say for example it's as follows
1-2500
2-2000
3-1600
4-1300
5-1100
6-1000
7-900
8-800
9-15-700
16-20-600
21-30=500
31-40=400
41-50=300

what would the formula look like for that? Thanks for the help Cory

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5380
    • View Profile
Re: Entering Point values as prizes
« Reply #3 on: February 03, 2014, 09:11:20 PM »
switch(r, 1, 2500, 2, 2000, 3, 1600, 4, 1300, 5, 1100, 6, 1000, 7, 900, 8, 800) + if(r > 8 and r < 16, 700) + if(r > 15 and r < 21, 600) + if(r > 20 and r < 31, 500) + if(r > 30 and r < 41, 400) + if(r > 40 and r < 51, 300)

JBjr

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Entering Point values as prizes
« Reply #4 on: February 04, 2014, 08:38:54 AM »
Awesome! Thanks Cory.