Author Topic: Formula Please  (Read 2117 times)

thegooser

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Formula Please
« on: December 22, 2008, 05:32:17 AM »
Hi all. Any chance of the formula for the following please?

First gets 10 points, second gets 9..... down to 9th getting 2 points (nothing for 10th) + 1 point per hit.

1st = 10
2nd = 9
3rd = 8
4th = 7
5th = 6
6th = 5
7th = 4
8th = 3
9th = 2
10th = 0

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formula Please
« Reply #1 on: December 22, 2008, 06:44:22 AM »
IF(r > 10,(n - r + 1), 0) + nh

thegooser

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Formula Please
« Reply #2 on: December 23, 2008, 05:09:25 AM »
Thank you Phaze...

and merry christmas!

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formula Please
« Reply #3 on: December 23, 2008, 06:15:34 AM »
And to you and your family too ;D

thegooser

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Formula Please
« Reply #4 on: December 23, 2008, 08:17:59 AM »
Can you just double check that code please mate.

I did a test tournament and it came out wrong. And i used the test formula function and it came out wrong too.

thegooser

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Formula Please
« Reply #5 on: December 23, 2008, 08:38:38 AM »
Ok I think I've got it.

if(rank<=9,11-rank,0)+(nh)

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formula Please
« Reply #6 on: December 23, 2008, 08:15:26 PM »
Ahhh yeah... lemme check.......... my post at 6:44 AM... must still been on my first cupa coffee... apologies

badbeat

  • Full Member
  • ***
  • Posts: 114
    • View Profile
Re: Formula Please
« Reply #7 on: December 24, 2008, 03:54:46 AM »
IF(r < 10,(n - r + 1), 0) + nh

I'd looked at Phaze's formula and at 1st glance it looked ok and as he's normally pretty consistant with his formulas, never checked it. My formula was slightly different and not quite so compact, (n-r+1)+nh+IF(r=10,-1) so didn't bother posting it.