Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  sensitivity

    Posted 01/11/09 06:28 PM

    Originally posted by: SystemAdmin


    [glitter said:]

    Hi,

    My model does not have any integer variables, but dual and slack values appear as undefined.
    When i check the constraints from problem tab i can see the slack and dual values, i think i have a mistake in the writeln part but i cannot solve it.
    at the end of model file i write,
    execute{
    writeln(ct1.slack, "", ct1.dual)
    }
    and my constraint is
    forall(i in Books)
    ct1:
    number[i]<=order;<br />
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: sensitivity

    Posted 01/12/09 01:27 PM

    Originally posted by: SystemAdmin


    [alain.chabrier said:]

    HI,

    In the script part, you may have to write something similar to :

    execute {
    for (i in Books)
    writeln(ct1[i].slack, "", ct1[i].dual)
    }

    Alain
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: sensitivity

    Posted 01/12/09 06:46 PM

    Originally posted by: SystemAdmin


    [glitter said:]

    thanks very much, it worked...

    i have one more question on this, is there a way to write the sensitivity analysis values to Microsoft Access?
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: sensitivity

    Posted 01/12/09 06:46 PM

    Originally posted by: SystemAdmin


    [alain.chabrier said:]

    Hi,

    What you can do is use some float array to save the dual into it, and then using .dat files export these data to the excel file.

    float myduals[Books];

    execute {
    for (i in Books)
      myDuals[i] = ct1[i].dual;
    }

    And then use ExcelWrite in .dat to get it written to the Excel file. Look at any Excel data example for this.

    Alain
    #DecisionOptimization
    #OPLusingCPLEXOptimizer