### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- The angle between two vectors, Python version
- More Python Traps
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Combining arrays

### Recent Comments

More Python Traps |… on The meaning of = in Pytho… More Python Traps |… on Python Traps Using LINEST for non… on LinEstGap with non-linear… dougaj4 on Using LinEst() on data with… LinEstGap with non-l… on Fitting high order polyno… LinEstGap with non-l… on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Charlene Van Wyngaar… on Using LinEst() on data with… dougaj4 on DigitGraph Spreadsheet and Web… dbwriting on DigitGraph Spreadsheet and Web… dougaj4 on Biaxial bending update dougaj4 on DigitGraph Spreadsheet and Web… Sergiu on Biaxial bending update Paul Halsema on DigitGraph Spreadsheet and Web… Patricio Galvan on DigitGraph Spreadsheet and Web…

# Tag Archives: PyXLL

## More Python Traps

I recently posted on some Python Traps, focussing on code where changes in the values of sub-routine arguments were not reflected in the calling routines. The reverse can also be a problem: if an array, a, is passed to a … Continue reading

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Numpy, Passing variables, Python, python traps, PyXLL, UDF
Leave a comment

## Python Traps

When converting existing VBA code to Python there are a number of obvious changes to the syntax that need to be made for the code to run at all, but there are also a number of not so obvious traps … Continue reading

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, for loop counters |, Numpy, Passing variables, Python, python traps, PyXLL, UDF, VBA
1 Comment

## More powers of 3

Following the discovery of a question to which the answer is 42, the same team has now reported a sum of three cubes equal to 3. As before, the result can be checked from Excel, linking to mpmath, via pyxll. … Continue reading

Posted in Computing - general, Excel, Link to Python, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL, sum of 3 cubes
Leave a comment

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