thermo-resistor PT100 simulation in Spice

[pavel47]

pt100 spice

Hello

Is there a posibility to simulate the behaviour of
thermoresistor. I have look-table in the form:


Temperature Resistance
-55 °C 78.32 Ω
-54 °C 78.72 Ω
......................................

+200 °C 175.86 Ω

Can I use this table in Spice.

Thanks in advance

Pavel.

 

[Fom]

polynomial pt100

Resistor model may use up to second order polinomial temperature coefficient.
Open this table in EXCEL. Interpolate the table by second order polynom and use these polynomial coefficients in your resistor model.

 

[pavel47]

pt100 table excel

I couldnt find interpolation function in Excel.
Are you sure that it exists?

Thanks

 

[Fom]

pt 100 resistor table

I am sure.
Plot your table as a chart. Make sure you use XY(Scatter) chart type.
Click on the chart windows. In Menu "Data" item is changed to "Chart" item.
In chart menu select add trendline. Select polynomial Trend/Regression type (order =2).
In the Option select "Display equation on chart".
Click OK.

 

[pavel47]

resistor pt 100

Thanks you, Fom

It works.