基于Excel-VBA与APDL的拱坝参数化建模方法

Parametric modeling of arch dam based on Excel-VBA and APDL

由于拱坝体形较为复杂,拱坝建模难度较大。笔者利用VBA对Excel进行二次开发,得出拱坝建模中所需的点坐标。根据这些点坐标生成ANSYS中可执行的APDL代码,快捷高效地建立了双曲拱坝模型,为此后的拱坝仿真计算创造了条件。实例表明,Excel-VBA与APDL的结合使用,可以使ANSYS中拱坝的参数化建模更为方便和准确。

Modeling of arch dam is growing more and more difficult as its complex shape. To get the re-quired coordinates of arch dam modeling, this paper does secondary development of Excel by VBA. Andacquired coordinates could generate executable APDL code, which would make establishing double-cur-vature arch dam model more quickly and efficiently. It could save a lot of time for the next simulationanalysis and calculation of arch dam. The result shows that the parameterized modeling of arch dam be-comes more convenient and accurate by the method combining Excel-VBA and APDL.