The Tournament Director Forums

Main => Help Me => Topic started by: T-Bone on January 02, 2012, 08:57:09 AM

Title: Need Some Help w/Hit-Related Formula
Post by: T-Bone 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.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Magic_fubu 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.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone 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!
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Magic_fubu 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.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone on January 02, 2012, 12:27:20 PM
Didn't work...ran test tournament and no one got any points at all.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Magic_fubu 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)
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone on January 02, 2012, 12:54:28 PM
No difference. Do we maybe need to nest some of these expressions instead of + sign?
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Corey Cooper 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
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Magic_fubu 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
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone on January 03, 2012, 07:01:31 AM
Indeed it does work. Thanks, you guys.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: caeles 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 :)
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Magic_fubu on January 26, 2012, 11:16:45 AM
This would go in the points for playing box, found on the game tab.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone 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).
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Corey Cooper 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.
Title: Re: Need Some Help w/Hit-Related Formula
Post by: T-Bone 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
Title: Re: Need Some Help w/Hit-Related Formula
Post by: Corey Cooper on January 29, 2012, 09:55:15 PM
Well, didn't get it out yesterday as I had hoped (had to release 3.1.1 instead), but did get the patch out tonight.