A

1
2
3
4
5

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

Re-Checked by C.E.Smith 3-4-2002. Now acceptable.

H
Branch rev 3

This spreadsheet checks branch connections in accordance with clause 304.3 of the code.
Where the connection had pad reinforcement, the calculation includes the pad and pad to header weld areas, but only
the areas within the width of the reinforcement zone. The calculation assumes that the pad and all welds fall within the
height of the rein
Where no pad is used, the pad thickness, pad width, and pad to header weld should be input as 0.
Complete all yellow shaded areas of spreadsheet .
The original of this spreadsheet is write protected and may not be overwritten. Therefore the new calculation button must
be used to create a new calculation. A new filename must be entered at the prompt.

New Calculation

Print Calculation

Goto top left of Calc

26
27

JOB NO

CALC BY

28

JOB TITLE

CHECKED

29

CALC No

APPROVED
DATE

30

Click buttons using mouse against required Units as listed below:-

31
32

Stress Units

PSI

Pressure Units

PSI

Length Units

33

MPA

MPA

34

Kg/cm2

Kg/cm2

ins
mm

barg

35
36

Units used

37

HEADER

MPA

barg

mm
BRANCH

38
39

MATERIAL

1.25 Cr A691

MATERIAL

P11

40
41

ASME 31.3

ASME B31.3

42

NOMENCLATURE

NOMENCLATURE

43
44

Dh

OUTSIDE DIAMETER (mm)

45

T(bar)h

NOMINAL HEADER THICKNESS (mm)

46

1066.8 Db
38 T(bar)b
0.789

MILL TOLERANCE (%)

47

CORROSION ALLOWANCE (mm)

48

DESIGN PRESSURE (barg)

49

COEFFICIENT Y (Table 304.1.1)

50

BASIC ALLOWABLE STRESS (MPA)

51

LONGITUDINAL JOINT FACTOR

52

OUTSIDE DIAMETER (mm)

323.9
50

NOMINAL BRANCH THICKNESS (mm)

12.5

MILL TOLERANCE (%)

1 c

CORROSION ALLOWANCE (mm)

79.8
0.4
113 S
1 E
841

TEMPERATURE (Deg F)

BASIC ALLOWABLE STRESS (MPA)

100.6
1

LONGITUDINAL JOINT FACTOR

90

BRANCH ANGLE (Deg)

53
54

REINFORCEMENT AREAS

55

(Pad assumed to have same strength as Header)

56

Tr

57

PAD THICHNESS LESS UNDERTOL(mm)

EFFECTIVE PAD AND WELD DETAILS (CALC)

MINIMUM PAD WIDTH (mm)

EFFECTIVE PAD WIDTH (mm)

EFFECTIVE PAD HEIGHT(mm)

58
59

WELD LEG LENGTHS (mm)

60

HEADER OR PAD TO BRANCH

61

PAD TO HEADER

MINIMUM

ACTUAL EFFECTIVE PAD TO HEADER WELD AREA (mm^2)

0.3536
0

50 EFFECTIVE WELD TO BRANCH AREA (mm^2)

0
2500
2500

62
63
64

CALCULATIONS

65
66
67

th

HEADER PRESSURE DESIGN THICKNESS (mm)

36.6336064

68

tb

BRANCH PRESSURE DESIGN THICKNESS (mm)

12.451451

69

d1

EFFECTIVE LENGTH REMOVED FROM HEADER AT BRANCH (mm)

70

d2

HALF WIDTH OF REINFORCEMENT ZONE (mm)

71

L4

HEIGHT OF REINFORCEMENT ZONE OUTSIDE OF RUN PIPE (mm)

72

A1

REQUIRED AREA CORRECTED FOR ANGLE (mm^2)

8733.45178

73

A2

EXCESS AREA IN RUN PIPE (mm^2)

15.8711356

74

A3

EXCESS AREA IN BRANCH PIPE (mm^2)

5559.81101

75

A4

PAD AND WELD AREAS (mm^2)

76

A2+A3+A4

REINFORCEMENT AREAS (mm^2)

77

(A2+A3+A4)-A1 EXCESS REINFORCEMENT (mm^2)

238.4
238.4
91.75045

2500
8075.68215
-657.769627

78
79
80 File =\\vboxsrv\conversion_tmp\scratch_4\ 185860710.xls.ms_office.xls (Sheet1)
81 WARNING - BRANCH CONNECTION DOES NOT HAVE SUFFICIENT REINFORCEMENT
82 ALL REINFORCEMENT IS INSIDE WIDTH OF REINFORCEMENT ZONE
83 ALL REINFORCEMENT IS INSIDE HEIGHT OF REINFORCEMENT ZONE

HEADER TO PAD WELD IS ACCEPTABLE

84 HEADER THICKNESS IS ACCEPTABLE.

BRANCH ANGLE IS ACCEPTABLE.

BRANCH THICKNESS IS ACCEPTABLE.

85 HEADER GEOMETRY ACCEPTABLE FOR REQUIREMENTS OF B31.3 PARA. 304.3.1 b

HEADER OR PAD TO BRANCH WELD IS ACCEPTABLE.

86
87
88
89
90 =IF(2*N70<(O44/SIN(J52*PI()/180)+2*M57),N70-(O44/SIN(J52*PI()/180))/2,M57) EFFECTIVE PAD WIDTH (Ins)
91 =IF(L37>0,M56,M56+L37)

EFFECTIVE PAD HEIGHT(Ins)

92 =L29

EFFECTIVE PAD TO HEADER WELD AREA (In^2)

93 =L39

EFFECTIVE WELD TO BRANCH AREA (Ins^2)

94 =O59+O60

TOTAL EFFECTIVE WELD AREA (Ins^2)

95
96
97 =M48*M44/(2*(M50*F51+M48*F49))

th (ins)

98 =M48*O44/(2*(O50*J51+M48*F49))

tb (ins)

99 =(O44+2*(-O45+O47+(O45*J46/100)))/SIN(J52*PI()/180)

d1 (ins)

100 =IF(N69>(M45-M45*F46/100-M47)+(O45-O45*J46/100-O47)+N69/2,N69,(M45-M45*F46/100-M47)+(O45-O45*J46/100-O47)+N69/2)

d2 (ins)

101 =IF(2.5*(M45-M45*F46/100-M47)<2.5*(O45-O45*J46/100-O47)+M56,2.5*(M45-M45*F46/100-M47),2.5*(O45-O45*J46/100-O47)+M56)

L4 (ins)

102 =N67*N69*(2-SIN(J52*PI()/180))

A1 (ins^2)

103

=2*(M45-N67-M45*F46/100-M47)*(N70-N69/2)

A2 (ins^2)

104 =2*N71*(O45-O45*J46/100-O47-N68)/SIN(J52*PI()/180)

A3 (ins^2)

105 =2*M57*O58+O61

A4(ins^2)

106 =N73+N74+N75

A2+A3+A4 (ins^2)

107 =N76-N72
108

(A2+A3+A4)-A1 (ins^2)

109 =IF(2*N70>(O44/SIN(J52*PI()/180)+2*M57),N70-((O44/SIN(J52*PI()/180))/2+M57),0)

Calculates d2 beyond edge of pad (L27)

110 =IF(L27>M61,M61,L27)

check if J27> pad to header weld size (28)

111
112
113
114
115
116
117

=IF(L27>0,M61*M61-(M61-L28)*(M61-L28),0)

If J27>0, calculate weld area of pad to header (L29)

=N71-M56
=IF(L37>M60,M60,L37)
=IF(L37>0,M60^2-(M60-L38)^2,0)

Calculates L4 beyond pad height (L37)

1
2
3
4
5

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

barg
Mpa
Kg/cm2
PSI

Conversion to PSI
14.503776
145.03776
14.2238
1

26
27

3.00984252 Calculates d2 beyond edge of pad

28

0 check if J27> pad to header weld size

29

0 If J27>0, calculate weld area of pad to header

30
31
32
33
34
35
36
37

3.612222441 Calculates L4 beyond pad height

38

1.968503937 Checks if J31>pad or header to branch weld

39

Wall Units :

3.87500775 If J31>0, calculate weld area of pad or header to branch

40

code No

41
42

Stress convertion factor

43

Pressure convertion factor

Length convertion factor

44

Dh (ins)

42

Db (ins)

12.7519685

T(bar)h (ins) 1.496062992

T(bar)b (ins) 1.968503937

47

c (ins) 0.039370079

c (ins) 0.039370079

48

P (PSI) 1157.401325

45
46

Do not over type cells U42 to U44. These code numbers relate to the u

49
50

S (PSI) 16389.26688

S (PSI) 14590.79866

51
52
53
54
55
56
57

Tr (ins)
Min.Pad Width ins

0 EFFECTIVE PAD WIDTH (Ins)

0 EFFECTIVE PAD HEIGHT(Ins)

58

0 EFFECTIVE PAD TO HEADER WELD AREA (In^2)

59
60

Weld to Branch ins

1.968503937

61

Weld Pad/Head ins

3.8750078 EFFECTIVE WELD TO BRANCH AREA (Ins^2)

62
63
64
65

Available Reinforcement Areas for Header to Pad welds and Pad

66
67

1.44226797 th (ins)

68

0.490214605 tb (ins)

Effect. Pad Outside Radius. X (in)

69

9.385826772 d1 (ins)

Left Hand Pad to Header Weld Available Area (in 2)

70

9.385826772 d2 (ins)

Right Hand Pad to Header Weld Available Area (in 2)

71

3.612222441 L4 (ins)

Pad Available Area (in2)

72

13.53687733 A1 (ins^2)

Reinforcement Limit less

73

0.024600309 A2 (ins^2)

Effective Pad thickness. X1 (in)

74

8.617724307 A3 (ins^2)

Pad to Branch Weld Available Area (in2)

75

3.87500775 A4(ins^2)

(Based on conservative value of b =90o)

Reinforcement Limit less

9.3858268 =d2' (ins)

76

12.51733237 A2+A3+A4 (ins^2)

77

-1.01954496 (A2+A3+A4)-A1 (ins^2)

78
79
80
81
82
83
84
85

3.00984252

3.612222441

3.87500775

K
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117

1
2
3
4
5

6
7
8
9
10
11
12
13
14
15
Conversion to
16PSI
17
18
19
20
21
22
23
24
25

mm
in

Conversion To ins
0.039370079
1

AA

AB

AC

AD

AE

AF

AG

AA

AB

AC

26
27
28
29
30
31
32
33
34
35
36
37 mm

0.039370079 in

38
39
40 Factor

Conversion to PSI

Conversion To ins

41
42

145.03776

PSI

43

14.503776

Mpa

145.03776

44

0.039370079

Kg/cm2

45

14.2238

barg

14.503776

46

U42 to U44. These code

s for Header to Pad welds and65

Reference - Pad to Header Welds

67

Angle "b" in radians

68

(If b<>90)Tanb

69

Tp/2Tanb = in

70

(If b<>90),Tp/2-X.tanb = in

1.570796327
-1
0
-1

71
72
73
74
75
76
77
78
79
80
81
82
83
84
85

(Lw-Tp/2)/Tanb = in

in
mm

1
0.039370079

AD

AE

AF

AG

V
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117

AA

AB

AC

AD

AE

AF

AG

AH

AI

1
2
3
4
5

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25