Skip to main content

Multi-scenario model Excel output

Answered

Comments

2 comments

  • Jonasz Staszek
    Community Moderator Community Moderator
    Thought Leader
    Gurobi-versary
    First Question

    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
    Collaborator
    Curious

    Hi Jonasz:

    Thanks for your in-time help!!

     

    0

Please sign in to leave a comment.