|Chris n Maria's Geocaching Homepage||
Sign Our Guestbook
|Waypoint WorkBench||Caching in London||UK Caching Resources||Trig Points||Galleries||The CWNM Project||Krazy Koala||Cache Cameras||Coal Posts||Links|
Help on Using Waypoint Workbench
Waypoint Workbench relies on the Macro functionality within Excel, this is often disabled in later versions of Excel. You will need to enable it by openining Excel the selecting from the menu Tools>Macros>Securtiy. Then set the security level to medium.
Waypoint Workbenc allows entry of coordinates from various file formats or you can type or copy and paste the values straight into the spreadsheet. The formats currently supported are:
All files are imported in the same way except Geocaching.com Multicache Page which needs you to save the webpage before you import the file.
Importing a file - General Instructions.
With the Spreadsheet open, click on the Import Waypoints button at the top of the screen:
A Dialog appears which request the Import type and filename:
Select the type of file you wish to import and then click on Browse to select a file. NB: the OK button will not be enabled until the system can find the file you have selected.
The coordinates within the file will now be loaded into the spreadsheet.
Now You are ready to work with the data:
Importing a File - Specific Instructions for Geocaching.com Multicache Page
An Inconvenience with Multicaches is the need to input lots of co-ordinates by hand as you can't download them direct from Geocaching.com. Imagine if there was a system that could take a cache page and strip out all the waypoints from the page wherever they were. Well imagine no more this spreadsheet does just that.
In order to open a multi cache page you will need to do the following. Open the multicache page in your web browser and select File>SaveAs to save the page to your hard drive:
From the spreadsheet click Import Waypoints.
Select Geocaching.com Cache Page and point it to the file you have just created.
The coordinates will now arrive into the spreadsheet:
Once you have some waypoints in the spreadsheet it is a simple matter to convert them between the different formats. Simply click on Fill in Blanks:
The Spreadsheet will then fill in any areas that you have not completed yourself and add some hyperlinks to enable you to view maps of the location.
Changing the information you see
You might find some of the columns on the worksheet to be extraneous to your requirements. In order to to change the columns you see click on Show/Hide Columns:
This displays a dialog which allows you to select which columns you want to view:
Select the columns you are interested in and click OK. (Your changes are saved in the file and remembered for next time).
Now you have processed your waypoints you can export the file in the following formats:
The process for all of these is similar except EasyGPS which offers you the option of opening up EasyGPS once the file has been downloaded.
Exporting a File - General Instructions
First Click on Export Waypoints :
Then Select the file type you wish to create and the filename of the file:
Click OK and the file is created.
Exporting a File - EasyGPS Instructions
When Exporting to EasyGPS you have the option of automatically opening the file in EasyGPS once the download is complete. To do this Select the correct location for where your EasyGPS program file is and Click OK.
If you do not wish to run EasyGPS select the Don't run Easy GPS check box.