[time-nuts] Excel logarithmic function (was Thermal impact on OCXO)

Bob Camp kb8tq at n1k.org
Wed Nov 16 18:02:50 EST 2016


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 at 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 at febo.com
> To unsubscribe, go to https://www.febo.com/cgi-bin/mailman/listinfo/time-nuts
> and follow the instructions there.



More information about the time-nuts mailing list