Simulation of Torricelli Effluent Flow by Using Visual Basic for Application (VBA) on Microsoft Excel

Abstract

-Simulation of Torricelli effluent flow was created by using Visual Basic for Application (VBA) on Microsoft Excel. It describes a container with a cross sectional area A 1 filled by water with a certain level h 1 . At the container's wall, there is a small leakage with a leakage height h 2 and a cross sectional area A 2 . If the quantity of water in the container is very large (A 1 >> A 2 ), the speed of water is constant, and the effluent distance of water out from leakage (x) can be simply determined by applying the Bernoulli principle, the equation of continuity, and the formula of free-fall motion. However, if the cross sectional area of container is proportional to the leakage's cross sectional area, then the speed of effluent water decreases with time and the formula of effluent distance is revisited. The simulation program was generated by the Euler method and analytical calculation. The manipulated variables are water level, leakage height, buffer height, container cross sectional area, and leakage cross sectional area. The simulation presents idealized condition by ignoring the air resistance, adhesion force, and surface tension of water so that it deviates from experimental results.

Analysis of Higher Order Thinking Skills (HOTs) on Simple Harmonic Motion Concept Using Virtual Laboratory Based on VBA Excel Study in Physics Education Students of Universitas Cenderawasih

“…The use of VBA Excel in learning physics on the concept of vibration on a swing can be used to analyze the increase in students' learning achievement, enthusiasm, and thinking skills [49], [54]. However, the use of VBA Excel requires practice because not all students are familiar with the code or syntax in Excel [55]. Especially if students do not have a good apperception of vibrations and trigonometric mathematical equations.…”