pipe_calculator.xlsm

Sheet1

Pipe Length (m) = 30 Reynolds No. = 98803.5330105834 Flowrate calculation from velocity :
Pipe Diameter (mm) = 150 Friction factor = 0.0254460413 Velocity V (m/s) 1
Volume flow rate (m3/hr) = 63.62 Major lossess (m)= 0.2596744373 Area A (m2) 1.77E-02
Gravity accelecration (m/sec2) = 9.81 Minor lossess (m)= 0.1785858395 Volume flow rate (m3/s) = 0.018
Pipe Material Commercial Steel Total lossess (m) = 0.4382602767 Volume flow rate (m3/hr) = 63.62
Density (kg/m3) = 1000
Dynamic Viscosity (N.s/m2) = 1.52E-03
Valves section : Tees
How Many valves in your system : How Many :
Gate valve = 0 Flow in line = 0
Reflux valve 0 Line to branch flow = 0
Globe valve = 0
Butterfly valve = 0
angle valve = 0
foot valve = 0
air valve = 0
ball valve = 0
How Many elbows in your system :
90 degrees elbows (R/D <0.6) = 0
45degrees elbows (R/D <0.6) = 0
11.25 degrees elbows (R/D >2) = 0
22.5 degrees elbows (R/D >2) = 0
45 degrees elbows (R/D >2) = 0
90 degrees elbows (R/D >2) = 0

Find

Sheet2

Commercial Steel 0.457
Drawn Tubing or Plastic 0.0015
Cast Iron 0.2591
Galvanized Iron 0.1524
Concert 0.3048