RakeBack FTP calculation
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    58

    Default RakeBack FTP calculation

    Since the last update the following custom stat doesnt works.
    I dont find the errors.
    HTML Code:
    <Stat GroupName="Default" ColumnName="Base FTP" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
    Evaluate="FTP" ColumnHeader="Base FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
    <Stat GroupName="Default" ColumnName="FTP/100" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
    Evaluate="FTPHand/1.0/TotalHands*100" ColumnHeader="FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />
    <Stat GroupName="Default" ColumnName="BC FTP" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
    Evaluate="FTP*2.5" ColumnHeader="BC FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
    <Stat GroupName="Default" ColumnName="BC FTP/100" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
    Evaluate="FTPHand/1.0/TotalHands*250" ColumnHeader="BC FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />  
    <Stat GroupName="Default" ColumnName="BC FTP $" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
    Evaluate="FTP*2.5*.0035" ColumnHeader="BC FTP $" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $ total" />
    <Stat GroupName="Default" ColumnName="$/100 From FTPs (BC)" 
    ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
    Evaluate="FTPHand/1.0/TotalHands*250*.0035" ColumnHeader="BC $/100 from FTP" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $/100" />
    <Stat ColumnName="WCRake" 
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.01 AS WCRake" 
    Evaluate="WCRake" ColumnHeader="WC Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake (including uncalled bets)" />
    <Stat ColumnName="WCRB" 
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB" 
    Evaluate="WCRB" ColumnHeader="WC Rakeback" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="WCRB" />  
    <Stat Groupname="Default" ColumnName="EV Earn" 
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;sum(case when EV.SklanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks else ph.NetAmountWon end) as SklanskyAdjustedWinnings;sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" 
    Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0)+(FTP*2.5*.0035))" ColumnHeader="EVEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EVEarn" />

  2. #2
    Junior Member
    Join Date
    Feb 2011
    Posts
    1

    Default

    same here

Similar Threads

  1. Calculation of AF
    By Tackleberry in forum Manager General
    Replies: 1
    Last Post: 10-10-2010, 10:51 PM
  2. $EV calculation bug
    By rehlbe in forum Manager General
    Replies: 1
    Last Post: 09-22-2010, 08:56 PM
  3. Cereus wrong calculation rakeback
    By Rukol in forum Manager General
    Replies: 1
    Last Post: 09-06-2009, 01:26 PM
  4. dealt rakeback or contributed rakeback
    By linkus in forum Manager General
    Replies: 1
    Last Post: 07-05-2009, 02:07 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
  •