Hello guys! I wanted to ask if somebody of you is able to solve this optimization problem: I am completely stuck and would really appreciate your help. I can’t upload the corresponding Excel but a general code would already help. Thank you!
Use the excel input file input−data.xlsx from the website as input to your model– all necessary values are there. Read the data directly from the excel file. Also read in the set elements from the excel file. Observe: there is a sheet called ”inflows-assignment”, use this sheet for reading inflows.
Prices are in €/MWh. Inflows are in MW. max stor, min flow, max gen are in MW.
Write the model in a way that it can be extended to multiple reservoirs and hydropower plants by only changing data, but not equations.
Hint 1: On a Non-Windows Machine, manually copy over the data
Hint 2: the minimum flow in the lower reservoir(s) cannot be guaranteed in the first hour(s) (as no water has reached the reservoir yet). Therefore, use a $-condition to not generate the respective equation(s) in the first hour(s). Otherwise, the problem becomes infeasible.
Hint 3: the data carries now the index r with elements set r /upper, lower/;. This allows to extend the model simply by extending the set and the corresponding data.
The rounded optimal objective value is: 72 662