Tuesday, April 10, 2012

yogi_Compute Distance Between Starting Location And Destination

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #503    Apr 10, 2012     www.energyefficientbuild.com.

 UPDATED APR-25-2015

user midhunzone said: 
how to get distance between two places via road on a spreadsheet. I tried pasting some formulas i found online but it returned errors.. pls help 
---- 
i meant keying in location like mumbai and pune in other. the formula should link it from google maps calculate the distance and return the distance in km as answer these is one code i found but i am unable to run it..pls help 
=Index(importXML("http://maps.google.com/maps?saddr="&B46&"&daddr="&C46&"&ie=UTF8&hl=en&output=mobile&f=d&btnG=Get+Directions", "/html/body"),1,4) 
 --------------------------------------------------------

following is a solution to the problem -- I have computed the distance in km as well as in miles