EXCEL VBA-BASED USER DEFINED FUNCTIONS FOR HIGHLY PRECISE COLEBROOK’S PIPE FLOW FRICTION APPROXIMATIONS: A COMPARATIVE OVERVIEW
| Autor: | Zoran Stajić, Dejan Brkić |
|---|---|
| Rok vydání: | 2021 |
| Předmět: |
Scheme (programming language)
Engineering Civil Polymers and Plastics Mathematics Applied Engineering Multidisciplinary User Defined Functions (UDFs) Visual Basic for Applications Industrial and Manufacturing Engineering Pipe flow symbols.namesake Excel Macro Programming Lambert W function Darcy friction factor formulae Principal branch Civil and Structural Engineering computer.programming_language Colebrook flow friction Mechanical Engineering Lambert W-function Solver User-defined function algebra_number_theory hydraulic resistance Multidisciplinary Sciences Engineering Mechanical Mechanics of Materials Water Resources symbols Computer Science Interdisciplinary Applications Visual Basic for Applications (VBA) computer Algorithm |
| Zdroj: | Facta Universitatis, Series: Mechanical Engineering. 19:253 |
| ISSN: | 2335-0164 0354-2025 |
| DOI: | 10.22190/fume210111044b |
| Popis: | This review paper gives Excel functions for highly precise Colebrook’s pipe flow friction approximations developed by users. All shown codes are implemented as User Defined Functions – UDFs written in Visual Basic for Applications – VBA, a common programming language for MS Excel spreadsheet solver. Accuracy of the friction factor computed using nine to date the most accurate explicit approximations is compared with the sufficiently accurate solution obtained through an iterative scheme which gives satisfying results after sufficient number of iterations. The codes are given for the presented approximations, for the used iterative scheme and for the Colebrook equation expressed through the Lambert W-function (including its cognate Wright ω-function). The developed code for the principal branch of the Lambert W-function has additional and more general application for solving different problems from variety branches of engineering and physics. The approach from this review paper automates computational processes and speeds up manual tasks. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|