Monthly Means

User avatar
darrog
Weather Nut
Posts: 1930
Joined: Mon Nov 02, 2009 10:23 pm
Altitude: 183
Weather Station: Davis VPro2
Location: Maulds Meaburn, Cumbria
Contact:

Re: Monthly Means

Post by darrog » Tue Feb 22, 2011 12:57 am

Paul - my method was probably a long way round, but it doesn't look too bad.

basically played with the font color section and by selecting a white font color for all those ----, the result was the appearance of gaps in the tables.

when I had completed the month of january I then used copy+paste x12 and then went back and entered the correct data for those months.

would be sooooooo much easier if the forum accepted those spaces
Darren Rogers - he who submits the most interesting posts, AKA Mr Data
Maulds Meaburn

User avatar
darrog
Weather Nut
Posts: 1930
Joined: Mon Nov 02, 2009 10:23 pm
Altitude: 183
Weather Station: Davis VPro2
Location: Maulds Meaburn, Cumbria
Contact:

Re: Monthly Means

Post by darrog » Thu Feb 24, 2011 11:24 am

Chaps/ ladies

I know that I'm often mis-understood, but I was more looking for your overall/longterm averages.
Darren Rogers - he who submits the most interesting posts, AKA Mr Data
Maulds Meaburn

User avatar
Paul C
Professor
Posts: 8457
Joined: Mon Nov 02, 2009 8:52 pm
Altitude: 117m
Weather Station: Davis VP2
Location: Brampton
Contact:

Re: Monthly Means

Post by Paul C » Thu Feb 24, 2011 8:56 pm

OK - I have changed mine ! please let me know if this is what you are looking for

cheers

User avatar
darrog
Weather Nut
Posts: 1930
Joined: Mon Nov 02, 2009 10:23 pm
Altitude: 183
Weather Station: Davis VPro2
Location: Maulds Meaburn, Cumbria
Contact:

Re: Monthly Means

Post by darrog » Fri Feb 25, 2011 11:21 am

Paul - excellent - if the other members follow suit we will have a very useful and easily accessible tool available to us.

Your ten yrs of data already compares quite favourably to my 3/4yrs worth of data.

TEMPS - are already within a quite comparable +/- margin already - all my monthly means are lower than yours - expected that.
Only Jan + Dec' differ by more than 1.0c (1.2c + 1.5c) - expected that due to the recent cold yrs for those months.

March (0.57c) - Aug' (0.53c) - Sept (0.70c) are the only other months with a margin of 0.5c or greater. Recent cold summers could account for Aug' (but July is only 0.07c out).

The Other months vary by 0.03 - 0.43c

I know that i will get shot down in flames, but I have always held the opinion that in the Uk, means quickly harmonise, even when comparing a few yrs of data to a more standard 30yrs worth of data.

Now prove me wrong.
Paul - just as a guide, can you say how your 10yrs worth of data compares to what it was after 5yrs - any noticeable differences.

It would be interesting if Carl did the same for say 10 - 20 - and 30yrs


You never did tell me how you did that jpg stuff - but now that I have done my table anyway i'll just update that each month.
Last edited by darrog on Fri Feb 25, 2011 11:38 am, edited 1 time in total.
Darren Rogers - he who submits the most interesting posts, AKA Mr Data
Maulds Meaburn

User avatar
Paul C
Professor
Posts: 8457
Joined: Mon Nov 02, 2009 8:52 pm
Altitude: 117m
Weather Station: Davis VP2
Location: Brampton
Contact:

Re: Monthly Means

Post by Paul C » Fri Feb 25, 2011 11:30 am

[You never did tell me how you did that jpg stuff - but now that I have done my table anyway i'll just update that each month.[/quote]

Page 1 :D .

Use your snip tool around your spreadsheet and save image as a jpg file. Then upload the jpg file to the site.

I have looked into all other options and this is the best way, infact the only way as inserting a "table" or spreadsheet is impossible.

User avatar
darrog
Weather Nut
Posts: 1930
Joined: Mon Nov 02, 2009 10:23 pm
Altitude: 183
Weather Station: Davis VPro2
Location: Maulds Meaburn, Cumbria
Contact:

Re: Monthly Means

Post by darrog » Fri Feb 25, 2011 3:25 pm

Do we use this page/subject to comment on each others figures or use add posts on each individuals page?

but anyway - just had a quick look at Carl's table, very good[/u} it is as well.
Carl, can you break down into individual months?

x2 decades with a mean temp' of 9.4c - one at 9.3c, the other at 9.5c and the mean min' was exactly the same.

Carl - from a first glance it looks like you live in a fairly consistant location for weather - hope that's not a daft observation, or even sounds daft.
Darren Rogers - he who submits the most interesting posts, AKA Mr Data
Maulds Meaburn

User avatar
Carl M
Assistant Professor
Posts: 6222
Joined: Mon Nov 02, 2009 9:25 pm
Altitude: 7m
Weather Station: Davis VP2
Location: Drumburgh
Contact:

Re: Monthly Means

Post by Carl M » Fri Feb 25, 2011 9:01 pm

darrog wrote:Carl, can you break down into individual months?

x2 decades with a mean temp' of 9.4c - one at 9.3c, the other at 9.5c and the mean min' was exactly the same.

Carl - from a first glance it looks like you live in a fairly consistant location for weather - hope that's not a daft observation, or even sounds daft.
Yes, all months are broken down - they're on my website.

Well my site hasn't changed in all those years, ok maybe a few
more trees have grown taller but generally unchanged.

The only slight difference is in the rainfall where the last decade
2001-2010 shows an increase, but not by that much.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Drumburgh 7m AMSL (Solway Estuary)
http://www.coggabata.co.uk/weather.html

Post Reply

Return to “Monthly Means”