Section properties for groups of defined shapes

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E values.

The new spreadsheet may be downloaded from Section Properties07.zip, including full open source code.

The procedure is:

  • Select a shape from the drop-down list on the “DefShapes” sheet and enter the required dimensions.
  • In the Group Properties table (further down on the same sheet) enter details of X and Y offsets, rotations, and Elastic Modulus values for one or more copies of this shape.
  • Click the “Create new group” button.  The Group Properties table will update.
  • Different shapes may be added by following the same procedure as above, then click the “Add shapes to group” button.

Holes inside a shape may be defined using Elastic Modulus values of 1 and -1 for the shape and holes respectively.

The grouped shapes may be plotted on the “Coords_Group” sheet, which also recalculates section properties, based on end point coordinates.  Note that properties on the “Coords_Group” sheet will be slightly different from those shown in the Group Properties table for any shape including curves because the calculation on that sheet models curves as a series of short straight lines.  For any polygonal shape the results should be exactly the same (within machine precision).

Examples of input and results are shown in the screen-shots below.

Create 6 equilateral triangles, offset so that the tip is at the origin, and rotated through 60 degree increments

Create 6 equilateral triangles, offset so that the tip is at the origin, and rotated through 60 degree increments

Resulting hexagon

Resulting hexagon

Create new group with 0.5 dia. circle

Create new group with 0.5 dia. circle

Add 25 mm diameter holes at 0.45 m from the centre with 30 degree increment

Add 25 mm diameter holes at 0.45 m from the centre with 30 degree increment

Resulting group and section properties

Resulting group and section properties

Add 4 equal angles to an I section; offset and rotated to I section internal corners

Add 4 equal angles to an I section; offset and rotated to I section internal corners

Resulting group and section properties

Resulting group and section properties

This entry was posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA and tagged , , , . Bookmark the permalink.

8 Responses to Section properties for groups of defined shapes

  1. That’s a hug daily dosis I think. Still some good tips and trics.

    Like

  2. metroxx says:

    Hello,
    Is it possible to add find area of section above neutral axis and below?
    With regards

    Like

    • metroxx says:

      Mainly question: Is it possible to add calculation of First moment of area above neutral axis and below. It is used for example in EC2 calculation of prestressed section to shear resistance without needed reinforcement.

      Like

      • dougaj4 says:

        On the Coords_Shape sheet, enter the coordinates for the section above the neutral axis, and click the “Recalc Section Properties” button.

        This will give you the area of the shape (Area), and the distance from the neutral axis to the centroid (Yc, assuming you entered the NA on the X axis).

        The first moment of area is then Area*Yc

        Like

  3. Pingback: Daily Download 20: Section Properties | Newton Excel Bach, not (just) an Excel Blog

  4. Pingback: Section Properties Update | Newton Excel Bach, not (just) an Excel Blog

  5. Great spreadsheet!

    Big fan of your blog! I am in the processing of building something similar in MATLAB, however have used a sightly different approach where I have defined a boundary and used an open source meshing code to create a triangular mesh. I’ve got the flexural properties down, but I am trying to think about how I would approach calculating torsional properties (shear centre, J, Iw) for a set of triangles. Do you have any advice or resources that might guide me in the right direction?

    Cheers,

    Robbie

    Like

    • dougaj4 says:

      Not really, other than that torsion is difficult. The finite element program I use does torsion by creating a mesh and doing a stress analysis on that. If you are working from a triangular mesh I think that’s the only approach that is going to work, since the connectivity of the mesh has a big effect on the torsional stiffness of the section.

      If you do find a simpler way, I’d be really interested to hear of it.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s