Two Plus Two Older Archives sng tracker question
 FAQ Members List Calendar Search Today's Posts Mark Forums Read

#11
07-21-2005, 07:44 PM
 Hood Junior Member Join Date: Apr 2004 Posts: 2
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.
#12
07-21-2005, 10:37 PM
 axeshigh Senior Member Join Date: Jun 2005 Posts: 223
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!
#13
07-22-2005, 03:37 AM
 Hood Junior Member Join Date: Apr 2004 Posts: 2
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&gt;=MAX(INDIRECT("W13:W" &amp;ROW()-1)),X14,IF(W14&gt;MAX(INDIRECT("W13:W" &amp;ROW()-1)),(W14-MAX(INDIRECT("W13:W" &amp;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!
#14
07-22-2005, 03:43 AM
 Slim Pickens Senior Member Join Date: Jan 2005 Location: Las Vegas, NV Posts: 786
Re: sng tracker question

[ QUOTE ]
a) I don't understand it

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

ok picking through that excel math I've got:

IF starttime &gt; max(all_other_end_times)
Multi_duration = tourney_duration

ELSE
If endtime &gt; 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.
#16
07-22-2005, 04:32 AM
 axeshigh Senior Member Join Date: Jun 2005 Posts: 223
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).

 Thread Tools Display Modes Linear Mode

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Two Plus Two     Two Plus Two Internet Magazine     About the Forums     MOD DISCUSSION     ISOP General Poker Discussion     Texas Hold'em     Beginners Questions     Books and Publications     Televised Poker     News, Views, and Gossip     Brick and Mortar     Home Poker     Poker Beats, Brags, and Variance     Poker Theory Limit Texas Hold'em     Mid- and High-Stakes Hold'em     Medium Stakes Hold'em     Small Stakes Hold'em     Micro-Limits     Mid-High Stakes Shorthanded     Small Stakes Shorthanded PL/NL Texas Hold'em     Mid-, High-Stakes Pot- and No-Limit Hold'em     Medium-Stakes Pot-, No-Limit Hold'em     Small Stakes Pot-, No-Limit Hold'em Tournament Poker     Multi-table Tournaments     One-table Tournaments Other Poker     Omaha/8     Omaha High     Stud     Other Poker Games General Gambling     Probability     Psychology     Sports Betting     Other Gambling Games     Rake Back     Computer Technical Help Internet Gambling     Internet Gambling     Internet Bonuses     Software 2+2 Communities     Other Other Topics Other Topics     Sporting Events     Politics     Science, Math, and Philosophy     The Stock Market

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