Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- 3DFrame - 3D Frame analysis for Excel
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Downloads
- Automatic download of csv files
Recent Comments
Category Archives: Newton
7 Year Report
As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading
Reducing Risk in Structural Concrete Design
The Concrete Institute of Australia is running a series of full day seminars on Structural Concrete Design for Extreme Events in each of the mainland capitals: See: Structural Concrete Design for Extreme Events for details of dates and locations in … Continue reading
Posted in Concrete, Newton
Tagged Concrete Institute, Earthquake design, Fire design, Risk reduction
Leave a comment
Beams may kiss, but do not hug …
… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Simply supported beams, Solver, stacked beams, Strand7, UDF, VBA
Leave a comment
Numerical Integration; Tanh-Sinh Quadrature v. 4.3
A new version (4.3) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. The Tanh-Sinh Quadrature Version 4.3 workbook now provides a feature for the integration of integrands contained in independent (external) UDFs. … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
6 Comments
Numpy and Scipy for Excel
The Python Numpy and Scipy libraries contain a huge number of maths and science related functions. Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading
Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Numpy, Python, SciPy, UDF, VBA
11 Comments