Dynamic Trend

[Eli Kedar]

I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you

 

[Andy Pope]

Hi,

This can be done with dynamic ranges.
http://www.andypope.info/ngs/ng31.htm

Cheers
Andy

 

[John Mansfield]

Eli,

The examples here might help as well:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=518

 

[Eli Kedar]

John

Thank You
--
Eli Kedar
Israel

Eli,

The examples here might help as well:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=518

 

[Eli Kedar]

Andy

Many Thanks
--
Eli Kedar
Israel

Hi,

This can be done with dynamic ranges.
http://www.andypope.info/ngs/ng31.htm

Cheers
Andy