Point formula questions

[flipflop1970]

ok I use this formula for my points.  round(sqrt(((bc*n)/(r+1)))/r)+(n-r)  based on 20 players the last place finisher gets 0

Now I know I can add +1 to the end of the formula to eliminate that. but instead I would like to roundup.  when I try and use roundup it tells me there is an error in the formula.

Also,  I am running a series of local tournaments.  we get anywhere from 30-70 players.  what do I need to do to keep a running point total for all 20 tournaments?

I am confused where to find this option.

[Corey Cooper]

That's because "roundup" is not a function.  Use "ceil" (ceiling) to round up.  Use "floor" to round down.  Use "round" to round to the nearest (up or down).

You don't need to do anything to get running point totals, other than making sure to save each tournament after they finish.  The Stats tab will tally up player points automatically.  Just press the "Refresh Tourneys" button.

[badbeat]

Just ensure the location you save your tourneys, is listed in the "Tournament file location (for stats)" section, at the bottom of the preferences tab.

[flipflop1970]

ceil(sqrt(((bc*n)/(r+1)))/r)+(n-r)


would this be it then?

Thanks Corey!

[Corey Cooper]

Looks OK to me.