Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  How to input data( type Turple) from Excel

    Posted 03/23/16 11:47 PM

    Originally posted by: TrầnQuốcĐạt


    Model:

    int nbJobs = ...;

    int nbMchs = ...;

    range Jobs = 0..nbJobs-1;
    range Mchs = 0..nbMchs-1; 
    // Mchs is used both to index machines and operation position in job

    tuple Operation {
      int mch; // Machine
      int pt;  // Processing time
    };

    Operation Ops[j in Jobs][m in Mchs] = ...;

    Data:

    nbJobs = 6;
    nbMchs = 6;
    //<Machine,Processing_time>
    Ops=[
    [<2,1>,<0,3>,<1,6>,<3,7>,<5,3>,<4,6>],
    [<1,8>,<2,5>,<4,10>,<5,10>,<0,10>,<3,4>],
    [<2,5>,<3,4>,<5,8>,<0,9>,<1,1>,<4,7>],
    [<1,5>,<0,5>,<2,5>,<3,3>,<4,8>,<5,9>], 
    [<2,9>,<1,3>,<4,5>,<5,4>,<0,3>,<3,1>],
    [<1,3>,<3,3>,<5,9>,<0,10>,<4,4>,<2,1>],
    ];

    But, I want to input this data  from Excel,  You can help me, please!


    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: How to input data( type Turple) from Excel

    Posted 03/24/16 01:40 AM

    You may want to take a look at this and this chapter in the user manual. They explain how to input data from Excel. The big question will probably be how to organize your data in Excel so that it represents tuples. Since Excel does not have a tuple data type, you will have to find something else, for example two rows that define the (machine,processint_time) pairs (a pair is formed by the two values that are in the same column).


    #CPLEXOptimizers
    #DecisionOptimization