brianwi
11-01-2009, 09:56 AM
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" />
<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" />