Simulation of Torricelli Effluent Flow by Using Visual Basic for Application (VBA) on Microsoft Excel
- DOI
- 10.2991/icaet-14.2014.39How to use a DOI?
- Keywords
- Torricelli principle, Bernoulli, VBA 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 A1 filled by water with a certain level h1. At the container's wall, there is a small leakage with a leakage height h2 and a cross sectional area A2. If the quantity of water in the container is very large (A1>> A2), 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.
- Copyright
- © 2014, the Authors. Published by Atlantis Press.
- Open Access
- This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).
Cite this article
TY - CONF AU - Dinar Maftukh Fajar AU - Neny Kurniasih AU - Khairurrijal PY - 2015/01 DA - 2015/01 TI - Simulation of Torricelli Effluent Flow by Using Visual Basic for Application (VBA) on Microsoft Excel BT - Proceedings of the 2014 International Conference on Advances in Education Technology PB - Atlantis Press SP - 158 EP - 161 SN - 2352-5398 UR - https://doi.org/10.2991/icaet-14.2014.39 DO - 10.2991/icaet-14.2014.39 ID - Fajar2015/01 ER -