kjunmed Posted March 2, 2019 Report Share Posted March 2, 2019 Hello Saifan Pilot, I am having a terrible time trying get this data to convert. I keep getting "Runtime error 13" "Type Mismatch" . I have gone through the data several times and can not fine the error. If you could look over this data and maybe give me some insight on where I am failing? I would greatly appreciate any help you can give me. Thanks for taking your time to write this program. I am running this on an Macbook Pro using office 365 Quote Link to comment Share on other sites More sharing options...
kjunmed Posted March 2, 2019 Report Share Posted March 2, 2019 A great Tool, I was able to find my errors after putting a way for the night and coming back this AM. Quote Link to comment Share on other sites More sharing options...
krizkaoz Posted March 10, 2019 Report Share Posted March 10, 2019 Hey guys, this spreadsheet sounds like exactly what I'm looking for but the links don't work. I'm currently plotting waypoints to visit on Viewranger from Excel by hand, it takes ages. I'm in Northern Ireland and the data comes in the form of an excel spreadsheet, Irish grid letter directly followed by easting and northing in one cell. If this spreadsheet will help can someone please send it to me? Cheers. Quote Link to comment Share on other sites More sharing options...
swanie Posted March 25, 2019 Report Share Posted March 25, 2019 Hey Krizkaoz make an account to access the file. Thanks Saifan Pilot for making this.. Cheers, Tom Quote Link to comment Share on other sites More sharing options...
Saifan Pilot Posted April 3, 2019 Author Report Share Posted April 3, 2019 On 3/10/2019 at 11:06 AM, krizkaoz said: Hey guys, this spreadsheet sounds like exactly what I'm looking for but the links don't work. I'm currently plotting waypoints to visit on Viewranger from Excel by hand, it takes ages. I'm in Northern Ireland and the data comes in the form of an excel spreadsheet, Irish grid letter directly followed by easting and northing in one cell. If this spreadsheet will help can someone please send it to me? Cheers. https://www.dropbox.com/s/yt4dsrxanr2n72i/Excel2GPS v3.00.xlsm?dl=0 Quote Link to comment Share on other sites More sharing options...
orin Posted April 15, 2019 Report Share Posted April 15, 2019 Hi, Just wanted to add my kudos/thanks for your work on this spreadsheet. I've was looking for a way to convert on my Mac for survey work and found your solution. Perfect!! Thanks again. Orin Quote Link to comment Share on other sites More sharing options...
Saifan Pilot Posted April 18, 2019 Author Report Share Posted April 18, 2019 On 4/15/2019 at 3:15 PM, orin said: Hi, Just wanted to add my kudos/thanks for your work on this spreadsheet. I've was looking for a way to convert on my Mac for survey work and found your solution. Perfect!! Thanks again. Orin Glad you found it useful. I often got customers who would give me hundreds of waypoints in a spreadsheet and they had no idea how to convert them to a useable GPS file, so I figured I had to come up with something on my own Quote Link to comment Share on other sites More sharing options...
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.