+ Reply to Thread
Results 1 to 2 of 2

Sensitivity Report not showing in Solver

  1. #1
    Registered User
    Join Date
    08-11-2016
    Location
    Singapore
    MS-Off Ver
    MS2013
    Posts
    1

    Sensitivity Report not showing in Solver

    Hello all,

    I am trying to generate a sensitivity analysis based on a max cost of 10 but the sensitivity report is not showing after I run the solver. The sensitivity report would be needed to test the variables when I change the max cost.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Sensitivity Report not showing in Solver

    Perhaps this could be the problem?

    If Solver finds a (locally or globally) optimal solution, and there are no integer constraints, two additional reports are available: the Sensitivity Report and the Limits Report.
    As far as I know a binary constraint will have the same effect as the integer constraint i.e. no "Sensitivity or Limits Report"

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sensitivity Analysis Option Not Showing
    By treyweeks11 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-03-2014, 04:04 PM
  2. solver sensitivity analysis report
    By mmcsgoncalves in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2014, 03:15 PM
  3. How to create a Sensitivity Report
    By jackpot25 in forum Excel General
    Replies: 2
    Last Post: 10-10-2012, 07:35 PM
  4. solver and sensitivity report
    By megtoma in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2009, 08:42 AM
  5. Question related to Sensitivity Report (Solver)
    By hakimov in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2008, 02:29 PM
  6. Solver - Different Sensitivity Reports
    By Valentina_Lapp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2007, 06:58 AM
  7. Replies: 0
    Last Post: 03-29-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1