Friction Factor Calculation in Excel
Radigan Engineering have a free to download excel spreadsheet.
Taken from their website:
When in the course of human events it becomes necessary to calculate the Darcy-Weisbach friction factor… engineer’s often throw up their hands, go back to their old college textbooks, and say “about .02!” [Which normally isn’t off by more than a factor of 2 in either direction.] If you want to be more scientific about it, you can calculate the appropriate flow parameters and then refer back to your Moody Diagram to get a “real” answer. But now, thanks to the miracle of Excel, you can use your trusty old Moody Diagram AND have an instant answer at the push of a button. The Excel spreadsheet linked at the bottom of this page contains the Churchill Correlation equations for the friction factor along with a plot that has been carefully overlaid on top of a standard Moody diagram. Just enter your relative pipe roughness (ε/D) into the cell highlighted in red and the chart will update with the appropriate friction factor calculations. For a single-point value, enter your Reynold’s number into the cell highlighted in green, and your friction factor will be calculated in C8.
Click on the link to be re-directed to their website and download the spreadsheet.