MoTh
02-14-2011, 06:42 AM
Since the last update the following custom stat doesnt works.
I dont find the errors.
<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" />
I dont find the errors.
<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" />