I had a comment from Gabriel on the Google Distance post, asking if it could be adapted. After a bit of back-and-forth by email with Google Translate as an intermediary (Gabriel is Brazilian and my live-in translator/interpreter/girlfriend is in Brazil too so she couldn’t help), I figured out that what Gabriel wanted was to return [...]
Mel Starrs tweeted a week or so ago about using GIS software to do mapping and energy analysis. I wanted to do the something similar but for sub-metered zones in a multi-tenanted office building. Rather than go down the route of learning a new package, I remembered a chapter on creating choropleth maps in Nathan [...]
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 [...]
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 (more on that in a later post). It’s used [...]
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. [...]
Mel Starrs has just posted a handy time-saving tip over at Elemental which explains how to use MS Word’s autocorrect feature to ensure that your CO2 subscript always comes out right. It’s a handy approach and saves your work from the annoying critic who ignores your carefully crafted argument while pointing out every last formatting [...]