Prediction of moment resistance of steel connection with Macro Excel using Eurocode standard

Abstract

To date, the use of information technology has become part of the human lifestyle. The existence of the demands of fast, precise and accurate design is a common standard that must be met which has significant advantage to compete with practitioners who are working with conventional method. In civil engineering, the use of information technology cannot be avoided, whether you like or not engineers must be able to adapt. This is a logical consequence because the analysis involves considerable calculations, iterative, or trial and error. The solution is to create a program application using Fortran, Pascal, or C ++ which sometimes frustrates engineers who are accustomed to manual methods. This paper presents one solution that bridges the existence of a gap to information technology in the form of short programs as a mediator between conventional and automatic calculations. Eurocode standard was used for design steel connection because this code already established and using metric units that commonly used in Indonesia. The parametric analysis was conducted by means of Excel combine with Visual Basic Application (VBA), the calculation performed iteratively for different dimensions and summarized in the form of a table.