运用EXCEL宏设计淤地坝溢洪道陡坡段水面曲线计算表格的方法

The Method of Design a Table for Calculating the Water Surface Curve of the Abrupt Slope Section of the Check Dam Spillway Using EXCEL Macro

淤地坝设计中,溢洪道陡坡段水面曲线的计算是比较繁琐的一个环节,主要存在的问题是,计算公式复杂、参数较多、需要反复试算,使得每一个拟设溢洪道断面的设计和调整,都会浪费很多时间,少则个把小时,多则半天至一天。文中把EXCEL宏运用到水面曲线计算表格的设计中,因而把计算过程缩短至几秒钟,极大地提高了设计效率。

In design of check dam, the calculation of the water surface curve of the abrupt slope section of the spillway is a coinplicated link. The main problems exist are complex formula, too much parameters and repeated iteration. These problems will waste a lot of time on design and adjustment of each spillway section proposed. We usually need at least an hour, or even half to one day. In this paper, EXCEL macro was used to design the water surface curve computing table, so that the calculation process can be reduced to a few seconds, and the design efficiency could be greatly improved.