Daily Download 20: Section Properties

The download spreadsheets today provide functions to find section properties of shapes either defined by coordinates or selected from a list of shape types.  The section properties found are: area, first and second moments of area about the X and Y axes and about axes through the centroid (parallel to X and Y and principal axes), Ixyc and angle of the principal axes, position of the centroid, and in some cases the torsional constant.

The download files are:
Section properties function and in-cell charting: http://interactiveds.com.au/software/SecProps-array.zip

Section properties of defined shapes:

Section properties without VBA:

Section Properties from vectors:

Posts describing the functions in more detail are:

Section Properties from Coordinates
Section Properties UDF and UDF charting
Section Properties from Layers
Section Properties of Defined Shapes – Spreadsheet
Section Properties from Coordinates Without VBA
Area from Vectors
Section properties for groups of defined shapes

Section properties from coordianates and in-cell charting

Section properties without VBA

Section Properties from Vectors

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

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 )

Facebook photo

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

Connecting to %s

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