Solution of the Implicit Colebrook Equation for Flow Friction Using Excel - Archive ouverte HAL
Journal Articles Spreadsheets in Education Year : 2017

Solution of the Implicit Colebrook Equation for Flow Friction Using Excel

Dejan Brkić
  • Function : Author

Abstract

Empirical Colebrook equation implicit in unknown ow friction factor (λ) is an accepted standard for calculation of hydraulic resistance in hydraulically smooth and rough pipes. e Colebrook equation gives friction factor (λ) implicitly as a function of the Reynolds number (Re) and relative roughness (ε/D) of inner pipe surface; i.e. λ0=f(λ0, Re, ε/D). e paper presents a problem that requires iterative methods for the solution. In particular, the implicit method used for calculating the friction factor λ0 is an application of xed- point iterations. e type of problem discussed in this "in the classroom paper" is commonly encountered in uid dynamics, and this paper provides readers with the tools necessary to solve similar problems. Students’ task is to solve the equation using Excel where the procedure for that is explained in this “in the classroom” paper. Also, up to date numerous explicit approximations of the Colebrook equation are available where as an additional task for students can be evaluation of the error introduced by these explicit approximations λ≈f(Re, ε/D) compared with the iterative solution of implicit equation which can be treated as accurate.

Domains

Education
Fichier principal
Vignette du fichier
article.pdf (965.31 Ko) Télécharger le fichier
Origin Publisher files allowed on an open archive
Loading...

Dates and versions

hal-01586190 , version 1 (12-09-2017)

Identifiers

  • HAL Id : hal-01586190 , version 1

Cite

Dejan Brkić. Solution of the Implicit Colebrook Equation for Flow Friction Using Excel. Spreadsheets in Education, 2017, 10 (2). ⟨hal-01586190⟩

Collections

TICE
269 View
10749 Download

Share

More