Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
Recent Comments
Author Archives: dougaj4
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
2 Comments
EngineeringPaper.xyz
EngineeringPaper.xyz is a web app for engineering applications with free open-source code: EngineeringPaper.xyz is a web app for engineering calculations that handles unit conversion/checking automatically and also supports plotting, solving systems of equations, and documenting your calculations (see the official blog for … Continue reading
Posted in Computing - general, Newton
Tagged EngineeringPaper.xyz, MathCad alternative
Leave a comment
Pete Brown
Peter Ronald Brown (25 December 1940 – 19 May 2023) was an English performance poet, lyricist, and singer best known for his collaborations with Cream and Jack Bruce. https://en.m.wikipedia.org/wiki/Pete_Brown I spent my last year of high school in England as a boarder, and the “upper … Continue reading
Scipy linear algebra functions in Excel
The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Liear algebra functions, Link to Python, PyPardiso, PyXLL, Scipy Linalg, UDFs
2 Comments
LU Decomposition with Python and Scipy
This post was prompted by a question at the Eng-Tips forum: LU Decomposition which asked why Mathcad was generating LU matrices different to those calculated from the basic theory. The short answer was that there is more than one way … Continue reading
Posted in Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, linear algebra, LUsolve, Python, PyXLL, SciPy
2 Comments