Stars 2010 VPP stats.

[spellofmaya]

I'm using these custom stats, for the 2010 Stars VPP rates, but they seem to be slightly off compared to what I am actually getting at the tables.

Can anyone see what is wrong with them?

These are for FR.


< Stat GroupName="Misc" ColumnName="Stars VPP 2010" ColumnName="VPP 2010" ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*6)/100)/pkh.numberofplayers as numeric),2)) as NewStarsVPPS2" Evaluate="NewStarsVPPS2" ColumnHeader="VPP 2010" ColumnFormat="0.00" ColumnWidth="*" Tooltip="New VPP" />


< Stat GroupName="Misc" ColumnName="Stars VPP per Hand 2010" ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*6)/100)/pkh.numberofplayers as numeric),2)) as NewStarsVPPS2" Evaluate="NewStarsVPPS2/1.0/TotalHands" ColumnHeader="New Stars\nVPPS\nPer Hand 2010" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Stars VPP Points earned per hand based on new calculation" />

Thanks

[cds0699]

I would really, really like accurate stats for 6 max (and maybe full ring, doubt I'll play much FR tho) if anyone can do it. I believe heads up gets the same as 6 max.

[fozzy71]

Roy is working on adding the new VPP stat. It won't be completely accurate on FR tables until we add proper table identification for 6max/full-ring.

[spellofmaya]

I would really, really like accurate stats for 6 max (and maybe full ring, doubt I'll play much FR tho) if anyone can do it. I believe heads up gets the same as 6 max.

If you change *6 in each of the ones above to *5.5 it should work with six max, I'm thinking I must've been on some of the old tables and thats why my vpp total was different cause it seems to be accurate for my latest session. Oh and take the space out in the beginning as it's only there because it wouldn't show up in the forums without it.

[professorpain]

If you change *6 in each of the ones above to *5.5 it should work with six max, I'm thinking I must've been on some of the old tables and thats why my vpp total was different cause it seems to be accurate for my latest session. Oh and take the space out in the beginning as it's only there because it wouldn't show up in the forums without it.

where should we change this exactly?

[spellofmaya]

where should we change this exactly?

(pkh.rakeamount as numeric)*6 in each one.

But they added it to the new beta version. so you can just upgrade and not have to use a custom stat. I think it's only accurate for 6max and HU tho.

[brianwi]

They appear to be incorrect in 1.10 beta 6 still where these queries (once the 6 is changed to 5.5) match exactly.

However, I think the HEM folks are still working on the new queries and table detection - so it's likely coming.

[spellofmaya]

They appear to be incorrect in 1.10 beta 6 still where these queries (once the 6 is changed to 5.5) match exactly.

However, I think the HEM folks are still working on the new queries and table detection - so it's likely coming.

its in beta 7 which was released a few days ago, i think they forgot to update the notice on the site tho.

[brianwi]

Ah. Thanks. I even checked the top of the page - still said Beta 6, so I assumed no change. Great to know!

[professorpain]

I have 1.09.03 and play 6max nl400.

the vpp rate is still wrong.

[spellofmaya]

I have 1.09.03 and play 6max nl400.

the vpp rate is still wrong.

Its fixed in 1.10 beta 7 for 6 max. If you don't want to upgrade you can use the custom stat posted above.

[fozzy71]

Ah. Thanks. I even checked the top of the page - still said Beta 6,......

:o

Sorry about that.

[professorpain]

does beta 7 differentiate between the dates that the day vpp rates changed or does it apply the formula to every hand in your database?

[professorpain]

bump