Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 5: Frame Analysis
- Writing Arrays to the worksheet - VBA function
- Automating chart scale limits - update
- About Newton Excel Bach
- Downloads
Recent Comments
Monthly Archives: March 2026
2DFrame-py
… and 3DFrame-py update. I have added code to the 3DFrame-py module to allow simplified input for 2D frame analysis. The revised code and example spreadsheets can be downloaded from: 3DFrame-py.zip There are also miscellaneous minor revisions to the 3DFrame … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged 2D Frame analysis, compare to Strand7, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
Alternative iterative solvers
This post looks at alternative solutions to a problem posted on Quora: How can 2^x = 10x be solved? One of the alternatives requires a new function linking to Scipy that has been added to the pyScipy module, that can be downloaded … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Brent's method, Excel, Goal Seek, Iterative solvers, Lambert W function, PyXLL, SciPy, UDF, VBA
Leave a comment