[Babase] Re: min_max file attached with daytime column

Karl O. Pinc kop at meme.com
Tue Mar 31 17:23:50 EDT 2009


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



More information about the Babase mailing list