how to extract the log file information (iteration or objective value) to excel

Hi, dear friends

I have a model that I solved through Conopt
I want to extract the log file information (iteration number, time, and objective function value) to Excel and draw a solver performance curve.
The only way that I found was to copy all log file information, which is hard and impossible to separate all data from those for which I need it.
Can any one suggest a way to save log file information to Excel in which each column represents one piece of information, such as iteration, etc.?
Thank you.

1 Like

Parsing the log file is the only way for Conopt. For some MIP codes, e.g. Cplex, there is a GAMS facility called mip- or solvetrace. This allows to print the primal and dual solution over time. For details check the docs.

-Michael