Branch Connections
Method for Determining if a Direct Branch Connection Will Meet a Design Condition Without Reinforcement
                          And if it Does Not, the Extent of Reinforcement Needed
             Instructions:
             (1) Enter the required branch angle in cell B26. Set cell J25 to zero.
             (2) Enter the pipe data in cells A33 to H33. For welded pipe, if the weld seam of the main is not cut use S without the E factor. See typical materials list bel
             (3) If the design pressure is higher than the joint pressure, JP, pressure, reinforcement is required.
             (4) To calculate reinforcement area enter the pipe data on line 45 with the required design pressure under P.
             (5) The required sq in of reinforcement will be under A4. Enter this value or whatever area you will use in cell J25.
             (6) The value for JP line 33 will then show your new maximum pressure and the area check.
                                                                       Typical Material Allowable Stresses:
                                                                       A106B,A53B Smls           S=                 15000 psi
     JP = Allowable joint pressure based on ASME B31.9 - 2005          A53B,ERW                 SE=                 12800
          2ShSb(dbTh+Tb^2(5+sin a))                                       Same, Seam Uncu        S=                 15000
          (SbdbDh(3-sin a)+5ShTbDb)                                    A53F, BW, Cont.Weld SE =                      7200
                                                                          Same, Seam Uncu S =                       12000
     JP = Allowable joint pressure
       P= 2St/D                                                             A7 = th x d1 x (2-sina) ,sq.in.,(sq.mm.)
      D = Nomina l pipe OD                                                  A1 = (2d2-d1)(Th-th)= db/sin a(Tm-PDm/2Sm), sq in(sq mm)
        t = Required pipe wall = PD/2S                                      A2 = 5Tb/sin a(Tb-tb), sq in (sq mm)
       T = T-A, Nominal pipe wall less tolerance & corrosion.               A3 = 2(0.7Tb)^2, sq in (sq mm)
      h = main, header                                                      A4 = reinforcement, if needed, sq in (sq mm)
      b = branch                                                            db = Db-2Tb
                                                                       d1 = d2 = db/sina
  Br.angle             deg      rad                                                   A4 = sq in                0.0000
       a=               90   1.5708     sin a =    1.0000                                    sq mm                   0
Basic Maximum Allowable Working Pressure
  Main                                            Branch                                                                   Max Main    Max Br
  Size           Sh          Dh         Th         Size        Sb          Db         Tb                      JP             Pm         Pb
   in            psi         in         in          in         psi         in         in                      psi
  12"         15000          12.75 0.250           8"       15000         219.1 0.250                         282.27            588          34
Area Check:
                                                                            Page 1
                                                               Branch Connections
   A7     S A1 to A4     A1        A2         A3         A4                     db
  sq in      sq in      sq in     sq in      sq in      sq in                    in
   26.224     26.223    28.426     -2.264      0.061     0.0000                218.600
Reinforcement:
  Main                                      Branch
  Size       Sh         Dh         Th        Size       Sb          Db          Tb        P    A4 Reinf.       db
   in        psi        in         in         in        psi         in          in       psi     sq in
  12"       15000      12.75 0.250           8"        15000       8.625 0.250           700       2.680         8.125
METRIC UNITS -- SEE ASME B36.10 FOR METRIC DIMENSIONS
  Size       Sh         Dh         Th        Size        Sb         Db          Tb               PF           Pm             Pb
  DN         kPa        mm         mm        DN         k/Pa        mm          mm               kPa          k/Pa       k/Pa
  300       103425      323.9      6.350     200       103425       219.1       6.350                  2283     4055         5995
    25      6.895          25.4    25.400     25       6.895           25.4     25.400          6.895         6.895        6.895
    12      15000      12.752     0.250        8       15000      8.625984     0.250             331           588          869
Area Check:
    A7   S A1 to A4      A1         A2        A3        A4                      db
  sq mm     sq mm      sq mm      sq mm     sq mm                               mm
  737.896    737.090     572.7    124.830    39.516      0.0000                206.400
                                                                      Page 2
                                                                            Branch Connections
See typical materials list below for examples
                                                        Table of Pipe Sizes and Schedules
                                                                  US customary Units
                          Pipe      Outside
                          Size      Dia, in.    Std      X 0.875    40     X 0.875        XS      80     X 0.875   160     XXS
                           1/8       0.405      0.068     0.060    0.068     0.060       0.095   0.095    0.083
                           1/4        0.54      0.088     0.077    0.088     0.077       0.119   0.119    0.104
                           3/8       0.675      0.091     0.080    0.091     0.080       0.126   0.126    0.110
                           1/2        0.84      0.109     0.095    0.109     0.095       0.147   0.147    0.129    0.187    0.294
                           3/4        1.05      0.113     0.099    0.113     0.099       0.154   0.154    0.135    0.218    0.308
                            1        1.315      0.133     0.116    0.133     0.116       0.179   0.179    0.157    0.250    0.358
                          1-1/4       1.66      0.140     0.123    0.140     0.123       0.191   0.191    0.167    0.281    0.382
                          1-1/2       1.9       0.145     0.127    0.145     0.127       0.200   0.200    0.175    0.281    0.400
                            2        2.375      0.154     0.135    0.154     0.135       0.218   0.218    0.191    0.344    0.436
                          2-1/2      2.875      0.203     0.178    0.203     0.178       0.276   0.276    0.242    0.375    0.552
                            3         3.5       0.216     0.189    0.216     0.189       0.300   0.300    0.263    0.438    0.600
                          3-1/2        4        0.226     0.198    0.226     0.198       0.318   0.318    0.278             0.636
                            4         4.5       0.237     0.207    0.237     0.207       0.337   0.337    0.295    0.531    0.674
                            5        5.563      0.258     0.226    0.258     0.226       0.375   0.375    0.328    0.625    0.750
                            6        6.625      0.280     0.245    0.280     0.245       0.432   0.432    0.378    0.719    0.864
                            8        8.625      0.322     0.282    0.322     0.282       0.500   0.500    0.438    0.906    0.875
                           10        10.75      0.365     0.319    0.365     0.319       0.500   0.594    0.520    1.125    1.000
                           12        12.75      0.375     0.328    0.406     0.355       0.500   0.688    0.602    1.312    1.000
                           14          14       0.375     0.328    0.438     0.383       0.500   0.750    0.656    1.406
                           16          16       0.375     0.328    0.500     0.438       0.500   0.844    0.739    1.594
                           18          18       0.375     0.328    0.562     0.492       0.500   0.938    0.821    1.781
                           20          20       0.375     0.328    0.594     0.520       0.500   1.219    1.067    1.969
                           24          24       0.375     0.328    0.688     0.602       0.500   1.219    1.067    2.344
                          > 24                  0.375     0.328              0.000       0.500            0.000
                                                                                     Page 3
                                               Branch Connections
                                              SI Units
                         Schedule or Designation, wall thickness in millimeters
Dia     Outside
No.     Dia. mm   5S        10S        Std        40        XS         80         120     160     XXS
  3      10.3     0.09     1.24       1.73       1.73       2.41      2.41
  6      13.7     1.24     1.65       2.24       2.24       3.02      3.02
 10      17.1     1.65     1.65       2.31       2.31       3.20      3.20
 15      21.3     1.65      2.11      2.77       2.77       3.73      3.73                4.87    7.47
 20      26.7     1.65      2.11      2.87       2.87       3.91      3.91                5.56    7.82
 25      33.4     1.65     2.77       3.38       3.38       4.55      4.55                6.35    6.35
 30      42.2     1.65     2.77       3.56       3.56       4.85      4.85                 6.35    9.70
 40      48.3     1.65     2.77       3.68       3.68       5.08      5.08                 7.14   10.15
 50      60.3     1.65     2.77       3.91       3.91       5.54      5.54                 8.74   11.07
 65      73.0     2.11     3.05       5.16       5.16       7.01      7.01                 9.53   14.02
 80      88.9     2.11     3.05       5.49       5.49       7.62      7.62                11.13   15.24
  90     101.6    2.11     3.05       5.74       5.74        8.08      8.08                       16.15
 100     114.3    2.11     3.05       6.02       6.02        8.56      8.56       11.13   13.49   17.12
 125     141.3    2.77     3.40       6.55       6.55        9.53      9.53       12.70   15.88   19.05
 150     168.3    2.77     3.40       7.11       7.11       10.97     10.97       14.27   18.26   21.95
 200     219.1    2.77     3.76       8.18       8.18       12.70     12.70       18.26   23.10   22.23
 250     273.0    3.04     3.96       9.27       9.27       12.70     15.09       21.44   28.58   25.40
 300     323.8    3.96     3.96       9.53      10.31       12.70     17.48       25.40   33.23   25.40
 350     355.6    3.96     6.35       9.53      11.13       12.70     19.05       25.40   35.71
 400     406.4    3.96     6.35       9.53      12.70       12.70     21.44       30.96   40.49
 450     457.0    3.96     6.35       9.53      14.27       12.70     23.83       34.93   45.24
 500     508.0    4.78     6.35       9.53      15.09       12.70     26.19       38.10   50.01
 600     601.0    5.54     6.35       9.53      17.48       12.70     30.96       46.02   59.54
> 600                                 9.53                  12.70
                                                        Page 4