| 基于Excel宏的径流式水电站水能计算简易模型 |
| |
| 引用本文： | 原文林,方洪斌,马跃先,王梁.基于Excel宏的径流式水电站水能计算简易模型[J].水电能源科学,2012,30(5):108-111. |
| |
| 作者姓名： | 原文林 方洪斌 马跃先 王梁 |
| |
| 作者单位： | 郑州大学水利与环境学院,河南郑州,450002 |
| |
| 基金项目： | 国家自然科学基金资助项目(50679053，51109189)；中国博士后科学基金资助项目(20100471007) |
| |
| 摘 要： | 针对目前径流式水电站水能计算方法存在的不足,基于水文学和水能计算的相关原理,运用Excel软件的函数图表与统计分析功能对计算各要素做相应处理,并对计算指标作合理修正,整体过程依托Excel宏操作,加入折减系数模块化后建立计算简易模型,并以引沁河口水电站为例进行计算。结果表明,该简易模型不仅提高了水能计算效率,且精度较高。
|
| 关 键 词： | Excel宏 径流式水电站 水能计算简易模型 折减系数 |
Waterpower Calculation Simplified Model of Runoff River Hydropower Station Based on Excel Macro |
| |
| YUAN Wenlin,FANG Hongbin,MA Yuexian and WANG Liang.Waterpower Calculation Simplified Model of Runoff River Hydropower Station Based on Excel Macro[J].International Journal Hydroelectric Energy,2012,30(5):108-111. |
| |
| Authors: | YUAN Wenlin FANG Hongbin MA Yuexian and WANG Liang |
| |
| Affiliation: | College of Water Conservancy and Environmental Engineering, Zhengzhou University, Zhengzhou 450002, China;College of Water Conservancy and Environmental Engineering, Zhengzhou University, Zhengzhou 450002, China;College of Water Conservancy and Environmental Engineering, Zhengzhou University, Zhengzhou 450002, China;College of Water Conservancy and Environmental Engineering, Zhengzhou University, Zhengzhou 450002, China |
| |
| Abstract: | To solve waterpower calculation problem of runoff river hydropower station, the function charts and statistical analysis function in Excel software are used to deal with each element based on the hydrology and waterpower calculation theory. And reasonable correction is made on calculation index. Then the whole process depends on the Excel macro operation. Finally, waterpower calculation model is established with reduction coefficient modeling. Taking Hekou hydropower station in Yinqin river for an example, the results show that the simplified model improves the efficiency of waterpower calculation with high precision. |
| |
| Keywords: | Excel macro runoff river hydropower station waterpower calculation simplified model reduction coefficient |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
