### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Fitting high order polynomials
- Combining arrays
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Time in hours and minutes between two dates
- Retrieving unique values from a range or array ...

### Recent Comments

Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks Concrete Stress Bloc… on Stress blocks in AS 3600

# Tag Archives: PyXLL

## The answer to Life the Universe and Everything …

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL
5 Comments

## 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

## Transfer of arrays to/from Python with Pyxll – Part 2; Speed

Following the previous post, which looked at the way different data types worked when transferring data between Excel and Python, this post looks at ways t0 get the best performance. As a benchmark I have used a short routine that: … Continue reading

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, VBA
Tagged Excel, improving performance, Numba, Python, PyXLL, transferring data, VBA
1 Comment