Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 2DFrame-py
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Biaxial bending update
- Using VBA Evaluate as an Array Function
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- Automatic download of csv files
Recent Comments
Category Archives: Newton
World’s Largest Natural Arches
Update 9th May 2013: Not in the top 10 for size, but a little known rock formation in Australia: From AmusingPlanet.com and The Natural Arch and Bridge Society A natural arch is a geological formation where rocky cliffs subject to erosion … Continue reading
Section properties for groups of defined shapes
Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of multiple shapes, VBA
13 Comments
3DFrame Ver 1.03 and Frame4 Ver 3.07
Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA
Tagged 3D frame analysis, Excel, Frame Analysis, VBA
34 Comments
Tanh-Sinh Quadrature V4.1
The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes 1. Small but useful accuracy improvements have been … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
1 Comment
Bridges Over the Tiber -3
See Bridges Over the Tiber -1 for location map. The final installment of Bridges Over the Tiber brings us to the six bridges built in the 20 th Century, which can be grouped in three pairs: two copies of the ancient … Continue reading