Category Archives: Newton

Cubic splines with horizontal data

Posted on 16/02/2014 by dougaj4

Following a request here I have modified my cubic spline functions to accept input arranged  in rows as well as columns.  By default the output arrays will have the same orientation as the range of interpolation X values, but I have also added … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 1 Comment

Beam actions and deflections, 3D or 2D

Posted on 01/02/2014 by dougaj4

Two new functions have been added to the ConBeamU spreadsheet, last discussed here. The new version can be downloaded from ConBeamU.zip, including full open-source code. The new functions, BeamAct3D and BeamAct2D calculate forces, moments, deflections and rotations along a 3D … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 2 Comments

New Links: Scientific Python and Engineering Excel

Posted on 31/01/2014 by dougaj4

The previous post had a link to Cyrille Rossant which is worth a closer look.  The blog has many detailed posts on scientific applications of Python, as well as links to Galry: a high performance interactive visualization package in Python and his … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , | Leave a comment

The speed of loops in Python

Posted on 24/01/2014 by dougaj4

This post is based on exercises published by Cyrille Rossant in his book “Learning IPython for Interactive Computing and Data Visualization”.  Cyril also has a blog well worth looking at: http://cyrille.rossant.net/blog/ (Thanks to Alfred Vachris and Boris Vishnevsky for the links). … Continue reading →

Posted in Arrays, Link to Python, NumPy and SciPy | Tagged , , , , | Leave a comment

Two MaxAbs functions

Posted on 20/01/2014 by dougaj4

Excel does not have a built-in function to find the maximum absolute value of a range, perhaps because the Max() and Abs() functions can be combined in an array function: =Max(Abs(datarange)) This solution has a number of drawbacks however: The … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 9 Comments