Author Archives: dougaj4

JavaScript UDFs in Excel

Posted on 09/05/2018 by dougaj4

Bleeping Computer report that Microsoft have announced JavaScript UDFs for Excel. See the link for more details. This feature is not yet available in standard Excel, but a preview version is available to those joining the Office Insiders Program.

Posted in Excel, Javascript, UDFs | Tagged , , , | 1 Comment

IP2_py Update for Python3

Posted on 28/04/2018 by dougaj4

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 →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , , | Leave a comment

Beam geometric non-linear effects

Posted on 21/04/2018 by dougaj4

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 , , , , , , | 5 Comments

Frame Analysis Resources

Posted on 17/04/2018 by dougaj4

I recently discovered: Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, and Ziemian. which is available for free download: Description The aims of the first edition of Matrix Structural Analysis were to place proper emphasis on the methods of matrix … Continue reading →

Posted in Finite Element Analysis, Frame Analysis, Newton | Tagged , , | 1 Comment

xlwSciPy update for Python 3

Posted on 09/04/2018 by dougaj4

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 , , , , , , | 2 Comments