Re: C.O.G OF PIPES

Christopher,
You had written something for automating the weight and c.o.g. I didn't get you. could you please show it.

Regards

Jijoy.
----- Original Message -----
From: "Christopher Wright" <chrisw@skypoint.com> To: "?" <PipingDesign@yahoogroups.com>
Sent: Sunday, May 30, 2004 9:44 PM
Subject: Re: [PipingDesign] C.O.G OF PIPES

> >I have a network of pipes inside a rig. And I want to find the C.O.G
(Center
> >of Gravity) of these pipes. Is there any easy method or any software
which
> >will help me do this.
> Easy as rolling off a log with Excel:
> Set up columns as follows with the weight and CG of each span. Name each
> column (Formula>Define Name...) as indicated
> Column A Weight
> Column B Xcg
> Column C Ycg
> Column D Ycg
>
> Sum the weights =SUM(Weight) and name the total Wtot.
> =SUM(Weight*Xcg)/Wtot will give you the the X location of the CG. Use
> similar formulas for the Y and Z coordinates.
>
> If you want to spend a little more time to have something you can use
> over and over, add columns identifying each span and the weight/foot with
> the beginning and end points and automate the weight and CG calculation.
> You can get really cool and make the calculation into a workbook and get
> the weight/foot value from a look-up table or include the incremental
> Wt/ft for contents and insulation.
>
> Christopher Wright P.E. |"They couldn't hit an elephant at
> chrisw@skypoint.com | this distance" (last words of Gen.
> ___________________________| John Sedgwick, Spotsylvania 1864)
> http://www.skypoint.com/~chrisw
>
>
>
>
>
> =========================================
> PipingOffice - Excel Spreadsheets for Piping Calculations
> http://www.pipingoffice.us/
> =========================================
> Main site: http://www.pipingdesign.com
>
> Yahoo! Groups Links
>
>
>
>
>
>
Received on Mon May 31 00:16:00 2004