Recent Comments
Category Archives: UDFs
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
13 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
ULS design of reinforced concrete, AS, ACI and European codes
The previous post in this series compared the results of current and previous Australian Standards, and the ACI 318 code, for the ultimate bending capacity of a rectangular reinforced concrete section, subject to combined bending and axial load. I have now extended … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged ACI 318, AS 3600, BS 5400, BS 8110, Concrete, EC 2, Reinforced Concrete, Section Analysis, Ultimate capacity
1 Comment
More on the Excel Evaluate function
Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update). It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading
Posted in Excel, Newton, Numerical integration, UDFs, VBA
Tagged Eval, EvalText, Evaluate, Excel, numerical integration, Substitutea, UDF, VBA
4 Comments
