Category Archives: UDFs

Converting from global to local coordinates (and vice versa)

Posted on 08/01/2014 by dougaj4

In 3D structural analysis (as well as many other applications) it is necessary to convert section properties, forces, and deflections between coordinate systems defined by individual structural members (local coordinates) and the common coordinate system defining the entire structure (global … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, UDFs, VBA | Tagged , , , , , , , | 22 Comments

Python for VBA users- 7; Making Python go Faster

Posted on 20/12/2013 by dougaj4

As reported in the previous post in this series, although the compiled routines included in packages such as Numpy, Scipy, and Pysparse are very fast, other parts of the code turned out to be slower than the equivalent in VBA.  … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , | Leave a comment

Download update 2

Posted on 08/12/2013 by dougaj4

I have updated the Downloads spreadsheet on Skydrive to include all new files added this year, and I have also added two Category columns, which link to the Download by Category page, giving more details and links for each file.  … Continue reading →

Posted in Computing - general, Excel, Newton, UDFs, VBA | Tagged , , , | Leave a comment

Download update – Python downloads

Posted on 08/12/2013 by dougaj4

Download files related to linking to Python from Excel are to be found in: Python matrix functions in Excel, using Pyxll: Download file: http://interactiveds.com.au/software/Matrixpyxll.zip Python for VBA users – 4; Python data types:  The main Python data types, including numpy arrays, with examples … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | Leave a comment

Extracting numbers from text strings

Posted on 07/12/2013 by dougaj4

There is often a need to extract numbers from the start or end of text strings.  It’s not too hard to do with on-sheet formulas, but after having done it a few thousand times I decided it would be worth … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 13 Comments