Tag Archives: section properties

Dividing shapes into layers

For reasons that will become apparent in a later post, I need to rotate irregular polygons, defined by the coordinates of each corner, by a specified angle, and then split the resulting shape into horizontal trapezoidal layers. I have written … Continue reading

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , | 8 Comments

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 … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 13 Comments

Area from Vectors

The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates.  In this post the functions will be extended to find other section properties (such … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 5 Comments

Section Properties from Coordinates Without VBA

At the Eng-Tips forum there was a question asking for a calculation of area and centroid values from coordinates without the use of VBA.  In my opinion using VBA is much the easiest and most robust way to do it, … Continue reading

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA | Tagged , , , , , | 13 Comments

Section Properties from Layers

An alternative to finding the section properties of irregular polygons from the coordinates of the corners is to divide the shape into rectangular or trapezoidal layers.  The properties of the shape may then be found by simply summing the properties … Continue reading

Posted in Maths, Newton, Uncategorized | Tagged , , , , | 1 Comment