Adding Constraints to variables in Excel sheet

回答済み

Aadav Srimushnam Sundaranathan

2022年04月06日 20:15 編集済み

• 
• 
• 

I am attempting to load data from excel sheet for maximizing profits in supply planning. I have sheets for Demand, Supply, Price and Cost, where I am looking to add capacity constraint of 400 to my variables in Supply sheet with i rows and j columns. 

#adding constraints

m.add_constr(Supply[i][j].value <= 400 for i in range(dem_r) for j in range(dem_c))

where dem_r and dem_c are the size of rows and columns in the sheet.

Unfortunately, it shows syntax error. Can you guide on how to add constraints for variables with i rows and j columns?

0

• 

  Jaromił Najman

  • Gurobi Staff

  2022年04月06日 07:10

  What is your question?

  Are you asking how to read Excel Sheet data? If yes, then you can use pandas for this, see How to Import an Excel File into Pyhton using Pandas?

  0
• 

  Aadav Srimushnam Sundaranathan

  2022年04月07日 16:36

  • 
  • 
  • 

  No. As I look to add constraints to variables in a table (with i rows and j columns), I am getting an error for the following syntax: 

  m.add_constr(Supply[i][j].value <= 400 for i in range(dem_r) for j in range(dem_c))

  Can you please suggest the right method to add constraints to variables in a table.

   

  0
• 

  Jaromił Najman

  • Gurobi Staff

  2022年04月08日 14:33 編集済み

  It is hard to help here, because you did neither provide a reproducible example nor the error message you get.

  My guess would be that you are using a wrong method. Instead of \(\texttt{add_constr}\), you should probably use the addConstrs method.

  0

サインインしてコメントを残してください。