Excel与迭代法结合判断水工建筑物下游水跃衔接形式

The Combination of Excel and Iterative Method to Determine Downstream Hydraulic Jump Cohesion Forms of Hydraulic Structures

在水力计算中,判断下游水跃衔接形式时,通常采用试算法或迭代法,这两种方法计算量都较大,本文将Micr osof t Excel软件应用到解决该问题中,借助Excel的相对引用、绝对引用、公式计算和if函数,快速判断溢流坝下游水跃衔接形式。

In hydraulic calculation,algorithm or iterative methodare usually used to determine the downstream hydraulic jumpconnection form,but the two methods both need large amount ofcalculation.In this paper,Microsoft Excel will be used to solvethe problem.With the help of Excel,including relative references,the absolute reference,formula calculation and the iffunction,we can quickly determine the downstream hydraulicjump cohesion form of an overflow dam.