Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 2DFrame-py
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Using VBA Evaluate as an Array Function
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Frame Analysis with Excel - 3, Continuous beam or frame
- The Conjugate Beam Method
- Downloads
- Cubic Splines
Recent Comments
Category Archives: Newton
Daily Download 1: Buckling of columns, rings and arches
One of the disadvantages of the blog format is that valuable resources tend to get lost somewhere in the archives. To help make them a bit more visible, for the next month or so I plan to post links to … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged buckling, Downloads, Excel, Rings and Arches, stepped columns, UDF, VBA
Leave a comment
Tanh-Sinh Quadrature V3.0
I have received from Graeme Dennes another update to his Tanh-Sinh Quadrature spreadsheet, offering fast and convenient numerical integration functions. The spreadsheet can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: Tanh-Sinh Quadrature … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
5 Comments
Frame4 – with intermediate beam results
Back in March 2010, in response to this post with an update of the Frame4 spreadsheet: https://newtonexcelbach.wordpress.com/2009/12/31/frame4-xls-update2/ jscott (and later mettrox) asked if I had thought about adding output of the member forces at intervals along the member length, to which the response … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, open source code, VBA
5 Comments
Continuous Beam Spreadsheet – with Units
The spreadsheet previously known as Macaulay has been updated to include “unit aware” versions of all the included functions, and has been renamed “ConBeamU”, to make it more obvious what it does. The new spreadsheet (including full opens source code) can be … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Continuouse beam, Excel, Macaulay's Method, UDF, unit aware, VBA
21 Comments
Units for Excel 5:
Previous post on Units for Excel Download spreadsheet: Units4Excel.zip I have posted a new update of the Units4Excel spreadsheet for download (link above). The main changes are: The ConvertA and ConvertA2 functions have been combined. The ToSI and FromSI functions have been deleted, … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Excel, UDF, Unit conversion, Units, Units aware, VBA
3 Comments