Formula Noob question

[drbald1]

Ok, I searched a bit and didn't find what I was looking for, so I thought I'd ask.  I'm a complete noob to anything more than the most basic Excel formulas, so go easy.   

I'm basing this on the standard points-per-rank formula n - r + 1.  What I'd like to do is penalize players via points for rebuys, but on a scale.  -0 for first round rebuys, -1 for 2nd round, etc.

So....what would that look like?

[Magic_fubu]

the "na" variable is for number of add ons, and the "nr" is for number of rebuys. If you look to penalize one point for either, it's as simple as adding this to your formula: "- na". If, for example, you want to penalize 3 points, it would be this: "- 3 * na"

However, to my knowledge, the program cannot directly correlate round of rebuy into the formula; however, in the game notes, you can see when the people rebought or added on, and adjust the points manually that way. My suggestion for doing what you suggest is this: Make your formula be n - r + 1 - nr. Track on paper or excel who rebuys and what round, etc., and adjust the points as you are able to. You are able to adjust during the game. By this method, only the 2nd level would not require any adjustments.

That's the best way that I'm personally aware of, but perhaps someone else may have a different/better way to do this...

[TIMMER]

When you bustout a player, you have a option when rebuying back in to set the points then. so anytime they rebuy just look at what round your at and set it,  like  round 1 with -o  or   3rd round, -3   or   5th round -5   

[Magic_fubu]

Thanks, Timmer - I didn't know that... But such is the life of a freezeout host.... lol

[drbald1]

We've been keeping track manually, and I was kind of hoping to automate it all.  Sounds like I can get pretty close, especially doing points manually as they rebuy.

Thanks folks!

[TIMMER]

We did something like this in our Race To A Hundred, Are rebuys ended at the end of the 5th round, But it went rebuy in the 5th round points 0,  4th round -1,  3rd round -2,  2nd round -3,  1st round -4,   they didnt like the idea of getting punished for a higher rebuy round

[drbald1]

So how hard is this, then:

Points per rank (1 for 10th place up to 10 for 1st)
Point for making the final table (top 6 players)
-1 point per rebuy (this is easy)

And then using league stats to track it all? 

[Magic_fubu]

Points per rank as described: n-r+1
point for making final table: if(r =<6, 1)    *note: might need to be <= instead of =<
-1 for rebuy: -nr

Combined: n - r + 1 + if(r=<6, 1) - nr

How I handle league stats: Create the league with the name, and name a season. Each tournament should have the league name and the season setting for which it should be applied to. League scoring should be sum(points), where each tournament would have the point formula above.

[Corey Cooper]

point for making final table: if(r =<6, 1)    *note: might need to be <= instead of =<

Even easier, just use finalTable, which will be "1" if the player made the final table or "0" if they did not (determined by the largest table on the Tables tab).

Combined: n - r + 1 + finalTable - nr

[Magic_fubu]

point for making final table: if(r =<6, 1)    *note: might need to be <= instead of =<

Even easier, just use finalTable, which will be "1" if the player made the final table or "0" if they did not (determined by the largest table on the Tables tab).

Combined: n - r + 1 + finalTable - nr

didn't even realize there was a finalTable token... Sweet... would that work for an "if" statement?  if(finalTable=1,13), for example?

[Corey Cooper]

Of course! 

[drbald1]

Holy shniekies, it worked!  Thanks!