Excel

Dynamic Chart Titles in Excel

One of the things that makes Excel such a great tool is the ease at which you can automate certain tasks. This creates many opportunities for engineers to save time and prevent errors. One often-overlooked opportunity for automation is in chart titles and axis titles. Excel allows you to link the title of a chart …

Dynamic Chart Titles in Excel Read More »

Colebrook Equation Solver in Excel

The Colebrook (or Colebrook-White) equation is the best way to dynamically determine the Darcy-Weisbach friction factor for turbulent pipe flow. The equations were developed via a curve fit to many experimental data points. In the post below, I demonstrate how to create a Colebrook equation solver in Excel. Unfortunately, the equation is implicit (meaning that the …

Colebrook Equation Solver in Excel Read More »

Scroll to Top