Stars VPPS Item Incorrect

[brianwi]

I know this point is almost moot (since the VPP system is going to change), but the Stars VPPS item that was added to HEM is slightly incorrect. For me, as an example, it shows 8646 VPPs earned when in reality it should be 8633 (according to Stars). I have a custom Stars VPPs that is correct and have pasted it below. Thanks.


<Stat GroupName="Default" ColumnName="VPPs Earned" ValueExpressions="
Sum((case when PKH.RakeAmount between 40 and 299 then 1 else 0 end)+
(case when PKH.RakeAmount >=300 then 2 else 0 end))/1.0
as StarsVPPc" Evaluate="StarsVPPc" ColumnHeader="Total VPPs" ColumnFormat="0" ColumnWidth="*" Tooltip="VPPs earned total at limits 1/2NL full ring or lower" />

<Stat GroupName="Default" ColumnName="1 and 2 VPP Hands" ValueExpressions="
Sum(case when PKH.RakeAmount >=40 then 1 else 0 end)
as StarsVPPe" Evaluate="StarsVPPe" ColumnHeader="1 and 2 VPP Hands" ColumnFormat="0" ColumnWidth="*" Tooltip="1 (or 2) VPP Hands at 1/2NL full ring or lower" />

<Stat GroupName="Default" ColumnName="2 VPP Hands" ValueExpressions="
Sum(case when PKH.RakeAmount >=300 then 1 else 0 end)/1.0
as StarsVPPf" Evaluate="StarsVPPf" ColumnHeader="2 VPP Hands" ColumnFormat="0" ColumnWidth="*" Tooltip="2 VPP Hands at 1/2NL full ring or lower" />

<Stat GroupName="Default" ColumnName="VPPs/hand" ValueExpressions="
Sum((case when PKH.RakeAmount between 40 and 299 then 1 else 0 end)+
(case when PKH.RakeAmount >=300 then 2 else 0 end))/1.0
as StarsVPPd;Count(PH.*) as TotalHands" Evaluate="StarsVPPd/TotalHands" ColumnHeader="VPPs/hand" ColumnFormat="0.000" ColumnWidth="*" Tooltip="VPPs earned per hand, if these hands were played at 1-2 NL FR or lower" />

[netsrak]

What about the "New Stars VPP poinst" we added some weeks ago?

[brianwi]

well, assuming Stars changes the VPP system (they haven't for the games I play yet), then it might work. But I was just saying, the current one is incorrect. :) (But again, it's probably moot since the system is changing anyway, but we won't know changes for sure until December according to Stars.)