Author Topic: formula help  (Read 1996 times)

pieman

  • Newbie
  • *
  • Posts: 2
    • View Profile
formula help
« on: May 07, 2009, 08:41:26 AM »
could someone help with this it is all new to me and i am at a loss to work out the formula for our league

we are running a 10-15 man league over the next 40 weeks and the point system we use is
1st 10 points, 2nd 7 points, 3rd 5 points, 4th 3 points 5th 2 points and everyone else gets 1 points for attending

how would you work this out

your help would be appreciated guys

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5595
    • View Profile
Re: formula help
« Reply #1 on: May 07, 2009, 10:00:54 AM »
1 + switch(r, 1, 10, 2, 7, 3, 5, 4, 3, 5, 2)

badbeat

  • Full Member
  • ***
  • Posts: 114
    • View Profile
Re: formula help
« Reply #2 on: May 07, 2009, 10:17:28 AM »
Should be

1 + switch(r, 1, 9, 2, 6, 3, 4, 4, 2, 5, 1)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5595
    • View Profile
Re: formula help
« Reply #3 on: May 07, 2009, 01:35:30 PM »
Oops, you're absolutely right.  Or:

switch(r, 1, 10, 2, 7, 3, 5, 4, 3, 5, 2, 1)

pieman

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: formula help
« Reply #4 on: May 12, 2009, 06:05:58 AM »
thanks guys you are all stars

jhisey

  • Newbie
  • *
  • Posts: 39
    • View Profile
Re: formula help
« Reply #5 on: May 15, 2009, 04:18:45 PM »
So first place when 8 people show up gets the same points as first place when 15 show up?