Could someone kindly point me to (Win-XP) software which would help with
analysis (as opposed to display) of the downloaded WeatherLink data from a
Davis VP2?

Sorry if this is an FAQ, but what I'm looking for is an easy way to get max,
min and averages for temperature day by day through the month, add up
rainfall etc. I often miss a day's observation, and it's a real chore to
flog through the mass of raw data adding up numbers. I'm not especially
interested in fancy graphics, just numerical summaries that I can put into a
spreadsheet.

TIA,

Steve P

I presume that you're asking because the various NOAA reports built in
to Weatherlink don't do what you require?

Another option is to Export a month's data from the Weatherlink Browse
mode and import this into a standard spreadsheet like Excel.

I've got a utility (Weatherlink Reporter), which is still
unfortunately in rather protracted development, which will handle a
lot of monthly summarising. There's an older beta version available
for download, but this isn't properly Vista compatible at present.
Hopefully I will be able to release an updated version within a few
weeks now. Suggest you contact me direct if you need further details.

John Dann
www.weatherstations.co.uk

On 3 Nov, 12:48, "Steve Pardoe" wrote:
Could someone kindly point me to (Win-XP) software which would help with
analysis (as opposed to display) of the downloaded WeatherLink data from a
Davis VP2?

Sorry if this is an FAQ, but what I'm looking for is an easy way to get max,
min and averages for temperature day by day through the month, add up
rainfall etc. *I often miss a day's observation, and it's a real chore to
flog through the mass of raw data adding up numbers. *I'm not especially
interested in fancy graphics, just numerical summaries that I can put into a
spreadsheet.

TIA,

Steve P

If you're using Excel and you know how to use pivot tables, the
easiest way is just to take the sub-daily data into a spreadsheet,
split out date and month from the Weatherlink number (date and time
combined) using Excel functions in two separate columns, and then
pivot by date and month selecting 'max of Tmax', 'min of Tmin', 'sum
of rain', etc as teh table variables.

This will of course give you civil day (00-00h) terminal hours; a
little jiggery pokery adjusting dates (separately for max and rain,
and min) in the spreadsheet will give you 09-09h values, but don't
forget to be complete on the first and last days of the month you'll
need 09-00h data for the previous month and 00-09h of the following
month's data.

If you've not used Excel pivot tables before, it takes a little
experimenting to start but it's incredibly handy for all sorts of
climatological analyses, and of course once you've set up a little
template to do this, it's just a matter of pasting in the next month's
data and refreshing the pivot table - a matter of seconds.

HTH.

--
Stephen Burt
Stratfield Mortimer, Berkshire

"John Dann" wrote in message
...
I presume that you're asking because the various NOAA reports built in
to Weatherlink don't do what you require?

D'oh! For some reason I'd got it into my head that the NOAA reports were
just some sort of US database upload thingy. Now I've had a poke about,
they do indeed provide what I wanted (there's even a button on the toolbar,
for heaven's sake); and thanks for pointing it out so tactfully, John,
rather than saying "RTFM" which is what I deserved!

Another option is to Export a month's data from the Weatherlink Browse
mode and import this into a standard spreadsheet like Excel.

Yes, I'd tried that but couldn't be bothered with setting up all the
calculations, sure that I'd be reinventing the wheel. Plus (in answer to
Stephen Burt's helpful reply) I'm not a natural when it comes to Excel, and
pivot tables were the item in the training at which I decided to leave it to
my smarter colleagues.

Hey ho, thanks again!

Steve P