[Babase] Re: min_max file attached with daytime column
kfenn
kfenn at princeton.edu
Wed Apr 1 08:49:18 EDT 2009
Karl O. Pinc wrote:
>
> 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.
>
I noticed that when I did the export yesterday and figured it would be a
problem (not that it stopped me from sending you my lousy file....).
But I'm glad you looked at the daytime format I created and it looks
OK. So I can just revert back to the last daytime.txt file you created
that we OK'ed....right? I should try using that for the upload? And,
yes, moving forward I can create the new files for upload with a daytime
column only.
> 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?
>
I think that will be OK. If I have a missing time I'm just going to do
an average myself based on that month, right? And if I have missing min
or max but the precip is there, I can just upload it with the NULLS for
min & max but a precip value, right?
A related, and as-of-yet undiscussed, can of worms is the precip
measures we have for the Nado Soito station. There are a few precip
values for each month starting in 2007. Should I just try an upload of
the days with records and leave the others out? I realize I also need
to add a station abbreviation to that table before this will work.
> 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
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list