sng tracker question

[Hood]

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

[axeshigh]

[ 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!

[Hood]

[ 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!

[Slim Pickens]

[ QUOTE ]
a) I don't understand it

[/ QUOTE ]
Neither do I. I wish I could be of more help here.

[Hood]

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.

[axeshigh]

[ 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).