摘要
针对国内各水利水电勘测设计院普遍采用的商业软件、自行编程计算、Excel普通自带函数链接计算等方法的优缺点进行了分析,提出了在Excel软件上基于VBA编程的水力自动化计算的方法。实现有针对性的个性化、自动化水力计算。工程实例证明,该方法具有效率高、简单易学等优点,还可利用Excel的图表功能使结果表达得准确直观。
This paper studies advantages and disadvantages of commercial software,self-programming calculation,and Excel calculation method with link function widely used in water conservancy and hydropower investigation and design institutes in China,and proposes the method of hydraulic automatic calculation based on VBA programming in Excel to achieve targeted,personalized and automatic hydraulic calculation.Engineering practices show that the method is highly efficient,simple and easy to learn.It can also present the results accurately and intuitively by using the graph function of Excel.
作者
李倩
申忠辉
LI Qian;SHEN Zhonghui(Guangxi College of Water Resources and Electric Power,Nanning,Guangxi,530007;Guangxi Water and Power Design Institute,Nanning,Guangxi,530023)
出处
《红水河》
2018年第2期15-17,共3页
Hongshui River
基金
2017年度中青年教师基础能力提升项目(2017KY1194)
关键词
水力学
计算
编程
软件
hydraulics
calculation
programming
software