Exponential Smoothing Macro

[reet_uk@yahoo.com]

Hi

I've had superb help off this site before so thought I'd come back
again:

Does anyone have a macro which automates the generation of exponential
smoothing forecasts for say 1000 different product lines for say 12
months?

Also, when you manually create the E/S forecast using the toolpack, why
are the first two forecasts coming up with #N/A?

Any help greatly appreciated as always.

Bye for now.

Reeter

[Gary''s Student]

The smoother is just a filter that needs old values and a new value as an
input. The first couple of items just have nothing to "reach back" to. See:

http://www.itl.nist.gov/div898/handb...on4/pmc431.htm
--
Gary's Student


"reet_uk@yahoo.com" wrote:

> Hi
>
> I've had superb help off this site before so thought I'd come back
> again:
>
> Does anyone have a macro which automates the generation of exponential
> smoothing forecasts for say 1000 different product lines for say 12
> months?
>
> Also, when you manually create the E/S forecast using the toolpack, why
> are the first two forecasts coming up with #N/A?
>
> Any help greatly appreciated as always.
>
> Bye for now.
>
> Reeter
>
>