Author Topic: 5,10,15.....Based Formula  (Read 970 times)

BonesCO

  • Newbie
  • *
  • Posts: 1
    • View Profile
5,10,15.....Based Formula
« on: August 23, 2008, 09:39:36 AM »
Looking for a "points for playing" formula that will give 5 points to the first player out, ten to the second to go out, fifteen to the third, etc etc.  This is for a 6 month long season, and one week we may have 6 players and the next week 10.  Is there a way to have a set formula that will do this rounding by five with an unknown number of players so I wouldn't have to change it each week when we know how many players show up?  We want to keep it divisible by five because at end of the year game each player is given a chip sack corresponding to their year long points and the lowest chip is a "5".  Thanks.

badbeat

  • Full Member
  • ***
  • Posts: 114
    • View Profile
Re: 5,10,15.....Based Formula
« Reply #1 on: August 23, 2008, 10:01:17 AM »
(n+1-r)*5
Should give you what you want.

(n=number of players, r=rank)