If you downloaded the example file I posted earlier on today, as well as a few updates to the simple versions of the Gmaps and geolocation functions for Excel, you may have noticed that one of the places on the clickable list of locations was “My location”. This works using Wikimedia’s geoiplookup service. When I [...]
I was asked for a downloadable file with the G_LATLNG by Filipe who was having trouble getting the function working. Since I posted that, I’ve done a bit of further work to improve it. The workbook you can download caches results from G_LATLNG and G_DISTANCE queries to reduce the amount of time spent polling Google. [...]
To top off the recent Gmaps and Excel posts, I thought I’d show you how to embed a map in a worksheet. This involves three main steps. 1) Inserting the web browser object The first step is really simple. Just go to the developer tab on the ribbon and click the “More controls” icon – [...]
A lot of people find this blog through the post about the embodied carbon of tap water so I thought I’d do a quick follow-up post. I found the water industry body, Water UK’s sustainability reports covering the period from 2001/2002 up to 2010/2011. This gave me all the data I need to update the [...]
Now that you have the G_LATLNG function for your Excel sheets, what is that good for? Well you can use your geocoded value to display your location on a map. I’ll get to that later on, but for now you can also use it to look up postcodes, thanks to a file I obtained from [...]
Edit: See an updated version of this geocoding function. As with the previous post, I’ve been writing some code lately using Google tools. This post is a rewrite of some heavier code for geocoding location data. The aim is to get latitude and longitude which is then used to display points on a Google Map [...]
I’ve been writing a few bits of code lately which have required using Google tools. I thought I’d write up some notes here for my information than anything else but may come in handy for others too. This post is a nifty tool for tracking the distance travelled by building materials from source to site. [...]
