Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Contour plots with Excel and Matplotlib
- Stereograms
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving non-linear equations with two or more unknowns – 5
- About Newton Excel Bach
- Installing AlgLib with Excel VBA
Recent Comments
Category Archives: Link to dll
Download Problems
Update 24th March 2024: The certificate problem has now been fixed, and most download links should now work without a problem. Note that any file with VBA code (which is almost all of them) will have the VBA blocked with … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, Python Pandas, PyXLL, UDFs, VBA
Tagged Clear downloads, Download link
1 Comment
Speed of Scipy Linear Algebra Solvers
The files presented in the recent post on Scipy Linear Algebra Solvers include a wide range of different solver types, with in some cases numerous sub-options, allowing the functions to be called from Excel, and greatly extending and speeding up … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, linear algebra, PyPardiso, Python, PyXLL, Solver times
1 Comment
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Using Excel with Python and ctypes
The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading
Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment
64 bit Excel and the Strand7 API
Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results. A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7
Tagged 64 bit Excel, Strand7 API
Leave a comment