基于Excel实现电阻应变式传感器实验数据的处理

Data Processing in Experiment with Resistance Strain Sensor Based on Excel

基于应变效应,利用单臂电桥的平衡原理,测定了电阻应变式传感器的力学-电学关联特性曲线,得到质量-电压定标方程。基于该定标曲线,在传感器的线形工作区域,实现了电子秤功能,并对实际物品进行了称量。同时利用Excel,采用数据绘图、线形回归等方法对实验数据进行了分析处理。

Mechanics-electricity correlated characteristic curves of resistance sensor were measured, and calibration equation of mass-voltage was obtained by adopting balance principle of Wheatstone Bridge based on resistance strain effects. The function of electronic balance was realized and several articles were measured in the linear region of sensor based on calibration equation. Meanwhile, data were processed by using the method of data-based graph and linear regression in Excel.