### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

### Recent Comments

Peak Warming Man on Australian Greenhouse Gas… AS 3600 and RC Desig… on New AS 3600 and RC Design Func… dougaj4 on Brent’s Method and a daf… Craig on Brent’s Method and a daf… Craig on Brent’s Method and a daf… dougaj4 on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… metroxx on Using Section Properties-… dougaj4 on Using Section Properties-… More iterative solve… on Iterative solvers and arr… metroxx on Using Section Properties-… Craig on Arc-spline update dougaj4 on Arc-spline update Craig on Arc-spline update

# Category Archives: Arrays

## More iterative solvers

Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem. The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment

## Iterative solvers and arrays

A recent thread at Eng-Tips was looking for a solution to the problem described below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading

## Using VBA Evaluate as an Array Function

I recently discovered from a thread at Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function. As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged array functions, Evaluate, Excel, UDFs, VBA
2 Comments

## VBA vs Power Query vs Python

A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits. This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment

## Passing variable argument lists from Excel to Python via xlwings

When calling a Python function it is sometimes necessary to pass a variable number of arguments. Examples from the xlw_Scipy spreadsheet include: Curve fitting functions, for which the functions to be fitted may have any number of arguments. The Scipy … Continue reading

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA, xlwings
Tagged dictionaries, Excel, ParamArray, Passing arrays, Passing named arguments, Python, UDFs, VBA, xlwings
2 Comments

## Returning Arrays From VBA and Python

Most of the user defined functions (UDFs) presented on this blog return a multi-cell array, that must be entered by selecting the output range then pressing Ctrl-shift-enter to display all the results. This process has several inconveniencies: You need to know … Continue reading

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged dynamic arrays, Excel, Python, resizing array functions, UDFs, using array functions, VBA, xlwings
Leave a comment

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