Universal Nozzle Calculator Ver 3.0

Legal Statement Year 2000 releases (c) 2000 www.laurencebrundrett.com

Terms This is a license, not a sale. The following terms and conditions apply If you use this product you agree to the following terms and conditions: 1 Registering for this product grants you permission to use this product. The copyright remains with www.laurencebrundrett.com. This notice must be included with all copies made. 2 You may use this product only on a single computer or network, and only by one user at a time. You must register more copies if you need it for more users. 3 This product is sold "as is" without warrantees or liability. It is your responsibility to know how to use this software. Any product designed with this software is your responsibility. The author does not guarantee the accuracy of this product. All risk associated with this products use is assumed by you. 4 www.laurencebrundrett.com does not provide support for the use of this product 5 The codes and standards that this product is based on change periodically. It is your responsibility to check that you are using an appropriate version. This program is not a substitute for knowing the applicable codes and standards. The calculation sheet has a link back to the web page for this product. Check that the version you are using is the latest version. 6 Registering for this product does not guarantee that future versions will be made available as applicable codes and standards change.

Locked Cells This spreadsheet is locked for your convenience. You can move between input cells using the tab key. The password to unlock it is "100" If you make changes to this spreadsheet you are required to remove the "www.laurencebrundrett.com" text. You are responsible for any and all changes that you make.

Updates The codes and standards that this program are based on are updated periodically. If you have registered for this product, reasonable attempts will be made to email you when updated versions are available. You will also be notified when your registration has expired.

Comments If you have comment, corrections or questions about this product send an email to [email protected].

Registration This program must be registered prior to commercial use. Register this program at www.laurencebrundrett.com Register

Printing A Printing macro is provided with this spreadsheet. Press Ctrl+p to print the calculations. The macro checks for a dangerous condition where Excel allows input values to be changed but does not recalculate the outputs. If this occurs, an error message will pop up. Your computer has run out of resources and must be restarted.

This protection is only available if you use the macro.

2 <- Useful page 2 formula 3 <- Useful page 3 formula

17 18 22 20 21 22 23 24 25 26 27 28 29 30 32 35 36 38 39 41 42 43 44 45 46 47 56 59 62 63 64 68 74 82 84 95 99 107 108 110 111 112 113 114 130 131

136 137 138 139 142 143 146 147 151 152 158 159 163 164 172 181 182 267 269 270 271

=

Setup Select a design and options using pull down menus The spreadsheet will show the equations and drawing for the correct case The drawings for the available nozzle designs can be viewed by scrolling right -------->

Do

Do Leg5

t

Do Leg41

UW-16.1 (d)

te

Rin g g

Leg42

tp

Leg41

Leg41 Leg41

Nozzle

Shell

Do UW-16.1(q) modified with proj UW-16.1 (h)

UG-40 (a-2)

Vt

L eg5

Leg42

Shell

Leg41 Leg42

Leg41

5

Shell

Vt

Nt

Leg41

Vt

di

Leg41

#DIV/0! From Table IID-G

Leg43

L eg43

Do Nt

Leg42

t/2 t/2

t/2 t/2

Vt UW-16.1 (a) A=

<- P, internal design pressure <- Pa, external design pressure

Full Penn.

t

Dp

Nt

Nt

te

Ring

Nozzle

Nozzle

Do

Do

Shell

Leg42

g

trn = #DIV/0! trnE = #DIV/0!

t/2 t/2

t Leg41

Leg43

Full Penn.

Shell Vt

Leg41

Shell

Leg5

Leg42

Leg41

Vt Leg43

UW-16.1 (c)

Okay #DIV/0!

5

Rin g

te

R te

g

Vt

Shell

Vt

Ip

R/2

OD Nozzle

UW-16.1 (k)

Nt

Full Penn.

t

Nt

Do

Nt

Do t

Leg5

Leg41

Leg41

Leg41

Shell

Leg41

Vt Leg43

Proj

UW-16.1(i)

Nozzle

Shell Vt

Leg43

Nozzle

Leg41 Leg41

UW-16.1 (c) modified

UG-40(i) UG-42(c)

Do

Leg43 Leg41

Leg43

Vt

Proj

5

Ring

g

Shell UW-16.1 (k) modified

Leg42 te Shell Dp

LegG UW-16.1(q) - modi fied

Vt

S hell

Vt

Shell Vt

Dp UW-16.1(q)

Do

Nt

R/2

Dp

Shell

UW-16.1 (e) modified

Nozzle

0.000 = #DIV/0!

Vt

OD Nozzle Nt

Leg41

Leg41

Leg41

Leg41

#DIV/0! #DIV/0!

UW-16.1 (h) - modified

Do Nt

Nt

Nozzle

Leg43

UW -16.1(q) with proj

LegG

>=

Nozzle

Geometry Constraints: 0.7*Leg41 >= tc41 0.7* >= 0 0.000 UG-45 = Max(Max(trn,trnE)+corr,Min(StdPipe+Corr,Max(tr,(Pa/P)*tr,0.0625)+corr)) <= Nt-UT = #DIV/0!

OD Nozzle

Do Nt

Nozzle

= MIN(/, 1) = Min(0.25,0.7*Min(0.75,0,0))

Pipe Required Wall Thickness - trn from internal, trnE from external pressure trn = (P*Rn)/(Sn*E - 0.6*P) <= tn-UT = (*0)/(* - 0.6*) trnE = (3*Do*Pa)/(4*B) <= tn-ut = (3*0*0)/(4*0)

Do Nt

Nozzle

Rn = 0.000 UT = 0.000 t = 0.000 tn = 0.000 fr1 = 1.000 fr2 = #DIV/0! tc41 = 0.000 F = 1.000

Nozzle

= /2 - 0 = * = = 0-0

Nozzle

Variables:

Sh ell Dp LegG L eg43

Weld to connect to rein forcing pa d

t

te

Proj

Dp

<- Leg41, size of weld fillet <- F

Ring

g

Vt

Shell

UW-16.1 (e)

UW-16.1 (b)

Reinforcing:

Dp LegG

We ld to connect to reinforcing pad

Leg43 Leg41 Shell

Vt

Shell

Proj

Dp t

tp

Vt

te

g

Proj

L egG

UW-16.1 (i) modified

Leg41 Leg41

Vt

Shell

Ring

5

Nozzle

Nozz le

Vt

Leg43

t

di

Leg42 Shell

LegG Leg4 3

Nt

Leg41

Leg42

Leg5

Vt

<- Do, outside diameter <- dh, id of hillside nozzle <- L, exterior Projection <- Nt, wall thick, uncorroded <- UTp, undertolerance (%) <- E nozzle

Rn = Do/2 - tn UT = Nt*UTp t = Vt-corr tn = Nt-corr fr1 = 1.000 fr2 = MIN(Sn/Sv,1) tcLeg41 = Min(0.25,0.7*Min(0.75,tn,t)) F = Min(Fenterered, 1)

Leg5

Leg41

Shell

Dp

Nt

Nt

Leg41

Nt

Leg41 Leg41

Do

Nozzle:

<- Nozzle material <- Sn, allowable stress level (Sn) <- B, max exterior stress

OD Nozzle

Nt

29-Sep-09 Page 1 Manual dh for hillside nozzles Automatic Limit Diameter Curved Shell or Head Section

Nozzle

UW16(a)

www.pveng.com

<- Vessel <- Desc

Nozzle

ver 3.0

<- Shell material <- Sv, allowable stress level <- Vt, wall thick, uncorroded <- tr, required wall thickness int. press. <- trE, required wall thickness ext. press. <- Eone, efficiency of shell at nozzle <- corr, corrosion allowance

Noz zle

ASME Code VIII Div I 2001 no add

No zzle

UW16(a) <- Select a nozzle design Manual dh for hillside nozzles<- Manually enter dh - nozzle hillside inside diameter? Automatic Limit Diameter <- Use a manual limit diameter (for interaction with other nozzles)? <- Is this nozzle intersecting a Flat Plate or Curved shell or Head Section

Curved Shell or Head Section

Nozzle Reinforcement

UG-40 (a-2) & UW-16. 1(i)

OD Nozzle External

UG-42(c)

Do

Nt

Do

Leg43 Leg41

Leg43

Nt

Full Penn.

t

0.000

Nt

#DIV/0!

Shell

t

Shell

Leg41

Leg43

Leg41

Vt

Vt

Leg43

#DIV/0! #DIV/0! #DIV/0!

UW-16.1 (c) modified

5

te Vt

Shell

Shell

Dp

UW-16.1 (k) modified

UW-16.1(i)

Vt

Leg42

Ring

g

Vt

Proj

Proj

#DIV/0!

S hell

Leg5

Leg41

Leg41

Nozzle

Leg41

Nozzle

0.000

#DIV/0! #DIV/0! #DIV/0!

Do

Nt

Do

Leg41

0.000

Nozzle

Internal 0.000

Nozzle

Area Replacement: Fig UG-37.1 Pressure From: A = 1*d*tr*F + 2*tn*tr*F*(1-frone) A Required (internal) = = 1*0*0*1 + 2*0*0*1*(1-1) Ae = 0.5*(d*trE*1 + 2*tn*trE*1*(1-frone)) A Required (external) = = 0.5*(0*0*1 + 2*0*0*1*(1-1)) A1 = max(d, 2*(t+tn)) * (E1*t-F*tr)-2*tn*(E1*t-F*tr)*(1-fr1) A1 = = max(0, 2*(0+0)) * (0*0-1*0)-2*0*(*0-1*0)*(1-1) A1e = max(d, 2*(t+tn)) * (Eone*t-F*trE)-2*tn*(Eone*t-F*trE)*(1-frone) A1e = = max(0, 2*(0+0)) * (0*0-1*0)-2*0*(0*0-1*0)*(1-1) A2 = min((tn-trn)*fr2*Min(5*t,2*L) , (tn-trn)*fr2*Min(5*tn,2*L)) A2 = = #DIV/0! A2e = min((tn-trnE)*frtwo*Min(5*t,2*L) , (tn-trnE)*frtwo*Min(5*tn,2*L)) A2e = = #DIV/0! A41 = Leg41^2*frTwo A41 = #DIV/0! A41 = Actual Area = #DIV/0! Actual-Required = Weld strength calculations are not required per UW-15(b)(1)

LegG UW-16.1(q) - modi fied

Do not make changes! 1

<- Drawing Index #VALUE! 0

0

OD 0.405 0.540 0.675 0.840 1.050 1.315 1.660 1.900 2.375 2.875 3.500 4.000 4.500 5.563 6.625 8.625 10.750 12.750 200.000

Std Wall Less 12.5% 0.068 0.060 0.088 0.077 0.091 0.080 0.109 0.095 0.113 0.099 0.133 0.116 0.140 0.123 0.145 0.127 0.154 0.135 0.203 0.178 0.216 0.189 0.226 0.198 0.237 0.207 0.258 0.226 0.280 0.245 0.322 0.282 0.365 0.319 0.375 0.328 0.375 0.328

Pipe Wall Thickness Chart & Seamless Fitting Chart Chart Name = ChartPipeWall & ChartPipeWallTitle & ChartPipeWallOD

Nominal Size 0.5 0.75 1 1.25 1.5 2 2.5 3 3.5 4 5 6 8 10 12 14 16 18 20 24 30 36 42

Pipe OD .840 1.050 1.315 1.660 1.900 2.375 2.875 3.500 4.000 4.500 5.563 6.625 8.625 10.750 12.750 14.000 16.000 18.000 20.000 24.000 30.000 36.000 42.000 2

1

* Light .083 .083 .109 .109 .109 .109 .120 .120 .120 .120 .134 .134 .148 .165 .180 .250 .250 .250 .250 .250 .312 .312

** 20

30

#N/A

Std .109 .113 .133 .140 .145 .154 .203 .216 .226 .237 .258 .280 .322 .365 .375 .375 .375 .375 .375 .375 .375 .375 .375 6

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

.250 .250 .250 .312 .312 .312 .375 .375 .500 .500

.277 .307 .330 .375 .375 .438 .500 .562 .625 .625

#N/A

#N/A

#N/A

3

4

5

Schedule 40 .109 .113 .133 .140 .145 .154 .203 .216 .226 .237 .258 .280 .322 .365 .406 .438 .500 .562 .594 .688 #N/A

.750

*** 60 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

.406 .500 .562 .594 .656 .750 .812 .969 #N/A #N/A

#N/A

#N/A

7

8

X-stg .147 .154 .179 .191 .200 .218 .276 .300 .318 .337 .375 .432 .500 .500 .500 .500 .500 .500 .500 .500 .500 .500 .500 9

80 .147 .154 .179 .191 .200 .218 .276 .300 .318 .337 .375 .432 .500 .594 .688 .750 .844 .938 1.031 1.219

100 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

.594 .719 .844 .938 1.031 1.156 1.281 1.531

#N/A

#N/A

120 #N/A

140 #N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A #N/A #N/A

.438 .500 .562 .719 .844 1.000 1.094 1.219 1.375 1.500 1.812 #N/A

#N/A #N/A #N/A #N/A #N/A #N/A

.812 1.000 1.125 1.250 1.438 1.562 1.750 2.062 #N/A #N/A

160 .188 .219 .250 .250 .281 .344 .375 .438 #N/A

.531 .625 .719 .906 1.125 1.312 1.406 1.594 1.781 1.969 2.344 #N/A #N/A

XX-stg .294 .308 .358 .382 .400 .436 .552 .600 .636 .674 .750 .864 .875 1.000 1.000 #N/A #N/A #N/A #N/A #N/A #N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

10

11

12

13

14

15

#N/A

Nominal Size 0.5 0.75 1 1.25 1.5 2 2.5 3 3.5 4 5 6 8 10 12 14 16 18 20 24 30 36 42

* Light wall thicknesses are identical to stainless steel schedule 10S in sizes thru 12" and to Sch 10 in sizes 14" and larger ** Standard wall thicknesses are identical to Stainless steel schedule 40S in sizes thru 12" ** Extra Strong wall thicknesses are identical to Stainless steel schedule 80S in sizes thru 12"

Undertolerance This chart provides the under-tolerance allowance for pipes and tubes listed in Section IIA. For example SA-53 under-tolerance is listed as -12.5% (pipe wall can be 12.5% Thin). Use a value of +12.5% in the Pipe spreadsheet. Undertolerance is not used for rolled shell. Items not included in this chart Spec. No.

Source

SA-53 SA-106 SA-134 SA-135 SA-178 SA-179 SA-192 SA-199 SA-209 SA-210 SA-213 SA-214 SA-226 SA-249 SA-250 SA-268 SA-312 SA-333 SA-334 SA-335 SA-358 SA-369 SA-376 SA-409 SA-423 SA-426 SA-430 SA-451 SA-452 SA-524 SA-556 SA-557 SA-587 SA-660 SA-671 SA-672

Weld

Seamless

-12.5%

SA-450

Cast

Forged & Bored

-12.5% -12.5%

SA-530

??? -12.5% -5.0% -10.0% -10.0% -10.0% -10.0% -10.0% -10.0%

SA-450 SA-450 SA-450 SA-450 SA-450 SA-450

-5.0% -5.0% -5.0% -5.0% -5.0% -12.5% -12.5% -5.0%

SA-450 SA-450 SA-450 SA-450 SA-450 SA-530 SA-530 SA-450

-12.5% -12.5% -10.0% -12.5%

SA-530

-12.5%

SA-530

0.0%

SA-530

-12.5%

SA-530

-12.5% -5.0%

SA-530 SA-450

-10.0% 0.0%

SA-530

0.0%

SA-530

0.0% 0.0%

SA-530 SA-530

-12.5% -10.0%

SA-530 SA-450

-5.0%

SA-450

** 0.0%

SA-530 SA-530 SA-530

SA-688 SA-691 SA-731 SA-789 SA-790 SA-803 SA-813 SA-814

SA-450 SA-530 SA-530 SA-450 SA-530 SA-450 SA-530 SA-530

-12.5% -12.5% -5.0% -12.5% -12.5% -5.0% -12.5% -5.0% -12.5% -12.5%

-12.5% -10.0% -12.5%

** See Chart Table 4 in spec SA-587. Set undertolerance to zero and use the diameter values given

This chart provides the under-tolerance allowance for pipes and tubes listed in Section IIB. Some undertolerances have to be looked up in the specification. Example: See table 3 in SB-42 (ASME IIB) for undertolerance for SB-42 pipe. * These specifications are included on this sheet Not included in ASME IIB Spec. No. Undertolerance % or inch SB-42 SB-43 SB-75 SB-111 SB-135 SB-161 SB-163 SB-165 SB-167 SB-210 SB-234 SB-241 SB-315 SB-337 SB-338 SB-359 SB-395 SB-407 SB-423 SB-444 SB-464 SB-466 SB-467 SB-468 SB-514 SB-515 SB-516 SB-517 SB-523 SB-535 SB-543 SB-619 SB-622 SB-626 SB-658 SB-668 SB-673 SB-674 SB-675 SB-676 SB-677 SB-690 SB-704 SB-705 SB-710 SB-729 SB-804

See Table Refer To in particular Spec No. Table 3 Table 1 * SB-251 Table 7 * SB-251 Table 3

0.0% 0.0% 0.0% ANSI H35.2 para 11.5 ANSI H35.2 para 14.1 ANSI H35.2 para 12.3, 16.2 Table 4,5 12.5% 10.0% 0.0% Table 5 Table 3 0.0% * SB-829 * SB-775 * SB-251 Table 6 * SB-751 * SB-775 * SB-751 * SB-751 * SB-775 10.0% * SB-829 Table 7 * SB-775 Table 4 Table 4 12.5% Table 4 * SB-751 Table 3 12.0% Table 3 Table 3 0.0% * SB-751 12.0% * SB-775 * SB-829 0.010"

SB-251 - undertolerance in inches Max Pipe or Tube OD, inch Maximum Wall, inch 0.13 0.63 0.02 0 0 0.02 0 0 0.03 0 0 0.06 0 0 0.08 0.01 0.12 0.01 0.16 0.01 0.22 0.01 0.28

1 0 0 0 0 0.01 0.01 0.01 0.01 0.02

2 0 0 0 0.01 0.01 0.01 0.01 0.01 0.02

4

7

10

0.01 0.01 0.01 0.01 0.01 0.02 0.02

0.01 0.01 0.01 0.01 0.02 0.02

0.01 0.01 0.02 0.02 0.02

SB-829 - undertolerance in % for seamless cold worked pipe and tube Max OD % SB-829 Table 3 0.63 15.0% 1.5 10.0% 3 10.0% 4.5 10.0% 6 12.5% 6.63 12.5% 8.63 12.5% SB-829 - undertolerance in % for hot workded tube Max OD % SB-829 Table 4 1.5 12.5% 4 12.5% 9.25 12.5% SB-829 - undertolerance in % for hot workded pipe Max OD % SB-829 Table 4 4.5 12.5% 6.5 12.5% 9.25 12.5%

SB-775 - undertolerance in % for seamless cold worked pipe Max OD % SB-775 Table 4 0.63 15.0% 1.5 10.0% 3 10.0% 4.5 10.0% 6 12.5% 6.63 12.5% 8.63 12.5% SB-775 - undertolerance in % for welded pipe Max OD % SB-775 Table 3 any 12.5% SB-775 - undertolerance in % for seamless hot worked pipe Max OD % SB-775 Table 5 4.5 12.5% 6.5 12.5% 9.25 12.5%

SB-751 - undertolerance in % for seamless cold worked tube Max OD % SB-751 Table 4 0.63 15.0% 1.5 10.0% 3 10.0% 4.5 10.0% 6 12.5% 6.63 12.5% 8.63 12.5% SB-751 - undertolerance in % for seamless hot worked tube Max OD % SB-751 Table 5 1.5 12.5% 4 12.5% 9.25 12.5%

Ouch! Do not Modify! Factor G Charts

DoT = 0 copied from Dot = 4 TableLdo LDo | | V

DoT --> 0.00 0.01 0.02 0.05 0.10 0.20 0.40 0.70 1.00 1.50 2.30 3.50 5.00 7.50 12.00 19.00 30.00 50.00 1000.00 1001.00 1 This Next Value Log Value

0 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.03 -1.09 -1.12 -1.13 -1.14 -1.14 -1.14 -1.14 -1.14 -1.14267 2

4 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.03 -1.09 -1.12 -1.13 -1.14 -1.14 -1.14 -1.14 -1.14 -1.14 3

5 -1.03 -1.03 -1.03 -1.03 -1.03 -1.03 -1.03 -1.03 -1.03 -1.06 -1.22 -1.29 -1.32 -1.33 -1.34 -1.34 -1.34 -1.34 -1.34 -1.34 4

6 -1.08 -1.08 -1.08 -1.08 -1.08 -1.08 -1.08 -1.08 -1.08 -1.19 -1.37 -1.45 -1.48 -1.5 -1.5 -1.5 -1.51 -1.51 -1.51 -1.51 5

8 -1.01 -1.01 -1.01 -1.01 -1.01 -1.01 -1.01 -1.01 -1.18 -1.39 -1.6 -1.7 -1.74 -1.75 -1.76 -1.76 -1.76 -1.76 -1.76 -1.76 6

10 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.02 -1.14 -1.33 -1.53 -1.76 -1.88 -1.93 -1.94 -1.95 -1.95 -1.95 -1.95 -1.95 -1.95 7

15 -1.01 -1.01 -1.01 -1.01 -1.01 -1.01 -1.11 -1.41 -1.61 -1.8 -2.03 -2.2 -2.27 -2.29 -2.3 -2.31 -2.31 -2.31 -2.31 -2.31 8

20 -1.01 -1.01 -1.01 -1.01 -1.01 -1.01 -1.32 -1.62 -1.81 -1.99 -2.21 -2.42 -2.51 -2.54 -2.55 -2.56 -2.56 -2.56 -2.56 -2.56 9

25 -1.06 -1.06 -1.06 -1.06 -1.06 -1.06 -1.46 -1.76 -1.95 -2.14 -2.35 -2.57 -2.69 -2.73 -2.75 -2.75 -2.75 -2.75 -2.75 -2.75 10

30 -1.04 -1.04 -1.04 -1.04 -1.04 -1.2 -1.61 -1.9 -2.08 -2.26 -2.47 -2.68 -2.83 -2.89 -2.9 -2.91 -2.91 -2.91 -2.91 -2.91 11

40 -1.06 -1.06 -1.06 -1.06 -1.06 -1.41 -1.81 -2.09 -2.27 -2.45 -2.65 -2.85 -3.04 -3.13 -3.15 -3.16 -3.16 -3.16 -3.16 -3.16 12

50 -1.03 -1.03 -1.03 -1.03 -1.11 -1.58 -1.97 -2.24 -2.42 -2.58 -2.79 -2.99 -3.19 -3.31 -3.35 -3.35 -3.35 -3.36 -3.36 -3.36 13

60 -1.02 -1.02 -1.02 -1.02 -1.25 -1.71 -2.09 -2.36 -2.54 -2.7 -2.92 -3.12 -3.29 -3.45 -3.5 -3.51 -3.51 -3.51 -3.51 -3.51 14

80 -1 -1 -1 -1 -1.48 -1.92 -2.29 -2.55 -2.73 -2.89 -3.1 -3.29 -3.47 -3.66 -3.74 -3.76 -3.76 -3.76 -3.76 -3.76 15

100 -1.13 -1.13 -1.13 -1.13 -1.66 -2.08 -2.44 -2.7 -2.87 -3.03 -3.24 -3.44 -3.61 -3.81 -3.92 -3.95 -3.96 -3.96 -3.96 -3.96 16

125 -1.32 -1.32 -1.32 -1.32 -1.83 -2.24 -2.59 -2.85 -3.02 -3.18 -3.39 -3.58 -3.75 -3.95 -4.11 -4.14 -4.15 -4.15 -4.15 -4.15 17

150 -1.47 -1.47 -1.47 -1.47 -1.97 -2.37 -2.71 -2.96 -3.14 -3.3 -3.5 -3.7 -3.87 -4.07 -4.26 -4.3 -4.31 -4.31 -4.31 -4.31 18

200 -1.71 -1.71 -1.71 -1.71 -2.18 -2.57 -2.89 -3.16 -3.33 -3.49 -3.69 -3.88 -4.05 -4.25 -4.47 -4.54 -4.55 -4.56 -4.56 -4.56 19

250 -1.89 -1.89 -1.89 -1.89 -2.34 -2.72 -3.06 -3.31 -3.47 -3.63 -3.84 -4.02 -4.2 -4.39 -4.62 -4.73 -4.74 -4.75 -4.75 -4.75 20

300 -2.03 -2.03 -2.03 -2.03 -2.48 -2.84 -3.18 -3.43 -3.6 -3.75 -3.95 -4.14 -4.31 -4.51 -4.73 -4.88 -4.9 -4.91 -4.91 -4.91 21

400 -2.26 -2.26 -2.26 -2.26 -2.68 -3.04 -3.37 -3.62 -3.78 -3.94 -4.14 -4.33 -4.5 -4.69 -4.91 -5.05 -5.05 -5.05 -5.05 -5.05 22

500 -2.43 -2.43 -2.43 -2.43 -2.84 -3.19 -3.52 -3.77 -3.93 -4.08 -4.28 -4.47 -4.64 -4.83 -5.06 -5.06 -5.06 -5.06 -5.06 -5.06 23

600 -2.57 -2.57 -2.57 -2.57 -2.97 -3.31 -3.64 -3.89 -4.05 -4.2 -4.4 -4.59 -4.76 -4.95 -5.01 -5.01 -5.01 -5.01 -5.01 -5.01 24

800 -2.78 -2.78 -2.78 -2.78 -3.17 -3.51 -3.83 -4.07 -4.24 -4.39 -4.59 -4.78 -4.95 -5 -5 -5 -5 -5 -5 -5 25

1000 NextDoT -2.95 0.0100 -2.95 0.0200 -2.95 0.0500 -2.95 0.1000 -3.31 0.2000 -3.66 0.4000 -3.97 0.7000 -4.22 1.0000 -4.38 1.5000 -4.54 2.3000 -4.74 3.5000 -4.92 5.0000 -5.02 7.5000 -5.02 12.0000 -5.02 19.0000 -5.02 30.0000 -5.02 50.0000 -5.02 ### -5.02 ### -5.02 #N/A 26 26

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

4 #DIV/0! 5

5 #DIV/0! 6

6 #DIV/0! 8

8 #DIV/0! 10

10 #DIV/0! 15

15 #DIV/0! 20

20 #DIV/0! 25

25 #DIV/0! 30

30 #DIV/0! 40

40 #DIV/0! 50

50 #DIV/0! 60

60 #DIV/0! 80

80 #DIV/0! 100

100 #DIV/0! 125

125 #DIV/0! 150

150 #DIV/0! 200

200 #DIV/0! 250

250 #DIV/0! 300

300 #DIV/0! 400

400 #DIV/0! 500

500 #DIV/0! 600

600 #DIV/0! 800

800 #DIV/0! 1000

1000 #DIV/0! 10001

LDo = #DIV/0! ThisLDo = #DIV/0! NextLDo = #DIV/0! Range = #DIV/0! RatioThisLDo = #DIV/0! RatioNextLDo = #DIV/0! DoT2 DoT --> Value Next DoT

0 #DIV/0! 4

DoT = #DIV/0! ThisDoT = #DIV/0! NextDoT = #DIV/0! Range = #DIV/0! RatioThisDoT = #DIV/0! RatioNextDoT = #DIV/0! ValueThis DoT = #DIV/0! ValueNextDoT = #DIV/0! Value for A= #DIV/0!

10001 NextDoT #DIV/0! #N/A

Universal Nozzle Calculator Written By: Laurence Brundrett Code: ASME VIII Sections: UG-37-45 Update Log Date Change 23-May-99 Verified with L-7.1 Verified with L-7.2 21-May-00 Audit Check Verified with L-7.1 - does not cover reinforcement Hand check calculations 12-Jul-00 Rewrite to match L-7.2 (UW-16(h)) only Removed equations referencing A3 and A43 Added geometry constraints Added legal section Added commentary Verified against Appendix L-7.2 Locked Cells - password = 100 19-Oct-00 Updated to A2000 format - new picture New print macro, legal statement Verified against L-7.2.1 - same results Cells Locked - Password = "100" 19-Oct-00 Modified from UW-16(h) - no proj New drawing Additional calculations for A3 and A43 Verification Calculations are required Cells Locked - Password = "100" 6-Nov-00 Added UG-45 checks Added Nozzle and Pipe Thickness calcs Verified against ASME L-7.3.1 F = 1 for this geometry Locked 27-Dec-00 Modified to universal format nozzle calculator All nozzle calculations are on one spreadsheet New configuration macro written New print macro written All nozzle drawings imported Nozzle UG-40(a) - verified 18-Feb-01 Added Nozzle UW-16.1(e) modified - verified 6-Apr-01 Added Nozzle UW-16.1(a) - verified against ASME L-7.7.1 Added Nozzle UW-16.1(b) - Same calculation as UW-16.1(a) Nozzle Required Thickness now calculated based on ID, not OD UG-40(a) reverified against ASME L-7.6.1 UW-16.1(e) reverified against ASME L-7.6.1 Version Number Changed to 0.6 UW-16.1 (a) and (b) reverified against ASME L-7.6.1 7-Apr-01 Added Nozzle UW-16.1 (c,d,e) 13-Apr-01 Updated selection formulas - all nozzle configurations Added Nozzle UW-16.1(I)

Added Nozzle UG-40(I) 14-Apr-01 Changed format of UG-45 to match calcs from PV Elite - No change in results UG-45 now calculated with undertolerance, compared to nozzle after undertolerance removed 17-Jun-01 Extrerior pressure calculations added 25-Jun-01 Extrerior pressure calculations added - not verified Verified UW-16.1 (c) only for internal pressure 27-Jun-01 Modified UW-16.1(e) - exterior pressure calculations Verified External Pressure Calculations 1-Jul-01 Verifed for all verisions of UW16(q) - in use for UW 16(q) Verified for UW-16(e) modified - in use for UW-16(e) modified Verified for UW-16(e) - in use for UW-16(e) 4-Jul-01 Verified for UW-16(h) modified 10-Jul-01 Modified all weld strength equations for internal and external pressure Standardized formats for projecting through and butting against vessel wall 13-Jul-01 Added UG-42(c) - area replacement calculation 7-Aug-01 Verified for UW-16(k) 2-Oct-01 Added hillside dh entry - manual hillside calcs - version 2.17 Verified against ASME L-7.7 3-Oct-01 Modified UG-40(a) - Removed excess information 10-Oct-01 Added flat plate UG-39 factor Verified flat plate factor Added Diameter Limit Verified Diameter Limit 11-Oct-01 Updated All Drawings Added UW-16.1(c) modified - identical to UW-16.1(e) modified Verified to UW-16.1(e) 12-Oct-01 All Audit Runs UG-40(a-2) Okay UW-16.1(e) mod Okay UW-16.1(c) mod Okay UW-16.1(c) mod flat Okay UW-16.1(h) Okay UW-16.1(h)Mod Okay UW-16.1(a) Okay UW-16.1(a)Hillside Okay UW-16.1(b) Okay UW-16.1(c) Okay UW-16.1(c) Limit Dia Okay UW-16.1(i) Okay UG-40(i) Okay UW-16.1(q) Okay UW-16.1(q) Mod Okay UW-16.1(q) Mod Proj Okay UW-16.1(q) Proj Okay 16-Oct-01 All Audit Runs Cont… UW-16.1(k) Okay 17-Oct-01 UW-16.1(i)mod Okay UG-45 Okay UG-42(c) Okay Version Number = 2.20 19-Oct-01 UW-16.1(I)&UG-40(a-2) Okay Version Number = 2.21

24-Oct-01 UW-16.1(k)mod Okay UW-16.1(k) Removed W3-3 (identical to W2-2) - Okay Version Number = 2.22 Added cell protection to macro - there is no password 19-Dec-01 Added cells for BM and Nozzle Chart Info 24-Feb-02 Corrected Geomety constraints shown for case UG-40(a-2) 12-Apr-02 Added exterior length limits to A2 for cases where exterior pipe is not of infinite length Added corrosion reduction in thickness for area A3 Verified UW-16.1(c) and UW-16.1(e) 16-Jun-02 error in A2 calculation when L=0 fixed Version = 2.25 6-Jul-02 Major Upgrade of setup macro Macro is now embeded in the Nozzle sheet Setup is now automated Version = 3.0 13-Jul-02 UG-45 equation is updated allows for external pressure correction based on internal pressure - UG-45 b2 Updated macro to blank hidden input rows instead of setting value to 0.000 - easier to see items need All Audit Runs UG-40(a-2) Okay UG40(a)&Uw16(i) Okay UW16(e) Okay UW16(e)Mod Okay UW16(h)M Okay UW16(h) Okay UW16(a) Okay Hillside calculation UW16(c) Okay UW16(e) Okay UW16(i) Okay UG42(c) Okay UG40(i) Okay UW16(q)MP Okay UW16(q)M Okay UW16(q) Okay UW16(i)mod Okay UW16(k) Okay UW16(k)mod Okay UW16(c)mod Okay UW16(b) Okay UW16(d) Okay UW16(q)P Okay Spreadsheet locked First copy published to web site

olerance removed

easier to see items needing entry