Utilizing CSi API Embedded in VBA for Designing Reinforced Concrete Beams According to TCVN 5574:2018

Tóm tắt

DOI: https://doi.org/10.66195/mtu.2025.14.110

This paper presents an approach to designing reinforced concrete (RC) beams in accordance with TCVN 5574:2018 using the CSi Application Programming Interface (API) integrated with VBA Excel. By connecting directly to ETABS, the method automatically extracts critical internal forces, including negative moments at the 1/4-span, positive moments at the 1/5-span, and shear at three selected sections according to a simplified formula. It further identifies the location of shear force Q near the support if a <2.5ℎo . Comparison with conventional design methods reveals that automating data retrieval through CSi API substantially reduces the manual effort required and mitigates potential errors in entering internal forces. In addition, key results-such as negative and positive moment values-are systematically filtered and organized, allowing engineers to quickly evaluate flexural and shear demands on the beam. Overall, the study underscores the benefits of leveraging CSi API in conjunction with VBA Excel for efficient, accurate, and reliable RC beam design.