Chris n Maria's Geocaching Homepage View Our Guestbook
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

None of the buttons are workings

Importing/Entering Waypoints

How to view and Convert Coordinates

Exporting Waypoints from the Spreadsheet

Using Waypoint Workbench and GSAK to strip intermediate waypoints from GPX files

Help - None of the buttons are working

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.

Importing/Entering Waypoints

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:

  • EasyGPS
  • Multicache Page
  • CSV (AutoRoute/MapPoint)
  • Txt (Waypoint Plus)
  • QLD P&W Service

All files are imported in the same way except 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 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  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 Cache Page and point it to the file you have just created.

The coordinates will now arrive into the spreadsheet:

How to view and Convert Co-ordinates

Converting coordinates

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).

Exporting Waypoints from the Spreadsheet

Now you have processed your waypoints you can export the file in the following formats:

  • EasyGPS
  • CSV (for Autoroute/MS MapPoint)
  • MemoryMap
  • QLD P&W Service
  • WaypointPlus (Route or waypoints)

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.