Category Archives: UDFs

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

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

Plotting Charts With Gaps …

Posted on 31/03/2018 by dougaj4

“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading →

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA | Tagged , , , | 7 Comments

More circle fitting options with Scipy

Posted on 17/03/2018 by dougaj4

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles.  An example of the problem can be seen in the screen shots below: The function … Continue reading →

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

More Python rotation functions

Posted on 23/02/2018 by dougaj4

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation.  I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading →

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