Multi-scenario model Excel output

Answered

Jingyue Zhang

• April 30, 2022 03:55

Hi，

I've noticed that Gurobi provides multi-scenario models and can solve them simultaneously.

However, I met a problem when programming. If I'd like to write results for different scenarios into Excel sheets, how should I operate?

 

0

• 

  Jonasz Staszek

  Community Moderator

  • May 02, 2022 07:51

  

  

  

  Hi Jingyue,

  this article should shed some light. Writing a solution to an Excel sheet can be done for example by iterating over variables of the model and retrieving their value in each scenario, and then storing them in separate dicts per scenario. Then, you can write the dicts to csv files. Python has a great built-in module for this.

  Hope this helps.

  Best regards
  Jonasz

  0
• 

  Jingyue Zhang

  • May 06, 2022 13:06

  

  

  Hi Jonasz：

  Thanks for your in-time help！！

   

  0

Please sign in to leave a comment.