Recent Comments
Category Archives: Arrays
Working with dynamic arrays in Excel
Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then pressing Ctrl-Shift-Enter (CSE). This can be inconvenient (or at least untidy) when the size of the output array varies. … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Charles Williams, dynamic arrays, Excel, Fast Excel, VBA, Wndows Insider
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
More updates to ArcSpline and IP2
I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below. The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged arcspline, Array function entry, Automatic re-size array functions, Excel, IP2.xlsb, Line intersections, UDFs, VBA
Leave a comment
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
Posted in Arrays, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, Excel, Python, SciPy, UDFs, VBA, xlwings, xlwSciPy3
2 Comments
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
