Variance between AppSheet Distance() and Google Maps

[Daisy_Ramirez]

Our client is providing shipping cost quotations with the starting and destination zip codes. I’ve imported a zip code listing containing the LAT/LONG of each zip code in the US, determined the DISTANCE() between the two zip codes and multiplied to obtain the mileage ([vir_distance]*0.621371)). The client is inquiring about the difference between the Google Map mileage calculation vs. AppSheet. Can anyone provide some background and what has been implemented to help eliminate the variance?

A million thanks!

[Aleksi]

The difference is because the DISTANCE expression is calculating the direct path from point A to to B where Google Map is calculating with the street route.

[Daisy_Ramirez]

Thanks Aleksi. For reference, Praveen posted a super helpful article for an external service similar to Google Maps API for a spreadsheet formula. Here’s the article link:

gadgetsappshacks.com

Calculating Distance between two locations in Google Spreadsheet

Google Spreadsheets provide a lot of useful functions, but unfortunately nothing that calculates the distance between two locations. Howev...

[Aleksi]

Thanks Daisy, yes I’m aware of this one

[Daisy_Ramirez]

Yes, I was hoping to make available to anyone finding my inquiry

Thanks as always for your help.

[Aleksi]

Good idea!

[House_Chokdee]

Thank you Daisy

[Daisy_Ramirez]

You’re very welcome!!