Originally posted by: Shawn1

I need to write the value of variable "itvs" in attached scheduling problem in an excel sheet. Is there any way to do this?

itvs contains starting time, finishing time and duration for preforming each job on each machine. 

Thanks in advance for your support.

Hi,

have you tried anything like adding

tuple it
{
 int m;
 int g;
 int s;
 int e;
}  

{it}  output={<m,g,startOf(itvs[m][g]),endOf(itvs[m][g])> | m in 0..Mchs-1,g in 0..Grades-1};
 

and then doing a SheetWrite with tuple set output ?

Regards

Originally posted by: Shawn1

Thank you Alex for your prompt reply.  It works!

Originally posted by: Shawn1

Alex

Can I write the values for 'mchs'  variable in Excel too? What I need to export is the order of jobs run on each machine. I could not figure out how to export it.