Thursday, August 26, 2010

The Planning File - MapSource to Excel

Note: If you click on any of the Pictures, it will open a new window which will also enlargen the file and picture






The above was the end result. The MapSource data acquisition is as follows

Select a route you want to analyse




You will be highlighting, copying the Waypoints in MapSource and pasting to the excel spreadsheet







Switch over to the Excel spreadsheet and select the Via Point Data tab



Back to the MapSource file. You already have the Route Properties up, select the Directions tab



Now activate Excel and select the Garmin Data tab



You now have acquired all the data from MapSource and put it in Excel. Via Email I will send the rest of the instructions in a Demo Excel File. I will also include a blank Worksheet files for the model. Have fun and enjoy

From time to time I may enhance this file. Let me know if you would like future enhancements. I will do my best to describe what the enhancements are.



2 comments:

Richard said...

Willie,
I'd love to have a copy of that Excel file. I set up something similar but it's very cumbersome to use. Yours looks like the cat's meow. It would keep me from having to set up routes in both mapsource and streets and trips. I use s&t just so I can figure in the times. If you'd send it to rngrant@comcast.net, I'd really appreciate it.
Thanks,
Rich

Keith said...

Hey Willie, I would also like to have a copy of your Excel sheet if that's cool. I do a lot in Excel and this may give me some good ideas for future use.

Are you also on the ZG/GTR fanatics forum? Noticed the C14 in your sig line on the FJR forum.

How'd ya do in the Titanic GT?

Keith
k1@krcarlson.net
2005 C10