Need Some Help w/Hit-Related Formula

[T-Bone]

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.

[Magic_fubu]

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.

[T-Bone]

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!

[Magic_fubu]

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.

[T-Bone]

Didn't work...ran test tournament and no one got any points at all.

[Magic_fubu]

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)

[T-Bone]

No difference. Do we maybe need to nest some of these expressions instead of + sign?

[Corey Cooper]

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:

1	18.00
2	14.00
3	13.00
4	12.00
5	11.00
6	10.00
7	9.00
8	8.00
9	7.00
10	6.00
11	5.00
12	4.00
13	3.00
14	2.00
15	1.00

[Magic_fubu]

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.   

[T-Bone]

Indeed it does work. Thanks, you guys.

[caeles]

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

[Magic_fubu]

This would go in the points for playing box, found on the game tab.

[T-Bone]

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).

[Corey Cooper]

T-Bone emailed this to me.  It's an easy fix and I'll release a patch later today to fix it.

[T-Bone]

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.