摘要
文章根据某水电站闸坝库容、水位以及下泄流量等对应关系,通过Excel软件的多项拟合算法,将离散的数据点拟合成库容-水位、下泄流量-闸门开度连续的曲线关系;结合设计考虑的优化调整闸坝泄洪闸工作闸门规定,当水电站库水位、入库流量及机组负荷调整等情况下,通过Excel逻辑运算模型可以较准确算出闸坝下泄流量和泄洪闸门开度,以此来保证闸坝水位运行在允许范围内。通过Excel多项拟合运算的方式提高了计算的精度,减少了闸门动作频次,提高了操作效率,节约了人力成本,降低了闸坝漫坝和拉空的风险,对于电站闸坝设备设施安全稳定运行有较大意义。
According to the corresponding relations between the reservoir capacity,water level,and discharge of the gate dam of a hydropower project,the continuous curve relationships between the reservoir capacity and water level,discharge and gate opening are fitted with the discrete data points by the method of multiple fitting of Excel software.Combined with the design consideration of the optimization and adjustment of the working gate,when the water level of the reservoir,the discharge into the reservoir and the load of the unit are adjusted,the discharge under the dam and the opening of the sluice gate can be calculated accurately through the Excel calculation,so as to ensure that the water level of gate dam is operating within the allowable range.The calculation precision is improved by using Excel multiple fitting algorithm method,which reduces the gate operation frequency,improves the operation efficiency,saves the labor cost,reduces the overflow and the risk of the dam,and has great significance for the safe and stable operation of the dam and the equipment.
作者
王志
吴家乐
涂鸿焱
李泉
张芯萁
刘碧武
WANG Zhi;WU Jiale;TU Hongyan;LI Quan;ZHANG Xinqi;LIU Biwu(Yalong River Hydropower Development Co.,Ltd.,Chengdu Sichuan 610051)
出处
《四川水力发电》
2024年第S01期112-117,153,共7页
Sichuan Hydropower
