Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 2DFrame-py
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using VBA Evaluate as an Array Function
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- Automatic download of csv files
Recent Comments
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
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
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 AlgLib, Excel, link to dll, sparse solver
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 3D frame analysis, Excel, sparse solver, Spreadsheet frame analysis, VBA
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