Recent Comments
Category Archives: Arrays
IP2 Update, ByRef and ByVal
A recent comment pointed out that the IPPlaneLine function (intersection of a 3D line with a plane) in the IP2 spreadsheet was giving incorrect results. This has now been fixed, and the corrected spreadsheet can be downloaded from IP2.zip. The problem turned out … Continue reading
More on writing arrays to the worksheet
Writing a large VBA array to the worksheet in a single operation, rather than cell by cell, can result in a huge improvement of the speed of many macros. The basic technique was described here. I recently wanted to modify this … Continue reading
Area from Vectors
The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates. In this post the functions will be extended to find other section properties (such … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments
Dots and Crosses
The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors. Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged cross product, dot product, Excel, UDF, VBA, vector area, vectors
11 Comments
Using LatPilePY
LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles. It was presented in this post: LatPilePY. In response to an e-mail request, this post will give step by step instructions for … Continue reading
Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Array Function, COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 