Just because I have changed the way I read the input data, now model equations give me errors. How can I resolve this?
More context here:
I have successfully run optimization model when I was reading the csv files with readdlm command. Given that I have so many input files (csv files) I wanted to use xlsx, and I have put all these csv files in tabs of excel.
Now I am using
Offices= readxlsheet(DataFrame, “Locations_v2.xlsx”, “Offices”)
which has the cost information in column 11 of tab “Offices”:
Cost = Offices[1:size(Offices),11]
However, now I get a lot of error with equations in the model:
My cost data is below:
What am I doing wrong?
Could you help me with my syntax here?
I don’t want to have multiple csv files. I will need excel formulations for my input data and csv does not store formulations. Thus, I need to keep my input data in excel xlsx format. How do you guys typically read data from excel files?
Could you help with the problem above?