Anyone know of a spreadsheet which can roughly calculated the required pipewall when pressure/temperature is inputted.

Materials used carbon steel, stainless steel and duplex.

Do you mean the formula t=pD/2xMaterial Yield?

e.g.

A3 = 15 (Pressure in bar)
B3 = 508 (Pipe O.D.)
C3  = 275 (Material Yield)

D3 = =(A3*B3)/(2*2/3*C3)/10 (Answer of 2.07).

I'm not sure how the answer is affected by the temperature, but you did say a rough answer.

I assume from your description that you are referring to transition pipe or pups attached to weld end valves where the length of pipe is typically about 3' for larger size valves.  Smaller size valves may have shorter pups.

The purchaser should specify the piping code of the mating pipe which in turn gives the formula.  There are variations in code formulas as to what allowable stress, design factors, etc. that you plug into the formula.  For example, the formula for B31.3 uses an allowable stress with a built-in safety factor.  On the other hand, B31.8 uses the yield stress plus a design factor in the formula.

If it is B31.8 then they should also specify the installation class which determines the design factor.  The design factor can vary depending on whether the valve is in a cross country pipeline or in a facility.  Hence the valve(ball valve) manufacturer has no way of knowing unless the purchaser tells him.

I always specify the piping code, grade and wt of the mating pipe.  If the valve manufacter choses to use a lower grade pipe and hence thicker wt then he is responsible for bevelling the ends to match the mating pipe all within the rules of the particular code.

Many companies furnish the pipe to the valve manufacturer when they order several valves so that they can control the material properities of the pipe.  Who furnishes the pipe should always be addressed in the specifications.

Assuming for the moment that you are supplying a ball, gate on other open/close valve and not a control valve then in my opinion the noise generated by the piping is the responsibility of the purchaser.  In these cases I will purchase separately a removable insulation blanket for the valve and special acoustical insulation for the piping.

Back to your orginal question about a spread sheet for calculating the wall thickness.  Once you know the piping code then writing the spread sheet should not take you more than a few minutes.  The biggest time consuming task is to look up the formula and the allowable stresses for different materials which is particular for each application.

MORE NEWS