Monthly Archives: November 2019

Steinhart-Hart Thermistor Calibration in Excel Using Matrix Formulas

I had a job this week that required that I use the Steinhart-Hart equation for modeling the thermistor resistance versus temperature relationship. The requirement was driven by the customer's need for high accuracy. Most thermistor applications do not demand high accuracy, but this application can tolerate no more than ±0.2 °C of error.  This means that I cannot use the β-based thermistor model, which in this application would have an error of more than ±2 °C. This page will show how how to perform an efficient 3-point calibration using Excel and a bit of matrix math. As a side benefit, I am using this workbook as an example of matrix math in my Excel tutoring at a local library. Continue reading

 
Posted in Electronics | 2 Comments