Category Archives: Excel

New Links

Posted on 26/01/2011 by dougaj4

Two new Excel links on the list to the right, both with a tonne of good information on how to get more out of Excel: Bob Phillips writes the Excel Do, Dynamic Does blog, with a focus on business information.  The … Continue reading →

Posted in Arch structures, Excel, Historic Bridges, Newton | Tagged , , | Leave a comment

Finding all range names in a specified range

Posted on 24/01/2011 by dougaj4

Another useful little snippet from Eng-tips. There was a question regarding how to list all the range names applied to a specified cell.  Forum members electricpete and MintJulep came up with a short macro to do the job, which I have … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 2 Comments

Using LINEST for non-linear curve fitting

Posted on 19/01/2011 by dougaj4

Update 14 March 2020: See LinEstGap with non-linear functions for the latest version of Linest-Poly with new functions for non-linear curves allowing more convenient input and work with data with gaps errors, and/or hidden lines. Update 28 June 2015:  Also see … Continue reading →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 96 Comments

Evaluating higher order polynomials …

Posted on 17/01/2011 by dougaj4

… 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 , , , , , , | 4 Comments

Solving higher order polynomials

Posted on 13/01/2011 by dougaj4

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 , , , , , , | 12 Comments