Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 5: Frame Analysis
- Downloads
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Author Archives: dougaj4
Is Hinchliffe’s Rule True? …
… is the title of a paper by Boris Peon. Here is the abstract: Hinchliffe has asserted that whenever the title of a paper is a question with a yes/no answer, the answer is always no. This paper demonstrates that … Continue reading
Long Lost, a WW1 short film …
… and crowd-funded production, directed by my daughter: The story of the project At the start of 2014, sparked by the funding opportunity Raw Nerve (A Metroscreen and Screen Australia initiative) Kerinne Jenkins (director), Harry Windsor (writer) and Nic Douglas … Continue reading
Numerical Integration; Tanh-Sinh Quadrature v. 4.2
The latest version (4.2) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. For more details of the background see: Faster Integration with the Tanh-Sinh Method and subsequent posts on this subject. In addition to … 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
2 Comments
Solving polynomials – update
The polynomial spreadsheet (details here) provides functions to solve polynomial equations of any order; using an “exact” method for up to quartic, and an iterative procedure for higher orders. The input for the functions requires the equation coefficients to be … Continue reading
Posted in Arrays, Excel, Maths, UDFs, VBA
Tagged Excel, high order simultaneous equations, Polynomial equations, solve simultaneous equations, UDF, VBA
1 Comment
Faster Biaxial Bending
The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment