Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- Solving non-linear equations with two or more unknowns – 3
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Beam actions and deflections by Macaulay's Method
- Taming Symbols in Excel
- Downloads
- Downloads by category
- Buckling of columns with varying cross section
Recent Comments
Category Archives: Newton
The structural analysis of domes: From Pantheon until Reichstag
An interesting paper with technical details of several historical domed structures, available for free download, from Dokuz Eylul University, Izmir, Turkey: The structural analysis of domes
Revision to CSpline2.xls
It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003. It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading
Posted in Drawing, Excel, Maths, UDFs, VBA
Tagged bug fix, ChartSpline function, Cubic spline
6 Comments
Stress blocks in AS 3600
The long awaited update to the Australian Standard for concrete structures (AS 3600 – 2009) provides rules for the design of structures with concrete up to a compressive strength of 100 MPa. Unfortunately there are a number of significant typographical errors … Continue reading
Tanh-Sinh Quadrature update
Graeme Dennes has been continuing work on his Tanh-Sinh Quadrature function, and recently sent me a revised version, which can be downloaded from: Tanh-Sinh.zip The main change is a new automatic tolerance adjustment feature which automatically increases the tolerance for … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
9 Comments
Update to Beam1 and Beam2
It has just been pointed out that the single span beam spreadsheet presented at Frame Analysis with Excel 1 does not work for a propped cantilever. The same applies to the spreadsheet for single span sloping beams at Frame Analysis with … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged beam analysis, Excel, Frame Analysis
3 Comments