+ Reply to Thread
Results 1 to 2 of 2

Creating a Macro That will Run Solver Multiple Times

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Creating a Macro That will Run Solver Multiple Times

    Hello,
    I am using solver to get the smallest SSE in an intricate model (it involves varying three variables). Unfortunately, it seems that sometimes running the solver more than once yields different results with varying accuracy. Can someone help me develop a macro that would have a constrain of running solver for a predetermined number of runs to arrive to an optimum answer (the minimum SSE). Note, I will be copying the worksheet multiple times, so it would be great if the macro runs in the sheet it’s executed in.
    In advance I really appreciate the help,

  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: Creating a Macro That will Run Solver Multiple Times

    Unfortunately, it seems that sometimes running the solver more than once yields different results with varying accuracy
    Not having seen your model it is a bit difficult to suggest some useful hints but have you tested running the "Evolutionary" model and under "Options" -> "Evolutionary" tab changed the value in the tick box marked "Maximum Time without improvement" from 30 seconds to say 60 or a 100?

    Rerunning Solver using GRG or Simplex it's normally better to change "constrain_precision" or "convergences". You can also add the result of the target cell to be a constraint i.e. less than given value.

    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. Creating a Macro, finding channel times
    By Gamerxx13 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-11-2013, 01:12 PM
  2. Run Solver Multiple Times (while changing constraints and goal for each iteration)
    By pmw1218 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 04:17 PM
  3. Creating a basic loop to solve an equation multiple times
    By MechEng84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2009, 09:26 PM
  4. Using Solver Multiple Times In One Sheet
    By g1362901 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2009, 09:02 AM
  5. [SOLVED] Using Excel Solver multiple times with macros
    By Barry T in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2005, 04:06 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