Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
Expand all | Collapse all

write intermediate solutions to excel instantaneously

  • 1.  write intermediate solutions to excel instantaneously

    Posted 03/26/14 12:10 PM

    Originally posted by: Rajasekhar Kadambur


    How to write the intermediate solutions to excel when the solution is found (before post processing) .

    (How to write solution to excel from the main Opl script)


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: write intermediate solutions to excel instantaneously

    Posted 04/07/14 04:49 PM

    Originally posted by: Mondano


    Maybe you could iteratively set the MIP gap and then call postProcess and solve, like

    //preparation

    cplex.epgap = 0.9

    cplex.solve()

    cplex.postProcess() // with the execute block after main the writing should be triggered

    cplex.epgap = 0.8

    cplex.solve() // it starts from the previously optained solution, since nothing has been ended

    ...

    and so on. Maybe you could also decrease the epgap-parameter in a loop.


    #DecisionOptimization
    #OPLusingCPLEXOptimizer