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

Hydraulics implicit equation solution and aided drawing based on Excel

作　　者：鲍新华[1] 卢文喜[1] 李鸿雁[1] 才文韬[1] 谭剑锋[1] 

机构地区：[1]吉林大学环境与资源学院,吉林长春130026

出　　处：《东北水利水电》2010年第9期28-31,共4页Water Resources & Hydropower of Northeast China

摘　　要：文章通过几个实例,介绍了应用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.

关 键 词：EXCEL 水力学隐式方程 单变量求解法 简单迭代法 辅助绘图 

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