| 基于ExcelVBA实现山塘堰上水头计算的自动化 |
| |
| 作者姓名： | LIU Huixi XIANG Hongli YANG Xiaoling |
| |
| 作者单位： | 1. 浙江省衢州市水利水电勘测设计有限公司,浙江衙州,324002
2. 江山市碗窑水库须江电站,浙江江山,324100 |
| |
| 摘 要： | 分析山塘综合整治工程中堰上水头计算现状,针对存在的问题,提出将Excel的二次开发工具VBA语言应用于堰上水头计算。编写计算程序、将可视化窗口作为用户操作界面,实现山塘综合整治工程堰上水头计算的自动化。将本程序应用于山塘实例,结果表明该程序可实现堰上水头计算的自动、准确、高效进行。
|
| 关 键 词： | Excel VBA 堰上水头 水头计算 山塘 |
Automatic calculation of the ponds weir head based on Excel VBA |
| |
| LIU Huixi,XIANG Hongli,YANG Xiaoling.Automatic calculation of the ponds weir head based on Excel VBA[J].Journal of water resources and water engineering,2011,22(5):161-163. |
| |
| Authors: | LIU Huixi XIANG Hongli YANG Xiaoling |
| |
| Affiliation: | LIU Huixia1,XIANG Hongli1,YANG Xiaoling2(1.Quzhou Design and Research Co.,Ltd.of Water Resource and Hydropower of Zhejiang Province,Quzhou 324002,China,2.Xujiang Power Station of Wanyao Reservoir of Jiangshan,Jiangshan 324100,China) |
| |
| Abstract: | The paper analyzed the present situations of calcuating weir head in the ponds comprehensive improvement project.Aiming at the existing problems,it proposed the application of the secondary development tools of Excel VBA to weir head calculation.Automatic calculation was implemented for the weir head in the comprehensive improvement project through writing the calculating programs and using the visual window as operating interface.This program can be applied in the ponds practice,the results showed that the... |
| |
| Keywords: | Excel VBA weir head calculation of weir head ponds |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
| 点击此处可从《水资源与水工程学报》浏览原始摘要信息 |
|
点击此处可从《水资源与水工程学报》下载全文 |
|
