+Chris n Maria Posted October 17, 2002 Share Posted 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 Quote Link to comment
+Chris n Maria Posted November 1, 2002 Author Share Posted 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 Quote Link to comment
+The Merman Posted November 1, 2002 Share Posted 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! Quote Link to comment
+Chris n Maria Posted November 1, 2002 Author Share Posted 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 Quote Link to comment
+The Merman Posted November 4, 2002 Share Posted 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! Quote Link to comment
Ciemon Posted December 14, 2002 Share Posted 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 Quote Link to comment
+Chris n Maria Posted December 15, 2002 Author Share Posted 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 Quote Link to comment
Ciemon Posted December 15, 2002 Share Posted 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 Quote Link to comment
neilt Posted December 15, 2002 Share Posted December 15, 2002 I get the same error trying to open it on a Cassiopeia 115. Quote Link to comment
+Chris n Maria Posted January 10, 2003 Author Share Posted 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 Quote Link to comment
+Chris n Maria Posted July 17, 2003 Author Share Posted 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 Quote Link to comment
+John Stead Posted July 17, 2003 Share Posted 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 Quote Link to comment
+Wood Smoke Posted July 17, 2003 Share Posted 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 Quote Link to comment
+Lassitude Posted July 17, 2003 Share Posted 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'.] Quote Link to comment
+Chris n Maria Posted July 18, 2003 Author Share Posted 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 Quote Link to comment
+minstrelcat Posted July 18, 2003 Share Posted 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 Quote Link to comment
+Chris n Maria Posted July 18, 2003 Author Share Posted 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 Quote Link to comment
+Chris n Maria Posted July 18, 2003 Author Share Posted 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 Quote Link to comment
+minstrelcat Posted July 18, 2003 Share Posted 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 Quote Link to comment
+Hi-Tek Posted July 18, 2003 Share Posted 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. Quote Link to comment
+Chris n Maria Posted July 18, 2003 Author Share Posted 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 Quote Link to comment
+Hi-Tek Posted July 18, 2003 Share Posted 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. Quote Link to comment
+minstrelcat Posted July 18, 2003 Share Posted 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 Quote Link to comment
+Chris n Maria Posted November 20, 2003 Author Share Posted 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 Quote Link to comment
+Chris n Maria Posted January 26, 2004 Author Share Posted 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 Quote Link to comment
+Naefearjustbeer Posted January 26, 2004 Share Posted 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 Quote Link to comment
+Chris n Maria Posted January 26, 2004 Author Share Posted 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 Quote Link to comment
+Naefearjustbeer Posted January 26, 2004 Share Posted January 26, 2004 Cheers Got the buttons working now. cant seam to access the speed camera file I downloaded though. Donnie Quote Link to comment
+Chris n Maria Posted January 26, 2004 Author Share Posted January 26, 2004 Click Import Waypoints, then Browse, then Autoroute/Mapsource/Pocket GPS Safety Cameras under file type. Select the file & click OK. Quote Link to comment
+Naefearjustbeer Posted January 26, 2004 Share Posted January 26, 2004 (edited) 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 Quote Link to comment
+Stuey Posted January 27, 2004 Share Posted January 27, 2004 (edited) 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 Quote Link to comment
+Chris n Maria Posted January 27, 2004 Author Share Posted 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 Quote Link to comment
+Stuey Posted January 27, 2004 Share Posted 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 Quote Link to comment
+Lost in Space Posted January 27, 2004 Share Posted 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............. Quote Link to comment
+Chris n Maria Posted January 27, 2004 Author Share Posted January 27, 2004 (edited) 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 Quote Link to comment
+Chris n Maria Posted January 28, 2004 Author Share Posted 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 Quote Link to comment
+Lost in Space Posted January 29, 2004 Share Posted January 29, 2004 Cheers Chris, Works a treat! (And a lot quicker than cutting and pasting) Neil Quote Link to comment
The Cuthberts Posted January 29, 2004 Share Posted January 29, 2004 (edited) Excellent Chris, Many thanks for such an excellent bit of software. The gatso import worked a treat. Edited January 29, 2004 by The Cuthberts Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.