The Tournament Director Forums

Main => Help Me => Topic started by: CruiseLite on June 16, 2006, 07:51:31 PM

Title: Formula Validation Please
Post by: CruiseLite on June 16, 2006, 07:51:31 PM
Hi gang!

We are wanting to assign the following points:
1 point for playing
1 point for every player knocked out before you
1/2 point for every hit you give
Bonus to 1st, 2nd and 3rd positions of .3, .2 and .1 respectively times number of starting players.

Here is the formula I'm using which seems to work fine for the several tests I ran but was wondering if there is an easier or more elegant way to achieve the results.

((n-r)+1)+(if(r=1,n*.3,0)+if(r=2,n*.2,0)+if(r=3,n*.1,0))+nh*.5

Thanks for any input!!

Craig