### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Downloads by category
- Drawing in Excel 7 - Creating drawings from coordinates
- The angle between two vectors, Python version
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Section Properties with MeshPY, including torsion and warping
- Fine as a Bee's wing
- Daily Download 8: Drawing in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

### Recent Comments

Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… Larry on Scarborough Fair g2-9ed9acc685824c666… on Scarborough Fair Daniel Crotzer on About Newton Excel Bach More SciPy Solvers |… on xlwSciPy update for Python… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Paris Altidis on Numerical Integration; Tanh-Si… Erik Wynn on Cubic Splines dougaj4 on Cubic Splines Erik Wynn on Cubic Splines

# Tag Archives: section properties

## Using Section Properties- Group

Following a recent comment I have updated the documentation for finding the section properties of groups of shapes in the Section-Properties-Group spreadsheet. The revised file can be downloaded from: Section Properties07-Group.zip The screenshots below illustrate use of the Group function to … Continue reading

## Section Properties with MeshPY, including torsion and warping

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
7 Comments

## Section Properties – Lunes and Groups

Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon). I have also added a “Re-draw Shape” button because … Continue reading

Posted in Drawing, Excel, Maths, Newton, VBA
Tagged Excel, group properties, Lune, section properties, VBA
2 Comments

## Section Properties Update

The Section Properties spreadsheet provides formulas for the section properties of 35 different defined shapes, calculation of section properties from coordinates, and interactive calculation and plotting of any chosen shape with defined dimensions: The latest version added the function to … Continue reading

Posted in Excel, Maths, Newton, VBA
Tagged Excel, section properties, Section properties of grouped shapes, VBA
2 Comments

## 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 divide shape into layers, Excel, rotate coordinates, section properties, UDF, VBA
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 Excel, section properties, section properties of multiple shapes, VBA
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 Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments