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

Comments

3 comments

Official comment
Simranjit Kaur

Gurobi Staff

November 16, 2025 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

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

Post is closed for comments.