Category Archives: Newton

Precise Angles and XNumbers

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

New Page

In an effort to make the information on this site easier to access I have collected all the “Daily Download” posts from last year onto a new page, listing each of the download posts by category. It’s called “Download by … Continue reading

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

New Release Alglib Library

The Alglib Numerical Analysis Library has just been updated.  For full details of the changes see: http://www.alglib.net/arcnews.php#date_18_01_2013 , but the significant change for routines linking to my spreadsheets is that the sparse solver  has been significantly improved and now successfully solves problems … Continue reading

Posted in AlgLib, Excel, Finite Element Analysis, Link to dll, Maths, Newton | Tagged , , , | Leave a comment

3DFrame – 3D Frame analysis for Excel

I have now extended the Frame4 spreadsheet to deal with 3D frames.  As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 21 Comments

Defining beam orientation in 3D

The principal axes of a beam (or any 2D closed shape) are defined as the axes along which an applied load will not cause any deflection in the transverse direction.  In mathematical terms, if the beam cross-section is defined in the … Continue reading

Posted in Beam Bending, Coordinate Geometry, Frame Analysis, Maths, Newton | Tagged , , , , | Leave a comment