Recent Comments
Category Archives: Link to dll
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
Tanh-Sinh Quadrature via F2PY – Part 2
Lets look at some details of the coding. The original code (available here) includes routines “intdeini” to generate an array of points and weights of the quadrature formula, and “intde” to carry out the integration of any supplied function “f”. … Continue reading
Posted in Excel, Link to dll, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, Excel-Python, F2Py, numerical integration, Python, SciPy, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment
Problems with UCase and LCase in VBA
A recent comment reported a problem with the use of the UCase and LCase (upper and lower case) functions in VBA. The function was returning the error message “Compile error: Can’t find project or library”. I found the same problem … Continue reading
Posted in Excel, Link to dll, VBA
Tagged Excel, LCase, problems with UCase and LCase, UCase, VBA, VBA.LCase, VBA.UCase
6 Comments
Newton Excel Bach, not (just) an Excel Blog 