Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  please help for the model, errors (please notify IBM)

    Posted 03/07/17 07:57 AM

    Originally posted by: A6UM_Can_Nguyen


    Dear all,

    I am using CPLEX to run a model that it read data from Excel file to the model. However, it is error as shown below. Could you help me to run the model? And please look at the attached project file.

     

    Thank you,

    IBM Nguyen

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: please help for the model, errors (please notify IBM)

    Posted 03/07/17 10:28 AM

    Thank you for the notification. Could you please specify which version of CPLEX Optimization Studio you're using, and on which platform?


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: please help for the model, errors (please notify IBM)

    Posted 03/07/17 10:41 AM

    Originally posted by: A6UM_Can_Nguyen


    Dear Xavier.Nodet,

    I am using ILOG CPLEX Optimization Studio Community Edition V12.6.3 for Windows 32 bit and my PC is Win7 with 32 bit, and the office is 2007.

    Thank you for help in advance.

    IBM Nguyen

     

     

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: please help for the model, errors (please notify IBM)

    Posted 03/08/17 03:24 AM

    Hi,

    if in the .dat you write

    SheetConnection sheet("MIVSsheet.xls");
     
     Products from SheetRead(sheet,"'Data'!A2:A10");
     Suppliers from SheetRead(sheet,"'Data'!B1:F1");
     c from SheetRead(sheet,"'Data'!B11:F11");
     p from SheetRead(sheet,"'Data'!B15:F23");

    the model should work better

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 5.  Re: please help for the model, errors (please notify IBM)

    Posted 03/08/17 01:07 PM

    Originally posted by: A6UM_Can_Nguyen


    Dear AlexFleischer,

    It's still error, please look at the attached files and help fix this.

    IBM Nguyen

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 6.  Re: please help for the model, errors (please notify IBM)

    Posted 03/08/17 02:27 PM

    and what is the error you get ?

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 7.  Re: please help for the model, errors (please notify IBM)

    Posted 03/08/17 09:24 PM

    Originally posted by: A6UM_Can_Nguyen


    Dear AlexFleischer,

    I use office 64bit, it work well. Thank you so much for help.

    IBM Nguyen


    #DecisionOptimization
    #OPLusingCPLEXOptimizer