I am trying to use Tushar Mehta's version of the trendline coefficient
extraction code, which I found he
http://www.tushar-mehta.com/publish_...nalysis/16.htm
My problem is that for some reason if I save the file and reopen it,
Excel locks up and the TLcoef and TLeval formulas return "Err: No
trendline found"

What is wrong? Should I be changing something in the code?

FYI - i'm using Excel 2002.

Why not use one of his LINEST formulas to get the coefficients?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
I am trying to use Tushar Mehta's version of the trendline coefficient
extraction code, which I found he
http://www.tushar-mehta.com/publish_...nalysis/16.htm
My problem is that for some reason if I save the file and reopen it,
Excel locks up and the TLcoef and TLeval formulas return "Err: No
trendline found"

What is wrong? Should I be changing something in the code?

FYI - i'm using Excel 2002.

The LINEST formulas in Excel 2002 and previous aren't as good as the
chart trendline for complex data. This is why I need to extract the
trendline data.

Agreed, there are cases when LINEST gives incorrect results.
I would be interested in seeing such a data set.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
The LINEST formulas in Excel 2002 and previous aren't as good as the
chart trendline for complex data. This is why I need to extract the
trendline data.

I presume that you want to see if the OP has a new example; that would
interest me as well.

Previously posted examples include

http://groups.google.com/group/micro...9a2bb33e6cdbb8
a 6th degree polynomial fit that gets no correct figures in versions prior
to 2003, but does better in 2003 on.

http://groups.google.com/group/micro...8ea066b144d042
a 6th degree polynomial fit that gets no correct figures in any version of
Excel

http://groups.google.com/groups?thre...0a% 40phx.gbl
an orthogonal trigonometric regression that worked prior to 2003, but gives
erroneous zeros in 2003.

Jerry

"Bernard Liengme" wrote:

Agreed, there are cases when LINEST gives incorrect results.
I would be interested in seeing such a data set.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
The LINEST formulas in Excel 2002 and previous aren't as good as the
chart trendline for complex data. This is why I need to extract the
trendline data.