Page 1

1
2
3
4
5
6
7
8
9
10

PROJECT :

PIPE FRICTION LOSS CALCULATION

D
k
L
V
Nre

11
Reynold no.
Nre critical:
12
2300
13
Rel.roughness
14
Fanning fric.fact.
f
V2
15
Dynamic pressure
16
Frict.loss str.pipe
17
--"-18 Restrictions , fixed (indep.of diam.):
19
20
Pipe entrance r/d
0
21
Pipe exit
0
22
23
24
25
26
27
28
29
30
31
32
33
34
Friction loss restrictions :
35
--""-36 Restrictions , calculated :
37 (incl.loss in restr.length)
38
39
Elbow 90o r/d
1.5
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Friction loss restrictions :
62
--""--

m3/ h
kg/m3
cSt
m
m
m
m/s
Fl.pattern:
k/D
Pa
Pa
bar

29566
turb.
0.00032
0.024
1175
2239
0.022
Qty

2-3
400.0
842
8.7
0.154
5.00E-05
20
5.965
105594
turb.
0.00032
0.019
14982
37934
0.379
Qty

3-4
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

4-5
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

5-6
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

6-7
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

7-8
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

8-9
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

pump

8.7

10-11
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

11-12
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

12-13
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

13-14
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

14-15
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

15-16
112.0
1000
8.7
0.1
5.00E-05
100
3.961
45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

Date: 7/9/2015 ISC a/s

45532
turb.
0.00050
0.023
7846
180666
1.807
Qty

0.5
1

1
1

1
1

Pa
bar

1.5
1762
0.02

1.5
22472
0.22

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

0
0
0.00

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

Qty

14

10

Pa
bar

84
0.014
1.176
1381
0.01

140
0.014
1.96
29364
0.29

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

0
0.016
0
0
0.00

l/d

l/d
fT

1-2
112.0
842
8.7
0.154
5.00E-05
12
1.670

PUMPFIT3.XLS

total :
0.242

total :
0.307

Page 2
1
2
3
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

PROJECT :

PIPE FRICTION LOSS CALCULATION

Valves :

Valve 1

Kv
Visc.corr. fact.
Valve dP
Kv
Visc.corr. fact.
Valve dP
Kv
Visc.corr. fact.
Valve dP

Valve 2

Valve 3

Misc :

bar

Restriction orifice
(0<<0,8)
(20<Nre<109)

m,h,bar
c
bar
m,h,bar
c
bar
m,h,bar
c
bar

=
Tap.read dp
Perm.press loss

10-11
1.81

11-12
1.81

12-13
1.81

13-14
1.81

14-15
1.81

15-16
1.81

Date:
16-17
1.81

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1
0
0

1
0
0

1
0
0

1
0
0

1
0
0

1
0
0

1
0
0

1
0
0

1.807

1.807

1.807

1.807

1.807

1.807

1.807

1.807

total :
26.245

11
0
-7.951

12
0
-9.758

13
0
-11.564

14
10
-14.352

15
0
-15.178

16
0
-16.984

17
0
-18.791

18
0
-20.598

19
0
-20.598

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

1-2
0.054

2-3
0.90

3-4
1.81

4-5
1.81

5-6
1.81

6-7
1.81

7-8
1.81

8-9
1.81

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

1.0000
0.000

pump

bar
bar

Fixed dp

7/9/2015
17-18
1.81

bar

Total friction loss dP

bar
0
0
1

Inlet pressure Po bara :

1
0
1.000

0.054

0.898

1.807

1.807

1.807

1.807

1.807

1.807

2
0
0.946

3
0
0.048

4
0
-1.758

5
0
-3.565

6
0
-5.372

7
0
-7.178

8
0
-8.985

9
0
-10.792

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

NOTE !!!!

89 Outlet press. P19 bara :

Calculated pump dP:

Capacities based on water service :

m^3/h

95

Point A :

96

Point B :

97

Point C :

98

Point D :

99
100
101

Point E :

0
60
80
100
120

Best eff. point :

100

P bar

5.62
5.62
5.6
5.2
4.2
5.2

Eff.factor

0.2
0.5
0.67
0.745
0.68
0.745

10
-6.144

NOTE !! NOTE !!!!

4.6

bar (node 9-10)

At 112.0 m^3/h
Viscous capacity :
Q m^3/h
P bar

CHkor=

Eff.factor

(NPSH)av -10.99 bar

0.00

5.62

0.18

Shaft power

21.8

1.00

60.00

5.60

0.46

El.eff.fact.

0.9

0.99

80.00

5.57

0.61

El.power

24.2

0.99

100.00

5.16

0.68

0.99

120.00
CQ=

4.16
CH=

0.62
CE=

1.00

0.99

0.92

PUMPFIT3.XLS

kW
kW

NOTE !!!

Diff :

ISC a/s
0.55

23.598

Page 3
CONVERSIONS:
Insert :
FLOW
gallon/min
gallon/h
barrel/min
barrel/h
barrel/day
l/s
l/min
m3/min

1
1
1
1
1
1
1
1

To get :
0.2271
0.003785
9.5394
0.15899
0.0066246
3.6
0.06
60

COL.Z
FOR USE IN LINES 38-57 :
Full bore valves and fittings (FB) :
l/d
Ref. CRANE
Gate valve
FB
8
Globe valve
Globe valve
Globe valve
Globe valve

straight
"flow"
angle
angle

340
55
150
55

Check valve
Check valve
Check valve
Check valve
Stop check v.
Stop check v.
Stop check v.
Stop check v.
Stop check v.

swing
swing
lift
lift
globe t.
angle t.

100
50
600
55
400
200
300
350
55

Plug valve
Plug valve
Plug valve

1-way
3-way
3-way

18
30
90

Ball valve

FB

2"-8"
10"-14"
16"-24"

45
35
25

w.strainer
w.strainer

420
75

Mitre bend
Mitre bend
Mitre bend

15
20
90

4
4
60

Elbow 90 r/d
Elbow 90o r/d
Elbow 90o r/d

1
1.5
2

20
14
12

Return 180o
Elbow scrd.
Elbow scrd.

90
45

50
30
16

run
branch

20
60

Foot valve
Foot valve

Tee
Tee

flow
flow

lb / inch3
lb / foot3
lb/gallon
lb/barrel

Q , m3/h

ROW :

19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

DENSITY
To get :
1.00
27679.76 kg / m3
1.00
16.02 kg / m3
1.00
119.84 kg / m3
1.00
2.85 kg / m3
Kv

Insert :
Cv ,gal/min/psi
Kv ,l/s/bar

1 0.04166667 m3/h

m3/day

Butterfly v. ND
Butterfly v. ND
Butterfly v. ND

Insert :

m3/h
m3/h
m3/h
m3/h
m3/h
m3/h
m3/h
m3/h

p , bar

1.00
1.00

1.00

To get :

Insert :

m2/s
inch2/s
foot2/s

cP

0.86 Kv ,m/h/bar
0.28 Kv ,m/h/bar

Pa s
0.001

VISCOSITY To get :
0.0000087
8.7 cSt
1
645.16 cSt
1
92903 cSt
g/cm3

1
kg/m3
1000

1 cSt
1 cSt

1.00 Kv ,m/h/bar

COL. AE
FOR USE IN LINES 19-32 , ALL VALUES FOR LARGE (d2) DIAMETER FLOW CONDITION :
d1
Reduced bore valves and fittings (RB) :
K2 ()
Ref.CRANE.

formula :
mm

d2

l
mm
1
1
1
1
1
1

l/d (K1)

8
8
340
55
150
55

1
1
1
1
1
1

/2
rad
0
0
0
0
0
0

K2

Gate v. RB,=
Gate v. RB,=
Globe v. RB,=
Globe v. RB,=
Globe v. RB,=
Globe v. RB,=

1.00
1.00
1.00
1.00
1.00
1.00

0.22
0.22
9.18
1.49
4.05
1.49

formula5
formula6
formula7
formula7
formula7
formula7

1
1
1
1
1
1

mm
1
1
1
1
1
1

Check v. RB,=
Check v. RB,=
Check v. RB,=
Check v. RB,=
Check v. RB,=
Check v. RB,=
Check v. RB,=

1.00
1.00
1.00
1.00
1.00
1.00
1.00

16.20
1.49
10.80
5.40
8.10
9.45
1.49

formula7
formula7
formula7
formula7
formula7
formula7
formula7

1
1
1
1
1
1
1

1
1
1
1
1
1
1

1
1
1
1
1
1
1

600
55
400
200
300
350
55

1
1
1
1
1
1
1

0
0
0
0
0
0
0

16.2
1.485
10.8
5.4
8.1
9.45
1.485

Plug v. RB,=
Plug v. RB,=
Plug v. RB,=

1.00
1.00
1.00

0.49
0.81
2.43

formula6
formula6
formula6

1
1
1

1
1
1

1
1
1

18
30
90

1
1
1

0
0
0

0.486
0.81
2.43

< 45o :
45o < :

Ball v. RB,=
Ball v. RB,=

1.00
1.00

0.08
0.08

formula5
formula6

1
1

1
1

1
1

3
3

1
1

0
0

0.081
0.081

< 45o :
45o < :
< 45o :
45o < :

Reducer cont.=
Reducer cont.=
Reducer enl.=
Reducer enl.=

1.00
1.00
1.00
1.00

0.00
0.00
0.00
0.00

formula1
formula2
formula3
formula4

1
1
1
1

1
1
1
1

1
1
1
1

N/A
N/A
N/A
N/A

1
1
1
1

0
0
0
0

0
0
0
0

Pipe entrance r/d

0.00

0.50
1.00

< 45o :
45o < :

Notes:

d1=small diameter
d2=large diameter

l= length of conical section

K2= for large diameter flow , i.e. lines to be split at small end of reducers.

PUMPFIT3.XLS

0.216
0.216
9.18
1.485
4.05
1.485

Page 4
CONVERSIONS:
Insert :
FLOW
gallon/min

To get :
0.2271 m3/h

Insert :

lb / inch3

DENSITY
To get :
1.00
27679.76 kg / m3

PUMPFIT3.XLS

Insert :

m2/s

VISCOSITY To get :
0.0000087

8.7 cSt