Google Spreadsheets provide a lot of useful functions, but unfortunately nothing that calculates the distance between two locations. However, this is easy to add as a custom function using the Maps service available in Google Apps Script.
Most of the other approaches I found online seemed to involve using the external APIs provided by Google Maps or MapQuest. But both these approaches required registering for a Developer API Key. The approach I describe here seems a lot simpler.
I'll show how to create the following functions and how they can be used in Google Spreadsheets
DrivingMeters(origin, destination) - Driving Distance in Meters
DrivingMiles(origin, destination) - as above but in Miles
DrivingSeconds(origin, destination) - Driving Time in Seconds
DrivingHours(origin, destination) - as above but in Seconds
Yet Another LED Gmail Notifier using a Nanode
This year we've begun having an "unplugged" day once a week - with no-one in the house using iphones, ipads, chromebooks, tvs, kindle, etc. But we still run a vacation rental business, and need to respond promptly to inquiries. So we wanted a way to be visually notified of those inquiries (without having to check our email, and being tempted to respond to non-business emails). The other requirement was that this device be standalone, and not required to be connected to a computer.
There's lots of other projects like this out there. Several of them need to be plugged into a computer. Others use the Raspberry Pi. I happened to have a Nanode sitting around unused, and wanted to build it with that. This article will show you how I light an LED when we receive an important email, and turn it out once it is read.
There's lots of other projects like this out there. Several of them need to be plugged into a computer. Others use the Raspberry Pi. I happened to have a Nanode sitting around unused, and wanted to build it with that. This article will show you how I light an LED when we receive an important email, and turn it out once it is read.
Subscribe to:
Posts (Atom)
Blog Archive
- May 2019 (3)
- November 2015 (1)
- September 2015 (1)
- May 2014 (1)
- March 2014 (1)
- February 2014 (2)
- January 2014 (1)
- September 2013 (2)
- August 2013 (1)
- April 2013 (3)
- March 2013 (2)
- February 2013 (1)
- January 2013 (1)
- December 2011 (1)
- October 2011 (1)
- September 2011 (12)
- July 2011 (2)
- March 2011 (1)
- January 2010 (2)
- December 2009 (2)
- December 2008 (4)
- November 2008 (4)
- October 2006 (1)
- September 2006 (1)
- August 2006 (1)
- February 2006 (1)
- January 2006 (3)
