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

Mapping distance between our Businesses and Clients

This is a discussion on Mapping distance between our Businesses and Clients within the MapPoint Desktop Discussion forums, part of the Map Forums category; Greetings all! It is great to become a member of your site. My question is this: The company I work ...

  1. #1
    ashrout is offline Junior Member White Belt
    Join Date
    Dec 2004

    Mapping distance between our Businesses and Clients

    Greetings all! It is great to become a member of your site.

    My question is this:

    The company I work for has over 600 locations, which I have mapped using MapPoint 2002. A client recently contacted us who has 1300 customer reps throughout the country, which I have also mapped. They would like to use our business services. To do this, we need to find our closest location to each of their closest reps.

    Is there a way to do this? Currently, I locate one of their reps and find the closest facility to them. I then export both their information and our information for the closest location (in miles) into excel. I then copy and paste each export into a master excel sheet to provide the customer the closest facility for that particular rep and so on.

    Isn't there an easier way that MapPoint can compare two variables (my business and my customers) to then tell me the closest location for each of their respective locations?

    I do not care if we have a rep in Montana and the closest store for them is Chicago, IL. Or if it tells me we have 30 stores in Los Angeles and they have 150 representatives there. I just want to know of those 30 stores, which is the closest, in miles, to each of those reps. Only I want to do this nationwide without having to wast 25 hours doing this manually?

    Thank you all so much in advance for this long post, but I really need all of your help!

    Thanks again,


  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Blog Entries
    Using some Visual Basic programming you could draw radii, use the QueryShape method, and export to Excel.

    There are GIS programs that would make this easier, but you'd have to get another package, export the coordinates of your locations and the customer locations using something like the Pushpin Tool, load the points into the GIS, and pour through the GIS package's manual -- maybe not a bad investment, but also not a slam-dunk without someone to guide you through it.

    The short answer it, there's no easy way to get it accomplished immediately, but hopefully the two suggestions above can get you started on the right track without doing them all manually.

    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Blog Entries
    You could use my MileCharter program to batch calculate all the distances. With the kinds of numbers you're talking about it will take a while to compute (a day?). You would then have a huge table full of distances, and you can either manually find the shortest distances, or you could write an Excel macro to find them.

    Having a specially written (or customized) program to perform this for you will be quicker, because some calculations can be skipped.

    MileCharter could also be customized to perform this function for you - email me off list, if interested.
    MileCharter info (special offer ends 31st Dec):


    Winwaed Software Technology LLC
    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. Innovations: Microsoft MapPoint helps businesses with routes
    By Eric Frost in forum News and Announcements
    Replies: 0
    Last Post: 04-30-2005, 10:22 AM
  2. Great Plains 8.0 for Australian businesses
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 09-12-2004, 03:49 PM
  3. Small Businesses Fuel Economy With Help From Technology
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 05-20-2004, 10:00 PM
  4. MapPoint Location Server to Mobilize Businesses
    By Eric Frost in forum News and Announcements
    Replies: 0
    Last Post: 03-22-2004, 07:51 AM
  5. Object Invoked has Disconnected for its Clients Message.
    By jmiller55 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-07-2003, 10:22 PM

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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132