基于Excel VBA的年调节电站水能计算程序编译及应用  

Program complication and application of the calculation of hydro-power plant in annual regulation based on Excel VBA

作　　者：郑州[1] 陈新[1] 杨小龙[1] 李权燎 

机构地区：[1]四川大学水利水电学院

出　　处：《西南民族大学学报（自然科学版）》2015年第2期234-238,共5页Journal of Southwest Minzu University(Natural Science Edition)

基　　金：国家自然科学基金青年项目(41102194)

摘　　要：水电站电能指标计算在工程规划设计中对电站发电能力评估起着重要指导作用,其中等出力法的计算涉及大量的假设试算插值工作.结合实际需要,在利用EXCEL强大数据处理功能的同时,引入VBA编程方法,用编译的计算程序实现试算和插值过程,使计算更加快捷准确.程序应用结果表明,程序计算速度快,计算过程灵活,取得了良好的应用效果.Calculation of Hydro-power station power index plays an important role in planning and designing evaluation of power generation capacity. The co-output method involves lots of assumption and interpolation. This paper takes into consideration the actual needs, uses the powerful data processing capabilityy of Excel,introduces VBA programming,realizes the trim calculation and interpolation process by a calculation program, which makes the calculation more accurate and rapid. The application results show that the calculation speed is fast, and that the calculation process is flexible, which results in a good application effect.

关 键 词：水能计算 等出力法 EXCEL VBA 试算 

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