Preprint Review Version 1 Preserved in Portico This version is not peer-reviewed

Excel VBA-Based User Defined Functions for Highly Precise Colebrook’s Pipe Flow Friction Approximations: A Comparative Overview

Version 1 : Received: 5 April 2021 / Approved: 6 April 2021 / Online: 6 April 2021 (13:27:55 CEST)

A peer-reviewed article of this Preprint also exists.

Brkić, D. and Stajić, Z., 2021. Excel VBA-Based User Defined Functions for Highly Precise Colebrook’s Pipe Flow Friction Approximations: A Comparative Overview. Facta Universitatis, Series: Mechanical Engineering 19(2):253-269. https://doi.org/10.22190/FUME210111044B Brkić, D. and Stajić, Z., 2021. Excel VBA-Based User Defined Functions for Highly Precise Colebrook’s Pipe Flow Friction Approximations: A Comparative Overview. Facta Universitatis, Series: Mechanical Engineering 19(2):253-269. https://doi.org/10.22190/FUME210111044B

Journal reference: Facta Universitatis, series: Mechanical Engineering (FU Mech Eng) 2021, 19, 7267
DOI: 10.22190/FUME210111044B

Abstract

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.

Keywords

Hydraulic resistance; Colebrook flow friction; Lambert W-function; Excel Macro Programming; Visual Basic for Applications (VBA); User Defined Functions (UDFs)

Subject

MATHEMATICS & COMPUTER SCIENCE, Algebra & Number Theory

Comments (0)

We encourage comments and feedback from a broad range of readers. See criteria for comments and our diversity statement.

Leave a public comment
Send a private comment to the author(s)
Views 0
Downloads 0
Comments 0
Metrics 0


×
Alerts
Notify me about updates to this article or when a peer-reviewed version is published.
We use cookies on our website to ensure you get the best experience.
Read more about our cookies here.