Excel的迭代计算在河道水面曲线计算中的应用

Application of Excel Iterative Computing Method in Curve Calculation of River Water Surface

在天然河道治理、防洪规划和水利工程建设中,需要确定河道水面曲线。天然河道的水流一般是非恒定非均匀流,然而由于河道中各种水力要素随时间的变化非常缓慢,可以认为天然河道在一定时间内是恒定非均匀流。在河道水面曲线计算中,常用的方法有试算法和图解法。本文根据天然河道恒定非均匀流水面曲线的公式,采用Excel软件的迭代计算功能,以贵州省清水河格里桥水电站为实例进行河道水面曲线计算,有效地提高了工作效率。

Curve of river water surface need be determined in natural river improving, flood control planning and construction of conservancy project. Flow in natural river is generally transient and non-uniform one, but because various hydraulic factors change with time very slowly, flow in natural, therefore, could be considered as constant non-uniform one in certain period. In the light of water surface curve computing formula of constant non-uniform flow in natural river, using iterative function of Excel soft ware the writer calculated water surface curve of the Qingshuihe River in Guizhou Provence for Geliqiao Hydropower Station as an example. It effectively improves calculation efficiency.