Spread The Love

From GeoWiki
Revision as of 09:05, 23 March 2013 by Noikmeister (talk | contribs)
Jump to: navigation, search

Introduction

There are a number of challenge caches around which require the finder to have found a certain number of caches which hadn't previously been found for more than a certain period. Examples are:

GC3KWWQ - Spread the Love Challenge [1]

This cache requires the finder to find enough cache that haven't been found for at least 183 days so that the total number of days is greater than 15 years (5479 days).

GC47J4N - Challenge: Fifteen Forgotten Years [2]

This is essentially the same as the Spread the Love Challenge.

GC45RN3 - Challenge: Five Forgotten Years [3]

As above, but the total is only 5 years (1826 days)

Finding your finds on unloved caches

Unfortunately it can be quite hard to tease out these unless you have a few which you already know of. Especially if you are making them up from lots of 6-12 month finds. So to make it easier I've written some SQL and PowerShell code to generate the statistics for you.

What you need

  • A GSAK database with all your finds in it. Note: This DB will also need the logs for the next finder or the published log if it was an FTF
  • You need a Windows Vista or Windows 7 machine (or have PowerShell installed on Windows XP)
  • A copy of the SQLite command shell for Windows [4]
  • OPTIONAL: A spreadsheet program like Excel to view the data
  • The code below

The Code