A Simple Numerical Modelling of Refraction and Shoaling Wave Using VBA Excel

Abstract

Wave propagation from the deep water to the shoreline experiences a transformation process. Their transformation, frequently, affects coastal processes such as erosion and sedimentation. In addition, their wave force can also damage the coastal infrastructure. There are three processes of wave transformation that should be modelled, namely, shoaling, refraction, and wave breaking. It is difficult to calculate the wave transformation manually due to the complexity of computation. Therefore, it should be handled using such commercial software, which is mostly very expensive. In order to cope with the problem, a simple numerical model of wave transformation, based on the finite difference method, is carried out using VBA Excel as a programming language. The advantage of using VBA Excel is the easy accessibility due to its integration with Microsoft Office. The aim of this project is to create a simple software for modelling refraction and shoaling waves that can be developed for educational purposes. The outcome of making this software is to meet the availability of wave modelling software in supporting the development of education and teaching in the ocean engineering field. The results of the numerical model are verified using the modelling results of Horikawa and Koutitas.