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

Realization for Calculation on Characteristical Depth of Open Channel by Excel

作　　者：丁丽泽[1] 欧阳明[2] 章晴雯[1] 

机构地区：[1]嘉兴职业技术学院 [2]浙江工业大学建筑工程学院

出　　处：《水利与建筑工程学报》2013年第2期176-181,共6页Journal of Water Resources and Architectural Engineering

摘　　要：针对正常水深、临界水深、收缩水深和共轭水深这四种明渠特征水深,通过Excel软件的填充柄、单变量求解功能、循环引用迭代计算和规划求解功能四种方法进行求解计算。通过实例计算以及与文献计算结果对比分析,表明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 func- tion. 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 teach- ing and design.

关 键 词：明渠 特征水深 EXCEL 高次方程 

分 类 号：TV133[水利工程—水力学及河流动力学]