Polyethylene Friction Loss Table: Gustavo Urbano

273238491.xls 06/11/2015

1 Metric Friction Chart

Friction Loss Characteristics

Polyethylene (PE) SDR-Pressure Rated Tube

(2306, 3206, 3306) SDR 7, 9, 11.5, 15 C=150
Sizes: 12.5mm to 75mm
Flow: 0.063 to 28.39 Liters per second
Size
13mm (1/2")
ID (cm)
1.326

19mm (3/4")
2.093

25mm (1")
2.664

32mm (1 1/4") 38mm (1 1/2")

3.505
4.089

50mm (2")
5.250

63mm (2 1/2")
6.271

75mm (3")
7.793

Flow

Flow

Velocity Head loss

Velocity Head loss

Velocity Head loss

Velocity Head loss Velocity Head loss Velocity Head loss Velocity Head loss Velocity Head loss

GPM

LPS

M/s

M/s

M/s

M/s

1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60

0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78

0.32
0.64
0.96
1.28
1.61
1.93
2.25
2.57
2.89
3.21
3.54
3.86
4.50
5.14
5.79

m/100m

1.05
3.77
7.99
13.61
20.57
28.85
38.38
49.14
61.23
74.30
88.64
104.15
138.55
177.42
220.67

m/100m

m/100m

0.18
0.26 0.11
0.09
0.37
0.96 0.23
0.30
0.55
2.04 0.34
0.62
0.73
3.47 0.45
1.07
0.92
5.23 0.56
1.63
1.10
7.35 0.68
2.27
1.28
9.77 0.79
3.02
1.47 12.52 0.90
3.86
1.65 15.56 1.01
4.80
1.83 18.90 1.13
5.85
2.02 22.57 1.24
6.96
2.20 26.51 1.35
8.19
2.56 35.27 1.58 10.89
2.93 45.15 1.81 13.95
3.30 56.17 2.03 17.36
3.66 68.28 2.26 21.09
4.03 81.46 2.49 25.16
4.40 95.69 2.72 29.55
4.76 101.77 2.94 34.29
5.13 127.32 3.17 39.32
5.50 144.66 3.40 44.68
3.95 59.45
4.52 76.14
5.08 94.70
5.64 115.10

0.06
0.13
0.20
0.26
0.32
0.39
0.46
0.52
0.59
0.65
0.72
0.78
0.91
1.04
1.17
1.30
1.43
1.57
1.70
1.83
1.96
2.28
2.61
2.94
3.26
3.59
3.92

m/100m

0.02
0.09
0.17
0.28
0.43
0.60
0.79
1.01
1.26
1.54
1.84
2.16
2.87
3.66
4.56
5.55
6.62
7.78
9.02
10.35
11.77
15.67
20.06
24.73
30.30
36.15
42.48

M/s

0.05
0.09
0.14
0.19
0.24
0.29
0.33
0.38
0.43
0.48
0.52
0.57
0.67
0.77
0.86
0.96
1.06
1.15
1.25
1.34
1.44
1.68
1.92
2.16
2.40
2.64
2.88

m/100m

0.00
0.04
0.09
0.13
0.19
0.28
0.39
0.47
0.60
0.73
0.86
1.03
1.35
1.74
2.16
2.61
3.13
3.69
4.26
4.89
5.55
7.39
9.47
11.79
14.32
17.08
20.06

M/s

0.03
0.06
0.09
0.12
0.14
0.17
0.20
0.23
0.26
0.29
0.32
0.35
0.41
0.46
0.52
0.58
0.64
0.70
0.76
0.81
0.87
1.02
1.16
1.31
1.45
1.60
1.74

m/100m

0.00
0.02
0.02
0.04
0.06
0.09
0.11
0.15
0.17
0.21
0.26
0.30
0.41
0.51
0.64
0.77
0.92
1.09
1.26
1.46
1.65
2.19
2.81
3.49
4.24
5.06
5.96

M/s

0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
0.22
0.24
0.28
0.33
0.37
0.41
0.45
0.48
0.53
0.57
0.61
0.71
0.81
0.92
1.02
1.12
1.24

m/100m

0.00
0.02
0.02
0.04
0.04
0.06
0.06
0.09
0.11
0.13
0.17
0.21
0.28
0.32
0.39
0.45
0.54
0.62
0.69
0.92
1.18
1.48
1.78
2.14
2.51

M/s

0.06
0.08
0.09
0.10
0.12
0.13
0.14
0.16
0.18
0.21
0.24
0.26
0.29
0.32
0.34
0.37
0.40
0.46
0.53
0.59
0.66
0.72
0.79

m/100m

0.00
0.02
0.02
0.02
0.02
0.02
0.04
0.04
0.06
0.09
0.09
0.11
0.13
0.15
0.19
0.21
0.24
0.32
0.41
0.51
0.62
0.75
0.88

273238491.xls 06/11/2015

65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300
325
350
375
400
425
450

Polyethylene Friction Loss Table: Gustavo Urbano

4.24
4.57
4.90
5.22
5.55
5.88

4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81
28.39

Using conversion factor psi to meters/100m=

2.1430 See below**

** 1. psi to feet x2.307 gives feet of head loss per 100ft

2. multiply product by .3048m/ft to get meters of head lost per 100 feet
3. multiply that product by 3.048 to convert loss/100ft to loss/100m

49.27
56.51
64.12
72.37
80.99
90.03

3.12
3.36
3.60
3.84
4.08
4.32
4.56
4.80
5.28
5.75

23.27
26.70
30.35
34.18
38.25
42.52
47.00
51.69
61.66
72.44

2 Metric Friction Chart

1.89
2.04
2.18
2.33
2.47
2.62
2.76
2.91
3.20
3.49
3.78
4.07
4.36
4.65
4.95
5.24
5.53
5.82

6.90
7.91
9.00
10.14
11.34
12.60
13.93
15.32
18.28
21.47
24.90
28.57
32.47
36.60
40.95
45.52
50.32
55.31

1.33
1.43
1.53
1.63
1.73
1.83
1.94
2.04
2.24
2.45
2.65
2.86
3.08
3.26
3.47
3.67
3.87
4.08
4.59
5.10
5.61

2.91
3.34
3.79
4.26
4.78
5.31
5.87
6.45
7.69
9.04
10.50
12.04
13.67
15.41
17.25
19.18
21.19
23.29
28.97
35.23
42.03

0.86
0.92
0.99
1.05
1.18
1.19
1.25
1.32
1.45
1.58
1.72
1.85
1.98
2.11
2.24
2.40
2.51
2.64
2.97
3.30
3.63
3.96
4.29
4.62
4.95
5.28
5.61
5.94

1.01
1.16
1.31
1.48
1.65
1.84
2.04
2.25
2.68
3.15
3.64
4.18
4.76
5.36
6.00
6.66
7.37
8.10
10.07
12.24
14.62
17.17
19.91
22.82
25.93
29.23
32.70
36.37

Imperial Friction chart

Standard Friction Loss Charactoristics

Flow
GPM
1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300

Size
IDia (C
Flow
LPS
0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92

Polyethylene (PE) SDR-Pressure Rated Tube

(2306, 3206, 3306) SDR 7, 9, 11.5, 15 C=150
13mm (1/2")
19mm (3/4")
25mm (1")
32mm (1 1/4") 38mm (1 1/2")
1.326
2.093
2.664
3.505
4.089
Velocity Head losVelocit Head losVelocit Head losVelocit Head losVelocit Head los
M/s
psi
M/s
psi
M/s
psi
FPS
psi
M/s
psi
0.32
0.49 0.18
0.12 0.11
0.04 0.21
0.01 0.15
0.00
0.64
1.76 0.37
0.45 0.23
0.14 0.42
0.04 0.31
0.02
0.96
3.73 0.55
0.95 0.34
0.29 0.64
0.08 0.47
0.04
1.28
6.35 0.73
1.62 0.45
0.50 0.85
0.13 0.62
0.06
1.61
9.60 0.92
2.44 0.56
0.76 1.07
0.20 0.78
0.09
1.93 13.46 1.10
3.43 0.68
1.06 1.28
0.28 0.94
0.13
2.25 17.91 1.28
4.56 0.79
1.41 1.49
0.37 1.09
0.18
2.57 22.93 1.47
5.84 0.90
1.80 1.71
0.47 1.25
0.22
2.89 28.57 1.65
7.26 1.01
2.24 1.92
0.59 1.41
0.28
3.21 34.67 1.83
8.82 1.13
2.73 2.14
0.72 1.57
0.34
3.54 41.36 2.02 10.53 1.24
3.25 2.35
0.86 1.72
0.40
3.86 48.60 2.20 12.37 1.35
3.82 2.56
1.01 1.88
0.48
4.50 64.65 2.56 16.46 1.58
5.08 2.99
1.34 2.20
0.63
5.14 82.79 2.93 21.07 1.81
6.51 3.42
1.71 2.51
0.81
5.79 102.97 3.30 26.21 2.03
8.10 3.85
2.13 2.83
1.01
3.66 31.86 2.26
9.84 4.28
2.59 3.15
1.22
4.03 38.01 2.49 11.74 4.71
3.09 3.46
1.46
4.40 44.65 2.72 13.79 5.14
3.63 3.78
1.72
4.76 47.49 2.94 16.00 5.57
4.21 4.09
1.99
5.13 59.41 3.17 18.35 5.99
4.83 4.41
2.28
5.50 67.50 3.40 20.85 6.42
5.49 4.73
2.59
3.95 27.74 7.49
7.31 5.50
3.45
4.52 35.53 8.56
9.36 6.29
4.42
5.08 44.19 9.64 11.54 7.08
5.50
5.64 53.71 10.71 14.14 7.87
6.68
11.78 16.87 8.65
7.97
12.85 19.82 9.44
9.36
13.92 22.99 10.23 10.86
15.00 26.37 11.01 12.46
16.07 29.92 11.80 14.16
17.14 33.77 12.59 15.95
18.21 37.79 13.37 17.85
19.28 42.01 14.16 19.84
14.95 21.93
15.74 24.12
17.31 28.77
18.88 33.80

Page 3

Imperial Friction chart

325
350
375
400
425
450
475
500
525
550
575
600

20.50
22.08
23.66
25.23
26.81
28.39
29.96
31.54
33.12
34.69
36.27
37.85

conversion factor psi to meters/100

2.3061

Page 4

Imperial Friction chart

50mm (2")
63mm (2 1/2")
75mm (3")
100mm (4")
150mm (6")
5.250
6.271
7.793
10.226
15.405
Velocit Head losVelocit Head losVelocit Head losVelocit Head losVelocit Head loss
M/s
m/100m M/s
m/100m M/s
m/100m M/s
m/100m M/s
m/100m
0.09
0.00
0.19
0.01
0.28
0.01 0.20
0.00
0.38
0.02 0.26
0.01
0.47
0.03 0.33
0.01 0.21
0.00
0.57
0.04 0.40
0.02 0.26
0.01
0.66
0.05 0.46
0.02 0.30
0.01
0.76
0.07 0.53
0.03 0.34
0.01
0.85
0.08 0.60
0.03 0.39
0.01
0.95
0.10 0.66
0.04 0.43
0.01
1.05
0.12 0.73
0.05 0.47
0.02
1.14
0.14 0.80
0.06 0.52
0.02
1.33
0.19 0.93
0.08 0.60
0.03
1.52
0.24 1.07
0.10 0.69
0.04
1.71
0.30 1.20
0.13 0.78
0.04
1.90
0.36 1.33
0.15 0.86
0.05
2.10
0.43 1.47
0.18 0.95
0.06
2.29
0.51 1.59
0.21 1.04
0.07
2.48
0.59 1.74
0.25 1.12
0.09
2.67
0.68 1.87
0.29 1.21
0.10
2.86
0.77 2.00
0.32 1.30
0.11
3.34
1.02 2.34
0.43 1.51
0.15
3.82
1.31 2.67
0.55 1.73
0.19
4.29
1.63 3.01
0.69 1.95
0.24
4.77
1.98 3.34
0.83 2.16
0.29
5.25
2.36 3.68
1.00 2.36
0.35
5.72
2.78 4.07
1.17 2.60
0.41
6.20
3.22 4.35
1.36 2.81
0.47
6.68
3.69 4.68
1.56 3.03
0.54
7.16
4.20 5.01
1.77 3.25
0.61
7.63
4.73 5.35
1.99 3.46
0.69
8.11
5.29 5.68
2.23 3.86
0.77
8.59
5.88 6.02
2.48 3.90
0.86
9.07
6.50 6.35
2.74 4.11
0.95
9.54
7.15 6.68
3.01 4.33
1.05
10.50
8.53 7.35
3.59 4.76
1.25
11.45 10.02 8.03
4.22 5.20
1.47
12.41 11.62 8.70
4.90 5.63
1.70
13.36 13.33 9.37
5.62 6.06
1.95
14.32 15.15 10.09
6.38 6.50
2.22
15.27 17.08 10.70
7.19 6.93
2.50
16.23 19.11 11.37
8.05 7.36
2.80
17.18 21.24 12.04
8.95 7.88
3.11
18.14 23.48 12.71
9.89 8.23
3.44
19.09 25.81 13.38 10.87 8.66
3.78
15.05 13.52 9.75
4.70
16.73 16.44 10.83
5.71
18.40 19.61 11.92
6.82
13.00
8.01

Page 5

Imperial Friction chart

14.08
15.17
16.25
17.33
18.42
19.50

9.29
10.65
12.10
13.64
15.26
16.97

Page 6

Head Loss Calculator

Automatic Head Loss Calculator (Issue 1 20-02-03)

This spreadsheet allows the user to calculate accurately the velocity (m/s) and total frictional headloss (m) for pipes
of varying diameter, for a given flow rate (Lps) and pipe length.
Input data is marked in red
Pipe Length (m) =

700

Pipe Size
Pipe/Fitting Cost/100m

Flow

Flow

13mm (1/2")
100.0 $ (Pesos)

19mm (3/4")
146.0 $ (Pesos)

25mm (1")
192.0 $ (Pesos)

32mm (1 1/4")
246.0 $ (Pesos)

38mm (1 1/2")
292.0 $ (Pesos)

50mm (2")
384.0 $ (Pesos)

63mm (2 1/2")
484.0 $ (Pesos)

75mm (3")
576.0 $ (Pesos)

Velocity

Velocity

Velocity

Velocity

Velocity

Velocity

Velocity

Velocity

Head loss

Head loss

Head loss

Head loss

Head loss

Head loss

Head loss

Head loss

GPM

LPS

m/s

m/s

m/s

m/s

m/s

m/s

m/s

m/s

4.29

0.27

1.37

108.92

0.78

27.75

0.48

8.59

0.28

2.24

0.20

1.03

0.12

0.34

0.09

0.15

Range

Range

Total Cost =

700.0

Total Cost =

1022.0

Total Cost =

1344.0

Total Cost =

1722.0

Total Cost =

2044.0

Total Cost =

2688.0

Total Cost =

3388.0

Total Cost =

Range

The presence of the "Range" term in a cell signifies that the input data is outside the parameters of the friction chart.
Note : the following friction tables are for spreadsheet calculation only
Size
ID (cm)

13mm (1/2")
1.326

19mm (3/4")
2.093

25mm (1")
2.664

32mm (1 1/4")
3.505

38mm (1 1/2")
4.089

50mm (2")
5.250

63mm (2 1/2")
6.271

75mm (3")
7.793

Flow

Flow

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

GPM

LPS

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300
325
350
375
400
425
450

0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81
28.39

0.32
1.05
0.64
3.77
0.96
7.99
1.28 13.61
1.61 20.57
1.93 28.85
2.25 38.38
2.57 49.14
2.89 61.23
3.21 74.30
3.54 88.64
3.86 104.15
4.50 138.55
5.14 177.42
5.79 220.67

0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81
28.39

Size
ID (cm)

0.18
0.26
0.37
0.96
0.55
2.04
0.73
3.47
0.92
5.23
1.10
7.35
1.28
9.77
1.47 12.52
1.65 15.56
1.83 18.90
2.02 22.57
2.20 26.51
2.56 35.27
2.93 45.15
3.30 56.17
3.66 68.28
4.03 81.46
4.40 95.69
4.76 101.77
5.13 127.32
5.50 144.66

13mm (1/2")
1.326

0.11
0.09
0.23
0.30
0.34
0.62
0.45
1.07
0.56
1.63
0.68
2.27
0.79
3.02
0.90
3.86
1.01
4.80
1.13
5.85
1.24
6.96
1.35
8.19
1.58 10.89
1.81 13.95
2.03 17.36
2.26 21.09
2.49 25.16
2.72 29.55
2.94 34.29
3.17 39.32
3.40 44.68
3.95 59.45
4.52 76.14
5.08 94.70
5.64 115.10

19mm (3/4")
2.093

25mm (1")
2.664

0.06
0.13
0.20
0.26
0.32
0.39
0.46
0.52
0.59
0.65
0.72
0.78
0.91
1.04
1.17
1.30
1.43
1.57
1.70
1.83
1.96
2.28
2.61
2.94
3.26
3.59
3.92
4.24
4.57
4.90
5.22
5.55
5.88

0.02
0.09
0.17
0.28
0.43
0.60
0.79
1.01
1.26
1.54
1.84
2.16
2.87
3.66
4.56
5.55
6.62
7.78
9.02
10.35
11.77
15.67
20.06
24.73
30.30
36.15
42.48
49.27
56.51
64.12
72.37
80.99
90.03

32mm (1 1/4")
3.505

0.05
0.09
0.14
0.19
0.24
0.29
0.33
0.38
0.43
0.48
0.52
0.57
0.67
0.77
0.86
0.96
1.06
1.15
1.25
1.34
1.44
1.68
1.92
2.16
2.40
2.64
2.88
3.12
3.36
3.60
3.84
4.08
4.32
4.56
4.80
5.28
5.75

0.00
0.04
0.09
0.13
0.19
0.28
0.39
0.47
0.60
0.73
0.86
1.03
1.35
1.74
2.16
2.61
3.13
3.69
4.26
4.89
5.55
7.39
9.47
11.79
14.32
17.08
20.06
23.27
26.70
30.35
34.18
38.25
42.52
47.00
51.69
61.66
72.44

0.03
0.06
0.09
0.12
0.14
0.17
0.20
0.23
0.26
0.29
0.32
0.35
0.41
0.46
0.52
0.58
0.64
0.70
0.76
0.81
0.87
1.02
1.16
1.31
1.45
1.60
1.74
1.89
2.04
2.18
2.33
2.47
2.62
2.76
2.91
3.20
3.49
3.78
4.07
4.36
4.65
4.95
5.24
5.53
5.82

38mm (1 1/2")
4.089

0.00
0.02
0.02
0.04
0.06
0.09
0.11
0.15
0.17
0.21
0.26
0.30
0.41
0.51
0.64
0.77
0.92
1.09
1.26
1.46
1.65
2.19
2.81
3.49
4.24
5.06
5.96
6.90
7.91
9.00
10.14
11.34
12.60
13.93
15.32
18.28
21.47
24.90
28.57
32.47
36.60
40.95
45.52
50.32
55.31

50mm (2")
5.250

0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
0.22
0.24
0.28
0.33
0.37
0.41
0.45
0.48
0.53
0.57
0.61
0.71
0.81
0.92
1.02
1.12
1.24
1.33
1.43
1.53
1.63
1.73
1.83
1.94
2.04
2.24
2.45
2.65
2.86
3.08
3.26
3.47
3.67
3.87
4.08
4.59
5.10
5.61

0.00
0.02
0.02
0.04
0.04
0.06
0.06
0.09
0.11
0.13
0.17
0.21
0.28
0.32
0.39
0.45
0.54
0.62
0.69
0.92
1.18
1.48
1.78
2.14
2.51
2.91
3.34
3.79
4.26
4.78
5.31
5.87
6.45
7.69
9.04
10.50
12.04
13.67
15.41
17.25
19.18
21.19
23.29
28.97
35.23
42.03

0.06
0.08
0.09
0.10
0.12
0.13
0.14
0.16
0.18
0.21
0.24
0.26
0.29
0.32
0.34
0.37
0.40
0.46
0.53
0.59
0.66
0.72
0.79
0.86
0.92
0.99
1.05
1.18
1.19
1.25
1.32
1.45
1.58
1.72
1.85
1.98
2.11
2.24
2.40
2.51
2.64
2.97
3.30
3.63
3.96
4.29
4.62
4.95
5.28
5.61
5.94

63mm (2 1/2")
6.271

0.00
0.02
0.02
0.02
0.02
0.02
0.04
0.04
0.06
0.09
0.09
0.11
0.13
0.15
0.19
0.21
0.24
0.32
0.41
0.51
0.62
0.75
0.88
1.01
1.16
1.31
1.48
1.65
1.84
2.04
2.25
2.68
3.15
3.64
4.18
4.76
5.36
6.00
6.66
7.37
8.10
10.07
12.24
14.62
17.17
19.91
22.82
25.93
29.23
32.70
36.37

75mm (3")
7.793

Flow

Flow

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

GPM

LPS

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300
325
350
375
400
425

0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81

0.32
0.64
0.96
1.28
1.61
1.93
2.25
2.57
2.89
3.21
3.54
3.86
4.50
5.14
5.79

1.05
3.77
7.99
13.61
20.57
28.85
38.38
49.14
61.23
74.30
88.64
104.15
138.55
177.42
220.67

0.18
0.26
0.37
0.96
0.55
2.04
0.73
3.47
0.92
5.23
1.10
7.35
1.28
9.77
1.47 12.52
1.65 15.56
1.83 18.90
2.02 22.57
2.20 26.51
2.56 35.27
2.93 45.15
3.30 56.17
3.66 68.28
4.03 81.46
4.40 95.69
4.76 101.77
5.13 127.32
5.50 144.66

0.11
0.09
0.23
0.30
0.34
0.62
0.45
1.07
0.56
1.63
0.68
2.27
0.79
3.02
0.90
3.86
1.01
4.80
1.13
5.85
1.24
6.96
1.35
8.19
1.58 10.89
1.81 13.95
2.03 17.36
2.26 21.09
2.49 25.16
2.72 29.55
2.94 34.29
3.17 39.32
3.40 44.68
3.95 59.45
4.52 76.14
5.08 94.70
5.64 115.10

0.06
0.13
0.20
0.26
0.32
0.39
0.46
0.52
0.59
0.65
0.72
0.78
0.91
1.04
1.17
1.30
1.43
1.57
1.70
1.83
1.96
2.28
2.61
2.94
3.26
3.59
3.92
4.24
4.57
4.90
5.22
5.55
5.88

0.02
0.09
0.17
0.28
0.43
0.60
0.79
1.01
1.26
1.54
1.84
2.16
2.87
3.66
4.56
5.55
6.62
7.78
9.02
10.35
11.77
15.67
20.06
24.73
30.30
36.15
42.48
49.27
56.51
64.12
72.37
80.99
90.03

0.05
0.09
0.14
0.19
0.24
0.29
0.33
0.38
0.43
0.48
0.52
0.57
0.67
0.77
0.86
0.96
1.06
1.15
1.25
1.34
1.44
1.68
1.92
2.16
2.40
2.64
2.88
3.12
3.36
3.60
3.84
4.08
4.32
4.56
4.80
5.28
5.75

0.00
0.04
0.09
0.13
0.19
0.28
0.39
0.47
0.60
0.73
0.86
1.03
1.35
1.74
2.16
2.61
3.13
3.69
4.26
4.89
5.55
7.39
9.47
11.79
14.32
17.08
20.06
23.27
26.70
30.35
34.18
38.25
42.52
47.00
51.69
61.66
72.44

0.03
0.06
0.09
0.12
0.14
0.17
0.20
0.23
0.26
0.29
0.32
0.35
0.41
0.46
0.52
0.58
0.64
0.70
0.76
0.81
0.87
1.02
1.16
1.31
1.45
1.60
1.74
1.89
2.04
2.18
2.33
2.47
2.62
2.76
2.91
3.20
3.49
3.78
4.07
4.36
4.65
4.95
5.24
5.53
5.82

0.00
0.02
0.02
0.04
0.06
0.09
0.11
0.15
0.17
0.21
0.26
0.30
0.41
0.51
0.64
0.77
0.92
1.09
1.26
1.46
1.65
2.19
2.81
3.49
4.24
5.06
5.96
6.90
7.91
9.00
10.14
11.34
12.60
13.93
15.32
18.28
21.47
24.90
28.57
32.47
36.60
40.95
45.52
50.32
55.31

0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
0.22
0.24
0.28
0.33
0.37
0.41
0.45
0.48
0.53
0.57
0.61
0.71
0.81
0.92
1.02
1.12
1.24
1.33
1.43
1.53
1.63
1.73
1.83
1.94
2.04
2.24
2.45
2.65
2.86
3.08
3.26
3.47
3.67
3.87
4.08
4.59
5.10
5.61

0.00
0.02
0.02
0.04
0.04
0.06
0.06
0.09
0.11
0.13
0.17
0.21
0.28
0.32
0.39
0.45
0.54
0.62
0.69
0.92
1.18
1.48
1.78
2.14
2.51
2.91
3.34
3.79
4.26
4.78
5.31
5.87
6.45
7.69
9.04
10.50
12.04
13.67
15.41
17.25
19.18
21.19
23.29
28.97
35.23
42.03

0.06
0.08
0.09
0.10
0.12
0.13
0.14
0.16
0.18
0.21
0.24
0.26
0.29
0.32
0.34
0.37
0.40
0.46
0.53
0.59
0.66
0.72
0.79
0.86
0.92
0.99
1.05
1.18
1.19
1.25
1.32
1.45
1.58
1.72
1.85
1.98
2.11
2.24
2.40
2.51
2.64
2.97
3.30
3.63
3.96
4.29
4.62
4.95
5.28
5.61
5.94

0.00
0.02
0.02
0.02
0.02
0.02
0.04
0.04
0.06
0.09
0.09
0.11
0.13
0.15
0.19
0.21
0.24
0.32
0.41
0.51
0.62
0.75
0.88
1.01
1.16
1.31
1.48
1.65
1.84
2.04
2.25
2.68
3.15
3.64
4.18
4.76
5.36
6.00
6.66
7.37
8.10
10.07
12.24
14.62
17.17
19.91
22.82
25.93
29.23
32.70
36.37

Page 7

Combination Pipes Equation : Automatic Calculator (Issue 1 21-02-03)

This spreadsheet allows the user to determine the best combination of pipes of different diameters (in) in order to
burn off a stated frictional headloss (m), given the chosen pipe diameter (in), a total pipe length (m) and a flow rate
(Lps). Pipe and fitting costs can also be included to allow calculation of the best combination.
Typically the previous Head Loss Calculator Spreadsheet would be used to determine the minimum pipe diameter
which "burns off" a frictional headloss which is just above the required value. This diameter should be input into
this spreadsheet as the "Chosen Pipe Diameter" below. After input of the other variables this spreadsheet will give
the rounded 100m lengths of Mangera of the combination that is closest to the required frictional headloss. It quotes
both the cost of the combination (pesos) and the actual frictional headloss (m) of the combination. The value quoted
in blue is the exact length of the chosen diameter pipe that would give the correct frictional burn off in combination
with that particular diameter of pipe.
Input data is marked in red.
Total Pipe Length (m) =
Required Head Loss (m) =
Chosen Pipe Diameter (in) =
Chosen Pipe Head Loss (m/100m) =
Chosen Pipe Cost (Pesos/100m) =

Other Pipe Size

Pipe/Fitting Cost/100m

Flow

Flow

GPM

LPS

4.29

0.27

700
40
0.5
15.56
100.00
13mm (1/2")
100.0 $ (Pesos)

19mm (3/4")
146.0 $ (Pesos)

25mm (1")
192.0 $ (Pesos)

32mm (1 1/4")
246.0 $ (Pesos)

38mm (1 1/2")
292.0 $ (Pesos)

50mm (2")
384.0 $ (Pesos)

63mm (2 1/2")
484.0 $ (Pesos)

75mm (3")
576.0 $ (Pesos)

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

m/s

m/100m

m/s

m/100m

m/s

m/100m

m/s

m/100m

m/s

m/100m

m/s

m/100m

m/s

m/100m

1.37

15.56

0.78

3.96

0.48

1.23

0.28

0.32

0.20

0.15

0.12

0.05

0.09

0.02

m/s

Range

Head loss
m/100m

Range

Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia. Chosen Dia.
Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Pipe Length

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?

Pipe Length

Dia.

No

105.64

100

219.12

200

247.74

200

252.85

200

255.67

200

256.45

200

Error

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Actual Head

This Dia.

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Burned Off

Pipe Length

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?

Use ?
No

N/A

No

39.35

600

37.26

500

32.72

500

31.85

500

31.37

500

31.23

500

N/A

No

Total Cost =

N/A

Total Cost =

876.0

Total Cost =

960.0

Total Cost =

1230.0

Total Cost =

1460.0

Total Cost =

1920.0

Total Cost =

2420.0

Total Cost =

N/A

The presence of the "Dia." term in a cell signifies that the chosen input data is the same as this diameter of pipe.
The presence of the "Error" term in a cell signifies that the resulting pipe length is less than zero or greater than the overall pipe length.
The presence of the "Range" term in a cell signifies that the input data is outside the parameters of the friction chart.
The presence of the "N/A" term in a cell signifies that this data is not applicable.
Note : the following friction tables are for spreadsheet calculation only
Size
ID (cm)
Flow

13mm (1/2")
1.326
Flow

GPM

LPS

1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300
325
350
375
400
425
450

0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81
28.39

GPM

1
2
3
4
5
6
7
8
9
10
11
12
14
16
18
20
22
24
26
28
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
110
120
130
140
150
160
170
180
190
200
225
250
275
300
325
350
375
400
425

25mm (1")
2.664

32mm (1 1/4")
3.505

38mm (1 1/2")
4.089

50mm (2")
5.250

63mm (2 1/2")
6.271

75mm (3")
7.793

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

0.32
1.05
0.64
3.77
0.96
7.99
1.28 13.61
1.61 20.57
1.93 28.85
2.25 38.38
2.57 49.14
2.89 61.23
3.21 74.30
3.54 88.64
3.86 104.15
4.50 138.55
5.14 177.42
5.79 220.67

Size
ID (cm)
Flow

19mm (3/4")
2.093

Velocity

0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81
28.39

0.18
0.26
0.37
0.96
0.55
2.04
0.73
3.47
0.92
5.23
1.10
7.35
1.28
9.77
1.47 12.52
1.65 15.56
1.83 18.90
2.02 22.57
2.20 26.51
2.56 35.27
2.93 45.15
3.30 56.17
3.66 68.28
4.03 81.46
4.40 95.69
4.76 101.77
5.13 127.32
5.50 144.66

13mm (1/2")
1.326

0.11
0.09
0.23
0.30
0.34
0.62
0.45
1.07
0.56
1.63
0.68
2.27
0.79
3.02
0.90
3.86
1.01
4.80
1.13
5.85
1.24
6.96
1.35
8.19
1.58 10.89
1.81 13.95
2.03 17.36
2.26 21.09
2.49 25.16
2.72 29.55
2.94 34.29
3.17 39.32
3.40 44.68
3.95 59.45
4.52 76.14
5.08 94.70
5.64 115.10

19mm (3/4")
2.093

25mm (1")
2.664

0.06
0.13
0.20
0.26
0.32
0.39
0.46
0.52
0.59
0.65
0.72
0.78
0.91
1.04
1.17
1.30
1.43
1.57
1.70
1.83
1.96
2.28
2.61
2.94
3.26
3.59
3.92
4.24
4.57
4.90
5.22
5.55
5.88

0.02
0.09
0.17
0.28
0.43
0.60
0.79
1.01
1.26
1.54
1.84
2.16
2.87
3.66
4.56
5.55
6.62
7.78
9.02
10.35
11.77
15.67
20.06
24.73
30.30
36.15
42.48
49.27
56.51
64.12
72.37
80.99
90.03

32mm (1 1/4")
3.505

0.05
0.09
0.14
0.19
0.24
0.29
0.33
0.38
0.43
0.48
0.52
0.57
0.67
0.77
0.86
0.96
1.06
1.15
1.25
1.34
1.44
1.68
1.92
2.16
2.40
2.64
2.88
3.12
3.36
3.60
3.84
4.08
4.32
4.56
4.80
5.28
5.75

0.00
0.04
0.09
0.13
0.19
0.28
0.39
0.47
0.60
0.73
0.86
1.03
1.35
1.74
2.16
2.61
3.13
3.69
4.26
4.89
5.55
7.39
9.47
11.79
14.32
17.08
20.06
23.27
26.70
30.35
34.18
38.25
42.52
47.00
51.69
61.66
72.44

0.03
0.06
0.09
0.12
0.14
0.17
0.20
0.23
0.26
0.29
0.32
0.35
0.41
0.46
0.52
0.58
0.64
0.70
0.76
0.81
0.87
1.02
1.16
1.31
1.45
1.60
1.74
1.89
2.04
2.18
2.33
2.47
2.62
2.76
2.91
3.20
3.49
3.78
4.07
4.36
4.65
4.95
5.24
5.53
5.82

38mm (1 1/2")
4.089

0.00
0.02
0.02
0.04
0.06
0.09
0.11
0.15
0.17
0.21
0.26
0.30
0.41
0.51
0.64
0.77
0.92
1.09
1.26
1.46
1.65
2.19
2.81
3.49
4.24
5.06
5.96
6.90
7.91
9.00
10.14
11.34
12.60
13.93
15.32
18.28
21.47
24.90
28.57
32.47
36.60
40.95
45.52
50.32
55.31

50mm (2")
5.250

0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
0.22
0.24
0.28
0.33
0.37
0.41
0.45
0.48
0.53
0.57
0.61
0.71
0.81
0.92
1.02
1.12
1.24
1.33
1.43
1.53
1.63
1.73
1.83
1.94
2.04
2.24
2.45
2.65
2.86
3.08
3.26
3.47
3.67
3.87
4.08
4.59
5.10
5.61

0.00
0.02
0.02
0.04
0.04
0.06
0.06
0.09
0.11
0.13
0.17
0.21
0.28
0.32
0.39
0.45
0.54
0.62
0.69
0.92
1.18
1.48
1.78
2.14
2.51
2.91
3.34
3.79
4.26
4.78
5.31
5.87
6.45
7.69
9.04
10.50
12.04
13.67
15.41
17.25
19.18
21.19
23.29
28.97
35.23
42.03

0.06
0.08
0.09
0.10
0.12
0.13
0.14
0.16
0.18
0.21
0.24
0.26
0.29
0.32
0.34
0.37
0.40
0.46
0.53
0.59
0.66
0.72
0.79
0.86
0.92
0.99
1.05
1.18
1.19
1.25
1.32
1.45
1.58
1.72
1.85
1.98
2.11
2.24
2.40
2.51
2.64
2.97
3.30
3.63
3.96
4.29
4.62
4.95
5.28
5.61
5.94

63mm (2 1/2")
6.271

0.00
0.02
0.02
0.02
0.02
0.02
0.04
0.04
0.06
0.09
0.09
0.11
0.13
0.15
0.19
0.21
0.24
0.32
0.41
0.51
0.62
0.75
0.88
1.01
1.16
1.31
1.48
1.65
1.84
2.04
2.25
2.68
3.15
3.64
4.18
4.76
5.36
6.00
6.66
7.37
8.10
10.07
12.24
14.62
17.17
19.91
22.82
25.93
29.23
32.70
36.37

75mm (3")
7.793

Flow

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

Velocity

Head loss

LPS

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

M/s

m/100m

0.06
0.13
0.19
0.25
0.32
0.38
0.44
0.50
0.57
0.63
0.69
0.76
0.88
1.01
1.14
1.26
1.39
1.51
1.64
1.77
1.89
2.21
2.52
2.84
3.15
3.47
3.78
4.10
4.42
4.73
5.05
5.36
5.68
5.99
6.31
6.94
7.57
8.20
8.83
9.46
10.09
10.72
11.35
11.99
12.62
14.19
15.77
17.35
18.92
20.50
22.08
23.66
25.23
26.81

0.32
1.05
0.64
3.77
0.96
7.99
1.28 13.61
1.61 20.57
1.93 28.85
2.25 38.38
2.57 49.14
2.89 61.23
3.21 74.30
3.54 88.64
3.86 104.15
4.50 138.55
5.14 177.42
5.79 220.67

0.18
0.26
0.37
0.96
0.55
2.04
0.73
3.47
0.92
5.23
1.10
7.35
1.28
9.77
1.47 12.52
1.65 15.56
1.83 18.90
2.02 22.57
2.20 26.51
2.56 35.27
2.93 45.15
3.30 56.17
3.66 68.28
4.03 81.46
4.40 95.69
4.76 101.77
5.13 127.32
5.50 144.66

0.11
0.09
0.23
0.30
0.34
0.62
0.45
1.07
0.56
1.63
0.68
2.27
0.79
3.02
0.90
3.86
1.01
4.80
1.13
5.85
1.24
6.96
1.35
8.19
1.58 10.89
1.81 13.95
2.03 17.36
2.26 21.09
2.49 25.16
2.72 29.55
2.94 34.29
3.17 39.32
3.40 44.68
3.95 59.45
4.52 76.14
5.08 94.70
5.64 115.10

0.06
0.13
0.20
0.26
0.32
0.39
0.46
0.52
0.59
0.65
0.72
0.78
0.91
1.04
1.17
1.30
1.43
1.57
1.70
1.83
1.96
2.28
2.61
2.94
3.26
3.59
3.92
4.24
4.57
4.90
5.22
5.55
5.88

0.02
0.09
0.17
0.28
0.43
0.60
0.79
1.01
1.26
1.54
1.84
2.16
2.87
3.66
4.56
5.55
6.62
7.78
9.02
10.35
11.77
15.67
20.06
24.73
30.30
36.15
42.48
49.27
56.51
64.12
72.37
80.99
90.03

0.05
0.09
0.14
0.19
0.24
0.29
0.33
0.38
0.43
0.48
0.52
0.57
0.67
0.77
0.86
0.96
1.06
1.15
1.25
1.34
1.44
1.68
1.92
2.16
2.40
2.64
2.88
3.12
3.36
3.60
3.84
4.08
4.32
4.56
4.80
5.28
5.75

0.00
0.04
0.09
0.13
0.19
0.28
0.39
0.47
0.60
0.73
0.86
1.03
1.35
1.74
2.16
2.61
3.13
3.69
4.26
4.89
5.55
7.39
9.47
11.79
14.32
17.08
20.06
23.27
26.70
30.35
34.18
38.25
42.52
47.00
51.69
61.66
72.44

0.03
0.06
0.09
0.12
0.14
0.17
0.20
0.23
0.26
0.29
0.32
0.35
0.41
0.46
0.52
0.58
0.64
0.70
0.76
0.81
0.87
1.02
1.16
1.31
1.45
1.60
1.74
1.89
2.04
2.18
2.33
2.47
2.62
2.76
2.91
3.20
3.49
3.78
4.07
4.36
4.65
4.95
5.24
5.53
5.82

0.00
0.02
0.02
0.04
0.06
0.09
0.11
0.15
0.17
0.21
0.26
0.30
0.41
0.51
0.64
0.77
0.92
1.09
1.26
1.46
1.65
2.19
2.81
3.49
4.24
5.06
5.96
6.90
7.91
9.00
10.14
11.34
12.60
13.93
15.32
18.28
21.47
24.90
28.57
32.47
36.60
40.95
45.52
50.32
55.31

0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
0.22
0.24
0.28
0.33
0.37
0.41
0.45
0.48
0.53
0.57
0.61
0.71
0.81
0.92
1.02
1.12
1.24
1.33
1.43
1.53
1.63
1.73
1.83
1.94
2.04
2.24
2.45
2.65
2.86
3.08
3.26
3.47
3.67
3.87
4.08
4.59
5.10
5.61

0.00
0.02
0.02
0.04
0.04
0.06
0.06
0.09
0.11
0.13
0.17
0.21
0.28
0.32
0.39
0.45
0.54
0.62
0.69
0.92
1.18
1.48
1.78
2.14
2.51
2.91
3.34
3.79
4.26
4.78
5.31
5.87
6.45
7.69
9.04
10.50
12.04
13.67
15.41
17.25
19.18
21.19
23.29
28.97
35.23
42.03

0.06
0.08
0.09
0.10
0.12
0.13
0.14
0.16
0.18
0.21
0.24
0.26
0.29
0.32
0.34
0.37
0.40
0.46
0.53
0.59
0.66
0.72
0.79
0.86
0.92
0.99
1.05
1.18
1.19
1.25
1.32
1.45
1.58
1.72
1.85
1.98
2.11
2.24
2.40
2.51
2.64
2.97
3.30
3.63
3.96
4.29
4.62
4.95
5.28
5.61
5.94

0.00
0.02
0.02
0.02
0.02
0.02
0.04
0.04
0.06
0.09
0.09
0.11
0.13
0.15
0.19
0.21
0.24
0.32
0.41
0.51
0.62
0.75
0.88
1.01
1.16
1.31
1.48
1.65
1.84
2.04
2.25
2.68
3.15
3.64
4.18
4.76
5.36
6.00
6.66
7.37
8.10
10.07
12.24
14.62
17.17
19.91
22.82
25.93
29.23
32.70
36.37