Decision Optimization

Decision Optimization

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

 View Only

  • 1.  How to read a 3-D parameter from excel sheet?

    Posted Sat April 15, 2017 02:17 AM

    Originally posted by: BhavnaJha


    Hi, 

    Is there a way to input a 3-D variable where the dimensions are strings and not int? 

    I found a link explaining how to read the data using integer dimensions. 

    But if I have sets as 

    {string} a = ..;

    {string} b = ..;

    {string} c = ..;

     

    float p[a][b][c] = ...; 

     

    Then how should I read the data from an excel spreadsheet, where data is in 2-D form? 


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: How to read a 3-D parameter from excel sheet?

    Posted Mon April 17, 2017 09:25 AM

    Hi,

    Have you had a look at http://www-01.ibm.com/support/docview.wss?uid=swg21401340

    ?

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: How to read a 3-D parameter from excel sheet?

    Posted Mon April 17, 2017 01:59 PM

    Originally posted by: BhavnaJha


    Yes I had a look at this. That's why I wrote I found a link which read 3-D variables using integer dimensions or sets but I couldn't find on how to do it when you have strings as dimensions. 

     

    Is there a way? 

     

    Please help! Thank you. 


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: How to read a 3-D parameter from excel sheet?



  • 5.  Re: How to read a 3-D parameter from excel sheet?

    Posted Wed April 26, 2017 05:47 AM

    Originally posted by: BhavnaJha


    Yes, this answers my question. 

    Thank you. :)


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content