关键词: Excel-VBA, ANSYS-APDL, 拱坝, 参数化建模

Abstract: Modeling of arch dam is growing more and more difficult as its complex shape. To get the required coordinates of arch dam modeling, this paper does secondary development of Excel by VBA. And acquired coordinates could generate executable APDL code, which would make establishing double-curvature arch dam model more quickly and efficiently. It could save a lot of time for the next simulation analysis and calculation of arch dam. The result shows that the parameterized modeling of arch dam becomes more convenient and accurate by the method combining Excel-VBA and APDL.

Key words: Excel-VBA, ANSYS-APDL, arch dam, parametric modeling