| 基于Excel VBA 的年调节电站水能计算程序编译及应用 |
| |
| 引用本文： | 郑 州,陈 新,杨小龙,李全燎.基于Excel VBA 的年调节电站水能计算程序编译及应用[J].西南民族大学学报(自然科学版),2015,41(2):234-238. |
| |
| 作者姓名： | 郑 州 陈 新 杨小龙 李全燎 |
| |
| 作者单位： | 四川大学 水利水电学院,四川大学 水利水电学院,四川大学 水利水电学院,四川大学 水利水电学院 |
| |
| 摘 要： | 水电站电能指标计算在工程规划设计中对电站发电能力评估,其中等出力法的计算涉及大量的假设试算插值工作。结合实际需要,在利用Excel强大数据处理功能的同时,引入VBA编程方法,用编译的计算程序实现试算和插值过程,使计算更加快捷准确。程序应用结果表明,程序计算速度快,计算过程灵活,取得了良好的应用效果。
|
| 关 键 词： | 水能计算 等出力法 Excel VBA 试算 |
| 收稿时间： | 2014/11/28 0:00:00 |
| 修稿时间： | 2015/3/26 0:00:00 |
Program complication and application of the calculation of hydro -powerSplant in Annual regulation based on Excel VBA |
| |
| zhengzhou,chenxin,yang xiao long and li quan liao.Program complication and application of the calculation of hydro -powerSplant in Annual regulation based on Excel VBA[J].Journal of Southwest University for Nationalities(Natural Science Edition),2015,41(2):234-238. |
| |
| Authors: | zhengzhou chenxin yang xiao long and li quan liao |
| |
| Institution: | Water resources and hydropower college of Si Chuan University,Water resources and hydropower college of Si Chuan University,Water resources and hydropower college of Si Chuan University,Water resources and hydropower college of Si Chuan University |
| |
| Abstract: | Calculation of Hydro-power station power index that plays an important guidance in engineering plan-ning and designing evaluation of power generation capacity .The same output method involves in lots of assump-tions and interpolation. Combined with the actual needs, in the use of Excel powerful data processing capabilities,the introduction of VBA programming method, the trial and the interpolation process is realized by a program,which makes the calculation more accurate and rapid. The application results show that the calculation speed is
fast, the calculation process is flexible, obtains a good application effect. |
| |
| Keywords: | Hydro-power calculation the same output method Excel VBA The trial |
|
| 点击此处可从《西南民族大学学报(自然科学版)》浏览原始摘要信息 |
| 点击此处可从《西南民族大学学报(自然科学版)》下载免费的PDF全文 |
|
