Recent Comments
Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… 
dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… 
Larry on Scarborough Fair 
g2-9ed9acc685824c666… on Scarborough Fair 
Daniel Crotzer on About Newton Excel Bach More SciPy Solvers |… on xlwSciPy update for Python… 
Graeme Dennes on Numerical Integration; Tanh-Si… 
Paul on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… 
Paris Altidis on Numerical Integration; Tanh-Si… 
Erik Wynn on Cubic Splines dougaj4 on Cubic Splines Erik Wynn on Cubic Splines
Author Archives: dougaj4
mpmath for Excel
mpmath has been mentioned in passing here before, but not in any detail. The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading
Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings
Tagged evaluate pi, Excel, high precision maths, mpmath, Python, PyXLL, UDFs, VBA, xlwings
Leave a comment
Transferring large arrays with Pyxll
Pyxll is a commercial Excel add-in linking Excel and Python. The latest version offers greatly improved performance in transferring data between Excel and Python as Numpy arrays, amongst many other new features and improvements. To check what this means in practice, … Continue reading
Posted in Arrays, Excel, Frame Analysis, Link to Python, PyXLL, UDFs, VBA
Tagged data transfer time, Excel, large arrays, Python, PyXLL, UDFs, VBA
Leave a comment
Scarborough Fair
Scarborough Fair is a very old song, according to Wikipedia dating back at least to 1670, and probably much earlier. Here are three versions from the mid-sixties. The first from Martin Carthy was released in 1965, on his first album: The … Continue reading
Posted in Bach
Tagged Marianne Faithful, Martin Carthy, Scarborough Fair, Simon and Garfunkel
2 Comments
More updates to ArcSpline and IP2
I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below. The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged arcspline, Array function entry, Automatic re-size array functions, Excel, IP2.xlsb, Line intersections, UDFs, VBA
Leave a comment
More SciPy Solvers
The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function. The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged bolt group, Excel, Python, SciPy, solvers, UDFs, VBA, xlwings
Leave a comment
Solid Air – Norma Waterson
I don’t know how I missed this, but I just discovered yesterday: More about the album: The Very Thought of You On her second solo album the Grande Dame of British folk is presenting us with a surprising, inspired selection … Continue reading
Posted in Bach
Tagged Danny Thompson, John Martyn, Martin Carthy, Norma Waterson, Richard Thompson
Leave a comment
Python Problems
I have recently returned to using Pyxll to link Excel to Python (of which more later), which required the installation of a 32 bit version of Python 3.7. First trials after installation returned the message: “AttributeError: ‘module’ object has no … Continue reading
Posted in Computing - general, Link to Python, NumPy and SciPy
Tagged CLSIDToPackageMap, installation, Python, py_gen
Leave a comment
