Author Topic: New formula help please  (Read 1947 times)

whirlers

  • Jr. Member
  • **
  • Posts: 70
    • View Profile
New formula help please
« on: March 26, 2012, 04:08:50 AM »
Hiya folks

I need a new formula that work for the points awarded below. Top 8 get the points allocated below & everyone else gets 10 points regardless.
I anyone can help
Cheers

Points are awarded: 1st = 100, 2nd = 80, 3rd = 70, 4th = 60, 5th = 50, 6th = 40, 7th = 30, 8th = 20, all others = 10.

Mahound

  • Sr. Member
  • ****
  • Posts: 395
  • THE ONLY time i get screwed is when i play poker!
    • View Profile
Re: New formula help please
« Reply #1 on: March 26, 2012, 08:25:39 AM »
 Use switch(r, 1, 100, 2, 80, 3, 70, 4, 60, 5, 50, 6, 40, 7, 30, 8, 20) in the game tab enter 10 points for playing

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: New formula help please
« Reply #2 on: March 26, 2012, 08:57:54 AM »
If the points for 1st to 8th replace the 10 for playing, then you'll want to switch the 100 to a 90, 80 to 70, etc. If they are in addition to the 10 for playing, then whirlers would have it right.
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

Mahound

  • Sr. Member
  • ****
  • Posts: 395
  • THE ONLY time i get screwed is when i play poker!
    • View Profile
Re: New formula help please
« Reply #3 on: March 26, 2012, 10:15:47 AM »
If the points for 1st to 8th replace the 10 for playing, then you'll want to switch the 100 to a 90, 80 to 70, etc. If they are in addition to the 10 for playing, then whirlers would have it right.
Yup Sorry about that, Whirlers! Magic is correct you will need to change the figure in the switch to what magic suggests

whirlers

  • Jr. Member
  • **
  • Posts: 70
    • View Profile
Re: New formula help please
« Reply #4 on: March 26, 2012, 05:11:00 PM »
Cheers for that, works a treat

whirlers

  • Jr. Member
  • **
  • Posts: 70
    • View Profile
Re: New formula help please
« Reply #5 on: April 02, 2012, 02:14:11 PM »
Sorry folks i got the points wrong on this formula.

I need the points to show 10 points per player busted & bonus points as follows


1st = 100, 2nd = 80, 3rd = 70, 4th = 60, 5th = 50, 6th = 40, 7th = 30, 8th = 20

So if we had 20 players
1st out would get 10 points
2nd out would get 20 points etc etc

Cheers

TIMMER

  • Hero Member
  • *****
  • Posts: 562
    • View Profile
Re: New formula help please
« Reply #6 on: April 02, 2012, 02:31:35 PM »
Points for hits ( Game tab, ) everything else looks the same as before,   1  ?  2nd no 90

whirlers

  • Jr. Member
  • **
  • Posts: 70
    • View Profile
Re: New formula help please
« Reply #7 on: April 03, 2012, 04:44:03 AM »
Cheers Timmer i sorted it in the end by just adapting a formula i already had a little  ;D