I was having a look at the public data the Met office provide on their website. They have a huge amount freely available on their website. I was interested in the historical data they provided for each of the stations accessible via this web page.The page allows you to download the data one station at…
I was doing some table calculations in Tableau and needed complete control over the rounding that was used. Tableau provides a single ROUND function. The exact specification of this (I believe) depends on the data source you are connected too, as it passes through to the underlying server. I needed to be able to look at…
I tend to find myself prototyping tools for our users within Excel, by far and away their favourite tool. I have a nice little wrapper for exposing C# functions as Worksheet functions and a slowly growing universe of VBA snippets for making automation and creation of these workbooks quickly. Most of the time these spread…
A couple of silly little tricks, but ones I find useful. Far too often I end up trying to decode a complicated Excel formula and wanting to make it easier to read and leave comments behind. The tricks below work in Excel 2010 and 2013. I don’t use 2007 any more but expect they would…
