I think a Maine cacher should ask GPSFUN to archive
Nana's Ladybug Cache" GCJQCF
It has been unavailable too long.
Printable View
I think a Maine cacher should ask GPSFUN to archive
Nana's Ladybug Cache" GCJQCF
It has been unavailable too long.
When and if these files are ever posted so they are correct, can they be made available to all of us? :) Thanks Haffy
Thanks, I was beginning to wonder if I was totally missing something.Quote:
Originally Posted by tat
I didn't intend to ignor you, Haffy! The links are in post #19, just go back to page 2 of this thread and you will see them.Quote:
Originally Posted by Haffy
As to when they will be right, well.... :)
Nope, never used it. PC only software.Quote:
Originally Posted by cameoooooo
Thanks to everyone for having fun with this cache... I have been nervous from the start about it being able to work and how would I handle verifications and all. Well, from all of your work and posts I have learned TONS of new things from my DeLorme software, GSAK, .csv files, right down to the DeLorme Gazetteer. I never knew the coordinates were in the corner of the pages! DOH!!! Now my only concern is someone will submit caches for verification and I have not had a chance to make my finders gift due to truck transmission problems and a pending BIG BILL for repair.
All of you folks are GREAT and I love the stuff you have been creating to conquer this cache! KEEP IT UP!!!!!
Team Teebow 1
Tom T
The latest .xls file is posted. I did indeed make a "bowtie". The pattern is now corrected. Also, polygons need to be "closed" by starting and ending in the same place. This correction has been made.
Could someone make a file to check the filters? I think it would include 4 waypoints near the corners of each map and may even add some in case someone places a cache in one of those out of the way places on maps 17, etc.
Hope to update the .csv files tonight.
The .csv files are updated. Once again, if anyone sees anything wrong, let me know
Looks like Hafy put a bug in GPSFun's ear - it is now archived.Quote:
Originally Posted by Sabby
And it also looks like this was an illegal "vacation cache". The cache owner has found 5 caches, all in Hawaii, and placed 3 caches - one in Maine, one in Hawaii and one in Missouri.
Unfortunatly, that cache is probably still out in the woods somewhere as geo-trash.:(
Oh no! Not another rescue mission!! :)Quote:
Originally Posted by Slate
Okay, here we go. I love the idea of this cache. However, I don't follow a thing you guys are talking about as far as bowtie.csv+gsak-whatever. Has anyone else come up with a clever way (besides brdad) to find out how many maps they have cleared so far? I printed off a little map and plan to cross them out as I go. When I look at the map, and pull a town, I can usually remember if I have been there to cache, and then find what map it is in. Pretty time consuming, but doable. Any ideas?
Looks pretty good, I think you are almost there. I just found one error. It looks like 51.csv is wrong, it looks like a copy of 50.csv.Quote:
Originally Posted by tat
Thanks for taking all the time to put this together for everyone else to use.
I've been crossing off the maps on the back of my Gazetteer.Quote:
Originally Posted by cameoooooo
I also bought a 30x40" map of Maine, put it on a corkboard and I'm using pins to plot out northern Maine caches so I can figure out how to optimize my trips.
Pedalchick is making noises like I may have a problem, but hey, I can stop whenever I want...right?
I have been working with TAT on an EXCEL spreadsheet that gives the index page of the caches. If all goes well I will be available to download soon.
OK what do I do with all these numbers now. I know how to do the polygon on GSAK. Is there a way to import them or do I have to hand enter them. I'm sure I am just missing some obvious step here. Please HELP:eek:
In GSAK go to filter and there is a tab on the right named "arc/poly". Click on that tab. There is a button "load from file". Click on that and pick the .csv file for the map # you want to filter. Make sure you picked polygon as the filter type.Quote:
Originally Posted by Mainiac1957
Can you load all of them as a batch file or do they have to be loaded individually?
You could load all the points in one file, but then you would see all of the caches you found in Maine. What you want to know is which maps you have found a cache. I can't think of a way to which parts of the filter added caches and which ones didn't. But, applying the filters individually, it is easy to see if there are any finds with any particular filter.Quote:
Originally Posted by Haffy
I have it going now and it's working fine. Now I just have to get out and get the missing areas.
I fixed file 51.csv and hopefully that is the last error. Good luck and if any one has trouble, just post your questions here.
I was very intrigued by the DeLorme Challenge when I saw it but I probably will never get to log it.
When I saw what TAT had done with filters for GSAK it got my mind going to see what areas that I had gotten done. I worked on an EXCEL spreadsheet that can be used to find what index sheet they are in. It can accept data from a GSAK .csv file as input. If you enter all the Maine caches it provides insight into how many caches are in each index. If you just enter your “found” caches you will know where you have to go yet.
TAT has been a great help and has agreed to host the spreadsheet in an area where all can view it and download it to use. BE FORWARNED IT IS A 7 Mb file and will take some time if you are on dial-up. The data in the file now is from a Pocket Query run on 06/05/06 and includes 1205 caches that are active or unavailable. No archived caches.
You can go here to get the spreadsheet
http://www.gobozeman.net/thetiemans/...me calc R2.xls
I hope it helps.
You can PM me with comments, suggestions, and problems.
Once again Sabby, you impress me with your mad excel skills:D
I like the last one where you put the maps in the right graphical order.
Thanks.
Where do you guys come up with stuff. This is awesome. Thanks so much. I feel pretty lucky that I have already got some of the harder maps complete. I will be interested to see how many I have. I will play with that spread sheet and my cache page and see how many I have left.
You guys are the greatest.
Now that I downloaded the excel spreadsheet it is asking me what to use to open it with. So what do I use to open it with? I know I am puter illiterate.
Open it with Excel! LOL!Quote:
Originally Posted by Haffy
(It's a Microsoft spreadsheet program) :D :D
I suspect, John, that you do not have MS Excel on your computer. You could try the free Open Office software, available here:Quote:
Originally Posted by Haffy
http://www.openoffice.org/
which has an Excel compatible spreadsheet (though some advanced features may work differently or not at all). Be forewarned, it is a large download.
Cheryl and I are enjoying all of the buzz going on here. You folks certianly have shown your creativeness on creating something to solve your cache finds in each index page. I give all of you an A+. I was afraid no one would like the challenge but I think I was wrong....
Team Teebow 1
Tom T
The two biggest challenges are going to be getting enough time off from work to make the long drives north, and that nasty gas card bill at the end of the month:eek:Quote:
Originally Posted by team teebow
Planning this one has gotten the thinking cap working hard, thanks for the challenge.
Quote:
Originally Posted by Sabby
Awesome job!! Thanks!!:D
An updated version of the EXCEL spreadsheet has been posted. There is no data in the new version. You will have to add it from your GSAK export. Additional note has been added and the map has been refined. Go to the origional post to get the link.
Maybe some nice kind soul can put that into another format or file so I can download it as I don't use excel.
What spreadsheet do you use??
What formats can it read??
Spreadsheet? What's a spreadsheet? I use Microsoft word,thats all I know how to use and that is even iffy at times....lol
I don't know to say this nicely.
I think you have to invest in a Gazetteer and plot your finds with a pencil.
I don't know how to make the spreadsheet auto run nor do I know how to program in some computer language that would self run.
Can anybody help Haffy?
Quote:
Originally Posted by Sabby
Thats what I am trying to avoid but if that's the only way then I guess that's what I'll have to do then. Thanks anyway Sabby
Quote:
Originally Posted by Haffy
I jusst got done marking a new gazateer with all the Maine caches I have not yet done. That's about 725 caches, took me about 5 hours total. Here is a state map of all Maine caches using the Delorme back cover:
http://www.bytethebullet.com/geocach...s/delorme1.jpg
(800K JPG)
If you want to go the Watcher route like I do, haffy, I can send you an index file of all the profiles for the maps, so you can at least load any GPX file and sort by the maps.
Thanks Dave but I don't use watcher I use GSAK so don't know how that would be accomplished. Looks like you did a great job though putting all those caches on the map.
Maybe I can find out exactly what I have to do to put all my finds on the map at the event Saturday because don't know how to do it otherwise. I'm just thick I guess. :)
Quote:
Originally Posted by Haffy
Send me the GPX file of all your finds, and I'll put them on the map I just posted...