摘要
水泵性能曲线试验数据在用Excel表格进行存储时,为了使水泵性能数据在Excel通用电子表中能自动进行数值计算,利用VBA对原先编制的Excel水泵性能试验数据处理表进行了二次开发.在电子表中增加了水泵试验容差等级选择和试验结果按钮,根据GB/T 3216—2005标准规定的容错等级和判别准则以及最小二乘拟合算法和插值计算算法,分别对这两个功能按钮进行了VBA编程,通过点击试验结果按钮,就可实现水泵性能试验数据的插值计算和性能判别,得到了水泵规定点和交点的性能数据及判别结果.以BQW15-30-4型潜水泵为应用实例,进行水力性能试验,并进行了性能判别及绘制性能曲线.结果表明,H-Q曲线刚好与容差十字线垂直线段下端相交,满足要求.该方法增强了Excel处理水泵试验数据的插值计算功能,省略大量曲线绘制工作.
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.
出处
《排灌机械工程学报》
EI
2011年第2期123-126,共4页
Journal of Drainage and Irrigation Machinery Engineering
基金
'十一五'国家科技支撑计划项目(2008BAF34B15-1)
江苏省自然科学研究重点项目(BK2007706)
关键词
水泵性能
试验数据
曲线拟合
插值计算
EXCEL
pump performance
experimental data
curve fitting
interpolation calculation
Excel
