Hi everyone!
I woke up at 6 this morning and couldn't get back to sleep so I decided to write a macro that would tell me which DeLorme map each of my found caches is in. Does something like this already exist? If not, let me know and I'll be happy to share it!
So far, the macro seems to work for all maps except 17, 27 and 67. I need to do a bit more tweaking to take care of those maps. Otherwise, I'm pretty pleased with it. It helped me realize that I have completed one more map than I thought I had I haven't completed very many maps so it is possible there are still a few bugs I haven't worked out.
If anyone wants it, let me know what format you would prefer for the output and I'll set it up. Right now the format is pretty simple, below is an example of what it produces on my Found Caches DB. I'm thinking about maybe making it only give me the first found cache on each map in a pretty format that I can put on my gc.com profile.
I'm going out in a little while so I won't be around for a few hours. But, since my staycation ends today I'll try to finish up the macro later tonight! If I don't, I likely won't work on it for a while, lol.
Maine DeLorme Challenge Progress
Caches found on map 1
GC17EHF - Nubble Trouble
GCGCM5 - Postcard Cache
Caches found on map 2
GCX33D - Trains, boats and planes (almost)
Caches found on map 3
GC108F9 - B.M.T. Cache
Caches found on map 4
GCXNME - MOOSE POND CACHE
GC1FJNV - Lovewell's Fight
Caches found on map 5
GC10KRN - Tassel Top
Caches found on map 6
GC1D1FA - Downtown / Main Street USA: Bath, Maine
Caches found on map 7
GC169M9 - A LITTLE PAGE
Caches found on map 8
GCK4FC - Seafarers Beacon Cache
GC9216 - Monhegan Magic
GCQ5M8 - Monhegan Moonwatch
GC93D6 - Shipwreck of the D.T. Sheridan
No caches on map 9 have been found.
No caches on map 10 have been found.
No caches on map 11 have been found.
No caches on map 12 have been found.
Caches found on map 13
GC1F8W6 - Sheepscot River Launch
GC1FC5X - Pretty As A Picture #3 - Stickney Brook
GC1V0Z7 - The Maine Event (Ayuh)
Caches found on map 14
GC17361 - Dammed in Belfast
GC1BXV2 - Footbridge Cache
GC1PK4A - Penobscot History by the Bay
GC1BJ73 - we're not in Kansas anymore?
GC1K91F - Schooners R Us
GCC0E - Patty's Mount Battie
Caches found on map 15
GC1FRKK - Picnic on the Pollutie
GC10DTY - back beach - Maine Rose Series
GCZVN5 - caterpillar hill - Maine Rose Series
GCTGX0 - Travel Bug Recuperation Hotel
GC14VYM - The Gallery
GC1DZ2N - veteran's memorial cache
GCNX7V - king row cache
GCQ6AX - labyrinth cache
GC2414 - Fort Point deLight
GC4EF4 - Sears Island Special
GC1M417 - Gnarly Green
GC1M5PE - South Seize
No caches on map 16 have been found.
Caches found on map 18
GCNDJQ - Coos Canyon Cache
GC14Y72 - Minnesota Twins visit Height of the Land
Caches found on map 19
GC1GG1M - Guard Rail Blues
Caches found on map 20
GC1MAJH - Snow Hawks Snowmobile Trail Micro
GC133R5 - Nine of Spades
GC1QQJY - There's a Light House here?
GCYGH6 - Route 2 Tour-East Mercer Cemetery
GCYGH4 - Route 2 Tour-The Old Bridge
GCYGH0 - Route 2 Tour-Philbrick Park
Caches found on map 21
GC1PBVX - Turkey Day - celebrating Gob-ler's accomplishments
GCTWKH - Right in Plain Sight III (another lamp post Micro)
GCH7N7 - Kennebec Banks Cache
GC1BHN3 - Sherwood Forest
GC1MXDE - A LT Nano Chip Shot
GC1WM6Y - Neck Rd Cache
GCYGHD - Route 2 Tour-Palmyra Veterans Park
GCYGHA - Route 2 Tour-Lake George West
Caches found on map 22
GC1C4HY - Tom's Trail
GC1H8AY - The Fifty States Delaware
Caches found on map 23
GCZN17 - Rails & Rails - Maine Rose Series
GC13WHE - King of Diamonds
GCZZNC - WOW MOM - Maine Rose Series
GC14DQV - 88 Piano Keys - Note B2 "Deep B"- #27
GC13ZCF - Ziploc Zombie
GCWTYF - Sal's Yard
GC13WHM - Queen of Diamonds
GCYGHE - Route 2 Tour-Road to Nowhere
GC1FE0G - Goodwill towards Pine Trees
GC1H68M - KGP
GC1HY2P - KGP2
GC1HYEY - KGP3
GC10HNN - Flour Mill Dam - Maine Rose Series
GCXXY8 - Kenduskeag Woods
GC10HPT - Bulls Eye - Maine Rose Series
GCXTQ3 - Union Station Micro Coin Cache
GC1BF7T - The Moment of Discovery
GCHPM3 - McCarthy cache
GCMA3F - Bangor International Airport TB Hotel
GC1D2RZ - Driving School
GC1F1RN - Old Iron Sides
GCWEN7 - Geo Post Office and Travel Bug Hotel, Bangor
GCV9D3 - Remember When...The Bangor Twin Drive-In
GC1P8G6 - Park and Ride Hide
GC1G88F - Paul Bunyan Sport Center
GC1VAVH - FBRI #4
GC1VAV6 - FBRI #2
GC1JCW9 - # 8
GC1WN69 - Red Four
GC1WJ5T - Elemental Cache 2 - Plants
GC1WJ61 - Elemental Cache 3 - Wood
GC1WJ5J - Elemental Cache 1 - Electricity
GC1D59B - Holden...who knew?
No caches on map 24 have been found.
Caches found on map 25
GC1TMCX - Robt Tribute
No caches on map 26 have been found.
Caches found on map 28
GC1FNCT - Another Rangeley Overlook
GCWZ95 - The Shoe Closet
GCWZ8T - The Lost Shoe
GC1QVYV - Useless Eustis Ewe: Peggy Sue
GCGP12 - Chain of Ponds
Caches found on map 29
GC1CEPT - Maine In Maine?????
GC1TE91 - Sugarloaf view
GC1G2RA - Useless Eustis Ewe: Lewis
GC1GCH4 - Useless Eustis Ewe: Lupercus
GC1G2T4 - Useless Eustis Ewe: Stewart
GC15DAD - Moon Over the Bigelows
GC1G2RD - Useless Eustis Ewe: June
GC1G2RT - Useless Eustis Ewe: Eugene
GC1RZ93 - KL's 70th Birthday Cache- Ledge Falls
GC1TMZC - KL's Pretty As A Picture Cache
Caches found on map 30
GC1GK8X - Water-Slide
GC5337 - Wyman view
GCJ4T4 - Another Reason to Stop
GC1V10J - Arnolds Exit
Caches found on map 31
GC12QKV - Harry's Garage
GCWAK3 - Memorial Bridge
GC1BNY1 - Rabbit Where ?
GC1NBGH - almost there
Caches found on map 32
GC161PH - Back Side of the Wetland
GC12RW5 - Looking Over Dover
GCP2PE - Low's Bridge
GC1PDH5 - Kenduskeag River
GC1PDHQ - More Rivers...
GC1DBHV - Paine Road Cementary
Caches found on map 33
GC17K53 - Byron Coulters Slept Here
GCYY49 - Telltale Heart
No caches on map 34 have been found.
Caches found on map 35
GC1TMCW - TRF Tribute
GC1TMCR - Waterski Tribute
GC1TMCN - BenandTina Tribute
GC1TMCM - Sabby Tribute
GC1TMCK - Tandemstoker Tribute
Caches found on map 36
GC1774F - Almost Home
GC1RNXJ - Eagle's View Cache
No caches on map 37 have been found.
Caches found on map 38
GCWT94 - Mainiac1957's Map 38 Cache
Caches found on map 39
GCZEDE - Holden Cemetary
Caches found on map 40
GCH9JK - Got Moxie?
GCW1P7 - The True Mainer
Caches found on map 41
GCVWDM - Gravel Pit Pond Geocache
GCQ9C0 - Mountain View Pond Geocache
GC1ERVJ - Fish Of The Kennebec #13, Alewife
No caches on map 42 have been found.
Caches found on map 43
GC1H42R - Lincoln Treasure Hunt Series #1
Caches found on map 44
GC1FM5H - Cole Beach
GCZ7D8 - Old Winn Rd. Cache: Springfield, ME
Caches found on map 45
GC1H6VZ - Kossuth Kache
GC1664Z - East Musquash Lake
Caches found on map 46
GCWMFE - Little Falls Cache
Caches found on map 47
GCGYC4 - South of the Border
No caches on map 48 have been found.
No caches on map 49 have been found.
No caches on map 50 have been found.
No caches on map 51 have been found.
No caches on map 52 have been found.
No caches on map 53 have been found.
No caches on map 54 have been found.
No caches on map 55 have been found.
No caches on map 56 have been found.
No caches on map 57 have been found.
No caches on map 58 have been found.
No caches on map 59 have been found.
No caches on map 60 have been found.
No caches on map 61 have been found.
No caches on map 62 have been found.
No caches on map 63 have been found.
No caches on map 64 have been found.
No caches on map 65 have been found.
No caches on map 66 have been found.
No caches on map 68 have been found.
No caches on map 69 have been found.
No caches on map 70 have been found.