On Tuesday, December 17, 2013 7:24:45 PM UTC, exmetman wrote:
Scott I can't agree with you when you say that the winter of 1962/63 is a magnitude 10 more severe than 1947 - or should that 460 read 46.0? Bruce.

Bruce, you're right.

I have modified the spreadsheet and used Kelvin instead of mean temp. I have divided snow lying by average mean Kelvin then multiplied by 100 to give it a chunky figure.
The temperature stats refer to the meteorological winter - December, January, February. The snowfall stats refer to October to May. I realise this is not consistent but I was merely trying to give a 'perception' of each winter. One could argue that I should include temp stats to go with the snowfall data ie October to May - but then this would introduce its own inconsistencies in not being 'meteorological winter'. With a couple of exceptions all my snowfall occurs December to March. Further feedback welcomed.

Here is a link to the new spreadsheet
http://sdrv.ms/1hZwtkG