Welcome to Motorhomefacts, we are a thriving motorhome community (Largest in Europe). Why Not JOIN NOW and get instant access to more of the website. It costs nothing to join and only takes a few minutes. We have 200,000 different people visiting our site monthly and this amount of motorhomers in one place guarantees a fast response to any questions you may have. We also have unique facilities not found elsewhere such as our Online Logbook, stopover tracker, Motorhome directory with Ebay type feedback and the largest repository of motorhome campsites reviews found anywhere
I have 118 GPS co-ordinates in an EXCEL spreadsheet, listed in the decimal format e.g. 52.12345 / 6.56789.
They were recorded from TOMTOM manually each evening (or fudged by looking at Google Earth at a later date).
Is there a way to drop or import this data into a programme (like Google Maps or Earth) which will then show me a plotted course for our journey?? I'd really like to take a screenshot for our blog! Plus it'd help us visualize the drive thus far.
For the techies amongst you:
Currently column A has the day no. of our trip (1 to 100), column B has the date of the stopover (in the format '24th June 2009'), C has the lat value, D has the lon value. Should i format the columns in a particular way prior to import??
Any suggestions greatly received!
Massive thanks in advance!
I can submit the file (.XLS) if necessary.
Note: some co-ords are repeated as we spent several days in one place, therefore the actual no. of GPS values may be nearer 80 than 100.
In Autoroute, go to File > New > Import Data Wizard.
Follow the dialogue boxes and choose "Comma" when asked to Choose the character that separates your fields.
If your first row does not contain column headings, untick the relevant box at the next step - and don't forget to specify which country the places are located.
______________________________________________________________ When confronted by a problem, you can solve it easily by reducing it to the question, "How would the Lone Ranger have handled this?"
Hi Steve the new version of Tyre is for the Garmin as well, but no idea if its Mac compatable.
Just to clarify Tyre will plot a route between points if you load the file into it, and calculate the distance, as far as I know the others don't, they just show the poi's on the map.
And yes Mike your programme will convert to Kml as will my favourite, poiedit
Unfortunately I do not own Autoroute, so i think Google Earth or 'Open Street Maps' are my only alternative.
I've attached the reworked file as an example of the formatting...
date is dd/mm/yyyy hh:mm format, but i think Google Earth mistakes this for a place name?
Ideally the output of all this would be a visual map showing the journey from start to finish, including the movement between points like you see on a google maps itinerary. I could remove some repeated values to simplify it a little! Place name are available in separate sheet (v.easy to marry up).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
All times are GMT + 1 Hour Page 1 of 2Goto page 1, 2Next
Morocco
) :
