Excel or Google Spreadsheets: Function to find distance between cities?

Posted by Rosarch on Super User See other posts from Super User or by Rosarch
Published on 2009-10-17T23:10:12Z Indexed on 2010/05/11 23:25 UTC
Read the original article Hit count: 289

Filed under:

google-docs

|

google-spreadsheets

|

google-maps

I want a spreadsheet of the following form:

Point A         Point B           Mileage
Los Angeles     Miami             292100
Palo Alto       San Francisco     90

Where Mileage is automatically calculated. Are there any functions or APIs to do this?

I am looking for "distance driven", not "as the crow flies"

© Super User or respective owner

Related posts about google-docs

Remove 'Google Chrome' folder on Google Docs

as seen on Super User - Search for 'Super User'
I used to sync my Chrome bookmark, and Chrome create a folder named Google Chrome in my Google Docs Now I want to delete it. Is there any way to do? >>> More
Alternative to google docs?

as seen on Super User - Search for 'Super User'
Any alternative that you know? Because google docs really sucks, it wont let you upload powerpoint or any document file which is higher than 3 mb. Please, thanks in advance. >>> More
Direct URL to a Google docs revision

as seen on Super User - Search for 'Super User'
I have a Google doc document. Using Edit-File-See Revision History I can see older revisions and go to them. I want to give some-one a URL which points directly to a specific revision of my document which is not the current one. How do I do this? (Note: The link from the revision list does not work… >>> More
Map a GoogleDocs Spreadsheet to a SQL table

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a generalized plan of attack at this problem: Upon saving a spreadsheet in my Google Docs account a SQL 08 table is updated. Or perhaps via spreadsheet's new 'Form' input method. But the overarching goal is letting google docs function as a front-end editor to sql. thx --steve... >>> More
Google Docs as a Drive - Maximum number of images on 200GB account

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, have you upgraded to a Google Docs Premium Account? I'm wondering if that can be used as I'm using S3 at the moment. I'd like to upload images. Do you know if there is there any limit on the number of images I can upload on my 200GB Google Docs account? Thank you ;) >>> More

Related posts about google-spreadsheets

does google spreadsheets create forms?

as seen on Super User - Search for 'Super User'
after going to this URL: link text i noticed that it is powered by google docs. i didnt know that google docs make online forms as well. does google doc provide the option to make online forms? has anyone had experience doing this? what language are they using to make this thing so scalable? >>> More
Google Spreadsheets - How to take SUM of colored cells in a column

as seen on Super User - Search for 'Super User'
In a Google Spreadsheet, is it possible to take the sum of only the colored cells in a column? I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background. Is it possible to create a formula… >>> More
How do I change the font formatting of cells in Google Spreadsheets?

as seen on Super User - Search for 'Super User'
I am trying to add checkboxes to a spreadsheet in Google Spreadsheets. I found an interesting solution to this problem here in Google's help. The second post on that thread states you can just format the cell to Wingdings 2 and certain characters will correspond to a checkbox. Now the problem is… >>> More
How do I change the font formatting of cells in Google Spreadsheets?

as seen on Server Fault - Search for 'Server Fault'
I am trying to add checkboxes to a spreadsheet in Google Spreadsheets. I found an interesting solution to this problem here in Google's help. The second post on that thread states you can just format the cell to Wingdings 2 and certain characters will correspond to a checkbox. Now the problem is… >>> More
Accessing Google Spreadsheets with C# using Google Data API fails with Mono

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to access my Google spreadsheets using the GData API. I have followed the example which looks like: var service = new SpreadsheetsService("myTest"); service.setUserCredentials(username, password); var query = new SpreadsheetQuery(); var feed = service.Query(query); This should return… >>> More