Proceedings of the 2014 International Conference on Advances in Education Technology

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

Authors
Dinar Maftukh Fajar, Neny Kurniasih, Khairurrijal
Corresponding Author
Dinar Maftukh Fajar
Available Online January 2015.
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/).

Download article (PDF)

Volume Title
Proceedings of the 2014 International Conference on Advances in Education Technology
Series
Advances in Social Science, Education and Humanities Research
Publication Date
January 2015
ISBN
978-94-62520-44-8
ISSN
2352-5398
DOI
10.2991/icaet-14.2014.39How to use a DOI?
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  -