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 :)
 
Thread 'How can I find the cleanout for my building drain?'

Thread 'How can I find the cleanout for my building drain?'

I am a long distance truck driver, but I recently completed a plumbing program with Stratford Career Institute. In the chapter of my textbook Repairing DWV Systems, the author says that if there is a clog in the building drain, one can clear out the clog by using a snake augur or maybe some other type of tool into the cleanout for the building drain. The author said that the cleanout for the building drain is usually near the stack. I live in a duplex townhouse. Just out of curiosity, I...
View full post »

Thread 'Query on Isentropic relationships (such as PV^gamma = constant)'

Hi all, I have a question. So from the derivation of the Isentropic process relationship PV^gamma = constant, there is a step dW = PdV, which can only be said for quasi-equilibrium (or reversible) processes. As such I believe PV^gamma = constant (and the family of equations) should not be applicable to just adiabatic processes? Ie, it should be applicable only for adiabatic + reversible = isentropic processes? However, I've seen couple of online notes/books, and...
View full post »

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
8K
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