Guest chris n maria Posted January 31, 2002 Share Posted January 31, 2002 Hi Folks, I have just developed an excel spreadsheet that converts between the different formats for Latitiude and Longitude. The idea is that because it does not use macros it should work on Palm & CE machines. It is completly free to use (and always will be!). Anyway if you would like a copy mail me: (Chris@fabalou.com) Chris Quote Link to comment
Guest chris n maria Posted February 4, 2002 Share Posted February 4, 2002 Hi Folks, Just to let you know that (by popular demand) I have added the conversions to UTM now. Mail me if you want a copy. Chris Quote Link to comment
Guest oldcrow Posted February 4, 2002 Share Posted February 4, 2002 How do I email you? I cannot find an address! Quote Link to comment
Guest chris n maria Posted February 4, 2002 Share Posted February 4, 2002 Sorry, you had to look further up the page - it's: Chris@fabalou.com Chris Quote Link to comment
Guest oldcrow Posted February 5, 2002 Share Posted February 5, 2002 Oops...that is what happens when you get in a hurry; sorry I missed it! Quote Link to comment
Guest chris n maria Posted February 7, 2002 Share Posted February 7, 2002 release three is now available which features the conversions from and to: All three Latitude and Longitude formats UTM(WGS84) And new for version (3.0) it converts from all the above formats in to UK Grid references. ------------------ ~~~~~ Chris Quote Link to comment
Guest glenn95630 Posted February 7, 2002 Share Posted February 7, 2002 Chris emailed the spreadsheet to me and it is excellent! ...top notch! ...way cool! ...two thumbs up! Quote Link to comment
Guest crusso Posted February 7, 2002 Share Posted February 7, 2002 Chris, How do I know what version I have? U emailed me one a couple days ago. Chris Quote Link to comment
Guest glenn95630 Posted February 7, 2002 Share Posted February 7, 2002 Click on the "FAQ" button. Quote Link to comment
Guest chris n maria Posted February 7, 2002 Share Posted February 7, 2002 quote:Originally posted by crusso:Chris, How do I know what version I have? U emailed me one a couple days ago. Chris I would normally (as promised in the FAQs) have sent out the latest version to all my existing users. But this release only added UK National Grid to the functionality so I figured wasn't worth sending out to all my existing users - most of whom are in the US. I will send everyone the next release when, it is complete. I have planned for it: Conversion from UK national grid to all formats. Possibly NAD27 conversions (if I can understand how it is supposed to work!) If anyone wants any more functionality - Post here and I will see what I can do. ------------------ ~~~~~ Chris Quote Link to comment
Guest chris n maria Posted February 16, 2002 Share Posted February 16, 2002 FYI, I have become aware that at the moment the spreadsheet does not run with Docs To Go v4.0. It seems to be their bug not mine. I'm currently awaiting a fix from their tech support and will let you know when it is available. Chris ------------------ Chris We are not lost, we just don't know where we are.. Quote Link to comment
Guest chris n maria Posted February 28, 2002 Share Posted February 28, 2002 Just bumping it up to the top - we have 35 user so far Quote Link to comment
Guest Zuckerruebensirup Posted March 2, 2002 Share Posted March 2, 2002 quote:Originally posted by chris n maria:Anyway if you would like a copy mail me You have mail! [This message has been edited by Zuckerruebensirup (edited 02 March 2002).] Quote Link to comment
Guest Zuckerruebensirup Posted March 2, 2002 Share Posted March 2, 2002 quote:Originally posted by chris n maria:Anyway if you would like a copy mail me You have mail! [This message has been edited by Zuckerruebensirup (edited 02 March 2002).] Quote Link to comment
+Chris n Maria Posted March 7, 2002 Share Posted March 7, 2002 We seem to have resolved the problems with Docs-To-Go so I will be sending out a new version to all current users Real Soon. The new version will consist of 2 Sheets: The current Standard one that contains Links to Sites & the FAQs. A Second "lite" version formatted for use on Palms. Quote Link to comment
+Chris n Maria Posted March 8, 2002 Share Posted March 8, 2002 Attached is the latest version of the Spreadsheet which now comes in two flavours Regular and Lite (for Palm users). This Release Includes: Lite Version ~~~~~~~~~~ Conversion from DD MM SS, DD MM.MMM, DD.DDDD, UTM to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid Regular Version ~~~~~~~~~~~ All of the above plus The results link to: JEEEP.COM MAPQUEST Nearest Caches Ordnance Survey StreetMap.Co.Uk UK National Cycle Network Planned Future enhancements: ~~~~~~~~~~~~~~~~~~~~~ Conversion From UK Grid reference Test on Windows CE Machine NAD Conversion (Maybe) Existing Users it should be in your in box by now Chris "We're not lost - we just don't know where we are" Quote Link to comment
+Chris n Maria Posted March 8, 2002 Share Posted March 8, 2002 Attached is the latest version of the Spreadsheet which now comes in two flavours Regular and Lite (for Palm users). This Release Includes: Lite Version ~~~~~~~~~~ Conversion from DD MM SS, DD MM.MMM, DD.DDDD, UTM to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid Regular Version ~~~~~~~~~~~ All of the above plus The results link to: JEEEP.COM MAPQUEST Nearest Caches Ordnance Survey StreetMap.Co.Uk UK National Cycle Network Planned Future enhancements: ~~~~~~~~~~~~~~~~~~~~~ Conversion From UK Grid reference Test on Windows CE Machine NAD Conversion (Maybe) Existing Users it should be in your in box by now Chris "We're not lost - we just don't know where we are" Quote Link to comment
+Chris n Maria Posted March 11, 2002 Share Posted March 11, 2002 Some users have made me aware that the lite version dosn't run on Casiopeias. I am investigating (on marias' Casiopeia ) and will post here if I get a fix. Chris "We're not lost - we just don't know where we are" Quote Link to comment
Max Wedge Posted March 11, 2002 Share Posted March 11, 2002 A big hearty vote for a NAD conversion!! _ __ ____________________________________________________________ __ _ On my first day of school, my parents dropped me off at the wrong nursery -- there I was, surrounded by trees and shrubs..... Quote Link to comment
Max Wedge Posted March 11, 2002 Share Posted March 11, 2002 A big hearty vote for a NAD conversion!! _ __ ____________________________________________________________ __ _ On my first day of school, my parents dropped me off at the wrong nursery -- there I was, surrounded by trees and shrubs..... Quote Link to comment
+Chris n Maria Posted March 13, 2002 Share Posted March 13, 2002 quote:Originally posted by Max Wedge: A big hearty vote for a NAD conversion!! Okey Dokey I will Look at it - there wil propably end a third sheet "Family Size?" which includes the Macros to do this and output a lot of co-ords to EasyGPS. Don't hold your breath for it - I'm usually out caching rather than coding Chris "We're not lost - we just don't know where we are" Quote Link to comment
+Chris n Maria Posted March 13, 2002 Share Posted March 13, 2002 quote:Originally posted by Max Wedge: A big hearty vote for a NAD conversion!! Okey Dokey I will Look at it - there wil propably end a third sheet "Family Size?" which includes the Macros to do this and output a lot of co-ords to EasyGPS. Don't hold your breath for it - I'm usually out caching rather than coding Chris "We're not lost - we just don't know where we are" Quote Link to comment
+Chris n Maria Posted April 5, 2002 Share Posted April 5, 2002 This Release Includes: Lite Version ~~~~~~~~~~ Conversion from DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid Regular Version ~~~~~~~~~~~ All of the above plus The results link to: JEEEP.COM MAPQUEST Nearest Caches Ordnance Survey StreetMap.Co.Uk UK National Cycle Network Planned Future enhancements: ~~~~~~~~~~~~~~~~~~~~~ Test on Windows CE Machine NAD Conversion (Maybe) Creation of EasyGPS file Existing Users it should be in your in box by now Chris "We're not lost - we just don't know where we are" London & UK Geocaching Resources: http://www.sheps.clara.net/Index.html Quote Link to comment
+Chris n Maria Posted April 5, 2002 Share Posted April 5, 2002 This Release Includes: Lite Version ~~~~~~~~~~ Conversion from DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK Naional Grid Regular Version ~~~~~~~~~~~ All of the above plus The results link to: JEEEP.COM MAPQUEST Nearest Caches Ordnance Survey StreetMap.Co.Uk UK National Cycle Network Planned Future enhancements: ~~~~~~~~~~~~~~~~~~~~~ Test on Windows CE Machine NAD Conversion (Maybe) Creation of EasyGPS file Existing Users it should be in your in box by now Chris "We're not lost - we just don't know where we are" London & UK Geocaching Resources: http://www.sheps.clara.net/Index.html Quote Link to comment
+Chris n Maria Posted April 11, 2002 Share Posted April 11, 2002 Now added new Bulk option. This does all version 3.5 did plus allows the conversion of multiple waypoints which it will the export straight into EasyGPS for downloading to your GPS Mail me if you would like a copy - Existing Users it should be in your in box by now For more info see the website below Chris "We're not lost - we just don't know where we are" London & UK Geocaching Resources: http://www.sheps.clara.net/Index.html Quote Link to comment
+Chris n Maria Posted April 11, 2002 Share Posted April 11, 2002 Now added new Bulk option. This does all version 3.5 did plus allows the conversion of multiple waypoints which it will the export straight into EasyGPS for downloading to your GPS Mail me if you would like a copy - Existing Users it should be in your in box by now For more info see the website below Chris "We're not lost - we just don't know where we are" London & UK Geocaching Resources: http://www.sheps.clara.net/Index.html Quote Link to comment
+Chris n Maria Posted April 17, 2002 Share Posted April 17, 2002 We're Celibrating tonight as we have just hit our 100th request for the spreadsheet. Anymore needy souls out 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
+Waterboy Posted April 17, 2002 Share Posted April 17, 2002 This is a PUBLIC THANK YOU. Quote Link to comment
+Chris n Maria Posted May 1, 2002 Share Posted May 1, 2002 Any more users need a copy? Update for current users: I'm Currently working with some Australian Conservation Rangers to get UTM conversions working correctly for Southern Hemisphere. Northern Hemisphere UTM conversion seems to work OK. Next release will include Export to Autoroute and DBF. Plus I'm currently working on post-code conversion for UK & US. 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
+Alan2 Posted May 1, 2002 Share Posted May 1, 2002 Tks, that's interesting. Does anyone know if conversion from dd mm.mmm to UTM in the southern hemisphere work in GPS units? I have a Vista. Alan Quote Link to comment
+Chris n Maria Posted May 2, 2002 Share Posted May 2, 2002 quote:Originally posted by Alan2: Tks, that's interesting. Does anyone know if conversion from dd mm.mmm to UTM in the southern hemisphere work in GPS units? I have a Vista. Alan I should think they do... The problem with My Spreadsheet seems to be a fix I put in to correct for an extra 1 appearing in front of Northern Hemisphere UTMs - Apart from that the calc is the same. Tesing is taking a while (with timezones etc) but should be fixed RSN. 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 June 28, 2002 Share Posted June 28, 2002 Okey Dokey, I Finaly found some time to work on a new version of this - been to busy caching. in the end the only solution to getting more time to work on it was to do it at work This Release features the fix for southern hemisphere problems plus the ability to export to CSV for use with Autoroute. Existing users - it will be in your mailbox in a few hours (once I get home from wotk!) 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 June 28, 2002 Share Posted June 28, 2002 Okey Dokey, I Finaly found some time to work on a new version of this - been to busy caching. in the end the only solution to getting more time to work on it was to do it at work This Release features the fix for southern hemisphere problems plus the ability to export to CSV for use with Autoroute. Existing users - it will be in your mailbox in a few hours (once I get home from wotk!) 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 July 12, 2002 Share Posted July 12, 2002 After repeated requests I have now made this available as a download direct from my website: http://www.sheps.clara.net Hope you find it of use. 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 August 16, 2002 Share Posted August 16, 2002 Now available for download is a Mass conversion version of the spreadsheet. It will allow you to enter 1000s of coordinates in up to 5 formats and convert them or export them in 1 go. Why not try it for yourself - open the file and press "fill in the blanks" and watch the magic happen! 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 plus links to: JEEEP.COM MAPQUEST StreetMap.Co.Uk Exports to: EasyGPS Autoroute. It can be found at http://www.sheps.clara.net/SSVersions.html I Recommend downloading the zipped version as the unzipped is very large. This version uses macros - for more information and help goto: http://www.sheps.clara.net/Utils.html 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
Syncro Posted August 18, 2002 Share Posted August 18, 2002 Hi Chris, do you plan a conversion for the german grid with Potsdam Date??? That would really be great. So far Syncro Quote Link to comment
+Chris n Maria Posted August 19, 2002 Share Posted August 19, 2002 quote:Originally posted by Syncro:Hi Chris, do you plan a conversion for the german grid with Potsdam Date??? That would really be great. So far Syncro Hi Syncro, I would love to do a version for German grid but I have no idea what the calculations are. Most of the explinations I can find are in German & I don't speak German. If you could find 1 of the following: 1. An Excel Sheet that does the conversion to 1 of my existing formats. 2. Visual Basic Source code that does the conversion. 3. An Explination of the caclulations in English. I will see if I can Help. Cheers Chris 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
Syncro Posted August 19, 2002 Share Posted August 19, 2002 Hi Chris, I'll try to get these infos for you... Regards Syncro Quote Link to comment
Syncro Posted August 20, 2002 Share Posted August 20, 2002 Hi Chris, does this link help you??? http://groups.google.com/groups?q=%2Btransformation+%2Butm+%2Bgauss&hl=de&lr=&ie=UTF-8&safe=off&selm=6nipt9%24s6l%241%40news.iastate.edu&rnum=1 So far Syncro Quote Link to comment
+Chris n Maria Posted August 20, 2002 Share Posted August 20, 2002 quote:Originally posted by Syncro:Hi Chris, does this link help you??? Yes, Seems far to easy but - I'll have a go at including it. Probably won't be for a week or so, as I'm on holiday soon. cheers Chris 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
+Trees Posted August 21, 2002 Share Posted August 21, 2002 Got the spreadsheet but cant open it. What program do I use? Wordperfect? Word? Need help. Thanks, Trees Quote Link to comment
Syncro Posted August 21, 2002 Share Posted August 21, 2002 Hi Trees, think you'll need MS Excel... Regards Syncro Quote Link to comment
+Trees Posted August 22, 2002 Share Posted August 22, 2002 Thanks Syncro for the help, will get a copy. Trees. Quote Link to comment
+Chris n Maria Posted September 28, 2002 Share Posted September 28, 2002 Just bumping it to the top to see if there are more users out there. So if you want it come and get it from here. I'm currently working on German grid conversions, the ability to hide formats you don't need plus more import & export formats. 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 October 17, 2002 Share Posted October 17, 2002 Just announcing the latest version of my Lat/long conversion spreadsheet - it represents a major leap forward in functionality. 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
Syncro Posted October 22, 2002 Share Posted October 22, 2002 Hi Chris, how far is the German Grid conversion? Regards Syncro Quote Link to comment
+Chris n Maria Posted October 23, 2002 Share Posted October 23, 2002 quote:Originally posted by Syncro:Hi Chris, how far is the German Grid conversion? Regards Syncro Hi Syncro, I haven't got very far with it at the moment - I've been too busy caching. Now it's getting dark and wet I may have more time to attempt it. Heres Hopeing. 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 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
+Chris n Maria Posted January 10, 2003 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 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
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.