GSAK Stats Macro

[+rutson]

I've had a little play today with the GSAK macro language, thought it was about time I got to grips with it. Inspired by that My Finds PQ analyser that Fiona posted the other I day I've come up with a find stats generator of my own.

 

You can see the output here.

 

I'm looking for ideas for yet more stats that can be put on there and any other comments.

Edited August 24, 2006 by rutson

[+Team Ballibeg]

Great stuff! Nicely represented too. Well done.

 

Dave

[+Jaz666]

Looks fantastic matey, get it released!

 

The only thing I'd add would be a "future milestones" date prediction as per the topic which was on here a few days ago.

[+Maingray]

Looks great, I'd use it for sure. Reminds me of ircstats!

 

Yeh, future milestone would rock.

[+dino-irl]

Ohhhhh....I like that, especially the "Finds By Owner" bit at the bottom

[+CrazyL200]

Fantastic, a nice interface, that's easy to read.

How about adding most in a week finds and predictions as above.

 

Well done - get it released, I'm sure it'll be well received.

[+wizard1974uk]

Looks great Ian

[+Hi-Tek]

Very presentable - I'm impressed.

 

One Q - what's the "Finds byOwner" part? Does it represent caches placed and logged by the owner?

[+rutson]

No, it's the number of caches I've found placed by a particular person. Maybe the wording could be improved?

 

BTW, the following are in the works: finds by day of week, most in a week (Mon-Sat), most in a weekend (Sat+Sun). Milestones (past and future predictions, though the user will have to select which caches were the milestones.

 

Units for the distance is tricky as it's a GSAK option, I may let the user enter it at run-time. (ah! hang on, I have a cunning plan....)

[+Happy Humphrey]

Looks fantastic: can it be easily pasted into your profile though (like this)?

[+Tiger-Eyes]

I'm well impressed and would definately use it.

[+HazelS]

You wouldn't happen to be bored whilst out in China would you Ian???

 

[Deego]

Very nice

 

Does it count "Other" type also? (I have all my trigpoints in this section) or would this throw all the data out?

[+Hi-Tek]

No, it's the number of caches I've found placed by a particular person. Maybe the wording could be improved?

 

BTW, the following are in the works: finds by day of week, most in a week (Mon-Sat), most in a weekend (Sat+Sun). Milestones (past and future predictions, though the user will have to select which caches were the milestones.

 

Units for the distance is tricky as it's a GSAK option, I may let the user enter it at run-time. (ah! hang on, I have a cunning plan....)

Ah I understand .

 

Perhaps wording along the lines of "Caches placed by 'xyz' that I've found" (not easy to pick good description methinks).

[+Hi-Tek]

Very nice

 

Does it count "Other" type also? (I have all my trigpoints in this section) or would this throw all the data out?

..... and here starts a potential problem. I use the "Other" for parking/information and the "Benchmark" icon for Trig Points

 

I think this is an excellent Stats report and the effort involved to produce it deserves to be applauded

[+Seasider]

Excellent utility!

 

Cheers!

 

Seasider

[+Moote]

Looks good Ian, but when can we have a version to play around with

 

Moote

[+rutson]

Well.... I sort of got sidetracked today. Some darned fool suggested pie charts would be nice. An idea I dismissed at first then got thinking about it. Lots of PHP/GD/GIF89a hacking later, I can now generate 3D effect pie charts with the GSAK macro language In true Bluepeter style, here's one I made earlier:

 

It relates to my Finds by Container

 

Will try to get Beta release 1 of the main stats script available tomorrow.

Edited August 26, 2006 by rutson

[+Seasider]

Excellent - look forward to it.

 

Cheers!

 

Seasider

[+Cryptik Souls Crew]

Project A.P.E and Mega Event are missing from the Finds by Type category

[+rutson]

That's because they're not listed as types in GSAK, Clyde is aware.

[+walkergeoff and wife]

Well.... I sort of got sidetracked today. Some darned fool suggested pie charts would be nice. An idea I dismissed at first then got thinking about it. Lots of PHP/GD/GIF89a hacking later, I can now generate 3D effect pie charts with the GSAK macro language In true Bluepeter style, here's one I made earlier:

 

It relates to my Finds by Container

 

Will try to get Beta release 1 of the main stats script available tomorrow.

Is the beta available? If so, is there a link where I can download it?

[+rutson]

Nah, sorry, not yet! There are a few issues I want to resolve before getting another release out, mianly the thorny issue of multiple finds.

[+The_Westies]

Great idea! Would it be possible to break the list down by counties and even countries as well?

[+rutson]

Well.... counties is not so easy, given Groundspeak doesn't support them. Countries is on 'the list'.

 

Look at my profile for the latest output, including a states map. I know, not a lot of use for us UKers, but it was an easy section (relatively speaking) and looks nice

[Nediam]

Looks really nice Rutson - a great idea

 

Would it be possible to include something like an "Average Number of Caches Found - per Week" based on either the number of weeks since you started caching or perhaps just the number of weeks so far for this year?

[+rutson]

Nice idea, Nediam, done

[Nediam]

Nice idea, Nediam, done

 

Hmmm, that seemed far too easy! Must try and think of something more testing for you

 

Cheers though

Edited September 5, 2006 by Nediam

[Deego]

Its looking very good Stats got to luv em

 

How about FTF ? as a log text search maybe?

[barryhunter]

How about FTF ? as a log text search maybe?

 

I tried doing that on G:UK, but found that some log's had things like "must of missed the FTF by minutes", basically a large proportion of the first day logs all mentioned FTF. Not saying its not possible, just have to catch some negatives, also if only searching your own logs, you can know that you only mention FTF in real FTF logs.

[+rutson]

You can actually mark FTFs in GSAK, but I haven't so it's down 'the list', but certainly possible.

[Deego]

You can actually mark FTFs in GSAK, but I haven't so it's down 'the list', but certainly possible.

 

It was only an idea . I can remember all SIX of mine lol

[+Al & Tracy Smith]

Its looking very good Stats got to luv em

 

 

Just remember though: -

 

There are lies, d@mn lies and statistics!

 

But seriously a big thumbs up for a great utility and welll presented data. Looking forward to seeing the completed version.

[+rutson]

Just been through my finds, I think I have 46 FTFs.

[+Moote]

Its looking very good Stats got to luv em

 

How about FTF ? as a log text search maybe?

Brian

 

This kind of data compiling / reporting, never works as free form fields can actually hold any spurious information. Even in industry when compiling the results of massive surveys, they need considerable human intervention to get meaningful information out.

 

Milton

[+purple_pineapple]

Its looking very good Stats got to luv em

 

How about FTF ? as a log text search maybe?

Brian

 

This kind of data compiling / reporting, never works as free form fields can actually hold any spurious information. Even in industry when compiling the results of massive surveys, they need considerable human intervention to get meaningful information out.

 

Milton

 

I have a stats summary on my profile that includes FTF and does it this way, and I suspect its not especially accurate for exactly those reasons! However, as Ian points out, there is now a tick box in GSAK for FTF, so we just need to remember to use it!

 

Ian, don't know if you've seen my profile stats, but it may help. Dunno about the coding though, I just downloaded a prog!

[+Jaz666]

Just thought of something Ian.

Does it support multiple databases in GSAK, as I have UK, non-uk, and archived?

[+Moote]

Just thought of something Ian.

Does it support multiple databases in GSAK, as I have UK, non-uk, and archived?

Easiest solution would be to maintain a Merged Database set. EG 4 x DBs UK, non-uk, archived and Merged

[+rutson]

At the moment, it only supports one database. I'm venturing into the thorny issue of multiple finds next and I think the best way to handle them will be to create a temporary database and copy all finds into there. Will be trivial to add support for multiple databases then, will add it as an option Jaz.

 

As for the FTFs it'd need serious heuistic matching to get anything LIKE accurate results. I went through all my logs of caches I found within the first week of placement and there were many: "Oh darn, just missed FTF" and the like. In short, it aint happening! I will add a line to the numbers section that reports and caches flagged as FTF and just output nothing if there are none I think.

[+rutson]

Ian, don't know if you've seen my profile stats, but it may help. Dunno about the coding though, I just downloaded a prog!

 

Yep, I got the same program, it was the inspiration for my macro. Good program but HOW bloated? To think I downloaded 23mb(or something) of MS Bloatware .NET framework for that...

 

On the other hand, the flipping macro is now over 1500 lines :$

[+Tharagleb]

At the moment, it only supports one database. I'm venturing into the thorny issue of multiple finds next and I think the best way to handle them will be to create a temporary database and copy all finds into there. Will be trivial to add support for multiple databases then, will add it as an option Jaz.

 

As for the FTFs it'd need serious heuistic matching to get anything LIKE accurate results. I went through all my logs of caches I found within the first week of placement and there were many: "Oh darn, just missed FTF" and the like. In short, it aint happening! I will add a line to the numbers section that reports and caches flagged as FTF and just output nothing if there are none I think.

 

Cachestats just searches your log for any string and you add those to a FTF list. I went back and added"-x-" to all my FTF logs and now I can easily search for my FTFs

[+chizu]

any update on this macro?

[+rutson]

Sorry, got engrossed in other stuff, watch this space.

[+Captain Gore-tex]

Looks good, but can it have a feature to prevent the missus seeing how many days Ive been out caching, or at least some form of comparitor for days spent out shopping to try to maintain a sence of perspective? Roll on the beta release.

[Deego]

When are you back in China ? so this can be finished

[+rutson]

China: hopefully never.... (just typing my resignation from the job that takes me there )

 

Macro finished: Errr....... Next question please!

[Deego]

I will take it "as is"

 

Good luck with your next job I was only being flippant, sorry

[+Master Mariner]

I don't know if this has been posted elsewhere, but the stats routine that Rutson started have now been amended by Lignumaqua and are available as a GSAK macro. Absolutely brilliant Ian - I didn't realise my stats looked so good!! To run the macro you will need the latest beta version of GSAK.

 

Edited to add available here

Edited May 9, 2007 by Master Mariner