Author Topic: Could I ask for help please with formulas  (Read 4189 times)

destadula

  • Newbie
  • *
  • Posts: 30
    • View Profile
    • Da-Man Poker Club
Could I ask for help please with formulas
« on: February 24, 2009, 05:26:56 PM »
Currently our league has used the formula N-R+1 as a point system with an additional 5 points for the buyin. Because the winner is only receiving 1 point more than second place we are now switching so that the winner of the tournament gets 5 bonus points in addition to the N-R+1.

Here is what I am trying to explain:

48 player tournament

53 points for winner
52 points for second and so on.

Now under the same senerio we would like it to be as follows:

48 player tournament

58 points for the winner
52 point for second and so on.


I thank you in advance for any help you may give. There is no great hurry as we play again on March 7, 2009.

manpokerclub.com
Desta Dula
Man Poker Club
http://www.manpokerclub.com
Certified Tournament Directors Association

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Could I ask for help please with formulas
« Reply #1 on: February 24, 2009, 05:40:45 PM »
n - r + 1 + if(r == 1, 5)

This assumes you've set "Points for buy-in" to 5.  If not, use

n - r + 6 + if(r == 1, 5)





destadula

  • Newbie
  • *
  • Posts: 30
    • View Profile
    • Da-Man Poker Club
Re: Could I ask for help please with formulas
« Reply #2 on: February 24, 2009, 05:51:20 PM »
Corey,

Thank you for the quick reply and the help.

manpokerclub.com
Desta Dula
Man Poker Club
http://www.manpokerclub.com
Certified Tournament Directors Association

destadula

  • Newbie
  • *
  • Posts: 30
    • View Profile
    • Da-Man Poker Club
Re: Could I ask for help please with formulas
« Reply #3 on: January 01, 2010, 08:14:38 AM »
 This forum has been a great help in the past as well as the previous two posts. I use TD for our league and Rank'em for our website and with some tweeks here and there I have been able to get it running pretty smoothly.

I currently use the formula in Tournament Director  N - R + 1 with a bonus of 5 pts for a buyin. Now when I translate this to Rank'em the formula looks like this (bolded type):

strSQL =  "SELECT "& round_count & " round((1+((T.tournament_players)-(S.placement)+5)),0) " _
& "FROM scores S INNER JOIN tournament T ON S.tournament_id = T.tournament_id  " _
& "WHERE S.player_id = "& dbRS(0) & " "
if session("date_range") > "" then
strSQL = strSQL & " AND T.tournament_date BETWEEN #"& session("begindate") &"# AND #"& session("enddate") &"# "
end if
strSQL = strSQL & "ORDER BY 1 DESC"

What I am requesting help on is this if anyone can possibly help out.

Using the code above I am looking to change N – R + 1 which it is above to use the formula
 
N – R + 1  + if(r == 1, 5)

Thank you in advance to any help one could give. DestaDula

Side note: I have asked the author of Rank’em to both contact TD and try to get the programs hooked up and to also proved formulas as an input much the way TD does, but no answer yet.
Desta Dula
Man Poker Club
http://www.manpokerclub.com
Certified Tournament Directors Association

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Could I ask for help please with formulas
« Reply #4 on: January 04, 2010, 10:28:41 AM »
I'm not the best at SQL but try this:

round(T.tournament_players - S.placement + 1 + (case when S.placement = 1 then 5 else 0 end), 0)


destadula

  • Newbie
  • *
  • Posts: 30
    • View Profile
    • Da-Man Poker Club
Re: Could I ask for help please with formulas
« Reply #5 on: January 04, 2010, 10:30:55 AM »
Thank you... I will try this and let you know the results of the test.

Desta Dula
Man Poker Club
http://www.manpokerclub.com
Certified Tournament Directors Association

destadula

  • Newbie
  • *
  • Posts: 30
    • View Profile
    • Da-Man Poker Club
Re: Could I ask for help please with formulas
« Reply #6 on: January 06, 2010, 01:30:04 PM »
Unfortunately this did not work so what I have done is put in a request to the rankem.com (clicktech.com) people in hopes I get a response.

I'm not the best at SQL but try this:

round(T.tournament_players - S.placement + 1 + (case when S.placement = 1 then 5 else 0 end), 0)


Desta Dula
Man Poker Club
http://www.manpokerclub.com
Certified Tournament Directors Association

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Could I ask for help please with formulas
« Reply #7 on: January 07, 2010, 09:48:26 AM »
I wonder why it didn't work.  That is valid SQL (and I actually tried it with MSSQL Server).