Solver
 

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?

Solver
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Richard4926" wrote in message
...
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?

Solver
 

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

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

--
HTH :)
Dana DeLouis


"Richard4926" wrote in message
...
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?

Solver
 

On Mon, 17 Dec 2007 05:51:01 -0800, Richard4926 wrote:

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.


--
http://nerds-central.blogspot.com/se...l/Baby%20Steps

Solver
 

Are you sure it uses the simplex method when solving a system of equation?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Alex Turner" wrote in message
...
On Mon, 17 Dec 2007 05:51:01 -0800, Richard4926 wrote:

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.


--
http://nerds-central.blogspot.com/se...l/Baby%20Steps