Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Tag Archives: SciPy
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
1 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
py_RC Elastic update 2
Following the previous post, I have added a further new function, and in the process discovered that the py_Estress function was not handling tensile axial loads correctly. That has now been fixed, and the updated spreadsheet and Python files can … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Concrete creep and shrinkage, Creep and shrinkage development, Excel, Python, PyXLL, Reinforced Concrete, SciPy, UDF
Leave a comment