Exponential Smoothing Macro
 

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

Exponential Smoothing Macro
 

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


" 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