基于Excel的水力学隐式方程求解与辅助绘图

Hydraulics implicit equation solution and aided drawing based on Excel

文章通过几个实例,介绍了应用Excel求解水力学隐式方程的单变量求解法和简单迭代法。实例计算表明单变量求解法和简单迭代法具有求解过程简单,结果精度高,通用性强的特点。此外,运用实例介绍了Excel应用于水力学计算的简便辅助绘图功能。

Through some examples, the paper introduces goal seeking method and simple iterative method to solve hydraulic implicit equation based on Excel. The result shows the two methods have many characteristics of simple solving process, high accuracy and strong generality. In addition, the paper introduces simple aided drawing function to hydraulics calculation based on Excel.