### 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
- Cubic Splines
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

### Recent Comments

More Python rotation… on Fitting 3D circles to scattere… Ana Sofía on Indexing NumPy arrays with flo… Soren Hauch on Update to Glob_to_loc3 and Loc… dougaj4 on RCInteract and RC Design Funct… Lorenzo Castellani on RCInteract and RC Design Funct… dougaj4 on Update to Glob_to_loc3 and Loc… Fitting 3D circles t… on Update to Glob_to_loc3 and Loc… Soren Hauch on Update to Glob_to_loc3 and Loc… dougaj4 on Cubic splines with jagged… Bob Jordan on Cubic splines with jagged… dougaj4 on Update to Glob_to_loc3 and Loc… Cubic splines with j… on xlwSciPy 1.09 – update f… Cubic splines with j… on Update to AL-Spline-Matrix Cubic splines with j… on Daily Download 22: Splines and… Soren Hauch on Update to Glob_to_loc3 and Loc…

# Tag Archives: Numpy

## More Python rotation functions

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation. I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, fit 3D circle, Numpy, Python, RPView, UDF, VBA, xlwings, xl_RPView
Leave a comment

## Fitting 3D circles to scattered points

Following a comment at update-to-glob_to_loc3-and-loc_to_glob3-functions, I have modified the Python code at the linked site, so it can be run from Excel, via xlwings. The spreadsheet described below, and the associated Python code, can be download from: 3DCirc.zip The original … Continue reading

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged 3DCirc, Excel, fit 3D circle, Numpy, Python, UDF, VBA, xlwings
1 Comment

## Using Alglib least-squares solvers

Following the last post on using the Python version of Alglib from Excel, via xlwings, this post looks in more detail at alternatives for fitting a non-linear function to a set of data, using the Levenberg-Marquardt method. The spreadsheet with … Continue reading

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, Excel, Levenberg Marquardt, lsfit, minlm, Numpy, Python, SciPy, UDF, VBA, xlwings
Leave a comment

## Evaluating text and calling Python functions from Excel with xlwings

The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions. I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, call Python functions, evaluate text strings, Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment

## Indexing NumPy arrays with floats …

… now you can’t. I recently updated to the latest version of NumPy (1.12.1), and today I discovered that some of my spreadsheets using NumPy arrays (via xlwings) were returning errors like: IndexError: only integers, slices (`:`), ellipsis (`…`), numpy.newaxis … Continue reading

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA
Tagged Float index, IndexError, Numpy, Python, VBA, xlwings
1 Comment

## The meaning of = in Python

In VBA, if you have an array named a and a variant named b, then the statement “b = a” creates a new array b with the same size and values as a. If the values of either a or b are subsequently changed, the values of the … Continue reading

## Transferring and converting strings in Excel and Python

The load table for the 3D Frame spreadsheet has a column listing the global axis for each load as text (X, Y, or Z). In the VBA version the table is converted to a variant array, and the axes are handled … Continue reading

Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA
Tagged Excel, map, Numpy, ord, Python, String functions, upper, VBA, xlwings
Leave a comment