Author Topic: Formula Help x2 :)  (Read 3904 times)

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Formula Help x2 :)
« on: August 21, 2012, 02:54:05 PM »
I too am struggling with a formula

I want every player who enters to recieve 100 points

then the final table recieves 1000 points  x  # of players - 100 for each place for the top nine

 so if we has 25 players first place would recieve 1000 x 25 = 25000
                              second place would recieve  900  x 25 = 22500
                                third   place would recieve 800 x 25 =20000
and so on through the top 9

also I want to include 500 point to each player that takes out (hitman) a player from the tournament

I know I dont want much anyone have any suggestions ?

Thanks
Brent
« Last Edit: August 21, 2012, 03:04:00 PM by itchn4trbl »

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formula Help x2 :)
« Reply #1 on: August 21, 2012, 04:06:51 PM »
Quote
I want every player who enters to recieve 100 points

This part is easy: 100

Quote
then the final table recieves 1000 points  x  # of players - 100 for each place for the top nine

 so if we has 25 players first place would recieve 1000 x 25 = 25000
                              second place would recieve  900  x 25 = 22500
                                third   place would recieve 800 x 25 =20000

A bit trickier, but I think this should work: (11-r)*2500
(Since it's 100 increments for the first part of x25, I simplified it to 10*100, 9*100, and so on, and multiplied the 100 by 25 to get 2500).

Quote
lso I want to include 500 point to each player that takes out (hitman) a player from the tournament

500*nh for this part.

Now to combine it into a usable formula

100 + ((11-r)*2500) + (500*nh)

If this doesn't work, let me know and I'll do some further testing for you.
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!

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Formula Help x2 :)
« Reply #2 on: August 21, 2012, 04:31:34 PM »
Thanks this is a good start but not quite tweeked all the way the # of players should be varible in the formula

is # of players x 1000 = first place
   # of players x 900 = 2nd place
   # of players x 800 = 3rd  place
   # of players x 700 = 4th place
   # of players x 600 = 5th place
   # of players x 500 = 6th place
   # of players x 400 = 7th place
   # of players x 300 = 8th place
   # of players x 200=  9th place


places below 9th only recive the 100 points for entering or 500 point for the hitman bonus for taking some one out

also when I tested this players below 9th place went -

Thanks
Brent
« Last Edit: August 21, 2012, 04:34:48 PM by itchn4trbl »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula Help x2 :)
« Reply #3 on: August 21, 2012, 04:55:19 PM »
Just need to use the max() function to make sure nothing less than 0 gets through.  In fact, just make it nothing less than 100 and you don't have to add 100 to everyone's score:

max(100, (11-r)*2500) + (500*nh)

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Formula Help x2 :)
« Reply #4 on: August 21, 2012, 06:45:32 PM »
ok we are getting closer the max stopped the negitive but I need the # of players varible to scale so instead of awarding 25000 to first it awards 1000 x the number of players  but stops scaling at 9 players

thanks
Brent
« Last Edit: August 21, 2012, 09:35:57 PM by itchn4trbl »

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formula Help x2 :)
« Reply #5 on: August 21, 2012, 09:36:29 PM »
whoops... so sorry about that... we need the ((11-r)*2500) to be this:

f(r=<9, ((11-r)*2500), 0

to make the formula be

100 + (if r<=9, ((11-r)*2500), 0) + (500*nh)

NOTE: The <= may need to be changed to =< to work properly... Again, I apologize for not being able to test this out fully for you.
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!

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Formula Help x2 :)
« Reply #6 on: August 21, 2012, 09:46:17 PM »
ok I tried this both ways suggested and get errors both ways

Brent

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula Help x2 :)
« Reply #7 on: August 22, 2012, 10:04:14 AM »
ok we are getting closer the max stopped the negitive but I need the # of players varible to scale so instead of awarding 25000 to first it awards 1000 x the number of players  but stops scaling at 9 players

It does.  Well, it stops scaling at 10th place.  Sorry, change the 11 to a 10:

max(100, (10-r)*2500)

Now it should stop scaling at 9th place:

 1     22,500.00
 2     20,000.00
 3     17,500.00
 4     15,000.00
 5     12,500.00
 6     10,000.00
 7      7,500.00
 8      5,000.00
 9      2,500.00
10        100.00
11        100.00
12        100.00
13        100.00
14        100.00
15        100.00

Don't forget to keep the hits in there:

max(100, (10-r)*2500) + (500*nh)

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Formula Help x2 :)
« Reply #8 on: August 22, 2012, 10:43:41 AM »
ok somewhere up top we got focused on 25k point which is not what I wanted though your formula does scale it well

in our league we reward points based on the number of players in the tourny this rewards the harder bigger tournaments with more points

so first place recieves 1000 points times the number of players and then the points scale down by 100 to 900 x the number of players for second and 800 times

the number of players for third and on down untill 9th place gets 200 x the number of players only the top nine currently recieve point but I am looking at adding the HP point for extra points for other players and of cousre all player get 100 point for participating

thanks
Brent

itchn4trbl

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Formula Help x2 :)
« Reply #9 on: August 22, 2012, 02:11:28 PM »
max(100,if(rank<=9,((11-rank)*n*100),0))+ (500*nh)


ok I think this is it and working between both of your help and the instruction manual this gives me the numbers I wanted I am sure I will have more questions as I continue to work out how to set up everything just the way I want it but this was a huge hurdle thank you very much for ya'lls help

Brent

I am going to run a full mock tournament ans see if it catches every thing the way I want
« Last Edit: August 22, 2012, 02:13:01 PM by itchn4trbl »