Category Archives: Newton

Dynamic sorting with Excel, VBA, and Python

Posted on 31/03/2014 by dougaj4

A spreadsheet with User Defined Functions (UDFs) to dynamically sort a range of data has previously been presented here and here. I have now modified the Python version of the UDF for improved functionality, added a second Python function, and … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , | 1 Comment

Transfer of arrays to/from Python with Pyxll – Part 2; Speed

Posted on 22/03/2014 by dougaj4

Following the previous post, which looked at the way different data types worked when transferring data between Excel and Python, this post looks at ways t0 get the best performance. As a benchmark I have used a short routine that: … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, VBA | Tagged , , , , , , | 1 Comment

Global to Local for plates (and three node beams)

Posted on 02/03/2014 by dougaj4

The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading →

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , | 3 Comments

The angle between two vectors, Python version

Posted on 01/03/2014 by dougaj4

I posted a VBA function to return The angle between two vectors, in 2D or 3D last year, and have just discovered that Python and Numpy are lacking this function.  Since all the suggested code I found in a quick search used: Cos θ … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy | Tagged , , , | 10 Comments

Using Frame4Buckle with the Alglib solver

Posted on 01/03/2014 by dougaj4

The Frame4Buckle spreadsheet carries out a buckling analysis of a column or strut, which may be divided into any number of segments with varying cross section details, allowing the analysis of stepped or tapered members.  The spreadsheet includes a VBA … Continue reading →

Posted in AlgLib, Computing - general, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , , | 5 Comments