Formula assistance request

[bfcadmin]

I am using the following formula for my Tournament Scoring (under Stats Tab), 35 - (nr * 5) + (nh * 5) + (na * 5) + (finalTable * 10) + (m * 20) + switch(r, 1, 100, 2, 50, 3, 25, 4, 10) it should work as follows

+35 BuyIn
-5 pts for a rebuy
-5 pts for an addon
+5 pts for hit
+10 pts for making the final table (top 10 players)
+20 pts for making it into the money
+100 pts for 1st
+50 pts for 2nd
+25 pts for 3rd
+10 pts for 4th

Is the formula correct?

#2 what formula should I use in the Overall Scoring to come up with a "score" rather than points total?

Lastly, is there any way to incorporate the 4th place finish into the stats export rather than just the top three?

[Corey Cooper]

Looks right to me.

I can't answer number 2 for you.   To me it looks like the sum of points is probably the right thing, but it sounds like you might want to tweak that a bit.

I'm not sure what you are asking in your final question.  The "stats export" should export all players listed on the Stats tab.

[bfcadmin]

Corey, it does list all players. What I am not getting is Finishes Columns beyond 1st, 2nd & 3rd. Can we include more finishes?

[Corey Cooper]

That's on the list.  My concern is that I'll add new columns for places 4 through 10, then I'll get a request for more places 11 through 20.  Where do you draw the line?

[bfcadmin]

likely most users here are not full fledge commerical users and would not ever need more than 10-20 pay outs.

You have my empathy.