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

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.

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.

Logged

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!

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