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
- Automatic download of csv files
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Using LinEst() on data with gaps
Recent Comments
Author Archives: dougaj4
3DFrame-py; with non-linear analysis
Exactly a year since the previous update I have revised the 3DFrame-py spreadsheet with the addition of non-linear analysis options. The new files can be downloaded from: 3DFrame-py.zip Details of file installation, and required software are at: 3DFrame-py Minor revisions … Continue reading
Scipy Linalg functions stopped working
I recently noticed that the iterative linear algebra solvers in my pyLinAlgfuncs3.xlsb spreadsheet had stopped working. It turned out that the optional tolerance argument had been renamed ‘rtol’. Changing all the occurrences of the name in the Python code fixed … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Iterative solvers, linear algebra, linear equations solver, LU solvers, Numpy, PyPardiso, Python, PyXLL, SciPy, sparse matrices, UDFs.
Leave a comment
Beam geometric non-linear effects – end loads
Following the previous post, I found some errors in the Python code: These problems have now been fixed, and updated code and a revised spreadsheet have been added to the download file at: py_GeomK.zip The screenshots below show results with … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged End loads, Frame Analysis, Non-linear geometry, Python, PyXLL, Second order effects, UDF
Leave a comment
Beam geometric non-linear effects – Python version
In 2018 I posted Beam geometric non-linear effects with a VBA based spreadsheet to calculate beam actions and deflections under combined transverse and axial load, allowing for geometric non-linear effects. I have now converted the code to Python, linking to Excel … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Frame Analysis, Non-linear geometry, Python, PyXLL, Second order effects, UDFs
1 Comment
Two traditional songs …
… with very different renditions. First from 1967, Martin Carthy and Dave Swarbrick join Julie Felix: Then a new version of Tam Lin from 2022, by Fiona Gillespie and Elliot Cole and performed by Makaris: For more om Makaris see … Continue reading
Posted in Bach
Tagged Dave Swarbrick, Elliot Cole, Fiona Gillespie, Julie Felix, MAKARIS, Martin Carthy, Tam Lin
Leave a comment