### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- The Conjugate Beam Method
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- For Bert Jansch - Around the World in 80 Plays
- Solving cubic and quartic equations with Excel

### Recent Comments

Compiled AlgLib Matr… on Compiled AlgLib Matrix Functio… guddu on Automatic download of csv… dougaj4 on Return of Excel – Evalua… phix345 on Return of Excel – Evalua… New sort functions a… on A Sort Function smartcarrion on 64 bit Excel and PtrSafe dougaj4 on 3DFrame – 3D Frame analy… Mark Firkins on 3DFrame – 3D Frame analy… Lennox Bridge | Newt… on Trinity Bridge and Bridge of t… Trunc Function In Ex… on More Numpy with Excel and… dougaj4 on Using LinEst() on data with… Charlene on Using LinEst() on data with… dougaj4 on Jaqui Mcshee raduga fenerbahce on Jaqui Mcshee John on Installing Adobe Reader non-DC…

# Tag Archives: plane strain

## Retaining wall analysis – FEA and hand calculations

I have used the PlateMC spreadsheet described in the previous post to compare the results of a finite element analysis of a retaining wall with a similar analysis using the commercial package Strand7, and a simple hand calculation using Coulomb … Continue reading

Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged Coulomb, ctypes, Excel, FEA, Fortran, Ka, link to dll, plane strain, Programming the Finite Element Method, Python, soil-structure interaction, staged analysis, VBA, xlwings
Leave a comment

## Plane Strain FEA – Non linear staged analysis

Continuing the recent series of posts featuring Fortran based FEA routines, the spreadsheet from the previous post has been revised: The spreadsheet allows for a staged analysis, with additional elements placed in layers for any number of construction stages. Temporary loads … Continue reading

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, UDFs, VBA
Tagged ctypes, Excel, FEA, Fortran, link to dll, plane strain, Programming the Finite Element Method, Python, soil-structure interaction, staged analysis, VBA, xlwings
1 Comment

## FEA slope analysis; effect of mesh size

The last version of the FEA slope analysis spreadsheet (presented here) allows the slope shape and element density to be easily varied. This post looks at the effect of varying the density from very coarse to fine, with constant soil … Continue reading

## Linking Excel to Fortran with ctypes; update

In the previous post arrays were created in Python and passed to a Fortran dll as ctype pointers. The data written to these arrays in the Fortran routines was then converted back to Python arrays with statements such as: nodedisp = npc.as_array(nodedisp). … Continue reading

## Linking Excel to Fortran, via xlwings, Python and ctypes

Continuing the recent series on using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)), this post looks at linking Excel to Fortran code compiled as … Continue reading

## Compiling Fortran code for Windows

This post is a continuation of a recent series, using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)). The compiled file provided in the download should … Continue reading

Posted in Excel, Finite Element Analysis, Fortran, Newton, VBA
Tagged Excel, FEA, Fortran, Mohr-Coulomb, plane strain, Programming the Finite Element Method, soil-structure interaction, VBA
2 Comments

## Running exe files from Excel

Following on from the previous post (running a compiled Fortran finite element analysis program from Excel), this post looks at the details of calling any command line routine from Excel, through VBA. The important points that need to be addressed are: Writing … Continue reading