Originally posted by: wj1

please find attached my .mod ,.dar files and the excel file ... for the constraint 10 i got an error , the size of the range is not the size of the array.

pLease help !!

Hi,

if you do

execute
{
writeln("nb courses =",course.size);
writeln("nb faculties = ",faculties.size);
}

you get

nb courses =62
nb faculties = 76

Is your named range "nb_section_faculty_course" the same size ? I do not think so

regards

Originally posted by: wj1

Hi Alex ,

how can i fix it , i've been trying for days now ... i only have 62 courses and 76 faculties ..im trying to read the column from excel

please help, thank youuuuu!

Instead of using a named range, why do not you try to use SheetRead with a range ?

See

https://www.ibm.com/developerworks/community/forums/html/topic?id=c2469c56-db27-4816-9cf2-f596513ce555&ps=25

on how to transform R1C1 ranges into the ones SheetRead accepts

regards

Originally posted by: wj1

the thing is im a very beginnner on opl ... is there any easier method ?

That s easy.

You may find an example in CPLEX_Studio129\opl\examples\opl\oil

https://www.ibm.com/support/knowledgecenter/SSSA5P_12.9.0/ilog.odms.ide.help/OPL_Studio/opllangref/topics/opl_langref_datasources_spreadsheet_read.html

regards

Originally posted by: wj1

ok im gonna check it out , i hope i can fix it ...  it's my last error ..thank you

Ok can you tell me where is that matrix of 62*76 ?

In which tab ? And what is are the extreme cells ?

regards

Originally posted by: wj1

ok, so , it's about constraint number 10 which is :

forall(<i,f> in Course_To_Faculty)sum( j in section :<i,j>in Course_To_Section) z[f][j]==nb_section_faculty_course[i][f];

so nb_section_faculty_course , you could find in the excel file .. you could type the name the name and you will see the range ...

thank you sooo much alex , i appreciate iiittt !!!

Hi

I see a column with 193 values.

Whereas OPL is expecting

nb courses =62
nb faculties = 76

So you need to fix that

regards

Originally posted by: wj1

that's the thing i couldn't figure out because the excel file is a data i got from the university ... i feel like i don't know what to do ...could u help me fix it ?

then waiting for you customer data you could try

float nb_section_faculty_course[c in course][f in faculties]=10;

in order to use fake values in the meantime

regards

Originally posted by: wj1

ok i will try a fake value... do u know someone who could help me asap , i need to hand in the model this week...thank you 

Hi

or insteadf of fake values you could try

.mod

int temp[1..105]=...;
float nb_section_faculty_course[c in course][f in faculties]=temp[f];

and in .dat

temp from SheetRead (my_sheet,"nb_section_faculty_course");

At least this show how to get the values out of the named range.

regards

Originally posted by: wj1

i ahve done this alex and it worked :

forall (s in Course_To_Faculties) 
  sum(t in Course_To_Section: s.i == t.i)z[s.f][t.j] == s.groupsize;

someone helped write the last command about exporting the decision variable x but i tried to export y ,z and aplha and got many errors ...could u help with the command that will export y,z and alpha ? thannk youuuu !!

Hi

you should use SheetWrite

You may find an example in CPLEX_Studio129\opl\examples\opl\oil

regards

Originally posted by: wj1

Hey alex , i did that but i got the error in the screenshot attached ... any help ? thank you and god bless you!

Hi

see https://www.ibm.com/developerworks/community/forums/html/topic?id=ed2adb39-2271-4d7e-bd07-b5ed0d3d0e6f

regards

Originally posted by: wj1

im sorry alex for botherring , wras i told u , im a begiiner in opl ... i found what u wrote not much understandable for me...could you help with one exmple? for instance , i want to export y(s,j) : s in student and j in section ...thaank youuuuu

Hi,

if you adapt the example I shared, you will write

execute
    {

    // http://cwestblog.com/2013/09/05/javascript-snippet-convert-number-to-column-name/
    function toColumnName(num) {
      for (var ret = '', a = 1, b = 26; (num -= a) >= 0; a = b, b *= 26) {
        ret = String.fromCharCode(parseInt((num % b) / a) + 65) + ret;
      }
      return ret;
    }

    // 1,1 => A1  1,4 => D1 2,27 => AA2
    function convertR1C1toA1(r,c)
    {
    return(toColumnName(c)+r);
    }

    }
    
string sheeetWriteString;

execute
{
sheeetWriteString="test!A1:"+convertR1C1toA1(student.size,section.size);  
}  

and that will write y in the tab "test"

At some point do not hesitate to follow some training : https://www.linkedin.com/pulse/low-barrier-entry-optimization-through-cplex-alex-fleischer/

regards