Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  SheetWrite and SheetRead

    Posted 06/13/14 09:07 AM

    Originally posted by: siva.chinta


    hi, i want to run a single run configuration, in which it has to take multiple data for a single datatype.

    for example i want to run a model, in which A is a data vector,  for 40 different cases the data for A i want to read from 40 different .xls files named file_1,file_2,..file_40. without using different run configurations i want to run it in a single run configuration. similarly i want to write the output variable B, from those 40 cases in to 40 different .xls files. is it possible?? give me your valuable suggestion.

                      Thanks in advance. 


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: SheetWrite and SheetRead

    Posted 06/13/14 10:46 AM

    Hi,

    in your .dat why do not you use 40 different SheetConnection ?

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: SheetWrite and SheetRead

    Posted 06/14/14 01:36 AM

    Originally posted by: siva.chinta


    Thanks, but each time i want to initialize the data for a single data type named with A and i want to run it like a for loop for 40 different cases. is it possible??


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: SheetWrite and SheetRead

    Posted 06/14/14 10:56 AM

    Hi,

    then what you could do is generate the .dat files through scripting. The .dat will have the 40 SheetConnection but you will have generate those through simple codes.

     

    Regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer