Moody Diagram Excel. One of the commonly used approximation is given by lewis moody otherwise known as moody chart or moody diagram. When using excel spreadsheets for pipe flow calculations with the darcy weisbach equation it is more convenient to use equations for the moody friction factor f rather than a graph like the moody diagram.
The following diagrams are the example of moody diagram. This charts or graphs are used for working out rate of flow and pressure drop through the tubes. The moody diagram is one of the things superseded by ms excel.
This worksheet enables a user to specify a reynolds number and a roughness factor and the darcy friction factor for pipe flow is calculated.
There are different ways to calculate it one can be graphical using a moody graph. The friction factor can usually be interpolated between. Re enter the dimensionless roughness factor. We can check the result against a published moody diagram to verify the calculation.