Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Time in hours and minutes between two dates
- Rabbits, Foxes, and Lorenz Attractors
- The angle between two vectors, Python version
- Downloads
- Installing Adobe Reader non-DC version.
Recent Comments
Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec… Kaushal on Deflections and Moments in Rec… Kurt Clark on Working with units in Excel…
Tag Archives: section properties
Section Properties for Rotated Shapes
I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading
Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of rotated shapes, UDF, VBA
Leave a comment
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