Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- The history of the theory of beam bending - Part 1
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
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