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.
Highlights
The Colebrook equation from 1939 [1], Eq (1), is an informal standard widely accepted in engineering practice for calculation of turbulent Darcy’s fluid flow friction factor
To facilitate use of the Colebrook equation in spreadsheet solver MS Excel [21,22], codes written in Visual Basic for Applications (VBA) based on the available highly precise explicit approximations [23,24,25,26,27,28,29,30] are given as User Defined Functions (UDFs) and compared in this review paper
The codes for solving the Colebrook equation used in this review paper are shown through macros for MS Excel written in Visual Basic for Applications (VBA)
Summary
The Colebrook equation from 1939 [1], Eq (1), is an informal standard widely accepted in engineering practice for calculation of turbulent Darcy’s fluid flow friction factor. To facilitate use of the Colebrook equation in spreadsheet solver MS Excel [21,22], codes written in Visual Basic for Applications (VBA) based on the available highly precise explicit approximations [23,24,25,26,27,28,29,30] are given as User Defined Functions (UDFs) and compared in this review paper. Such approach automates computational processes and speeds up manual tasks
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: Facta Universitatis, Series: Mechanical Engineering
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
