## Section Properties of Defined Shapes – Spreadsheet

http://www.interactiveds.com.au/software/Section%20Properties03.zip

http://www.interactiveds.com.au/software/Section%20Properties07.zip

• Section properties for 35 defined shapes
• Section properties from coordinates
• Section properties UDF

Screen shots:

This entry was posted in Excel, Maths, UDFs and tagged . Bookmark the permalink.

### 29 Responses to Section Properties of Defined Shapes – Spreadsheet

1. metroxx says:

Hello,
There is a problem if you use for numbers (,) , not point (.)

Like

• dougaj4 says:

Hi metroxx

This seems to be a problem with the evaluate function. I couldn’t find any solution from a quick search. The only way around this I can think of (other than switching to using the decimal point) is to add some code to substitute “.” for “,” before calling the Evaluate function.

Like

• metroxx says:

Thank you,
Can you give example how function will looks?

Like

2. metroxx says:

It is for function “eval”.

Like

3. metroxx says:

Hello,
I cant understand where is the problem.
I want to calculate section properties for circle with radius 1000, but it’s give theta=-38,88
http://dl.dropbox.com/u/13038878/Section%20Properties07.xlsb

Like

• dougaj4 says:

Hi metroxx – it seems that for a radius bigger than about 300 the calculation of Ixyc (which should be zero for a symmetrical shape) suffers from numerical inaccuracies, and this results in a non-zero Ixyc and Theta. Changing the units to make the radius smaller seems to fix the problem.

Did you get the e-mail I sent with a fix for the , decimal point, and did it fix the problem?

Like

• metroxx says:

Yes, it is, if higher than 300, than mistake. It is not fixable ?
About email, sorry, I was missed your email. I will take a look and answer you to email. Thank you!

Like

4. dougaj4 says:

I’ll write it up in the next few days.

Like

• metroxx says:

It’s looks ok right now. About Eval2-comma spreadsheet. When copy modules to the Section Properties then show error (Problem with GetArray function in module mCoords).

Like

• dougaj4 says:

I have increased the relative tolerance value from 1E-14 to 1E-12. That should be big enough to avoid all these incorrect theta values, but still accurate enough for all practical purposes.

I’ll have a look at the eval2-comma function now.

Like

5. dougaj4 says:

metroxx – the Eval function in the Section Properties spreadsheet is a modified version of the original. It allows an extra parameter range, and it converts angles from radians to degrees.
I have modified it to accept a comma decimal separator here:
http://www.interactiveds.com.au/software/Section%20Properties07-Evalc.zip

It seems to work OK with the decimal set to either , or . but I would be grateful if you could give it a thorough check and let me know if you find any problems.

Like

• metroxx says:

Right now everything is perfect. Thank you.

P.S.
I think will good if will be possible to calculate also:
1) Section perimeter (P = sum( sqrt[(yi-yj)²+(xi-xj)²])) – but by this simple way impossible not to take into account interior perimeter of section (For example if it is closed section, Hollow section)
2)Moment resistance (Elastic, Plastic)
3)Torsional moment of inertia (It)
4) Wrapping constant (Iw)
6) J – torsional stiffness constant calculated by coordinates. For example you define coordinates and section type (T, L, O, closed etc …)

Like

• dougaj4 says:

The section modulus (2) and radius of gyration (5) would be straightforward, and the perimeter would be a bit more tricky, but should not be too difficult, so I’ll look at incorporating those. The rotational moment of inertia (3) should also be straightforward. The torsional stiffness (6) and warping constant (4) are more difficult because they depend on the configuration of the section, and that would be difficult to detremine from coordinates, even with a section type. I will have a look at the calculations on the “defined shapes” sheet though and add to those.

Like

6. metroxx says:

Is it possible to calculate this profile? (Two profiles near each other)
http://dl.dropbox.com/u/13038878/Section%20Properties07-Evalc-my.xlsb

Like

• dougaj4 says:

Just add a “web” of zero thickness between the two parts, along the axis of symmetry.
If you select section type 26 (I section 2) on the “Defshapes” sheet you can define the flange sizes, and set the web thickness to zero, then copy that shape to the “coords” sheet.

Like

• metroxx says:

But If we will talk about more difficult section?

Like

7. dougaj4 says:

metroxx – as for the other one, you could find the properties for the two sections acting as a single section by connecting them along a horizontal line through the centroid.

I should emphasise that this is only appropriate if the two sections are connected so that they act as a rigid beam; i.e. a plane section through both members remains plane after bending. If they are not connected they will act as two separate beams (and the section properties for the individual members should be just added together). If there is a partial connection (just a plate connecting the separate beams at the ends for instance) the true section properties will be something between the sum of the two sections, and the value for the two sections acting as one.

Like

• metroxx says:

Yes, I understand.
But I was think, that will be good to use it for example to find properties for welding (To calculate detailed welding connection). As you know, for example by Eurocode you can check welding by simple and by detailed design. If you want to take into account moment action to the weld you need to know welding contour properties and this will not be connected to each other(Moment of inertia etc.)

Like

8. dm600 cccam says:

I do trust all the ideas you’ve offered to your post. They’re very convincing and
can definitely work. Still, the posts are too brief for novices.
May just you please prolong them a little from next time?
Thanks for the post.

Like

• dougaj4 says:

Often time available is a problem, but do feel free to ask further specific questions here, either on the use of the spreadsheets, or the background theory.

Like

9. Robbie says:

Hi Doug,
First thanks for the spreadsheet. I seems like it will be a very helpfull tool for me. I tried to use this to compute section properties like I, Sx, J and so on. I have a situation where I need to compute a section properties of a shape which consist of bunch of plates and angles. I defined the section but was not able to get reasonable output because some members are not connected technically. I have pasted my input of the co-ordinates below. So, please guide me how to effectively model this section. Element on right and left are not technically connected. I tried to connect them with a really thin plate but the output doesnot seem reasonable.

X Y
-7.8125 0
-7.8125 -10
-8.3125 -10
-8.3125 -10.25
-12.3125 -10.25
-12.3125 -9.875
-8.6875 -9.875
-8.6875 -6.25
-8.3125 -6.25
-8.3125 6.25
-8.6875 6.25
-8.6875 9.875
-12.3125 9.875
-12.3125 10.25
-8.3125 10.25
-8.3125 10
-7.8125 10
-7.8125 0
7.8125 0
7.8125 -10
8.3125 -10
8.3125 -10.25
12.3125 -10.25
12.3125 -9.875
8.6875 -9.875
8.6875 -6.25
8.3125 -6.25
8.3125 6.25
8.6875 6.25
8.6875 9.875
12.3125 9.875
12.3125 10.25
8.3125 10.25
8.3125 10
7.8125 10
7.8125 0.00005
-7.8125 0.00005

Robbie

Like

• dougaj4 says:

Robbie – I’ll have a look tomorrow. If you could send a copy of the spreadsheet with your data to dougaj4 at gmail, that would be helpful.

Like

• dougaj4 says:

You have defined the right hand section with coordinates listed anti-clockwise, which generates negative values, so the combined values are close to zero. If you list all the points in a clockwise direction it will give the correct results.

Alternatively for area and properties about the X axis you could just double the results for one shape.

Like

10. Li Min says:

Cheers, Li

Like

• dougaj4 says:

Just click on the link. It includes channel sections.

Like

This site uses Akismet to reduce spam. Learn how your comment data is processed.