Star VPP 2012

[Goertsy]

Stars is switching to contributed rake from dealt so I would need a new stat to calculate VPPs and more importantly: rakeback.

For those who are not familiar with the system.
Old system:VPPs = (total pot) * (rake collected * VPP multiplier) / (number of players dealt into the hand)
VPP multipliers:

Spoiler: show

tables with 8 or more seats --> 6 for $ tables and 8.5 for € tables
tables with 7 or fewer seats --> 5.5 for $ tables and 8 for € tables

For the old system I was using this stat and it worked perfectly:

Code: Select all

if[holdem_limit.limit_name LIKE '€%', if[holdem_limit.limit_name LIKE '% max)', (holdem_table_session_summary.amt_mgr*8), (holdem_table_session_summary.amt_mgr*8.5)],if[holdem_limit.limit_name LIKE '% max)', (holdem_table_session_summary.amt_mgr*5.5), (holdem_table_session_summary.amt_mgr*6)] ]

The new system:
VPPs = (your contribution to pot / total pot) * (rake collected * VPP multiplier)
VPP multipliers

Spoiler: show

8 or more seats --> 6 for $ and 8 for €
7 or fewer seats --> 5.5 for $ and 7 for €

Can someone help me to create a stat for the new system? Any help would be greatly appreciated.

[kraada]

The stat in this thread should give you a good base to start from - it will give you your weighted contributed rake.

[Dilas]

Kraada would you please help to create VPP stats for 2012 rake at cashganes

Simply inserting amt_weighted_contributed_rake for amt_rake in my old stats dont work.

[Dilas]

sum(if[(holdem_hand_summary.id_site=100 AND holdem_hand_summary.amt_weighted_contributed_rake>0),(if[holdem_hand_summary.cnt_players>=8, holdem_hand_summary.amt_weighted_contributed_rake*6*(1/(holdem_hand_summary.cnt_players)),holdem_hand_summary.amt_weighted_contributed_rake*5.5*(1/(holdem_hand_summary.cnt_players))]),0])


whats wrong ?

[kraada]

amt_weighted_contributed_rake is not a new database element. As created with this stat it is a new column. You can reference it in a stat or you can edit it as necessary but it can't be used in a column.

[Dilas]

nice to know but it did not really help me much....