埃特金迭代法在骨干坝调洪演算中的应用

Application of Aitken Accelerated Iterative Method in the Key Dam Flood Routing

列表试算是调洪演算最常用的方法,试算时采用埃特金加速迭代法进行计算,不需要求解导数,适合利用集成于Excel与AutoCAD中的VBA编制计算程序,从Excel VBA中直接调用AutoCAD数据并生成水位—库容关系曲线图,在埃特金加速迭代过程中,程序自动查算AutoCAD中的水位—库容关系曲线图,避免了曲线插值和传统手工查图造成的误差。该方法既简便易懂,又提高了计算精度,是骨干坝调洪演算的可行途径。通过实例对比分析,列表采用埃特金加速迭代法和简化三角形法,两者计算结果基本一致。

List of trial is the most commonly used method for flood regulating calculation. When we make a trial,we often use Aitken acceler-ated iterative method to calculate but not the derivative. It is suitable for using integrated in Excel and AutoCAD VBA program. In Excel VBAin use of AutoCAD generate water capacity curve graph. In the process of Aitken accelerated iterative procedure,the program automaticallychecks the storage capacity curve. The method reduces the error of curve interpolation and traditional manual reading. This method is simpleand easy to understand,and improves the accuracy of calculation. It is a feasible way to adjust the flood routing of the key dam.Through thecomparative analysis of examples,calculation results by the list using Aitken acceleration iteration method and the simplified triangle methodare basically the same.