[Babase] Re: min_max file attached with daytime column

Karl O. Pinc kop at meme.com
Wed Apr 1 09:24:20 EDT 2009


On 04/01/2009 07:49:18 AM, kfenn wrote:
> 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.

>  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?

Right.

>> 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?

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?

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.

Sounds right to me.

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