How to use Excel Table to accurately analyze the relationship of PT100 temperature Resistance
In this issue, the editor will bring you about how to use the Excel table to accurately analyze the PT100 temperature resistance relationship. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.
The following is for you to introduce how to use the Excel table to accurately analyze the corresponding relationship of PT100 thermal resistance and temperature resistance, and realize it in programming development.
Step 1: use the data in the PT100 thermal resistance temperature resistance table to establish a relationship in the Excel table. Here I intend to establish the relationship between-40 ℃ ~ 230 ℃, PT100 temperature and resistance. The results are as follows:
Step 2: select the resistance value and temperature data, establish the corresponding visual chart (X-axis resistance data, Y-axis temperature data), and select the scatter chart type.
Step 3: enlarge the chart and add solid lines to make the corresponding relationship between resistance value and temperature data more obvious.
Step 4: the last key step is to establish the trend curve relationship between resistance and temperature data, which is my quadratic polynomial, which basically fits the original data (the blue data line is the original data, the red data line is to establish the trend curve relationship between resistance and temperature data)
Click on the display formula (y = 0.0011x2 + 2.3459x-245.14), you can see the analysis of the resistance value, temperature data trend curve, in the development process, know the PT100 temperature or resistance value, apply the following formula, you can calculate the conversion data.
The above is the editor for you to share how to use the Excel table to accurately analyze the PT100 temperature resistance relationship, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.
