Hat jemand mal Zeit und Lust diese customstats auf die Richtigkeit der Punkte zu testen?
Einfach mal die Punkte innerhalb einer Session vergleichen.
<Stat GroupName="Default" ColumnName="Paddy Points" ValueExpressions=" Sum(
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 1 and 2 then 0.09 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 3 and 5 then 0.22 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 6 and 10 then 0.45 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 11 and 24 then 1.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 25 and 50 then 2.1 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 51 and 75 then 3.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 76 and 100 then 5.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then 6.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then 8.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then 9.25 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then 11.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then 12.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then 13.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then 15.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then 17.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >= 305 then 29.0 else 0 end)
)/1.0 as PPPoints" Evaluate="PPPoints" ColumnHeader="Paddy Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Paddy Points" />
<Stat GroupName="Default" ColumnName="WH Points" ValueExpressions=" Sum(
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 1 and 2 then 0.1 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 3 and 5 then 0.25 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 6 and 10 then 0.35 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 11 and 24 then 0.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 25 and 50 then 1.25 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 51 and 75 then 2.25 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 76 and 100 then 3.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then 4.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then 4.75 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then 5.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then 6.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then 7.25 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then 8.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then 10.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then 12.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >= 305 then 16.0 else 0 end)
)/1.0 as WHPoints" Evaluate="WHPoints" ColumnHeader="WH Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="WH Points" />
<Stat GroupName="Default" ColumnName="Mansion Points" ValueExpressions="
Sum(
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 1 and 9 then 0.3 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 24 then 1 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 25 and 50 then 2 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 51 and 75 then 3 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 76 and 100 then 4.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then 6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then 7 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then 8.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then 10 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then 11 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then 12.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then 14.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then 16.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >= 301 then 21.0 else 0 end)
)/1.0
as MCP" Evaluate="MCP" ColumnHeader="MCP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="MCP" />
<Stat GroupName="Default" ColumnName="TitanPoints" ValueExpressions="
Sum(
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 4 and 9 then 0.3 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 24 then 0.9 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 25 and 50 then 1.7 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 51 and 75 then 3.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 76 and 100 then 4 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then 5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then 6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then 7.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then 8 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then 11 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then 13 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then 15.5 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then 17.0 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >= 301 then 24.0 else 0 end)
)/1.0
as TitanPoints" Evaluate="TITANPoints" ColumnHeader="TitanPoints" ColumnFormat="0.00" ColumnWidth="*" Tooltip="TitanPoints" />
<Stat GroupName="Default" ColumnName="bet365" ValueExpressions="
Sum(
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 4 and 9 then 0.32 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 24 then 0.64 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 25 and 50 then 1.6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 51 and 75 then 2.4 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 76 and 100 then 3.6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then 4.8 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then 5.6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then 6.8 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then 7.6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then 9.6 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then 12 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then 14.4 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then 16 else 0 end) +
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >= 301 then 17.6 else 0 end)
)/1.0
as bet365" Evaluate="bet365" ColumnHeader="bet365" ColumnFormat="0.00" ColumnWidth="*" Tooltip="bet365" />
Eine Anleitung fürs einfügen gibts hier:
Holdem-Manager customstats für PaddyPowerPunkte
