### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Biaxial bending update
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- 3D Frames, axes and stiffness matrices
- Solving Quadratic, Cubic, Quartic and higher order equations; examples

### Recent Comments

Angelo on Biaxial bending update dougaj4 on Excel to Alglib via xlwin… dougaj4 on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin… Bill Harvey on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin… dougaj4 on The answer to Life the Univers… Paul Halsema on The answer to Life the Univers… More powers of 3 | N… on The answer to Life the Univers… Onyia Leonard on Daily Download 4: Continuous B… The age of snakeoil… on They all laughed at Christophe… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi…

# Category Archives: Geotechnical Engineering

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

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

## Making non-linear FEA with Excel go (much) faster

The spreadsheet presented in the previous post takes about 90 seconds to complete (with the iteration limit set at 500) on my computer, and is much slower on some other systems. The VBA code that does all the hard work is based … Continue reading

## Daily Download 7: Lateraly loaded pile analysis

Today’s downloads (the last in the Engineering category) are related to the analysis of piles subject to lateral loads: LatPile – Analysis of Lateral Loads on Piles describes the principles of the analysis. Download file: http://interactiveds.com.au/software/LatPile.zip P-Y Curve function describes function to … Continue reading

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Beam on elastic foundations, COM624, Excel, laterally loaded piles, PY curves, UDF, VBA
3 Comments