Solver Workaround for Apple iWork Numbers

September 28th, 2007 | by Michael |

Solver Workaraound iWork Numbers

Forum member and Numbers guru, JaxJason, has posted a workaround for the lack of Solver support in Numbers. Jason can explain it better than I can, so here is his quote from the forum:

This one is a solver workaround that uses a second table with about 1000 rows to perform a series of iterations. using the difference between the goal your looking for and the results of the last solution from the line above.

I will leave it for you to work and play with instead of giving a full rundown here. I basically just played with the iteration formulas till I found a nice medium that gave me nice results within 1000 rows.

You can change the yellow boxes. It is shooting to set the final principal amount in the second column, to get the payment in that column to the amount you asked for in the yellow payment box.

Hope this helps some people understand how Numbers works. I just liked that I got it to work.

Jason

Great work Jason!

Note: I am disabling comments on this post since any questions or suggestions should be directed to the Solver workaround thread.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.