### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

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

# Tag Archives: UDF

## More Numpy with Excel and xlwings

The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions. The spreadsheet and associated Python file can be downloaded from: xlNumpy.zip The Numpy functions require xlwings and Numpy to be installed, which are included in … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Anaconda, Excel, math functions, Numerical ranges, Numpy, Polynomial functions, Python, Trig functions, UDF, VBA, xlwings
1 Comment

## Sorting with Python and Numpy

Following the previous post, lets look at sorting functions in the Numpy library. The spreadsheet xlwNumpy links to a variety of Numpy functions, including the sorting functions described below. The spreadsheet and associated Python code can be downloaded from: xlNumpy.zip … Continue reading

## Sorting with VBA and Python

This subject was last covered in March 2014. I have now updated the Python code to work with xlwings, and the new version (including open source VBA and Python code) can be downloaded from: Sortfunc.zip. The previous version, linking to … Continue reading

## IP2_py Update for Python3

The spreadsheet IP2_py provides a large number of geometric functions, including intersection points of lines, circles and planes, interpolation, rotations, and converting between coordinate systems. Many of the functions are available in VBA and Python versions. The Python code has now … Continue reading

## Beam geometric non-linear effects

A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Euler buckling, Excel, Frame Analysis, Non-linear geometry, Second order effects, UDF, VBA
2 Comments

## xlwSciPy update for Python 3

The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel. The spreadsheet has now been updated for use with Python 3. The spreadsheet and … Continue reading

Posted in Coordinate Geometry, Differential Equations, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, UDFs, VBA, xlwings
Tagged Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
2 Comments

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