Tag Archives: Excel

Numerical Integration With Tanh-Sinh Quadrature v 6.0

Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 6.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: Note that the speed improvement is … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | Leave a comment

Cleaning Data – Sort functions and shortcuts

Back in 2020 I posted here on New sort functions and sorting to groups, looking at using the sort functions to clean data. Revisiting that post I found that the link to the sample spreadsheet was broken, and that is now … Continue reading →

Posted in Computing - general, Excel | Tagged , , , | Leave a comment

Lists and Arrays in Excel

I recently learned from MyOnlineTraingHub that Microsoft recently released a new feature allowing lists, arrays, and nested arrays to be stored in single cells. This feature is currently only available on the Beta Channel for Microsoft 365 Insiders, but it … Continue reading →

Posted in Arrays, Excel | Tagged , , | Leave a comment

VBA polynomial functions update

Following several comments at an old post I have made updates to the Polynomial spreadsheet. The new files can be downloaded from: Polynomial.zip The changes are: SolvePoly was amended to accept numbers or signed cell addresses in the input. QuarticR, … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Passing 3D arrays to Excel with Python and pyxll

The previous post looked at options for displaying 1D or 2D arrays in Excel. This post will look at passing 3D arrays from Python to Excel as a cache object, using pyxll, and how to extract selected data from the … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , | 1 Comment