基于Excel宏的径流式水电站水能计算简易模型  

Waterpower Calculation Simplified Model of Runoff River Hydropower Station Based on Excel Macro

作　　者：原文林[1] 方洪斌[1] 马跃先[1] 王梁[1] 

机构地区：[1]郑州大学水利与环境学院,河南郑州450002

出　　处：《水电能源科学》2012年第5期108-111,共4页Water Resources and Power

基　　金：国家自然科学基金资助项目(50679053;51109189);中国博士后科学基金资助项目(20100471007)

摘　　要：针对目前径流式水电站水能计算方法存在的不足,基于水文学和水能计算的相关原理,运用Excel软件的函数图表与统计分析功能对计算各要素做相应处理,并对计算指标作合理修正,整体过程依托Excel宏操作,加入折减系数模块化后建立计算简易模型,并以引沁河口水电站为例进行计算。结果表明,该简易模型不仅提高了水能计算效率,且精度较高。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.

关 键 词：EXCEL宏 径流式水电站 水能计算简易模型 折减系数 

分 类 号：TV747[水利工程—水利水电工程]