Decision Optimization

Decision Optimization

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

 View Only
Back to discussions
Expand all | Collapse all

Sheetwrite in flowshop example

  • 1.  Sheetwrite in flowshop example

    Posted Tue February 11, 2014 08:44 AM

    Originally posted by: Shawn1


    I need to write the value of variable "itvs" in attached scheduling problem in an excel sheet. Is there any way to do this?

    itvs contains starting time, finishing time and duration for preforming each job on each machine. 

    Thanks in advance for your support.

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: Sheetwrite in flowshop example

    Posted Tue February 11, 2014 09:26 AM

    Hi,

    have you tried anything like adding

     

    tuple it
    {
     int m;
     int g;
     int s;
     int e;
    }  

    {it}  output={<m,g,startOf(itvs[m][g]),endOf(itvs[m][g])> | m in 0..Mchs-1,g in 0..Grades-1};
     

     

    and then doing a SheetWrite with tuple set output ?

     

    Regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: Sheetwrite in flowshop example

    Posted Tue February 11, 2014 01:13 PM

    Originally posted by: Shawn1


    Thank you Alex for your prompt reply.  It works!


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: Sheetwrite in flowshop example

    Posted Wed February 12, 2014 11:30 AM

    Originally posted by: Shawn1


    Alex

     

    Can I write the values for 'mchs'  variable in Excel too? What I need to export is the order of jobs run on each machine. I could not figure out how to export it.

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content