An MS Excel Add-in for Calculating Darcy Friction Factor


Duman S., Demir S. , Manav Demir N. , Karadeniz A.

SPREADSHEETS IN EDUCATION, vol.10, 2018 (Journal Indexed in ESCI) identifier

  • Publication Type: Article / Article
  • Volume: 10
  • Publication Date: 2018
  • Title of Journal : SPREADSHEETS IN EDUCATION
  • Keywords: MS Excel add-in, Darcy friction factor, Colebrook Equation, Friction factor models, EXPLICIT APPROXIMATIONS, COLEBROOKS EQUATION, TURBULENT-FLOW, SMOOTH PIPES, FORMULAS, REGIMES, ROUGH

Abstract

An MS Excel add-in was prepared for calculating Darcy friction factor. The tool contains a function named "FFACTOR" and it calculates friction factor under laminar, transient, and turbulent conditions. Under turbulent conditions, the function employs a total of 25 friction factor models and the user can select one of these to calculate Darcy friction factor. Tip texts and pop-up help were also prepared and are available if open-source Excel-DNA Intellisense add-in is also added to MS Excel. The students can benefit from the MS Excel add-in. Also, professors can use it for teaching purposes