Recent Comments
dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… 
Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… dougaj4 on Another (very slow) way of com… 
Matt on Another (very slow) way of com… 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…
Category Archives: Excel
Multiple Integration with Scipy
Scipy has 3 functions for multiple numerical integration in the scipy.integrate module: dblquad: Compute a double integral. tplquad: Compute a triple integral’ nquad: Integration over multiple variables. I have written six functions to call these functions from Excel, via Pyxll: Each … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, multiple integration, Python, PyXLL, SciPy, UDFs
6 Comments
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
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
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
Numerical Integration; Tanh-Sinh Quadrature v. 4.4
Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading
Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
9 Comments
