Author Topic: Formula Assistance  (Read 1151 times)

ctucker

  • Newbie
  • *
  • Posts: 2
    • View Profile
Formula Assistance
« on: April 03, 2007, 05:35:47 PM »
I am a new user of the software and really like it. We have a 20 to 35 man tourney each week and I am struggling with making a point system formula we used before the software was used. Any assistance or guidance anyone could give would be greatly appreciated. Thanks.


50 points for attending
1pt for each dollar won in the tourney
if 23 players or less we award additional points of 1-200pts, 2-150pts, 3-125pts, 4-100pts, 5-75pts, 6-50pts
if 24 players or more we award additional points of 1-350pts, 2-300pts, 3-250pts, 4-200pts, 5-150pts, 6-125pts, 7-100pts, 8-75pts, 9-50pts

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formula Assistance
« Reply #1 on: April 04, 2007, 06:28:25 AM »
50 + tw + if (n<24, if (r==1,200, if(r==2,150, if(r==3,125, if(r==4,100, if(r==5,75, if(r==6,50)))))), if(r==1,350,if (r==2,300,if (r==3,250,if (r==4,200,if (r==5,150,if (r==6,125,if (r==7,100,if (r==8,75,if (r=9,50))))))))))

This formula looks like it works to do all that you asked
« Last Edit: April 04, 2007, 06:34:20 AM by Phaze »

ctucker

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Formula Assistance
« Reply #2 on: April 04, 2007, 01:11:22 PM »
Thanks alot, I think i see where i was messing up after looking at your formula. I will give it a try tonight. Thank you for you assistance.