Tag Archives: Quartic

Complex Numbers and Solving Quartic Polynomial Equations

Posted on September 19, 2010 by dougaj4

It was recently pointed out to me that the User Defined Function (UDF) for solving quartic polynomial equations presented in this post returned an error for some input values.  In tracking down the source of the error I decided that it … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Solving cubic and quartic equations with Excel

Posted on August 4, 2010 by dougaj4

Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs)  for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Approximate Solutions of Polynomial Equations

Posted on September 14, 2009 by dougaj4

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel.  Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Using Goal Seek on Multiple Cells

Posted on July 25, 2009 by dougaj4

The Excel “goal seek” function is useful and powerful, but the procedure for using it on multiple cells is painfully slow. The spreadsheet GSeek.xls provides a simple macro to allow Goal Seek to be automatically applied to a range of … Continue reading →

Posted in Excel, Maths, VBA | Tagged , , , | 17 Comments

Reinforced Concrete Section Analysis – 3

Posted on May 30, 2008 by dougaj4

Previous post -1 Previous post -2 The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs | Tagged , , , , , , , , | 8 Comments