Re: time series analysis interpolation

[Jim Tarvid <tarvid ls net>]

Thanks for the quick replay.

The dates are all 1/1/yyyy. I had applied a custom format as none of the default formats for date suited me.

All the date columns are now type date format m/d/yyyy., I switched OS and failed to update Tools -> Plugins

tsa was not active. I am now getting #VALUE!

You are indeed correct about point period issues. They abound.

I am uploading the revised file.

On Thu, Aug 19, 2010 at 9:15 AM, Morten Welinder <mortenw gnome org> wrote:

If you get #NAME? then the function is likely unknown.
Check Tools->Plugins and see if the time series plugin
is active.

I get #VALUE!  A quick look suggests that you should not
mix years (integers like 1991) with dates like on the data
sheet..  Change 1991 to a date in 1991.  That will obviously
also force you to think about whether you want the interpolation
for the beginning/middle/end on the year.  Or something else.

Morten

--
Rev. Jim Tarvid, PCA
Galax, Virginia
http://ls.net
http://drupal.ls.net