Party Points Earned?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Party Points Earned?

Postby oracle3001 » Fri Aug 15, 2008 7:46 pm

Anybody got an idea how I would go about calculating this.

For those that don't know, you get x points (dependent on level of play) per 20 raked hands at that level (regardless of if you played 20 a one table or 20 at multiple tables). Quite a complicated one, any ideas?
oracle3001
 
Posts: 851
Joined: Fri Jan 25, 2008 4:12 am

Re: Party Points Earned?

Postby WhiteRider » Sat Aug 16, 2008 4:14 am

Ooh, yeah, that's a good one!

I don't think there is a 'mod' function (yet?) so you won't be able to get it accurate, but you should be able to get it to the nearest point by counting the hands played at each level and dividing by 20.
Since the points aren't a pure function of the blinds, I don't think it will be a straightforward single column.
I'm not sure if there's a better way of doing it, you may need to create a 'Column' for each set of levels that generate the same number of points, and then create a 'Statistic' which adds together all your columns.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests