Originally posted by: TrầnQuốcĐạt
Model:
int nbJobs = ...;
int nbMchs = ...;
range Jobs = 0..nbJobs-1;
range Mchs = 0..nbMchs-1;
// Mchs is used both to index machines and operation position in job
tuple Operation {
int mch; // Machine
int pt; // Processing time
};
Operation Ops[j in Jobs][m in Mchs] = ...;
Data:
nbJobs = 6;
nbMchs = 6;
//<Machine,Processing_time>
Ops=[
[<2,1>,<0,3>,<1,6>,<3,7>,<5,3>,<4,6>],
[<1,8>,<2,5>,<4,10>,<5,10>,<0,10>,<3,4>],
[<2,5>,<3,4>,<5,8>,<0,9>,<1,1>,<4,7>],
[<1,5>,<0,5>,<2,5>,<3,3>,<4,8>,<5,9>],
[<2,9>,<1,3>,<4,5>,<5,4>,<0,3>,<3,1>],
[<1,3>,<3,3>,<5,9>,<0,10>,<4,4>,<2,1>],
];
But, I want to input this data from Excel, You can help me, please!
#CPLEXOptimizers#DecisionOptimization