Originally posted by: bilbeisi9

Hello,

I'm working on a production scheduling project for a company called "Dairy Foods". I seem to have only a couple of errors left, all concerning the link to the Microsoft Excel sheet. I keep getting the same error over and over again: Exception from IBM ILOG Concert: Excel range is unknown.  Im going to attach the excel worksheet and the CPLEXcode on a word document.  I also know that there are some spelling mistakes but I matched/was consistent in those mistakes, so I doubt they are the cause of the errors.I am in desperate need of help for my project is due in two days. Someone help, thanks!

Hi,

there seems to be a space in the name "Budget" and if you type it again in excel your error will go away.

I attached the correct excel file.

regards

Originally posted by: bilbeisi9

Thanks for the reply, but I really doubt that is the problem. Did you try running it on your cplex?

Hi,

yes I tried and at least this is a fix for

Exception from IBM ILOG Concert: Excel range is unknown.

There are many other issues that you should fix.

Regards

Originally posted by: bilbeisi9

Thank you, I fixed the excel sheet problems but now we have other existing errors, im very sure its a very stupid mistake somewhere in the code. If you have some time can you possibly explain the other existing errors? IS it a problem with the linearization or other?

Hi,

there are many issues.

For example, in the .mod you have

int d[F][N][O]=...;

and then in the .dat

dData from SheetRead(sheet,"Demand!A5:D274");

1) in the .dat you should have d

2) d is a 3d array so you cannot read it so easily. You need to go through a 2D array (See https://www.ibm.com/developerworks/community/forums/html/topic?id=bcaea400-c839-4f12-85bc-4750c48d68f3&ps=25 )

You should try to fix all your errors one by one

Regards