Pipe Schedule Formula??

I haven't heard of such a function, but a few quick calculations using the first five pipe sizes starting at 1/2" shows that the wall thickness increases exponentially as a function of o.d.

Plotting such data should enable you to do a curve fit fairly quickly.

I also have not consulted "Machinery Handbook," which may have the information you seek.

If you can input the ID and the OD of the pipe, 1/2 the difference of the two will be the wall thickness.

Thanks for the help everyone.

Looks like I'll be on the keyboard this weekend once again! Although I will plot that data and appoximate a function. It should be interesting.

Yes, an engineering bartering section sounds like a terrific idea...if people deliver what they actually promise.

Heath, one last thing to try before you give up the week end.

I have a vague recollection of some one mentioning a formula on this site relating pipe schedule to diameter ratios. Try the CR4 search for "pipe schedules" and see what pops up.

hi

p/s X 1000

p = working pr.

s=allowable stress.

The formula for stress in the pipe is stress=pd/2t. p=pressure, d=outside (i think) dia, t=wall thickness. If you put the pipe yield stress in for stress and solve for t, you get the schedule. Do a google search and you'll find the actual value for stress used, or just solve for a few pipe sizes.

Hi, I think that if the end use of the formula will be to use it into a VBA macro, you can creat an additional sheet on the Excel workbook and put in the data for the SCH-40 pipe geometry and create a routine that finds the desired data using a known value (maybe one of the diameteres or the thicknees or in the most difficult case a parameter that could be calculated accordingly to the design like a diameter relation or an average diameter) and applying the Excel function of Vlookup or Hlookup.

There is no a function to be used, but you have to create a database to include all pipe diameters (NPS & OD) and thicknesses (schedules). NPS and OD are constant values for the same nominal pipe size, and ID is a variable value depends on thickness of pipe.