Recent Comments
Category Archives: Newton
Evaluating higher order polynomials …
… and a better solution for quadratics. Having written a better solver for high order polynomials, that raises a few other issues. The error in the roots found by the RPolyJT was checked by simply substituting each root as the … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
4 Comments
Solving higher order polynomials
The Quartic spreadsheet presented here previously (most recently here) uses algebraic techniques to provide an “exact” solution to polynomial equations of up to fouth order. For polynomials of higher order there is no general algebraic solution, and numerical methods are … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
12 Comments
LatPile update
I have just posted an update to the LatpilePY spreadsheet, fixing a bug in the way in which it read the first row of data from input PY curves, which was resulting in the program failing to run if there were … Continue reading
Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, free download, laterally loaded piles, Non-linear concrete, UDF, VBA
2 Comments
Elegant Solutions – completing the square
When I was at school (many years ago), if I recall correctly, we were told of the “completing the square” method of solving quadratic equations, but I never really appreciated the elegance of this method because it was treated as … Continue reading
Posted in Excel, Maths, Newton
Tagged completing the square, Excel, Maths, Quadratic equations, Skydrive
1 Comment
Buckling of rings and arches
In 2007 I wrote a paper on buckling of confined steel tunnel liners for the ANZ Geomechanics Conference in Brisbane, and in the course of that I noticed that the calculated buckling load of an unconstrained pipe subject to uniform radial load was significantly … Continue reading
Posted in Arch structures, Beam Bending, Excel, Newton, VBA
Tagged buckling, Excel, Rings and Arches, VBA
15 Comments
Newton Excel Bach, not (just) an Excel Blog 