Poker Software
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Nov 2009
    Posts
    5

    Default [HowTo] Show Partypoints (formula inside)

    Hi!

    I was searching for a custom stat which shows my earned PPs, but couldnt find anything - so i decided to 'write' it on my own. I dont have any experience regarding this matter, so i looked at some existing stats and transformed them to fit my needs. Now i am almost completely satisfied with the result, except the addition of the different points per limit. It seems like the sum of all limits in the report is not the actual sum but the avg of all limits - maybe someone has an idea to fix this..

    My solution so far:

    HTML Code:
    <Stat GroupName="Default" ColumnName="Partypoints" ValueExpressions="
    
    (case when BigBlind = 4    then 58.0 else 0.0 end) +
    (case when BigBlind = 10   then 38.0 else 0.0 end) +
    (case when BigBlind = 25   then 10.0 else 0.0 end) +
    (case when BigBlind = 50   then 6.7  else 0.0 end) +
    (case when BigBlind = 100  then 4.0  else 0.0 end) +
    (case when BigBlind = 200  then 2.5  else 0.0 end) +
    (case when BigBlind = 400  then 1.7  else 0.0 end) +
    (case when BigBlind = 600  then 1.4  else 0.0 end) +
    (case when BigBlind = 1000 then 1.3  else 0.0 end) +
    (case when BigBlind = 2000 then 1.1  else 0.0 end) +
    (case when BigBlind = 3000 then 1.1  else 0.0 end) +
    (case when BigBlind = 5000 then 0.7  else 0.0 end)
    as PPfactor;
    
    Sum(case when PKH.site_id = 0 then 
    (case when ph.RakeAmount > 0 then 1 else 0 end) 
     else 0 end) as RakedHands;"
    
    Evaluate="(RakedHands/PPfactor)" ColumnHeader="Party Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Party Points earned" />


    I doublechecked the points shown in HEM and in the partyclient and they match almost perfectly (119.60PP vs 120PP yesterday for example).

    The points are calculated correctly for PL/NL games - for FL or SNGs you have to edit the values.


    Edit:

    To show how it works (and to show the bug in the summary):

    Last edited by Enormo; 11-12-2009 at 11:32 PM. Reason: added pic

  2. #2
    Junior Member
    Join Date
    Nov 2009
    Posts
    5

    Default

    I think i fixed the bug - new version:


    HTML Code:
    <Stat GroupName="Default" ColumnName="Partypoints" ValueExpressions="
    
    Sum(
    (case when PKH.site_id = 0 then 1 else 0 end) *
    (case when ph.RakeAmount > 0 then 1 else 0 end)* 
    (
    (case when BigBlind = 4    then (1/58.0) else 0.0 end) +
    (case when BigBlind = 10   then (1/38.0) else 0.0 end) +
    (case when BigBlind = 25   then (1/10.0) else 0.0 end) +
    (case when BigBlind = 50   then (1/6.7)  else 0.0 end) +
    (case when BigBlind = 100  then (1/4.0)  else 0.0 end) +
    (case when BigBlind = 200  then (1/2.5)  else 0.0 end) +
    (case when BigBlind = 400  then (1/1.7)  else 0.0 end) +
    (case when BigBlind = 600  then (1/1.4)  else 0.0 end) +
    (case when BigBlind = 1000 then (1/1.3)  else 0.0 end) +
    (case when BigBlind = 2000 then (1/1.1)  else 0.0 end) +
    (case when BigBlind = 3000 then (1/1.1)  else 0.0 end) +
    (case when BigBlind = 5000 then (1/0.7)  else 0.0 end)
    )
    )
    as ppoints"
    
    Evaluate="ppoints" ColumnHeader="Party Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Party Points earned" />


  3. #3
    Junior Member
    Join Date
    Mar 2011
    Posts
    1

    Default

    it doesnt work anymore
    are there some updates??

  4. #4
    Junior Member
    Join Date
    Nov 2009
    Posts
    5

    Default

    My actual customstats:
    PHP Code:
    <Stat GroupName="Default" ColumnName="PartyPoints" ValueExpressions="Sum((case when PKH.site_id = 0 then 1 else 0 end) * ph.RakeAmount)/50.0 as ppoints"
    Evaluate="ppoints" ColumnHeader="PartyPoints" ColumnFormat="0.00" ColumnWidth="*" Tooltip="PartyPoints earned" />


    <
    Stat GroupName="Default" ColumnName="PartyPoints per 1000 hands" ValueExpressions="Sum((case when PKH.site_id = 0 then 1 else 0 end) * ph.RakeAmount)/50.0 as ppoints"
    Evaluate="(ppoints*1000)/TotalHands" ColumnHeader="PartyPoints \nper 1k hands" ColumnFormat="0.00" ColumnWidth="*" Tooltip="PartyPoints per 1,000 played hands" /> 

Similar Threads

  1. HEM won't show hands under ANY report
    By TheHate in forum Manager General
    Replies: 0
    Last Post: 10-04-2009, 03:49 AM
  2. run report show error message
    By foxkiller in forum Manager General
    Replies: 1
    Last Post: 08-19-2009, 06:07 AM
  3. Report: Group by month doesn't show correct hands below
    By ImSpecial in forum Manager General
    Replies: 1
    Last Post: 06-19-2009, 07:30 AM
  4. report doesn't show 6 max hands
    By gpiotter in forum Manager General
    Replies: 5
    Last Post: 10-26-2008, 10:01 AM
  5. Report "Hands at Showdown" show no hands
    By JazzPunk in forum Manager General
    Replies: 8
    Last Post: 07-25-2008, 08:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •