Forum Discussion

ammesaros's avatar
ammesaros
Copper Contributor
May 13, 2020

Excel Solver - Sensitivity Analysis

Hi friends! I am working on a linear optimization programming problem for school. I need to perform a sensitivity analysis on my models but the option is not coming up where it should under reports. ...
excel
wumolad's avatar
wumolad
Iron Contributor
May 13, 2020

Hi ammesaros 

 

I understand sensitivity report is not available if you have an integer constraint. A sensitivity analysis can be performed only for models with continuous variables.

Try and check Ignore Integer Constraints checkbox under Solver Options and see if it works

 

 
 

 

Cheers

 

  • ammesaros's avatar
    ammesaros
    Copper Contributor
    May 13, 2020

    This did help but unfortunately, it changed the optimal solution. It will be good enough to show our professor though. Thank you so much. wumolad 

    • Adelaide0622's avatar
      Adelaide0622
      Copper Contributor
      Jan 31, 2023

      HI, I have the exact same problem, did you solve it?ammesaros 

    • wumolad's avatar
      wumolad
      Iron Contributor
      May 13, 2020
      You are welcome

      ammesaros

Resources