Author Topic: Need Some Help w/Hit-Related Formula  (Read 3917 times)

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Need Some Help w/Hit-Related Formula
« on: January 02, 2012, 08:57:09 AM »
Setting things up for the 2012 season and am experimenting with a different point system. I want to award 1 point to first player out and increment by 1 for subsequent bust-outs (I have this already setup), 3 additional points for winning, 1 point for one or more hits (in other words, whether you have one hit or knock out the entire field, you get 1 point), and 1 point for the most hits--in case of a tie, player with highest finish gets the point.

Seems like I saw almost this exact scenario here on the forum before but can't find it now.

Thanks in advance for any help.
If it ain't naked, deep-fried or poker-related, I ain't interested!

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #1 on: January 02, 2012, 11:44:42 AM »
n--r+1 = 1 point for 1st out and increment by one
+if(r=1,3) = 3 points for winning
+if(nh =>1, 1) = awards 1 point for obtaining a hit.
The point for most hits you would have to make a prize, track who has the most hits, and manually award it (unless there is a way to automatically do it that I'm not aware of).

So, to combine the first three lines:

n-r+1+if(r=1, 3)+if(nh=>1, 1)    should take care of all but the hit leader, which again, should be a prize.
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!

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #2 on: January 02, 2012, 11:50:56 AM »
I had the n-r+1 and the manually awarded most hits prize. I'll plug the rest into the formula and see how it works. Thanks for the help!
If it ain't naked, deep-fried or poker-related, I ain't interested!

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #3 on: January 02, 2012, 11:54:38 AM »
Glad to help! - If it shouldn't work, lemme know. I'll be around for another hour before I have to get motivated for school.
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!

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #4 on: January 02, 2012, 12:27:20 PM »
Didn't work...ran test tournament and no one got any points at all.
If it ain't naked, deep-fried or poker-related, I ain't interested!

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #5 on: January 02, 2012, 12:30:23 PM »
Might be that it doesn't like the arguement for the hits... what if we were to change it to .... +if(nh>0, 1) ?  (Can't test as the laptop that I use went kaput)
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!

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #6 on: January 02, 2012, 12:54:28 PM »
No difference. Do we maybe need to nest some of these expressions instead of + sign?
If it ain't naked, deep-fried or poker-related, I ain't interested!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #7 on: January 02, 2012, 07:49:59 PM »
Magic_fubu's first formula works as long as you change => to >= (for "greater than or equals to"):

n-r+1+if(r=1, 3)+if(nh>=1, 1)

With 15 players:
118.00
214.00
313.00
412.00
511.00
610.00
79.00
88.00
97.00
106.00
115.00
124.00
133.00
142.00
151.00

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #8 on: January 02, 2012, 10:43:44 PM »
Magic_fubu's first formula works as long as you change => to >= (for "greater than or equals to"):

n-r+1+if(r=1, 3)+if(nh>=1, 1)

Bah.... stupid programmer lingo.... lol.   ;D
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!

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #9 on: January 03, 2012, 07:01:31 AM »
Indeed it does work. Thanks, you guys.
If it ain't naked, deep-fried or poker-related, I ain't interested!

caeles

  • Newbie
  • *
  • Posts: 22
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #10 on: January 26, 2012, 07:25:27 AM »
This looks like a great formula to use as well. Though, one question: where do I put it? In the game-tab or the stats-tab?

Regards,
Bobby

EDIT: Never mind! Found the solution, thanks for taking a look, though :)
« Last Edit: January 26, 2012, 10:34:56 AM by caeles »

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #11 on: January 26, 2012, 11:16:45 AM »
This would go in the points for playing box, found on the game tab.
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!

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #12 on: January 28, 2012, 05:34:06 AM »
Uh, oh...this no longer works. Ran first tournament of the year and manually awarded the hit leader prize with no problem. Upgraded to 3.1 and when I attempted to award the prize after last night's game, here's what I get: (see attachment).
If it ain't naked, deep-fried or poker-related, I ain't interested!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #13 on: January 28, 2012, 02:22:59 PM »
T-Bone emailed this to me.  It's an easy fix and I'll release a patch later today to fix it.

T-Bone

  • Full Member
  • ***
  • Posts: 173
    • View Profile
Re: Need Some Help w/Hit-Related Formula
« Reply #14 on: January 29, 2012, 05:08:38 AM »
And may I say, I don't get this kind of attention from my doctor, lawyer or accountant. Okay, I don't have a lawyer or accountant but you get the point.  ;D
If it ain't naked, deep-fried or poker-related, I ain't interested!