Recent Comments
Category Archives: Arrays
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
Using LinEst() on data with gaps
A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps. There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading
Using Array Formulas
Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading
Alternative IP and Rotations
In response to the 3D Intersections and PView Function posts Lori Miller has sent me two very elegant alternative ways of achieving similar results. The first is an on-spreadsheet solution to the intersection of two lines, using the LinEst function: Note … Continue reading
Posted in Arrays, Charts, Charts, Coordinate Geometry, Excel
Tagged defined names, Hypecube, IP, perspective projection
Leave a comment
PView Function
As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading
Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA
Tagged Excel, perspective projection, PView, rotation matrix, UDF, VBA, XY chart
3 Comments
Newton Excel Bach, not (just) an Excel Blog 