Using EXCEL for numerical analysis of fluid flow in series and parallel piping systems and discussing the limitations of the numerical techniques
Keywords:
Numerical Analysis of Fluid, MS Excel, Series and Parallel Piping SystemsAbstract
Fluid dynamics is governed by Bernoulli’s equation which is based on the principle of conservation of energy. Bernoulli’s equation is an energy balance equation that converts fluid potential energy, kinetic energy, and stored energy due to pressure to an equivalent head for a single branch fluid flow system. The Head is in units of length. Friction losses can also be expressed in terms of head and be included in Bernoulli’s equation. However, if the flow rate is unknown, there are more unknowns than equations, and Bernoulli’s equation cannot be used directly. In such a scenario the fluid system must be analyzed by iterative techniques. In the case of a series system, there is only one flow rate and the flow rate can be incrementally changed until the correct solution is obtained. However, in a parallel system, the flow rates are different in various branches. For the parallel piping systems, a halving technique where the interval is cut into half on a repeated basis can be used to investigate various flow rates until the correct flow rate with sufficient accuracy is determined. An EXCEL spreadsheet can be used to automate this process. The analysis techniques for both the series piping systems and parallel piping systems are the theme of this article.
Downloads
Published
How to Cite
Issue
Section
License
The JIIET is an open-access journal meaning that upon publication of research, it will publicly available on the web and can be accessed via search engines. In contrast with traditional journals which charge readers a fee via subscription or single purchase, open-access journals charge authors a fee to pay ongoing costs for lifetime storage of articles.
Authors keep the copyright of published articles in JIEET. The journal provides a platform for authors to publish their works, receive credentials, and keep their name associated with the idea. We recommend authors to apply for an official copyright certificate via the copyright offices in their country.
We at JIIET do not tolerate any research misconduct including plagiarism, playing with data such as trimming, cooking, and forging. We only publish original research works. In other words, your research should not be published in any other journals, books, and conference proceedings. However, presented works at conferences and workshops are acceptable for publications.
JIIET does not accept any responsibility about the consequences of releasing your idea on the web. The only method of protection, which is suitable for publication, is the copyright. This needs authors to apply for copyright through copyright offices. If you like to keep your idea secret for patenting, we do not recommend to publish your idea.