Most caches in a given town Version 2

[brdad]

Attached is a macro which will primarily populate one of the user data fields in GSAK with the town name and also produce 3 interactive stats based on Maine towns.

All the town data is included with the macro in an embedded zip file, which will (hopefully) be automatically be unzipped into the proper GSAK folder the first time you run the macro.



If you run other macros that populate any of the User Data columns, Make sure you elect a column for the town data that will not interfere as the data for the selected column will be deleted. If you are unsure what columns you might be using select View - Add/Delete Columns from the GSAK menu and check the User Data, User data 2, User data 3, and User data 4 checkboxes. If you wish to keep these columns or the column you save the towns in, you can do so by choosing View - Save current view... from the GSAK menu.

You will need to update the database(s) you wish to list Maine towns when you add caches. Choosing to update only the empty records will speed the update a bit, but if you have non-town data in the column you will want to deselect that option to overwrite the old data.
_____________________________________

The stats section of the macro will output D/T, Container(Size), or Cache Type stats, in other words how many of each is in each town. The macro will respect your current GSAK filter, so for example if you want to run towns stats on a particular hider(s), filter GSAK to list only caches hidden by that hider and then run the macro. The image below shows such a list of Ekidokai's hides. If you are running the stats on an unfiltered, large database, such as all Maine caches, you will probably want to limit the stats to towns that have over 25 number of caches, or some number that fits your need.



EDIT: I'll post the macro shortly, I didn't forget! ;-)

EDIT2: macro file is down at the bottom of the post now!

EDIT 3: Macro has been removed and moved to the GSAK web site: http://gsak.net/board/index.php?showtopic=19842