View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Martin Brown Martin Brown is offline
external usenet poster
 
Posts: 230
Default Getting intermediate results from Solver Functions... Possible

Martin wrote:
ryguy7272

Maybe you got me wrong, I'm not trying to set a fire in an iceberg... It was
just a question, that's why my opening on the question was "Is it
possible..." I didn't take it for granted, and you're very right... Solver is
an optimization tool so it does what's expected from it... I just wanted to
get intermediate results for academic purposes for an operations research
class because Solver works under Simplex Method for linear problems... and


Won't "Solver Options" "Show Iteration Results" do what you want ?

that was it. Honestly, I don't feel Solver is explained well enough in terms
of functions it uses. I thought that, maybe, there might be another function
called from solversolve that gets intermediate results that are reused in a
loop. Sorry for the inconvenience... if any, and thank you.


I have a hunch that it swaps between different methods depending on how
well behaved the Hessian looks around the point(s) being considered.

It can get stuck if you feed it an awkward problem.

Regards,
Martin Brown