Author Topic: help with league points  (Read 812 times)

badbeat feva

  • Newbie
  • *
  • Posts: 6
    • View Profile
help with league points
« on: January 25, 2009, 12:49:44 PM »
Hi everyone..i am a newbie and need some help please....my tourney that I host is a fun league, it goes every Monday for 12 weeks with top 2 going to final table on 13th week, prizes are donated by the pub we are playing at. No need to track points in this format, however I want to start a member buy in, where as anyone wishing to buy in at beginning of season will get extra prizes at the end of 12 weeks. In this format I need to track the points for members only as only members can win these extras. Members and non members will be playing along with each other and I wanted to use this formula for points :

if(r < 41, 25, 0) + if(r < 31, 25, 0) + if(r < 20, 50, 0) + if(r < 13, 50, 0) + if(r < 7, 50, 0) + if(r < 6, 50, 0) + if(r < 5, 50, 0) + if(r = 3, 100, 0) + if(r = 2, 250, 0) + if(r = 1, 450, 0)

so if a paying member placed 4th, and 1 2 3 were non members, 1 and 2 would go to final table on 13th week, 3rd gets nothing and I need that 4th placed member to get the 750 points for first and the 2nd placed member (finishing say 6th) to get the 2nd place points and so on...does this make sense and is it possible? Ive been playing with the inLeague variable but am stumped....Thanks in advance for any help.....Mike