+ Reply to Thread
Results 1 to 3 of 3

Excel Solver help with target high and target low

  1. #1
    Registered User
    Join Date
    05-12-2010
    Location
    Adrian, MI
    MS-Off Ver
    Excel 2010
    Posts
    76

    Excel Solver help with target high and target low

    I am trying to use solver to optimize my target high and low of two sets of numbers. (basically what should my high be set at and my low to attain the highest accuracy of the high always happening and the low occurring rarely) I am sure I will need to post more data but I am unsure what I will need to post. Please ask and I will get it posted.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Excel Solver help with target high and target low

    I find that the beginning of almost any Solver model (or other optimization algorithm) begins with my objective function (the function that will be maximized/minimized/solved for a value) and my decision variables (what will be changed). Your brief descriptions talks about highs and lows and accuracy and probability. I would suggest that you first need to figure out how all that comes together to build an objective function based on decision variables with all of the functions in between needed to connect the decision variables to the objective function.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    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: Excel Solver help with target high and target low

    To optimize to set of values. Maximize A and minimize B I would try defining my object function as C = A/B and set solver to maximize C.

    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. Self Ajusting cell , moving to provide target to meet end of year target
    By andycuk7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2016, 11:22 AM
  2. [SOLVED] Excel 2013 already have Target GM % , wanst to add Target Sales Price
    By Bitto in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2015, 10:25 AM
  3. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. [SOLVED] Need alternate syntax 'Select Case' on Target.Column and Target.Row at the same time.
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 11:19 AM
  6. Solver constraints shall be OR // Solver target cell
    By Cunner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2009, 04:28 AM
  7. [SOLVED] Several target cells in the solver
    By omathilde in forum Excel General
    Replies: 3
    Last Post: 01-27-2006, 08:45 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