摘要
工程实际中解决水力学问题时,正常水深、临界水深、水面线等高次隐函数,难以直接求解。传统方法是利用查图表求解或用试算法求解,也可利用编程求解,但都不太方便。介绍利用Excel单变量求解功能和配合宏的运用,可快捷、精准地解决水力学计算中高次隐函数方程问题;灵活实用可求变底坡、底宽和边坡系数变断面渠道任意位置水深的水面曲线推求程序。
In engineering practice, some hydraulic problems such as normal depth, critical depth and water surface profile, which are higher implicit functions, are difficult to solve directly. Traditional methods solved them by ＂trial method＂ and ＂graph method＂ or by programming, but all of them are not convenient. Using goal seek in Excel, the higher implicit function equations of hydraulic calculation can be solved quickly and accurately. With the use of macros, a water surface profile calculation program which can solve water depth at any position of channel with variable slop or section size was written. This paper introduces the application of solving higher implicit function by goal seek and integration of multiple solving by macros in water surface profile calculation.
出处
《云南水力发电》
2015年第3期25-26,31,共3页
Yunnan Water Power
