|
|
|
| Development of VBA for pump performance experimental data based on Excel |
| Tang Yue, Zhao Kun, Xu Wenbo |
| (Research Center of Fluid Machinery Engineering and Technology, Jiangsu University, Zhenjiang, Jiangsu 212013, China) |
|
|
|
|
Abstract The pump performance curve experimental data were often stored.In the Excel tables.In order that the pump performance data were carried out numerical calculations in the Excel electronic tables automatically, the secondary development about the original preparation of pump performance test data was processed in Excel tables by VBA(Visual Basic for Applications)technology. The selection button and test results button about pump test tolerance level would be added in the electronic tables, according to fault tolerance levels and discrimination criterion in the GB/T 3216—2005 standard requirements, as well as least squares fitting algorithm and interpolation algorithms, the VBA programming on these two functions buttons was proceeded respectively, by clicking on the test results button, it can be achieved of interpolation calculation and performance discrimination on the pump performance test data, furthermore, the performance data and discrimination results in specified point and intersection point would also be obtained. As the applied example of BQW15-30-4submersible pumps, doing the hydraulic performancetests, determining the performance and drawing curves.The result shows that, H-Q curve intersects with the cross tolerance bottom of the vertical line,which meets the requirement. The method enhanced the interpolation calculation function of Excel dealing with pump test data by VBA technology,saving a large number of curve drawing work.
|
|
Received: 24 November 2010
Published: 30 March 2011
|
|
|
|
| ［1］施卫东,张德胜, 郎 涛,等.基于LabVIEW的水泵性能测试系统的设计［J］.排灌机械,2007, 25(3): 38-41.Shi Weidong, Zhang Desheng, Lang Tao, et al. Developmentof pump performance test system based on LabVIEW［J］. Drainage and Irrigation Machinery , 2007,25(3):38-41.(in Chinese)［2］国家质量监督检查检疫总局,中国国家标准化管理委员会.GB/T 3216—2005 回转动力泵 水力性能验收试验1级和2级［S］.北京:中国标准出版社,2006.［3］何希杰,邸立辉,王 曌.GB／T 3216—2005回转动力泵性能判定法的公式化研究［J］. 通用机械,2007(7):77-81.He Xijie, Di Lihui, Wang Zhao. Formulation research of GB／T 3216—2005 rotative power pump′s perfor mancedecision method［J］. General Machinery , 2007(7):77-81. (inChinese)［4］王宏伟,王 蕊,商德勇,等.基于VB和Matlab混合编程的离心泵测试数据分析［J］.矿山机械,2008,29(5):192-193.Wang Hongwei, Wang Rui, Shang Deyong, et al. Testing data analysis of centrifugal water pump based on VB and Matlab［J］. Coal Mine Machinery , 2008, 29(5):192-193.(in Chinese)［5］葛 强,陈松山,颜红勤.基于AutoCAD与Excel的水泵性能曲线复原新方法［J］.水泵技术,2006 (4): 29-31.Ge Qiang, Chen Songshan, Yan Hongqin. Based on AutoCAD and Excel recover new methods of the pump performance curves［J］. Pump Technology , 2006 (4):29-31. (in Chinese)［6］杨新春.水泵性能检测试验数据处理及软件设计［J］.科技信息,2008 (29):92-93.Yang Xinchun. Data processing and software design of the experiment data about pump performance test［J］. Science and Technology Information ,2008 (29): 92-93. (in Chinese)［7］林成深.数值分析［M］.北京:科学出版社,2006.［8］Wendyam F T, Mccann R A. Flux estimation in switched reluctance motors using a two dimensional least square method approximation［C］∥ Proceedings of the IEEE Region5 Technical Conference, 2007.［9］Jelen B,Syrstad T. VBA and Macros for Microsoft Office Excel 2007 ［M］.2nd ed.［S.l.］:Business Solutions Indianapolis,2008.［10］任 律,刘小兵,王辉艳.Excel VBA在水电工程安全监测数据处理中的应用［J］.西华大学学报:自然科学版,2009,28 (1):56-59.Ren Lü, Liu Xiaobing, Wang Huiyan. Application of Excel VBA in the processing of safety monitoring data in hydropower projects［J］. Journal of Xihua University: Natural Science Edition , 2009,28 (1):56-59. (in Chinese) |
|
|
|
