+ Reply to Thread
Results 1 to 12 of 12

Sensitivity and solution space

  1. #1
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Sensitivity and solution space

    i have a coursework on linear programming , decision optimisation. I have maximised my objective using solver .I even have a limit,answer and a sensitivity report but i cant interpret them.How to make conclusions from them .Next my problem is that i have to do sensitivity and solution space .Can you give me any links/tutorial/site explaining me hoe to do all of these(sensitivity,solution space) .Or can you explain yourself.I will be very greatful to you.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Senstivity and solution space

    Hi abha and welcome to the forum,

    My answer to understand new stuff is to read many different authors. Sometimes the book the prof uses makes no sense but some web page is perfect for your brain. Try these three sites:
    First with an example:
    http://people.brunel.ac.uk/~mastjjb/...ns_solver.html
    Second a pdf file that says this is complicated when dealing with the real world
    http://www.econ.ucsd.edu/~jsobel/172aw02/notes7.pdf
    Third a web page
    http://www.quickmba.com/ops/lp/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    thnku so much...;

  4. #4
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    how can i attach my excel file here.Because as you see i have different sensitivity report given by solver compared to links you provided.Can i show you my attachment and cn you help me then with it.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Senstivity and solution space

    It's explained in the forum rules.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    cant find paper-clip button (or scroll down to the Manage Attachments button),

  7. #7
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    please help me .Will be very grateful to you.Please.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Senstivity and solution space

    Press the reply button. The paper clip button is next to the smiley face.

  9. #9
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Post Re: Senstivity and solution space

    here is my file with the sensitivity report.Please explain what reduced gradient ,lagrange multiplier means.And what does binding and not binding means in the answer report status .Lastly can you tell me that you do think that i used solver correctly to maximise my chess ratings.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    Can you atleast reply..!!!

  11. #11
    Registered User
    Join Date
    11-19-2011
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Senstivity and solution space

    "Bump no response"

  12. #12
    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: Senstivity and solution space

    Perhaps this link could be of help?

    http://japr.fass.org/content/18/1/85.full

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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