D'Arcy-Weisbach pressure loss in Excel

Click For Summary
SUMMARY

The discussion focuses on implementing the D'Arcy-Weisbach equation for calculating pressure loss in a fluid system using Excel. The user initially provided an incorrect formula and sought assistance in correcting it. The correct formula for pressure loss in Excel is given as =(C4*(C5/C6))*((C7*(C8*C8))/2), where C4 represents the friction coefficient, C5 is the length of the pipe, C6 is the hydraulic diameter, C7 is the density, and C8 is the velocity. This correction is crucial for accurate pressure loss calculations in engineering applications.

PREREQUISITES
  • Understanding of the D'Arcy-Weisbach equation
  • Familiarity with Excel formulas and functions
  • Knowledge of fluid dynamics concepts
  • Basic understanding of pressure loss calculations
NEXT STEPS
  • Research the D'Arcy-Weisbach equation in detail
  • Learn advanced Excel techniques for engineering calculations
  • Explore fluid dynamics principles related to pressure loss
  • Investigate common errors in Excel formulas for engineering applications
USEFUL FOR

Engineers, fluid dynamics specialists, and Excel users involved in calculating pressure loss in piping systems will benefit from this discussion.

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

Tubing Pressure drops with Compressible Fluids
  • · Replies 3 ·
Replies
3
Views
2K
Shouldn't pressure loss quadruple if flow rate doubles?
  • · Replies 5 ·
Replies
5
Views
5K
How to calculate water pressure drop in cooling tower piping system?
  • · Replies 1 ·
Replies
1
Views
4K
[Fluid Dynamics] Losses in branched pipes etc.
  • · Replies 2 ·
Replies
2
Views
2K
Heat Loss in insulated Pipework
  • · Replies 2 ·
Replies
2
Views
2K
Concept subsea PHES system, /advice with calculations
  • · Replies 8 ·
Replies
8
Views
2K
Pressure loss pipe system: Conversion from known fluid1 to fluid2
  • · Replies 8 ·
Replies
8
Views
2K
Flow through Interconnected Tubes
  • · Replies 1 ·
Replies
1
Views
2K
Pressure drop analysis on water pipe system w/pump
  • · Replies 29 ·
Replies
29
Views
9K
Pressure loss in an HVAC system
  • · Replies 19 ·
Replies
19
Views
3K