### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Deflections and Moments in Rectangular Plates
- Taming Symbols in Excel
- Cubic Splines
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads

### Recent Comments

dougaj4 on Deflections and Moments in Rec… Kaushal on Deflections and Moments in Rec… Kurt Clark on Working with units in Excel… dougaj4 on Working with units in Excel… Kurt Clark on Working with units in Excel… Kurt Clark on Working with units in Excel… Kurt Clark on Working with units in Excel… dougaj4 on Numerical integration with on-… Tanh-Sinh Quadrature… on Numerical integration with on-… esfand on Open Source FEA Code Link… Craig on Numerical integration with on-… dougaj4 on Numerical integration with on-… Milos Cipovic on Numerical integration with on-… dougaj4 on Numerical integration with on-… Milos Cipovic on Numerical integration with on-…

# Category Archives: Beam Bending

## A Treatise on the Mathematical Theory of Elasticity

The book The Man Who Knew Infinity by Robert Kanigel describes the life of the Indian mathematician Srinivasa Ramanujan, and also his Cambridge mentor G.H. Hardy. It mentions that Hardy was influenced by reading “A Treatise on the Mathematical Theory … Continue reading

Posted in Beam Bending, Maths, Newton
Tagged AEH Love, B-OK Global, HAL Archives, Internet archives, Mathematical Theory of Elasticity
Leave a comment

## Using Excel with Python and ctypes

The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading

Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment

## Concrete Stress Blocks

Back in 2010 and 2011 posts here looked at a comparison of alternative stress blocks in the then new AS 3600, and a procedure for calculating parameters for a rectangular stress block exactly equivalent to the Eurocode 2 parabolic-rectangular stress … Continue reading

## Deflections and Moments in Rectangular Plates

Following a question here I have compared tabulated coefficients for deflections and bending moments in a rectangular plate with results of a Strand7 analysis using 8 noded plate/shell elements. The results are summarised below, and in a spreadsheet which also … Continue reading

Posted in Beam Bending, Curve fitting, Excel, Finite Element Analysis, Newton
Tagged Excel, FEA, Linest, Moody, Pilkey, plate bending, plate deflections, Plate stresses, Roark, Strand7, Timoshenko
2 Comments

## 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