节点文献

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

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

  • 推荐 CAJ下载
  • PDF下载
  • 不支持迅雷等下载工具,请取消加速工具后下载。

【作者】 成小松

【Author】 CHENG Xiao-song(Guizhou Provincial Hydrology &Water Resources Bureau,Guiyang,Guizhou,550002,China)

【机构】 贵州省水文水资源局 贵州贵阳550002

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

【Abstract】 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.

  • 【文献出处】 贵州水力发电 ,Guizhou Water Power , 编辑部邮箱 ,2007年05期
  • 【分类号】TP391.13
  • 【被引频次】4
  • 【下载频次】283
节点文献中: 

本文链接的文献网络图示:

本文的引文网络