|
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. |