Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- 3D Matplotlib Plots in Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Automatic download of csv files
- Cubic Splines
- Contour plots with Excel and Matplotlib
- The Conjugate Beam Method
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Tag Archives: link to dll
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
Installing dlls on 64 bit Windows
Several of the spreadsheets available here include routines linking to compiled code written in C#, C++ or Fortran, which require the installation and registration of dll files. The procedures for doing this are significantly different on machines with 64 bit … Continue reading
Posted in Computing - general, Excel, Link to dll, VBA
Tagged 64 bit Windows, dll, link to dll, VBA
10 Comments