How To Use Solver In Excel For Mac

Want to get more from the Excel Solver? Try Analytic Solver Basic for $250/year you get an easy to use guided mode, over 200 examples you can easily. Best games for mac.

Is there a way to record a macro that • copy data from a 'data' sheet to a 'calculator' sheet • activate the 'SOLVER' function • goes to a 'result' sheet • copy result and paste into 'data' sheet • then loops I tried recording these but the problem I faced was that the macro didn't give SOLVER enough time to finish the iterations needed to get a solution. One very slow way I could think of was to get macro to do everything from step 3 to step 5 and then step 1 and ends, then I manually start the solver and wait for the iterations to complete. Anyone can help me? Sorry I'm super newbie here. There is a bug in the solver for Mac Excel2011. Vba must stop running before solver can start. This means that loops like that you show will not work.

The only work around I can find is to create two solver functions: The first initiates the loop and makes the calls to solver. It then initiates a call to an application wait to invoke the second function after a time delay which must be long enough for Solver to do its task. It then exits The second function captures the results from solver, manages the loop advance and again starts solver. It too invokes the same delay and exits.

If the second function finds the loop is complete it just exits without calling Solver. This approach works but is very slow. In my example the PC loop like your example above took just over 1 minute for 180 iterations of a 10 parameter solver system with 60 data points to evaluate.

On the Mac I had to allow a 10second delay to ensure completion. Result Mac 30 minutes Not good but workable.