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 5 of 5

Automated client/center distance calculations

This is a discussion on Automated client/center distance calculations within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi! I work for a nationwide chain of health centers. We have many national clients with locations all over. We ...

  1. #1
    beth is offline Junior Member White Belt
    Join Date
    Sep 2006
    Location
    Dallas, TX
    Posts
    2

    Question Automated client/center distance calculations

    Hi! I work for a nationwide chain of health centers. We have many national clients with locations all over. We need to find the closest clinic to each client's locations, displaying mileage, and export the data to Excel. The process needs to be automated, since the Excel lists can be over 1000 locations sometimes.
    We currently use MapInfo/MapMarker for this, but it's too expensive to renew our license. I was wondering if this process can be done in MapPoint, maybe with a little programming. It'd be great if we could do this without a full-blown GIS with features we don't need. If MapPoint won't work for this, any suggestions on what will?
    Thanks for any help!

  2. #2
    Alex57 is offline Junior Member White Belt
    Join Date
    Feb 2004
    Posts
    7

    Automated client/center distance calculations

    Hi, we have a web based system and desktop tools. See Your MapPoint, MapPoint Web Service and Store Locator Software Specialists. The Web-based tool is called ProximityAnalyzer.

    Feel free to email me at amachinis at spatialpoint.com. for more details.

  3. #3
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    This can indeed easy be done with a little programming. If you use the MapPoint ocx control, then you can embed the map in your own appliction without all the whisels and bells, and then you use it just for the thing you need.

    I shoul do it this way:

    You have a database with the geocoordinates of each clinic. In your program you find the 2 or 3 most close ones in the birds eye of view. Then you do with MP the most close route.

    Or you take 1..n most close (in bird eye view) until the distance between n and n - 1 is more than 20 procent or so.

    Wy first calculate in your own application is for speed. Calculating a real route take more time than just calculate the distance in a strait line.

    You mention Excel. I think you can do it all in Excel in VBA. But almost any other language will do.

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    The Professional version of our MileCharter production will also do this.
    Load your data as two pushpin sets.
    Set it to find the Closest 1, and leave it running. Default output is to an Excel spreadsheet, finding the closest destination(s) for each source.
    More info:

    MileCharter: Create Mileage Charts with Microsoft® MapPoint®


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    beth is offline Junior Member White Belt
    Join Date
    Sep 2006
    Location
    Dallas, TX
    Posts
    2
    Thanks for the responses! I found MileCharter after I made the original post and it looks like it will do exactly what we need! I'm still waiting to get a copy of MapPoint 2006, but have 2004. Will MileCharter work with MP2004 so I can try it out?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Making an automated task in a commandline
    By jcjdoss in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-29-2005, 01:31 PM
  2. Distance Between Single Client & Mulitple Employees
    By paulhartland in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-21-2005, 11:11 AM
  3. Distance Calculations in Mappoint
    By SiGreenwood in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-01-2005, 11:56 PM
  4. My calculations on distance and time appear to be wrong
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-27-2004, 06:58 PM
  5. could Mappoint be automated for trafic in a specific city?
    By DavidofMontreal in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-21-2004, 10:51 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