Re: C.O.G OF PIPES

>This is what I didn''t understand. Could you show it with some example.
I'll do better I'll tell you how to do it yourself.

Each span of pipe has a start point and an end point and a size. The start and end points are three coordinates in space. So you might set up columns like this

SpanID Size x1 y1 z1 x2 y2 z2 Length Weight xg yg zg

--Span ID is just a number used to identify the run as a convenience --Size might be say 4.5 sch40 identifying the nominal pipe size x1, y1, z1, x2, y2, z2 are the end point coordinates --Figure the length as the absolute distance between the end points: =SQRT((x2_-x1_)^2+(y2_-y1_)^2+(z2_-z1_)^2) xg, yg and zg are the CG coordinates for each run. Figure them as the averages of the respective endpoint coordinates ie. xg =0.5*(x1_+x2_) --Weight is the weight of the run, equal to the weight/length for the pipe size times the length. You'd find the weight/length from a handbook. Make a look-up table anywhere that's convenient with one column containing the pipe size and the adjoining column as the weight/length. Use one of the Excel look-up functions to do the lookup as shown in the docs. For example =LOOKUP(Size,NPS,wt)*Length. The wt table entry can include an adder for insulation and contents.

Christopher Wright P.E.    |"They couldn't hit an elephant at
chrisw@skypoint.com        | this distance"   (last words of Gen.
___________________________| John Sedgwick, Spotsylvania 1864)