Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Installing AlgLib with Excel VBA
- About Newton Excel Bach
- Solving non-linear equations with two or more unknowns – 5
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- Using Array Functions and UDFs
- Daily Download 4: Continuous Beam Analysis
- The VBA Decimal data type
Recent Comments
Tag Archives: SciPy
Solving the 4 point lift problem …
… with Excel, Python and pyxll. The problem involves the lifting of a precast concrete panel (or any other long thin object) with lifting points at four sections along the length of the panel, and with the load connected to … Continue reading
Posted in Concrete, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 4 point lifting, Excel, Non-linear solvers, precast lifting, Python, PyXLL, SciPy, UDFs
Leave a comment
Scipy Functions with Excel and pyxll 9 – Special, distance, space and constants functions and FFT
In the final post in this series I will look at linking Excel to the Scipy special, distance, space and constants functions and also the Fast-Fourier Transform (FFT) functions. The py_Special-Dist and py_FFT spreadsheet, with associated Python code in PythonSpaceFuncs3.py … Continue reading
Posted in AlgLib, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged CODATA constants, Distance functions, Excel, FFT, Help function, MatPlotlib, Python, PyXLL, SciPy, Scipy comstants, Scipy Constants, Space functions, Special functions, UDFs
Leave a comment
Scipy Functions with Excel and pyxll 8 – Statistics
This post looks at linking Excel to the Scipy and Pandas statistics functions using pyxll. 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 package (including … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, Help function, Numpy, Pandas, Python, PyXLL, SciPy, statistics, UDFs.
Leave a comment
Scipy Functions with Excel and pyxll 7 – Linear Algebra
This post looks at linking Excel to the Scipy linear algebra functions using pyxll, and also using the PyPardiso solver. Previous posts on this topic include: The pyLinAlgfuncs3 spreadsheet, with associated Python code in pyLinalgfuncs3.py and pyScipy3.py, are included in the … Continue reading
Posted in Arrays, 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 Functions with Excel and pyxll 6 – Integration
The py_Integrate spreadsheet, with associated Python code in pyScipy3.py, are included in the download file: py_SciPy.zip The spreadsheet and associated Python packages have had significant edits since the first post in this series, so please download the latest file. Details … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Integration, multiple integration, Numpy, Python, PyXLL, Quadrature, SciPy, Sympy, Tanh-Sinh Quadrature, UFFs
Leave a comment