Originally posted by: Srihitha Reddy B

How to execute the program file in a single "run configuration" click using multiple data files(excel sheets)? 

Like we have to provide say, 10 input data files (10 excel sheets), then our program should connect all these 10 data files to the program itself, and when it is executed, we have to obtain 10 corresponding results.

Which means, instead of changing data files 10 times and running them individually to obtain the corresponding 10 results, is there any way of programming in which we will automate the process by giving 10 input data files at a time and obtain 10 outputs.

Thanks and regards,

Srihitha.

Hi

https://www.ibm.com/developerworks/community/forums/html/topic?id=092c58bb-7bc8-4121-b3d9-91c07424c586

you may also see the example CPLEX_Studio128\opl\examples\opl\examples_suite

regards

https://www.linkedin.com/pulse/how-opl-alex-fleischer/

Originally posted by: Srihitha Reddy B

Hi, Alex!

Thanks for answering my question.

I have looked at the above link which you provided. But it was still confusing.

I had some variables in my program, and I need to have all those variables data again in a separate file or separate columns. I couldn't understand how the same program can be run multiple times with the multiple copies of data each executing individually.

Here, I tried using the code as follows in .dat file. Please let me know the modifications.

SheetConnection my_data("Allocationalgo.xlsx");
 
 averagefdel from SheetRead(my_data,"avgfdel");
 averageactpower from SheetRead(my_data,"avgactpow");
 pcap from SheetRead(my_data,"p_cap");
 power from SheetRead(my_data,"actpow");
 currentpower from SheetRead(my_data,"serverpow");
 //power_cap from SheetRead(my_data,"actpower");
 
 pcap from SheetRead(data2,"pcap");
 averagefdel from SheetRead(data2,"fdel");
 averageactpower from SheetRead(data2,"avgactpower");
  power from SheetRead(data2,"actpower");
 currentpower from SheetRead(data2,"serverpower");

By doing this, am getting an error saying, "Data element 'pcap' has already been set."

Please help me out with this issue.

Thanks,

Srihitha.

Hi,

in a given .dat you cannot have twice pcap !

Other examples:

https://www.ibm.com/developerworks/community/forums/html/topic?id=471cc451-9dc2-44d8-a0e9-5f146fb14765&ps=25

https://www.ibm.com/developerworks/community/forums/html/topic?id=59d92679-0fd0-44f6-a447-5afa833c0a2a&ps=25

regards

Originally posted by: Srihitha Reddy B

Hi,

In the above link, https://www.ibm.com/developerworks/community/forums/html/topic?id=471cc451-9dc2-44d8-a0e9-5f146fb14765&ps=25 , we are giving input maxOfx value once and then we are using that in the first mod file i.e sub.mod and then using the y value as x value in the next mod file, sub2.mod. But, here my scenario is different.

I need to have multiple excel sheets for having multiple sets of data and I need a single program in ehich I had to able to automate the process of executing all the multiple data files at the same time.

Hope you understand my problem.

Thanks,

Srihitha.

Hi,

could you have a look at the example in

CPLEX_Studio128\opl\examples\opl\examples_suite

?

Originally posted by: Srihitha Reddy B

Hi,

I had a glance at those examples. But I couldn't find the examples which uses multiple input files (multiple excel sheets) and then program in the main part of mod file correspondingly.

Thanks,

Srihitha

Hi,

let me give you a small example:

sub.mod

float maxOfx = ...;
    dvar float x;

    maximize x;
    subject to {
      x<=maxOfx;
    }

    execute
    {
    writeln("x= ",x);
    }

sub.dat

 maxOfx=10;

sub2.dat

maxOfx=11;

then

{string} datFiles={"sub.dat","sub2.dat"};

main {

for(var datFile in thisOplModel.datFiles)
{
  var source = new IloOplModelSource("sub.mod");
  var cplex = new IloCplex();
  var def = new IloOplModelDefinition(source);
  var opl = new IloOplModel(def,cplex);
  var data = new IloOplDataSource(datFile);
  opl.addDataSource(data);
  opl.generate();
  if (cplex.solve()) {
     writeln("OBJ = " + cplex.getObjValue());

  } else {
     writeln("No solution");
  }
 

  opl.end();
 
  data.end();
  def.end();
  cplex.end();
  source.end();
}
}

gives

OBJ = 10
OBJ = 11

regards

Originally posted by: Srihitha Reddy B

Hi,

Thank you so much for the response.

But, I had a query about creating two .dat  files?

So, as I want to have two excel sheet files, now after creating two .dat files, what I can do is, to use SheetConnection and establish the connection and then I can implement the same thing in the .mod file which you have shown.

Also, where should be the main function written, in the .mod file itself or anywhere else?

Thanks,

Srihitha.

Hi

in sub.dat and sub2.dat you could have some SheetConnection and SheetRead

regards

Originally posted by: Srihitha Reddy B

Hi,

How should we create another .dat file?

While creating mod file, we can create one dat file. But how can we create multiple dat files?

Thanks,

Srihitha.

Originally posted by: Srihitha Reddy B

Hi,

I am almost there, but getting some errors.

Please have a look at my files.

ERROR: 

Try downloading .rar file. I also attached the individual files even.

Thanks in advance,

Srihitha.

Hi

I generally like to have a main in a separate file

oplrun mainindia.mod works fine

regards

Originally posted by: Srihitha Reddy B

Hi,

But am not able to add two .mod files to "configuration 1(default). Only one .mod file is getting added and multiple .dat files are getting added.

Please suggest me an alternate solution.

Thanks,

Srihitha.

Hi,

in a run configuration you may have only one .mod

In order to run the main.mod I used

regards

https://www.linkedin.com/feed/update/urn:li:activity:6386134616226566144https://www.linkedin.com/feed/update/urn:li:activity:6386134616226566144https://www.linkedin.com/feed/update/urn:li:activity:6386134616226566144

Originally posted by: Srihitha Reddy B

Hi,

I am having the same issue as below. But, I couldn't understand the solution.

https://www.ibm.com/developerworks/community/forums/html/topic?id=09847297-e0ed-47b0-b2a2-81a1e370a014

Thanks in advance,

Regards,

Srihitha