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 (ESCI) identifier

  • Publication Type: Article / Article
  • Volume: 10
  • Publication Date: 2018
  • Journal Indexes: Emerging Sources Citation Index (ESCI)
  • Keywords: MS Excel add-in, Darcy friction factor, Colebrook Equation, Friction factor models, EXPLICIT APPROXIMATIONS, COLEBROOKS EQUATION, TURBULENT-FLOW, SMOOTH PIPES, FORMULAS, REGIMES, ROUGH
  • Yıldız Technical University Affiliated: Yes


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