This is a small tutorial video on how to generate a distance matrix on excel using Bing Maps API. Everything is explained in detail. This video is extremely useful for a Supply chain professional who is trying to perform Vehicle routing / Network analysis / Logistic cost analysis / Location Planning / Logistics Planning. It provides the road distance along the best routes considering traffic.

Link for GetDistance formula: https://drive.google.com/file/d/1zfrQ... (for windows version)

This may not work in Mac OS, due to limitations of Apple Mac.

If you need Travel time aswell, post this below code in your vba window and use GetTravelTime formula in the same format as GetDistance as explained in the video.
https://drive.google.com/file/d/1Dyao...
output will be travel time in minutes






If you are getting an error, it means the formula is not giving you any relevant information.
Here are the general reasons which I know result in such errors. (in the order of the likelihood)

1. If you are using a macbook. The Excel in macbook does not have a web service function, which is essential for Excel to talk to the internet.
2. If you are using Windows, but on a work laptop where Excel application may not have access to the Internet service. To validate if this is the case, I suggest trying the Webservice function to see if you are getting a relevant output. If you are getting an output, this may not be the reason. And if you are not getting the output, this is the issue and you need to talk to your IT admin or do this on your personal laptop. Reference: https://exceljet.net/excelfunctions/...
3. If you are sure 1&2 are not the reasons, There could be an error in the source coordinates and destination coordinates or the Bing key that is inserted into the GetDistance formula. Request you to kindly revisit the video and verify.
4. You need to save the file in .xlsm format.


About me:
I am a student at NITIE Mumbai, batch of 20192021. NITIE (National Institute of Industrial Engineering) is a leading academic institution in generating world class supply chain and operations professionals. It is also popularly known as "The Mecca of Supply chain".
Link: https://www.nitie.ac.in

#bingmaps #distancematrix #excel

To Connect with me:
Email: [email protected]