Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > Tournament Poker > One-table Tournaments

Reply
 
Thread Tools Display Modes
  #11  
Old 07-21-2005, 07:44 PM
Hood Hood is offline
Junior Member
 
Join Date: Apr 2004
Posts: 2
Default Re: sng tracker question

If anyone can come up with a smart algorithm to calculate this, please let me know. I'm scratching my head at the moment.
Reply With Quote
  #12  
Old 07-21-2005, 10:37 PM
axeshigh axeshigh is offline
Senior Member
 
Join Date: Jun 2005
Posts: 223
Default Re: sng tracker question

[ QUOTE ]
If anyone can come up with a smart algorithm to calculate this, please let me know. I'm scratching my head at the moment.

[/ QUOTE ]

Can't you just use the same algorithm that is used by the spreadsheet? Someone posted their software called sngpro that calculated hourly rate too.

I had a request too, that instead of just the finish position graph there would be a way to tell the exact % of any of the finishes. (maybe there is already a way to find out and I just didn't figure it out)

And thanks for the nice program!
Reply With Quote
  #13  
Old 07-22-2005, 03:37 AM
Hood Hood is offline
Junior Member
 
Join Date: Apr 2004
Posts: 2
Default Re: sng tracker question

[ QUOTE ]
Can't you just use the same algorithm that is used by the spreadsheet?

[/ QUOTE ]

No, because

a) I don't understand it, and
b) For each record, i think it queries all the other data to see what 'unique' time it has. This results in an n^2 passes through the data. I'm sure you can get it working through only n.

If I'm wrong, feel free to explain this to me further:

=IF(V14>=MAX(INDIRECT("W13:W" &ROW()-1)),X14,IF(W14>MAX(INDIRECT("W13:W" &ROW()-1)),(W14-MAX(INDIRECT("W13:W" &ROW()-1)))*60*24,0))

[ QUOTE ]
Someone posted their software called sngpro that calculated hourly rate too.

[/ QUOTE ]

Search for 'sngpro' turns a blank.

[ QUOTE ]

I had a request too, that instead of just the finish position graph there would be a way to tell the exact % of any of the finishes. (maybe there is already a way to find out and I just didn't figure it out)

[/ QUOTE ]

This is in the next version.

[ QUOTE ]
And thanks for the nice program!

[/ QUOTE ]

Thanks!
Reply With Quote
  #14  
Old 07-22-2005, 03:43 AM
Slim Pickens Slim Pickens is offline
Senior Member
 
Join Date: Jan 2005
Location: Las Vegas, NV
Posts: 786
Default Re: sng tracker question

[ QUOTE ]
a) I don't understand it

[/ QUOTE ]
Neither do I. I wish I could be of more help here.
Reply With Quote
  #15  
Old 07-22-2005, 03:43 AM
Hood Hood is offline
Junior Member
 
Join Date: Apr 2004
Posts: 2
Default Re: sng tracker question

ok picking through that excel math I've got:

IF starttime > max(all_other_end_times)
Multi_duration = tourney_duration

ELSE
If endtime > max(all_other_end_times)
Multi_duration = endtime - max(all_other_end_times)
Else
Multi_duration = 0


Yes, that seems to make sense. I may be able to translate that in to a SQL query... but it would really slow things down for a large database.
Reply With Quote
  #16  
Old 07-22-2005, 04:32 AM
axeshigh axeshigh is offline
Senior Member
 
Join Date: Jun 2005
Posts: 223
Default Re: sng tracker question

[ QUOTE ]

Search for 'sngpro' turns a blank.

[/ QUOTE ]

Oddly enough, the name of the software is mentioned nowhere in this post.

Don't know if it will be of any help. The software seems to be buggy, it stopped importing for me after 150 sngs or so, but it did calculate a lot of stuff that the tracker doesn't do (this isn't a complaint or anything, far from it).
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.