Recent Comments
Author Archives: dougaj4
Section Properties of Defined Shapes – Spreadsheet
Download section properties spreadsheet from: 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:
Posted in Excel, Maths, UDFs
Tagged Section Properties; Area; First Moment of Area; Second
29 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 Area, first moment of area, layers, second moment of area, section properties
1 Comment
Section Properties UDF and UDF charting
The technique for calculating section properties from coordinates is conveniently coded into a UDF: Function Area(xy_range As Variant) As Double Dim XYcells As Variant Dim N As Long, NumX As Long Dim XD As Double, YSum As Double XYcells = … Continue reading
Posted in Arrays, Charts, Excel, UDFs
Tagged Section Properties; Area; First Moment of Area; Second
6 Comments
Section Properties from Coordinates
The area of irregular closed polygons defined by coordinates may be conveniently calculated by summing the areas of adjacent trapeziums, as shown below. The area of each trapezium is calculated from the X axis. Note that with the apex coordinates … Continue reading
Posted in Maths, Newton
Tagged Area, coordinates, first moment of area, polygon, second moment of area
2 Comments
Array resources
The getarray function from the first post in this series, plus functions to transpose, count the number of dimensions, and return other information about arrays, ranges or values: http://www.interactiveds.com.au/software/getarray.zip Chip Pearson’s Functions for VBA Arrays (also have a look at … Continue reading
Posted in Uncategorized
3 Comments
