cubic polynomial Plot

carbonkid_1985

New member
Joined
Oct 8, 2021
Messages
1
Hi,

I'm trying to produce a frequency stability plot for AT-cut quartz resonators using excel. I have found a function to produce such a plot but I cannot get the correct shape. The function I found states;

The frequency shift of resonant frequency versus temperature is a function of the angle of the crystal cut versus the lattice structure of the quartz. The relative frequency shift versus temperature of AT-cut quartz crystals can be represented as a cubic polynomial:
Δf/f0 = A0 + A1(T - T0) + A2(T - T0)² + A3(T - T0)³
Where the coefficients A0 through A3 are functions of the angle of the quartz cut.


The plot I am trying to reproduce looks like this;

1633689655210.png

Where the frequency shift in ppm is on the y axis and the temperature is on the x. The different series are different cut angles in minutes from the delta AT-cut angle of 35°15'.

T-T0 is the temperature deviation from the Δ 25°C

I get the basic shape, but the numbers are massive, thousands of ppm. I also do not get the turnover point, something that is important for crystals.

If somebody could show me how one would create this plot in excel I would be eternally grateful.

Thanks In advance,

Chris
 
Top