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

Resulting hexagon

Create new group with 0.5 dia. circle

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

Resulting group and section properties

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

Resulting group and section properties

### Like this:

Like Loading...

*Related*

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

LikeLike

Hello,

Is it possible to add find area of section above neutral axis and below?

With regards

LikeLike

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.

LikeLike

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

LikeLike

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

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

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

LikeLike

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.

LikeLike