### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Fitting high order polynomials
- Using LINEST for non-linear curve fitting
- Beam actions and deflections by Macaulay's Method
- Drawing in Excel 7 - Creating drawings from coordinates
- Cubic Splines

### Recent Comments

dougaj4 on Drawing in Excel – … J.D. on Drawing in Excel – … dougaj4 on The Largest Early World Map… Doug Glancy on The Largest Early World Map… Larry Schuster on How Reinforced Earth work… dougaj4 on ConBeamU 4.13 roshan_rai@hotmail.c… on ConBeamU 4.13 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03 andre on RC Design Functions 8_03 dougaj4 on RC Design Functions 8_03 David, Lim (Korea) on RC Design Functions 8_03

# Tag Archives: PyXLL

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

## Transfer of arrays to/from Python with Pyxll – Part1; Data Types

This post will look at options for transferring arrays between Excel and Python using Pyxll, including data types, and problems associated with transferring mixed data types. In the following post I will look at the relative performance of the various … Continue reading

Posted in Arrays, Excel, Link to Python, VBA
Tagged Data types, Excel, Python, PyXLL, VBA
2 Comments

## Global to Local for plates (and three node beams)

The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA
Tagged Excel, Glob_to_Loc3, IP2.xls, Loc_to_Glob3, Python, PyXLL, UDF, VBA
3 Comments

## The angle between two vectors, Python version

I posted a VBA function to return The angle between two vectors, in 2D or 3D last year, and have just discovered that Python and Numpy are lacking this function. Since all the suggested code I found in a quick search used: Cos θ … Continue reading

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy
Tagged angle between two vectors, Numpy, Python, PyXLL
10 Comments