Search code examples
excelmappoint

Is there a drive time functionality in Excel 2016 similar to MapPoint?


I'm using the drive time zone functionality in Map Point a lot, but the software is no longer supported. I was wondering if it was possible to get similar functionality in Excel 2016, I've tried to replicate it in 3D Maps but I couldn't find anything. Does anyone know if this can be done with Excel or any add ins?


Solution

  • I haven't seen anything like this in the Excel 3d Maps or PowerMaps. We have been recommending our MapPoint customers move to Caliper's Maptitude product. Yes this does cost money (as did MapPoint, of course) but has more functionality than MapPoint, data is updated more frequently (and there is more of it), and they have a working, useful support service - more than can be said for Microsoft's support of MapPoint!

    The latest versions do support drive time zones, and these can be created using the API. It supports the GIS concept of layers, so the drive time zones are 'drawn' as a polygon (area) layer. This can then be used to query/ manipulate other map layers as per any standard GIS.

    (the API has a lot more methods/functions than MapPoint's API, and can be used via COM or Caliper's own macro language)

    We've also ported some of our MapPoint products to Maptitude.

    An alternative would be to roll your own (or pay someone like me to do it :-) ). If you do this, you would need a source of road data.