Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Exporting "located" data points to excel

This is a discussion on Exporting "located" data points to excel within the MapPoint Desktop 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" ...

  1. #1
    Jonboy is offline Junior Member White Belt
    Join Date
    Apr 2005
    Posts
    5

    Exporting "located" data points to excel

    I've imported a data set as a set of pins based on addresses. I've then used the "Find Nearby Places" to show all points within a 25km radius of a point of interest.

    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)

  2. #2
    Jonboy is offline Junior Member White Belt
    Join Date
    Apr 2005
    Posts
    5
    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.

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exporting the "show or hide places"
    By jhoffend in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 09-20-2007, 01:43 PM
  2. addin-form with behavior as "Extras-Geopositon"-fu
    By Th.M.Mädzulat in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-20-2005, 10:37 AM
  3. Disable "Export to Excel"
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-25-2005, 07:58 AM
  4. How to disable the "show the data by" function
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-02-2004, 10:00 AM
  5. Do I need "Autoroute Europe", if I install "M
    By bigtail in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-24-2004, 12:58 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96