Developing Soil Liquefaction Analysis Program created on Visual Basic Analysis in MS Excel based on the 2018 Turkish Seismic Code

The rapid increase in the world's population, the desire to revise old structures or to need new structures, and the decrease in usable areas in some big cities lead engineers to examine ground conditions more. Due to Turkey's location and geological structure, earthquake occurrences are quite high. The loss of life and property, which has increased with the earthquakes that have occurred in our country in recent years, has been examined and it has been seen that this situation is related to the ground factor rather than the superstructure design inadequacies. In this sense, the main goal of investors is to optimize the profit to be obtained by providing the aesthetics of the superstructure, comfort, and interior quality in building projects such as residences and offices. For this reason, geotechnical design is becoming a discipline that needs to be solved most economically. Starting the investment without paying due attention to the seismicity of the ground in the investment budgets, when the risk of liquefaction in the ground may come to the fore, it is possible to avoid unaccounted ground improvement methods, so new buildings with the risk of soil liquefaction are added to the unsafe old building stock. With the 2018 Seismic Code in Turkey, liquefaction on the ground and different problems that occur in the ground have been examined in more detail. Within the scope of the study, it was focused on getting faster results with faster and on-site determinations of the liquefaction situation on the ground, thanks to the Visual Basic application program prepared in Excel. In this sense, with the program prepared as the aim of the study, it is aimed to enable the construction of the soil liquefaction analysis to be made quickly and with less cost and to start the construction with a realistic budget and structural models. The program continuously increases its sensitivity and accuracy with additional inputs. This allows geotechnical engineers to achieve faster and earlier results Earthquake; Soil Liquefaction; TBDY; 2018 Turkish Seismic Code Regulation