Multi-scenario model Excel output

回答済み

Jingyue Zhang

2022年04月30日 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

• 正式なコメント

  

  Simranjit Kaur

  • Gurobi Staff

  2025年11月16日 23:38

  This post is more than three years old. Some information may not be up to date. For current information, please check the Gurobi Documentation or Knowledge Base. If you need more help, please create a new post in the community forum, or try Gurobot, our chatbot interface offering instant, expert-level support.
• 

  Jonasz Staszek

  • Community Moderator

  2022年05月02日 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

  2022年05月06日 13:06

  • 
  • 
  • 

  Hi Jonasz：

  Thanks for your in-time help！！

   

  0

投稿コメントは受け付けていません。