Ứng dụng VBA trong Excel lập chương trình tính toán tự động tải trọng gió theo TCVN 2737:2023

Abstract

Currently, the Institute of Construction Science and Technology has compiled many new construction standards to be suitable for practice. Include TCVN 2737:2023, replaced TCVN 2737:1995. The calculation of wind loads according to TCVN 2737:2023 has many new differences compared to TCVN 2737:1995. The main object of the article is to present how to calculate and apply VBA in Excel to create a program to automatically calculate wind loads according to TCVN 2737:2023 for prismatic blocks with flat roofs or roof retaining walls.