View Single Post
  #1   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:
Martin

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


My friend, I tried when setting the option features but it doesn't get
marked when I click up on it. Why? I don't know. I'll run the same model on
other pc to see if I can set this option. I hope there's nothing wrong with
my solver... A while ago I ran a model and I remember that it showed some
iterations as it was running.


How odd. It works here at least on the sorts of optimisation problems I
run - typically non-linear curve fits on real number data.

Each iteration stops and the screen shows the current values of the
parameters and the value of the function being optimised.

Regards,
Martin Brown