Re: C.O.G OF PIPES

Thanks all for your replies. I have one more query. Is there any way by which if I draw lines in 2d showing the pipe network, Can I export the values of x1,y1 and x2,y2, to the excel sheet. This will be useful as there are lot of pipes so I will have to go toeach point to see the x1,y1,x2,y2 etc.
Thanks

Jijoy.

• Original Message ----- From: "Christopher Wright" <chrisw@skypoint.com> To: "?" <PipingDesign@yahoogroups.com> Sent: Tuesday, June 01, 2004 9:43 PM Subject: Re: [PipingDesign] 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)
> <a href="http://www.skypoint.com/~chrisw">http://www.skypoint.com/~chrisw</a>
>
>
>
>
>
> =========================================
> PipingOffice - Excel Spreadsheets for Piping Calculations
> <a href="http://www.pipingoffice.us/">http://www.pipingoffice.us/</a>
> =========================================
> Main site: <a href="http://www.pipingdesign.com">http://www.pipingdesign.com</a>
>
> Yahoo! Groups Links
>
>
>
>
>
>
Received on Wed Jun 02 02:22:00 2004