Quartic2.xls Download

Description:

Find the roots of polynominal equations with Purpose Excel Functions

Quartic - ax^4 + bx^3 + cx^2 + dx +e = 0
=quartic(a, b, c, d, e, Output Index -1 to 5 (optional))
Cubic - ax^3 + bx^2 + cx + d = 0
=cubic(a, b, c, d, Output Index -1 to 4 (optional))
CubicCa - x^3 + bx^2 + cx + d = 0
=cubicC(a, b, c, d, Output Index -1 to 4 (optional))
Quadratic - ax^2 + bx + c = 0
=quadratic(a, b, c, Output Index 1to 3(optional))

Notes
1 Enter an output index to specify a real root number, or the number of real roots
2 Enter a negative output index to specify a complex root number, or the number of complex roots
3 Enter as an array formula to return an array with the real part of all roots and the number of real roots
4 Enter as an array formula with output index = -1 to return an array with the imaginary part of all roots and the number of complex roots
5 Equations of lower order may be solved by entering 0 in the redundant factors.

Courtesy of Interactive Design Services Pty Ltd - a small civil engineering consultancy based in Sydney, Australia, specializing in analysis, design, review and technical advice related to bridges and soil interaction structures such as retaining walls and buried structures. The principal of the company, Doug Jenkins, has over 30 years experience in the design and construction of bridges, retaining walls, and buried arch structures.

Calculation Reference
Polynominal
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Forum Link

Discuss this document in the Forum (subscribe to this topic to be notified of changes).

Submitted On:

02 Jul 2008

Submitted By:

Doug Jenkins (DougJenkins)

File Date:

02 Jul 2008

File Author:

Doug Jenkins

File Version:

1.0

File Size:

117.00 Kb

File Type:

xls

Downloads:

185

Rating:

Total Votes:2

Be the first to comment! Please sign in or register.