Excel trendline

[John Fortiner]

Ron:  The "smoothing" is simply a "rounding off" of values.  Sometimes it
rounds up and sometimes down depending on settings.  Sort of like saying the
over tension is "about" 40k lbs on a piano.  That is a "smoothed" figure.
It is totally impossible to derive an "exact" from that.  To derive the
"exact" a person would have to have all the raw data to recalculate
again.....
I'm sure this isn't what you wanted to hear, but that's the way it is. ;-{

John Fortiner
Billings, MT. 

-----Original Message-----
From: Ron Nossaman [mailto:rnossaman at cox.net] 
Sent: Sunday, May 14, 2006 12:25 PM
To: Pianotech
Subject: Excel trendline


Brain pool - help!

Excel has a trendline feature in it's charting system, to visually smooth
the data. Does anyone know a way to get the set of smoothed data point
values BACK from the second degree polynomial trendline routine, or how to
use the trendline's Y and R^2 formulas to reconstruct the smoothed set in a
column?

Yes, it's piano related.

Thanks,
Ron N