节点文献

利用Excel实现柔性测试计量系统

The Realization of the Flexible measuring System by Using Excel

  • 推荐 CAJ下载
  • PDF下载
  • 不支持迅雷等下载工具,请取消加速工具后下载。

【作者】 罗泽文; 罗钧; 冉学臣; 段思宇;

【Author】 Luo Zewen 1 Luo Jun 1 Ran Xuechen 2 Duan Siyu 1 1 (Key Laboratory of Optoelectronic Technology and System of MOE, Chongqing University, Chongqing 400044, China) 2 (Weapon Industrial 456 District Measure Station, Chang’an Co., Chongqing 400021, China)

【机构】 重庆大学光电技术及系统国家教育部重点实验室; 长安集团兵器工业四五六区域计量站; 重庆大学光电技术及系统国家教育部重点实验室 重庆400044; 重庆400044; 重庆400023; 重庆400044;

【摘要】 柔性计量体现了软件可根据业务的可修改性,它是在现代企业发展需要提出的一种新需求,在计量业中得到广泛的应用。介绍了实现柔性计量系统的原理,利用Excel强大的计算及表格设计功能实现报表格式的设计以及数学模型的固化,通过测量模板建立所有测量数据与Excel单元格的位置关系,利用Ole技术实现在程序中操纵Excel,从而实现把需要的数据读入到Excel相应的位置中,并且调用Excel的打印模块输出报表。在系统中,传感器管理模块加入转换公式实现多物理量测量,录入界面的自动生成实现了测量的柔性化。

【Abstract】 The flexible measuring system expressed the idea of the modifiability of the software based on the demand of operation. It is a new requirement bringing forward by the development of modern industry and it is widely used in the measuring field. The theory of flexible measuring system, the way to design format of report by using the powerful form designed capability, and the way to build mathematic modely by using the powerful computimg capability of Excel are presented. The connection between measuring data and position of cell in Excel by using measuring models is establised. the OLE technology to implement the manipulation to the Excel in the program is used in order to read and load the needed data to the correct location, and then the PR module of the Excel is called to output the report. The system implements multi parameter measurement by adding the converted formula into the module of sensors, the auto making of the input interface implements the flexible measurment.

  • 【文献出处】 仪器仪表学报 ,Chinese Journal of Scientific Instrument , 编辑部邮箱 ,2004年S2期
  • 【分类号】TP317.3
  • 【被引频次】8
  • 【下载频次】91
节点文献中: