利用Excel实现明渠特征水深计算

针对正常水深、临界水深、收缩水深和共轭水深这四种明渠特征水深,通过Excel软件的填充柄、单变量求解功能、循环引用迭代计算和规划求解功能四种方法进行求解计算。通过实例计算以及与文献计算结果对比分析,表明Excel求解与一般的人工手算或计算机编程计算相比,能更快速、准确、方便地求得各种断面形式的水深,计算过程方便易懂、计算结果精确可靠,为教学和设计等提供了很好的方法和思路。更多还原

Realization for Calculation on Characteristical Depth of Open Channel by Excel

The four kinds of characteristical depths of open channel,i.e.,normal water depth,critical water depth,contracted water depth and conjugate water depth,can be calculated by the four methods with Microsoft Excel such as filling handle,single goal seeking function,and iteration solving by circulating citation and programming solving function.Through the application examples and comparing with the reference results,it is shown that the depths in various kinds of sections can be obtained by Excel more quickly,precisely and conveniently compared with the general methods,such as manual calculation or computer programming.The process of calculation is simple and can be understood easily,the result of calculation is exact and reliable,and the good methods and new ways of thinking can be provided for teaching and design.