Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  making tuples/arrays by import Excel data to CPLEX

    Posted 04/19/23 12:04 PM

    Hello,
    please see the excel file attached.

    How can i make arrays/tuples like:
    COST = {  [ <10> , <20> , <BIG NUMBER> ]  ,  [ <30> , <40> , <50> ] }
    TOTALH = [ <10> , <20> ]
    PRICE = { [ <10> , <0> , <0> ] , [<20> , <0> , <0>] , [<0> , <30> , <40>] , [<0> , <0> , <50>] , [<60> , <0> , <30>] }


    Thanks in Advance,

    Eran.



    ------------------------------
    eran tascesme
    ------------------------------


  • 2.  RE: making tuples/arrays by import Excel data to CPLEX

    Posted 04/20/23 05:35 AM
    Edited by Renaud Dumeur 04/20/23 05:37 AM

    Dear Eran,

    You will find an answer to your question in:
    https://www.ibm.com/docs/en/icos/22.1.1?topic=keywords-sheetread
    which describes how to use SheetConnection and SheetRead directive to access spread sheet contents.
    I hope this helps,

    Cheers,

    Cheers,



    ------------------------------
    Renaud Dumeur
    ------------------------------