• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

latitudes and longitudes Road distance calculation

AV114

Member
I'm looking to get road distances between 2 addresses. I have the latitude and longitudes of each address. The issue I have is I can't use the Haversine formula, as it's for mileage claims so needs to be road distances.

I'm aware of the google API stuff, but not really sure how it works, or how I'd go about implementing something like that into my scripts.

Can you please help me on this.
 

Attachments

  • MAP.xlsx
    8.9 KB · Views: 3
Go through link below.
https://analystcave.com/excel-calculate-distances-between-addresses/

And below (Google Distance API documentation), if additional parameter is needed.
https://developers.google.com/maps/documentation/distance-matrix/intro

Do note that you'll need to obtain API key from Google first. They no longer support keyless API request.

Edit: I misspoke, they changed pricing just recently. Go over their documentation before using API. As pricing has changed to pay as you go plan, and you may need to turn on billing option before use of API (I haven't used Google API in a while and haven't tested).
 
Last edited:
Back
Top