Solver

[Richard4926]

Hi!

I'm working with excel 2003. I'd like to know details about the algorithm
excel uses to solve a system of equations with for examlpe 10 unknowns.
Where can I find these information?

 

[Bernard Liengme]

In any text book on numerical analysis you will find stuff on solving
equations by iterative methods.
But to solve a system of equations (simultaneous equations) the best way is
with the matrix function MINVERSE and MMULT
best wishes

 

[Dana DeLouis]

If it's a question with Solver , here's a kb article:

Solver Uses Generalized Reduced Gradient Algorithm
http://support.microsoft.com/kb/82890

 

[Alex Turner]

Hi!

I'm working with excel 2003. I'd like to know details about the
algorithm excel uses to solve a system of equations with for examlpe 10
unknowns. Where can I find these information?

Specifically, the solver uses a form of the simplex function. This is
not a bad choice because it tends to be very stable and therefore general
purpose. However, its performance (steps to completion within chosen
criteria) is really really bad compared to conjugate gradients or newton
raphson.

 

[Bernard Liengme]

Are you sure it uses the simplex method when solving a system of equation?
best wishes