+ Reply to Thread
Results 1 to 3 of 3

Solver Variables, only change if it still needs solving?

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    Taco, Texas
    MS-Off Ver
    2013
    Posts
    2

    Solver Variables, only change if it still needs solving?

    Helping a buddy out with my limited knowledge of solver.

    I have a model that works, but some of the variable cells my buddy would like a formula to figure out before solver runs.

    So is there a way to tell solver to skip a variable cell if there is a "1" in the cell next to it or something like that? It is difficult to explain. Basically we need solver to solve a problem that is partially solved, and out of the 20 variable cells solver may only need to do 8 or 15 or 3 or all of them... depending on if the formula has already figured that variable out.

    Please ask me to describe the problem more if my question doesn't make sense.

    I really appreciate any help, thanks!

    -R

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

    Re: Solver Variables, only change if it still needs solving?

    it will depend on the details, and there could be multiple ways to do this. I am not aware of some kind of simple "toggle" in Solver that will do this, so it will take some more detailed work.

    I could not tell if your question was "if a given 'by changing' cell's contribution to the solution is already known, don't include this cell in the by changing cell". If this is what you mean, I would probably be inclined to handle this in the spreadsheet. Have two ranges for the decision variables. In one range, calculate the desired variable(s) with an adjacent toggle value(s). Another range for the Solver "By changing cells". Have a third range for the main inputs to the Solver model that is populated by a simple IF() function. IF(toggle is true,value from calculated decision variable range,value from solver by changing cell range).

    We will probably need more detail and maybe even a good example spreadsheet in order to really provide some good suggestions.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-23-2017
    Location
    Taco, Texas
    MS-Off Ver
    2013
    Posts
    2

    Re: Solver Variables, only change if it still needs solving?

    MrShorty,

    Thanks so much, that does make sense... after posting I kind of was thinking something like you suggested, with ranges and 'if's.

    Thanks again!

+ 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. Replies: 4
    Last Post: 01-01-2017, 07:38 PM
  2. Change solver variables in vba
    By blimes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2016, 01:44 PM
  3. Solver is not solving
    By Nata27 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-18-2014, 03:17 AM
  4. Is Solver capable of solving my problem?
    By devpatel85 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 01-26-2014, 11:06 PM
  5. Solving equation using the Solver Function of Excel
    By ltomilas in forum Excel General
    Replies: 2
    Last Post: 08-29-2013, 04:13 PM
  6. [SOLVED] Solving Engineering problem using Solver
    By mukund23534 in forum Excel General
    Replies: 5
    Last Post: 12-17-2012, 03:31 PM
  7. Solving a problem within VBA without using solver
    By xodus8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2011, 03:53 PM

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