[Babase] Re: min_max file attached with daytime column

Jeanne Altmann altj at princeton.edu
Tue Mar 31 20:46:47 EDT 2009


Susan,
Can we make a decision about historical data for rain and temp that were
converted from English system to metric and as a result have decimal
representation that suggests inappropriate precision? Or have we missed
a decision that we already agreed to?

I now propose that we have rounding to one decimal point on temp and
integer values on mm.  Thoughts?

jeanne

-----Original Message-----
From: babase-bounces at eeblistserv.princeton.edu
[mailto:babase-bounces at eeblistserv.princeton.edu] On Behalf Of Karl O.
Pinc
Sent: Tuesday, March 31, 2009 5:24 PM
To: babase at eeblistserv.princeton.edu
Subject: [Babase] Re: min_max file attached with daytime column


On 03/31/2009 02:11:10 PM, kfenn wrote:
> Karl,
> 
> This should reflect the following improvements we've made since we  
> began this process (you can check me to make sure I haven't  
> accidentally exported an older version with some retro mistakes:
> 
> no ~1971-75 data
> no icky quotes
> shorter, more concise comments
> date and time condensed into a daytime column

The daytime column data supplied looks good to me.
(Mostly, see below.)

> 
> 
> Looking forward (sort of) to trying the upload myself.

There are 64 rows having no time value where excel
has turned the daytime value into #VALUE!.  Consequently
I can't get the month and so can't compute the average
time and so have neither day nor time.

I think the thing to do is to leave the day and time
separated in the historical data and rely on my
'fixer' program to move the comments around,
get the day and time right, and otherwise fixup
the historical data.

Moving forward you can do your excel manipulation to
get the date and time into one column.  We should
always have a time and there won't be a problem.

On a related note, you won't have any problems doing
data entry and omitting those days where no data
was collected so we don't have the "blank" lines
that are in the historical data, right?

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list