Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is Solver | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
"solver" | Excel Discussion (Misc queries) | |||
solver | Excel Discussion (Misc queries) | |||
Solver | Excel Discussion (Misc queries) |