MapForums
Community of VE/MapPoint Users and Developers
Exporting "located" data points to excel
This is a discussion on Exporting "located" data points to excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I've imported a data set as a set of pins based on addresses. I've then used the "Find Nearby Places" ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-04-2005
| |||
| |||
| Exporting "located" data points to excel On my data sets down the left hand side, I can see it's picked out each of these points individually, and given a "distance". What I'd like to do now is simply export these points, along with the distance, to excel. I can't find a way of doing this! The only thing that seems to work is to manually draw a radius to match by eye. There must be an easier, and more precise, way? Any help most appreciated (Mappoint 2004 Europe)         |
|
04-06-2005
| |||
| |||
|
Anyone? How about instead (if it's easier) - a list of postcodes in a single Excel column, a single reference postcode in a separate cell, then a macro that compares the reference to each postcode and enters a distance between each in the adjacent column eg. Ref: WA22 2RS RM22 2QR 396km N4 3QR 384km etc. |
|
04-06-2005
| ||||
| ||||
|
You will need a little bit of programming to automate the process you've tried by hand: Find the location of the new postcode. Measure the distance from the reference location to the new location. Save that value. Or if you pre-load your data into MapPoint as pushpins, you could use my MileCharter product to do this (see links below). As well as straight line distances, this would also be able to find route distances amongst other things. Richard
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
 |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting the "show or hide places" | jhoffend | MapPoint 2006/2009 Discussion | 5 | 09-20-2007 12:43 PM |
| addin-form with behavior as "Extras-Geopositon"-fu | Th.M.Mädzulat | MapPoint 2006/2009 Discussion | 0 | 12-20-2005 09:37 AM |
| Disable "Export to Excel" | Anonymous | MapPoint 2006/2009 Discussion | 2 | 01-25-2005 06:58 AM |
| How to disable the "show the data by" function | Anonymous | MapPoint 2006/2009 Discussion | 0 | 06-02-2004 09:00 AM |
| Do I need "Autoroute Europe", if I install "M | bigtail | MapPoint 2006/2009 Discussion | 1 | 03-23-2004 11:58 PM |
All times are GMT -5. The time now is 09:09 AM.
