排灌机械工程学报2011，Vol.29Issue(2)：123-126,4.DOI:10.3969/j.issn.1674-8530.2011.02.007
基于Excel的水泵性能试验数据处理的VBA开发
Development of VBA for pump performance experimental data based on Excel
摘要
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-4 submersible pumps, doing the hydraulic performance tests, 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.关键词
水泵性能/试验数据/曲线拟合/插值计算/ExcelKey words
pump performance/ experimental data/ curve fitting/ interpolation calculation/ Excel分类
农业科技引用本文复制引用
汤跃,赵坤,许文博..基于Excel的水泵性能试验数据处理的VBA开发[J].排灌机械工程学报,2011,29(2):123-126,4.基金项目
"十一五"国家科技支撑计划项目(2008BAF34B15-1) （2008BAF34B15-1）
江苏省自然科学研究重点项目(BK2007706) （BK2007706）
