Tournament Minutes with Decimals for more accurate Hourly?

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

Tournament Minutes with Decimals for more accurate Hourly?

Postby dadizza » Tue Feb 08, 2011 4:17 pm

Hi everyone!
I´m wondering if there is a possibility to get more a more accurate stat for the duration of a tournament, i.e. ´18.6 Minutes´ instead of ´19 Minutes` duration. I´m asking for such a ´feature´ because I noticed that the hourly rate isn´t really accurate based on the hours played. So, it would also be necessary to calculate the hourly rate on the -more accurate- minutes data. Does anybody have a solution for this?
dadizza
 
Posts: 4
Joined: Fri May 16, 2008 9:38 am

Re: Tournament Minutes with Decimals for more accurate Hourl

Postby kraada » Tue Feb 08, 2011 5:39 pm

Are you looking at your $/Hour on the Tournaments tab's Tournaments By Time report? For each session it should only at most be off by one minute - and since sometimes it rounds up and sometimes it rounds down as the number of sessions increases the discrepancy should more or less even out.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tournament Minutes with Decimals for more accurate Hourl

Postby dadizza » Tue Feb 08, 2011 8:20 pm

Thanks for your answer, kraada!
Actually I´m looking at the $/Hour on the Tournaments By Tournament report because I want to know the hourly for the NET time I really played,not including the waiting time between tournaments.
And I noticed that PT3 doesnt round down but always rounds up. For example, if a tournament took me actually 9.1 minutes, it will show 10 minutes in the reports. Given this, the hourly displayed differs from the true hourly.
dadizza
 
Posts: 4
Joined: Fri May 16, 2008 9:38 am

Re: Tournament Minutes with Decimals for more accurate Hourl

Postby kraada » Wed Feb 09, 2011 9:43 am

In the Tournaments By Time report if there's more than 15 minutes with no hands played, things are separated back out. And if you're playing two tournaments at the same time, the time would be aggregated. In the By Tournaments report, if you play two tournaments simultaneously you'll be doubling your hours, which doesn't seem like it would ever get you your real $/hr figures.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests