Spreadsheet functions to query route planner for travel time/distance

Posted by Rich on Super User See other posts from Super User or by Rich
Published on 2010-03-18T17:14:56Z Indexed on 2010/03/19 1:11 UTC
Read the original article Hit count: 364

Filed under:

route-planning

|

google-docs

|

gis

|

google-spreadsheets

I would like to achieve something whereby I have a spreadsheet such that the columns are:

Column A - place name
Column B - place name
Column C - distance by road between places in columns A and B
Column D - travel time by road between places in columns A and B

I thought it might be possible using Google Docs' spreadsheet and its 'Google' functions, but I've not found any that might do the trick.

In the end I could knock up an app to do it using the Google Maps API but would rather avoid it if I can.

© Super User or respective owner

Related posts about route-planning

Finding places by travel time from start point

as seen on Super User - Search for 'Super User'
Does anyone know of any website or other route planning tool that lets you find places by travel time from a specific point? For example, if my starting point is London, and I drive for 24 hours, what are the major cities I could reach? >>> More
Spreadsheet functions to query route planner for travel time/distance

as seen on Super User - Search for 'Super User'
I would like to achieve something whereby I have a spreadsheet such that the columns are: Column A - place name Column B - place name Column C - distance by road between places in columns A and B Column D - travel time by road between places in columns A and B I thought it might be possible using… >>> More
Programmatically query route planner for travel time/distance?

as seen on Super User - Search for 'Super User'
Hi I would like to achieve something whereby I have a spreadsheet such that the columns are: Column A - place name Column B - place name Column C - distance by road between places in columns A and B Column D - travel time by road between places in columns A and B I thought it might be possible… >>> More
Is there a low carbon future for the retail industry?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Recently Oracle published a report in conjunction with The Future Laboratory and a global panel of experts to highlight the issue of energy use in modern industry and the serious need to reduce carbon emissions radically by 2050. Emissions must be cut by 80-95% below the levels in 1990 – but… >>> More

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