time-nuts@lists.febo.com

Discussion of precise time and frequency measurement

View all threads

Excel logarithmic function (was Thermal impact on OCXO)

PV
Peter Vince
Wed, Nov 16, 2016 9:36 PM

Hello Lars,

Just out of curiosity I yesterday put just the first thirty days (like in

the pdf mentioned below) and let Excel calculate the logarithmic function.
If I extrapolate that to 10 years it seems that the drift would be
6E-13/day but as can be seen in the aging graph it was more like ten times
higher.

I'm not very good with Excel, but this curve-fitting function sounds very
useful.  Could you please tell me how it's done?

 Thank you,

      Peter
Hello Lars, Just out of curiosity I yesterday put just the first thirty days (like in > the pdf mentioned below) and let Excel calculate the logarithmic function. > If I extrapolate that to 10 years it seems that the drift would be > 6E-13/day but as can be seen in the aging graph it was more like ten times > higher. > I'm not very good with Excel, but this curve-fitting function sounds very useful. Could you please tell me how it's done? Thank you, Peter
BC
Bob Camp
Wed, Nov 16, 2016 11:02 PM

Hi

As mentioned earlier in this thread. The function that has been used in several posts
isn’t the right log function. The proper fit is to ln(bt+1)

Bob

On Nov 16, 2016, at 4:36 PM, Peter Vince petervince1952@gmail.com wrote:

Hello Lars,

Just out of curiosity I yesterday put just the first thirty days (like in

the pdf mentioned below) and let Excel calculate the logarithmic function.
If I extrapolate that to 10 years it seems that the drift would be
6E-13/day but as can be seen in the aging graph it was more like ten times
higher.

I'm not very good with Excel, but this curve-fitting function sounds very
useful.  Could you please tell me how it's done?

 Thank you,

      Peter

time-nuts mailing list -- time-nuts@febo.com
To unsubscribe, go to https://www.febo.com/cgi-bin/mailman/listinfo/time-nuts
and follow the instructions there.

Hi As mentioned earlier in this thread. The function that has been used in several posts isn’t the right log function. The proper fit is to ln(bt+1) Bob > On Nov 16, 2016, at 4:36 PM, Peter Vince <petervince1952@gmail.com> wrote: > > Hello Lars, > > Just out of curiosity I yesterday put just the first thirty days (like in >> the pdf mentioned below) and let Excel calculate the logarithmic function. >> If I extrapolate that to 10 years it seems that the drift would be >> 6E-13/day but as can be seen in the aging graph it was more like ten times >> higher. >> > > I'm not very good with Excel, but this curve-fitting function sounds very > useful. Could you please tell me how it's done? > > Thank you, > > Peter > _______________________________________________ > time-nuts mailing list -- time-nuts@febo.com > To unsubscribe, go to https://www.febo.com/cgi-bin/mailman/listinfo/time-nuts > and follow the instructions there.