+ Reply to Thread
Results 1 to 33 of 33

Macro with Solver loop

Hybrid View

lichtensteinryan Macro with Solver loop 12-15-2016, 09:27 PM
lichtensteinryan Re: Macro with Solver loop 12-15-2016, 10:31 PM
Alf Re: Macro with Solver loop 12-16-2016, 04:01 AM
lichtensteinryan Re: Macro with Solver loop 12-16-2016, 08:51 AM
Alf Re: Macro with Solver loop 12-16-2016, 09:11 AM
lichtensteinryan Re: Macro with Solver loop 12-20-2016, 02:39 PM
MrShorty Re: Macro with Solver loop 12-20-2016, 02:51 PM
lichtensteinryan Re: Macro with Solver loop 12-20-2016, 03:35 PM
lichtensteinryan Re: Macro with Solver loop 12-20-2016, 03:16 PM
MrShorty Re: Macro with Solver loop 12-20-2016, 03:28 PM
lichtensteinryan Re: Macro with Solver loop 12-20-2016, 03:47 PM
MrShorty Re: Macro with Solver loop 12-20-2016, 05:17 PM
lichtensteinryan Re: Macro with Solver loop 12-20-2016, 06:43 PM
MrShorty Re: Macro with Solver loop 12-21-2016, 12:35 AM
lichtensteinryan Re: Macro with Solver loop 12-21-2016, 02:12 PM
MrShorty Re: Macro with Solver loop 12-21-2016, 03:12 PM
MrShorty Re: Macro with Solver loop 12-21-2016, 04:02 PM
Alf Re: Macro with Solver loop 12-21-2016, 05:45 PM
lichtensteinryan Re: Macro with Solver loop 12-22-2016, 02:50 PM
Alf Re: Macro with Solver loop 12-23-2016, 02:35 AM
benlandgren Re: Macro with Solver loop 12-07-2017, 01:59 PM
Alf Re: Macro with Solver loop 12-07-2017, 05:09 PM
benlandgren Re: Macro with Solver loop 12-07-2017, 05:34 PM
benlandgren Re: Macro with Solver loop 12-07-2017, 06:29 PM
Alf Re: Macro with Solver loop 12-07-2017, 06:17 PM
benlandgren Re: Macro with Solver loop 12-07-2017, 06:40 PM
Alf Re: Macro with Solver loop 12-07-2017, 07:15 PM
benlandgren Re: Macro with Solver loop 12-08-2017, 08:55 AM
Alf Re: Macro with Solver loop 12-08-2017, 10:31 AM
benlandgren Re: Macro with Solver loop 12-08-2017, 10:55 AM
Alf Re: Macro with Solver loop 12-08-2017, 03:04 PM
benlandgren Re: Macro with Solver loop 12-10-2017, 11:23 AM
Alf Re: Macro with Solver loop 12-10-2017, 03:24 PM
  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,387

    Re: Macro with Solver loop

    Without more information, I will probably have to take your word for it that this cannot be solved algebraically. If AI2 is independent of AJ2, though, it really looks to me like the algebra should work out for a closed form solution of the equation/inequality. I think if I were solving this problem, I would pursue solving the above equation/inequality for AJ2. From that, I would learn how this function behaves and have a better idea how to solve it. If it ends up requiring a numeric Solver solution, I would expect to end up with an expression for AJ2 as a function of AP2. Then call Solver and tell it to set AJ2 to a minimum by changing AP2 subject to the constraint that AP2>=5 and any other constraints needed when the problem is rearranged in that way.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Registered User
    Join Date
    12-15-2016
    Location
    Seattle, WA
    MS-Off Ver
    Microsof Office Pro Plus 2013
    Posts
    10

    Re: Macro with Solver loop

    I've ran solver manually on the first 20 cells and it is giving me the answer I need. I just need to be able to create a loop to do this calculation on every cell.

+ 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. Solver - macro loop - want it faster
    By fidocze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2016, 11:42 AM
  2. VBA Macro for Solver Loop
    By vizbasic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2016, 09:13 AM
  3. [SOLVED] Solver Loop Macro Question
    By ngiesbrecht in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2015, 05:25 PM
  4. Macro Loop for Solver
    By kchm_2000 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-28-2010, 09:42 AM
  5. Macro Loop for Solver
    By kchm_2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2010, 12:26 PM
  6. Macro to loop solver
    By NMason in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2010, 03:19 PM
  7. Solver macro with Loop
    By golfclubs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2010, 10:35 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