Recent Comments
Category Archives: Excel
New GROUPBY and PIVOTBY functions
Microsoft recently announced two new functions that provide similar functionality to pivot tables, but will update automatically for any change in the referenced data. These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel. … Continue reading
Posted in Computing - general, Excel
Tagged Excel, GROUPBY, myOnlineTraininghub, New functions, pivot tables, PIVOTBY, Slicers
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.
1 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
1 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
