河南水利与南水北调2025，Vol.54Issue(10)：52-54,3.
基于VBA编程技术实现水工建筑物设计中波浪要素计算
The Calculation of Wave Elements in Hydraulic Structure Design Based on VBA Programming Technology
张涛 1李奕宏2
作者信息
- 1. 山东省水利勘测设计院有限公司,山东 济南 250013
- 2. 黄河水利委员会黄河水利科学研究院,河南 郑州 450003
- 折叠
摘要
Abstract
This paper aims to simplify the calculation of wave elements for different types of hydraulic structures.By analyzing the differences and connections in wave element calculations among various hydraulic structures,a computer-aided calculation program for wave elements is developed using Excel's VBA to write macros and custom functions.On this basis,calculation modules for"crest elevation"and"wave pressure"are compiled.Case studies verify that the calculation results are accurate,the calculation process is simple,and the program is convenient and feasible.关键词
水工建筑物/波浪要素计算/VBAKey words
hydraulic structures/calculation of wave elements/VBA分类
建筑与水利引用本文复制引用
张涛,李奕宏..基于VBA编程技术实现水工建筑物设计中波浪要素计算[J].河南水利与南水北调,2025,54(10):52-54,3.
