Rim weighting macro v1.1.1

It’s been a long time since I posted here. Haven’t been able to find the time recently to continue developing the software. And the change made to the rim weighting add-in isn’t a major change, just a bug fix.

There was a bug in the way the check for the existence of targets was being done. I was comparing the cells text to the cells value. In most scenarios they are the same but sometimes they’re not. In this instance the error was found when the cell contained the value 1.00. The text is ‘1.00’, the value is 1.

Anyway I’ve put a new version on the site.

A Warm December

It’s been a warm December here in the UK. I thought I’d have a look at the data from the Met Office to see quite how warm it’s been. It’s also interesting to see how the temperature has changed since the monthly statistics began in 1910.

First I downloaded the data for UK mean temperatures and had a look in Excel.

Below is chart of mean temp for the month of December from 1910 onwards. dec-mean-temp

As you see, 2015 is easily the warmest. It’s roughly 3-4 degrees Celsius warmer than the average. In fact, calculating the average (3.99 Celsius) and the standard deviation (1.45 Celsius) it’s roughly 2.7 times the standard deviation higher than the average. If it were distributed normally 99.6% of the months should be colder. I’ve no idea what the expected distribution is but it’s probably not normal. In any case, it was abnormally warm.

For comparison, I’ve plotted the averages and standard deviations for each month below.
avg-mean-temp-month

Interestingly the spread of temperatures is higher for the winter months.