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

Data Processing in Experiment with Resistance Strain Sensor Based on Excel

作　　者：田红梅[1] 秦好泉[1] 滕坚[1] 

机构地区：[1]深圳职业技术学院工业中心,广东深圳518055

出　　处：《深圳职业技术学院学报》2008年第3期29-32,共4页Journal of Shenzhen Polytechnic

基　　金：深圳职业技术学院科研基金资助项目(2207K124G0)

摘　　要：基于应变效应,利用单臂电桥的平衡原理,测定了电阻应变式传感器的力学-电学关联特性曲线,得到质量-电压定标方程。基于该定标曲线,在传感器的线形工作区域,实现了电子秤功能,并对实际物品进行了称量。同时利用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.

关 键 词：传感器 EXCEL 电阻应变效应 数据处理 

分 类 号：O4-39[理学—物理]