Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Continuous Beams With Spring Supports by Macaulay’s Method
- Section Properties of Defined Shapes - Spreadsheet
- Fitting high order polynomials
- Drawing in Excel 7 - Creating drawings from coordinates
- Intersections, interpolations, and rotations
- Daily Download 3: ULS design of reinforced concrete sections
Recent Comments
Tag Archives: SciPy
3DFrame-py; non-linear with end releases
The non-linear analysis routines in 3DFrame-py have now been updated to work with beams with end-releases at one or both ends. Updated files are at: 3DFrame-py.zip See the previous two posts for details of other software required for installation. To … Continue reading
Installing 3DFrame-py
Updated 1st Feb 2025. As mentioned in the previous post, the installation process for the 3DFrame-py spreadsheet has changed with the new version. Also there have been some significant changes to the code to fix installation problems. Updated files are … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 3DFrame-py, Excel, Frame Analysis, Geometric non-linearity, Installing Python packages, Material non-linearity, non-linear analysis, Numba, Numpy, PyPardiso, Python, PyXLL, SciPy
4 Comments
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
Scipy-statistics update
Links to the Scipy statistics functions were last presented here. The functions have since had extensive updates: The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, Help function, Pandas, Python, PyXLL, SciPy, Scipy.Stats, statistics, UDF
Leave a comment
py_Numpy update
The py_Numpy spreadsheet, and the associated Python module have been updated. The new files are included in: py_SciPy.zip The download contains full open-source Python code and example spreadsheets for a wide range of Scipy functions, as well as the Numpy … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, get_docs function, Norm Function, Numpy, Python, Python help, PyXLL, py_Numpy, py_Scipy, SciPy
Leave a comment