New Release of My Conversion Spreadsheet available

1.4k · October 17, 2002

Just announcing the latest version of my Lat/long conversion spreadsheet which has lots of goodies for UK users. Some highlights are:

Enter 1000s of coordinates in up to 5 formats and convert them or export them

in 1 go. Try it for yourself - open the file and press "fill in the blanks"

and watch the magic happen!

Use it to open a Geocaching.com multicache page and watch it strip out all the

coordinates from the text - no more entering multicache information by hand!

Import waypoints from the most popular file formats:

Groundspeak EasyGPS

Microsoft Autoroute (CSV)

Waypoint Plus

QLD P&W

Provides conversions:

from DD MM SS, DD MM.MMM, DD.DDDD, UTM,UK National Grid

to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK National Grid

Provides links to:

JEEEP.COM

MAPQUEST

StreetMap.Co.Uk

Geocaching.com

Exports to:

Groundspeak EasyGPS

Microsoft Autoroute (CSV)

Waypoint Plus (Routes or Waypoints)

QLD P&W

Memory Map

All in a Significantly reduced file size!

How to get hold of it:

Go to http://www.sheps.clara.net/SSVersions.html and you can download the latest version from there.

Chris

"We're not lost - we just don't know where we are"

London & UK Geocaching Resources: http://www.sheps.clara.net

1.4k · November 1, 2002

The conversion spreadsheet has now been renamed "The Waypoint Workbench" to reflect the huge amount of functionality it provides.

This latest version represents a consolidation of the existing features, a few new features and some bug fixes.

The bugs fix various issues relating to Excel97 and versions of Windows the spreadsheet had not been tested on.

Extra Functionality is:

Import ExpertGPS

Export Mapsource

Distances now available in Statute and Metric

Straight Through Processing" Option which allows conversion directly between file formats.

How to get hold of it:

Go to http://www.sheps.clara.net/SSVersions.html and you can download the latest version from there.

Chris

Bear rescues a speciality!

London & UK Geocaching Resources: http://www.sheps.clara.net

November 1, 2002

Thumbs up to your spreadsheet guys, but one question.

I was wondering how do I get a printout of the spreadsheet?

I set it up yo print out a test page and it started to print out green!

I don't know anything about exel so I am probably doing something wrong!

Great work though.

I woke this morning and my boat was not rocking...for one horrid moment I thought I lived in a house!

1.4k · November 1, 2002

If you select File>Page Setup>Sheet>

then check Black & White - You should be OK.

Chris

Bear rescues a speciality!

London & UK Geocaching Resources: http://www.sheps.clara.net

November 4, 2002

Just to say a huge thanks to Chris for taking the time to put a feature on the conversion utility for me.

As a sailor I asked him what the chances were of having a nautical miles feature, and he sent me back the finished worksheet within a heartbeat.

Any other sailors out there will appreciate being able to convert to nautical.

Thanks Chris.

I woke this morning and my boat was not rocking...for one horrid moment I thought I lived in a house!

December 14, 2002

Hi all,

Is anyone successfully using the lite version on an iPAQ?

The sheet seems to be getting trashed on synch and won't open.

Ciemon

1.4k · December 15, 2002

quote:
Originally posted by Ciemon:
Hi all,

Is anyone successfully using the lite version on an iPAQ?

The sheet seems to be getting trashed on synch and won't open.

Ciemon

I originally tested it on some off the Ipaqs at work and it seemed to work ok. Do you get any error message at all?

Bear rescues a speciality!

London & UK Geocaching Resources: http://www.sheps.clara.net

December 15, 2002

Sure does Chris, not very helpful though:

An error occured while opening 'geocaching_Pam'.

I'm trying to open it on an iPAQ 3970 with PocketPC2002.

Ciemon

December 15, 2002

I get the same error trying to open it on a Cassiopeia 115.

1.4k · January 10, 2003

I have (finally) finished the next release of Waypoint Workbench Version 6.2. It Represents a series of improvements that have been requested by users - you asked for it so here it is.

The main enhancements are:

~~~~~~~~~~~~~~~~~~~~

Lots of bug fixes

Improved Speed on GPX Import (honestly!)

Added Minimum Recalc to improve performance

Added the option for distances in Nautical Miles

Added Antipodal Points (You know you need them!)

Added Projections

Added Waypoint+ imports in Lat/Long

Added NEMA Import

Brought all Settings under 1 Settings Button

Added Option for Memorymap Export Symbol

Download details

~~~~~~~~~~~~~~~

You can download from the usual place: http://www.sheps.clara.net/SSVersions.html

Bear rescues a speciality!

London & UK Geocaching Resources: http://www.sheps.clara.net

1.4k · July 17, 2003

NOW AVAILABLE - the next release of Waypoint Workbench Version 6.5. It Represents a series of improvements that have been requested by users - you asked for it so here it is.

The main enhancements are:

~~~~~~~~~~~~~~~~~~~~

Added coordinate stripping to GPX files (so you can get all the coords from a multi-cache).

GPX now imports cache Type.

Added Option for Distance/Bearing to be between Waypoints or from First Waypoint.

Added Option to set Home Coordinates on first line of WW.

Added MultiMap.com link

Added Export to EasyMPS

Memory Map option allows different icons for main waypoints to stripped waypoints.

Added ability to import multiple files.

Added Clear before import Option

and Many many bug fixes

Download details

~~~~~~~~~~~~~

You can download from the usual place: http://www.sheps.clara.net/WW.htm

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

1.8k · July 17, 2003

Brilliant Chris - you've put in all I asked for and some more besides. Defaulting to first row as home is really useful - many thanks

Member Geocaching Association of GB

July 17, 2003

Hi Chris,

One picky little buglet :-)

When clicking on any of the links it opens them in IE and not the default browser :-(

WoodSmoke

GeocacheUK - very useful resources for the UK Geocaching community

July 17, 2003

Thanks for the new release. I use your speadsheet on a regular basis and it has become invaluble to me.

Thanks

Chris

LASSITUDE- (noun) Tiredness and apathy: a state of weariness accompanied by listlessness or apathy[15th century. Via French from Latin lassitudo , from lassus 'weary'.]

1.4k · July 18, 2003

quote:
Originally posted by Wood Smoke:
Hi Chris,

One picky little buglet :-)

When clicking on any of the links it opens them in IE and not the default browser :-(

WoodSmoke

Hmmm,

Not sure what would cause that as I only issue a hyperlink function the rest is up to Microsoft Excel.

Though it would seem unlikely that MICROSOFT Excel running on MICROSOFT Windows would open in any other browser but MICROSOFT Internet Explorer - or am I just being cynical??

Chris

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

July 18, 2003

Hi Chris

I've never used your spreadsheet before so I may be doing something wrong. I've just downloaded it and clicked on the Settings button, and got the following:

Complie error: Automation type not supported in Visual Basic.

The text highlighted in VB is:

Public Function VB5Split(ByVal sIn As String, _

Optional sDelim As String = " ", _

Optional nLimit As Long = -1, _

Optional bCompare As VbCompareMethod = vbBinaryCompare) _

As Variant

Cheers,

Lisa

1.4k · July 18, 2003

quote:
Originally posted by Adam & Lisa:
Hi Chris

I've never used your spreadsheet before so I may be doing something wrong. I've just downloaded it and clicked on the Settings button, and got the following:

Complie error: Automation type not supported in Visual Basic.

The text highlighted in VB is:

Public Function VB5Split(ByVal sIn As String, _

Optional sDelim As String = " ", _

Optional nLimit As Long = -1, _

Optional bCompare As VbCompareMethod = vbBinaryCompare) _

As Variant

Cheers,

Lisa

Hi Lisa,

Someone else reported that problem last night - it's not something you are doing (or something I am doing). Can you let me know what version of Excel you are running so that I can pin the problem down. Also can you send me an email so that I can mail you a version to try out.

Thanks

Chris

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

1.4k · July 18, 2003

Hurrah!

I've sussed it! I fired up my dusty old Excel97 machine and discovered the problem.

The fix should be available from the usual place.

Sorry for any inconvenience.

Chris

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

July 18, 2003

Hi Chris

Yes, I'm using excel 97 (never saw the need to upgrade ).

I tried downloading the spreadsheet again and I'm getting the same error .

Lisa

July 18, 2003

quote:
Originally posted by Adam & Lisa:
Hi Chris

Yes, I'm using excel 97 (never saw the need to upgrade ).

I tried downloading the spreadsheet again and I'm getting the same error .

Lisa

Alas I'm getting the same error .

"Fear is temporary, regret is permanent!"

motley. adj. varied in appearance or character.

crew. n. group of people.

1.4k · July 18, 2003

Sorry the posting above read:

The fix should be available from the usual place.

when it should have read:

The fix should be available from the usual place, when I get home from work!

Try it now - should be OK.

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

July 18, 2003

quote:
Originally posted by Chris n Maria:
Sorry the posting above read:

_The fix should be available from the usual place._

when it should have read:

_The fix should be available from the usual place, when I get home from work!_

Try it now - should be OK.

If only life had an undo button....

London & UK Geocaching Resources: http://www.sheps.clara.net

That seems to have fixed the 'settings' problem - thanks. Will try it in earnest later.

Thanks for this program Chris & Maria, I find it very useful indeed.

"Fear is temporary, regret is permanent!"

motley. adj. varied in appearance or character.

crew. n. group of people.

July 18, 2003

At last - managed to download the fixed version (bloomin' dial-up internet account was playing up earlier). Thanks for the e-mail Chris - its looking peachy at the moment.

All the best,

Lisa

1.4k · November 20, 2003

Just to let you know that a new version of WW is available that fixes a few minor bugs.

The Fixes are:

~~~~~~~~~~~~~~~~~~~~

Fix for compatibility Issue with Excel97

Fix for GPX files with trackpoints in them.

Fix for HTML import of Mozilla Files

Fix for Geocaches with waypoints > GCFFFF

Fix for New GC.Com Page Layout

Download details

~~~~~~~~~~~~~

You can download from the usual place: http://www.sheps.clara.net/WW.htm

Chris

1.4k · January 26, 2004

Hi Folks,

Just to let you know that I have just uploaded a new release that allows you to read in speed camera files (csv) as supplied by http://www.pocketgps.co.uk/. I'm sure you honest lot won't need it - but you might have a "friend who does.

Get it from the usual place :

http://www.sheps.clara.net/WW.htm

Cheers

Chris

January 26, 2004

Just downloaded your latest version but I cant get it do to anything. When I click on any of your buttons I get the following message

macros in this workbook have been disabled because the security level is high, and the macros have not been signed or verified as safe. To run the macros, you can either have them signed or change your security level. Click help for more info.

I have clicked help but I am not making much sense of what its telling me!!

I have gone to

tools

macro

then settings and tried changing the settings with no difference, I am running windows Xp home eddition with XP office profesional any suggestions??

Cheers

Donnie

1.4k · January 26, 2004

Hi Donnie,

Go to Tools>Macro>Security & set it to medium.

Reopen the spreasheet & enable macros when it asks - then it should all work OK.

Cheers

Chris

January 26, 2004

Cheers

Got the buttons working now. cant seam to access the speed camera file I downloaded though.

Donnie

1.4k · January 26, 2004

Click Import Waypoints, then Browse, then Autoroute/Mapsource/Pocket GPS Safety Cameras under file type. Select the file & click OK.

January 26, 2004

Yip tried that and all I get is the following

A file named C:\waypointworkbench_error.xls already exists in this location do you want to replace it.

It doesnt matter if I click yes or no it then comes up with

Hmmm something has gone wrong with the code not sure what but Chris might etc etc etc. it then opens up the speed camera waypoint file in a normal excel page. after I click the ok or cancel button

I have been able to import a easygps file no problem at all and export them.

Cheers

Donnie

edit I have sent the error file via the email to you. It is nearly a Mb in size

Edited January 26, 2004 by Naefearjustbeer

3.3k · January 27, 2004

Thanks Chris, I'd tried this spreadsheet out many months ago, and didn't realise at the time that it plucked the multi-cache points/suggested parking places from the GPX files. I've recently started to enter these into my GPS manually when I decide I am definitely doing a cache. This will be a good time saver, thanks!

One request..... is it possible to enable the "Show name" option by default against each Memory-Map waypoint created in the MXF file? I'm assuming not as otherwise it would probably have been done .

(memory-map photos text removed and posted in a new thread, Stuey)

Thanks very much, I will make use of this I expect!

Edited January 27, 2004 by Stuey

1.4k · January 27, 2004

One request..... is it possible to enable the "Show name" option by default against each Memory-Map waypoint created in the MXF file? I'm assuming not as otherwise it would probably have been done .

Stuey,

Your not the first to ask but its not an option available to me in the file so not much I can do about that one. Sorry

Donnie,

I've mailed you back.

Chris

3.3k · January 27, 2004

One request..... is it possible to enable the "Show name" option by default against each Memory-Map waypoint created in the MXF file? I'm assuming not as otherwise it would probably have been done .

Stuey,

Your not the first to ask but its not an option available to me in the file so not much I can do about that one. Sorry

Chris

No need to apologise Chris, it's a demon piece of Excel coding. Nice one, thanks

January 27, 2004

Yip tried that and all I get is the following

A file named C:\waypointworkbench_error.xls already exists in this location do you want to replace it.

It doesnt matter if I click yes or no it then comes up with

Hmmm something has gone wrong with the code not sure what but Chris might etc etc etc. it then opens up the speed camera waypoint file in a normal excel page. after I click the ok or cancel button

I have been able to import a easygps file no problem at all and export them.

Cheers

Donnie

edit I have sent the error file via the email to you. It is nearly a Mb in size

I get exactly the same.............

1.4k · January 27, 2004

I get exactly the same.............

Hmmm,

there seems to be a difference between the data I tested on and what is there now. I'll see if I can fix it.

Cheers

Chris

Edited January 27, 2004 by Chris n Maria

1.4k · January 28, 2004

Right,

I've just uploaded a version that should work with speed camera files OK. Sorry for that - no idea how my test data got to be completly different!

Cheers

Chris

January 29, 2004

Cheers Chris,

Works a treat! (And a lot quicker than cutting and pasting)

Neil

January 29, 2004

Excellent Chris,

Many thanks for such an excellent bit of software. The gatso import worked a treat.

Edited January 29, 2004 by The Cuthberts

New Release of My Conversion Spreadsheet available

Recommended Posts

Join the conversation