Recent Comments
Tag Archives: Section Properties; Area; First Moment of Area; Second
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 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
Newton Excel Bach, not (just) an Excel Blog 