D'Arcy-Weisbach pressure loss in Excel

AI Thread Summary
The discussion focuses on creating an Excel workbook to calculate pressure drops using the Darcy-Weisbach equation. The user initially provided an incorrect formula for pressure loss in their Excel setup. The correct formula should include density multiplied by the square of velocity, rather than the square root of velocity. This correction is crucial for accurate pressure loss calculations in fluid systems. The conversation highlights common frustrations encountered when working with complex equations in Excel.
bsharp
Messages
7
Reaction score
0
Hello,

I am working on making an Excel work book to aid in figuring out pressure drops in a system. I am trying to use the Darcy Weisbach equation for pressure loss.
http://www.engineeringtoolbox.com/darcy-weisbach-equation-d_646.html"

In Excel I have
=(C4*(C5/C6))*((C7+(SQRT(C8)))/2)

C4= Friction coefficient
C5= Length of pipe
C6= Hydraulic dia
C7= Density
C8= Velocity

Please help me out.
 
Last edited by a moderator:
Engineering news on Phys.org
bsharp said:
In Excel I have
=(C4*(C5/C6))*((C7+(SQRT(C8)))/2)

Should be

=(C4*(C5/C6))*((C7*(C8*C8))/2)

I hate it when that happens :)
 

Similar threads

Shouldn't pressure loss quadruple if flow rate doubles?
Replies
5
Views
5K
[Fluid Dynamics] Losses in branched pipes etc.
Replies
2
Views
2K
Pressure drop analysis on water pipe system w/pump
Replies
29
Views
9K
Tubing Pressure drops with Compressible Fluids
Replies
3
Views
1K
A couple questions regarding pressure drop
Replies
3
Views
13K
Converting from Static to Dynamic Understanding the Darcy Weisbach
Replies
1
Views
2K
Hydraulics and the darcy weisbach formula
Replies
3
Views
8K
How to calculate water pressure drop in cooling tower piping system?
Replies
1
Views
3K
I Calculate Minor Losses due to Flow Geometry Alone
Replies
3
Views
3K
Heat Loss in insulated Pipework
Replies
2
Views
2K

Hot Threads

Recent Insights

Back
Top