If any kind of error occurs then the function returns 0. It returns a value of the distance between the two locations in miles kilometres. I’ve called the UDF G_DISTANCE and the syntax for using it is =G_DISTANCE(Origin, Destination). The custom function for Excel works by entering two place names – or postcodes – and finding the shortest route between them using Gmaps route planner. Used in conjunction with the carbon factors per tonne km from Defra, this allows a decent estimate for the transport stage of a lifecycle carbon footprint assessment. This is for my information than anything else but may come in handy for others too. I’ve been writing a few bits of code lately which have required using Google tools, so I thought I’d write up some notes here. This post is a nifty tool for tracking the distance travelled by building materials from source to site.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |